Batches, FEFO, and alerts — how Foreshelf knows what expires and when.
A CSV with SKU, batch number, quantity, and expiry date is enough. The format is flexible: comma or semicolon separators, UTF-8 or Latin-1 encoding, multiple date formats, and French or English headers. A preview always appears before anything is written to the database.
FEFO (First Expired, First Out): each sale consumes the batch that expires soonest. It is applied automatically to every Shopify order, with no action required.
| Severity | Window |
|---|---|
| Critical | Fewer than 30 days before expiry |
| Warning | 30 to 60 days |
| Info | 60 to 90 days |
If you re-import an existing batch (same SKU and batch number), Foreshelf preserves units already sold — only the difference between the old and new total quantity is adjusted. A re-import never silently restores stock that was already sold.