Master Data Export

The module can export customer master data in DATEV EXTF Debitoren/Kreditoren format and include it alongside invoice/credit memo exports.

When Is It Included?

Manual export: enable Export Master Data in Sales > DATEV > DATEV Export
Automated export: enable Export Master Data in Automatic Export Settings

The export is written as a CSV file and may be bundled into ZIP downloads.

Output File

The master data CSV is generated as:

var/export/datev/EXTF_DebKred_Stamm_<timestamp>.csv

Mapping Structure

Master data mapping is a JSON object where:

keys are column indexes (as strings)
values are mapping expressions

Example:

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

The context for this mapping provides:

customer.* (Magento customer entity)
address.* (selected address for export)

Full syntax reference: Mapping Language

Address Selection

Use Address Export Priority to define which address is used for each customer (priority order):

billing,shipping (default)
shipping,billing

If no default address exists, the exporter falls back to the first available address.