Import Variants
Standard - Basic standing order import (this page)
Standard with Order Reference - Adds order reference and termination fields
Named Bespoke vendor specific variant
Validation Rules
Customer Number must match an existing Location Reference
Product Code must match an existing Product Code
Customer must not be cancelled (Cancelled date must be NULL)
Customer's account must not be on hold
Start Date must be a valid date
At least one daily quantity should be greater than zero
CSV Field Specification
# | Field Name | Data Type | Required |
0 | Customer Number | String | Yes |
1 | Product Code | String | Yes |
2 | Product Name | String | No |
3 | Qty Monday | Decimal | No |
4 | Qty Tuesday | Decimal | No |
5 | Qty Wednesday | Decimal | No |
6 | Qty Thursday | Decimal | No |
7 | Qty Friday | Decimal | No |
8 | Qty Saturday | Decimal | No |
9 | Qty Sunday | Decimal | No |
10 | Start Date | Date | Yes |
11 | End Date | Date | Yes |
The import is accessible through the customer management area of the application.
Example CSV Data:
CUST001,MILK2PT,2 Pint Semi Skimmed,2,2,2,2,2,0,0,01/01/2025,31/12/2025 CUST001,BREAD01,White Bread,0,1,0,1,0,0,0,01/01/2025,31/12/2025 CUST002,MILK1PT,1 Pint Whole Milk,1,1,1,1,1,1,0,15/02/2025,31/12/2025