Shopcada Reports' Glossary

Sales summary report
Sales by payment method
Sales by product count
Sales by channels
Sales by product classification
Sales by staff

Refund summary
Refund by Reasons

Sales summary report

You may filter data by selected channel(s).

TERMS	DEFINITION
Orders	The total number of orders check out during the selected period. All active state order status are included. Order state that are not included are Cancel and In checkout
Gross Sales	Total Qty x Selling price of the products, before discount, where the checkout date is in the given reporting period.
Discounts	Total Discounts of orders where the checkout date is in the given reporting period.
Gross After Discounts	Gross Sales - Discounts
Shipping	Shipping charges collected where orders checkout date is in the given reporting period.
Tax	Tax collected (if not included in the product prices) for the orders where the checkout date is in the given reporting period. Only available for the stores that turn on GST module.
Tax Inclusive	Reverse calculation of the payable tax if the selling price is inclusive of tax. Amount for reference only and will not be added to Total Sales. Only available for the stores that turn on GST module.
Total Sales	Gross Sales - Discount + Shipping + Tax
Voucher Sold	The total value of sales from Gift Certificate during the selected period.
Order Total	Total Sales + Voucher Sold
Refunded	Total refund amount that happens within the given reporting period, based on refund date.
Forfeited Credits	Unused portion of the exchanged credits issued in the retail store. This should be viewed as other incomes.
Net Sales	Total Sales - Refunded + Forfeited Credits
Product Cost	Cost of the products Only visible to the user with access right to cost field under product setup.
Gross Profit	Gross Sales - Product Cost Only visible to the user with access right to cost field under product setup.
Instock / Backorder	Total quantity of Instock / Backorder products checkout during the selected period. Only show when Breakdown by Instock/Backorder option is selected from filter.
Online / Outlets' Name	Total quantity of products checkout during the selected period by channels. Only show when Breakdown by Channels option is selected from filter

Sales by payment method

You may filter data by selected channel(s).

TERMS	DEFINITION
Total Sales	Gross Sales - Discount + Shipping + Tax
Voucher Sold	The total value of sales from Gift Certificate during the selected period
Order Total	Total Sales + Voucher Sold
Gift Certificate	Amount of the total sales that are paid by customers' gift certificate credit. Only available for the stores that turn on Gift Certificate module
Store Credit	Amount of the total sales that are paid by customers' store credit. Only available for the stores that turn on Store Credit module.
Rewards (In individual store branding)	Amount of the total sales that are paid by customers' rewards credit. Only available for the stores that turn on Store Credit module.
Paypal / Stripe Red Dot Payment - Credit Card	Amount of the total sales from web store that are paid by the respective payment mode. Only available for the stores that turn on the respective payment mode.
Cash / NETS / Credit Card / Voucher	Amount of the total sales from retail POS that are paid by the respective payment mode. Only available for the stores that turn on the respective payment mode.
Exchange Credit	Credit that the customers own when they exchange purchase at the retails outlets. Only applicable to POS retails orders.
Total Tendered	Total money collected via various payment methods.
Overages / Shortages	The different between Total Sales and Total Tendered. Overages: Amount collected is more than Total Sales Shortages: Amount collected is lesser than Total Sales .

Sales by product count

You may filter data by selected channel(s).

TERMS	DEFINITION
Orders	The total number of orders check out during the selected period. All active state order status are included. Order state that are not included are Cancel and In checkout.
Products	Total quantity of products checkout during the selected period. All active state order status are included. Order state that are not included are Cancel and In checkout.
Products Refunded	Total quantity of products refunded during the selected period, based on refund date.
Products Net Qty	Products - Products Refunded
Gift Cert	Total quantity of Gift Cert checkout during the selected period.
Instock / Backorder	Total quantity of Instock / Backorder products checkout during the selected period. Only show when Breakdown by Instock/Backorder option is selected from filter.
Online / Outlets' Name	Total quantity of products checkout during the selected period by channels. Only show when Breakdown by Channels option is selected from filter

Sales by channels

TERMS	DEFINITION
Orders	The total number of orders check out during the selected period. All active state order status are included. Order state that are not included are Cancel and In checkout.
Gross Sales	Total Qty x Selling price of the products, before discount, where the checkout date is in the given reporting period.
Discounts	Total Discounts of orders where the checkout date is in the given reporting period.
Gross After Discounts	Gross Sales - Discounts
Voucher Sold	The total value of sales from Gift Certificate during the selected period.
Products Refunded	Total amount of product refunded during the selected period, based on refund date.
Exchange Credit	Credit that the customers own when they exchange purchase at the retails outlets. Only applicable to POS retails orders.
Cash / NETS / Credit Card / Voucher	Amount of the total sales from retail POS that are paid by the respective payment mode. Only available for the stores that turn on the respective payment mode. Only show when Breakdown by Payment Method option is selected from filter.

Sales by product classification

You may filter data by selected channel(s).
You may filter data by selected classification, depending on your store setup.
You may select category, collection, colour, brand, size and etc.

TERMS	DEFINITION
Various classification	Total Qty x Selling price of the products, before discount, where the checkout date is in the given reporting period.

Sales by staff

This report only available for store enable Shopcada POS.

TERMS	DEFINITION
Orders	The total number of orders check out during the selected period. All active state order status are included. Order state that are not included are Cancel and In checkout
Products	Total quantity of products checkout during the selected period. All active state order status are included. Order state that are not included are Cancel and In checkout.
Total Sales	Gross Sales - Discount + Shipping + Tax
Refunded	Total refund amount that happens within the given reporting period, based on refund date.
Exchange Credit	Credit that the customers own when they exchange purchase at the retails outlets. Only applicable to POS retails orders.
Cash / NETS / Credit Card / Voucher	Amount of the total sales from retail POS that are paid by the respective payment mode. Only available for the stores that turn on the respective payment mode. Only show when Breakdown by Payment Method option is selected from filter.

Order Summary

This report show the order details at order level.
You may filter data by selected order status.
You may filter data by selected channel(s).

FILTER BY ORDER STATUS	DEFINITION
Active Orders	Report will list all active orders with payment date during the selected period. This including all orders at order state Post Checkout, Payment Received, and Completed.
All Orders	Report will list all orders with order creation date during the selected period. This including order at order state In Checkout and Canceled.

Refund summary

This report list the orders have a refund during the select period.
You may filter data by selected channel(s).

TERMS	DEFINITION
Refund #	This is system generate transaction ID.
Order #	Order ID. You can click to view the order details.
Order date	Order created date and time.
Refund date	Refund created date and time.
Order quantity	Number of the items checkout when order created.
Refund quantity	Number of the items refunded. Entered by site admin when process the refund.
Refund Total	Amount refunded. Entered by site admin when process the refund.
Refund Method	The channel refund amount is pay back to customer
Reason	Entered by site admin when process the refund. View summary by reason at REFUND BY REASONS.

Shopcada Reports' Glossary

Sales summary report

Sales by payment method

Sales by product count

Sales by channels

Sales by product classification

Sales by staff

Order Summary

Refund summary

Sell Everywhere

Products

Company

Customer Care