On this page
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.
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. (Note: We do not check notes for any special order instructions)
DeliveryService:
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
