Skip to content
SAP, DATEV and Dynamics experts

Shop integration & processes

The real work sits between the shop and the back office: articles, prices, stock levels, customers, orders, delivery notes and invoices have to flow reliably in both directions. This category collects articles on connecting these systems — from taking stock of existing data sources through choosing the leading system per data type to synchronisation methods, error handling, logging and recovery after incidents. We cover product data quality and classifications, variants and bills of materials, partial deliveries, returns and credit notes, and how to handle the special cases no standard solution anticipates. Written so that business departments and IT speak the same language and effort can be estimated realistically in advance. We also cover project organisation: who decides when systems conflict, and how are data flows documented so they remain understandable in two years?

Environment strategy for ERP interfacesSeparate environments, anonymised test data, defined releaseSeparate environments (BSI CON.8.A7)DevelopmentMocks, synthetic master dataDEVTest / sandboxAnonymised test data, 300/minTESTProductionLive data, document output onPRODContract testRelease + acceptanceTest data pipeline, not a production copyProduction dataAnonymisationTest data setOPS.1.1.6.A11: personal test data pseudonymised at minimumRate limits differ300/minSandbox 300/minProduction 600/min(Microsoft Learn)Contract test against mockConsumer test creates pactProvider verifies pactFull integration nightly onlyRelease and cutover criteria (OPS.1.1.6.A10)Acceptance plan metBackfill verifiedLoad profile heldRollback plan testedSources: BSI IT-Grundschutz CON.8/OPS.1.1.6, EUR-Lex (EU) 2016/679, Microsoft Learn, SAP Help Portal, Pact Foundation

Building Test Environments for ERP Interfaces Properly

Sandbox tenants, anonymised test data and contract tests: how to test ERP shop interfaces safely before go-live instead of flying blind into production.

13 min read
Automating Drop Shipping: Connecting Suppliers to the ShopStock and price feeds per supplier via a middleware into shop and ERPSupplier A · EDIEDIFACT: PRICAT, INVRPTSupplier B · CSV / SFTPStock + price, nightlySupplier C · REST APIAvailability in real timeMiddleware · OrchestrationNormalize format mappingMirror availability + lead timeSplit order by supplierStock and drop-ship goods in one processShop · Availability per supplierDrop-ship · 2–4 daysin stockStock item · from warehouseon handERP · leading systemArticle · price · order (drop-ship)Goods receipt + tracking returnedSplit the incoming order by supplier and place itOrder#104823 line items2 suppliersOrder → Supplier A · 2 line itemsOrder → Supplier B · 1 line itemReturnTracking + GR messageper supplier back to shop + ERPEUR 509bnB2B online trade 2024(IFH Cologne)56 %marketplace share e-commerce 2025(bevh)EUR 92.4bnonline retail forecast 2025(HDE)

Automating Drop Shipping: Connecting Suppliers

Automate drop shipping cleanly: read supplier feeds via EDI, CSV/SFTP or REST API, mirror availability and split orders by supplier -- with the ERP leading.

13 min read
RMA Process: Managing Returns Between Shop and ERPFrom the return request through inspection to credit note and stock correctionEnd-to-end RMA process1Return request in the accountlinked to the original orderOrder link2RMA number and check statusfrom the ERP systemRMA no.3Goods receipt and inspectionsorting and classificationInspect4Restocking or write-offA-grade, B-grade or scrapA-grade5Credit note and stock updateposted in SAP, DATEV, DynamicsCreditAverage return rate Germany17.4 %return rate(EHI Retail Institute)550mreturn parcels 2025(Uni Bamberg)EUR 5-10handling per item(EHI Retail Institute)EUR 92.3bnonline retail 2025(HDE Germany)

RMA Process: Managing Returns Between Shop and ERP

Manage return requests, RMA numbers, inspection, restocking and credit notes bidirectionally between shop and ERP -- without double entry of returns.

13 min read
Credit-Limit Checks in B2B Checkout: Live ERP DataReal-time credit check before order confirmationB2B CheckoutCustomerDebtor 10042Cart12 line itemsOrder value9,200 EURPaymentOn accountCheck creditERP Credit DataCredit limit50,000 EUROpen items28,500 EURPayment terms30 daysAvailable21,500 EURCredit Decision75%Limit utilizationApprovedPossible release decisions in the checkoutOrder value within limitPurchase on account approvedLimit getting tightDeposit or partial approvalLimit exceededPrepayment instead of invoice23,900company insolvencies 2025ten-year high (Creditreform)+15.8%more insolvenciesMarch 2026 (Destatis)32.13 daysaverage paymentterms (Creditreform)

