• Topic 主题 トピック Topic Topic
  • Sign in

Sales Report

You can use the Sales Report feature to view order data for a specific period, a particular product, or a specific country/region. For information about POS, please refer to the Retail Sales Reports.

When you open the sales report, you will immediately see the latest data. It typically takes around 1-2 minutes for the information to load. You can reopen or refresh the report to update data. However, please note that sales data will take 24-48 hours to reflect in the report of Sales by discount.

Notes: Changes in orders (such as refunds or changes in the number of products) have been recorded since January 21, 2022. 

 

In This Article

explanations of terminologies used in sales reports are covered.


 

Sales and Returns

The sales reports track the value of products at the time of sale and return.

A customer creating an order signifies a sale. After an order is created, the report will show the order value included in the sales order.

Returns refer to the scenario where a customer has purchased a product but decides not to keep it and return it to you. This includes editing the order to reduce the number of items, editing the order to delete items, canceling orders, or refunding orders, all of which result in a decrease in order value. It's noteworthy that a return is different from a refund; returns deal with order value, whereas refunds handle actual financial transactions. Only when a customer has paid for an order can you issue a refund for it.

The sales report includes sales and returns of archived orders, canceled orders, imported orders, pending orders, and draft orders converted into orders.

 


 

Negative Sales

In the sales report, sales are shown as a positive value on the day they occur, while refunds, order cancellations, and edits to reduce items are displayed as negative values on that day. Sales are recorded based on the transaction time of each order occurrence. If the returned amount in a day exceeds sales, the total sales for that day will be a negative number. For example, if your store doesn't generate any orders today but a customer refunds an order placed yesterday, you will see a negative sales figure for today.

 


 

Sales and Paid Amount

  • Sales present information specific to orders created, while the paid amount reflects details about payments made by customers. Values shown on each report may differ. For example, if a customer has placed an order but the order has not yet been marked as paid, the sales and paid amount will be different.
  • As reports display data based on a time range, the time range for placing an order may differ from that of the payment. For example, if a customer places an order in May but pays in June, the order appears in the May sales section of the financial report, while the payment is reflected in the June payments section of the financial report.
  • When customers purchase gift cards, the amount they pay for the gift cards is included in the paid amount section of the financial report. Gift card sales are recorded separately in the product sales report as gift card sales rather than regular product sales, which means you can flexibly combine or separate gift card sales in your accounting as required.

 



N/A Product Lines

If a product name in the report is marked N/A, it could be due to one of the following reasons.

  • It's a record of customer payment or refund amount. Since payments or refunds are actions based on orders and cannot be allocated to individual products, SHOPLINE uses N/A virtual product lines to help you record Paid Amount and Refund Amount. If you find N/A products in the report, check if the Product Name option is selected as a header. You can also add Paid Amount or Refund Amount as headers to confirm if the product is a virtual one.
  • You have not filled out complete information for your product profile. Product Name, Product Image, Variants, Variant images, SKU, and other product information are displayed based on your latest product profile. If you find there are entries missing under Product Name in the report, please check if your product catalog profile is complete. It's advisable to fill in complete product information when creating or maintaining product profile, facilitating a quick review of corresponding product information in the report.
  • It's a custom product. When a customer completes an order and you edit the order to add a custom product, the information of this custom product, such as Product Image and Multivariant Specification, will also display as N/A in the product line in the report. Additionally, suppose you have enabled applications that generate custom products for shipping insurance and service fees. In that case, these products will not be recognized in the report and displayed as N/A in the product line.

 


 

Common Metrics

The following table lists definitions for common metrics in a sales report:

Metric Definition
Subtotal Equals Product price × Quantity of items.
Discounted Amount The amount deducted after applying a coupon code entered by the customer or any automatic discounts created by you. For calculation of the discounted amount, it is apportioned based on the proportion of the subtotal of a product to the subtotal of all products.
Commodity Tax

Tax calculated based on the order. For calculation of the commodity tax, it is apportioned based on the proportion of the subtotal of a product to the subtotal of all products.

If you select All prices include tax in the tax settings, the commodity tax is zero as tax is already included in the Subtotal.

