Export customer master data

Customer master data can accompany an invoice or credit memo export. The extension creates an EXTF debtor and creditor CSV with 254 columns and one row for each collected customer.

Enable Export Master Data on the manual form or in the automatic export settings. The CSV is named like EXTF_DebKred_Stamm_<timestamp>.csv. The feature is enabled by default in the module configuration — disable it if the accounting recipient does not want customer master data in every export.

For a CSV export, master data is included in the accounting-data ZIP. With Both (CSV + XML), it stays in the accounting-data archive and is not copied into the XML document package. An XML-only export provides master data in its own EXTF_Datev_Stammdaten_<from>_<to>.zip archive.

Choose the address

Address Export Priority controls which Magento customer address is used:

billing first, then shipping
shipping first, then billing
billing only
shipping only

If neither preferred default address resolves, the generator falls back to the first available customer address. Customers without usable address data can therefore produce empty mapped fields.

Mapping format

The mapping is a JSON object. Keys are zero-based column indexes and values are expressions:

{
  "0": "{{customer.id + 10000}}",
  "1": "{{address.company}}",
  "3": "{{customer.lastname}}",
  "4": "{{customer.firstname}}",
  "15": "{{address.street}}",
  "17": "{{address.postcode}}",
  "18": "{{address.city}}",
  "32": "{{customer.email}}"
}

The supplied mapping initializes all 254 columns and fills selected account, name, address, contact, customer-number, and tax fields. Review both the column numbers and debtor-account formula with the receiving accounting team.

Before sending the file

Open the CSV with an editor that preserves Windows-1252 and semicolon delimiters. Check a company customer, a person customer, a customer with only one address, and any store-specific data. Do not use spreadsheet software that silently changes account numbers or VAT IDs before saving the file.