Credit-Limit Checks in B2B Checkout: Live ERP Data

Check credit limit, open items and payment terms in real time from SAP, Dynamics or DATEV in the B2B checkout to control invoice purchase and order release.

13 min read
OCI and cXML Punchout: Connect Procurement to the ShopProcurement SystemSAP purchasing / e-procurementPurchase requisition (PR)Approval workflowHTTP Session HandoffHOOK_URL / return URLSession ID + authenticationStructured cart returnedB2B ShopShopware CE + catalogueCustomer-specific catalogueContract prices live1 Setup2 Call4 Cart5 ApprovalThe Punchout Roundtrip in Five Steps1Setup RequestPass HOOK_URL2Session LoginAuth + open catalogue3Shop the CataloguePrices + tiers live4Cart ReturnedNEW_ITEM fields5Order (PO)Approval in systemOCI (SAP): HTML form fieldsCart return via form POSTNEW_ITEM-DESCRIPTION / -MATNRNEW_ITEM-QUANTITY / -UNITNEW_ITEM-PRICE / -CURRENCYNEW_ITEM-VENDORMAT / -LEADTIMEcXML: XML messagesDocument-based, server-to-server POPunchOutSetupRequest (create)PunchOutSetupResponse (StartPage)PunchOutOrderMessage (cart)OrderRequest (purchase order)B2B online trade via shops and marketplaces: about EUR 476 billion (Statista)95 percent simplify the ordering process digitally (Bitkom) - 80 percent see the biggest digitalization need in supplier management (BME)

OCI Punchout: Connect Procurement Portals to Your Shop

OCI and cXML Punchout connect your B2B shop to SAP purchasing and e-procurement: HTTP session handoff, cart return, customer-specific catalogues and prices.

13 min read
Observability Dashboard for InterfacesSync Success Rate99.4%last 24 hoursError Rate (Trend)Anomaly detected at 2:20 PMActive AlertsSAP latency elevatedQueue depth risingDLQ: 2 messagesThree Pillars of ObservabilityLogsStructured eventswith correlation IDJSON, searchableMetricsError rate, latencyQueue depth, throughputThreshold alertsTracesPath of an orderstore to ERPspan per stepEarly detection: see errors before customers doStore ordersMiddleware checksAlert on anomalyFix before customer impact

Observability for Interfaces: Detect Errors Early

Observability for ERP-store interfaces: logs, metrics and traces make sync errors visible before customers notice. Early detection instead of damage control.

12 min read
API Versioning: Lifecycle of an Interfacev1 activev1 deprecatedv1 sunsetv2 releaseshutdownv2 active (parallel to migration phase)Versioning StrategiesURI Versioning/api/v2/ordersVisible, cacheableHeader VersioningAccept: v=2026-06Clean URLsDate Versioning2026-06-22Per-client pinningDeprecation Signals for ConsumersDeprecation headerSunset dateChangelogMigration guide

API Versioning: Keeping Interfaces Long-Lasting

API versioning for shop interfaces: URI and header strategies, deprecation processes and backward compatibility for maintainable, long-lasting integrations.

12 min read
Master Data Management: one Golden Record for all systemsGolden RecordCustomer 100482 . Item SKU-7710Single Source of TruthERPSAP . Dynamics . DATEVShopShopware CE . PIMCRMSales . ServicesyncsyncConflict resolution (survivorship rule)Address: ERP wins . Stock: WMS winsPrice: ERP . E-mail: CRM (latest timestamp)on a tie -> review queue instead of overwriteData quality score94 %Complete . unique . deduplicated . validData governance: ownership, validation, audit trail per attributePoor data quality costs organizations USD 12.9m per year on average (Gartner)76 % of German companies struggle with data quality and silos (Bitkom, 2025)

Master Data Synchronization: Master Data Management 2026

Master data management 2026: synchronize customers, products and prices across ERP, shop and CRM, resolve conflicts rule-based and secure data quality.

13 min read
Payment Reconciliation: Matching Payments with the ERPPayouts (Provider)Orders (Shop)Invoices (ERP)PO-2026-0481 48.90 EURSO-100481 50.40 EURINV-50481 50.40 EURmatchedPO-2026-0482 118.20 EURSO-100482 120.00 EURINV-50482 120.00 EURFee -1.80 EURPO-2026-0483 64.00 EURno matchopen / exceptionunmatched -> exception listReconciliation EngineAmount + ReferenceFee SplitChargeback RulePost to ERPAuto-match rate94 %Manual effort only remains for residual itemsChargebacks cost USD 33.79bn (Juniper Research, 2025)