Shipping fees Shipping fees calculated based on the order. For calculation of the shipping fees, it is apportioned based on the proportion of the subtotal of a product to the subtotal of all products. If the orders are made from a "Free shipping" promotion, the product's shipping fee will be zero.
Tip Tips calculated based on the order. For calculation of the tips, it is apportioned based on the proportion of the subtotal of a product to the subtotal of all products. If there is no tip on the order, the tip amount for the product will be shown as zero.
Shipping Tax Tax associated with shipping calculated based on the order. Taxes are imposed on shipping fees when products are sold to certain countries/regions. For calculation of the freight tax, it is apportioned based on the proportion of the subtotal of a product to the subtotal of all products.
Points Deduction The amount deducted from the total payment when members use points for payment. For calculation of the points deduction amount, it is apportioned based on the proportion of the subtotal of a product to the subtotal of all products.
Rounding Adjustment Amount In some international markets, stores have the Rounding Rules setting enabled, requiring consideration of rounding standards for order amounts. This metric ensures the accuracy and standardization of numbers.
Duty Duties calculated based on the order. Duties are imposed when they are sold to certain countries/regions. For calculation of the duties, it is apportioned based on the proportion of the subtotal of a product to the subtotal of all products.
Increased Amount Recorded when an order is successfully created or when products are added during order editing, representing the total value of all items positively added in an order.
Returned Amount Recorded when products are reduced, orders are canceled, or products are returned, representing the total value of all items reduced in an order.
Sales

The difference between positive and negative amounts of an order recorded based on the time of order changes. It appears as a positive amount on the day of order placement and a negative amount on the day of order return.

This metric applies to orders from all sales channels, including imported orders.

Sales = Subtotal - Discounted amount + Shipping + Commodity tax + Tip + Shipping tax - Points deduction + Rounding adjustment amount + Duty - Refund amount.

Specifically, when an order undergoes multiple edits after creation (e.g., returns, refunds due to reduced items), resulting in changes in the positive and negative value of the order, Sales = Increased amount - Returned amount.

Total Order Amount Total order amount = Subtotal - Discounted amount + Commodity tax + Shipping fee + Freight tax + Tip + Tariff - Points deduction amount
Net Sales

Net sales is the actual income earned by the store from selling products after deducting refunds, discounts, shipping fees, etc. from the orders.

Net sales = Subtotal - Discount Amount - Points deduction + Rounding Adjustment Amount - Refund Amount

Paid Amount The amount paid by the customer or marked as paid by you, it is recorded based on the time of successful payment.
Refund Amount The actual amount refunded of the order, recorded according to the time of refund success.
Shipping Refund The shipping fee to be refunded within the refund amount. If you continue to refund the shipping fee by editing the order, it is considered a reverse operation on the order, so the Refundable Shipping is recorded at the order level and not allocated to the products. In the sales report, SHOPLINE uses a virtual product with N/A to record it.
Orders The total number of orders created in the store, recorded when the order is successfully created. Canceling orders does not reduce the number of orders.
Average order value Average transaction value = Sales/Orders
Sales quantity

Equal to the number of units sold.

After successfully creating an order and editing the order to add products, the product sales quantity will increase accordingly.

When editing an order to reduce products, canceling an order, refunding, or returning a product, product sales will be deducted.

Units per transaction Units per transaction = Sales quantity/Orders
Distribution Costs Distribution costs = Product cost price × Quantity of items
Gross Profit Gross profit = Net sales - Distribution costs
Gross Margin Gross margin = (Net sales - Distribution costs)/Net sales × 100%
Customers The number of unique customers who have successfully created orders. If a customer creates multiple orders in your store, it is counted as one customer.

 


 

Common Dimensions

The following table lists definitions for common dimensions terms in a sales report:

