Clarity Connect integration
WooCommerce Sage 200 Integration
Bring WooCommerce orders into Sage 200 without re-keying, and let Sage 200's stock, prices and despatch progress update your WordPress store.
What moves between WooCommerce and Sage 200
WooCommerce is the shop on your WordPress site; Sage 200 is where stock is held, orders are despatched and the accounts are kept. The integration moves orders into Sage 200 and brings back the stock, pricing and order progress your customers see online.
WooCommerce
The WordPress shop customers order from
- Orders
- Customers
- Products and variations
- Stock quantities
- Refunds
Sage 200
Where stock, despatch and accounts are run
- SOP sales orders
- Customer accounts
- Stock items and warehouses
- Price bands
- Sales invoices and credit notes
WooCommerce to Sage 200 record mapping
A typical starting map; discovery agrees the fields, VAT codes and rules for your Sage 200 company.
| WooCommerce | Sage 200 | Direction |
|---|---|---|
| Order | SOP sales order | WooCommerce to Sage 200 |
| Customer | Customer account | Both ways |
| Product or variation (SKU) | Stock item | Sage 200 to WooCommerce |
| Stock quantity | Stock across the chosen warehouses | Sage 200 to WooCommerce |
| Regular price | Price band price | Sage 200 to WooCommerce |
| Order status and tracking | Despatch details | Sage 200 to WooCommerce |
| Refund | Credit note | WooCommerce to Sage 200 |
How the WooCommerce and Sage 200 sync works
Web orders become SOP orders
An order.created webhook from WooCommerce tells Connect a new order is in. Connect builds the matching Sage 200 sales order, with lines, delivery address and VAT, and posts it through the Sage 200 API for the warehouse to pick.
Stock and trade prices to the shop
WooCommerce keeps one stock quantity per product or variation; Sage 200 holds stock by warehouse and prices in price bands. Connect totals the warehouses you pick and sends the stock figure and prices to WooCommerce on a schedule.
Order progress and refunds
When Sage 200 despatches an order, Connect moves the WooCommerce order to completed and adds the tracking details. A refund issued in WooCommerce can be passed to Sage 200 so a credit note is raised.
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.
How each side connects
WooCommerce's REST API is part of the WordPress REST API, uses version 3 (wc/v3) and authenticates with a consumer key and secret. Its webhooks stop after five failed deliveries in a row, so a scheduled Connect task also checks for recent orders and fetches any the webhook didn't deliver.
Sage's Sage 200 API is a REST API for both Sage 200 Standard and Professional, signed in through Sage ID with OAuth 2.0. Every request names a Sage 200 site and company, and on Professional the API is set up by your Sage 200 business partner before the integration goes live.
How Clarity Connect runs it
Clarity Connect is Clarity's integration platform. It holds a persistent two-way link between WooCommerce and Sage 200 and runs orders, stock and despatch as separate tasks, each live or on a schedule. If Sage 200 is unavailable, jobs wait in a retry queue instead of being lost. Clarity has built more than 3,000 integrations on it; there are demos 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
Will WooCommerce orders appear in Sage 200 straight away?
Yes. Connect posts each order to Sage 200 as WooCommerce's webhook arrives, and a scheduled check catches any order a webhook missed.
Can trade customers see their Sage 200 prices?
Yes, if the store supports customer-specific pricing. Connect can pass Sage 200 price bands and account terms to WooCommerce for logged-in trade customers.
Which Sage 200 editions are supported?
Both Sage 200 Standard and Sage 200 Professional, since Sage's API covers each. Professional needs the API set up by your Sage business partner first.
How is it priced?
Clarity Connect is $599 a month as SaaS, or a one-time $15,000 license with no ongoing fees; larger projects are priced to scope. See pricing.
Related resources
Connect WooCommerce and Sage 200
Tell us how orders, stock and customer accounts should move between your WooCommerce shop and Sage 200. A Clarity business analyst will map it with your team before the build begins.
Book a demo