Payment Reconciliation: Match Payments with the ERP

Payment reconciliation in e-commerce: automatically match payouts, orders and invoices, post fees and chargebacks, hand over cleanly to DATEV and your ERP.

12 min read
Running Multichannel through MiddlewareShop and ERPsource of truthShopware CE catalogueERP stock and priceorders and documentsone maintaineddata baseMiddleware Hubchannel mapping and synccreate listing per channelsync stock and pricecollect orderssend status backmapping per marketplacedata outorder inMarketplace Alisting live, sync okMarketplace Bstock in real timeMarketplace Cprice rule runningown web shopFour Synchronisation Flowslisting and attributesstock per warehouseprice and channel ruleorder and statusStatus per Channelgreen: listing and sync runningyellow: task in progressred: error needs clarificationWhy the Source of Truth Sits in the Hubone record, many channelsno manual edits per marketplaceshare stock in real timeoverselling is avoidedprice rule per channelmargin and fee stay cleanMarketplaces carried around 55 percent of German e-commerce volume in 2024 (bevh and EHI marketplace study)

Marketplace Integration via Middleware: Multichannel 2026

Connect shop and ERP to marketplaces through middleware: synchronise listing, order, stock and price, with mapping per channel and clear status in practice.

14 min read
Shipping Middleware between Shop and CarriersShop and ERPShopware CE plus ERPOrder and addressWeight and volumeShipment status backShipping MiddlewareCarrier-agnosticCarrier selectionLabel and trackingReturns and statusCarrier ALabel REST APICarrier BTracking webhookCarrier CReturns portalShipping requestLabel and statusMulti-carrierThree Carrier Functions through One InterfaceLabelShipping label and tracking IDgenerates the label per shipmentTrackingStatus events via webhookupdates the shipment stateReturnsReturn label and credit notecontrols the reverse flow of goodsWarehouse and Fulfillment SyncStock and reservationPick list and packageGoods receipt and reverse flow back to shop and ERPShipment Status per Stagelabel createdhanded overin deliverydeliveredreturncreditedIn 2024 around 4.29bn shipments were carried in the German CEP market (BIEK CEP Study)48 percent of checkout abandonments stem from extra costs such as shipping and fees (Baymard Institute)

Connecting Shipping and Logistics Interfaces in 2026

Connect carrier APIs for label, tracking and returns to your shop: multi-carrier selection, webhook tracking, returns handling and warehouse sync in practice.

13 min read
Product Data Pipeline: From PIM to ChannelPIM SystemSingle Source of TruthMaster DataAttributes and VariantsMedia and CopyTransformand EnrichmentMapping and RulesValidationEnrichment and DeltaOnline StoreSEO copy, filtersMarketplaceChannel mappingPrint and PDFCatalog exportData QualityCompleteConsistentAccurateTimelyDelta Sync: only changed records per runChannel MappingRequired fields per channelCategory assignmentEnrichmentCopy and mediaTranslationsValidationRules before publishErrors block releaseMonitoringSync status per channelAlerting on errors99 percent of B2B organizations face product information challenges (Akeneo B2B Survey, 2024)40 percent still manage product data manually, which invites errors and delays (Akeneo B2B Survey, 2024)

PIM Integration: Building the Product Data Pipeline

Build PIM integration: a product data pipeline from PIM through enrichment to store, marketplace and print -- with channel mapping, delta sync and API design.

11 min read
Coupling EDIFACT between Trading Partner and ShopTrading PartnerSupplier / CustomerUN/EDIFACT D.96AUNB ... UNZ envelopeEDI ConverterMapping in the middlewareEDIFACT to JSONSegment validationReceipt MDN / CONTRLShop and ERPShopware CE plus ERPREST and GraphQLOrder / documentAS2 / OFTP2MDN receiptAPI callstatus backMessage Types in the Order ProcessORDERSOrder partner to shopcreates order in systemDESADVDespatch advice for shippingannounces goods receiptINVOICInvoice as documentclaims paymentCONTRLSyntax acknowledgementconfirms receiptSecuring the TransportAS2 with S/MIME signatureOFTP2 with encryptionSFTP with key pairMDN as proof of deliveryVerify signature and receipt before processingMapping per PartnerRead EDIFACT segment UNB / BGM / NADMap fields onto the shop schemaMaintain a partner profile per subsetUN/EDIFACT spans over 200 message types (UNECE)EDI market USD 36.58bn in 2024, CAGR 12.1 percent to 2032 (Fortune Business Insights)

EDI Integration: Coupling EDIFACT to the Shop 2026