Dimension Explanation
Order ID The unique identifier of the order.
Order No. The order number, such as SL001.
Order Status The latest status of the order, such as shipped, pending, scheduled, etc.
Canceled The cancellation status of the order, such as canceled or not canceled.
Pay Status The payment status of the order, such as paid or unpaid.
Refund Status The refund status of the order, such as refunded or partially refunded.
Shipment Status The delivery status of the order, such as shipped, scheduled, etc.
Payment Channel The payment channel for the order, such as Paypal. If a customer pays for an order in multiple installments, separate them with commas. For example, Paypal, Oceanpay.
Payment Method Payment for orders is relaxed, such as Paypal. If a customer pays for an order in multiple installments, separate them with commas. For example, Paypal, CreditCard.
Sales Category The sales report is recorded based on the operation flow of the order. To indicate the impact of each order transaction on sales, SHOPLINE records using sales categories. When successfully creating an order, editing an order to add products, or making a payment, the sales category is registered as order. When canceling an order, editing an order to reduce items, or making a refund, the sales category is registered as return.
Sales Type Sales type indicates the product type of this line of product in this order. When the product is a normal product or a gift card product, the sales product type is Product, the refund is registered as Refunds, and the payment line is registered as Payment.
Product name The title of the product. If the product name is changed after customers place orders, the new product name will be displayed in the report. If you haven't inserted any picture of the product, the image in this field will be null.
Product ID The unique identifier of the product.
Product picture The main product image. If the picture is changed after customers place orders, the new picture will be displayed in the report.
Vendor The brand vendor of the product. If the product vendor is modified after the customer places the order, the report displays the latest product manufacturer. If you haven't set a vendor for the product, it will be displayed as N/A.
SPU Standardized product units. If the SPU has been modified since the customer placed the order, the report displays the latest SPU. If you haven't set the SPU for the product, it will be displayed as N/A.
Custom product type The custom product type you entered for your product. If the custom product type has been modified since the customer placed the order, the report will display the latest custom product type. If you haven't set a custom product type for the product, it will be displayed as N/A.
Multivariant specification The unique identifier for variants of products.
Multivariant ID Specifications for variants of products, such as red * L. If the product doesn't have a multivariant specification, this dimension is displayed as N/A.
SKU The identification code for variants of products. If you modify the SKU after a customer places an order, the report displays the updated SKU. If you haven't set an SKU for the variants, this dimension will be displayed as N/A.
Multivariant image The image for variants of products. If you haven't uploaded an image for the product, this dimension will be empty. If you modify the image after a customer places an order, the report displays the updated image.
User ID The customer's unique identifier.
Customer Name Customer's name.
Email address for the order The customer's email address.
Customer Type When creating an order, if the customer is placing an order for the first time, it is identified as a new customer, otherwise, it is a returning customer.
Country/Region The country or region where the order's shipping address is located.
Province/State The province or state where the order's shipping address is located.
City The city where the order shipping address is located.
Post Code The zip code of the order's shipping address.
Commodity Tax Rate The commodity tax rate recorded in the final status of the order. If you haven't set the commodity tax rate, it will be displayed as N/A by default. Data is recorded from December 13, 2023.
Freight Tax Rate The freight tax rate recorded in the final status of the order. If you haven't set the freight tax rate, it will be displayed as N/A by default. Data is recorded from December 13, 2023.
Duty Rate The duty rate recorded in the final status of the order. If you haven't set the duty rate, it will be displayed as N/A by default. Data is recorded from December 13, 2023.
Referrer site The referrer site from the referrer source to your online store for customers who place an order. For example, www.facebook.com
Referrer name The name of the referral source from which customers who placed orders reached your online store, such as Google, Facebook, Instagram, TikTok, etc. For direct sources, if the referral source cannot be determined, the name appears as N/A.
Referrer path The referrer page path from the referrer source to your store for customers who place orders. For example, if the complete URL link of the customer's referrer source is https://r.search.yahoo.com/abc, then the referrer source path is /abc
Referrer source Shows how customers arrive at your store. Possible situations include:
  • Social: Customers click on links on social media to come to your store.
  • Direct: Customers enter your store’s URL into their browser.
  • Search: Customers click on your store from a search engine’s results page.
  • Others: Sources that do not meet any of the above conditions. Traffic recommendation sources are sometimes impossible to determine, so it is common for unknown traffic sources to appear.
Referrer URL Display the URL link where customers arrive at your store. For example, https://r.search.yahoo.com/abc
UTM Content The utm_content parameter, the media type you set to identify the content of the marketing activity.
UTM Medium The utm_medium parameter, the media type you set to identify the marketing activity.
UTM Name The utm_campaign parameter, the name you set for the UTM campaign when you set it up.
UTM Source The utm_source parameter, the source channel specified for the UTM campaign when you set up the campaign.
UTM Term The utm_term parameter, the date range you specify for the UTM campaign when you set up the campaign.
Cashier ID The cashier ID of the products sold. This field only has a value for orders made through the POS sales channel.
Cashier Name The name of a cashier who sold products. This field only has a value for orders made through the POS sales channel.
Salesperson ID The salesperson ID of the products sold. This field only has a value for orders made through the POS sales channel.
Salesperson Name The name of a salesperson who sold products. This field only has a value for orders made through the POS sales channel.
Sales Channel The sales channel of the order. If the order is created in the admin, the sales channel display will be empty.
POS Store Location The POS store location where the products were sold offline. This field only has a value for orders made through the POS sales channel.

 


 

