What are your best sellers? Which products are not performing well? Whether you are observing your daily selling figures or evaluating your product portfolio each quarter, you can keep track of your product sales through the Shoplytics Product Sales Analysis and adjust your product portfolio accordingly to boost revenue.
*Note: The metrics below include general products, product sets, and add-ons. The product sets are counted in sets, e.g., Product Set A has 3 child products, and the "Total Product Sold" of Product Set A is counted as 1.
This article will cover the following:
- Product Performance: Product Analysis
- Product Performance: Category Analysis
- Product Performance: Supplier Analysis
- Export reports
- Product sales trend line graphs
- FAQs
1. Product Performance: Product Analysis
In the SHOPLINE Admin, go to [Report & Analytics] > [Shoplytics] > [Products] > [Product Sales Analysis]. Click the drop-down menu and select Product Analysis to view the overall product sales.
The system will sort the products according to sales volume; the popular products will be at the front. To look up the performance of a specific product, enter the Product Name / SKU / Barcode into the search bar.
*Note: Search product sets by the product name and barcode; search add-ons by the product name and SKU.
i. Omni-Channel
*Remark: In the "Omni-Channel" tab, the unit selling price and unit product cost are not displayed.
ii. Online Store
*Remark: In the "Online Store" tab, the unit price shows the Sale Price or Regular Price (remaining original variations).
iii. Retail Store
*Remark: The display order of Retail Store's Unit Price is as follows: Retail Store Price > Sale Price > Regular Price
In the "Retail Store" tab, Unit Price currently does not support displaying Store-specific Price of different stores. If the retail store price is set, the unit price gives priority to the retail store price. The special or original price will be displayed if there is no retail store price.
iv. Display Product Variants
Check the "Show Variant" box to show sales figures at the variant level. If one of the variants has no sales figure, it will not show.
If the "Show Variant" option is selected, and "deleted variants" appear in the variant column, it indicates that within the selected period, those variants were sold but have since been deleted.
*Remark: Product sets currently do not show product variants.
v. Filter conditions: Supplier, Category
In the "Omni Channel" tab, click the "Supplier" drop-down menu to filter for which product you want to view performance for.
In the "Online Store" and "Retail Store" tabs, you can filter through "Supplier" and "Category" to look up product performance. The "Category" filter allows you to filter from the main category to subcategories and third-layer category. After selecting the categories, click Confirm.
*Notes:
- The Supplier column with filter conditions is only available to merchants using the Retail POS Plan.
- If you have selected the "Category" and "Supplier" filter conditions, the product sales performance list, the "Category" and "Supplier" columns will automatically display. After removing the filter conditions, the columns will disappear altogether if you do not check the "Category" or "Supplier" columns.
- If you select multiple filter conditions in "Category" or "Supplier," the product that meets one of the filters will be displayed in the list of product sales performance. If you select filter conditions from both "Category" and "Supplier," products must fully meet these two conditions to be displayed in the list of product sales performance. For example, if the filter condition is set to "Category: Food," "Supplier: Flour Supplier, Fruit Supplier," the product must be food, and the supplier must be either a flour supplier or fruit supplier to be displayed in the list.
vi. Data summary
The total and average data will be displayed in the product sales list. If you select the "Category" and "Supplier" filter conditions, the system will only add up and average the product data that meet the filter criteria.
*Note: Product sales performance reports will also display the total/ average fields.
The following provides detailed explanations of each metrics' definition:
| Metrics | Descriptions |
| Sold Qty. | The total number of products sold (*Remark 3) |
| Online Sold Qty. | The total number of products sold in the online store (*Remark 3) |
| Offline Sold Qty. | The total number of products sold in the retail store (*Remark 3) |
| Return Qty. | The total number of items returned through return orders from retail stores (Online store return orders [from stores only using New Advanced Return Management] supported). |
| Page Views | The total number of page views of the product page at the storefront |
| Gross Orders | The total number of orders that have the product sold (*Remark 4) |
| Revenue | The total sales of the product in the orders (*Remark 3) |
| Discount Amount | The discount amount that is applied to the product in the order. (*Remark 1) |
| Return Value | The total amount of returned items through return orders from retail stores (Online store return orders [from stores only using New Advanced Return Management] supported). |
| Net Revenue | The actual revenue from the product sale (Formula: Revenue - Discount Amount - Returned Value) (*Remark 1) |
| Total Cost | The product costs generated at the time when the order was created |
| Unit Price | The latest product unit price. (unaffected by the selected period) (*Remark 2 & 5) |
| Unit Cost | The latest product unit cost (unaffected by the selected period) (*Remark 2) |
| Gross Profit | Product gross profit. (Formula: Net Revenue - Total Cost) |
| Gross Profit Margin | Product gross profit margin. (Formula: Gross Profit ÷ Net Revenue) |
*Remark 1: Discounts will be allocated to each product in proportion to its amount. Please refer to Discounts Allocation for more details. Note that the Discount Amount does not include the deduction amount from "Store Credits" and "Member Point Redeem to Cash".
*Remark 2: For products with multiple variants, the system excludes deleted ones and shows the lowest current price and cost price.
*Remark 3: The quantity will be deducted when the order has been canceled.
*Remark 4: Calculated when the order was placed. Further editing, splitting, or deleting will not alter the value.
*Remark 5: Add-on items may have different prices based on various scenarios, such as when added in the shopping cart or alongside a main product. Therefore, their unit price cannot be calculated and will be displayed as "-".
2. Product Performance: Category Analysis
In the "Online Store" and "Retail Store" tabs, apart from the sales performance of products and variants, you may turn to the "Category Analysis" mode to see how the category performed.
*Notes:
- If the product category has been changed, the system will only count the category sales based on the recent product categorization despite the analysis period selected. Products that do not belong to any of the categories will be attributed to the "Uncategorized Products(s)" field.
- Adding "Category" and "Supplier" filter conditions during “Category” mode is currently not supported.
- If you want to search for categories, please search by the main category. Sub-categories or third-layer categories will not be shown in the search result.
- When searching in the search bar, you can search by the name of the main category, subcategory or third-level category.
- Since a product can be categorized into multiple categories, to avoid double counting, the data for the main category will be calculated based on unique products.
- If a product is categorized into a main category but its subcategory isn't checked, its data will be classified as "Others of Main Category." If a product is categorized into a main category and subcategory but its third-level category isn't checked, its data will be classified as "Others of Sub Category."
The following table covers the meaning of each metric:
| Metrics | Descriptions |
| Sold Qty. | The total number of products sold in the category (*Remark 2) |
| Return Qty. | The total number of items returned through return orders from retail stores under that category (Online store return orders [from stores only using New Advanced Return Management] supported). |
| Page Views | Total number of page views of the product pages of the category in the storefront |
| Revenue | Total sales of the products in the category (*Remark 2) |
| Discount Amount | The discount amount that is applied to the product in the category in the order (*Remark 1) |
| Return Value | The total amount of returned items through return orders from retail stores under that category (Online store return orders [from stores only using New Advanced Return Management] supported). |
| Net Revenue | The actual revenue from the product sale of the category (Formula: Revenue - Discount Amount - Returned Value) (*Remark 1) |
| Total Cost | Product costs of the category generated at the time when the order was created |
| Gross Profit | Product gross profit. (Formula: Net Revenue - Total Cost) |
| Gross Profit Margin | Product gross profit margin. (Formula: Gross Profit ÷ Net Revenue) |
*Remark 1: Discounts will be allocated to each product in proportion to its amount. Please refer to Discounts Allocation for details. Note that the Discount Amount does not include the deduction amount from "Store Credits" and "Member Point Redeem to Cash".
*Remark 2: The quantity will be deducted when the order has been canceled.
3. Product Performance: Suppliers Analysis
Click the drop-down menu to view the supplier performance.
Click on the name of the supplier to view the individual sales performance of the specific supplier's products.
On the product performance page of a particular supplier, you can view detailed information such as the sales quantity of each product of the supplier, the number of product views, etc.
*Notes:
- If you remove the supplier information of the product after the customer purchases the product, the product data will be attributed to the "Products without Supplier" field.
- Add-ons and product sets will be attributed to the "Products without a supplier" field.
- Each product can have 0 or 1 supplier.
The following table covers the meaning of each metric:
| Metrics | Descriptions |
| Sold Qty. | Total number of sold products belonging to the supplier (*Remark 1) |
| Page Views | Total number of page views of the product belonging to the supplier in the storefront |
| Net Revenue |
The actual revenue from the product sale attributed to the supplier Formula: Revenue - Discount Amount - Returned Value (*Remark 2) |
| Gross Profit Margin |
Gross profit margin of the supplier's product Formula: Gross Profit ÷ Net Revenue |
*Remark 1: The quantity will be deducted when the order has been canceled.
*Remark 2: The Discount Amount does not include the deduction amount from "Store Credits" and "Member Point Redeem to Cash".
4. Export reports
The data in the "Product Performance" section can be exported as a report. The following are the steps for exporting:
Step 1
Set the range of the report you want to export, and click the Export button to select "Export all reports" or "Export selected reports." Then select the channel and report type.
- Omni-Channel: 3 types of reports are available - Product Performance, Product-Variant Performance, and Supplier Performance.
- Online Store: 4 types of reports are available - Category Performance, Product Performance, Product-Variant Performance, and Supplier Performance.
- Retail Store: 4 types of reports are available - Category Performance, Product Performance, Product-Variant Performance, and Supplier Performance.
Step 2
After clicking Export again, please wait while the system processes. The report will be sent to your email. Click the Download button to view it.
*Note: If you select multiple sales performance report items, the download file format will be a zip file. Each item will be presented as an independent report after unzipping.
Take the "Category Performance" report as an example, the report will display subcategory and third-level category fields.
Export based on filter conditions
You can also export reports based on filter conditions, including category, supplier, and keyword search. Once the filters are selected, click the “download” icon in the Product Sales Performance section, then click Export in the pop-up. The report will be sent to your email.
The "Product Performance" report with applied filter conditions:
Export report for all stores
You can view data across multiple stores within the same report. In the "Retail Store" tab, select "All Stores", and click Export in the top-right corner. Select "Product Performance" or "Product Variant Performance" report type, and then click Export.
In the pop-up window, you can select "Sum up all stores" or "Display by store". After selection, click Export, and the report will be sent to your email.
*Note: The pop-up window is only displayed if the operator has access to two or more stores.
When you select "Sum up all stores," the report is displayed as follows:
When you select "Display by store," the report is displayed as follows:
*Note: The "Gross Profit Margin" metric may differ between the report and the Admin, as the "Display by Store" report calculates an average for each store.
5. Product sales trend line graphs
To view a list of product sales over a given time period, you can also view line graphs of the same data.
i. Select Product/Variants
You can use the "Product"/ "Variant" / "Category" option at the top left to choose which product/ variant/ category to be compared. Up to 4 products/ variants/ categories can be compared at a time.
ii. Select Metrics
The "Sold" data is displayed by default. You can switch to other metrics through the drop-down menu.
Export report
Click the download icon at the top right of the line chart, and the system will export the report based on the selected product/ category/ variant and metrics.
6. FAQs
i. Why can't I find a certain product/ category when I perform a search?
To search for products, please enter the "Product name, SKU, or Barcode." To search for categories, please enter the main category name, subcategory name and third-layer category name. If you cannot find the product or category, it is possible that the product or category has been deleted or the keyword is not found. In this case, try other keywords.
ii. Why is the sum revenue of all categories different from the total revenue on other pages?
If you are running an online store, please be noted that a product may belong to multiple categories according to your settings. To avoid double counting product data, only unique product performance will be calculated. Therefore, adding up the sales numbers of all products may differ from the total revenue on other pages.
Read more
Comments