EcommerceOrders
A list of an account's ecommerce orders.
Columns
Name
Type
ReadOnly
Description
StoreId [KEY]
String
True
The StoreId for the table.
Id [KEY]
String
True
A unique identifier for the order.
Customer
String
False
Information about a specific customer. Orders for existing customers should include only the id parameter in the customer object body.
CampaignId [KEY]
String
False
A string that uniquely identifies the campaign associated with an order.
FinancialStatus
String
False
The order status. For example: `refunded`, `processing`, `cancelled`, etc.
FulfillmentStatus
String
False
The fulfillment status for the order. For example: `partial`, `fulfilled`, etc.
CurrencyCode
String
False
The three-letter ISO 4217 code for the currency that the store accepts.
OrderTotal
Decimal
False
The order total for the order.
TaxTotal
Decimal
False
The tax total for the order.
ShippingTotal
Decimal
False
The shipping total for the order.
TrackingCode
String
False
The MailChimp tracking code for the order. Uses the 'mc_tc' parameter in eCommerce360-enabled tracking urls.
ProcessedAtForeign
Datetime
False
The date and time the order was processed.
CancelledAtForeign
Datetime
False
The date and time the order was cancelled.
UpdatedAtForeign
Datetime
False
The date and time the order was updated.
ShippingAddress_Name
String
False
The name associated with an order's shipping address.
ShippingAddress_Address1
String
False
The shipping address for the order.
ShippingAddress_Address2
String
False
An additional field for the shipping address.
ShippingAddress_City
String
False
The city in the order's shipping address.
ShippingAddress_Province
String
False
The state or normalized province in the order's shipping address.
ShippingAddress_ProvinceCode
String
False
The two-letter code for the province or state the order's shipping address is located in.
ShippingAddress_PostalCode
String
False
The postal or zip code in the order's shipping address.
ShippingAddress_Country
String
False
The country in the order's shipping address.
ShippingAddress_CountryCode
String
False
The two-letter code for the country in the shipping address.
ShippingAddress_Longitude
Double
False
The longitude for the shipping address location.
ShippingAddress_Latitude
Double
False
The latitude for the shipping address location.
ShippingAddress_Phone
String
False
The phone number for the order's shipping address
ShippingAddress_Company
String
False
The company associated with an order's shipping address.
BillingAddress_Name
String
False
The name associated with an order's billing address.
BillingAddress_Address1
String
False
The billing address for the order.
BillingAddress_Address2
String
False
An additional field for the billing address.
BillingAddress_City
String
False
The city in the billing address.
BillingAddress_Province
String
False
The state or normalized province in the billing address.
BillingAddress_ProvinceCode
String
False
The two-letter code for the province or state in the billing address.
BillingAddress_PostalCode
String
False
The postal or zip code in the billing address.
BillingAddress_Country
String
False
The country in the billing address.
BillingAddress_CountryCode
String
False
The two-letter code for the country in the billing address.
BillingAddress_Longitude
Double
False
The longitude for the billing address location.
BillingAddress_Latitude
Double
False
The latitude for the billing address location.
BillingAddress_Phone
String
False
The phone number for the billing address.
BillingAddress_Company
String
False
The company associated with the billing address.
Lines
String
False
An array of the order's line items.
Last updated