Search our Help.

After the Shopify Integration

Follow
ON THIS PAGE

Using the Shopify Integration tutorial video

Workflows for Unleashed's Shopify integration

Field Mappings

Using the Shopify Integration tutorial video

Workflows for Unleashed's Shopify integration

The following processes are base examples that demonstrate how Shopify aims to sync with Unleashed after the integration is activated.

Manage Products synced with Shopify

When Unleashed is Master:

  • Products created or edited in Unleashed will automatically sync to update Shopify.
  • Products created or edited in Shopify will not automatically sync to update Unleashed.

When Shopify is Master:

  • Products created or edited in Unleashed will not automatically sync and update Shopify.
  • Products created or edited in Shopify will automatically sync to update Unleashed.

For more details, see Shopify Product Synchronization.

Product pricing with Shopify

If your prices are to be tax inclusive in Shopify, select the "All taxes are included in my prices" checkbox on the Settings | Taxes page in Shopify. The below describes how the prices are synced in Unleashed if the Shopify prices are set to tax inclusive:

  • Tax value is excluded when importing the products prices into Unleashed.

  • Tax value is added to the Unleashed price when we create products in Shopify.

  • Product prices updated in Unleashed are sent to Shopify. 

  • If Shopify is set as "master" the tax rate will pull from Shopify and set within your product record in Unleashed.

Manage Stock on Hand Availability

When the setting "Export Stock On Hand to Shopify" is enabled in the Shopify integration's "Stock Configuration" setting, changes made to your inventory's available quantity in Unleashed will periodically export to Shopify, making Unleashed the master of your inventory. As such, all inventory management and reporting should be completed in Unleashed.

It is recommended that you do not make any manual changes to Stock Quantities in Shopify directly.

The following transactions in Unleashed can trigger a stock update to export to Shopify:

  • Receipting Purchases Orders
  • Dispatching Sales Shipments
  • Completing Assemblies or Disassemblies
  • Completing Stock Adjustments (Only Stock Adjustments with a Qty greater than 1)

NOTE: Only updates made to the stock availability of the warehouses enabled in the integration will trigger an export to Shopify. 

Receipting stock into Unleashed

  1. Receipt a Purchase Order in Unleashed.
  2. Stock on Hand for the receipting warehouse in Unleashed increases.
  3. If the receipting warehouse is enabled in the Shopify integration's "Stock Configuration" settings, the receipted product's updated Stock on Hand availability will export to Shopify.

Dispatching stock in Unleashed

  1. In Shopify, an order is created for your stock.
  2. When the Shopify Order is updated to match the "Shopify Order Status" allocated in the Shopify configuration settings, the order imports to Unleashed as a new Sales Order. 
    NOTE: The Sales Order will import and allocate stock from the warehouse allocated in the integrations "Inbound Warehouse Mappings" settings.
  3. Unleashed will attempt to create the Sales Order with the "Unleashed Order Status" allocated in the Shopify configuration settings
    • Parked
    • Placed
    • Completed: if there is not enough stock to fulfil and complete the Sales Order upon import, the Sales Order status will default to Parked status.
  4. Stock on Hand Availability in Unleashed decreases by the Shopify Order's quantity.
  5. The allocated/dispatched product's updated Stock on Hand availability will export to Shopify.

Manage Sales Orders imported from Shopify

Edit Shopify Orders in Unleashed

If a Shopify Order has imported to Unleashed, but changes have since been to the order in Shopify, those changes will not sync to the existing Sales Order in Unleashed and vice versa. Similarly, the Shopify Order cannot be imported again through the integration to replace the original Sales Order in Unleashed.

Enable the "Unleashed Manual Order Edits" setting in your Shopify Configuration to manually amend imported Sales Orders to realign them with Shopify.

For more details, see How to edit a Shopify order after it's imported.

