Generate a Restock FBA Prediction
Before you generate Restock Predictions, do the following:
- Enable the Calculate Qty Sold in X days for Predicted Purchasing client setting.
- Ensure that ProductInventoryMovementServiceis running on the server. It runs daily at around 2:00 AM.
To generate Restock Predictions:
- Go to Purchasing > Tools > Predictive FBA Restocking.
- Select Days of Order and Days to Order.
- Click Search to populate the grid with items. The grid will only show items Fulfilled by Amazon.
| COLUMN | DESCRIPTION |
| ProductID | SKU |
| 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 for 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 | 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. |
| FBA Qty | The current FBA quantity available for sale at FBA. |
| FBA Reserved Qty | By default, Sellercloud will only import the quantity reserved because it has been ordered by a customer. |
| Qty | Quantity 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 | The number of sellers on that ASIN that are fulfilling their inventory through FBA. |
| Velocity | Rate of sales per day. This is calculated as 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 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 | Quantity 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 of the previous year – 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. 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. |
- However, if the requirements are not met, or if you want to calculate based on more recent data, click Generate Data for Sold Since Last Year from the Action menu. This 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.