Track revenue by product

I need revenue by product for the last fiscal quarter to justify restocking and margin talks. Pull transaction-level data so I can see product SKU, quantity, revenue per item, and refunds, then produce a CSV sorted by net revenue descending and a one-page summary that flags the top 10 SKUs that account for 80% of revenue. Confirm data includes tracked discounts and tax handling.

Before I show product revenue to procurement, make it easy to act on: surface total net revenue per SKU at the top, show units sold next to per-unit price, highlight SKUs with frequent refunds or negative net revenue, and note any SKUs with low hit counts that might be sampling errors. Point out gaps where product variants aren't tagged consistently.

I just exported transactions and a handful of SKUs show pageviews but zero revenue; I’m worried those SKUs are mis-tagged or sales came through a different path. The storefront lead is defensive about tagging. I can’t tell whether this is a tagging bug, an excluded payment gateway, or returned orders not reconciled. What is the most likely cause and the next two checks I should run to prove it?

Every month I spend hours reconciling product revenue because SKUs are reported inconsistently, discounts and refunds split across sources, and gift-card sales are misattributed. I need a habit that stops this recurring cleanup. What single process change or checklist will reduce reconciliation time by at least half and who in the team must own each step?