Shopify Sales by Product Report

‍Tracking product performance is essential for a successful Shopify store. The Sales by Product Report (for edited or modified orders) provides a detailed breakdown of each product’s contribution to revenue, helping merchants make informed decisions to improve profitability. It goes beyond raw sales numbers, offering insights into sales trends, vendor performance, and returns, allowing merchants to identify best-sellers, underperformers, and areas for improvement.

This report includes 10 key default fields, tracking gross sales, discounts, returns, and adjustments. However, it’s fully customizable, enabling merchants to add or remove fields and focus on the metrics that matter most to their business.

Sales by Product Report: Breaking Down Your True Revenue

Let’s Talk Numbers

Say you sell 10 units of Product A at $10 each—great, that’s $100 in gross sales. But let’s break it down:

• You ran a $10 discount, bringing it to $90.
• Two customers returned their items? That’s $20 gone, leaving you with $70.
• Factor in a $5 tax, and your final total sales revenue is $75.

What looked like a $100 win is actually a $75 reality. See the difference?

This kind of insight helps you price smarter, adjust discounts wisely, and manage inventory more effectively. When you analyze net revenue instead of just sales volume, you can focus on products that truly drive sales.

The most common fields used in the Sales by Product report are:

Product Title: Name of your product

Product Vendor: Name of the supplier for your product

Product Type: Type of product you are selling; for example, pants, shirts, or shoes

Net Quantity: Number of sold items - Number of returned items

Gross Sales: Equates to product price x quantity (before taxes, shipping, discounts, and returns) for a collection of sales; canceled, pending, and unpaid orders are included. Test and deleted orders are not included

Discount: The discount applied to the line item

Returns: The value of goods returned by a customer

Net Sales: Gross sales minus discounts and returns

Tax: Sum of all Taxes applied to the order

Total Sales: Gross sales - discounts - returns + taxes + duties + shipping charges + fees

Key Insights from the Sales by Product Report

1. Track units sold and total revenue to identify high-performing products and allocate marketing resources effectively.
2. Identify refund patterns and assess discount effectiveness to minimize revenue loss and optimize promotional strategies.
3. Evaluate product-specific tax contributions to manage varying tax rates for better pricing and compliance.
4. Analyze vendor performance by tracking sales for each vendor’s products, enabling better vendor management.
5. Use advanced filters to analyze sales by net quantity, total sales, order contributions, or specific date ranges—helping pinpoint key sales drivers and identify products with no sales.
6. Track year-to-date sales trends or customize the date range to analyze specific data.
7. Automate reports for streamlined analysis. Shopify merchants schedule these reports weekly and use custom logic for automation.

Conclusion

The Sales by Product report provides insights into product performance, including details like associated vendors, units sold, price, returns, and total sales. Advanced features such as custom filtering and automation streamline data analysis.
‍