Points to note:

  • Edits can only be made to the Sales Order in Unleashed if the stock on order has not been invoiced or dispatched. 
  • If a Shopify order has not yet imported to Unleashed but has since been edited in Shopify, the edited order will not import to Unleashed. You must create the Sales Order in Unleashed directly, bypassing the integration.

Keep shipments and fulfillments in sync

If the Shopify configuration setting "Keep shipments and fulfillments in sync" is enabled and Shopify Orders import to Unleashed with either "Parked" or "Placed" statuses, we recommend only using either Shopify or Unleashed to manage their fulfillment. 

With "Keep shipments and fulfillments in sync" enabled, and shipments are managed by Unleashed:

  1. Shopify Order imports, creating a Sales Order in Unleashed with a "Parked" or "Placed" status.
  2. A Shipment is created for the Sales Order in Unleashed.
  3. The Shipment is dispatched in Unleashed.
  4. The Shopify integration syncs the shipment to the Shopify Order, marking the Shopify Order as "Fulfilled" or "Partially Fulfilled".

With "Keep shipments and fulfillments in sync" enabled, and shipments are managed by Shopify:

  1. Shopify Order imports, creating a Sales Order in Unleashed with a "Parked" or "Placed" status.
  2. The Shopify Order is marked as "Fulfilled".
  3. The integration syncs the fulfillment to the Sales Order in Unleashed, creating and dispatching a Shipment.
  • If Shipment is created within Unleashed's order and not dispatched, any fulfillments in Shopify for the Sales Order will fail to import into Unleashed.
  • If the Sales Order's been dispatched in Unleashed by a Shopify fulfillment but the Invoice hasn't been completed the Sales Order's status will stay in it's current status, e.g. "Parked" or "Placed". The Sales Order will only update to "Complete" status when it's been invoiced and shipped.

Field Mappings

Products

Unleashed Shopify Notes: Import Products from Shopify to Unleashed
Product Code SKU This will not be overwritten. If the SKU is different, then a New Product Code will be created in Unleashed.
Product Description* Product Title*

If the Information is the same in Unleashed and Shopify, only the link will be established. If the Product has Variants then the Product Description will be updated in Unleashed with the Main Product Title and the Option Value.

Note: Unleashed cannot update Shopify Product Variant Title as this is a read only field in the Shopify API
Warning: Product Description & Product title are mandatory fields in both systems for product creation. If this field synchronisation setting is disabled, then new products cannot be exported.
Product Group* Product Type (Custom)*

Unleashed can only export to the Custom Product Type in Shopify.

Standard Product Types can be Imported into Unleashed. If the Shopify Product has a Custom & Standard Product Type, then the Custom Product Type will be imported.

If a Shopify Product is imported with a Standard Product Type, & Unleashed is the Master, then the Custom Product Type will be updated to match the Standard Product Type upon the next Synchronisation run.

If the Product Group name is updated in the Unleashed Settings, this change will be reflected in Shopify upon the next Synchronisation run.

Product Notes* Body (HTML)* If the information is different, then the Product Notes will be overwritten with the information in the Body in Shopify
Default Sell Price Variant Price Same as Product Notes.
Barcode * Barcode (ISBN, UPC, GTIN, etc.) * Same as Product Notes.
SOH Variant Inventory Quantity  
Default Image* Product Image*

If there is an image in Shopify, it will be added as the Default in Unleashed.

Note: only one image can be exported between the systems. If multiple images are present in Shopify these can be overwritten if Unleashed is the master.
Weight* Variant Weight*

Weight will be Synchronised only if the Weight Measurement in Shopify is one of the following units: Grams, Kilograms, Pounds (Lbs), or Ounces (Oz)

Note: if Measurement Systems differ between Unleashed & Shopify then an automatic conversion will occur as the data synchronises. The following conversion rates will apply:

Conversion to imperial:

  • Grams → Pound grams/453.592

  • Kilograms → Pound kilograms/0.453952

  • Ounce → Pound ounce/16

