This article covers the sales by variant report within Stock&Buy.
The Sales by product variant report shows the breakdown of gross sales, excluding shipping and other landed cost, of your products on a more granular level, namely at the variant level.
Shipping isn’t included because an order can consist of several products, but has a single shipping charge. For reporting purposes, the shipping charge can’t be apportioned between the products in the order.
The sales by variant report has the following columns:
|Product||The product name|
|Variant||The variant name|
|SKU||The Stock Keeping Unit of the variantion|
|Orders Count||Total number of orders the variation is sold in. Click on the total count to get a list of all the recorded orders.|
|Units Count||The total number of units sold. The units count is calculated as total units sold / total units returned. The report date range is calculated from the selected date range filter.|
|Gross Sales||The total sum of all order line items related to the product. Gross sales are calculated as product price x quantity (before taxes, shipping, discounts, and returns). Allocated, Invoiced and Shipped orders are included.|
|Discounts||The total sum of discounts at all order line items related to the product. All discounts are applied before taxes|
|Returns||The total value of goods returned by a customer.|
|Net Sales||Equates to gross sales – discounts – returns|
|Tax||The total amount of taxes based on the orders.|
|COGS||The total sum of the Cost Of Goods Sold. Equates to the product moving average cost at the time the order is recorded * quantity|
As of today, you can filter the sales by variant report by date and product brand name.