Operations
Order Export DetailsMore About the CSV Order Export
The CSV for Orders contains certain fields that are exported. These fields are listed below and are exported in a single line. Each one of these fields are headers in a column on the CSV. Using this you can export orders from your store. The UPS Worldship accepts the standard CSV export.
Currently, the CSV Order Export does not support product information in the export. If you wish to include product information in your export, the XML export includes this data.
Note: If you have an order where the customer has "Billing same as Shipping Address" selected, the CSV export will automatically fill out the required fields for export.
|
Field |
CSV Header |
|
Order Number |
OrderNumber |
|
Customer Name |
CustomerName |
|
Order Date |
OrderDate |
|
Total |
Total |
|
Tracking Number |
TrackingNumber |
|
Order Status |
OrderStatus |
|
Billing Company |
BillingCompany |
|
Billing First Name |
BillingFirstName |
|
Billing Last Name |
BillingLastName |
|
Billing Address 1 |
BillingAddress1 |
|
Billing Address 2 |
BillingAddress2 |
|
Billing City |
BillingCity |
|
Billing State |
BillingState |
|
Billing Postal Code |
BillingZipPostal |
|
Billing Phone |
BillingPhone |
|
Billing Country Name |
BillingCountryName |
|
Billing Country Abbreviation |
BillingCountryAbbr |
|
Shipping Company |
ShippingCompany |
|
Shipping First Name |
ShippingFirstName |
|
Shipping Last Name |
ShippingLastName |
|
Shipping Address 1 |
ShippingAddress1 |
|
Shipping Address 2 |
ShippingAddress2 |
|
Shipping City |
ShippingCity |
|
Shipping State |
ShippingState |
|
Shipping Zip Postal |
ShippingZipPostal |
|
Shipping Phone |
ShippingPhone |
|
Shipping Country Name |
ShippingCountryName |
|
Shipping Country Abbreviation |
ShippingCountryAbbr |
|
Shipping Method |
ShippingMethod |
|
Total Product Quantity |
TotalProductQty |
|
Archived Order |
IsArchived |