Conversion to metric:

  • Pound → Kilogram pound/2.20462

  • Ounce → Kilogram ounce/35.274

If the selected weight in Shopify is grams, then this will be converted to kilograms at the following rate: 

  • Grams → Kilogram gram/1000

Shopify Product fields NOT SYNCED to Unleashed Products

  • Tags
  • Vendor

Advanced Product Synchronization configuration

The fields marked with an * in the Product field mappings table above highlight data sets that can individually configured to be either included or excluded from automatic product updates synced across the Shopify integration. This will provide you with greater flexibility in how your Product Details sync between Unleashed and Shopify.

Click on Configure, next to "Advanced Settings" in your Shopify integration's "Product Synchronization" configuration option to review.

Screen Shot 2024-02-16 at 1.51.21 PM.png

Customers

To get the connection set correctly with no updates and no added Customers, import your Customers into Shopify with only the First Name, Last Name and Email Address, leave everything else blank. This will ensure the link is established between the two systems and you can update the other details later. 
Unleashed Shopify Notes: Import Customers from Shopify to Unleashed
Customer Code ID After the initial integration, when a new Customer is added to Shopify and passed to Unleashed, the Customer Code will be the ID number in the Shopify Customer URL.
Customer Name

First Name + Last Name + Company Name

The Customer Name in Unleashed will link to the First and Last Name fields in Shopify. If the First and Last names in Shopify are different, a new customer entry will be created with a new ID number from Shopify.

You don't need to enter both a First and Last Name. You can enter just a First Name, just a Last Name, or both.

Email Address Email Ensure the value is the same.
Note: If you have customers in Shopify with different names and the same email address, they will be created in Unleashed as new contacts of the customer that originally had that address in Unleashed. 
Note: You don't need to enter both a First and Last Name in the customer contact in Shopify. You can enter just a First Name, just a Last Name, or both, and it must have this, and an e-mail, to be considered valid.
 
Note: For the following fields, if the information is the same in Unleashed and Shopify, nothing will change only the link will be established. If the information is different, then the field will be overwritten with the information from Shopify.
Postal Street Address/PO Box Address1  
Postal Suburb Address2  
Postal Town/City City  
Postal State/Region Province  
Postal Country Country  
Postal Code Zip  
Phone Number Phone  
Notes Note  
Taxable (TRUE, FALSE)

Tax Exempt (no, yes)

 

Shopify Customer fields NOT SYNCED to Unleashed Customers

  • State (Active/Disabled etc.)
  • Tags

Sales Orders

Unleashed Shopify
Order Number  Name

Currency Code

Currency
Order Date Created At
OrderQuantity Lineitem quantity
Delivery Name Shipping Name
Address Line 1 Shipping Street
Address Line 2 Shipping Address1
City Shipping City
Region Province
Country Shipping Country
PostCode

Shipping Zip

Delivery Method

Shipping Method 

Order Comments Notes
Tax Rate Tax 1 Name
Total Tax Total Tax
Line Tax Rate Tax Line rate
Line Tax

Tax Line price

Shopify Order fields NOT SYNCED to Unleashed's Sales Order

  • Discount Codes
  • Financial Status
  • Tags
  • Payment Details

Shipments

Unleashed Shopify
Shipping Company Carrier
Dispatch Date Created (Fulfillment)
Tracking Number Tracking Number

Free Credits

Automatically sync Shopify refunds with Unleashed, enable "Shopify Refunds and Restocks" in your Shopify configuration and the following details will map to a Free Credit in Unleashed.

For more details, see Shopify Refunds and Restocks.

Unleashed Shopify
Credit Number Refund ID number
Credit Date Refund Created 
Product Code SKU
Qty Refund quantity
Tax Rate Tax Name
Return (checkbox) Restock items
Total Amount Refunded
Was this article helpful?
1 out of 1 found this helpful