[Coming Soon] Sales : Sales Overview|Shoplytics

6.All_EN_Shoplytics-Pro.pngThe Sales Overview report shows your store's order sales for a selected timeframe. The data is updated every hour, and you can reopen or refresh the report to get latest data.

 

A Sales Overview Report contains the following eight metrics:

 

Select the time frame you want to analyze

In SHOPLINE Admin, go to [Reports & Analytics] > [Shoplytics] > [Sales] > [Sales Overview]. Click on the date range in the top right-hand corner and select the range you want to analyze/have reports for. 

mceclip0.png

After choosing the date range, click [Apply].

mceclip1.png

 

1. Gross Merchandise Value 

The value of all the [Created Orders] placed by customers during the selected time period, including Paid and Unpaid Orders.   

Example: Cash on Delivery, Preorder Value, Return Order Value, Canceled Order 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. 

 

Omni-Channel 

mceclip2.png

Online Store/Retail Store

mceclip0.png

 

2. Canceled Value

The total value of Canceled Orders for the selected timeframe. Canceled 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.

 

Omni-Channel 

mceclip2.png

 

Online Store/Retail store
mceclip3.png

 

3. Preorder (Paid Off)

Preorder (Paid Off) is the outstanding balance on an order that is paid when a shopper completes a transaction when picking up a preordered item in a 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.  

 

Omni-Channel

mceclip4.png

 

Online and Retail Store

mceclip5.png

 

4. Preorder (Outstanding)

Preorder (Outstanding) is the amount for a preorder item that a customer has not yet paid. 

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 canceled on Dec 15th, then the $600 Preorder (Outstanding) would be deducted on Dec 15th.

 

Omni-Channel

mceclip7.png

 

Online and Retail Store

mceclip6.png

 

5. Total Sales

Total sales amount, excluding returns from retail and canceled orders from all channels.

Omni-Channel 

mceclip8.png

 

Online and Retail Store

For online store: Total Sales = Gross Merchandise Value – Canceled Value + Total Edited Value 

For Retail Store, Total Sales = Gross Merchandise Value – (Canceled Value + Preorder(Paid Off) - Preorder (Outstanding))

This metric shows the amount of money coming into a retail store through sales.

mceclip9.png

 

6. Cost of Sales

Product costs generated at the time when the order is created, for a selected timeframe.

Note: Cost is reported only for products, variants, add-ons and gifts that had a cost recorded for them at the time they were sold. To get a cost value from your cost reports, you need to add a cost value to a product in Shopline Admin.

  • Product without variation
    1. In Shopline Admin, go to [Products & Categories]
    2. Select the product you want to edit.
    3. In the [Quantity & Pricing] tab, enter a value into the [Cost] field.
    4. Click [Update] to save the changes.

mceclip17.png

  • Product with variations
    1. In Shopline Admin, go to [Products & Categories]
    2. Select the product you want to edit.
    3. In the [Variations] tab, enter a value into the [Cost] field.
    4. Click [Update] to save the changes.

mceclip0.png

 

  • Add-ons
    1. In Shopline Admin, go to [Products & Categories] > [Add-ons]
    2. Select the product you want to edit.
    3. In the [Add-on Item info] tab, enter a value into the [Cost of Add-on Item (Optional)] field.
    4. Click [Update] to save the changes.

mceclip20.png

  • Free Gifts
    1. In Shopline Admin, go to [Products & Categories] > [Free Gifts]
    2. Select the product you want to edit.
    3. Enter a value into the [Cost of Free Gift (Optional)] field.
    4. Click [Update] to save the changes.

mceclip21.png

 

Omni-Channel

mceclip10.png

Online and Retail Store

mceclip11.png

 

7. Gross Profit

Gross Profit = Total Sales – Cost of Sales

 

Omni-Channel

mceclip12.png

Online and Retail Store

mceclip13.png

 

8. Gross Profit Margin

Gross Profit Margin = Gross Profit / Total Sales * 100  or  (Total Sales – Cost of Sales) / Total Sales * 100

For example, if your Total Sales is $100 and your Cost of Sales is $40, then the Gross Profit Margin (calculated as ([100 - 40] / 100) * 100) is 60%.

 

Omni-Channel 

mceclip15.png

Online and Retail Store

mceclip16.png

 

 

 

 

 

Have more questions? Submit a request

Comments