Discuss a project

DL-031 · Case study

Amazon seller data turned into SAP interface files

A multi-brand health and beauty group needed its Amazon sales, stock and payouts in SAP. We built a daily service that writes Amazon data as SAP interface files.

Client
Name withheld
Location
France
Industry
Health and beauty group
Capabilities
03Build
01

Challenge

  • Amazon sales, returns and payouts had to reach SAP without manual re-keying.
  • Amazon SKUs did not match the group's internal SAP article codes.
  • Several brands and seller accounts, each needing the same treatment.
02

Environment

  • Multi-brand group selling through several Amazon seller accounts in Europe.
  • SAP as the system of record, fed by fixed-format interface files.
  • Files exchanged over the group's SFTP server.
03

Intervention

  • Daily pull of order, return, inventory ledger and settlement reports via SP-API.
  • Finances API data for payouts, fees and tax lines.
  • SKU conversion table mapping Amazon listings to SAP articles.
  • Interface files for stock movements, sales orders with returns, and settlements.
04

Outcome

  • Amazon stock, sales and payouts arrive in SAP on a daily cycle.
  • First marketplace live in 2026; further European marketplaces in rollout.
  • Ongoing maintenance as new accounts and marketplaces are added.
A daily service reads Amazon reports and financial events, maps SKUs to SAP articles and writes stock, sales and settlement interface files to an SFTP server that SAP imports.dailyimportSP-API REPORTSOrders / returns / ledgerFINANCES APISettlements / feesDAILY SERVICEMapping + filesSKU TABLEAmazon to SAPSFTPInterface filesSAPStock / sales / payouts
  1. 01SP-API REPORTSOrders / returns / ledgerDAILY SERVICEMapping + filesdaily
  2. 02FINANCES APISettlements / feesDAILY SERVICEMapping + files
  3. 03SKU TABLEAmazon to SAPDAILY SERVICEMapping + files
  4. 04DAILY SERVICEMapping + filesSFTPInterface files
  5. 05SFTPInterface filesSAPStock / sales / payoutsimport
Fig. 32Amazon data into SAPA daily service reads Amazon reports and financial events, maps SKUs to SAP articles and writes stock, sales and settlement interface files to an SFTP server that SAP imports.Scale NTS

Stack and services.

Stack05

  • Amazon SP-API
  • Finances API
  • AWS
  • SFTP
  • SAP interface files

Services used02

Tell us what has to work.

A senior engineer reads every brief. Describe the system, what it runs on today and what happens when it fails.

Discuss a project