SPAR Pick List Generator
FEFO Β· CATEGORY RULES Β· ORDER-DRIVEN PICKING
βœ“ Saved WareX
1 Upload files

Upload both the inventory report and the order file. Both are required to generate a pick list.

πŸ“¦ Inventory report

Auto-detects SKU Code, Prod Stat Code, Expire Date, Net QTY, Location, dates (supports full WMS inventory export).

πŸ“‹ Order file

Pre-Issue format: SKU Code, Prod Stat Code, Quantity Sold, Category (+ Invoice/Order/Customer optional)
Category values: IR  Corporate  General

2 Order summary
Order lines: 0 Picked: 0 / 0

Click Pick All Orders to auto-allocate the entire uploaded order at once, or click any single row to pick it manually. Each line applies its own category rule (IR β‰₯ 50% shelf life, Corporate > 30 days) and picks FEFO. Comments update after picking.

Live filter (SKU, order no, location, comment…)
Pick status
Category
Line # Order No Deliver Loc SKU Product Status Category Order Qty Picked Qty Balance Pick Status Applied Rule Comment
Load an order file to see order lines
3 Pick screen

Inventory lines are filtered to match SKU + Product Status + Expiry. Shelf life rule is auto-applied by category.

SKU *
β–Ό
Product status filter
Min shelf life % *
Min days to expire (Corporate)
Required qty *
SKU
β€”
Status filter
β€”
Total lines
0
Total Net QTY
0
Eligible
0
In pick list
0
Below SL%
0
Zero qty
0
No match
0
Picked so far
0
Remaining need
β€”
4 Pick list report
Lines: 0 Total qty: 0