Importing Customer Orders from CSV File


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

twitteryoutube

Leave a Reply