Shopify export → SAPPHIRE_SHOPIFY → MSTOREPM / MSTOREPI
Load store orders into Oracle with the same rules as the original pipeline.
Upload a Shopify orders CSV or Excel file. The loader maps columns, blocks missing parties and SKUs, handles duplicates, then writes ERP documents — exactly as the Python loader does.
Sale order workbook
Export Shopify vs Sapphire
Filter loaded orders and download the comparison Excel in the sample format.
Order Date uses CREATED_AT. Entry Date uses ENTDT.
- 01 Upload
- 02 Validate
- 03 Duplicates
- 04 Insert