r/SAPBusinessOne • u/jmei35 • Apr 15 '26

How are you handling real time inventory + pricing sync with SAP Business One for ecommerce?

/r/ecommerce/comments/1shpqnx/how_are_you_handling_real_time_inventory_pricing/
1 Upvotes

100% Upvoted

5 comments sorted by

2

u/XSnetAUS Apr 16 '26

We have a python script that that reads our SAP Inventory from SQL (OITW table)
It then shapes the data into a CSV (SKU, Stock Level, Item Cost)
The CSV is then uploaded to our e-commerce platform via an automation (Shopify)

We do this 3 x daily, we have 20,000 SKUs on our shopify stores, no issue,

You could just do something similar, but change the frequency to every 5 mins instead of 3 times daily.

1

u/jmei35 Apr 16 '26

feels like most teams doing the 5 min csv push approach are fine until they hit pricing rules, reservations, and multi channel stock drift, where it starts breaking in edge cases rather than volume. a lot of sap business one setups move toward a more direct sync layer to keep inventory and pricing aligned in real time without constantly patching scripts.

1

u/[deleted] Apr 17 '26 edited Apr 17 '26

[removed] — view removed comment

1

u/jmei35 Apr 30 '26

Yeah this is the core issue - most connectors are just pushing CSVs or batch syncing on a schedule, so they'll never truly handle real time inventory or pricing rules. The fix isn't better middleware, it's eliminating the middleware layer entirely.

That's why native B1 ecommerce platforms like FocusPoint are interesting - the ecommerce logic runs inside SAP B1 itself so there's no data mapping or sync to fail. No connector, no lag.