The Out of Stock with Sales report lists all products with sales for the date range selected, but are currently out of stock. Any item out of stock with sales requires a closer look to determine what action if any needs to be taken. You should periodically run this report to determine if products listed on the report need to be ordered from your supplier.
This report takes into account AFN (FBA) quantities using the (Products.QtyFBA = 0 ) field in the products table, and including only those products listed on FBA (Products.ListingFBA = Ture) where the order fulfillment type is AFN (OrdersDetail.FulfillType = 'AFN'). Products will only appear on this report when when those conditions are met for the date range and other filter options selected via the data filters.
The Quantity in Transit Qty IT (Products.QtyIT) or Quantity Reserved Qty Resv (Products.QtyFBAR ) is ignored since these quantities in transit and reserved are not available for sale.
Click here to view the video for the Amazon FBA Out of Stocks with Sales report.
Column Headings & Field Mappings
Column
|
Table
|
Data Field
|
Type
|
Description
|
Product SKU
|
Prods
|
ProdSKU
|
Data
|
Product SKU
|
FN SKU
|
Prods
|
ProdFNSku
|
Data
|
Amazon Fulfillment Network SKU
|
ASIN
|
Prods
|
ASIN
|
Data
|
Amazon Standard Identification Number (ASIN)
|
Barcode
|
Prods
|
Barcode
|
Data
|
Product Barcode
|
UPC
|
Prods
|
UPC
|
Data
|
Universal Product Code (UPC)
|
Product Name
|
Prods
|
ProdName
|
Data
|
Product name or listing title
|
Qty IT
|
Prods
|
QtyIT
|
Data
|
Quantity in Transit
|
Qty Resv
|
Prods
|
QtyFBAR
|
Data
|
Quantity Reserved at the FBA Warehouse
|
Nbr Ords
|
OrdersDetail
|
Proprietary Algorithm
|
Calculated
|
Number or orders containing the SKU
|
Last Date
|
OrdersDetail
|
Proprietary Algorithm
|
Calculated
|
Last Date Sold
|
Last Order
|
OrdersDetail
|
Proprietary Algorithm
|
Calculated
|
Last Order ID Sold
|
Qty Sold
|
OrdersDetail
|
Proprietary Algorithm
|
Calculated
|
Total number of units sold
|
Cogs
|
OrdersDetail
|
CostPerUnit * Units Sold
|
Calculated
|
Total cost of goods sold (Cogs) for the product
|
Sales
|
OrdersDetail
|
PricePerUnit * Units Sold
|
Calculated
|
Total sales for the product
|
GM
|
|
Proprietary Algorithm
|
Calculated
|
Total Gross Margin (GM)
|
GM %
|
|
Proprietary Algorithm
|
Calculated
|
Total Gross Margin Percent (GM %)
|
Days Since
|
|
Proprietary Algorithm
|
Calculated
|
Days since last sale
|
Category
|
Prods
|
CatID
|
Data
|
Category assignment
|
Brand
|
Prods
|
BrandID
|
Data
|
Brand/Product Line assignment
|
Supplier SKU
|
Prods
|
SuppSKU
|
Data
|
Supplier SKU
|
Supplier
|
Supps
|
SuppName
|
Data
|
Supplier Name
|
|