What goes wrong.
- Orders from two Shopify stores land in one company
- Foreign-currency orders posted at the wrong rate
- Shared products mapped to the wrong item number
Sage 300 + Shopify integration.
Orders, locations, refunds and gateway payouts, synced between Shopify and Sage 300.
- On-premises or hosted Sage 300
- Shopify online store
ChannelShopify order
FinanceShopify payout
MiddlewareRoute · map · validate
On-PremisesSage 300 Order Entry order
LedgerFees posted
StockShopify stock updated
Sage 300 and Shopify, explained
How does Shopify connect to Sage 300?
A Sage 300 Shopify integration maps each Shopify store and location to a Sage 300 company and location, creates orders in Order Entry with optional fields filled, and posts refunds and gateway payouts in the right currency.
Sage 300 + Shopify
Can several Shopify stores feed one Sage 300 installation?
Yes, and it is common: a group may run a South African Shopify store and an international one, each owned by a different company. Each store is connected to its own Sage 300 company, currency and locations. Products shared across stores are mapped per company, because item numbers and optional fields often differ, and consolidated reporting still comes from Sage 300 as it does today.
What moves between Shopify and Sage 300.
The field map we agree in discovery, before any code is written.
| Record | Shopify | Sage 300 | Direction |
|---|---|---|---|
| Products | Product variant SKU | Inventory Control item | Shopify ↔ Sage 300 |
| Stock | Inventory level per location | Location quantity | Sage 300 → Shopify |
| Orders | Order | Order Entry order | Shopify → Sage 300 |
| Customers | Customer | Accounts Receivable customer | Shopify → Sage 300 |
| Money | Gateway payout (PayFast, Peach Payments and similar, because Shopify Payments is not available in South Africa) | GL account | Shopify → Sage 300 |
| Returns | Refund | Credit note in Sage 300 | Shopify → Sage 300 |
| VAT | Shopify tax amounts | Tax class | Mapped |
Exact fields depend on your setup and are confirmed in the written field map.
Where Shopify–Sage 300 sync usually breaks.
What we see go wrong with this pair, and how the connector prevents it. A single Sage 300–Shopify connector is usually Integration hub or Enterprise integration scope; see integration pricing.
What we do.
- One Shopify store per Sage 300 company
- Currency rules agreed with finance and tested
- Product mapping maintained per company
Do you handle Shopify stores in different currencies with Sage 300?
Yes. Each store posts in its currency to the company that owns it, using the exchange rate approach your finance team specifies.
How much does a Sage 300 Shopify integration cost?
A Sage 300 to Shopify connector is usually Integration hub or Enterprise integration scope, from R15,000 once-off.
Your next chapter starts here
Sage 300 and Shopify, in sync.Let’s make it work.
Tell us how Sage 300 and Shopify are used in your business today. We’ll reply with a Shopify to Sage 300 field map and a fixed-scope proposal.
[email protected]+27 82 639 0925