Follow

What data fields can I import for my orders via a CSV file?

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 denote required fields.
ShippingEasy Column Column Definition
ORDER DETAILS
*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
*Item description Name/Description of the order item
Item SKU SKU related to the order item
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
*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
* Zip code Zip code of the order destination
Country Country name for the order destination
Company Company name of order recipient
Email Emaill address of order recipient
Phone Phone number of order recipient
Notes Internal notes for the order
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.

Comments

Please sign in to leave a comment.

  • Avatar
    Christina Stolle

    There name of the "Subtotal Inc. Tax" column is misleading. When providing a value for this column, it is instead imported as the Order Total (which includes shipping) and the real "Subtotal Inc. Tax" is calculated as this amount minus "Shipping cost". The column name should be renamed and the description should probably read "Total amount paid by customer inc. tax and shipping"



Community    browse  

COMMUNITY FORUMS
FEATURE REQUESTS

Questions & Answers

Issues & Bugs

Productivity

Partners

Shipping

Inventory

Marketing