(If you are looking help with CSVs in a general sense your issue may be resolved here: [Beware Excel and CSV issues] )


Example CSV: [Order CSV Template]

Datatype Reference Sheet: [Order CSV Data Reference]


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 to your Selazar account to have orders processed automatically, for how to do this see: [Selazar-Shopify Intergration placeholder link].


A template for your CSVs and Instructions on the Datatypes can be found under the "Upload Order" tab of "Orders"

Alternately they are linked at the top of this page.


Before you start 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 [Beware Excel and CSV issues].


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


UniqueRetailerOrderID:

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

ProductIdentifier:

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 you "Products".

SKUCode:

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

Count:

How many of the item has been ordered.

DeliveryName:

Name of the Customer who placed the order.

DeliveryAddressLine1:

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

DeliveryAddressLine2:

More space for the Customer address, 

Note: while AddressLine2 is optional, please do not cram too much into AddressLine1 as it does have a character limit.

DeliveryAddressTown:

Town of the Customer who placed the Order.

DeliveryAddressCounty:

County of the Customer who placed the Order.

DeliveryAddressPostcode:

Postcode of the Customer who placed the Order.

DeliveryCountryCode:

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

For a list of these check: [Country Codes]. 

DeliveryPhoneNumber:

The phone number of the Customer who placed the Order.

DeliveryEmailAddress:

The email address of the Customer who placed the Order.

Notes:

Field for if the Customer has left any special delivery instructions.

DeliveryService:

The delivery Service the Customer has selected.


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