Predictive Restocking for FBA

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

Predictive restocking for FBA feature

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 Predictive 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, predictive 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 ProductQtySoldCalcuateServices must 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.

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.
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 that is FBA Shipped, InTransit, CheckedIn Receiving
  • FBA UnShipped Qty = Qty in FBA shipment with status Saved, Previewed or Working

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 = 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 = 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 = 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 calculation for 45 and 90
  • See below for an 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 restocking  to help you determine products to restock:

  • FBA Reserved Qty— Quantity reserved by FBA orders
  • Amazon Rank— This 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.
  • Num FBA Sellers— The number of sellers with FBA offers that are in New condition.

Client Settings


SETTING


DEFINITION

Predictive Restocking: enable for purchasing The setting Reduce OnOrder Qty will display on the Predictive Restocking for FBA page. The OnOrder qty will be subtracted from the Qty To Order text box. This option is typically used if you want to create a PO from this page, and order from a vendor specifically to restock on FBA.
Predictive Restocking: Consider FC Transfer and FC Processing as reserved
  • For use in Predictive Purchasing when an FBA warehouse is marked as Sellable.
  • For use in Predictive Restocking for FBA even when a warehouse is marked as Unsellable.

FC transfer or FC processing means that Amazon places a reserve on merchandise already sent for various reasons. Enabling this will include that quantity as FBA Reserved Qty, which is subtracted from the calculated qty to restock FBA.

The Client Settings always Consider FBA Total Supply Quantity, and Download FBA Reserved inventory breakdown must also be enabled for the inventory to be calculated.

Predictive Restocking: Show main component qty For dependent kits, a new column will appear to show main component’s available qty.
Predictive Restocking: enable based on ship from warehouse For purchasing and FBA Restocking. Enables a warehouse selection to calculate deficit quantities/sales velocity based on a specific warehouse.
Predicted Restocking allow editing notes Add a Notes column to the Predicted Restocking grid. Saves text to the Master SKU field on the Product Home page.
Default Warehouse for Predicted Purchasing Restock After you choose a warehouse and save, the Avail Qty will show what is available for that warehouse, versus the total available quantity, when you do not select a warehouse.
Predicted Restocking: Use popup when adding to FBA shipment If enabled, a new tab will open when you use the action Add To FBA Shipment. This lets you keep your Predictive Restocking page open in a separate tab so that you can easily view and add SKUs to a shipment.
Predicted Restocking: Do not include Reserved in FBA Available Qty When enabled, the FBA Qty will not include FBA Reserved Qty.

Example: If total FBA Qty is 50, and 30 of that 50 is FBA Reserved Qty:

FBA Qty = 20
FBA Reserved Qty = 30

When not enabled, the FBA Qty includes FBA Reserved Qty.

Example: If total FBA Qty is 50, and 30 of that 50 is FBA Reserved Qty:
FBA Qty = 50
FBA Reserved Qty = 30

Predicted Restocking: Display All QtySold Columns The QtySold column is replaced with QtySold3, QtySold7, QtySold15, QtySold30, QtySold45, QtySold60, QtySold90, QtySold180, QtySold365.
Enable Projected Kit Quantity for FBA Predicted Restocking Shows a column Proj. Kit Qty that calculates the projected kit quantity, which is the amount that can be potentially assembled based on the units available for the components.

Generating a restock prediction

Learn how to generate a restock prediction in each interface by clicking the appropriate accordion below.

The accordion below will show you columns relevant to Step 6 in the following Alpha and Delta directions.
View columns (for step 6)


COLUMN

DESCRIPTION
ProductID

Delta: SKU

Alpha: Product ID

Preview Image

Displays the first image in the 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

The formal title of the product.
ASIN

Amazon standard identification number.

Site cost The cost/expenses of the product.

Selling Price

Price on the Amazon Health report 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

The 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 (Delta)

Avail. Qty (Alpha)

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 a 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 (Delta)

#FBA Sellers (Alpha)

The number of sellers on that ASIN who are fulfilling their inventory thru FBA.
Velocity

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

Qty Sold 3 (Delta)

QtySold (Alpha)

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 7

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 (Delta)

11/M (Alpha)

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 quantity than was calculated based on the regular velocity.

In Transit

FBA Inbound shipped but not yet received.

FBA Unshipped

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

Vendor

The default vendor on the product.
Available Qty for Kits

Kits being added to FBA must have an Independent inventory status. This means that its inventory quantity is independent of 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 

Alpha
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. Enable the Client Setting Predictive Restocking: enable warehouse filter to display a warehouse filter. The report will use the selected warehouse quantity as the Available Quantity.
  1. Click Inventory > Predicted Purchasing > Predictive Restocking for FBA.
  2. If the requirements above are met, 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 Days OF Order and Days TO Order.
  5. Filter as search as needed.
  6. Click Search to populate the grid with items with the columns in the accordion above. The grid will only show items Fulfilled by Amazon
Delta
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. Enable the Client Setting Predictive Restocking: enable warehouse filter to display a warehouse filter. The report will use the selected warehouse quantity as the Available Quantity.
  1. Click Purchasing > Predictive Restocking for FBA.
  2. If the requirements above are met, 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.
  5. Filter as search as needed.
  6. Click Search to populate the grid with items with the columns in the accordion above. The grid will only show items Fulfilled by Amazon

Customizing columns

In Delta, you can customize the columns that would appear in your search results. To make changes in the columns:

You can have a maximum of 10 columns displayed. If you want to add a new column, you will need to delete one from the list first.
  1. Click on the vertical ellipsis menu at the upper right corner > Customize Columns. A new window will appear containing the default columns and additional columns that you can add.
  2. Click on Add column > Scroll or type name in the Search field.
  3. Optional: Select a column by your choice > Apply to save the changes.
  4. Optional: Click on Cancel to abort action or click on Reset to get back to the default columns setting.
    Customizing columns for predictive restocking on FBA in Delta
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.

Exporting a predictive restocking report

You can create a scheduled task that automatically exports a predictive restocking Excel file to email or FTP. You can save the Excel file for future reference and documentation. Learn how to export a predictive restocking report in each interface by clicking the appropriate accordion below.

Alpha
  1. Go to Manage Inventory > Predicted Purchasing > Predictive Restocking for FBA > Search > Select the items you want to create a report for.
  2. Click the Select Action drop-down menu > Click Export to Excel > Go.

Export to Excel button

Delta
  1. Go to Purchasing > Predictive FBA Restocking > Search > Select the items you want.
  2. Go to the Action menu > Export To Excel.


Export all items to Excel


Adding to an FBA inbound shipment

If you’re selling products on any marketplace, you can use Amazon’s Fulfilled by Amazon (FBA) service to fulfill orders through Amazon. This saves time and can help grow your business by removing the burden of order logistics and fulfillment. The FBA service will handle the picking, packing, shipping, and customer service.

After your search results are displayed, follow the instructions below to add a product to an FBA inbound shipment:

  1. Select the products on the grid.
  2. Enter the amount you want to order in the Qty text field.
  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