Upload Input Files
Upload all three files to proceed. Drag & drop or click to choose.
File 01
Total Order Sheet
Master retailer order file. Supports AW25 long format and SS26 wide/pivot format — auto-detected on upload.
File 02
Items Billed / Sold
Sales report of stock already billed. Expected sheet: Report. Headers on row 2 (row 1 is blank).
File 03
New Lot Stock
Stock received from company to be allocated. Columns auto-detected. Supports .xlsx and .xls formats.
Retailer Priority Order
Enter a rank number next to each retailer. Rank 1 receives stock first. List re-sorts automatically on input.
0 retailers loaded — Rank 1 = first to receive stock from each lot
Run Allocation Engine
Review the configuration below, then run the allocation.
Order File
—
—
Billed File
—
—
Lot File
—
—
Top Priority Retailers
Allocation Results
Review allocated stock and download output files.
Total Lot Stock
0
units in lot file
Allocated
0
units matched to orders
Unallocated / Leftover
0
units remaining
Retailers Served
0
of 0 total
Allocated Stock
| # | Retailer | Product Code | Style · Color | Category | Size | Ordered | Already Billed | Allocating | Remaining After |
|---|
Unallocated / Leftover Stock
| # | Product Code | Item Description | Size | Available in Lot | Unallocated Qty | Reason |
|---|
Download Output Files
Allocation Output
Complete allocation data with retailer summaries and leftover stock.
Allocation Detail
Summary by Retailer
Unallocated Stock
Order vs Billed Report
Full fulfilment breakdown with retailer and category summaries.
Full Fulfilment Detail
Summary by Retailer
Summary by Category