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 needs a closer look to determine what action needs to be taken. You should periodically run this report to determine if products on the report need to be ordered from your supplier.
This report takes into account both the MFN (Merchant) and AFN (FBA) quantities using the QtyTOT field in the products table. Products will only appear on this report when both quantities are 0 (QtyTOT is alos 0). Products with a FBA quantity > 0 for are excluded from this report because you can still fulfill MFN order via a non-Amazon fulfillment (NAF) so it is not out of stock. 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.
Click here to view the video for the Amazon 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 OO
|
Prods
|
QtyOO
|
Data
|
Quantity On Order
|
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
|
|