Overcome the limitations of default Shopify analytics with the Advanced Reports app.
See both the bestselling and worst selling products in your Shopify store regardless of subscription plan.
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.
The Sales by Product report allows tracking all information generated by product sales. It can be used to answer questions such as:
The list of answers you can get with the Sales by Product report can be extended by using additional data columns and data filters.
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:
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.
The default configuration of the Sales by Product report in the Advanced Reports app includes such columns as:
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:
Here is how some additional key columns are calculated that you may use:
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.
You can easily know what products you sell in a certain geographical region. Simply use the location filter when generating a sales by product report.
Navigate to Locations filter to filter out sales by city or province. Use the filter in the Sales section to filter out data by country.
You can also get a live view of your sales geography by utilizing a Live View analytics option default Shopify provides. It shows orders and visitors on a global 3D map in almost real time.
The Sales by product report can display the information on available stock. Simply add the Inventory Planner Qty data column.
Sort the data table by the inventory quantity to see the products with the lowest stock number. In this way, you can quickly track items that may soon need to be replenished. Filter by stock quantity and get the products that fall within a specific range.
The so-called ABC report gives you a different perspective on the inventory by dividing all products into three grades:
From a financial standpoint, it makes more sense to concentrate on A-products to get the most profits. Filter by the Total Gross Profit data column to see what products fall into the A, B, C range for your store.
The Sales by Product report can be extended with data columns default to other reports. Here are some typical uses.
The term “Cost of goods sold (COGS)” stands for the direct cost of making sales. It includes expenses required for making the sale, for example, personnel salary. Use the Orders COGS to get this data column.
The Advanced Reports app offers a specific Inventory Planner report to display the data on the product stock in your shop. You can add its data columns to the Sales by Product report.
Inventory Planner includes such columns as:
Use these columns to track currently available stock quantity, get the sales speed for each product, forecasted quantity left in stock, and the number of products to be replenished in 21 days from the date the report was generated.
The data in the Variant Facts table of your store database keeps track of the dates when the specific product variant was first and last ordered.
Gain full access to the platform with a 7-day free trial.