Follow

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 fields are required if Full Name is not provided.

ORDER DETAILS

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 description 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
 

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
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

Comments

Please sign in to leave a comment.

Community browse

COMMUNITY FORUMS

Questions & Answers

Issues & Bugs

Beta Feedback

FEATURE REQUESTS

Productivity: Features, Interface & Settings

Partners: Integrations, Carriers & Stores

Shipping: Orders, Labels & Shipments

Inventory: Products, Purchase Orders & Suppliers