Note: For up-to-date guides on using Delivrd, please refer to official Delivrd documentation.
This how-to guide explains how to import customer orders from a CSV file. Importing orders from a file allows you to easily integrate Delivrd, the free online order fulfillment & inventory management solution, with your different sales channel through a single, simple interface.
Before you begin creating a customer orders import file, you should understand how customer orders are created in Delivrd and the lifecycle of these orders. We recommend you watch the video, too:
Now we can move on to explaining how a customer orders file should be created.
Customer Order File Straucture
For Delivrd to be able to import an orders file, the file’s strcuture must be exactly as explained in this guide.
Delivrd imports order data from CSV files. That means that each data field is separated by a comma. Here’s an example of how several orders in a CSV order import file might look like:
0,Name,Street,City,Zip,StateProvince,Country,RefOrder,RequestedDate,SalesChannel,ShippingCosts,LineNumber,SKU,Quantity,Value
1,”Roy Carter”,”2 Highclere”,Ascot,”Windsor and Maidenhead”,SL5,GB,9LODY2C8,2015-08-14,Ebay,7.6,10,296738,3,2.3
2,”Marie Anderson”,”34 Cowane Street”,Stirling,Stirling,”FK8 1JR”,GB,7KAY4M9D,2015-08-14,eBay,9.9,10,602498605714,3,5
3,”Paul Hicks”,”1014 Chester Road”,Birmingham,”West Midlands”,”B24 0LL”,GB,43SMFBXT,2015-08-14,eBay,9.2,10,159546,3,0.35
Header Line: the first line is a header line and is not imported into Delivrd. Each field in this line contains a description of the data of each field in the order lines.
Order Lines: an order data line should contain: Name, Street, City,Zip, StateProvince, Country, RefOrder, RequestedDate, SalesChannel, ShippingCosts, LineNumber, SKU, Quantity, Value
Here’s a useful table describing the different data fields in the orders import file
| Field Name | Description | Data Type | Length | Example | Remarks |
|---|---|---|---|---|---|
| ImportLineNumber | Number of line in order file | Number | from 0-number of lines in file | 0 1 2 etc. |
In the header line, you can specify value = 0 |
| Name | Customer Name | Text | 255 | Henry Rhodes | |
| Street | Street Address | Text | 1028 | 1014 Chester Road | Should contain complete street information |
| City | City | Text | 255 | Birmingham | |
| Zip | Zip code | Text or Numbers | 255 | B24 0LL 90210 |
|
| StateProvince | State or Province | Text | 255 | West Midlands NY New South Wales Rhône-Alpes |
For addresses in the U.S.A., enter two letters state abbreviation |
| Country | Country iso code 2 letters | Text | 2 | GB US AU FR |
According to ISO 3166-1 alpha-2 standard |
| RefOrder | Order number from the marketplace or from your e-commerce website. | Text | 255 | 231647283960 106-1129021-9005857 |
For example, if the order originated from Amazon, Reference order number would be Amazon's order number. |
| RequestedDate | Date the order is requested by customer | Date | 8 | 2015-08-14 | |
| SalesChannel | Sales Channel the order came from | Text | 255 | eBay Amazon Shopify |
You must create this sales channel in Delivrd's Sales channel list. |
| ShippingCosts | The amount the customer paid for shipping charges for this order. | Number with decimals | 8 | 3.2 | |
| LineNumber | Line number of customer order | Number | 8 | 10 20 30 |
If order has only one product, line would be 10. If another product was ordered in that same order, next line should be 20, next product line 30 etc. |
| SKU | SKU number in Delivrd's product data | Text | 255 | 541365 12365 SPN5046A |
|
| Quantity | Quantity ordered | Number | 8 | 1 3 50 |
|
| Value | Price of a single piece of the product ordered. | Number with decimals | 8 | 35.2 20 |
|
You can download a sample customer orders file from here:
Video tutorial: upload customer orders to Delivrd, review and relase