| identifier | SINGLE | The identifier column to import Spreadsheet into a Datastore. | |
| CustomerID | SINGLE | The ID of the contact. | |
| ExternalCustomerID | SINGLE | The external ID of the contact. | |
| CustomerNumber | SINGLE | The number of the contact. | |
| Type | SINGLE | The ID of the contact type (see PlentyONE CRM - types settings). | |
| FirstName | SINGLE | The first name of the contact. | |
| Surname | SINGLE | The last name of the contact. | |
| FullName | SINGLE | The full name of the contact. A concatenation of first and last name. | |
| Email | SINGLE | The private email address of the contact. | |
| SecondaryEmail | SINGLE | The secondary private email address of the contact. | |
| Gender | SINGLE | The gender of the contact or interested party | |
| FormOfAddress | SINGLE | The form of address for the contact. | |
| Newsletter | SINGLE | The time the contact registered for the newsletter. | |
| CustomerClass | SINGLE | The ID of the contact class. | |
| IsBlocked | SINGLE | The blocked status of the contact. Contacts can be blocked for a specific client (store). | |
| CustomerRating | 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. | |
| DebitorAccount | 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. | |
| Language | SINGLE | The language of the contact. | |
| ReferrerID | SINGLE | The origin of the contact. | |
| PlentyID | SINGLE | The client (store ID) that is assigned to the contact. | |
| ResponsibleID | SINGLE | The owner ID (user ID) of the contact. | |
| DateOfBirth | SINGLE | The date of birth of the contact. | |
| LastLogin | SINGLE | The date of the last login of the contact. | |
| LastSalesOrder | SINGLE | The date of the last order. | |
| CreatedAt | SINGLE | The date the contact was created. | |
| UpdatedAt | SINGLE | The date the contact was last updated. | |
| Telephone | SINGLE | The private phone number of the contact. | |
| Fax | SINGLE | The private fax number of the contact. | |
| Mobile | SINGLE | The private mobile phone number of the contact. | |
| EbayName | SINGLE | The eBay account name of the contact. | |
| PaypalEmail | SINGLE | The email address of the PayPal account of the contact. | |
| PaypalPayerId | SINGLE | The PayPal payer id of the contact. | |
| KlarnaPersonalId | SINGLE | The Klarna personal id of the contact. | |
| Postident | SINGLE | The DHL PostIdent of the contact. | |
| ForumUsername | SINGLE | The user name of the contact in the forum. | |
| ForumGroupId | SINGLE | The ID of the forum group that is assigned to the contact. | |
| SingleAccess | SINGLE | The access type of the contact. | |
| ContactPerson | SINGLE | The contact person of the contact. | |
| MarketplacePartner | SINGLE | The marketplace partner status of the contact. | |
| SalesRepresentativeContactID | SINGLE | The salesRepresentative ID of the contact | |
| InvoiceAllowed | SINGLE | True, if invoice payment is allowed. | |
| DebitAllowed | SINGLE | True, if debit payment is allowed. | |
| AllowedMethodsOfPayment | MULTIPLEVALUE | Semicolon separated list of all allowed payment method IDs | |
| VAT_ID | SINGLE | The vat number of the contact. | |
| BillingAddress_ID | SINGLE | ID of Address for update. Leave empty to create a new address (CustomerID required). | |
| BillingAddress_TypeID | SINGLE | TypeID can only be used for new addresses ('ID' column is empty) | |
| BillingAddress_Gender | SINGLE | The gender | |
| BillingAddress_Company | SINGLE | The name 1 field (defaults to: company name). | |
| BillingAddress_FirstName | SINGLE | The name 2 field (defaults to: first name). | |
| BillingAddress_Surname | SINGLE | The name 3 field (defaults to: last name). | |
| BillingAddress_AdditionalName | SINGLE | The name 4 field (defaults to: c/o). | |
| BillingAddress_Street | SINGLE | The address 1 field (defaults to: street, 'PACKSTATION' or 'POSTFILIALE') | |
| BillingAddress_HouseNumber | SINGLE | The address 2 field (defaults to: houseNumber, packstationNo) | |
| BillingAddress_AdditionalAddress3 | SINGLE | The address 3 field (defaults to: additional) | |
| BillingAddress_AdditionalAddress4 | SINGLE | The address 4 field is currently undefined and can be freely used. | |
| BillingAddress_ZIP | SINGLE | The postcode. | |
| BillingAddress_City | SINGLE | The town. | |
| BillingAddress_CountryID | SINGLE | The ID of the country. | |
| BillingAddress_StateID | SINGLE | The ID of the state. | |
| BillingAddress_ReadOnly | SINGLE | Flag that indicates if the data record is read only. | |
| BillingAddress_ContactPerson | SINGLE | The contact person option (alias for option with typeId 12). | |
| BillingAddress_VATNumber | SINGLE | The tax id number (VAT number) option (alias for option with typeId 1). | |
| BillingAddress_ExternalAddressID | SINGLE | The external ID option (alias for option with typeId 2). | |
| BillingAddress_EntryCertificate | SINGLE | The entry certificate (bool) option (alias for option with typeId 3). | |
| BillingAddress_Telephone | SINGLE | The phone number option (alias for option with typeId 4). | |
| BillingAddress_Email | SINGLE | The email option (alias for option with typeId 5). | |
| BillingAddress_Postnumber | SINGLE | The post number option (alias for option with typeId 6). | |
| BillingAddress_PersonalID | SINGLE | The personal ID option (alias for option with typeId 7). | |
| BillingAddress_BBFC | SINGLE | The BBFC/FSK option (alias for option with typeId 8). | |
| BillingAddress_Birthday | SINGLE | The birthday option (alias for option with typeId 9). | |
| BillingAddress_SessionID | SINGLE | The frontend session ID (alias for option with typeId 10). | |
| BillingAddress_Title | SINGLE | The title/salutation (alias for option with typeId 11). | |
| BillingAddress_CheckedAt | SINGLE | The time the address was checked. | |
| BillingAddress_CreatedAt | SINGLE | The time the address was created. | |
| BillingAddress_UpdatedAt | SINGLE | The time the address was updated. | |
| DeliveryAddress_ID | SINGLE | ID of Address for update. Leave empty to create a new address (CustomerID required). | |
| DeliveryAddress_TypeID | SINGLE | TypeID can only be used for new addresses ('ID' column is empty) | |
| DeliveryAddress_Gender | SINGLE | The gender | |
| DeliveryAddress_Company | SINGLE | The name 1 field (defaults to: company name). | |
| DeliveryAddress_FirstName | SINGLE | The name 2 field (defaults to: first name). | |
| DeliveryAddress_Surname | SINGLE | The name 3 field (defaults to: last name). | |
| DeliveryAddress_AdditionalName | SINGLE | The name 4 field (defaults to: c/o). | |
| DeliveryAddress_Street | SINGLE | The address 1 field (defaults to: street, 'PACKSTATION' or 'POSTFILIALE') | |
| DeliveryAddress_HouseNumber | SINGLE | The address 2 field (defaults to: houseNumber, packstationNo) | |
| DeliveryAddress_AdditionalAddress3 | SINGLE | The address 3 field (defaults to: additional) | |
| DeliveryAddress_AdditionalAddress4 | SINGLE | The address 4 field is currently undefined and can be freely used. | |
| DeliveryAddress_ZIP | SINGLE | The postcode. | |
| DeliveryAddress_City | SINGLE | The town. | |
| DeliveryAddress_CountryID | SINGLE | The ID of the country. | |
| DeliveryAddress_StateID | SINGLE | The ID of the state. | |
| DeliveryAddress_ReadOnly | SINGLE | Flag that indicates if the data record is read only. | |
| DeliveryAddress_ContactPerson | SINGLE | The contact person option (alias for option with typeId 12). | |
| DeliveryAddress_VATNumber | SINGLE | The tax id number (VAT number) option (alias for option with typeId 1). | |
| DeliveryAddress_ExternalAddressID | SINGLE | The external ID option (alias for option with typeId 2). | |
| DeliveryAddress_EntryCertificate | SINGLE | The entry certificate (bool) option (alias for option with typeId 3). | |
| DeliveryAddress_Telephone | SINGLE | The phone number option (alias for option with typeId 4). | |
| DeliveryAddress_Email | SINGLE | The email option (alias for option with typeId 5). | |
| DeliveryAddress_Postnumber | SINGLE | The post number option (alias for option with typeId 6). | |
| DeliveryAddress_PersonalID | SINGLE | The personal ID option (alias for option with typeId 7). | |
| DeliveryAddress_BBFC | SINGLE | The BBFC/FSK option (alias for option with typeId 8). | |
| DeliveryAddress_Birthday | SINGLE | The birthday option (alias for option with typeId 9). | |
| DeliveryAddress_SessionID | SINGLE | The frontend session ID (alias for option with typeId 10). | |
| DeliveryAddress_Title | SINGLE | The title/salutation (alias for option with typeId 11). | |
| DeliveryAddress_CheckedAt | SINGLE | The time the address was checked. | |
| DeliveryAddress_CreatedAt | SINGLE | The time the address was created. | |
| DeliveryAddress_UpdatedAt | SINGLE | The time the address was updated. | |
| Account_Id | SINGLE | The ID of the account. | |
| Account_Number | SINGLE | The number of the account. | |
| Account_CompanyName | SINGLE | The company name. | |
| Account_TaxIdNumber | SINGLE | The ID of the tax number | |
| Account_Valuta | SINGLE | The valuta date in days specified for the account. | |
| Account_DiscountDays | SINGLE | The early payment discount period in days specified for the account. | |
| Account_DiscountPercent | SINGLE | The early payment discount in percent specified for the account. | |
| Account_TimeForPaymentAllowedDays | SINGLE | The payment due date in days specified for the account. | |
| Account_SalesRepresentativeContactId | SINGLE | The contact ID of the sales representative. | |
| Account_UserId | SINGLE | The (user) ID of the account owner. | |
| Account_DeliveryTime | SINGLE | The delivery time for the supplier. | |
| Account_DealerMinOrderValue | SINGLE | The minimum order value for the supplier. | |
| Account_SupplierCurrency | SINGLE | The currency used by a supplier. | |
| Account_CreatedAt | SINGLE | The time the account was created. | |
| Account_UpdatedAt | SINGLE | The time the account was updated. | |
| BankAccount_ContactID | SINGLE | The ID of the contact the bank account belongs to. | |
| BankAccount_OrderID | SINGLE | The ID of the order the bank account belongs to. | |
| BankAccount_AccountOwner | SINGLE | The owner of the bank account. | |
| BankAccount_BankName | SINGLE | The name of the bank. | |
| BankAccount_BankAddress | SINGLE | The address of the bank. | |
| BankAccount_BankPostalCodeTown | SINGLE | The postcode and town of the bank. | |
| BankAccount_BankCountry | SINGLE | The country of the bank. | |
| BankAccount_AccountNumber | SINGLE | The account number of the bank account. | |
| BankAccount_SortCode | SINGLE | The sort code of the bank account. | |
| BankAccount_IBAN | SINGLE | The IBAN of the bank account. | |
| BankAccount_BIC | SINGLE | The BIC of the bank account. | |
| BankAccount_DirectDebitMandateAvailable | SINGLE | Flag that indicates if a direct debit mandate is available. | |
| BankAccount_DirectDebitMandateAt | SINGLE | The time the direct debit mandate was created. | |
| BankAccount_DirectDebitMethod | SINGLE | The direct debit method. | |
| BankAccount_DirectDebitType | SINGLE | The direct debit type. | |
| BankAccount_PaymentMethod | SINGLE | The payment method. | |
| BankAccount_LastUpdateBy | SINGLE | The source of the last change. | import |
| CustomerNotes | MAP | | |