Home Forums Reports & Utilities FBA FBA Out of Stock with Sales Report

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #875
    admin
    Keymaster

    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 = True) where the order fulfillment type is AFN (OrdersDetail.FulfillType = ‘AFN’). Products will only appear on this report 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.

Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.