Shopify Sales by Product Report

What information does the Sales by Product report show

The Sales by Product report (also called Product Performance) is a common report used by store managers and salesmen for sales analysis. This report opens a view on specific product sales.

The report is presented by the manually selected date range. Typically, it is formed as a table with each row corresponding to one product. The columns of the report are used to display various sales statistics on this product.

Depending on the reporting app the store uses, it can be possible to transform the report output form from a data table to a graphic chart.

What questions can the Sales by Product report answer

The Sales by Product report allows tracking all information generated by product sales. It can be used to answer questions such as:

• Get total sales amounts of all products in a store for any time period.
• See how well a specific product is selling.
• Get the best and worst selling products in your store.
• Compare specific product sales with the previous time period.
• For each product, get the number of ordered and refunded items.
• For each product, track coupons and discounts.

The list of answers you can get with the Sales by Product report can be extended by using additional data columns and data filters.

Similar reports to the Sales by Product report

Sales statistics in a store are not limited exclusively to data on product sales. A Shopify store owner may use several other sales reports alongside the product sales report.

Often in conjunction with product sales reports, store managers use such reports as sales:

• by product vendor
• by product variant
• by discount
• by traffic referrer
• by billing location
• by checkout currency
• by channel
• by customer name

Additionally, the store manager can build sales reports by product tag, POS location, and a dozen other similar reports on sales. The exact list of available reports depends on the utilized reporting app.

Key columns of the Sales by Product report

The default configuration of the Sales by Product report in the Advanced Reports app includes such columns as:

• Product Name
• Number of Orders
• Order Items Total Quantity
• Refund Items Total Quantity
• Refund Items Total Amount
• Order Items Total Net Amount
• Order Items Total Discount Allocation
• Ordered Items Total Price

You are totally free to exclude any existing columns from the report or add several additional ones. Simply choose available columns from the list.

Here is how some of the key columns in the default report are calculated:

• Order Items Total Quantity is calculated as the total quantity of products sold after returns are deducted.
• Refund Items Total Amount is the amount of money that has to be refunded for the total quantity of specific products requested for a refund by the customer.
• Ordered Items Total Net Amount is the monetary sum that is calculated as the difference between the sum of the total orders for a product and the refunded amount.
• Ordered Items Total Price is calculated per product as its price multiplied by the ordered quantity.

Here is how some additional key columns are calculated that you may use:

• Shipping orders are obtained per product as the difference between its total shipping price and order adjustments total shipping amount.
• Inventory Planner Replenishment QTY / 21 days. This optional data column is calculated as the product quantity multiplied by 21 minus the available quantity in stock.

Variations of the Sales by Product report and the questions they answer

Using filters and sorting options, you can get answers to a number of specific questions regarding sales. Here are some examples of the report variations.

Extending the Sales by Product report

The Sales by Product report can be extended with data columns default to other reports. Here are some typical uses.