Floemdata
Data & ETL

SAP B1 Marketplace Integration: Problems and Fixes

Combining SAP B1 and marketplace data in one warehouse is harder than it looks: different keys, returns and cancellations, reloads and reconciliation.

Floemdata · · 3 min read
An ERP block with four squares and a storefront with an awning, linked by two opposite arrows

In a small or mid-sized business, sales live in two places: invoices and stock in SAP Business One, orders and payments on the marketplace. Combining them in one warehouse looks easy at first; the difficulties are in the details. This article describes general integration challenges.

Challenges and what to do

  • Different keys. A marketplace order number is not the same thing as an ERP document number. Fix: an explicit mapping table linking the two systems, plus a list of what does not match.
  • Returns, cancellations and partial shipments. One order can be split across several invoices or cancelled later. Fix: keep document type and status in the data and sum amounts with their sign.
  • Commissions and deductions. The marketplace payout arrives with commission and deductions taken off the sales amount. Fix: keep gross, commission and net amounts in separate columns.
  • Reloads. If the same data is pulled twice, totals inflate. Fix: write the load so that it can be re-run (idempotent) and advance the progress marker only after the load is confirmed.
  • Timing differences. Order, invoice and payment dates fall on different days. Fix: choose which date you report by up front, and write it down.
  • Not straining the live system. Sending heavy queries to the ERP database slows daily work. Fix: a read-only user and plain SELECT queries.

Reconciliation

After combining, the first job is to compare the warehouse totals with the sources' own reports. If a difference appears, do not hide it; show it.

Where Floemdata stands

The only source Floemdata Analytics has run on real data is SAP Business One: read-only SELECT queries, re-runnable loads and a progress marker that advances only after the warehouse confirms. Marketplace connectors are on the roadmap; the marketplace description in this article is general knowledge and not a product feature claim (not verified).

To get started, match one marketplace for one month against the ERP invoices and count the rows that do not match. Questions: info@floemdata.com.

← All guides