Warehouse slotting with a spreadsheet: rank SKUs, place the fast 20

Pull one order from your busiest shelf and time it: about 40 seconds of walking, 8 seconds of grabbing. At 640 picks a week, that walking is a part-time job you never hired. Bad slotting costs no dramatic failure, just a small tax on every pick, paid in steps. The fix is velocity-based slotting: rank your SKUs by how often they get picked, put the fastest ones closest to the pack bench, and let the slow tail live far away. It all runs in a spreadsheet, and below is a worked example for a 420-SKU stockroom with the arithmetic shown.

What slotting decides (and what your floor plan already decided)

Slotting answers one question: given the layout you have, which SKU goes in which bin? It is the last layer of three, and a fourth sits just beneath it. How a room is zoned — receiving, packing, overflow, aisle flow — is a floor-plan problem, covered in the small warehouse setup guide. How bins get their codes and labels is its own discipline, covered in the bin location labeling guide. And how deep each placed bin should run — how many selling days a forward-pick position holds before refilling — is the sibling question of pick face sizing, which takes placement as given and sizes what's inside it. This guide assumes the first two exist: aisles are laid out, bins have real codes, and the open question is which SKU lives where.

The case is arithmetic. Order picking is most of the labor in small-batch fulfillment, and most of that labor is walking rather than grabbing — which makes placement, not picker speed, the lever (Bartholdi & Hackman, Warehouse & Distribution Science, accessed November 2026). Among warehouse improvements, re-slotting by pick frequency is also among the cheapest: it requires no equipment and no software, only carton moves (Frazelle, World-Class Warehousing and Material Handling, accessed November 2026).

The one rule: fastest picks get the closest bins

Rank every SKU by picks per week and give the shortest walks to the highest ranks. Three bands, with illustrative round-trip times that include the grab:

• Band 1 — bench-adjacent. Shelving within a few steps of the pack bench; about 15 seconds per pick.
• Band 2 — mid racking. Down one aisle and back; about 30 seconds.
• Band 3 — the far wall and high shelves. About 45 seconds.

Time five real picks with a stopwatch and set your own constants — these are illustrative. Rank by picks, not revenue: a $6 enamel pin picked 40 times a week costs the floor more walking than a $90 yoga mat picked twice (illustrative prices). And one override sits above velocity: weight and bulk. Heavy items belong at waist height on the nearest safe rack regardless of grade — OSHA's materials handling guidance keeps heavy lifts between knuckle and shoulder height (OSHA, Materials Handling and Storage, accessed November 2026). A fast-but-heavy SKU gets the closest waist-height bin, not the closest high shelf.

A worked example: re-slotting a 420-SKU stockroom

Illustrative store: 420 SKUs across bike lights, hiking socks, enamel pins, and yoga mats; 640 picks a week, where a pick means pulling a SKU for an order. From the last 90 days of sales, the store grades its catalog into an ABC slice: sorted by weekly picks and accumulated, 38 SKUs reach 80% of all picks (grade A), the next 62 bring the running total to 95% (grade B), and the remaining 320 share the last 5% (grade C). The grading mechanics — cutoffs, re-grading cadence, why picks rather than revenue — belong to the ABC inventory analysis guide; slotting consumes the grades.

Grades map to bands:

The bench-adjacent band in this room holds 24 bin positions. The 20 fastest SKUs take 20 of them (the rule in the next section); the other 18 grade-A SKUs go into the nearest mid-racking bay; 4 bench positions stay open for seasonal rotation.

Before the re-slot, the top 20 SKUs — 352 picks a week, 55% of all picks (illustrative) — were landing 60 picks in band 1, 120 in band 2, and 172 in band 3. After, all 352 come from band 1. Weekly walking saved:

• 120 picks × (30 − 15) seconds = 1,800 seconds
• 172 picks × (45 − 15) seconds = 5,160 seconds
• Total: 6,960 seconds ≈ 116 minutes a week, roughly 97 hours across a 50-week selling year

All constants are illustrative — set yours from your own floor. The moves themselves cost about two staff-hours of carrying (estimated), spread across receiving days so nothing ships late.

The spreadsheet: seven columns and a sort

Five build steps:

1. Export sales by variant for the last 90 days from Shopify as a CSV (Shopify Help Center, accessed November 2026). Ninety days is about 13 weeks, so picks/week = units ÷ 13.
2. Sort descending by weekly picks and add the cumulative % column; grade at 80% and 95%.
3. Fill the current-bin column once. This is the slow, manual column — for 420 SKUs, an afternoon with the shelf map. It only needs doing properly one time.
4. Apply the band policy to get proposed bins, flagging weight and oversize overrides. Note MAT-YG-6MM above: the grade says A, but a yoga mat's cube says floor rack — size beats velocity, per the override rule.
5. Diff current against proposed. The differences are the move list.

