Predictive Restocking for FBA

Updated 3 weeks ago

Predictive restocking for FBA calculates the quantity of products needed to be restocked at FBA to meet the expected volume of FBA orders for a range of days. 

While Amazon provides a restock report, their report is only based on the current inventory at FBA versus the past quantity sold at FBA. This may be an inaccurate restock quantity because it lacks information about quantities added to FBA or reserved for FBA that has not yet been previewed. 

Additionally, the Amazon report includes all items, while you may want to focus on a narrower group of products.

SellerCloud's predictive restocking provides the following additional information and capabilities:

  • Considers quantities already in-transit to FBA 
  • Considers quantities already in FBA inbound shipments that were not yet shipped
  • Can filter products to only show products with inventory in your warehouse to add to FBA 
  • Can filter products by vendor, buyer, manufacturer, product group, or single SKU

This feature is similar to Predicted Purchasing but is focused on the "selling" SKU and the amounts needed to restock FBA. It is not designed to provide information about the "inventoried" SKU and determine purchase quantities.

For example, if a product has many shadows, predicted purchasing can factor in sales for all related shadows of the purchasing SKU (SKU used on the PO) when the Client Setting Predicted Purchasing Merge Shadow SKU is enabled, because inventory is maintained by that SKU. Restocking FBA relates only to the actual SKU sold on FBA. 

The windows service ProductQtySoldCalcuateServices MUST be running on the server. This can be enabled by SellerCloud Support.

Key terms

  • Days OF Order - Days of past sales from which you are basing the prediction. This generates a daily velocity. Days with no stock availability will be skipped in the Days Of Order Count.
  • Velocity = Rate of sales per day when calculated by - Qty Sold in Days of Order divided by Days of Order
  • Deficit Supply - The predicted deficit to your supply for multiple date ranges. This is calculated as follows: (Velocity x Deficit Days) - (FBA Available Qty + In-transit + FBA Unshipped). See terms below:
    • FBA Available Qty = Qty available in FBA warehouses in SellerCloud
    • InTransit = Qty which is FBA Shipped, InTransit, CheckedIn Receiving
    • FBA UnShipped Qty = Qty in FBA shipment with status Saved, Previewed or Working
  • Days TO Order - Days to which you are multiplying the daily velocity to generate an Add to FBA Qty. While the deficit supply will be calculated for all dates, this selection enables a quick add to FBA. See below.

After determining the quantity to send, you can add to an FBA inbound shipment directly from this page. Example: Days of Order 30/ Days To Order 60



In this example, 69 units sold from FBA in the past 30 days (as seen in the Qty Sold field). Because it is based on a 30-day period, the per day velocity is 2.3. 

  • Deficit Supply 15 - Multiplying 2.3 by 15 gives you 34.5. Subtract the FBA Qty, the Unshipped Qty, In-transit Qty. This gives you a Deficit 15 of 0. ((69/30) * 15) - (12 + 29 + 21) = - 27.5. Therefore, there is no deficit qty.  
  • Deficit Supply 30 - Multiplying 2.3 by 30 gives you 69. Subtract the FBA Qty, the Unshipped Qty, In-transit Qty. This gives you a Deficit 30 of 7 ((69/30) * 30) - (12 + 29 + 21) = 7
  • Deficit Supply 60 - Multiplying 2.3 by 60 gives you 138. Subtract the FBA Qty, the Unshipped Qty, In-transit Qty. This gives you a Deficit 60 of 76 ((69/30) * 60) - (12 + 29 + 21) = 76
  • Same calc. for 45 and 90
  • See below for explanation of 11/M. 
  • Since Days To Order 60 was selected, the deficit qty of 76 was auto entered into the QTY. field to add to an FBA Inbound Shipment. See below.

Recently added to FBA Restock to help you determine products to restock:

  • FBA Reserve Qty - Quantity reserved by FBA orders.
  • Sales Rank - The Sales Rank calculation is based on Amazon sales and is updated daily to reflect recent and historical sales of the item sold on Amazon. Lower numbers indicate a higher ranking. Enable client setting Enable Amazon SalesRank download. You can get the current sales rank from the action menu.
  • Effective margin after amazon fees - Subtracts the estimated fees from the Price to give you an indication of your revenue margin. You can then compare to the site cost, visible on the page, to see your profit margins for the product.
  • Number FBA Sellers - The number of sellers with FBA offers that are in New condition


Generating a restock prediction

Restock predictions can be auto-generated based on a schedule.