Viewing the Sales Report

 


 

By Date Range

Displays the number of orders and sales received during the time range you selected. You can customize the selected time for comparison of indicators, or select a time unit in Time unit to control the grouping of data. Common dimensions of this report are as follows:

Dimension Explanation
Hour The time when the order was successfully created or when the order was edited. The system will automatically attribute the order to the hour of the transaction. For example, if the customer successfully created an order at 10:30 and 10:59 on January 1, 2023, and these two orders are recorded in the report at 10:00 on January 1, 2023. The following time terms are also processed according to the same logic.
Day The date when the order was successfully created or when the order was edited. For example: January 1, 2023.
Week

The date when the order was successfully created or edited is attributed to the Monday of that week. You can use this dimension to summarize metrics by week.

For example, a customer completed an order on January 1, 2023, and Monday of the week of January 1, 2023 is December 26, 2022. When you summarize the sales order amount or other metrics by the Week dimension, the order data will be attributed to the week of December 26, 2022.

Month

The date when an order was successfully created or edited. You can use this dimension to summarize metrics by month.

For example: January 1, 2023 is recorded as January 2023.

Quarter

The date when an order is successfully created or edited is displayed in the format of the first month of each quarter. You can use this dimension to summarize metrics by quarter.

For example: January 1, 2023 is recorded as January 2023.

Year

The date when an order was successfully created or edited. You can use this dimension to summarize the metrics by year.

For example, January 1, 2023 is recorded as 2023.

An hour of a day

By capturing the hour when an order is successfully created or an order is edited, you can use this dimension to observe the hourly characteristics of the data.

Based on this dimension, you might find that sales peak around 10 AM over a certain period.

A day of a week

By converting the date when an order is successfully created or an order is edited into a week, you can use this dimension to observe the weekly characteristics of the data.

Based on this dimension, you may find that sales on Sundays are significantly higher than other days over a certain period.

A month of a year

By capturing the month when an order is successfully created or an order is edited, you can use this dimension to observe the monthly characteristics of the data.

Based on this dimension, you may find that sales in December are significantly higher than other months over a certain period.

Sales Report_Dimensions_An hour of a date 01.png

Sales Report_Dimensions_An hour of a date 02.png

 

Analyze by Product

Displays product sales sold by the store. Common dimensions of this report are as follows:

Dimension Explanation
Product ID The unique identifier of the product.
Product name The title of the product. If the product name is changed after customers place orders, the new product name will be displayed in the report. If you haven't inserted any picture of the product, the image in this field will be null.
Product picture The main product image. If the picture is changed after customers place orders, the new picture will be displayed in the report.
Vendor The brand vendor of the product. If the product vendor is modified after the customer places the order, the report displays the latest product manufacturer. If you haven't set a vendor for the product, it will be displayed as N/A.
SPU Standardized product units. If the SPU has been modified since the customer placed the order, the report displays the latest SPU. If you haven't set the SPU for the product, it will be displayed as N/A.
Custom product type The custom product type you entered for your product. If the custom product type has been modified since the customer placed the order, the report will display the latest custom product type. If you haven't set a custom product type for the product, it will be displayed as N/A.

 

Analyze by Multivariant

Displays sales of different product variants sold by the store. Common dimensions of this report are as follows:

Dimension Explanation
Multivariant ID The unique identifier for variants of products.
Multivariant specification Specifications for variants of products, such as red * L. If the product doesn't have a multivariant specification, this dimension is displayed as N/A.
SKU The identification code for variants of products. If you modify the SKU after a customer places an order, the report displays the updated SKU. If you haven't set an SKU for the variants, this dimension will be displayed as N/A.
Multivariant image The image for variants of products. If you haven't uploaded an image for the product, this dimension will be empty. If you modify the image after a customer places an order, the report displays the updated image.

 

By Channel

Displays sales based on the referral sources of customers. Common dimensions of this report are as follows:

Dimension Explanation
Referrer source Displays the source of how customers arrive at your store. Possible situations include:
  • Social: Customers click on links on social media to come to your store.
  • Direct: Customers enter your store’s URL into their browser.
  • Search: Customers click on your store from a search engine’s results page.
  • Other: Sources that do not meet any of the above conditions.

 

By Country/Region

Displays the country or region where the order's shipping address is located. Common dimension of this report are as follows:

