How to format and upload order CSVs


On this page

How to format and upload order CSVs

Useful links


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. 

If you have a Shopify or WooCommerce 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, or How to integrate with WooCommerce with Selazar

A template for CSVs and Instructions can be found on the Upload Order tab on the Orders page.




Before you begin, if you are using Microsoft Excel for your CSVs please format your columns to text.

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.

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.

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

SKUCode:

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.

Count:

How many of the product 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 (Optional):

More space for the Customer address.

While AddressLine2 is optional, AddressLine1 has a character limit (35 or less characters).

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 full list of these, please see 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:

This is for your own reference in the order upload.

We do not check notes for any special order instructions

DeliveryService:

The delivery Service the Customer has selected.

Next Steps:

Once you have created the order CSV file and saved it, you are now ready to upload. On the Selazar portal, navigate to Orders > Upload Order

Useful Links


For general troubleshooting for CSVs please see CSV issues

Example CSV: Order CSV Template

Datatype Reference Sheet: Order CSV Data Reference