How to format and upload order CSVs

How to format and upload order CSVs

In order to have your orders fulfilled by the warehouse you will need to upload CSV files of the orders your customers have made. 

Alternatively, if you have a Shopify store you can connect this directly to your Selazar account to have orders processed automatically.  To do this, please see How to Integrate Shopify with Selazar.

A template for CSVs and Instructions on the Datatypes can be found under the "Upload Order" tab of "Orders", we have also included links at the bottom of this page.

Before you begin if you are using Microsoft Excel for your CSVs please format your columns to text, especially for ProductIdentifier and DeliveryPhoneNumber, for the how and why please consult How to fix common CSV errors.

The CSV works on a One Product Per Row system, so if an order contains multiple products each one will go onto a new row. However, they must all share the same UniqueRetailerOrderID.


This is a unique identifier for the order, all rows with the same UROID will be considered part of the same order.  The UROID is decided by you and/or any automated system you already use.


This is the EAN or SUID of the product being ordered, this must match with the EAN or SUID of a product already listed under your "Products".


A SKU is only needed when multiple products share the same EAN, such as different colour variations of the same product.  If this is not needed it can just be left blank.


How many of the product has been ordered.


Name of the Customer who placed the order.


First line of the address of the Customer who placed the order.


More space for the Customer address.

Note: while AddressLine2 is optional, please do not overload AddressLine1 as it has a character limit (less than 35 characters).


Town of the Customer who placed the Order.


County of the Customer who placed the Order.


Postcode of the Customer who placed the Order.


The two character country code for the country of the Customer who placed the Order. 

For a full list of these please check Country Codes .



The phone number of the Customer who placed the Order.


The email address of the Customer who placed the Order.


This is for your own reference in the order upload. (Note: We do not check notes for any special order instructions)


The delivery Service the Customer has selected.

Once this is done it can be uploaded to the "Upload Order" tab under "Orders".

Useful Links

For general troubleshooting for CSVs please see CSV issues

Example CSV: Order CSV Template

Datatype Reference Sheet: Order CSV Data Reference