Dimension Explanation
Country/Region The country or region where the order's shipping address is located.
Province/State The province or state where the order's shipping address is located.
City The city where the order shipping address is located.
Postcode The zip code of the order's shipping address.

 

Displaying Sales by Traffic Source

Analyzes sales and net sales based on customers' referrer sites. Common dimensions of this report are as follows:

Dimension Explanation
Referrer site The referrer source to your online store for customers who place an order. For example, www.facebook.com
Referrer name The name of the referral source from which customers who placed orders reached your online store, such as Google, Facebook, Instagram, TikTok, etc. For direct sources, if the referral source cannot be tracked, the name appears as N/A.
Referrer path The referrer path from the referrer source to your store for customers who place orders. For example, if the complete URL link of the customer's referrer source is https://r.search.yahoo.com/abc, then the referrer source path is /abc
Referrer source Shows how customers arrive at your store. Possible situations include:
  • Social: Customers click on links on social media to come to your store.
  • Direct: Customers enter your store’s URL into their browser.
  • Search: Customers click on your store from a search engine’s results page.
  • Other: Sources that do not meet any of the above conditions. Traffic recommendation sources are sometimes impossible to track, so it is common for unknown traffic sources to appear.
Referrer URL Display the URL link where customers arrive at your store. For example, https://r.search.yahoo.com/abc
 

Display Sales by Customer Name

Displays sales based on customer names. Common dimensions of this report are as follows:

Dimension Explanation
User ID The customer's unique identifier.
Customer Name Customer's name.
Email address for the order The customer's email address.
Customer Type When creating an order, if the customer is placing an order for the first time, it is identified as a new customer, otherwise, it is a returning customer.

 

Average Order Value by Date Range

Displays changes in the average transaction value of the store within a selected time range. Average transaction value = Sales/Orders.

 

Sales by Discount

Analyze order discount amounts by discount codes or automatic discounts. This report helps you see how often discount codes are applied and helps you understand which discounts convert the most sales. Sales may take 12-72 hours to be reflected in this report. Common dimensions and metrics of this report are as follows:

 

Dimension Explanation
Discount Code The discount code applied to the order by the customer.
Discount Code Campaign Name The discount code campaign name you set.
Discount Code Type Percent discounts, fixed amount discounts, free shipping, and buy X get Y.
Automatic Discount Title The name of the automatic discount campaign you set.
Automatic Discount Type Percent discounts, fixed amount discounts, free shipping, buy X get Y, Mth item discounts, lowest priced item free, and M items for N USD.

 

Metric Definition
Discount Code Amount Discounted amount using discount code.
Automatic Discount Amount Discounted amount using automatic discounts.

 

Sales by Payment Method

Analyze sales by payment methods and channels. Common dimensions of this report are as follows:

Dimension Explanation
Payment Channel

The payment channel used by the customer when paying. For example, PayPal, Oceanpay, GiftCard, etc. If a customer pays for an order in multiple channels, these will be displayed in the Payment Channel row, separated by commas.

For example, Jennie used PayPal to pay when first creating the order. Later when you edit her order to add products, Jennie pays for the new items using Oceanpay. In this case, the Payment Channel for this order will show as PayPal, Oceanpay.

Payment Method The payment method used by the customer when paying. For example, PayPal, CreditCard, adjustPay, etc. If a customer pays for an order by multiple methods, these will be displayed in the Payment Method row, separated by commas.
 

Units per Transaction over Time

Displays changes in units per transaction of the store within a selected time range. Units per transaction = Sales quantity/Orders.

 

Display Sales by Sales Channel

View sales across various sales channels. In this report, sales channel shows the name of the channel or app that customers used to place orders, such as an online store or Buy Button. For sales originating from draft orders created in the admin panel, the reported sales channel will appear as N/A.
 

Display Sales in the Settlement Currency

The report shows sales in the currency the customer used at checkout.

For example, your store sets USD as the checkout currency, and Jennie's local currency is USD, but she also accepts payments in GBP. In this report, SHOPLIONE will help you record the settlement currency of the order completed by Jennie in GBP, but the report still displays sales in USD.

 

Display Sales Based on Product Collection

This report shows sales by product collections, and this report can help you see which product collections have the highest sales. In cases where a product belongs to multiple collections, the report will display multiple rows and record the sales for each order under the respective collections. Please note that it may take up to 24 hours for the report to show the latest data. It is worth noting that the product collection information is recorded according to the product collection at the time of order.

