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.
