When importing orders/stops from a CSV file, you can now include custom items associated with these stops, including their quantities and weights. In order to import item data, your CSV file will need to include three additional columns: Quantity, Name, and Weight (per item). These item quantities and weights will also be included in route constraints if you have the Max items per stop route option enabled.
To import an order with multiple different types of items, add additional rows for each additional item and leave the other columns blank. From the CSV import mapping page, ensure that the Group adjacent items across blank rows into a single delivery stop checkbox is selected, and the three new columns are mapped to the appropriate fields; you can also configure the unit type your weight value is in:
Here is an example spreadsheet showing an order with multiple item rows, and two orders with single item rows:
When the example spreadsheet shown above is imported into EasyRoutes, customers and items will be parsed as follows:
- Michael Gauthier: 5x Skateboard, 1x Baseball Hat, 2x Sunglasses; Total Weight: 12.7kg
- Liam Anderson: 1x Basketball; Total Weight: 600g
- Barry Cook: 10x Hockey Puck; Total Weight: 1.7kg
See this support article for full details on working with stops and items imported via CSV.