Import Orders via CSV | How To
Run a store on a platform we do not currently support? No problem!
ShippingEasy allows you to import orders with a simple CSV upload tool. All you need to do is export your orders into a CSV file format from your store platform or point-of-sale system. Most shopping carts and marketplaces have this option available to you.
Download the Sample CSV to use as an Order CSV template!
If you are new to creating CSV files, review our Create a CSV File help article first.
Requires a Basic Plan or Higher
This feature is available only for those on the Basic plan or higher. Discover what's included in each plan.
Even if you don’t have the option to Export Orders from your selling channel, you can assemble a CSV file from scratch. Just be sure to include at least the following pieces of information:
-
Order Number
-
Item Name
-
Customer First and Last Name
-
Shipping Address
The Shipping Address must be separated into a column for each part: Street Address column, City column, State column, and Zip Code column.
While not required, we strongly suggest that you also include the following information:
-
Item Quantity
-
Item Weight
-
Customer Email Address
When mapping your CSV columns to ShippingEasy, follow this simple guide for an explanation of each field. CSV files uploaded to ShippingEasy can have a maximum size of 3MB.
Required Fields
Fields marked with an asterisk (*) are required.
First and Last Name are required if Full Name is not provided.
ShippingEasy Column |
Column Definition |
---|---|
*Order Number |
Order number/identifier You must set the Order Number to the same value for orders with multiple line items or if a customer has ordered from your store more than once and would like to combine these orders. This unique identifier will allow us to 'merge' these two rows together upon upload. |
Order date & time |
Date & Time that the order was createdEnsure dates are in US format MM/DD/YY |
Order date |
Date that the order was created |
Order time |
Time that the order was created |
Status |
Order status within your eCommerce store |
Order Total |
Total amount paid by customer inc. tax |
Requested service |
The specific service requested by the customer |
Shipping cost |
Shipping amount paid by the customer |
Custom 1 |
[Additional custom data field] |
Custom 2 |
[Additional custom data field] |
Custom 3 |
[Additional custom data field] |
*Item name |
Name/Description of the items in the order |
Item SKU |
SKU related to the items in the order |
Item unit price |
Price of the items in the order |
Item Quantity |
Quantity of items in the order |
Item unit weight (oz) |
Weight of the items in the order (oz) Ensure your file has converted all weights to oz and uses whole numbers or decimals only. |
Warehouse Bin |
Your location/identifier of the order within the warehouse |
Importer Customs ID |
Available only on accounts that have Global Post Plus support. |
ShippingEasy Column |
Column Definition |
---|---|
*Full Name |
Full name of order recipient |
First Name |
First name of order recipient |
Last Name |
Last name of order recipient |
*Address Line 1 |
Street address of the order destination |
Address Line 2 |
Atl. Street address of the order destination |
*City |
City of the order destination |
*State/Province |
State or Province of the order destination (standard abbreviations are recommended) |
* Zip code |
Zip code of the order destination |
Country |
Country name for the order destination |
Company |
Company name of order recipient |
|
Email address of order recipient |
Phone |
Phone number of order recipient |
Notes |
Customer comment for the order |
Comments
Add a Comment
Article is closed for comments.
Tags: