Generate a Purchase Prediction
Purchasing predictions are generated automatically when the client setting Calculate Qty Sold in X days for Predicted Purchasing is enabled. This client setting is enabled by default.
Additionally, the service Product Inventory Movement Service must be running on the server. This service runs once daily around 2 AM.
To generate a Purchase Prediction:
- Go to Purchasing > Tools > Predictive Purchasing.
- Select the Days Of Order / Days To Order from their respective default filter dropdowns.
- Select Yes from the Show Only with Qty Ordered default filter.
- Click Search to populate the grid with items with the following columns:
| ProductID | The product SKU. |
| ProductName | The product name. |
| ASIN | Amazon Standard Identification Number |
| Avail. Local Qty | Quantity in all warehouses. |
| Qty To Order | Automatically populated. You can update this field manually by: Open the Action menu and choose Add to PO > Go. You will be prompted to create a new PO or add to existing. Choose your option and click Continue. |
| Velocity | Rate of sales per day. Calculated as Qty Sold in Days of Order divided by Days of Order. |
| Qty Sold | Quantity sold in the selected Days of Order. Based on the Client Setting above, it will calculate sales for the days the inventory was available. This means that if there were days within the selected Days of Order when there was no available inventory, those days will be skipped in the count. |
| Deficit Supply | The predicted deficit to your supply. This is calculated as follows: (Velocity x Days To Order) – (Available quantity + On Order). |
| 11 Mo | Quantity Sold in a given month for 11 months back. This can be helpful when trying to determine quantities to order 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 order for the coming seasonal month of December, this column will look back 11 months – to December – and display the quantity sold for the month of December. This can be used as an indicator if you need to order more quantity than was calculated based on the regular velocity. |
| On Order | Shows how many units are on open Purchase Orders. PO must be set as “Approved” to consider quantity “On Order.” It is critical for determining if a product needs to be ordered and, if so, how many units to purchase. After determining how many units are needed for the given time period, both the available quantity and OnOrder quantities are factored in to determine how many need to be ordered. Clicking the OnOrder Quantity will open the related PO. |
| Vendor | Default vendor for the product. |
| Vendor Price | Price for the default vendor. |
| Amazon BuyBox Price | Retail price of Amazon’s BuyBox. Many online sellers 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. |
- If the requirements above are not met, or if you want to calculate based on more recent data, select Generate Data for Sold Since Last Year from the Action menu. This will calculate data for all products in your catalog. Alternatively, you can select specific items on the grid and select Generate Data for Selected SKUs.