Group Shopify line items by Variant SKU to compare quantity, gross sales, discounts, returns, and net sales for each SKU.
Official answer
Use Variant SKU as the grouping field and aggregate the sales measures you want to compare. This gives each SKU its own row even when multiple SKUs belong to the same product.
Recommended fields include SKU, Product Title, Variant Title, Quantity Sold, Gross Sales, Discounts, Returns, and Net Sales. Add inventory or cost fields only when the report's purpose requires them.
Check for blank or reused SKUs before relying on SKU-level analysis. Duplicate SKU values can merge data that should remain separate.
Follow-up questions
What happens if multiple variants share the same SKU?
SKU grouping can merge those variants into one row. Use Variant ID as an additional identifier when SKU values are duplicated or blank.
Can I combine sales and inventory by SKU?
Yes, provided the SKU or variant identifier matches consistently between the sales and inventory datasets. Keep inventory quantities distinct from sales quantities.