Predictive Restocking for FBA

Please read first! For information on this feature in Sellercloud’s original interface, download this file.

Using predictive restocking

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), because inventory is maintained by that SKU. Restocking FBA relates only to the actual SKU sold on FBA. 

The windows service ProductQtySoldCalcuateServicesMUST be running on the server. This can be enabled by Sellercloud Support.

Key Terms

Term

Definition

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

sellercloud fba predictive restocking

Predictive restocking example

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. 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: Ensure that the ProductInventoryMovementService is running on the server. This runs once daily around 2:00 AM.

  1. Click 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 and Days TO Order velocity.
  5. Filter as search as needed.
  6. Click Search. The grid will only show items Fulfilled by Amazon.
  7. The following columns can be displayed in the grid (controlled by clicking Customize Columns in the top right corner):

Column

Description
ProductID

Product’s SKU

Preview Image

Displays first image in product’s image manager

Parent Product ID

If the item is a shadow, will show the shadow parent product ID (FBA SKUs are often shadows)

Product Name

Formal title of the product
ASIN

Amazon standard identification number

Site Cost

The value of the product

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

Buy Box 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

Amazon Rank

How well a listing is selling compared to other listings in the same category

Avail. Local Quantity

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 step 6 above.

FBA Qty

The current available for sale at FBA quantity at FBA

FBA Reserved Qty

By default, Sellercloud will only import the quantity reserved because it has been ordered by a customer

Qty

Qty available to be added to FBA

Effective Margin After Amazon Fee

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). 

FBA Sellers

Someone who sells products and goods through FBA
Velocity

Rate of sales per day when calculated by – Qty Sold in Days of Order divided by Days of Order

Qty Sold 3

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. 

Deficit

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

Deficit 11 Mo

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

In Transit

FBA Unshipped

The current quantity already added to an FBA inbound shipment that has not been shipped

Vendor

Someone who sells goods and services
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. 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 

To include the FC Processing and FC Transfer quantities as Reserved Qty rather than Available Qty, Predictive Restocking: Consider FC Transfer and FC Processing as reserved should be enabled in Client Settings
For any situation in which sellers are trying to view reserved quantity in Predictive Restocking, it is important that Always Consider FBA Total Supply Quantity in Client Settings is enabled; otherwise, reserved quantities will be subtracted from available qty twice.
If you’re looking for single or multiple ASINs, you can search them using Custom filters. Simply select ASIN from the dropdown under Add Filter. You can enter multiple ASINs in the field to search for.

Adding to a 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. You will be prompted to create a new FBA Shipment or add to an existing shipment.
  4. Choose your option and click Continue.

 

Was this article helpful?

Related Articles