Searching...

Amazon’s FBA Restock Report


Overview 

The Amazon FBA Restock Report is an alternative to the Sellercloud  Predictive Restocking for FBA. The report provides you with valuable insights into your inventory in Amazon Fulfillment Centers (FCs). This report is designed to help you identify when you need to restock your inventory and when you should remove excess stock.

The page shows data from the most recent Amazon FBA Inventory Restock Report. It includes current inventory levels, sales velocity, lead times, and fulfillment rates for each FBA SKU. In contrast to Sellercloud’s Predictive Restocking Report, it only shows data for the prior 90 days to identify trends and patterns in sales volume and then uses that data to project future sales and make restocking recommendations. The report information changes dynamically as Amazon takes into account any changes in sales velocity, lead times, and changes in product demand.

App Setting EnableAmazonMarketplaceReportsControl must be enabled for this workflow. Contact Sellercloud Support to ensure that this setting is enabled for your account.

Manage Restock Report

To view Amazon’s FBA Restock Report, navigate to Purchasing > Tools > Amazon FBA Restock Report.

You will see the following filters on the page:

  • Company
  • Buyer
  • Vendor
  • Brand
  • Product ID
  • ASIN
  • Avail From Warehouse – when you select a warehouse for this filter, the Available Inventory (Non-FBA) column will display quantities only from the selected warehouse(s).
  • In Stock Alert
  • Only Show Rows with quantity to be restocked
  • Only Show Rows with Avail Qty
  • Show Amazon Enabled

Grid Data

Once you search for products, the following columns will appear in the grid:

  • SKU – A product’s unique Sellercloud SKU. 
  • Amazon SKU – The SKU for the product on Amazon. Should correspond to the Amazon Merchant SKU. 
  • Price on Amazon – The price of the product on Amazon.
  • FBA Recommended Order Qty – Тhe recommended quantity to restock, based on the report data.
  • Last 30 Days Units Sold – The quantity sold for the last 30 days.
  • Last 30 days Sales $ – Profit earned based on the last 30 days of product sales.
  • Available Inventory (FBA) – Available Inventory currently stored in Amazon Fulfillment Centers.
  • Available Inventory (Non-FBA) – Available Inventory in your local warehouses. If using the Avail From Warehouse filter, this column will only show the inventory from the selected warehouses.
  • Inbound Inventory – Product Inventory shipped from your local warehouse but not yet received by Amazon.
  • Total Inventory – Product’s total inventory from Available FBA and Inbound Inventory.
  • Days of Supply
  • Downloaded On – Displayed the date the last available report from Amazon containing this product was downloaded.
  • FBA Reserved Qty – Product inventory currently reserved for FBA Inbound Shipments.
  • Fulfilled By – Displays if the product is FBA or FBM.
  • InStock Alert – shows if there is a Low Stock or Out of Stock alert for the product in the latest Amazon Report.
  • Qty On Order – Product Inventory in unreceived Purchase Orders.
  • Recommended Order Date
  • UnFillable

 

Actions

Once you select a product, the Action menu provides the following options:

  • Export to Excel – Export the report data in an Excel sheet.
  • Add to FBA Shipment – this action will add the selected products to the already existing FBA Shipment or a new one.
  • Add to PO – the selected products will be added to an already existing purchase order or a new one.
  • Add to FBA Shipment and PO – this action will add the selected products both to FBA Shipment and Purchase Order.
  • Add to FBA Shipment and PO from Vendor – this action will add the selected products both to FBA Shipment and PO from a specifically selected Vendor.
When you select the ‘Add to..’ actions, a pop-up window will open, allowing you to specify the Purchase Order or Fulfilment By Amazon shipment you wish to add items to.

Overview 

The Amazon FBA Restock Report is an alternative to the Sellercloud  Predictive Restocking for FBA. The report provides you with valuable insights into your inventory in Amazon Fulfillment Centers (FCs). This report is designed to help you identify when you need to restock your inventory and when you should remove excess stock.

The page shows data from the most recent Amazon FBA Inventory Restock Report. It includes current inventory levels, sales velocity, lead times, and fulfillment rates for each FBA SKU. In contrast to Sellercloud’s Predictive Restocking Report, it only shows data for the prior 90 days to identify trends and patterns in sales volume and then uses that data to project future sales and make restocking recommendations. The report information changes dynamically as Amazon takes into account any changes in sales velocity, lead times, and changes in product demand.

App Setting EnableAmazonMarketplaceReportsControl must be enabled for this workflow. Contact Sellercloud Support to ensure that this setting is enabled for your account.

Manage Restock Report

To view Amazon’s FBA Restock Report, navigate to Inventory > Predicted Purchasing > Predictive Restocking for FBA > FBA Restock Inventory Report from Amazon.

You will see the following filters on the page:

Grid Data

Once you search for products, the following columns will appear in the grid:

  • Product ID – A product’s unique Sellercloud SKU. 
  • AmazonSKU – The SKU for the product on Amazon. Should correspond to the Amazon Merchant SKU.
  • Price on Amazon – The price of the product on Amazon.
  • FBA Recommended Order Qty – Тhe recommended quantity to restock, based on the report data.
  • InStockAlert – Amazon’s column that indicates a product’s current stock levels.
  • Days Of Supply – The product’s inventory age in the fulfillment center
  • Recommended Order Date – The date that the system recommends you ship out an FBA Inbound Shipment for inventory restocking.
  • Last 30 Days Sale Unit – The quantity sold for the last 30 days.
  • Last 30 days Sales $ – Profit earned based on the last 30 days of product sales.
  • Available Inventory (FBA) – Available Inventory currently stored in Amazon Fulfillment Centers.
  • Available Inventory (Non-FBA) – Available Inventory in your local warehouses.
  • Inbound Inventory – Product Inventory shipped from your local warehouse but not yet received by Amazon.
  • Total Inventory – Product’s total inventory from Available FBA and Inbound Inventory.
  • FBA Reserved Qty – The amount of inventory that is currently held in Amazon’s fulfillment centers but is reserved for orders that have been placed but not shipped.
  • Unfulfillable – The product cannot be shipped to the Amazon Fulfillment Centers and, therefore, cannot be sold through Amazon FBA.
  • Fulfilled By – Indicates if the product is fulfilled by Amazon or fulfilled by Merchant.
  • Downloaded On  – Date and Time when the report was imported to Sellercloud from Amazon

Actions

Once you select a product, the Action menu provides the following options:

  • Export to Excel – Export the report data in an Excel sheet.
  • Add to FBA Shipment – this action will add the selected products to the already existing FBA Shipment or a new one.
  • Add to PO – the selected products will be added to an already existing purchase order or a new one.
  • Add to FBA Shipment and PO – this action will add the selected products both to FBA Shipment and Purchase Order.
  • Add to FBA Shipment and PO from Vendor – this action will add the selected products both to FBA Shipment and PO from a specifically selected Vendor.
When you select the ‘Add to..’ actions, you will be taken to a new page, where you can specify the Purchase Order or FBA shipment you wish to add items to.

Was this article helpful?

Yes No
Need Support?
Can't find the answer you're looking for?
Contact Support