Alpha Backorder List Import
Mark supplier-ordered products with an availability date so quotes and sales orders show when they can be delivered
Backorder List
Some products are not held in your own stock; they are ordered from the supplier per order and only become available from a future date. Alpha tracks this with two product fields:
| Field | Meaning |
|---|---|
| Sourcing type | STOCK (fulfilled from own inventory) or BACKORDER (supplier-ordered) |
| Available from | The date a backorder product can be delivered |
Importing a backorder list flags the matched products as BACKORDER and sets their Available from date. From then on, selecting such a product warns the user and the date is shown on the offer.
Importing the list
Go to Products → Import Backorder List (the calendar icon next to the Excel import). Drag a CSV or Excel file, then confirm. After the import you get a summary of how many products were updated and which rows could not be matched.
Use the Excel template or CSV template buttons in the dialog to download a ready-made example file.
File format
Two columns (headers are case-insensitive):
| Column | Required | Notes |
|---|---|---|
Reference | Yes | Matched against the product Reference, then SKU, then product id |
Available From | Yes | yyyy-MM-dd (e.g. 2026-09-15) or Dutch dd-MM-yyyy (e.g. 15-09-2026); native Excel date cells also work |
Example (CSV, semicolon-delimited as Dutch Excel exports):
Reference;Available From
ART-1001;2026-09-15
ART-1002;01-12-2026Rows whose reference matches no product, or whose date cannot be parsed, are listed as unmatched in the import summary and skipped; the rest of the import still completes.
Where the warning appears
- Sales order editor: when you add a product that is only available from a future date, a confirmation asks whether to add it anyway. The line then shows a warning icon with a tooltip (
Available from {date}). - Offer (estimate): backorder lines show a
Beschikbaar vanaf {date}/Available from {date}note under the description, so the customer knows the item is on backorder.
The availability date on the offer is a snapshot taken when the product is added to the offer, so it stays stable even if the product is later updated.