Moving from Excel to a warehouse system: what to prepare
Moving from spreadsheets to a WMS goes smoothly when your product data is clean first: one code and barcode per product, a bin for each, and a supplier where you reorder. Then connect your channels, test on sample orders before real ones, and train the team on the real screens.
1. Clean up your product list
Every product needs one unique code (SKU) and, ideally, its barcode (EAN). This is the step most often underestimated. Look for:
- The same product under two codes, often from two shops.
- Products without a barcode, which will need a printed label.
- Codes that differ between your shop and your marketplaces.
- Old products that no longer sell and can be archived.
2. Map the warehouse
Decide your location codes (rack, shelf, bin) and write down where each product lives. You do not need to rearrange the warehouse first; you need to record it as it is. Print and stick bin labels before go-live, not during it.
This is also a good moment for a full count, so the stock you load into the new system is right from the first day.
3. Suppliers and purchasing data
For each product, note who you buy it from, the purchase price and the pack size. Without a supplier, a product cannot be proposed for reorder. If you have purchase orders still open, list them so the goods can be received properly when they arrive.
Note each product's minimum stock too, even roughly. It can be refined later, but without it nothing tells you when to reorder.
4. Connect your channels, then test
Connect your shops, marketplaces, couriers and invoicing one at a time. Check that products match between each channel and the warehouse by SKU or EAN, and fix the ones that do not.
Never let a fresh connection touch real orders straight away. Run test orders through the whole path, from order to picking, packing, label and invoice, and set a start date from which real orders flow. Keep the old spreadsheet available for the first days in case you need to compare.
5. Train on the real screens
Train people on the job they will do, with your own products, on the device they will hold. Pickers need picking and skipping; packers need packing and labels; the office needs orders, receiving and stock. Short sessions on the real screens teach more than a long demonstration.
Pick a quieter week to go live, and have someone who knows the system on the floor for the first days.
The first weeks after go-live
Expect small surprises: a product without a barcode, a bin that was never labelled, a delivery option no one mapped to a courier. Keep a shared list of them and clear it every day. Most come up in the first week and then stop.
After a few weeks, count the racks that gave the most trouble, review the stock levels you set for reordering, and ask the floor what still slows them down. The spreadsheet can be retired once nobody has opened it for a while.
- Do not keep updating the old spreadsheet in parallel; two sources of truth is the problem you are leaving.
- Give each person their own account, so every action has a name from day one.