How Clarity Connects Systems: Clarity eCommerce and Sage X3

Hi, Ron from Clarity. Today, I’m going to show how Clarity Connect, our integration platform, can integrate your Sage X3 Enterprise Management ERP with any front-office portal, in this case, our Clarity eCommerce platform. As a side note, Clarity is also a certified Sage X3 partner.

For the sake of the demo, I’ll only be syncing 3 fields:

  • The first is the Sage Product Description field, which our client has populated with the name of each of their products. So we map this to our eCommerce Product Name field.
  • Next, they use the Product field, as a unique Product ID field, which syncs with our unique Product Key.
  • Finally, to have the product show up in the catalog, we’re monitoring the Product Status field and mapping that to our Is Visible field.

So now that the fields are mapped, let’s go look at our test product we’ve created in Sage. Under common data, we’ve got our products and this is the most recent product we created. As you can see, just as the mappings showed, we’ve set our Clarity Test Product, ID 7777 as Active. After our first Connect sync, we can now go over to our Clarity eCommerce Admin UI and view the product that was created via the API.

To test that both directions of the integration are configured correctly, we’ll change the name of the product to Clarity Test Product Changed, and to show you what’s going on behind the scenes, we’ll go into our Connect Hangfire queue. We currently have the SyncProducts Job running every 15 minutes, so to see it run now, we’ll just check the box for that job and click Trigger Now. We can see that it’s Triggering and run.

So we’ll go back over to our Sage X3 UI, re-launch our Products page and we can see that the name’s been updated per our edit.

Now, this demo just showed you 3 fields. In a normal integration, we’re syncing dozens of fields, validating and creating users, looking up tiered pricing for affiliate types, pulling products and inventory counts, pushing sales orders and quote requests, processing purchase orders to vendors and much more.

To learn what we can do for your integration project, give us a call. Thanks for watching.