Predictive Restocking for WFS

Predictive Restocking for WFS

Overview

The Predictive Restocking for Walmart Fulfillment Service (WFS) reporting feature calculates the number of products you need to send to Walmart to restock their fulfillment centers and meet the expected WFS orders volume for a time range. The projection is based on several factors, including the number of past sales for each product and the current available quantity. Past sales are used to determine the velocity or the rate of sales per day over a given date range. Velocity is then multiplied to calculate the deficit supply for multiple date ranges. This feature is similar to Predictive Purchasing. However, it focuses on selling SKUs and the amounts needed to restock WFS rather than determining general purchase quantities for all channels. Sellercloud’s predictive restocking feature:

To learn how to customize predictive stocking reports, see Customize Search Filters and Grid Columns.

Prerequisites and Settings

To be able to generate restocking predictions, ask Sellercloud Support to ensure that the services ProductQtySoldCalcuateServices and ProductInventoryMovementServiceis are running on your server.

In addition, you can enable the following Client Settings:

Key Terms and Examples

Refer to the table below for key predictive restocking terms:
TERM DEFINITION
Days OF Order Predictions are based on the number of sales in this time range.
Days TO Order The time range for which to calculate your product quantity Deficit.
Velocity The average sales per day within the selected Days OF Order time range. Calculation: Product Qty Sold within the Days OF Order time range, divided by the Days OF Order.
Deficit The predicted product inventory quantity deficit for the Days TO Order time range. Calculation: ( Velocity x Deficit Days) – ( WFS Available Qty + In Transit + WFS Unshipped). See the terms below:
- WFS Available Qty = Product quantity available in WFS warehouses in Sellercloud

- In Transit = Product quantity that is WFS Shipped, In Transit, or CheckedIn Receiving

- WFS Unshipped Qty = Product quantity in WFS shipments with a status of Saved, Previewed, or Working

For the examples below, let’s say that:

To calculate the Deficit 15 ( Your Deficit calculation for a 15-day period, Days TO Order = 15):

  1. Multiply the Velocity by the number of days.
  2. 2 x 15 = 30.
  3. Subtract the FBA Qty, the Unshipped Qty, and the In Transit Qty.
  4. 30 - (12 + 8 + 10) = 0
  5. This gives you a Deficit 15 of 0, which means there is no deficit quantity. You will be able to fulfill the same velocity of orders during the next 15 days.

To calculate the Deficit 30 ( Your Deficit calculation for a 30-day period, Days TO Order = 30):

  1. Multiply the Velocity by the number of days.
  2. 2 x 30 = 60.
  3. Subtract the FBA Qty, the Unshipped Qty, and the In Transit Qty.
  4. 60 - (12 + 8 + 10) = 30
  5. This gives you a Deficit 30 of 30, which means you need to order 30 units to have enough inventory to fulfill the same velocity of orders during the next 30 days.

Use Predictive Restocking

You can generate a re-stock prediction, add the products to a Purchase Order or a WFS Shipment Plan, and export the data to a file - all from the Predictive WFS Restocking page.

  1. Go to Purchasing > Tools > Predictive WFS Restocking.

  2. Set the Days OF Order and Days TO Order.

  3. You can add more filters to narrow down the scope of the report.

  4. Click Search.

  5. To send products to WFS, select them and click the Actions icon, then select Add to WFS Shipment Plan.

  6. To purchase products, select them and click the Actions icon, then select Add to PO.

  7. To export the report, click the Actions icon, then select Export to Excel.

Once you click Search to generate a report, you will see data in columns. Check the lists below for the definition of each column. There are three types of information you can see:

Product Information

Inventory Information

Pricing and Sales Information