One caveat worth knowing: Shopify's admin does not grade variants A through C natively as of November 2026, so the grade column is yours to fill — which is what the export-and-sort is for, since it produces the cumulative numbers slotting actually needs.

And one note on tooling: InventoryX is not planned to slot anything — V1 has no WMS or ABC features — but its per-SKU velocity counts only days the item was in stock, so weeks where a bestseller sat empty don't inflate a rank, and the Monday Buying List is already a shortlist ranked by days of cover — paste it into the sheet. The slotting decision itself stays a spreadsheet job.

The top-20 rule at the pack bench

Why 20 and not all 38 of grade A? The bench band physically fits about two dozen bins, crowding slows packing, and twenty is the number a picker memorizes without a map. Keep the band disciplined with three rules:

• Capacity first. The band must hold each SKU's normal shelf quantity. If a bestseller's bin empties every second day, give it a bigger bin rather than shrinking its on-hand — the depth arithmetic for that sizing call is pick face sizing.
• The band is selling stock, not reserve. Hold a few selling days of quantity in the bench bin and keep the reserve behind it — the working-stock-versus-reserve split follows the same logic as the floor-vs-backstock guide.
• Waist height wins ties. Two candidates for one bench bin: the heavier one gets it.

The band also works as an early-warning shelf: your 20 fastest SKUs get walked past dozens of times a day, so a bin running low is noticed at a glance instead of at checkout. That matters at the storefront too: a customer facing an empty shelf substitutes or walks, and the ones who walk often buy elsewhere.

The seasonal re-slotting ritual

Ranks drift as seasons and the catalog move, so slotting needs a ritual, not a memory. (The habit scaffolding around it — sort, set in order, sustain — is the 5S method applied to the same floor; the 5S warehouse guide runs it.)

• Quarterly re-rank (January, April, July, October). Rebuild the 90-day ranking, re-grade, and move what changed. Cap moves at roughly 10% of bins per pass — more than that and the team stops trusting their shelf map mid-quarter.
• One pre-season pass. Promote a category a band before its peak: bike lights climb from mid racking to the bench in early October for dark commutes and demote in January; hiking socks rise before the November gift rush; enamel pins stay put because they sell flat all year.
• Fold moves into receiving days. Carts are out and hands are already on the stock — the cheapest re-slot is the one that happens during putaway.
• Log every move. SKU, from-bin, to-bin, date, on one sheet tab. A SKU bouncing bands every quarter is sitting on a grade cutoff; settle it by size or shelf life, not by coin flip.

Four habits keep those moves cheap:

• Relabel before the move. The bin label is the source of truth; a relocated SKU sitting under its old label is worse than an unmoved SKU. Print and place the new code first, move the cartons second — the labeling mechanics live in the bin location labeling guide.
• One-way moves per pass. Each SKU moves at most once per quarterly pass; whatever a bin didn't earn this round waits for the next one.
• New SKUs start in band 2. A launch SKU with no sales history earns the bench with 90 days of data, not on enthusiasm.
• Two hands on the heavy stuff. Any move that needs a proper lift is a two-person job or a floor-rack destination, not a high-shelf one.

Common questions

What is warehouse slotting? Deciding which bin each SKU lives in. Velocity-based slotting ranks SKUs by picks per week and puts the fastest closest to the pack bench and the slow tail furthest away. The goal is fewer seconds of walking per order — measured with a stopwatch, not judged by how tidy the room looks.

How often should a small warehouse re-slot? Quarterly is enough for most stores: rebuild the 90-day ranking and move only what changed, capped near 10% of bins. Add one pre-season pass for categories with a known peak. A full re-slot of every bin is rarely needed once the grade bands exist.

Do I need slotting software? No, up to a few thousand SKUs. The method is one sales export, seven columns, and a sort; the manual part is writing current bins once. Dedicated warehouse software earns its cost mainly in multi-shift operations moving thousands of picks a day, which most Shopify stores are not.

What is the ABC slice in slotting? A grade computed from picks rather than revenue: sort SKUs by weekly picks, accumulate the share, and cut at 80% (grade A) and 95% (grade B), leaving the rest as C. The slice decides placement — A near the bench, C on the far wall.

When size and speed disagree, which bin wins? Size and safety win. Heavy or bulky SKUs go at waist height on the nearest safe rack regardless of velocity, since OSHA's guidance keeps heavy lifts between knuckle and shoulder height. Velocity ranks only the items that are safe to place anywhere.

Next step

One number sorts a small floor: the step count from pack bench to your fastest SKU's bin. Pick that SKU today, count the steps, and if it's more than about 20, fix it: print the new bin label first (the code format is in the bin location labeling guide), then move the stock to the nearest bench bin. One SKU tonight makes the spreadsheet real tomorrow.