Slotting efficiency and location utilization at a glance
Assigned Locations by Zone
Item Velocity Distribution
Slot Score Summaryβ
Location Management
Seed all 9,000+ locations from your location report, or add/manage manually.
π₯ Seed from Report
ποΈ Bulk Add
π All Locations
Seed from All-Locations Report
π Drop your full location export here. Expects columns: Location Barcode, Dimensions (format: 150x48x50 = LΓWΓH in inches), optionally Pick Locn Area and an assigned item/SKU column.
Usable cube is auto-calculated at 55% utilization factor (LΓWΓH Γ· 1728 Γ 0.55). Handles 9,000+ rows.
π
Click or drag your All-Locations Report here
CSV or tab-delimited TXT β handles large files
Zone Assignment Rules (applied automatically at seed time)
βοΈ Enter area code prefixes to auto-assign zones and types when seeding. All unmatched locations default to Silver / Standard. You can edit any location individually in the All Locations tab afterward.
π‘ Zone rules use AREA:LEVEL format. Type rules use AREA, AREA:AISLE, or AREA:AISLE:BAY-BAY format.
β’ Zone examples: FA:C = Gold FA:B = Silver FA:A = Bronze
β’ Type examples: FA:09:01-20 = FA aisle 09 bays 01β20 β Crushable DD = all DD β Pallet Flow
Location ID structure: FA 09 39 D 05 β area=FA, aisle=09, bay=39, level=D, pos=05
Updates zone/type on every location in the database based on current rules above.
Bulk Location Generator
π‘ Generates IDs like FA0330A01 from Bank + Aisle + Bay + Level ranges. Levels can be alpha (AβE) or numeric (1β4).
Location ID
Area
Zone
Type
Usable Cube (ftΒ³)
LΓWΓH (in)
Assigned SKU
Actions
Import Daily / Weekly Reports
Drop any report below. Column headers are auto-detected β tab or comma delimited both work.
1 β Velocity Report
Daily
Key cols: Item Name Β· Item Bar Code Β· Item Unit Length/Width/Height Β· ORIG_ORDER_QTY Β· Display Location
Key cols: Location Β· Item Β· Desc Β· Status Β· Active Qty Β· Max Β· Min Β· Replen?
Rule: Status = "Discontinued" AND Active Qty = 0 β location freed
π«
Click or drag Disco / Zero Inventory Report
Skips title rows Β· handles "Disco Items with Inventory" header
3 β Open Pick Locations
Daily
Key cols: Pick Locn Area Β· Location Barcode Β· Work Area Β· Dimensions Β· Location Volume
Dimensions format: 150x48x50 (LΓWΓH inches)
π
Click or drag Open Pick Locations Report
Marks matched locations as open Β· adds new ones automatically
4 β Replenishment Count Report
Weekly
Key cols: Location (or SKU/Item) Β· Replen Count β 30-day replenishment events per slot. π‘ If using the Velocity Report above, Repln Tasks is already captured automatically β this drop zone is only needed if you have a separate standalone replen file.
π
Click or drag Replen Count Report
Accepts Location-based or SKU-based replen counts
Import Summary
Items Loaded
0
Open Locations
0
Disco Freed
0
Replen Alerts
0
Unslotted Items
0
Exact Column Reference (from your reports)
Velocity Report (tab-delimited)
Item Name Item Bar Code Item Merchandise Group
Item Unit Weight Item Unit Length Item Unit Width
Item Unit Height Pack Weight ON_HAND_QTY
ORIG_ORDER_QTY Display Location
Example row:
1016458 046985016247 160 0.16 2.1 2.1 3.8 1.56 6 [qty] FA0939D05
Disco / Zero Inventory (tab-delimited)
Location Pick Loc Slot Type Volume WG WA
Item Desc Status Merch Group Pick Zone
Active Qty Allocated Qty TBF Reserve Qty
Res Allocated Max Min Replen?
Freed when: Status="Discontinued" AND Active Qty=0
Open Pick Locations (tab-delimited)
Pick Locn Area Location Barcode
Work Area Dimensions Location Volume
Example:
DD DD5201A01 03 150x48x50 360,000
(Dimensions = L x W x H in inches)
All-Locations Seed Report
Location Barcode Pick Locn Area
Dimensions (150x48x50) Location Volume
[optional] Item/SKU column for pre-assigned slots
Replen Count Report:
Location or SKU Replen_Count (30-day total)
Slotting Engine
All items with velocity, cube match, and slot recommendations. π‘ Yellow = better slot available (+15 pts). π£ Purple = high replen count.
SKU
Description
Velocity
Item Cube (ftΒ³)
Current Slot
Recommended Slot
Score
Replens/30d
Action
Replenishment Alerts
Items generating high replenishment counts are undersized for their velocity. Move to a larger location to reduce labor cost.
High Replen Items β Move Candidates
SKU
Description
Current Location
Zone
Loc Cube (ftΒ³)
Item Cube (ftΒ³)
Fill %
Replens/30d
Suggested Larger Slot
Action
New Item Slotting
Enter a new item's dimensions and projected velocity to get the top 3 compatible slot recommendations.
Item Details
π
Fill in details and click Get Recommendations
Management Reports
Slotting efficiency, ergonomic pick rate analysis, and replenishment optimization.