Overview
Use this guide when your source is SAP, Oracle, Dynamics, Acumatica, or another ERP without a prebuilt mapping page. Start with a minimal required-field mapping, then add optional enrichment.Minimal Required Mapping
| Import module | Required payload keys |
|---|---|
| Catalog | products[].externalId |
| Inventory | levels[].skuId, levels[].locationId |
| Suppliers | suppliers[].externalId |
| Purchase Orders | purchaseOrders[].externalPoNumber, supplierId, destinationLocationId, lines[] |
| Orders | orders[].externalOrderId, lines[] |
| Demand History | records[].skuId, locationId, weekStarting |
Implementation Pattern
- Extract source records into a staging table.
- Transform fields into Better Data JSON payload shape.
- POST batch payloads to
/api/import/*. - Poll
/api/import/status/[jobId]and retry failed rows.
Transformation Tips
- Build stable external IDs and keep them immutable.
- Normalize location codes before sending payloads.
- Convert dates to ISO format (
YYYY-MM-DDor full timestamp). - Preserve numeric types for quantities and costs.