Partner Import (CSV)

    Import many partners at once via CSV file — with all master data, bank details and settings.

    File format

    • Encoding: UTF-8
    • Delimiter: Semicolon (;)
    • All columns must be present, even if left empty
    • No multiline content in fields
    • Allowed characters: Alphanumeric incl. European umlauts

    Column order (31 columns)

    The order must be followed exactly:

    PartnerID; Salutation; FirstName; LastName; AdminAlias; Language; Address; ZIP; City; Country; State; DateOfBirth; Email; URL; AdditionalURLs; Company; Phone; Fax; VATType; VATPayout; BusinessLicense; TaxNumber; VATId; AccountHolder; Bank; BIC; IBAN; Registration; Contact; CustomerNumber; TCCheck

    Sample data

    CSV example
    1420269;m;John;Doe;JohnDoe;EN;Main Street 1;12345;Berlin;DE;Berlin;10.10.2010;john@doe.com;https://www.johndoe.com;;DoeTrading;012345678910;1098765432;p;1;1;;;John Doe;Sample Bank;SWIFTCODE;DE1234567654321;01.01.2001;0123 53421534879;;1

    Important field formats

    FieldFormatRequiredExample
    Salutationm/f/dYesm
    LanguageISO code, 2 charsYesEN
    CountryISO code, 2 charsYesDE
    EmailValid emailYesjohn@mail.com
    VATTypep (private) or g (business)Yesp
    VATPayout0 or 1Yes1
    TCCheck0 or 1No1
    DateOfBirthDD.MM.YYYYNo10.10.1990
    RegistrationDD.MM.YYYYNo01.01.2024
    💡Tip
    If the file validates successfully, an option to start the import appears. Check carefully beforehand — especially email addresses and bank details.
    Still have questions?
    Our team is here to help with your integration — personally and competently.