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.

Required Data for Order CSV Imports

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

Import the CSV

CSV Order Upload Field Mapping

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.

Order Details

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.

Buyer Details

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

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: