Upload Order Data
Instructions:
- Download the Excel template using the button below
- Fill in your order and shipment data in the Order_Data sheet, following the template structure
- All mandatory fields are marked with red headers
- Optional fields are marked with blue headers
- Each row represents a combination of Order → Item
- Remove the sample data before uploading
- Upload your completed file using the form below
Help & Tips
Template Structure:
- Order_Data: All order, and item information (single sheet)
- Instructions: Detailed guidelines
Data Relationships:
-
OrderNumbergroups all items for an order
Required Formats:
- Dates: YYYY-MM-DD HH:MM
- Booleans: TRUE/FALSE
- Numbers: Decimal format
Examples:
- Order with 1 pickup and 2 stops, 1 order each, 2 items per order = 5 rows
- Order with 1 pickup stop (no orders) + 1 delivery stop (1 order, 2 items) = 3 rows
- Service stop with no orders = 1 row with order/item columns empty
Common Issues
- Ensure all mandatory fields are filled
- Use correct date format (YYYY-MM-DD HH:MM)
- Check that
LoadIdvalues match for all rows of the same order - Ensure
StopSequenceis sequential for each order - Verify
OrderNumberandItemLineNumberconsistency - Remove sample data before upload
- Save file in .xlsx format only