Route CSV Upload

Accessing the Feature

You can upload routes via CSV from two places in the dashboard.

From the Dispatch screen:

1. Click on Dispatch in the left navigation bar.
2. Click on Upload routes via CSV.

From the Orders page:

1. Click on Orders in the left navigation bar.
2. Click Bulk upload in the top-right area of the page.
3. From the dropdown select Import Orders & Routes via CSV

Download the Template

Before preparing your file, download the official Burq CSV template from within the upload modal by clicking Download sample CSV template. The header row must be present and columns must appear in the correct order — the file will be rejected if any header is missing or out of sequence.

• Dimensions template — uses numeric length, width, height, and weight fields for precise item and order dimensions. Required when dispatching to freight DSPs such as GoShare.

Note: Do not rename, reorder, or delete any column headers from the template. Even optional columns must remain in the file — leave them blank if unused.

CSV Field Reference

The table below covers every column in the standard template. See Route-Specific Fields for columns unique to those scenarios.

Route-Specific Fields

The three columns below tell Burq to group orders into a route. They work as a set — if any one of them is present on a row, all three must be provided. Leave all three blank on rows that should be created as individual orders rather than routes.

Important: All orders for a route must be included in the same CSV file. If the actual row count for a route reference does not match the declared External Order Count, the entire file is rejected. Splitting a route across multiple uploads is not supported.

Example: A 3-Stop Route

The rows below show how three orders are linked into a single route. Each row carries the same External Route Reference and External Order Count, and a unique External Stop Sequence.

Uploading Your File

1. From Dispatch, click Upload routes via CSV. From Orders, click Bulk Upload.
2. Select your file. Click Select file or drag and drop your CSV onto the upload area. The file must be 1 MB or smaller and use the .csv extension.
3. Click Import. Burq validates the file structure immediately. If any required headers are missing or a route validation rule is violated, the upload is rejected before processing begins and an error message is shown.
4. Monitor processing. Once accepted, orders are created row by row in the background and routes will be created. Click View import history (via the same dropdown) to track progress and review any row-level errors.

Tracking Upload Status

Each upload creates an import job you can monitor from the Import history view. Click View import history from the Dispatch dropdown or the Orders page to see all past uploads.

Successfully created orders appear immediately in the Dispatch Unassigned Orders list. Once all orders for a route are processed, the route is created automatically and visible under Planning.

Error Reference