Hello, I am trying to identify what products within the last 12 months have had multiple transactions but I can only see total sales by quantity. We sell gaskets and seals so a customer transaction can range from one item to 500. When I view total sales by product, I only see the total amount of sales, not how many transactions there have been for a product. How can I see this information? Thank you for your time.
Topic summary
Seeking a way to report the number of transactions (i.e., distinct orders) per product over the past 12 months, not just total sales quantity or amount. Current Shopify view only shows total sales by product, which doesn’t indicate how many separate transactions included that product.
Context: The store sells gaskets and seals, where a single transaction can range from 1 to 500 units. Quantity alone doesn’t reveal whether a product sells frequently across many orders or in large quantities within few orders.
Goal: Identify products that have had multiple transactions within the last year. The user asks how to access or generate this metric.
Status: No replies or solution provided in the thread; question remains open.