Clarity Connect integration
WooCommerce Sage 100 Integration
Have every WooCommerce order arrive in Sage 100 as a sales order, and let Sage 100 set the stock, prices and shipping details your store shows.
What moves between WooCommerce and Sage 100
WooCommerce is where customers browse and check out; Sage 100 is where the order is picked, invoiced and paid off. Clarity Connect carries the order into Sage 100 and carries item, stock and shipment updates back, so nobody copies data between the WordPress admin and Sage 100 screens.
WooCommerce
Orders, shoppers and the product pages they see
- Orders
- Customers
- Products and variations
- Refunds
Sage 100
Items, warehouses, invoicing and receivables
- Sales orders
- AR customers
- Items and warehouse quantities
- Invoices and tracking numbers
WooCommerce to Sage 100 record mapping
A common first map. Discovery settles the fields, numbering and rules for your company.
| WooCommerce | Sage 100 | Direction |
|---|---|---|
| Order | Sales order | WooCommerce to Sage 100 |
| Customer | AR customer | Both ways |
| Product or variation (by SKU) | Item | Sage 100 to WooCommerce |
| Stock quantity | Quantity on hand by warehouse | Sage 100 to WooCommerce |
| Order status and notes | Invoice and package tracking numbers | Sage 100 to WooCommerce |
| Refund | Credit memo | WooCommerce to Sage 100 |
How the WooCommerce sync works
Orders out of WooCommerce
WooCommerce fires an order.created webhook at checkout. Connect takes the order, finds or creates the Sage 100 customer, and writes the sales order through Sage's SO_SalesOrder_bus business object, which runs the same validation as an order keyed in by your staff.
Stock and prices from Sage 100
Quantities live in Sage 100 per item and warehouse. A scheduled Connect task reads them and updates each WooCommerce product or variation, matched by SKU, so the store stops selling an item once the warehouse runs out.
Custom fields on both sides
Many Sage 100 sites add user-defined fields (UDFs) to customers, items or orders. WooCommerce orders, products and customers carry meta data through the REST API, so a UDF such as a PO number or a ship-by date can be mapped across during discovery.
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.
The interfaces each side offers
WooCommerce exposes orders, products, customers and refunds through its REST API (version 3, under /wp-json/wc/v3), authenticated with a consumer key and secret over HTTPS. Its webhooks cover orders, products, customers and coupons, and by default WordPress sends them in the background through wp-cron, so a low-traffic site can send them late. A scheduled task that rereads recent orders is a sensible backstop.
On the Sage 100 side, writes go through Sage's Business Objects Interface, a COM interface included with every Sage 100 activation. Connect therefore runs on a machine on your network that can reach the Sage 100 installation.
How Clarity Connect runs it
Clarity Connect is Clarity's integration platform. It keeps WooCommerce and Sage 100 linked in both directions and runs each flow, orders in, stock out, tracking back, as a separate task on its own timing. Clarity has built more than 3,000 integrations on Connect; recorded demos are in our video playlist, and other pairings are in the integrations directory.
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
Can WooCommerce orders reach Sage 100 the moment they're placed?
Yes. The order.created webhook triggers the task that posts the sales order. Because WordPress sends webhooks in the background, a scheduled check for any order the webhook missed can run alongside it.
Does Sage 100 need extra modules for this?
Not for the connection itself. The Business Objects Interface comes with Sage 100. Visual Integrator, a separately registered module, is only needed if your project uses its import jobs.
Can our Sage 100 custom fields come across?
Usually, yes. Sage 100 user-defined fields can be mapped to WooCommerce meta data on orders, products or customers; discovery decides which ones and in which direction.
What does it cost?
It's $599 a month as SaaS, or $15,000 for a one-time license with no ongoing fees, and larger projects are priced to scope. See pricing.
Related resources
Connect WooCommerce and Sage 100
Tell us which orders, items and customer fields need to move between your WordPress store and Sage 100. A Clarity business analyst maps them with your team before the build begins.
Book a demo