Sage 200 + PrestaShop. Automatic replenishment.
200+ orders a week. Hospitality customers with strict delivery windows. PrestaShop stock that didn't reflect reality in Sage 200.
−60%
−40%
100%
200+
Out-of-sync stock, customers buying blind
A food distributor for hospitality was processing more than 200 orders a week. Their customers — restaurants, hotels, caterings — work on very tight timings. If the product doesn't arrive on time, service stops.
Core problem: the stock visible on PrestaShop didn't reflect the real stock in Sage 200. Updates happened manually, with CSV exports every few hours. Between one export and the next, customers ordered products that were already gone.
The fallout was predictable:
- Frequent stock-outs that hit already confirmed orders
- Hospitality customers constantly calling to confirm availability
- Customer service spent hours manually checking stock in Sage
- Orders processed on PrestaShop that didn't exist in Sage until hours later
- No traceability: the customer placed an order and didn't know its status until delivery
The result was an online order system that created more work than it saved. The pickiest B2B customers just called by phone to confirm stock before buying.
Direct Sage 200 connection + stock alerts + automatic orders
Integrafy Core connected Sage 200 using direct SQL access for reads and COM for writes. No additional middleware was installed, no Sage configuration was changed. The connection reads stock, items and orders tables in real time.
The AI module watches stock levels and detects when a product drops below the configured minimum threshold. At that point it generates automatic alerts for the purchasing team and can trigger restocking suggestions based on sales history.
Flow automates the full order lifecycle:
- PrestaShop order → automatic stock validation in Sage 200
- Automatic creation of the delivery note and order in Sage
- Status update on PrestaShop at every stage (confirmed, preparing, shipped)
- Customer notification with real order tracking
PrestaShop stock now refreshes every 30 seconds from Sage 200. When a customer visits the store, they see real availability.
Integration architecture
1. Integrafy Core connects to Sage 200 via SQL (direct read)
2. Reads items, stock per warehouse and pricing tables
3. Continuous sync every 30 seconds → PrestaShop
4. B2B customer places an order on PrestaShop
5. Flow validates real stock in Sage 200 before confirming
6. Confirmed order → Integrafy creates delivery note in Sage via COM
7. AI watches stock below threshold → restocking alert
8. Status change in Sage → updates PrestaShop automatically
9. Customer gets notification on every status change«Stock-outs dropped by more than half. And our customers don't call anymore to ask where their order is.»
Real stock, frictionless orders, self-serving customers
In the first 3 months after rollout, stock-outs dropped by 60%. Order follow-up calls went down 40% because customers could check status directly on the store.
Customer service stopped being a middleman between Sage and PrestaShop. The 200+ weekly orders are handled automatically, with no manual intervention. The AI module spots seasonal demand patterns and suggests preventive restocking before stock runs out.
Customers have full traceability of their order from the moment they place it until delivery. Sage 200 and PrestaShop behave as a single system.
Does your online stock fail to reflect the ERP reality?
We connect Sage 200, SAP, Odoo and other ERPs with your store in real time. No migrations. No risk.