Top Up Credits β†’
InvoiceSpec / ERP Crosswalks / shopware-6-to-zugferd-2-3
SOURCE: SHOPWARE 6 β†’ TARGET: ZUGFERD 2.3 (EN 16931 / EXTENDED) (CII-D16B) Mandate: 2025-01-01 (DE)

Shopware 6 to ZUGFeRD 2.3 (EN 16931 / Extended) Schema Crosswalk & XML Compiler

01. Architectural Gap Analysis

Why Native Shopware 6 Exports Fail ZUGFeRD 2.3 (EN 16931 / Extended) Validation

1. Shopware 6's `order` entity lacks a native field for the buyer's electronic address (BT-49) and Leitweg-ID (BT-10), which are mandatory for German public sector recipients under BR-DE-15; the `addresses[].vatId` field only provides the VAT ID (BT-48) but not the required electronic address or Leitweg-ID.

2. Tax calculation in Shopware 6 uses line-item level rounding via `lineItems[].price.calculatedTaxes`, which can cause a mismatch between the sum of line-level tax amounts and the document-level tax amount (BT-110), violating BR-CO-15 (invoice total VAT amount must equal the sum of VAT category tax amounts).

3. Shopware 6's `amountNet` and `amountTotal` are stored as floats with two decimal places, but ZUGFeRD requires exact decimal representation; without proper rounding to two decimals using a consistent method (e.g., half-up), the sum of line net amounts (BT-106) may not equal the invoice total net amount (BT-109), failing BR-CO-10.

02. Shopware 6 to CII-D16B Field Crosswalk Table
Shopware 6 API Field EN 16931 Business Term Target CII-D16B XPath Card. Normalization Rule Assertion
orderNumber string, e.g., 'SW10001' BT-1 /rsm:CrossIndustryInvoice/rsm:ExchangedDocument/ram:ID 1..1 Trim whitespace and use as-is; ensure non-empty and max length 1000 characters. BR-02 β†—
amountNet float, e.g., 100.00 BT-109 /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:TaxBasisTotalAmount 1..1 Round to 2 decimal places using half-up rounding; format as decimal with exactly 2 fractional digits. BR-CO-10 β†—
amountTotal float, e.g., 119.00 BT-112 /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:GrandTotalAmount 1..1 Round to 2 decimal places using half-up rounding; format as decimal with exactly 2 fractional digits. BR-CO-15 β†—
addresses[].vatId string, e.g., 'DE123456789' BT-48 /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:BuyerTradeParty/ram:SpecifiedTaxRegistration/ram:ID[@schemeID='VA'] 0..1 Remove spaces and hyphens; validate against country-specific VAT ID pattern (e.g., DE[0-9]{9}); if invalid, omit the element. BR-CL-01 β†—
03. Live Shopware 6 β†’ ZUGFeRD 2.3 (EN 16931 / Extended) Workbench
1 CREDITS
invoice.xmlUBL-2.1
DETECTED SOURCEShopify
BT-131 LINE SUM199.95 EUR
BT-106 HEADER200.00 EUR
SCHEMATRON: 7 FATAL, 1 WARNΒ· 1ms
Peppol BIS Billing 3.0
BR-01An Invoice shall have a valid EN 16931 Specification identifier (BT-24)
Spec & Diff
xpath: /ubl:Invoice/cbc:CustomizationID

Missing <cbc:CustomizationID> or value does not declare EN 16931 CIUS compliance.

fix: Insert <cbc:CustomizationID>urn:cen.eu:en16931:2017#compliant#urn:fdc:peppol.eu:2017:poacc:billing:3.0</cbc:CustomizationID>.

BR-CL-01Document currency code (BT-5) MUST belong to ISO 4217 uppercase code list
Spec & Diff
xpath: /ubl:Invoice/cbc:DocumentCurrencyCode

Found invalid or lowercase currency code "eur". Expected uppercase ISO 4217 (e.g. "EUR").

fix: Replace <cbc:DocumentCurrencyCode>eur</cbc:DocumentCurrencyCode> with uppercase "EUR".

PEPPOL-EN16931-R008Document MUST NOT contain empty XML elements (found 1: <cbc:AdditionalStreetName>)
Spec & Diff
xpath: //cbc:AdditionalStreetName[not(node())]

Peppol Schematron forbids empty elements such as <cbc:AdditionalStreetName></cbc:AdditionalStreetName> serialized from null ERP fields.

fix: Strip empty <cbc:AdditionalStreetName> nodes prior to XML serialization.

PEPPOL-EN16931-R020Seller electronic address (BT-34) MUST be provided with a valid EAS @schemeID
Spec & Diff
xpath: /ubl:Invoice/cac:AccountingSupplierParty/cac:Party/cbc:EndpointID

Missing <cbc:EndpointID schemeID="..."> inside <cac:AccountingSupplierParty>/<cac:Party>.

fix: Add <cbc:EndpointID schemeID="9930">DE123456789</cbc:EndpointID> as the first child of Seller <cac:Party>.

PEPPOL-EN16931-R010Buyer electronic address (BT-49) MUST include a valid EAS @schemeID attribute
Spec & Diff
xpath: /ubl:Invoice/cac:AccountingCustomerParty/cac:Party/cbc:EndpointID

Buyer <cbc:EndpointID> is either missing or lacks the mandatory EAS @schemeID attribute.

fix: Add schemeID="9930" (or "0088" for GLN / "0204" for Leitweg-ID) to Buyer <cbc:EndpointID>.

BR-DE-15Buyer reference / Leitweg-ID (BT-10) is missing
Spec & Diff
xpath: /ubl:Invoice/cbc:BuyerReference

No <cbc:BuyerReference> (BT-10) found. Mandatory in XRechnung 3.0 (BR-DE-15) and required in Peppol BIS 3.0 (PEPPOL-EN16931-R003) when OrderReference is absent.

fix: Insert <cbc:BuyerReference>991-12849-74</cbc:BuyerReference> in the document header.

BR-CO-10Sum of Invoice line net amount (BT-106 = 200.00) != sum of lines (BT-131 = 199.95)
Spec & Diff
xpath: /ubl:Invoice/cac:LegalMonetaryTotal/cbc:LineExtensionAmount

Mathematical discrepancy of 0.05 EUR between InvoiceLine sum (199.95) and LegalMonetaryTotal/LineExtensionAmount (200.00).

fix: Set cbc:LineExtensionAmount and cbc:TaxExclusiveAmount to 199.95.

BR-S-08Standard rate VAT TaxableAmount (BT-116 = 200.00) does not match S-rated lines (199.95)
Spec & Diff
xpath: /ubl:Invoice/cac:TaxTotal/cac:TaxSubtotal/cbc:TaxableAmount

TaxSubtotal/TaxableAmount reports 200.00, but Standard rated ("S") lines total 199.95.

fix: Recalculate BT-116 = 199.95, VAT BT-117 = 37.99, and PayableAmount BT-115 = 237.94.

Automate Shopware 6 β†’ Peppol BIS Billing 3.0 AP Delivery

Deploy certified Peppol Access Point & ZUGFeRD ERP connector

04. Other ERP Compliance Matrices