Couple EDIFACT messages such as ORDERS, INVOIC and DESADV between trading partners and your shop: converter, AS2, SFTP, mapping and receipts in practice.

14 min read
B2B Customer Access: ERP-Driven AssortmentsReleases, customer groups and blocked items from the inventory systemERP Customer MasterCustomer groupTradeRelease list1,240 itemsBlock set38 itemsContractactiveLogin requiredVisibility RuleCatalog scopeper groupItem releaseAllow listBlock checkactiveQuick orderERP no.Real-time + cachePer-Customer CatalogSKU 44120visibleSKU 44135visibleSKU 90277blockedSKU 61002on request12,400 visible / 340 blockedThree levels of assortment visibilityReleased itemsAllow list per customer groupCustomer-specific catalogContract and special itemsBlocked products + loginPhase-out items, login required509 bn €B2B internet trade 2024wholesale and manufacturers (ECC Cologne)76 %Online shop revenue sharein B2B internet trade (ECC Cologne)1 in 3B2B buyers preferdigital self-service (McKinsey)

B2B Customer Access: ERP-Driven Assortments

Control released items, customer groups, blocked products and login rules from the ERP in the B2B shop: visibility and assortments in real time or cache.

13 min read
SAP - Shopware Real-Time SynchronizationSAP Business OneService Layer API (OData)Master Data, Prices, InventoryShopwareStore API / Admin APIProducts, Orders, CustomersMiddlewareTransformation, Validation, QueueEvent-based, bidirectionalData FlowsItem Master DataSAP leads, Delta SyncInventory LevelsReal-time Push, Multi-WarehousePrice ListsCustomer-specific, TieredOrdersShop leads, Real-timeChange Tracking (SAP)TimestampsChange LogEvent WebhookOnly changed records transferredError HandlingRetry QueueDead LetterAlertingAutomatic retry, escalationSynchronization IntervalsOrders: Real-timeInventory: every 2 minPrices: every 15 minMaster Data: Delta 5 min

SAP and Shopware: Real-Time Synchronization of Master Data

Connect SAP and Shopware: real-time synchronization of master data, inventory and pricing via the Service Layer API with middleware architecture.

13 min read
DATEV Connection in E-CommerceOnline StoreOrders, Invoices, ReturnsShopware / Open Source / CustomDATEVFinancial AccountingPosting Batches, Documents, DMSMiddlewareMapping, Validation, ConversionDATEV Format ConversionAutomated Document FlowsInvoicesAutomatic ExportCredit NotesReturn DocumentsPaymentsMatching and AssignmentDebtorsAutomatic CreationDATEV Export FormatsPosting BatchCSV per DATEV SchemaXML DocumentOnline Document ExchangeDATEV APIREST, Real-time SyncDMS UploadArchive Document ImagesAccount AssignmentRevenue AcctsTax AccountsDebtor AccountsTax Rate Mapping19%7%0% (EU)RC

DATEV Connection in E-Commerce: Automated Accounting

DATEV connection for online stores: automatically transfer invoices, credit notes and payments. Posting batches, XML documents and API integration.

12 min read
Integration Architectures ComparedPoint-to-Point (REST API)StoreERPStoreDATEVDirect, fastLow abstractionMiddleware ArchitectureStoreERPDATEVPIMMiddlewareTransformationRoutingQueueDecision CriteriaNumber of Systems2 systems: API direct3+ systems: MiddlewareData VolumeLow: synchronous APIHigh: asynchronous queueMaintainabilityAPI: coupled to systemsMiddleware: decoupledTechnology OverviewRESTJSON, HTTP VerbsGraphQLFlexible QueriesODataSAP, DynamicsWebhooksEvent-basedMessage QueueAsync, robust

REST API or Middleware: Which Integration Architecture Fits

REST API or middleware for shop integration: advantages and disadvantages of both architecture models compared with concrete decision criteria.

11 min read
JTL-Wawi and Online Shop: Sync Direction per Data ObjectSet the leading system, plan the direction per object, resolve conflicts cleanlyJTL-WawiInventory systemLeading system(Master)> 50.000merchants run JTL-WawiOnline shopStorefront and checkoutOrders originate hereProducts and variantsPricesStock levelsOrdersCustomersPayment/shipping statusfrom JTL-Wawi (master)back into JTL-Wawibidirectional (status)

Connecting JTL-Wawi to Your Online Shop: Sync Strategy

Synchronize JTL-Wawi with your shop without duplicates or stock discrepancies: plan data objects, sync direction and the leading system (master) properly.

