| identifier | SINGLE | The identifier column to import Spreadsheet into a Datastore. | |
| Id | SINGLE | Unique identity of order. | |
| OrderNumber | SINGLE | Unique number associated with every order. | |
| AutoIncrement | SINGLE | Internal field. | |
| OrderDateTime | SINGLE | Timestamp when the order was placed. | |
| BillingAddressId | SINGLE | Unique identity of address. | |
| BillingAddressCountryId | SINGLE | Unique identity of country. | |
| BillingAddressCountryStateId | SINGLE | Unique identity of state. | |
| BillingAddressSalutationId | SINGLE | Unique identity of salutation. | |
| BillingAddressFirstName | SINGLE | First name of the customer. | |
| BillingAddressLastName | SINGLE | Last name of the customer. | |
| BillingAddressStreet | SINGLE | Street address. | |
| BillingAddressZipcode | SINGLE | Zip code of the country. | |
| BillingAddressCity | SINGLE | Name of the city. | |
| BillingAddressCompany | SINGLE | Name of the company. | |
| BillingAddressDepartment | SINGLE | Name of the department. | |
| BillingAddressTitle | SINGLE | Title name given to customer like DR., Prof., etc. | |
| BillingAddressVatId | SINGLE | Unique identity of VAT. | |
| BillingAddressPhoneNumber | SINGLE | Phone number of the customer. | |
| BillingAddressAdditionalAddressLine1 | SINGLE | Additional address input if necessary. | |
| BillingAddressAdditionalAddressLine2 | SINGLE | Additional address input if necessary. | |
| BillingAddressCreatedAt | SINGLE | Created at timestamp. | |
| BillingAddressUpdatedAt | SINGLE | Last updated timestamp. | |
| ShippingAddressId | SINGLE | Unique identity of address. | |
| ShippingAddressCountryId | SINGLE | Unique identity of country. | |
| ShippingAddressCountryStateId | SINGLE | Unique identity of state. | |
| ShippingAddressSalutationId | SINGLE | Unique identity of salutation. | |
| ShippingAddressFirstName | SINGLE | First name of the customer. | |
| ShippingAddressLastName | SINGLE | Last name of the customer. | |
| ShippingAddressStreet | SINGLE | Street address. | |
| ShippingAddressZipcode | SINGLE | Zip code of the country. | |
| ShippingAddressCity | SINGLE | Name of the city. | |
| ShippingAddressCompany | SINGLE | Name of the company. | |
| ShippingAddressDepartment | SINGLE | Name of the department. | |
| ShippingAddressTitle | SINGLE | Title name given to customer like DR., Prof., etc. | |
| ShippingAddressVatId | SINGLE | Unique identity of VAT. | |
| ShippingAddressPhoneNumber | SINGLE | Phone number of the customer. | |
| ShippingAddressAdditionalAddressLine1 | SINGLE | Additional address input if necessary. | |
| ShippingAddressAdditionalAddressLine2 | SINGLE | Additional address input if necessary. | |
| ShippingAddressCreatedAt | SINGLE | Created at timestamp. | |
| ShippingAddressUpdatedAt | SINGLE | Last updated timestamp. | |
| CurrencyId | SINGLE | Unique identity of the currency. | |
| CurrencyFactor | SINGLE | Rate at which currency is exchanged. | |
| LanguageId | SINGLE | Unique identity of language. | |
| SalesChannelId | SINGLE | Unique identity of the sales channel. | |
| PriceNetPrice | SINGLE | | |
| PricePositionPrice | SINGLE | | |
| PriceTotalPrice | SINGLE | | |
| PriceRawTotal | SINGLE | | |
| PriceTaxStatus | SINGLE | | |
| PriceTaxRulesTaxRate | SINGLE | | |
| PriceTaxRulesPercentage | SINGLE | | |
| PriceCalculatedTaxTax | SINGLE | | |
| PriceCalculatedTaxTaxRate | SINGLE | | |
| PriceCalculatedTaxPrice | SINGLE | | |
| AffiliateCode | SINGLE | An affiliate code is an identification option with which website operators can mark outgoing links. | |
| AmountTotal | SINGLE | Gross price of the order. | |
| AmountNet | SINGLE | Net price of the order. | |
| PositionPrice | SINGLE | Price of each line item in the cart multiplied by its quantity excluding charges like shipping cost, rules, taxes etc. | |
| TaxStatus | SINGLE | TaxStatus takes Free, Net or Gross as values. | |
| DeepLinkCode | SINGLE | It is a generated special code linked to email. It is used to access orders placed by guest customers. | |
| CampaignCode | SINGLE | A campaign code is the globally unique identifier for a campaign. | |
| Source | SINGLE | Source of orders either via normal order placement or subscriptions. | |
| CreatedById | SINGLE | Unique identity of createdBy. | |
| CreatedAt | SINGLE | Created at timestamp. | |
| UpdatedAt | SINGLE | Last updated timestamp. | |
| UpdatedById | SINGLE | Unique identity of updatedBy. | |
| VersionId | SINGLE | Unique identity of order version. | |
| ShippingCostUnitPrice | SINGLE | | |
| ShippingCostTotalPrice | SINGLE | | |
| ShippingCostQuantity | SINGLE | | |
| ShippingCostCalculatedTaxesTax | SINGLE | | |
| ShippingCostCalculatedTaxesTaxRate | SINGLE | | |
| ShippingCostCalculatedTaxesPrice | SINGLE | | |
| ShippingCostTaxRulesTaxRate | SINGLE | | |
| ShippingCostTaxRulesPercentage | SINGLE | | |
| CustomFields | MAP | | |
| StateId | SINGLE | | |
| StateName | SINGLE | | |
| StateTechnicalName | SINGLE | | |
| StateStateMachineId | SINGLE | | |
| StateCreatedAt | SINGLE | | |
| StateUpdatedAt | SINGLE | | |
| CustomerId | SINGLE | Unique identity of order customer. | |
| CustomerEmail | SINGLE | Email address of the customer. | |
| CustomerSalutationId | SINGLE | Unique identity of salutation. | |
| CustomerFirstName | SINGLE | First name of the customer. | |
| CustomerLastName | SINGLE | Last name of the customer. | |
| CustomerTitle | SINGLE | Title name given to the customer like Dr, prof. etc. | |
| CustomerCompany | SINGLE | Name of the company. | |
| CustomerCustomerNumber | SINGLE | Unique number assigned to the customer. | |
| CustomerCustomerId | SINGLE | Unique identity of customer. | |
| CustomerVatIds | MULTIPLEVALUE | Unique identity of VAT. | |
| CustomerCreatedAt | SINGLE | | |
| CustomerUpdatedAt | SINGLE | | |
| CustomerComment | SINGLE | | |
| InternalComment | SINGLE | | |
| TransactionsId | SINGLE | | |
| TransactionsPaymentMethodId | SINGLE | | |
| TransactionsPaymentMethod | SINGLE | | |
| TransactionsPaymentMethodPluginId | SINGLE | | |
| TransactionsPaymentMethodName | SINGLE | | |
| TransactionsPaymentMethodDescription | SINGLE | | |
| TransactionsPaymentMethodPosition | SINGLE | | |
| TransactionsPaymentMethodActive | SINGLE | | |
| TransactionsPaymentMethodAfterOrderEnabled | SINGLE | | |
| TransactionsPaymentMethodPlugin | SINGLE | | |
| TransactionsPaymentMethodSalesChannelDefaultAssignments | SINGLE | | |
| TransactionsPaymentMethodAvailabilityRule | SINGLE | | |
| TransactionsPaymentMethodAvailabilityRuleId | SINGLE | | |
| TransactionsPaymentMethodVersionId | SINGLE | | |
| TransactionsCreatedAt | SINGLE | | |
| TransactionsUpdatedAt | SINGLE | | |
| TransactionsStateId | SINGLE | | |
| TransactionsStateName | SINGLE | | |
| TransactionsStateTechnicalName | SINGLE | | |
| TransactionsStateStateMachineId | SINGLE | | |
| TransactionsStateCreatedAt | SINGLE | | |
| TransactionsStateUpdatedAt | SINGLE | | |
| TransactionsCustomFields | MAP | | |
| DeliveriesId | SINGLE | Unique identity of Order's delivery. | |
| DeliveriesShippingOrderAddressId | SINGLE | Unique identity of order's shipping address. | |
| DeliveriesShippingMethodId | SINGLE | Unique identity of shipping method. | |
| DeliveriesTrackingCodes | MULTIPLEVALUE | The delivery tracking codes as semicolon separated list. | |
| DeliveriesCreatedAt | SINGLE | | |
| DeliveriesUpdatedAt | SINGLE | | |
| DeliveriesStateId | SINGLE | | |
| DeliveriesStateName | SINGLE | | |
| DeliveriesStateTechnicalName | SINGLE | | |
| DeliveriesStateStateMachineId | SINGLE | | |
| DeliveriesStateCreatedAt | SINGLE | | |
| DeliveriesStateUpdatedAt | SINGLE | | |
| DeliveriesShippingDateEarliest | SINGLE | | |
| DeliveriesShippingDateLatest | SINGLE | | |
| ItemDatastoreIdentifier | SINGLE | | |
| ItemId | SINGLE | Unique identity of OrderLineItem. | |
| ItemType | SINGLE | Type refers to the entity type of an item whether it is product or promotion for instance. | |
| parent_identifier | SINGLE | The parent_identifier column to import Spreadsheet into a Datastore. | |
| ItemOrderId | SINGLE | Unique identity of order. | |
| ItemPosition | SINGLE | Position of line items placed in an order. | |
| ItemIdentifier | SINGLE | It is a unique identity of an item in cart before its converted to an order. | |
| ItemProductId | SINGLE | Unique identity of product. | |
| ItemReferencedId | SINGLE | Unique identity of type of entity. | |
| ItemQuantity | SINGLE | Number of items of product. | |
| ItemLabel | SINGLE | It is a typical product name given to the line item. | |
| ItemDescription | SINGLE | Description of line items in an order. | |
| ItemGood | SINGLE | When set to true, it indicates the line item is physical else it is virtual. | |
| ItemRemovable | SINGLE | Allows the line item to be removable from the cart when set to true. | |
| ItemCoverId | SINGLE | Unique identity of cover image. | |
| ItemStackable | SINGLE | Allows to change the quantity of the line item when set to true. | |
| ItemPriceUnitPrice | SINGLE | Price of product per item (where, quantity=1). | |
| ItemPriceQuantity | SINGLE | Number of items of each product. | |
| ItemPriceTotalPrice | SINGLE | Cost of product based on quantity. | |
| ItemPriceTaxRulesTaxRate | SINGLE | | |
| ItemPriceTaxRulesPercentage | SINGLE | | |
| ItemPriceCalculatedTaxesTax | SINGLE | | |
| ItemPriceCalculatedTaxesTaxRate | SINGLE | | |
| ItemPriceCalculatedTaxesPrice | SINGLE | | |
| ItemPriceListPrice | SINGLE | | |
| ItemPriceListPricePrice | SINGLE | List Price of each line item. | |
| ItemPriceListPriceDiscount | SINGLE | Absolute discount on each line item. | |
| ItemPriceListPricePercentage | SINGLE | Discount in percentage. | |
| ItemPriceIsCalculated | SINGLE | | |
| ItemPriceDefinitionPrice | SINGLE | | |
| ItemPriceDefinitionQuantity | SINGLE | | |
| ItemPriceDefinitionIsCalculated | SINGLE | | |
| ItemPriceDefinitionPrecision | SINGLE | | |
| ItemPriceDefinitionType | SINGLE | | |
| ItemPayloadProductNumber | SINGLE | | |
| ItemPayloadProductId | SINGLE | | |
| ItemPayloadAddBackToStock | SINGLE | | |
| ItemPayloadCredited | SINGLE | | |
| ItemCustomFields | MAP | | |
| ItemCreatedAt | SINGLE | | |
| ItemUpdatedAt | SINGLE | | |