Example: On August 1, when Product A was ordered, it was classified as Collection 1. On August 2, the smart categorization system reclassified Product A as Collection 2. When the customer purchases Product A again on August 2, its collection will be recognized as Collection 2. (However, when querying the product collection for August 1, it will still display as Collection 1.)

 

Commodity Tax on the Tax-Inclusive Price

In other sales reports, when you set taxes and enable the All Prices Include Tax option, the commodity tax and shipping tax will be calculated as zero because these taxes have been recorded in the selling price (that is, recorded in the Subtotal).

To help you understand the tax-included price of each order, SHOPLIONE shows you the commodity tax on the tax-inclusive price and freight tax on the tax-inclusive price of the order in the Commodity Tax on the Tax-Inclusive Price report.

 

It should be noted that the time of this report is based on the time when the order is successfully created, that is, the amount changes caused by operations such as order editing, refund, or cancellation will be uniformly attributed to the order creation completion time. 

The common metrics used in the report are as follows:

Metric Definition
Subtotal Equals Product price × Quantity of items. They are counted based on the time when an order is successfully created.
Discounted Amount The amount deducted after applying a coupon code entered by the customer or any manual discounts created by you. For calculation of the discounted amount, it is apportioned based on the proportion of the subtotal of a product to the subtotal of all products. They are counted based on the time when an order is successfully created.
Commodity Tax Tax calculated based on the order. If you select All prices include tax in the tax settings, the commodity tax is zero as tax is already included in the Subtotal. They are counted based on the time when an order is successfully created.
Commodity Tax (Tax-Inclusive Price)

Commodity tax on the tax-inclusive price is calculated based on the order. They are counted based on the time when an order is successfully created.

If you checked All Prices Include Tax when setting taxes. On January 1, your store sold $100 of goods, and the shipping fee was $20. A certain state in the United States charges a 13% commodity tax and a 5% shipping tax, so the commodity tax (price including tax) = 100 * 13 % = $13; Product Tax = $0.

Shipping fees Shipping fees calculated based on the order. If the order is placed in a "Free shipping" promotion, the product's shipping fee will be zero. They are counted based on the time when an order is successfully created.
Tip Tips received from the order. If there is no tip on the order, the tip amount for the product will show as zero. They are counted based on the time when an order is successfully created.
Shipping Tax Tax associated with shipping from the order. Taxes are imposed on shipping fees when products are sold to certain countries/regions. They are counted based on the time when an order is successfully created.
Freight Tax (Tax-Inclusive Price)

Commodity tax on the tax-inclusive price is calculated based on the order. They are counted based on the time when an order is successfully created.

If you checked All prices include tax when setting taxes. On January 1, your store sold $100 of goods, and the shipping fee was $20. A certain state in the United States charges a 13% commodity tax and a 5% shipping tax, so the shipping tax (tax included) = 20 * 5 % = $1; shipping tax = $0.

Points Deduction The amount deducted from the total payment when members use points for payment. They are counted based on the time when an order is successfully created.
Total Order Amount

Total order amount = Subtotal - Discount Amount + Commodity Tax + Shipping + Shipping Tax + Tip + Duty - Points Deduction

They are counted based on the time when an order is successfully created.

Rounding Adjustment Amount In some international markets, stores have the Rounding Rule setting enabled, requiring consideration of rounding standards for order amounts. This metric ensures accuracy and standardization of numbers. They are counted based on the time when an order is successfully created.

 

Note: This report is currently not open to all clients. If you need to view the report, please contact SHOPLINE customer service.

 


 

Customizing the Sales Report

Click Manage Filters and Edit to customize fields, and then click Update to save the custom sales report.

Suppose you want to see the hot products in the US market over the past 30 days; you can filter the reports by selecting By Country/Region and delete columns you don't wish to see. Steps as below:

  1. From your SHOPLINE admin panel, go to Analytics > Reports.
  2. In the Sales Report, click By Country/Region report.
  3. Select Last 30 days from the drop-down list of Date Range.
  4. Click Manage Filter and add the filter condition Country/Region is the United States.
  5. In the Edit slider, select Product Name and Sales. You can uncheck other metrics and click Update to update your header.
  6. Click Sales to sort the entire report in reverse order by product Sales.
  7. Click the Save as button at the top of the report, enter report name as Top Selling Products in the United States in the Past 30 Days, and click Complete.
  8. The customized sales results report is completed, and you can view it in the Custom Reports list in the future.

 


 

Have more questions? Submit a request

Comments