13 min read
Data Mapping: ERP to StoreERP System (Source Fields)ItemCodestring(20)ART-10042ItemNamestring(100)Bolts M8x40QuantityOnStockdecimal(18,3)1542.000PriceAfterDiscountdecimal(18,6)4.250000SalesUoMEntryint3 (= Ctn)Store System (Target Fields)productNumberstringART-10042nametranslatedBolts M8x40stockint1542price.grossfloat5.06 (gross)unit.namestringCarton1:1i18nroundtax+roundlookupMiddleware: Transformation, Validation, Enrichment1:1 MappingDirect assignmentwithout transformationType Conversiondecimal to intnet to grossLookup TablesUoM codes to namesTax keysValidationCheck required fieldsEnsure value rangesMapping Configuration: JSON/YAML-based, versioned, testableMapping changes without code deployment | Audit log for every transformation | Error protocol for invalid data

Data Mapping Between ERP and Store: Field Assignment Done Right

Data mapping between ERP and store system: field assignment, data transformation, validation rules and mapping strategies for successful integrations.

11 min read
Multi-Warehouse Inventory SynchronizationB2B Online StoreAggregated AvailabilityWarehouse NorthHamburg, 8,500 SKUsWarehouse CentralKassel, 12,000 SKUsWarehouse SouthMunich, 6,200 SKUsDropship PartnerExternal, API QueryMiddleware: Aggregation, Routing, Delta SyncInventory Rules | Reservations | Thresholds | Fallback LogicDelta SyncOnly transfer changes90% less data volumeEvent PushImmediate updateon every stock movementReservationsReserve stock on orderimmediatelyThresholdsSafety stockconfigurable per warehouseAvailability Display in StoreTotal Stock | Location Availability | Delivery Time per Region | Reorder Info

Inventory Synchronization Across Multiple Warehouses for B2B

Inventory synchronization across multiple warehouses: real-time availability in B2B stores through delta sync, multi-warehouse logic and intelligent routing.

10 min read
ERP Migration: Legacy to APILegacy State (Before)CSV ExportDirect DB AccessFTP UploadBatch ScriptsManual, error-prone, not scalableModern State (After)REST APIEvent WebhooksMessage QueueMiddlewareAutomated, robust, scalableStrangler Fig Pattern: Gradual MigrationPhase 1: Master DataPhase 2: InventoryPhase 3: OrdersPhase 4: PricingParallel OperationOld and new active simultaneouslyComparison TestsVerify old vs. new resultsRollback OptionSwitch back to legacy anytimeRisk minimization through gradual replacement | No big bang | Each phase individually testable

ERP Migration: From Legacy Interfaces to Modern API Connections

ERP migration from legacy interfaces to modern API connections: strangler fig pattern, risk analysis and gradual replacement of old integrations.

14 min read
Customer-Specific Price SynchronizationERP Price Lists10 Price Lists, TiersFramework Agreements, SpecialsMiddlewarePrice MappingCaching LayerNet to Gross + TaxB2B StoreCustomer Group PricesPrice Rules, Tiered PricingPrice StructuresList PricesStandard price for allGroup PricesPer customer groupTiered PricesQuantity-dependentSpecial PricesTime-limitedCaching ArchitectureRedis CacheTTL per Price TypeCache InvalidationFallback StrategySync StrategiesFull sync: All prices periodicallyDelta sync: Only changesOn-demand: At customer loginHybrid: Combination by price typePerformance Metrics500,000 price recordsunder 50ms query time95% cache hit rateDelta sync every 15 minutes

Customer-Specific Prices from ERP: Synchronization and Caching

Customer-specific prices from SAP or Dynamics in B2B stores: synchronization strategies, caching architectures and tiered price mapping.

10 min read
Error Handling in InterfacesStoreOrders, DataMiddleware: Error HandlingRetry, Queue, Circuit Breaker, LoggingERP / DATEVTarget SystemError Handling Pipeline1. ValidationCheck required fieldsValidate data typesCheck references2. Retry LogicExponential BackoffMax 5 attempts1s, 4s, 16s, 64s, 256s3. Circuit BreakerSystem protectionClosed / Open / Half-OpenAuto recovery4. Dead Letter QueueNot processableSafely storedManual clarificationMonitoring and AlertingTrack error rateMonitor queue depthMeasure latencyConfigure alertsIdempotencyEvery message can be processed multiple timeswithout undesired side effectsCorrelation IDsEnd-to-end traceabilityfrom store to ERP across all stations

Error Handling in Interfaces: Retry, DLQ and Monitoring

Error handling in store interfaces: retry logic with exponential backoff, dead letter queues, circuit breaker and proactive monitoring.

11 min read