Best/Worst Sellers report shows you the products that have the best or worst performance in terms of Net Sales or Net Items Sold. In addition to Net Sales and Quantity of items sold, you can see COGS, Margin and average item price in this report for the best or worst sellers in your store.
All metrics in the report are sortable and are defined as follows:
Product: The name of the product
Net Sales: Gross Sales - Discounts - Returns
Net Items Sold: Number of items sold - Number of items returned
Average Item Price: Net Sales / Net Items Sold
COGS: Sum of Unit Costs of items sold and returned. Unit costs are averages.
Gross Margin: (Net Sales - Cost of Goods Sold) / Net Sales
You can find the filters at the top-right corner on the Best/Worst Sellers page, and the report can be filtered by:
- Locations
- Date Range
You can also export the report by clicking the "Export" button next to the Location filter.