How Clarity Connects Systems: ASP.Net and Syspro

Intro (display slide-both.jpg) :07-:47

Hi, Ron from Clarity. This video will demonstrate a few of the workflows from our ASP.net Storefront to Syspro integration solution. This client, TC Wilson wanted a quick and custom integration to automate their user registration and sales orders from their online ASP.NET storefront into their Syspro ERP.

They also wanted us to manage their catalog by populating products, pricing and inventory from the ERP to the storefront, which we’ll show you during the demo.

As a modular architecture, once we develop a connector to an application, that allows us to integrate any application to that app. So we can integrate ASP.net storefront to any CRM, ERP and Supply Chain, or integrate any storefront, omnichannel or portal to Syspro using the connectors we’re demoing here.

ASP.net user registration

First off, we’ll start in the ASP.net storefront, where my developer has created a Contact record for a user called “Syspro sync”. All the required fields are populated, such as name and email, and once saved a user system ID of 87790 is generated.

Let’s fire up Connect and look at the Recurring Jobs we’ve created. You can see the first two jobs, one which syncs all orders from the storefront to the Syspro, and the second bringing all phone, email and fax orders entered into Syspro back into the storefront. The third job, the one we need, Syncs the customer list from ASP.net storefront into Syspro. We’ll check that job and Trigger it. If you want, you can click on jobs, processing and watch your job process. There’s a plugin that you can install, which allows you to drill into the job and watch the physical data being processed.

Once the job has cleared the queue, we’ll pop into Syspro and search for our ID, 87790, and it displays our Syspro sync user, with the email that we entered.

Price Table adjustment

Next, while we’re in Syspro, we’ll go look at a product, which in the storefront is currently listed at $346.08, since the product has assigned Price Code A as it’s list price. If we click on the price code, we can see the pricing table assigned to this product, and it’s got 6 tiers. For this example, we’ll change the list price to Code D, which typically changes as a client logs in, which once run will reset the list price in the storefront.

We’ll save the price code D, then pop into Connect and run the Product prices from Syspro to storefront job, move into ASP.net storefront and search for our SKU. Once we find our product, we drill in and see that the list price is now $491.31, or that assigned by the price code in Syspro. This is how prices automatically display differently for customer-specific pricing. All customers in Syspro are assigned to one of their 6 price codes, and when they log into the storefront, it displays the appropriate pricing based on that price code.

Create a product

For our final job, we’ll go back into Syspro and create a quick product. Each product can have multiple variants, so with their configuration, when I created product 12345, and set a price of $100.00, that by default becomes the first variant of the master product 12345. We could go in and assign an inventory location, and more, but for this example, we’ll just sync the base variant.

Within the Recurring jobs, we’ll select and trigger the Product list from Syspro to storefront job, which processes the product catalog listings.

Finally, we’ll go into the storefront admin and look for our new product, SKU 12345. Once we see our product, we drill in, then click on Manage Variants to see all of the variants we’ve created. As we only created the one price, we only see one variant, ID 80327, so we drill in to see that this is indeed our $100.00 variant that we created and sync’d from Syspro.

Summary

So, in summary:

We created a user in the online store. We then sync’d the user to Syspro, which is now automated for the client. We then checked Syspro to see that the user was created properly.

We then modified a product’s default list price in Syspro and synced that to the storefront.

And finally, we created a new master product with a single priced variant, synced that to the storefront and verified that it was available for posting to the catalog.

So that’s a quick view of Clarity Connect’s ASP.net storefront to Syspro integration.

Thanks for watching.