Clarity Connect integration
Shopify Sage 200 Integration
Turn Shopify orders into Sage 200 sales orders automatically and keep stock levels, prices and despatch details on the store in line with Sage.
What moves between Shopify and Sage 200
Shopify takes the order and the payment; Sage 200 handles the stock, the despatch and the accounts. The integration passes every Shopify order into Sage 200's sales order processing and sends stock, pricing and despatch updates back, so nobody types orders in twice.
Shopify
Where customers shop and pay
- Orders
- Customers
- Product variants
- Inventory levels
- Fulfillments and refunds
Sage 200
Where stock, despatch and the ledgers live
- SOP sales orders
- Customer accounts
- Stock items and warehouses
- Price bands
- Sales invoices and credit notes
Shopify to Sage 200 record mapping
A usual first map. Discovery fixes the fields, VAT handling and rules for your Sage 200 company.
| Shopify | Sage 200 | Direction |
|---|---|---|
| Order | SOP sales order | Shopify to Sage 200 |
| Customer | Customer account | Both ways |
| Product variant (SKU) | Stock item | Sage 200 to Shopify |
| Inventory level | Warehouse stock level | Sage 200 to Shopify |
| Price | Price band price | Sage 200 to Shopify |
| Fulfillment and tracking | Despatch details | Sage 200 to Shopify |
| Refund | Credit note | Shopify to Sage 200 |
How the Shopify and Sage 200 sync works
Orders straight into sales order processing
Shopify fires a webhook as each order is created. Connect maps the lines, delivery address and VAT to a Sage 200 sales order and posts it through the Sage 200 API, where it waits for the warehouse like any other SOP order.
Warehouse stock and prices to Shopify
Sage 200 holds stock per warehouse and prices in its price book. Connect reads the warehouses and price band you choose and updates Shopify's inventory and prices on a schedule, so the store isn't selling what the warehouse doesn't have.
Despatch and refunds
Once Sage 200 despatches the order, its tracking details complete the Shopify fulfillment, and Shopify can email the customer. Refunds issued in Shopify can go to Sage 200 so the accounts team raises the credit note.
See Clarity Connect move an order
Watch an online order travel into the ERP and its status come back in our Clarity Connect demo, or book a live walkthrough on your own systems.
Sage 200 and Shopify API notes
Sage's Sage 200 API is a REST API that serves both Sage 200 Standard and Sage 200 Professional, with sign-in through Sage ID using OAuth 2.0. On Professional it must be set up before an integration can use it, a step Sage expects your Sage 200 business partner to handle, and the endpoints on offer follow the Professional release you run.
Shopify now builds new Admin API features on GraphQL and treats its REST Admin API as legacy; new public apps have been required to use GraphQL since April 2025. Our Shopify connections use GraphQL so they won't need rework when REST is withdrawn.
How Clarity Connect runs it
Clarity Connect is Clarity's integration platform. It keeps a lasting two-way connection between Shopify and Sage 200 and runs orders, stock and despatch as separate tasks, live or on a timetable. Clarity has built more than 3,000 integrations on it; you can watch some in our video playlist.
Discovery
A Clarity business analyst documents the data fields and workflows each system can share and which ones you need.
Tasks and mapping
Each flow becomes a Connect task, such as orders to the ERP or stock to the store, set to run in real time or on a schedule.
Testing
Orders and updates are run end to end, including the return trip of statuses back to the customer-facing system.
Live, with a dashboard
Queues and scheduled tasks show in Connect's Hangfire dashboard. A job whose target is offline is retried 10 times, every 30 minutes, and can be re-queued once the cause is fixed.
Clarity Connect is sold as a SaaS subscription at $599 a month or as a one-time license at $15,000 with no ongoing fees, and larger projects are priced to scope. See pricing.
Questions
Does this work with Sage 200 Standard and Professional?
Yes. The Sage 200 API covers both editions. With Professional, your Sage business partner sets the API up first.
How is VAT handled on Shopify orders?
Each Shopify order carries its tax lines. In discovery we map them to your Sage 200 tax codes so orders post with the right VAT.
Can stock come from more than one Sage 200 warehouse?
Yes. We agree which warehouses feed the store, and Connect sends Shopify the stock for those warehouses on your schedule.
How much does it cost?
Clarity Connect costs $599 a month as SaaS or $15,000 as a one-time license with no ongoing fees; larger projects are priced to scope. See pricing.
Related resources
Connect Shopify and Sage 200
Tell us how orders, stock and customer accounts should move between your Shopify store and Sage 200. A Clarity business analyst will map it with your team before anything is built.
Book a demo