When you ship inventory to Walmart, there is a gap where the stock has left your warehouse but Walmart has not received it into WFS yet. That gap can last weeks or even months. In the meantime a local count comes up short, but the units are not in WFS either, so they fall through the cracks.
ConnectBooks handles this for you. We pull each shipment's status straight from Walmart and move your inventory through 3 warehouses so it shows where the stock actually is.
The 3 warehouses
Local Warehouse. Your stock on hand.
Transit Warehouse. Shipped, but not received by Walmart yet.
WFS Warehouse. Received by Walmart and ready to sell.
How it works
When Walmart marks a shipment as shipped, ConnectBooks moves those units from the Local Warehouse to the Transit Warehouse on its own.
Then, as Walmart receives units, ConnectBooks moves them from the Transit Warehouse to the WFS Warehouse. This happens each time ConnectBooks syncs with Walmart, until the shipment is fully received. So your In Transit balance shows what is still outstanding.
Turn it on
Go to Stores & Files, then Inventory Files, and click your file.
Click Inventory & Warehouse, then Edit.
Turn on Warehouse Tracking and WFS Shipments. You can't turn on WFS Shipments until Warehouse Tracking is on.
Click Manage Warehouses, set the WFS Warehouse, Local Warehouse and Transit Warehouse for each store, then click Save. Manage Warehouses shows only when Warehouse Tracking is on and a store is linked.
Transfer a shipment
New shipments transfer on their own when they ship. Older shipments are set to ignored. To transfer one, go to the WFS Shipments page, click the 3 dots next to it and choose Transfer. The shipment needs a ship date first.
Check on a shipment
To see a shipment's transfers, go to ConnectStock, then Warehouse Transfers, then Shipment Transfers.
The units moved from the Local Warehouse to the Transit Warehouse stay fixed. The units moved to the WFS Warehouse climb as Walmart receives them, until the shipment closes.
See everything
All transfers: ConnectStock, then Warehouse Transfers, then Shipment Transfers.
Inventory by warehouse, including In Transit: Reports, then Inventory, then Inventory Summary Report.
Frequently asked questions
Why can't I turn on WFS Shipments?
Turn on Warehouse Tracking first. You can't turn on WFS Shipments until it's on.
Why don't I see Manage Warehouses?
It shows only after you click Edit, and only when Warehouse Tracking is on and a store is linked to the file.
When do units move to the Transit Warehouse?
When Walmart marks the shipment as shipped. ConnectBooks moves the units on its own.