You can use the Sales Detail report to see information about Gross Merchandise Value (GMV) and total sales that you've made over time. You can also use it to categorize orders by sales metric for a given period of time. Data will be updated every time the Shoplytics page is refreshed.
In this article, you'll find:
- How to view sales detail report
- Metric definitions
- Sales Detail: by time/date
- Sales Detail: by order number
1. View Sales Detail report
In Shopline Admin, go to [Report & Analytics] > [Shoplytics] > [Sales] > [Sales Detail].
2. Metric definitions
The sales detail report provides the following metrics:
| Metrics | Descriptions |
| Gross Merchandise Value | Gross Merchandise Value contains everything that contributes to the total amount paid by the customer, including the retail price of the product, and any delivery fees and discounts. |
| Cancelled Value | Cancelled orders are those that have had their order status changed to "Cancelled" either by a merchant or by a shopper. |
| *Total Edited Value |
The total value of orders that have been edited or split by a merchant, which caused a difference (higher or lower) from the original order amount. *Note: When a customer pays off their preorder in a retail store, an additional payment fee might be incurred which will cause a difference from the original order amount. The amount difference will be listed in Total Edited Value. |
| *Preorder (Paid Off) | The total outstanding amount of preorders that retail store shoppers paid within the selected period. |
| *Preorder (Outstanding) | The total amount of the balance for preorder items that Retail Store shoppers have not yet paid for the selected period. |
| Total Returned Value |
|
| Total Sales |
|
| Cost of Sales |
The cost of items (Products, Add-ons, Free Gifts) is included in the order by the time a sale is made, excluding shipping and other related costs. (*Remark 2) Orders that are partially paid will have their cost value recorded when the full balance is paid off at the retail store. |
| Gross Profit | Gross Profit ＝ Total Sales - Cost of Sales |
| Gross Profit Margin | Gross Profit Margin ＝ Gross Profit / Total Sales *100 or ([ Total Sales - Cost of Sales ] / Total Sales) * 100 |
*Note: Pre-order information can only be viewed in the Omni-Channel or Retail Stores.
*Remark 1: [Coming Soon] In the event of online store order returns, adjustments (calculations) will be made based on the circumstances; The calculation method is as follows:
- Total Returned Value = Total return at the time of returned order creation ± Return adjusted item - Total of cancelled returned orders.
*Remark 2: [Coming Soon] In the event of online store order returns, adjustments will be calculated as per the situation.
- Return order created: Subtract the cost of goods sold when returning the item.
- Return order status is "Cancelled": Add back the cost of goods sold when returning the item.
For a breakdown of how the Sales Detail metrics are calculated, please see below:
- Positive indicators: GMV, Total Edited Value, Preorder (Paid off), Total Sales, and Gross Profit
- Negative indicators: Cancelled Value, Preorder (Outstanding), Total Returned Value, and Cost of Sales.
3. Sales Detail
This report shows the sales that you've made sorted by date. These are displayed in ascending order by default and are updated when the Shoplytics page is refreshed.
Omni-Channel
If you are an O2O merchant, you can review overall sales under the "Omni" tab.
4. Sales Detail: by Order Number
You can toggle on "Show Order Details." (Turned off by default) to view order numbers and see how an order is recognized.
A. Omni-Channel display
B. Online Store display
C. Retail Store display
To find your order, you must search using the full order number. You can search for multiple orders at once (up to a maximum of 400) by separating each full order number with a space.
Read More
Sales: Sales Overview｜Shoplytics
Comments