Clarity Connect integration
WooCommerce Dynamics NAV Integration
Post WooCommerce orders into Dynamics NAV as sales orders and let NAV's items, stock and shipments keep the store current, with Clarity Connect running both directions.
What moves between WooCommerce and NAV
WooCommerce is where customers browse and buy; NAV is where those orders are fulfilled, invoiced and posted. The integration hands each web order to NAV without retyping and sends NAV's catalog, stock and shipping updates back to the store.
WooCommerce
Orders, shoppers and the web catalog
- Orders
- Customers
- Products and stock quantities
- Refunds
Dynamics NAV
Fulfillment, inventory and accounting
- Sales orders
- Customers
- Items and inventory
- Shipments, invoices and credit memos
WooCommerce to Dynamics NAV record mapping
A usual first draft of the map. Discovery settles the fields and rules for your NAV setup.
| WooCommerce | Dynamics NAV | Direction |
|---|---|---|
| Order | Sales order | WooCommerce to NAV |
| Customer | Customer | Both ways |
| Product (by SKU) | Item | NAV to WooCommerce |
| Product stock quantity | Item inventory | NAV to WooCommerce |
| Order status | Posted sales shipment | NAV to WooCommerce |
| Refund | Sales credit memo | WooCommerce to NAV |
How WooCommerce and NAV stay in step
Each web order becomes a NAV sales order
WooCommerce can fire a webhook when an order is created. Connect receives it, maps the order lines by SKU to NAV item numbers and creates the sales order through the NAV web service you publish for it, creating or matching the NAV customer as it goes.
NAV keeps the catalog honest
NAV holds the item master, prices and inventory. Connect reads them on the schedule you set and updates the matching WooCommerce products, so the store doesn't take orders for items NAV can't ship.
Shipments and refunds close the loop
When NAV ships an order, the update goes back to WooCommerce so the order status changes and the customer hears about it. Refunds issued in the store can be passed to NAV for finance to raise the credit memo.
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.
What each side exposes
WooCommerce's REST API (current version wc/v3) covers orders, order refunds, customers and products, and its webhooks report events such as new orders. NAV 2018 publishes pages and codeunits as SOAP web services, and pages also as OData, which is how Connect reads and writes NAV records.
Clarity has shown this pattern with its own store: in Clarity's recorded Connect demo, Clarity eCommerce orders reached a client's NAV system in about four seconds and NAV's order status came back to trigger the customer's email. If you're moving to Dynamics 365 Business Central, the NAV side switches to Business Central's REST API (v2.0) and the WooCommerce side stays as it is.
How Clarity Connect runs it
Clarity runs this integration on Clarity Connect, its integration platform, which holds a persistent, two-way connection between WooCommerce and NAV, with each flow set up as a task that runs live or on a schedule. If NAV is unreachable, the job is retried rather than lost. More walkthroughs are 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
Do WooCommerce orders reach NAV straight away?
They can. A WooCommerce webhook fires when an order is created and Connect creates the NAV sales order right then. Stock and price updates going back to the store usually run on a schedule.
Does NAV need to be in the cloud?
No. Connect can be installed on your network next to NAV and talk out only to WooCommerce, so NAV's web services stay off the public internet.
Will this still work after we upgrade to Business Central?
The flows carry over. The connection to the ERP changes from NAV's web services to Business Central's REST API; the WooCommerce side doesn't change.
What does it cost?
A SaaS subscription to Clarity Connect is $599 a month; a one-time license is $15,000 with no ongoing fees. Bigger projects are quoted to scope. See pricing.
Related resources
Connect WooCommerce and Dynamics NAV
Tell us how orders, items and stock should move between your store and NAV, and a Clarity business analyst will work through the data with you before the build.
Book a demo