Requirements:

  • Enable the Client Setting Calculate Qty Sold in X days for Predicted Purchasing.
  • Ensure that the ProductInventoryMovementService is running on the server. This runs once daily around 2:00 AM.
  1. Click Inventory > Predicted Purchasing > Predictive Restocking for FBA.
  2. If the services above have been set, go to Step #4.
    1. If not, or if you want to calculate based on even more recent data, click Action Menu > Generate Data for Sold Since Last Year > Go. This will calculate data for all FBA products in your catalog. (Alternatively, you can select specific items on the grid and click Action Menu > Generate Data for Selected SKUs. SKUs will only appear in the grid after steps 4 and 5 are completed.)
  3. After the job completes, refresh the page.
  4. Select a Days Of Order/Days TO Order velocity.
  5. Filter as search as needed.
  6. Enable the Client Setting Predictive Restocking: enable warehouse filter to display a warehouse filter. The report will use selected warehouse quantity as the Available Quantity. 
  7. Click Search. The grid will only show items Fulfilled by Amazon.
  8. The following columns can be displayed in the grid (controlled by clicking "Select Columns" in the top left corner):
    1. ProductID
    2. Preview Image - Displays first image in product's image manager.
    3. Parent Product ID - If the item is a shadow, will show the shadow parent product ID. (FBA SKUs are often shadows.)
    4. ProductName
    5. ASIN
    6. Site Cost
    7. Selling Price - Price on the Amazon Health report that often differs from the defined Amazon price in SellerCloud. If none is found, will use from seller-defined Amazon Price on the Amazon Properties page.
    8. Amazon BuyBox Price - Retail price of the BuyBox on Amazon. Many online sellers will use this information to determine if they can be competitive on a given product, or if they should discontinue the product. Read how to get the Amazon BuyBox here.
    9. Amazon Rank - How well a listing is selling compared to other listings in the same category. Read more here.
    10. Avail. Qty - Quantity in all sellable warehouses available to be added to an FBA inbound shipment. This excludes the FBA warehouse, even if the FBA warehouse is sellable. 
      • See below for available qty related to kits.
      • Available quantity can be limited to specific warehouse. See "6" above.
    11. FBA Available Qty - The current available for sale at FBA quantity at FBA. 
    12. FBA Reserved Qty - By default, SellerCloud will only import the quantity reserved because it has been ordered by a customer.
      • To include the "FC Processing" and "FC Transfer quantities" as Reserved Qty rather than Available Qty, the Client Setting Predictive Restocking: Consider FC Transfer and FC Processing as reserved should be enabled. 
      • For any situation in which sellers are trying to view reserved quantity in Predictive Restocking, it is important that the Client Setting Always Consider FBA Total Supply Quantity is enabled; otherwise, reserved quantities will be subtracted from available qty twice.
    13. Qty - Enter the quantity to add to FBA. See below.
    14. Effective Margin After Amazon Fees - Calculates profit margin after fees are deducted: Amazon Price - FBA Fees - Item cost = Margin. Hover over the number to reveal the breakdown. The effect margin percent is calculated against the item cost as such: Margin$/cost * 100). 
    15. # of FBA Sellers
    16. Velocity - Rate of sales per day when calculated by - Qty Sold in Days of Order divided by Days of Order
    17. Qty Sold- The quantity sold from FBA in the selected "Days of Order." Based on the Client Setting above, it will calculate sales of on days inventory availability. This means days within the selected "Days of Order" where there was no available inventory at FBA will be skipped in the count. 
    18. Deficit Supply - The predicted deficit to your supply at FBA. This is calculated as follows: (Velocity x Days To Order) - (FBA Qty + In-Transit Qty +  FBA Unshipped) = Deficit Qty.
    19. 11/M -  Qty Sold 11 months prior for a full month period. This is helpful when trying to determine quantities to add to FBA for seasonal periods, which are often different than preceding non-season months. For example, if you are at the start of November and want to determine how much to add to FBA for the coming seasonal month of December, this column will look back 11 months - to December - and show quantity sold for the month of December. This can be used as an indicator if you need to add more qty than was calculated based on the regular velocity.
    20. In-Transit - The current quantity that is in-transit. The inventory may be in-transit to FBA from your warehouse or in-transit from one FBA warehouse to another.
    21. FBA UnShipped -  The current quantity already added to an FBA inbound shipment that has not been shipped.
    22. Vendor

Available Qty for Kits: Kits being added to FBA must have an Independent inventory status. This means that its inventory quantity is independent from the inventory quantity of the components. The independent kit gets inventory by assembling the kit. (Read more here.) Therefore, by default, the available quantity shown on a kit item will only be what has already been assembled into the independent kit. However, enabling the Client Setting Enable projected kit qty will include component inventory that is available to be assembled into the kit. Hovering over the Available Qty will open a window that shows the breakdown with the following terms:

  • Kit Qty - Inventory already assembled 
  • Avail Qty. - Quantity available to be assembled 

Add to FBA inbound shipment

  1. Enter a the amount you want to order in the Qty text field.
  2. Select the products on the grid.
  3. Click Action Menu > Add to FBA > Go. You will be prompted to create a new FBA Shipment or add to an existing shipment.
  4. Choose your option and click Continue.


How did we do?


Explore our brands and social media
Skustack Memaila Turnstock WayToPay.Me Facebook Instagram Linkedin YouToube Twitter