| identifier | SINGLE | The identifier column to import Spreadsheet into a Datastore. | |
| OrderHeadOrderID | SINGLE | The ID of the order | |
| OrderHeadOrderTypeID | SINGLE | The ID of the order type. It is possible to define individual order types. | |
| OrderHeadOrderType | SINGLE | The name of order type. | |
| OrderHeadOrderStatus | SINGLE | The ID of the order status. | |
| OrderHeadResponsibleID | SINGLE | The user ID of the orders owner. | |
| OrderCreatedAt | SINGLE | The date that the order was created. | |
| OrderUpdatedAt | SINGLE | The date that the order was updated last. | |
| OrderCompletedAt | SINGLE | The date that the order was completed (alias of order date type ID = 5). | |
| OrderCreatedOnAt | SINGLE | The date that the order was created on (alias of order date type ID = 2). | |
| OrderPaidAt | SINGLE | The date that the order was paid (alias of order date type ID = 3). | |
| OrderReturnDate | SINGLE | The order Return date (alias of order date type ID = 6). | |
| OrderPaymentDueDate | SINGLE | The order payment due date (alias of order date type ID = 7). | |
| OrderEstimatedShippingDate | SINGLE | The estimated shipping date of this order (alias of order date type ID = 8). | |
| OrderEstimatedDeliveryDate | SINGLE | The possible / estimated delivery date (alias of order date type ID = 11). | |
| OrderDatesMap | SINGLE | All order dates as map(e.g. dateTypeId1=2023-11-03T21:42:46+01:00;dateTypeId2=2023-11-07T09:02:28+01:00;...). See https://developers.plentymarkets.com/en-gb/interface/stable7/Order.html#order_date_models for available date types. | |
| OrderPlentyID | SINGLE | The plenty ID of the client that the order belongs to. | |
| OrderHeadCustomerID | SINGLE | The ID of the contact (receiver contact) | |
| OrderCustomerAddressID | SINGLE | ID of Address for update. Leave empty to create a new address (CustomerID required). | |
| OrderCustomerAddressTypeID | SINGLE | TypeID can only be used for new addresses ('ID' column is empty) | |
| OrderCustomerAddressGender | SINGLE | The gender | |
| OrderCustomerAddressCompany | SINGLE | The name 1 field (defaults to: company name). | |
| OrderCustomerAddressFirstName | SINGLE | The name 2 field (defaults to: first name). | |
| OrderCustomerAddressSurname | SINGLE | The name 3 field (defaults to: last name). | |
| OrderCustomerAddressAdditionalName | SINGLE | The name 4 field (defaults to: c/o). | |
| OrderCustomerAddressStreet | SINGLE | The address 1 field (defaults to: street, 'PACKSTATION' or 'POSTFILIALE') | |
| OrderCustomerAddressHouseNumber | SINGLE | The address 2 field (defaults to: houseNumber, packstationNo) | |
| OrderCustomerAddressAdditionalAddress3 | SINGLE | The address 3 field (defaults to: additional) | |
| OrderCustomerAddressAdditionalAddress4 | SINGLE | The address 4 field is currently undefined and can be freely used. | |
| OrderCustomerAddressZIP | SINGLE | The postcode. | |
| OrderCustomerAddressCity | SINGLE | The town. | |
| OrderCustomerAddressCountryID | SINGLE | The ID of the country. | |
| OrderCustomerAddressStateID | SINGLE | The ID of the state. | |
| OrderCustomerAddressReadOnly | SINGLE | Flag that indicates if the data record is read only. | |
| OrderCustomerAddressContactPerson | SINGLE | The contact person option (alias for option with typeId 12). | |
| OrderCustomerAddressVATNumber | SINGLE | The tax id number (VAT number) option (alias for option with typeId 1). | |
| OrderCustomerAddressExternalAddressID | SINGLE | The external ID option (alias for option with typeId 2). | |
| OrderCustomerAddressEntryCertificate | SINGLE | The entry certificate (bool) option (alias for option with typeId 3). | |
| OrderCustomerAddressTelephone | SINGLE | The phone number option (alias for option with typeId 4). | |
| OrderCustomerAddressEmail | SINGLE | The email option (alias for option with typeId 5). | |
| OrderCustomerAddressPostnumber | SINGLE | The post number option (alias for option with typeId 6). | |
| OrderCustomerAddressPersonalID | SINGLE | The personal ID option (alias for option with typeId 7). | |
| OrderCustomerAddressBBFC | SINGLE | The BBFC/FSK option (alias for option with typeId 8). | |
| OrderCustomerAddressBirthday | SINGLE | The birthday option (alias for option with typeId 9). | |
| OrderCustomerAddressSessionID | SINGLE | The frontend session ID (alias for option with typeId 10). | |
| OrderCustomerAddressTitle | SINGLE | The title/salutation (alias for option with typeId 11). | |
| OrderCustomerAddressCheckedAt | SINGLE | The time the address was checked. | |
| OrderCustomerAddressCreatedAt | SINGLE | The time the address was created. | |
| OrderCustomerAddressUpdatedAt | SINGLE | The time the address was updated. | |
| OrderDeliveryAddressID | SINGLE | ID of Address for update. Leave empty to create a new address (CustomerID required). | |
| OrderDeliveryAddressTypeID | SINGLE | TypeID can only be used for new addresses ('ID' column is empty) | |
| OrderDeliveryAddressGender | SINGLE | The gender | |
| OrderDeliveryAddressCompany | SINGLE | The name 1 field (defaults to: company name). | |
| OrderDeliveryAddressFirstName | SINGLE | The name 2 field (defaults to: first name). | |
| OrderDeliveryAddressSurname | SINGLE | The name 3 field (defaults to: last name). | |
| OrderDeliveryAddressAdditionalName | SINGLE | The name 4 field (defaults to: c/o). | |
| OrderDeliveryAddressStreet | SINGLE | The address 1 field (defaults to: street, 'PACKSTATION' or 'POSTFILIALE') | |
| OrderDeliveryAddressHouseNumber | SINGLE | The address 2 field (defaults to: houseNumber, packstationNo) | |
| OrderDeliveryAddressAdditionalAddress3 | SINGLE | The address 3 field (defaults to: additional) | |
| OrderDeliveryAddressAdditionalAddress4 | SINGLE | The address 4 field is currently undefined and can be freely used. | |
| OrderDeliveryAddressZIP | SINGLE | The postcode. | |
| OrderDeliveryAddressCity | SINGLE | The town. | |
| OrderDeliveryAddressCountryID | SINGLE | The ID of the country. | |
| OrderDeliveryAddressStateID | SINGLE | The ID of the state. | |
| OrderDeliveryAddressReadOnly | SINGLE | Flag that indicates if the data record is read only. | |
| OrderDeliveryAddressContactPerson | SINGLE | The contact person option (alias for option with typeId 12). | |
| OrderDeliveryAddressVATNumber | SINGLE | The tax id number (VAT number) option (alias for option with typeId 1). | |
| OrderDeliveryAddressExternalAddressID | SINGLE | The external ID option (alias for option with typeId 2). | |
| OrderDeliveryAddressEntryCertificate | SINGLE | The entry certificate (bool) option (alias for option with typeId 3). | |
| OrderDeliveryAddressTelephone | SINGLE | The phone number option (alias for option with typeId 4). | |
| OrderDeliveryAddressEmail | SINGLE | The email option (alias for option with typeId 5). | |
| OrderDeliveryAddressPostnumber | SINGLE | The post number option (alias for option with typeId 6). | |
| OrderDeliveryAddressPersonalID | SINGLE | The personal ID option (alias for option with typeId 7). | |
| OrderDeliveryAddressBBFC | SINGLE | The BBFC/FSK option (alias for option with typeId 8). | |
| OrderDeliveryAddressBirthday | SINGLE | The birthday option (alias for option with typeId 9). | |
| OrderDeliveryAddressSessionID | SINGLE | The frontend session ID (alias for option with typeId 10). | |
| OrderDeliveryAddressTitle | SINGLE | The title/salutation (alias for option with typeId 11). | |
| OrderDeliveryAddressCheckedAt | SINGLE | The time the address was checked. | |
| OrderDeliveryAddressCreatedAt | SINGLE | The time the address was created. | |
| OrderDeliveryAddressUpdatedAt | SINGLE | The time the address was updated. | |
| OrderContactCustomerID | SINGLE | The ID of the contact. | |
| OrderContactExternalCustomerID | SINGLE | The external ID of the contact. | |
| OrderContactCustomerNumber | SINGLE | The number of the contact. | |
| OrderContactType | SINGLE | The ID of the contact type (see PlentyONE CRM - types settings). | |
| OrderContactFirstName | SINGLE | The first name of the contact. | |
| OrderContactSurname | SINGLE | The last name of the contact. | |
| OrderContactFullName | SINGLE | The full name of the contact. A concatenation of first and last name. | |
| OrderContactEmail | SINGLE | The private email address of the contact. | |
| OrderContactSecondaryEmail | SINGLE | The secondary private email address of the contact. | |
| OrderContactGender | SINGLE | The gender of the contact or interested party | |
| OrderContactFormOfAddress | SINGLE | The form of address for the contact. | |
| OrderContactNewsletter | SINGLE | The time the contact registered for the newsletter. | |
| OrderContactCustomerClass | SINGLE | The ID of the contact class. | |
| OrderContactIsBlocked | SINGLE | The blocked status of the contact. Contacts can be blocked for a specific client (store). | |
| OrderContactCustomerRating | SINGLE | The rating of the contact. This rating is for internal use only. 5 red stars are for the worst and 5 yellow stars for the best rating. | |
| OrderContactDebitorAccount | SINGLE | The book account (debitor account) of the contact. An additional, separate number that generally corresponds to the customer number or the debtor number in your financial accounting. | |
| OrderContactLanguage | SINGLE | The language of the contact. | |
| OrderContactReferrerID | SINGLE | The origin of the contact. | |
| OrderContactPlentyID | SINGLE | The client (store ID) that is assigned to the contact. | |
| OrderContactResponsibleID | SINGLE | The owner ID (user ID) of the contact. | |
| OrderContactDateOfBirth | SINGLE | The date of birth of the contact. | |
| OrderContactLastLogin | SINGLE | The date of the last login of the contact. | |
| OrderContactLastSalesOrder | SINGLE | The date of the last order. | |
| OrderContactCreatedAt | SINGLE | The date the contact was created. | |
| OrderContactUpdatedAt | SINGLE | The date the contact was last updated. | |
| OrderContactTelephone | SINGLE | The private phone number of the contact. | |
| OrderContactFax | SINGLE | The private fax number of the contact. | |
| OrderContactMobile | SINGLE | The private mobile phone number of the contact. | |
| OrderContactEbayName | SINGLE | The eBay account name of the contact. | |
| OrderContactPaypalEmail | SINGLE | The email address of the PayPal account of the contact. | |
| OrderContactPaypalPayerId | SINGLE | The PayPal payer id of the contact. | |
| OrderContactKlarnaPersonalId | SINGLE | The Klarna personal id of the contact. | |
| OrderContactPostident | SINGLE | The DHL PostIdent of the contact. | |
| OrderContactForumUsername | SINGLE | The user name of the contact in the forum. | |
| OrderContactForumGroupId | SINGLE | The ID of the forum group that is assigned to the contact. | |
| OrderContactSingleAccess | SINGLE | The access type of the contact. | |
| OrderContactContactPerson | SINGLE | The contact person of the contact. | |
| OrderContactMarketplacePartner | SINGLE | The marketplace partner status of the contact. | |
| OrderContactVAT_ID | SINGLE | The vat number of the contact. | |
| OrderContactAccountId | SINGLE | The ID of the account. | |
| OrderContactAccountNumber | SINGLE | The number of the account. | |
| OrderContactAccountCompanyName | SINGLE | The company name. | |
| OrderContactAccountTaxIdNumber | SINGLE | The ID of the tax number | |
| OrderContactAccountValuta | SINGLE | The valuta date in days specified for the account. | |
| OrderContactAccountDiscountDays | SINGLE | The early payment discount period in days specified for the account. | |
| OrderContactAccountDiscountPercent | SINGLE | The early payment discount in percent specified for the account. | |
| OrderContactAccountTimeForPaymentAllowedDays | SINGLE | The payment due date in days specified for the account. | |
| OrderContactAccountSalesRepresentativeContactId | SINGLE | The contact ID of the sales representative. | |
| OrderContactAccountUserId | SINGLE | The (user) ID of the account owner. | |
| OrderContactAccountDeliveryTime | SINGLE | The delivery time for the supplier. | |
| OrderContactAccountDealerMinOrderValue | SINGLE | The minimum order value for the supplier. | |
| OrderContactAccountSupplierCurrency | SINGLE | The currency used by a supplier. | |
| OrderContactAccountCreatedAt | SINGLE | The time the account was created. | |
| OrderContactAccountUpdatedAt | SINGLE | The time the account was updated. | |
| OrderHeadIsSystemCurrency | SINGLE | Flag that states if the current currency is the same as system currency or not. | |
| OrderHeadCurrency | SINGLE | The currency of the amounts. | |
| OrderHeadExchangeRatio | SINGLE | The exchange rate for converting the current currency into the system currency. | |
| OrderHeadIsNetto | SINGLE | Flag that states if the invoice is net or not. If the invoice is not net, it is gross. | |
| OrderHeadTotalNetto | SINGLE | The total net amount of the order. | |
| OrderHeadTotalBrutto | SINGLE | The total gross amount of the order. | |
| OrderHeadTotalVAT | SINGLE | The total vat amount of the order. | |
| OrderHeadTotalInvoice | SINGLE | The total invoice amount. | |
| OrderHeadPaidAmount | SINGLE | The order amount that is already paid. | |
| OrderHeadTaxlessAmount | SINGLE | The taxless amount of the order. Portion of the total invoice amount without taxes. | |
| OrderHeadPrepaidAmount | SINGLE | This is deprecated and will be removed in the next version. Please use GiftCardAmount instead. | |
| OrderHeadGiftCardAmount | SINGLE | The amount that comes from gift cards that were redeemed when placing the order. The gift cards amount does not reduce the invoice total, but reduces the amount that still needs to be paid. The amount that still needs to paid is not an own parameter because the amount can be calculated by subtracting the gift cards amount from the invoice total. | |
| OrderHeadWarehouseID | SINGLE | The ID of the warehouse (order property ID = 1). | |
| OrderHeadShippingProfileID | SINGLE | The ID of the orders shipping profile (order property ID = 2). | |
| OrderHeadMethodOfPaymentID | SINGLE | The ID of the orders payment method (order property ID = 3) | |
| OrderHeadPaymentStatus | SINGLE | The payment status of the order (order property ID = 4) | |
| OrderHeadPaymentIDs | MULTIPLEVALUE | Semmicolon separated payment IDs associated with the order. | |
| OrderHeadPaymentProperties | MAP | Map of payment properties associated with the order. | |
| OrderExternalShippingProfile | SINGLE | The external shipping profile of the order (order property ID = 5) | |
| OrderDocumentLanguage | SINGLE | The external shipping profile of the order (order property ID = 6) | |
| OrderHeadExternalOrderID | SINGLE | The external order ID of the order (order property ID = 7) | |
| OrderHeadCustomerReference | SINGLE | The customer sign of the order (order property ID = 8) | |
| OrderHeadDunningLevel | SINGLE | The dunning level of the order (order property ID = 9) | |
| OrderHeadSellerAccount | SINGLE | The seller account of the order (order property ID = 10) | |
| OrderHeadReferrerID | SINGLE | The referrer ID of the order. | |
| OrderHeadExternalDeliveryID | SINGLE | The external delivery id of the order (order property ID = 49) | |
| OrderHeadShippingCosts | SINGLE | The order gross shipping costs amount. | |
| OrderHeadShippingCostsNet | SINGLE | The order net shipping costs amount. | |
| OrderHeadMarking1ID | SINGLE | The order flag / marking id (order property ID = 15) | |
| OrderHeadCouponCode | SINGLE | The order coupon code (order property ID = 18) | |
| OrderHeadCouponType | SINGLE | The order coupon type (order property ID = 19) | |
| OrderHeadSalesTaxID | SINGLE | The order sales tax ID number (order property ID = 34) | |
| OrderHeadInvoiceNumber | SINGLE | The order main document number (order property ID = 33) | |
| OrderHeadPackageNumber | MULTIPLEVALUE | All package numbers associated with the order. | |
| OrderWeight | SINGLE | The order weight (order property ID = 11) | |
| OrderWidth | SINGLE | The order width (order property ID = 12) | |
| OrderLength | SINGLE | The order length (order property ID = 13) | |
| OrderHeight | SINGLE | The order height (order property ID = 14) | |
| OriginOrderID | SINGLE | The ID of the origin order. | |
| ParentOrderID | SINGLE | The ID of the parent order. | |
| OrderReferenceOrderIdMap | MAP | Map of orderReferences (referenceType=referenceOrderId). The orderReferences relation shows if an order is referencing another order. The referenceType specifies the relation to this order. The parent order is the order that the actual order was derived from (relevant for sub-orders, such as return, credit note, ...). | |
| OrderReferenceOriginOrderIdMap | MAP | Map of orderReferences (referenceType=originOrderId). The orderReferences relation shows if an order is referencing another order. The referenceType specifies the relation to this order. The originOrderId returns the ID of the original order (relevant for sub-orders, such as return, credit note, ...). | |
| OrderID | SINGLE | The ID of the order | |
| OrderProperties | MAP | All order properties as map (typeId=value). List of typeIds: https://developers.plentymarkets.com/en-gb/interface/stable7/Order.html#order_models_orderproperty | |
| OrderLocationID | SINGLE | The ID of the accounting location. | |
| OrderLocationCountryID | SINGLE | The ID of the country of the accounting location. | |
| OrderLocationName | SINGLE | The name of the accounting location. | |
| OrderLocationClientID | SINGLE | The ID of the client that the accounting location belongs to. | |
| OrderLocationPlentyID | SINGLE | The plenty ID of the client that the accounting location belongs to. | |
| OrderContactComments | SINGLE | All comments / notes of referenced contact. | |
| OrderComments | SINGLE | All comments / note of the order. | |
| OrderDocumentNumbers | MAP | Map of document type=document number associated with the order. | |
| OrderDocumentNumbersWithPrefix | MAP | Map of document type=document number with prefix associated with the order. | |
| OrderDocumentPaths | MAP | Map of document type=document path associated with the order. | |
| OrderDocumentIDs | MAP | Map of document type=document id associated with the order. | |
| TagIDs | MULTIPLEVALUE | The order tag IDs | |
| TagNames | MULTIPLEVALUE | The order tag names | |
| OriginOrderReferenceOrderIdMap | MAP | Map of originOrderReferences (referenceType=orderId). The originOrderReferences relation shows the reference to the origin order of this order. The referenceType specifies the relation to this order. | |
| ReverseOrderReferencesOrderIdMap | MAP | Map of reverserOrderReferences (referenceType=orderId). The reverseOrderReferences relation points to all orders that reference this order. The referenceType specifies the relation to this order. | |
| OrderItemsIdentifier | SINGLE | | |
| OrderItemsRowID | SINGLE | The ID of the order item. | |
| parent_identifier | SINGLE | The parent_identifier column to import Spreadsheet into a Datastore. | |
| OrderItemsOrderID | SINGLE | The ID of the order | |
| OrderItemsVariantID | SINGLE | Variation ID of the order item. | |
| OrderItemsItemText | SINGLE | The name of the order item. | |
| OrderItemsReferrerID | SINGLE | The ID of order item referrer. | |
| OrderItemsWarehouseID | SINGLE | The ID of the warehouse. | |
| OrderItemsTypeID | SINGLE | The ID of the order item type | |
| OrderItemsType | SINGLE | The name of order item type. | |
| OrderItemsQuantity | SINGLE | The quantity. | |
| OrderItemsVAT | SINGLE | The vat amount, e.g. 19.0 for 19% VAT. | |
| OrderItemsVATCountryID | SINGLE | The ID of the VAT configuration. | |
| OrderItemsVATField | SINGLE | The ID of the VAT rate's field. | |
| OrderItemsBundleRowID | SINGLE | The ID of the referenced bundle order item. | |
| OrderItemsParentOrderItemsID | SINGLE | The ID of the parent order item. | |
| OrderItemsEstimatedShippingDate | SINGLE | The estimated shipping date in W3C date format(yyyy-MM-dd'T'HH:mm:ssXXX) of the order item. | |
| OrderItemsWeight | SINGLE | The order items weight (order item property ID = 11) | |
| OrderItemsWidth | SINGLE | The order items width (order item property ID = 12) | |
| OrderItemsLength | SINGLE | The order items length (order item property ID = 13) | |
| OrderItemsAmountPriceBrutto | SINGLE | The total gross price including surcharges and discounts. | |
| OrderItemsAmountPriceNetto | SINGLE | The total net price including surcharges and discounts. | |
| OrderItemsAmountCurrency | SINGLE | The currency of the amounts. | |
| OrderItemsAmountSurcharge | SINGLE | The surcharge as gross amount. | |
| OrderItemsAmountDiscount | SINGLE | The discount can be a percentage or a fixed value. | |
| OrderItemsAmountPriceOriginalBrutto | SINGLE | The original gross price without any surcharges or discounts. | |
| OrderItemsAmountPriceOriginaNetto | SINGLE | The original net price without any surcharges or discounts. | |
| OrderItemsAmountIsSystemCurrency | SINGLE | Flag that indicates if the current currency is the same as the system currency or not. | |
| OrderItemsAmountExchangeRatio | SINGLE | The exchange rate for converting the current currency into the system currency. | |
| OrderItemsAmountPurchasePrice | SINGLE | The purchase price of the variation. | |
| OrderItemsExternalItemID | SINGLE | The order item external id (order item property ID = 17) | |
| OrderItemsVariantItemID | SINGLE | The item ID of the item that this variation belongs to. | |
| OrderItemsVariantMainVariantID | SINGLE | The variation ID of the item’s main variation. | |
| OrderItemsVariantIsMain | SINGLE | Flag that indicates if the variation is the main variation of the item. | |
| OrderItemsVariantNumber | SINGLE | The unique variation number of the variation. The variation number must be specified. | |
| OrderItemsVariantExternalItemID | SINGLE | The external variation ID of this variation. The external variation number is optional and allows importing items and variations from external systems to PlentyONE. | |
| OrderItemsVariantModel | SINGLE | The model of the variation. | |
| OrderItemsVariantName | SINGLE | The name of the variation. | |
| OrderItemsVariantBundleType | SINGLE | Indicates the bundle type of the variation. | |
| OrderItemsVariantAvailabilityID | SINGLE | The availability of the variation. Possible values: 1 to 10 | |
| OrderItemsVariantPurchasePrice | SINGLE | The net purchase price. Value e.g. is used for price calculations. | |
| OrderItemsVariantWidthMM | SINGLE | The width of the variation in millimetres (mm) | |
| OrderItemsVariantLengthMM | SINGLE | The length of the variation in millimeters (mm) | |
| OrderItemsVariantHeightMM | SINGLE | The height of the variation in millimetres (mm) | |
| OrderItemsVariantWeightG | SINGLE | The gross weight of the variation in gramms (g). This weight includes the packaging for variations that are packaged separately. | |
| OrderItemsVariantWeightNetG | SINGLE | The net weight of the variation in gramms (g). This is the weight of the variation without packaging. | |
| OrderItemsVariantCustomsTariffNumber | SINGLE | The customs tariff number of the variation. | |
| OrderItemsVariationBarcodes | MAP | All variation barcodes as map (BarcodeID=CodeValue;... e.g. 1=1243123;2=3446) | |
| OrderItemsID | SINGLE | The ID of the order item. | |
| OrderItemsReasonForReturn | SINGLE | The specified reason for return. | |
| OrderItemsReturnStatus | SINGLE | The status of return. | |
| OrderItemsProperties | MAP | All order item properties as map (typeId=value). List of typeIds: https://developers.plentymarkets.com/rest-doc/order_order_item_order_item_property/details#get-all-order-item-propertys-for-one-order-item-by-its-order-item-id | |
| OrderItemsOrderProperties | MAP | All order item order properties as map (propertyId=value) | |
| OrderItemsStorageLocationQuantity | MAP | All StorageLocations and quantity as map (storage location ID=quantity) | |
| OrderItemsStorageLocationBatch | MAP | All StorageLocations and batch as map (storage location ID=batch) | |
| OrderItemsStorageLocationBestBeforeDate | MAP | All StorageLocations and BestBeforeDate as map (storage location ID=BestBeforeDate) | |
