Sales : Sales Overview|Shoplytics

shoplyticspro.png

With Sales Overview, Merchants can view important metrics at a glance related to order amounts and trends. Line graphs plotting this data for a selected time period provide a clear illustration of how a store is performing, and also offer valuable insights for formulating strategy adjustments and when drafting key performance indicators. 

Sales Overview comprises two main sections:

1.  How to read Sales Overview data 

In SHOPLINE Admin, go to [Reports & Analytics] > [Shoplytics]. From the menu on the left-hand side in Shoplytics, go to [Sales] > [Sales Overview].

1.png

 

2. Sales Revenue 

Omni-Channel 

On the Omni-Channel page, Sales Revenue offers two key indicators: GMV (Gross Merchandise Value), and Total Sales.

  • On the left-hand side, merchants can quickly gain an understanding the source and size of contributions to store revenue divided by channel. 
  • The line graph on the right-hand side provides a clear illustration of two critical metrics (GMV, and Total Sales).

Example image below: The difference between the GMV total for 04/13, and Total Sales is relatively large. This indicates that the cancelled orders for that particular day were higher than for other days. As a result, you can go back and review the situation for that day and adjust your operating strategy accordingly. 

Possible causes: The value of cancelled orders for that particular day was large, or the activity types for that time period gave rise to a relatively high rate of cancelled orders. 

 

omnichannelsalesrevenue.png

For a more detailed insight into these metrics, merchants can click on [View Related Report] in the top right-hand corner to view the Payments page.  

 

Online Store 

After entering the Online Store page, merchants will be able to view data and the following key Online Store operating indicators: 

  • Positive indicators: GMV, Preorder (Paid off), Total Sales, Gross Profit
  • Negative indicators: Cancelled Value, Preorder (Outstanding), Cost of Sales 

onlinestoresr.png

Metric definitions: Online Store 

Metric Description 
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 discount.

Cancelled Value

Cancelled orders are those that have had their order status changed to "Cancelled" either by a merchant or by a shopper cancelling an order.

Total Edited Value

The total value of orders that have been edited or split by a merchant that reduces the original order amount.

Total Sales 

 Total Sales= GMV - Cancelled + Total Edited Value

Cost of Sales

The cost of items (Products, Add-ons, Free Gifts) included in an order at the time a sale is made (*i), excluding shipping and other related costs.

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

Please note: Totals and status changes for orders that are altered after they are created (for example: canceled orders, split orders, or changes made to the products included in an order, etc.) will be recorded and included in the calculation for the day that the changes are made. 

*i:  Cost is reported only for products, add-ons and gifts that had a cost recorded for them at the time they were sold. To ensure more accurate data, please set a cost for a product in SHOPLINE Admin before selling. For detailed instructions, please see: Cost of Sales | Product 

 

Retail Store 

After entering the Retail Store page, merchants will be able to view data (*ii) and the following key Retail Store operating indicators: 

  • Positive indicators: GMV, Preorder (Paid off), Total Sales, Gross Profit
  • Negative indicators: Cancelled Value, Preorder (Outstanding), Cost of Sales 

*ii: Retail Store metrics are derived from SHOPLINE POS, and Kiosk data sources. 

retailstoresr.png

Metric definitions: Retail Store

Metric Metric description 

GMV

The value of all the created orders placed by customers during the selected time period, including Paid and Unpaid Orders.   

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

The total value of cancelled orders for the selected timeframe. Cancelled orders are those that have had their order status changed to "Canceled" either by a merchant or by a shopper cancelling an order.  

Note: If an order is returned at a retail store location, the value of the return will count toward the  Canceled Value for the day that the item is returned.

Preorder (Paid Off)

Preorder (Paid Off) is the total amount for the selected time period of the outstanding balance on orders that is paid when a shopper completes a transaction when picking up a preordered item in a Retail Store. 


For example, if a shopper preordered an item on Dec. 10th worth $1,000, paid $400 as a deposit and then paid off the remaining $600 when picking up the item on Dec. 15th, then the remaining balance of $600 would show up as Preorder (Paid Off) for Dec. 15th.  

Preorder (Outstanding)

Preorder (Outstanding) is the total amount of the balance for preorder items that Retail Store customers have not yet paid for the selected time period.

For example, if a shopper preordered an item Dec. 10th worth $1,000 and paid $400 as a deposit, the remaining balance of $600 would show up as Preorder (Outstanding) on Dec. 10th.

Please note, if the preorder in the example was cancelled on Dec 15th, then the $600 Preorder (Outstanding) would be deducted on Dec 15th.

Total Sales 

Total Sales = GMV – (Canceled Value + Preorder(Paid Off) - Preorder (Outstanding))

Cost of Sales

The cost of items (Products, Add-ons, Free Gifts) included in an order at the time a sale is made (*i), excluding shipping and other related costs.

Orders for which are Partially Paid will have their cost value recorded when the full balance is paid off

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

Please note: Totals and status changes for orders that are altered after they are created (for example: canceled orders, split orders, or changes made to the products included in an order, etc.) will be recorded and included in the calculation for the day that the changes are made. 

 

*iii: Cost is reported only for products, add-ons and gifts that had a cost recorded for them at the time they were sold. To ensure more accurate data, please set a cost for a product in SHOPLINE Admin before selling. For detailed instructions, please see: Cost of Sales | Product 

 

 

3. Payments 

The metrics in Payments are calculated according to the total amount and payment status of an order. An order will be included in the calculations for Amount Paid, and Amount Refunded at the time its payment status is changed. 

  • If using a payment option from an integrated third-party payment provider, the payment status will update automatically. 
  • If you are using a non-integrated payment option, you will need to update the order's payment status manually for it to be recorded in Payments. 

For more information on updating the payment status of an order, please see: Order Management Instructions 

Payments three main metrics: Amount Paid, Amount Refunded, and Net Payment 

Metric Definition
Amount Paid 

The total value of orders for which the payment status has been changed to "Paid" for the selected time period. 

Amount Refunded

The total value of orders for which the payment status has been changed to "Refunded" for the selected time period.  *iv *v

Net Payment

Net Payment = Amount Paid - Amount Refunded

*iv: Orders that have the payment status "Refunding" or "Partially Refunded" are not currently included in the totals for Amount Refunded. 

*v: For more information on how payment and refund amounts are recognized, please see: Sales: Payment Methods | Shoplytics 

 

Omni-Channel 

On the Omni-Channel page, merchants can compare the payment and refund trends for different channels: 

  • The data displayed on the left-hand side allows merchants to see at glance the relative importance of different channel to refunded and payment totals. 
  • The line graphs on the right-hand side show payment and refunded trends from different channels, as well as net changes. 

paymentsomnichannel.png

 

Online Store & Retail Store 

On the Online Store and Retail Store pages, only data collected from each respective channel is displayed:  

  • The relationship between refund and payment amounts and net payments is displayed on the left-hand side. 
  • The line graphs on the right-hand side show payment and refunded trends for a particular channel, as well as net changes. 

Generally speaking, Amount Paid will be greater than Amount Refunded for most stores hoping to maintain sustainable operations. If it is discovered that refunded amounts are greater than payments for a given time period, it is recommended that merchants investigate the causes in more detail or review the data again in order to formulate a more appropriate refund policy for their store. 

paymentsretail.png

 

Read more 

Cost of Sales | Product  

 

Have more questions? Submit a request

Comments