Predictive Restocking for FBA

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

While Amazon does provide a restock report, their report is based solely on the current inventory at FBA versus the past qty 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 display products with inventory in the 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 give info 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 (the SKU used on the purchase order) when 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. 

Please note: 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. Please note that 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 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 off a 30 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. 
  • Because 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 - 
  • 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 and 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

Generate a Restock Prediction
Restock predictions can be generated automatically on schedule. Enable the client setting Calculate Qty Sold in X days for Predicted Purchasing. Additionally, the service ProductInventoryMovementService must be running on the server. The service runs once a day around 2 AM. Then, navigate to Inventory > Predicted Purchasing  > Predictive Restocking for FBA link and begin from step 5 below.

  1. Navigate Inventory > Predicted Purchasing.
  2. Press the Predictive Restocking for FBA link.
  3. If the services above have been set, proceed to step 5. If not, or you want to calculate based on even more recent data, open the action menu and select Generate Data for Sold Since Last Year, and GO. This action will calculate data for all FBA products in your catalog. Alternatively, you can select specific items on the grid and select Generate Data for Selected SKUs from the action menuSKUs will only display in the grid after steps 5 and 6 have been completed.
  4. After the job completes, refresh the page.
  5. Select a Days Of Order/Days TO Order velocity.
  6. Filter as search as needed.
    • Enable client setting Predictive Restocking: enable warehouse filter to display a warehouse filter. The report will use selected warehouse quantity as the Available Quantity. 
  7. Press Search.
  8. The grid will only display items that are Fulfilled by Amazon.
  9. The following columns can be displayed in the grid (controlled by pressing on "Select Columns" above top left corner):
    1. ProductID
    2. Preview Image - Displays 1st image in product's image manager.
    3. Parent Product ID - When item is shadow, will display shadow parent product ID. (FBA SKUs are often shadows.)
    4. ProductName
    5. ASIN
    6. Site Cost
    7. Selling Price - The price on the Amazon Health report which can often be different from the defined Amazon price in SellerCloud. If none is found, then will use from seller defined Amazon Price on the Amazon Properties page.
    8. Amazon BuyBox PriceThe retail price of the BuyBox on Amazon. Many online sellers will use this info 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 Rankindicates 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 that is available to be added to an FBA inbound shipment. This excludes 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 qty 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, client setting Predictive Restocking: Consider FC Transfer and FC Processing as reserved should be enabled. 
      • For any situation where the client is trying to view reserved qty in Predictive Restocking, it is important that client setting Always Consider FBA Total Supply Quantity be enabled, or else the reserved quantities will be subtracted from available qty twice.
    13. Qty - In this field you can enter the quantity to add to FBA. See below.
    14. Effective Margin After Amazon Fees - Calculates the profit margin after fees are deducted: Amazon Price - FBA Fees - Item cost = Margin. Hover over number to reveal breakdown. The effect margin percent is calculated against the item cost as such: Margin$/cost * 100). 
    15. # of FBA Sellers
    16. VelocityRate 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 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 back in time for a full month period. This can be 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 beginning 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 display 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 it may be 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 qty. 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 your mouse over the Available Qty will pop open a window which displays the break down 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. Open action menu and select Add to FBA and GO.
  4. You will be prompted to create a new FBA Shipment or add to an existing shipment.
  5. Choose your option and press Continue.
Comments