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_.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.

Found an issue with this documentation? Let us know