CSV Order Uploads: Column mapping - required fields & explanations

Created:   |   Updated:

When it comes to mapping your CSV columns to ShippingEasy, follow this simple guide for an explanation of each field.

NOTE: Fields marked in red are required. First and Last Name are required if Full Name is not provided.


ShippingEasy Column
Column Definition
*Order Number

Order number/identifier

Order date & time Date & Time that the order was created
Ensure 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
Subtotal Inc. Tax Total amount paid by customer inc. tax
Requested service The specific service requested by customer
Shipping cost Shipping amount paid by 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 Location Your location/identifier of the order within the warehouse


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
Related articles:

How to: Create a CSV file
How to: Import orders via CSV file
How to: Export tracking numbers back to my original CSV file
How to: Check CSV uploads for duplicates and delete them
How to: Merge multiple columns of data in Excel without losing any dat

If you have problems that require extra assistance, feel free to reach out to our team.

Anyone can post questions in the comments, to the left, and the ShippingEasy Customer Success team will gladly assist.

ShippingEasy accounts on a paid plan will find additional resources in the upper left corner in app.

1-512 | Email | Chat

Fully registered accounts may email, call, or chat with our team.
Trial accounts may email or call.


Please sign in to leave a comment.

Community    browse  


Questions & Answers

Issues & Bugs