Woocommerce and Unleashed Integration

Unleashed and Woocommerce Connector / Integration documentation

Today we will be showcasing a popular integration between Woocommerce and Unleashed. DSYNC can synchronize products, customers and orders between the two applications. We also offer free setup and support via our on-boarding team. For more information on our Woocommerce Connector - For more information on our Unleashed Connector

IMPORTANT: We perform lots of Woo/Unleashed integrations. As handy information - It is key that the products in Woocommerce and in Unleashed have corresponding SKUs or an identifier that will help us to link one product to another. A SKU is any type of reference that we can use to correlate items.  

Steps for integrating Woocommerce and Unleashed

Step 1: Load both WooCommerce and Unleashed onto your DSYNC dashboard. You will need to enter both sets of keys for your systems to be authorized to communicate. 

Step 2: Create links for you data to flow - For example

• Product <> Product 
• Customer <> Customer
• Sales Order (unleashed) to Order (Woo) 
• Cron Stock on Hand Updated (unleashed) to Inventory (Woo API)

Step 3 : Map your data between Unleashed and Woocommerce

We recommend using our ready made maps between Woo and Unleashed, however if you would like to customize please feel free.

Step 4: Turn on your data sync

Step 5: Test your data flows

WooCommerce and Unleashed integration:

Products - Creating and Syncing between Woocommerce and Unleashed:

• Create products in Unleashed and automatically create in WooCommerce. Unleashed does not have configurable products so all products with Variants from Woocommerce will be pushed to unleashed individually.  must have SKUs for us to be able to map it. In WooCommerce a SKU is not required ... DSYNC requires it to be different/unique for each product and also each variation
• Product attributes from Unleashed to Woocommerce include: Item name, item type (default value will be "simple"), status (default value will be "published"), SKU, description, cost (default value will be "Default Purchase Price"), sale price, and weight.
• Product attributes from Woocommerce to Unleashed include: Name, cost ("Default Purchase Price"), product code, description, and weight.
• Variants must be listed as simple separate products in both systems – they can’t be simple in one system, and then listed as child products under a parent product in another.
• This is because the sync is only able to handle a one-to-one product relationship between "simple" products in Woo

Orders/Sales/Transactions:

• When an order is made in Woocommerce it will send a live trigger to Unleashed. DSYNC can send orders from Woocommerce to Unleashed. 
• Order attributes from Woocommerce to Unleashed include: order number, item name, line items (SKU, price, sale price, quantity, tax, total), currency, warehouse (default value will be "main"), SalesOrderGroup (default value will be "Online Order"), delivery methods (default value will be "shipping_methods"), status (default value will be "completed"), customer name, email, address, and phone.

Customer Syncing between Woocommerce and Unleashed:

• Customers can be synced in both directions between Woocommerce and Unleashed. This is handy when a customer makes a change to personal details. The system can be set to amend the latest change.
• Customer attributes from Woocommerce to Unleashed include: customer name, email, default shipping address (only one address), and phone.
• Customer attributes from Unleashed to Woocommerce include: email, contact name, and address (only one permitted for shipping and billing)
• The default password will be set as "password123!" which can be changed manually within your DSYNC mapping.

Inventory between Woocommerce and Unleashed:

• Inventory integrations can be synced in both directions for Woocommerce and Unleashed systems.
• Inventory attributes from Woocommerce to Unleashed include: integration via the "sales orders" endpoint.
• Inventory attributes from Unleashed to Wooommerce include: integration via stock quantity ("Stock On Hand").
• Matching SKU is required for a successful inventory integration.

Custom development 

DSYNC is a very flexible data integration platform and can do some weird and wonderful integration features. If you would like extras not covered in the above work flow we do have a professional services option where we can custom code integration features. We charge a scoping fee if you would like something that is not part of the above integration flow. 

The first part of our demonstration is to showcase how easy it is to set up the integration and map the two systems together.

The second part of our demonstration showcases data moving from Woocommerce to Unleashed

And lastly we demonstrate data moving from Unleashed to Woocommerce

Let’s begin the setup phase:

• Step one is to sign up for a free trial with DSYNC
• The next step is to add Woocommerce to your blank DSYNC dashboard.
• To add Woocommerce to you DSYNC dashboard please follow these steps
• Click on “select from system templates”
• From the drop down list select “Woocommerce”
• Select “Add this system” 

