Products: Product Sales Analysis | Shoplytics

6.All_EN_Shoplytics-Pro.png

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.

 

1. Product Performance: Products

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.

If you are using the SHOPLINE online store and POS system, go to [Report & Analytics] > [Shoplytics] > [Products] > [Product Sales Analysis]. In the "Omni-Channel" tab, you can view the overall product sales and individual sales figures in online and retail stores.

*Note: Search product sets by the product name and barcode; search add-ons by the product name and SKU.

A. Omni-Channel

A.png

Remark: In the "Omni-Channel" tab, the unit selling price and unit product cost are not displayed. 

 

B. Online Store

online_store_en.png

Remark: In the "Online Store" tab, the unit price shows the special or original price (remaining original variations).

 

C. Retail Store

retail_store_en.png

Remark: In the "Retail Store" tab, 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.

 

D. 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.

After checking the "Show Variant" box, if deleted variants appear in the Variant column within the selected time period, it means there were product variants that were sold but deleted afterward.

*Remark: Product sets currently do not show product variants.

D.png

 

E. 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.

e.png


In the "Online Store" and "Retail Store" tabs, you can filter through "Supplier" and "Category" to look up product performance.

2.png


*Notes:

  • The Supplier column with filter conditions is only available to merchants using the Retail POS Plan.
  • Multi-selection is supported for "Category" and "Supplier" filter conditions.
  • 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.3.png
  • Exporting product sales performance reports based on filter conditions is currently not supported.
  • If you create multi-level categories in your online shop, only the main category will be displayed in the "Category" filter.
  • 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.

 

F. 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.

4.png


The following table covers the meaning of each metric:

Metric Description
Sold Total number of products sold (*Remark 3)
Sold (Online Store) Total number of products sold in the online store (*Remark 3)
Sold (Retail Store) Total number of products sold in the retail store (*Remark 3)
Returned Quantity Total number of items being returned in retail stores. (Currently does not support online store return orders)
Page Views Total number of page views of the product page at the storefront
Gross Orders Total number of orders that have the product sold (*Remark 4)
Revenue 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)
Returned Value The total value of returned orders made through the retail store. (Currently does not support online store returned orders)
Net Revenue The actual revenue from the product sale
Formula: Revenue - Discount Amount
Total Cost Product costs generated at the time when the order was created
Unit Price The latest product unit price. (unaffected by the selected time period) (*Remark 2)
Unit Cost The latest product unit cost (unaffected by the selected time 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 The Rule of Amortization for details.

*Remark 2: Shows the lowest and current price when multiple variants exist.

*Remark 3: The quantity will be deducted when the order has been cancelled.

*Remark 4: Calculated when the order was placed. Further editing, splitting, or deleting will not alter the value. 


2. Product Performance: Category

In the "Online Store" and "Retail Store" tabs, apart from the sales performance of products and variants, you may turn to the "Category" mode to see how the category performed.

___2021-06-09___7.09.05.png

*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 (In the "Online Store" channel, only the main category will be counted). Products that do not belong to any of the categories will be categorized as "Uncategorized Products(s)."
  • 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. 
  • Adding "Category" and "Supplier" filter conditions during “Category” mode is not currently supported.

The following table covers the meaning of each metric:

Metric Description
Sold Total number of products sold in the category (*Remark 2)
Returned Quantity A total number of items from the category returned at retail stores. (Currently does not support online store return orders)
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)
Returned Value The total value of returned orders in this category is made at the retail store. (Currently does not support online store returned orders)
Net Revenue The actual revenue from the product sale of the category
Formula: Revenue - Discount Amount
Total Cost Product costs of the category generated at the time when the order was created

*Remark 1: Discounts will be allocated to each product in proportion to its amount. Please refer to The Rule of Amortization for details.

*Remark 2: The quantity will be deducted when the order has been cancelled.

3. 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 filtered by product/category/variant and different metrics.

A. Select Product/Variants

You can use the "Product"/ "Variant" option at the top left to choose which product or variant to be compared. Up to 4 products or variants can be compared at a time.

B. Select Metrics 

"Sold" is displayed by default; you can switch to other metrics through the drop-down menu.

sp44.png

 

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 products/ variations and metrics.

exportreport_en.png

 

4. FAQ

i. Why can't I find a certain product/ category when I perform a search?

To search for products, please enter Product name, SKU, or Barcode. To search for categories, please enter the main 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. Therefore, adding up the sales numbers of all products may differ from the total revenue on other pages.

 

iii. Why couldn't I find all the categories in the list?

If you are running an online store and have created a category structure with multiple layers, only the main categories will appear to be more concise.

 

 

 

 

 

Have more questions? Submit a request

Comments