Products Sold Report

Report Overview

The Products Sold report displays all of the products that affiliates have sold.  It does not take returns/adjustments into account.  The report is available to both Merchants and Affiliates on the 'Classic' reporting interface.

Column Definitions

• Sale Count: total number of orders that included that product SKU.  Desktop and Mobile order are included.
• Mobile Sale Count: total number of mobil orders that included that product SKU.  Only Mobile order are included.  Desktop is excluded.
• Total Product Sale Quantity:  the total count of product SKUs sold.  Desktop and Mobile order are included.  
  • Example: if there are two separate orders that had a quantity of three for the same SKU, the Total Product Sale Quantity would be six (Order Count of 2 multiplied by SKU count of 3)
• Total Product Sale Amount: The total dollar value of all units sold for a specific SKU. Desktop and Mobile order are included.  
  • Example: If 5 units of a SKU were sold at $20 each, the Total Product Sale Amount would be $100.

About the Data Source

AvantLink receives the product data from the Merchant via two independent processes:

1. The SKU, Quantity (of items sold), and the Price Per SKU from the merchant's tracking.
2. The Brand Name, Product Name, Category, Sub Category, and Product Group come from the merchant's product datafeed.
   • If there is not a value for this data in the report, merchants can update their datafeed to send AvantLink the data. The datafeed columns that report uses are:
     • Brand Name = StrBrandName
     • Category = strDepartmentName
     • Product Name = strProductName