FBA Inventory

FBA inventory imports into SellerCloud only if you have warehouse set for the FBA channel

Items set as FBM or Merchant Fulfilled in SellerCloud will not have their FBA warehouse inventory updated. An item must be set as FBA in SellerCloud in order to be updated to the most recent FBA qty from Amazon.

Inventory at Amazon Fulfillment Centers is stored in a warehouse that has been set as an FBA type warehouse. Inventory in this warehouse is updated periodically through FBA Inventory Reports that SellerCloud receives from Amazon. By default, the inventory is pulled from the column "afn-fulfillable-quantity" (column k). However, some merchants may want to have the total qty - even unfillable qty - updated in their SellerCloud FBA warehouse. This can be for reasons including reporting the true value of inventory at FBA or a willingness to sell inventory that will become available. Enable one of the following applicable client settings:

  1. Use FBA warehouse-quantity - Updates SellerCloud FBA warehouse from column "afn-warehouse-quantity" (column J), which includes inventory that FBA has determined to be unfillable. For example, if it's transit. If the warehouse is sellable, all inventory will be available for sale and will be included in the inventory feeds.
  2. Always Consider FBA Total Supply Quantity - Updates SellerCloud FBA warehouse from column "afn-warehouse-quantity" (column J), which includes inventory that FBA has determined to be unfillable. However, while the inventory will include total qty for inventory reporting and value  purposes, the unfillable inventory will not be included in the inventory feeds, even if FBA warehouse is sellable.
  3. Download FBA Reserved inventory breakdown - SellerCloud will consider the pending FBA orders/transfers and deduct those values from the available qty in SellerCloud.
Inventory will not update based on regular inventory movement, like the FBA Orders Report or when Shipping via FBA, and there will be no regular inventory movement history for FBA orders. This is to avoid duplication to adjustments in inventory levels. However, on the Inventory Movement page, you can click on the "FBA Movement" tab to see FBA order movement history.
Inventory is added to FBA by creating and shipping FBA Inbound shipments. Amazon receives the shipment, counts the inventory, and enters it into the FBA inventory reports. Amazon may not receive all inventory at one time. They may decide to ship some inventory to a different Amazon Fulfillment Center, so some inventory may only be available at a later date.
Inventory can be manually pulled as well to update individual products. On the Amazon Properties page click on Check Amazon FBA Quantity from the Action Menu. The quantity will update and a grid will display the status of the product's availability, like the earliest available time to pick.

Sometime the shipped quantity does not match the received quantity; Amazon may claim to have received more or less of any item. SellerCloud deals with this discrepancy in the following manner:
  • By default, if the Amazon over receives, SellerCloud assumes that the shipper erred, and automatically adjusts the shipped quantity to match the higher received quantity. However, because Amazon is known to make mistakes with over receiving, you can enable the client setting Do not adjust FBA Qty shipped even if over received. This will prevent the shipped quantity from adjusting.
  • If the Amazon under receives, SellerCloud will assume that Amazon will still receive more inventory in the future, and will not make any adjustments to the shipped quantity.

How FBA quantities work and how to track them

As stated above, all the available inventory from Amazon FBA is imported regularly in SellerCloud via the FBA inventory reports. 

  • When the FBA Warehouse is marked as Non-Sellable. In this case the inventory will only show as aggregate inventory for products that are set as FBA fulfilled. Physical inventory can be tracked from the Product Warehouse link on the product's Summary Page by checking the FBA quantity shown on the dedicated FBA warehouse. Inventory movement can be tracked from the product's Summary Page by clicking Inventory Movement > View FBA Movement. Here you can also check for reserved quantities that will not be included in the aggregate inventory. 
  • When the FBA Warehouse is marked as Sellable. If you set your FBA Warehouse as sellable, the inventory inside will be included into the aggregate quantities for the same products set as FBM (if they have the same ASIN). This workflow is often used when you are selling FBA fulfilled products to other channels than Amazon and a specialized post-order plugin should be installed on your server (FBA Format). Inventory Movement will include such multi-channel orders and the Product Warehouse quantity calculations will include the FBA inventory.
  • A common mistake is setting different FBA integrations to the same FBA warehouse. This causes the inventory reports to be overwriting each other. Since we are importing the inventory regularly, each Amazon FBA integration needs to be set in a separated FBA-type warehouse.

How did we do?