Complete the Settings within the Woocommerce pop up box

Including the

• User Name
• Password
• Your Woocommerce URL

Enter in your Woocommerce Consumer Key and Consumer Secret. Part of authorizing your Woocommerce site is to enter in your Woocommerce Consumer Key and Consumer Secret. To obtain your API keys please follow the next steps

• Visit Woocommerce then Settings
• Click on Keys and Apps
• For a new key select “Add Key”
• Proceed to name the description of your key
• Then select generate API key
• Copy and paste the “Consumer Key” from Woocommerce into your DSYNC settings area
• Copy and paste the “Consumer secret” from Woocommerce into your DSYNC settings area

This will Add Woocommerce to your dashboard

Add Unleashed to your dashboard

The next step is to add Unleashed by following the below steps:

• Start by clicking in the top right hand corner by selecting “Plus System”
• Then select from system templates
• From the drop down list select Unleashed
• Select “Add this system”
• A pop up box will appear asking to enter the Unleashed “API ID” and “API Key”
• To locate your ID and Key please visit your Unleashed Dashboard
• Select “Integration” and then select “Unleashed API Access”
• Copy and paste your Unleashed API ID into your DSYNC settings area
• Copy and paste your Unleashed API Key into your DSYNC settings area

This will successfully add Unleashed to your DSYNC dashboard

Mapping Woocommerce and Unleashed

Phase two of the Unleashed and Woocommerce integration is to map your customer data, inventory data or sales order data. In this example, we will be mapping customer data.

• Create a link/ Relation: Let’s start by creating a link between the two systems data points. In this example we will need to click on “Customer” within the Woocommerce section then click on “Create a relation” then click on “Customer” under the Unleashed section.
• Name your link: This creates a link between the two data points, A pop up box will appear asking you to name your link.
• Create a new map: Next we will need to create a new map for the link we have just created. Click on the lines between the data points and select “new”
• Name your map: Now you have created and named a new map it is time to enter our Mapping section. Our mapping section is where you can set different data points to interact together.

Mapping tips:

• The DSYNC mapping engine is all drag and drop.
• It is important that you map any required fields, required fields are highlighted with a red asterisks.
• You can use custom fields to join different data points together
• Click to add fields to be mapped
• You can click several fields at once and then pair the data to the right endpoint

For the customer example, we will be mapping: Please let our team know if you are stuck with mapping any endpoints we also have paid setup and support. 

• Customer Code to ID
• Email to Email
• Contact First Name to First Name
• Contact Last Name to Last Name

Using Custom fields to set rules when mapping:

For “Customer Name” we will be trying something special by using our Mapping engine we can bend and join the data together.  In this example, we will be joining the first and the last name together to become the customers full name.

To set this up click on “First name” and then “last name” and then add a space in the “custom field” string element section. This will create three tiles for you to position in the mapping field as a rule for the data to display.

Proceed to select save on your data map.

To switch direction of your data flow simply click on the two arrows indicating the direction of the data.

Follow the same process by aligning the data points against the right endpoints. In this example we will be aligning the following data entities

When mapping data in the opposite direction:

• Email is mapped to Email
• First name is mapped to Contact First Name
• Last name is mapped to Contact Last Name
• Username is mapped to eMail, however it would depend on your login credentials
• Password is mapped to your password settings. For password we will also need to create a “Custom” rule to accommodate the right format 

Proceed to select save

The next step is to set the direction of the data flow

Then enable the synchronization by selecting the small enable button in the right corner.

Testing the Woocommerce and unleashed connector

Let’s test our Woocommerce and Unleashed integration

From your Woocommerce website – create a new customer

Lets call the new user “Luke Bob”

Continue the testing by entering all of the standard user’s information

As we select save and then visit our Unleashed dashboard a new User called “Luke Bob” has been synchronized.

We can also add new customers in Unleashed and have the customer reflected on your Woocommerce website.

For testing purposes let’s call the customer “Florian Unleashed”

As we select save and add the customer the customer information is synchronized.

This example showcased customer synchronization however DSYNC is used to sync product data between unleashed and Woocommerce and also update Sales orders from Woocommerce back to unleashed.

 When you see “The source rows does not exist.” It basically means there were no updates in Unleashed therefore no data is to be transferred into WooCommerce. 

Can you create a product in Unleashed and it will be automatically create in WooCommerce? Yes however must be simple product.