Bulk Order Dispatching (CSV Upload)

The Bulk Order Dispatch Importer allows you to upload a CSV file to be processed 'in the background' in order to dispatch your orders.

This article describes how this system should be used and sets out it's intended behaviours and limitations.

📘

While this system does perform all standard dispatch procedures when dispatching the orders provided, it may not account for some custom dispatch procedures you have in place and so please check with your Aurora Commerce Account Manager before using it if you are uncertain.

Bulk Order Dispatching (CSV Upload)

This can be accessed from the Aurora Back-end in the Orders > Import > Dispatched Orders section of the Aurora Back-end and allows you to provide a filename to upload and an email address to be notified once it is complete.

Once uploaded, the import CSV file is queued in the Aurora Jobs System to be processed to help avoid large imports causing resources issues or browser time-outs.

Once it is completed, you will be not notified on the email address provided and you will be able to view the log of actions taken as a result of the import.

Format

The file uploaded must be a plain text CSV file without any special formatting or special characters. If either of these are present, the file may be rejected on upload.

Please see the following example CSV file that might be considered to be valid.

Order ID
1234
12345
123

Validation

When an import is uploaded to the Aurora Back-end, it is validated before it is queued for processing. This validation checks:

  • The first row of the CSV is a header row.
  • The Order ID column has been provided.
  • All of the Order ID's provided are valid integer figures, i.e. they are not text.
  • All of the Order ID's provided exists.

❗️

If any of the above is not true, then the entire file will be rejected and no orders will be updated at all. This is intended to prevent partial or potentially unintentional changes be made to the database.