Shopify Sales by All Product Report

The Pareto Principle tells us that just 20% of products generate 80% of profits. In other words, every sale adds to your overall revenue, but not every product contributes equally to it.

You need to identify the products that are hitting the mark in terms of sales volumes and those that are not getting off the ground. This Shopify Report will allow you to fine-tune your product lineup to match customer demand and improve business performance. 

The Sales by Product report by Report Pundit breaks down your sales performance by product. It packs a ton of crucial data like (Product Type, Vendor, Returns, Discounts), and relevant financial data like (Total sales, and gross sales). But doesn’t include shipping as shipping amounts are filtered out, the tax that is displayed in this report doesn't include taxes on shipping.

How the Sales by Product Report Works

The Sales by Product report in Report Pundit helps you identify the right product to sell at the right time and the right price. Consolidating both old and new products under a single, easy-to-understand Product Title field, eliminates the confusion often faced by merchants trying to decipher complex bundle or combo sales data. This clarity allows you to make informed decisions without the hassle of navigating through multiple, ambiguous fields.

 Why Does Your Shopify Store Need This Report? 

This Shopify Sales Report provides critical insights into product performance, highlighting which products are thriving and which are underperforming. With this data, merchants can: 

• Identify products to promote or discontinue.
• Validate product-market fit, ensuring offerings align with customer demand. 
• Maintain optimal stock levels, reducing the risk of stockouts or overstocking.
• Strengthen revenue streams, contributing to financial stability and opportunities for business growth.

Example: On March 10, you sell a product titled "Wireless Earbuds—Black." The next day, you update the product title to "Black Wireless Earbuds," and then make another sale on March 15. When you generate a sales report covering March 10 to March 15, the earbuds appear on two separate lines because the product title was different at each sale.

Note- Sometimes the data in the product fields, such as Product type, Product title, or Product Vendor displays as a dash (—). This occurs if the data didn't exist at the time of the order.

‍Bundle & Combo- Sales Understanding Made Simple 

Bundle sales can be challenging, especially when trying to track how many products are included in a combo. Native reporting tools often complicate this with multiple confusing fields. Report Pundit simplifies this using a single Product Title field that indicates all bundled products, providing straightforward, actionable insights without the guesswork.

It helps businesses handling recurring or high-volume orders, the Sales by Existing Product report offers: 

• A comprehensive view of all orders fulfilled in the last 30 days. 
• Fulfillment status and shipping details, improving order processing efficiency. 
• The ability to track total order value over the last month, helping you monitor revenue trends and adjust sales strategies accordingly. 

With Report Pundit, merchants can easily navigate their sales data, optimize inventory management, and drive strategic growth without the complexity of other reporting tools.

‍

Note:

1. This report doesn’t provide the applied shipping amount for a product’s sale.

2. This report provides data on your currently-listed products, and the products that were deleted and unlisted in the sales by-product report. 

‍
Data Fields in the Sales by Product Report

The standard fields in this report are:

• Product Title: name of the currently listed product
• Vendor: name of the vendor who sold you the product or whose product you’re selling
• Product Type: category of the product. Example: clothing, toys, electronics, etc
• Net Quantity: actual quantity of product sold over a specific period. Calculated as Ordered Quantity - Returned Quantity
• Gross Sales: revenue excluding returns and discounts. Calculated as Number of Units Sold * Product Price
• Discounts: total discount applied on the product over a specified period. Differs from Order Discount, which is applied to the overall order
• Refunds: refunds issued (if any) for products in the order. Includes both full and partial refunds
• Net Sales: actual revenue made for each product over a specific period. Calculated as Gross Sales - Discounts - Refunds‍
• Tax: total taxes applicable per product during a specific sale period. Calculated as a percentage of the product’s Net Sales amount