Amazon and Walmart use warehouse management systems (WMS) with pick-path optimization algorithms to shave seconds off every order. Small eBay sellers can capture 70% of the same benefit with a spreadsheet and disciplined batch picking. Here's the playbook.
The problem — random-order picking is slow
Default seller workflow: print label for order 1, walk to bin A, pick item, walk back, print label for order 2, walk to bin C, pick item, walk back. Repeated across 30 orders/day, you're walking miles of unnecessary distance.
Measured: single-order picking averages 4-6 minutes per order for a 500-SKU warehouse. Half that time is walking.
Batch picking basics
Print all pending order labels at once. Sort them by bin location, not order sequence. Pick everything in one warehouse loop, then return to packing station and match items to labels.
Measured result: batch picking reduces per-order time from 4-6 minutes to 2.5-3.5 minutes. That's 30-40% savings just from batching.
Zone layout
Divide your warehouse into zones by frequency:
Zone A (hot): top 20% of SKUs by sales volume. Should be closest to packing station.
Zone B (warm): middle 30% of SKUs by volume.
Zone C (cold): bottom 50% of SKUs. Furthest from packing but rarely visited.
ABC classification is straightforward from your eBay sales report. Reallocate physical bins quarterly as SKU velocity shifts.
The spreadsheet setup
Google Sheets or Excel. Two tabs:
Bin master: SKU | Bin location | Zone | Current stock.
Pick queue: Order ID | SKU | Bin location | Zone | Picked flag.
Before starting your daily pick session, dump all pending orders into the pick queue. Sort by zone, then by bin. Print in that order. Walk once through zone A, once through B, once through C. Done.
Cart discipline
Use a picking cart with divided sections (one per order). Never mix items across orders during pick. Match items to labels at packing station, not during pick — takes concentration away from walking efficiently.
Batch size math
Larger batches = more time-efficient per order but delay first order out. Trade-off:
Batch 5 orders: shortest wait per order, minimal batch efficiency gain.
Batch 10-15 orders: sweet spot for most sellers. First order ships within 30-45 min of receipt; all orders shipped within 2 hours.
Batch 30+: efficient but early orders wait 2+ hours before shipping. Only viable if you have strict cutoff-time batching.
Zone density mapping
Beyond ABC classification, map bin density. High-density zones (10+ SKUs per meter of aisle) minimize walking. Low-density zones (bulky items, one SKU per meter) require dedicated trips.
Aim for hot-zone density above 15 SKUs per meter. Cold zone can be lower — you visit it less often.
When you actually need a WMS
Above 100 orders/day sustained, spreadsheet batch picking hits scaling limits. Signals:
- Multi-picker coordination needed (WMS assigns picks to specific staff)
- Location accuracy drops (SKU actually in wrong bin, spreadsheet doesn't know)
- Bin location updates lag (moved SKU but spreadsheet not updated)
WMS software: $200-1,000/month depending on scale. Above 100 orders/day, ROI is clear. Below, spreadsheet + discipline outperforms complexity.
Profitio's warehouse module includes bin locations, batch pick generation, and pick-path optimization. 14-day free trial.