Shopify Integration


Sync inventory, pull sales information, sync products to and from Shopify.


Prerequisites



  1. Shopify Integration Setup
  2. Catalog
  3. Orders and Sales
  4. Operation Logs
  5. Common Troubleshooting Issues


Shopify Integration Setup

[back to top]


First you must connect DEAR to your Shopify store.


It is possible to link several Shopify stores to a single DEAR account. Each linked store has independent catalog, logs and settings.


To connect Shopify to DEAR: 

  1. Navigate to Integration -> Shopify

  1. Click the + to connect a new store. 
  2. Enter your Shopify portal name and click Connect to Shopify

  1. You will be redirected to the Shopify login screen. Enter your details and continue. 
  2. You will be asked to confirm sharing data between Shopify and DEAR. Click Agree to continue. 

  1. You will be directed back to DEAR to complete the setup. 
  2. Repeat these steps to connect as many Shopify stores as you require



Integration settings

[back to top]


In the Setup tab, several integration settings can be customised.


 

Order Capture

This option specifies when a Shopify Order will be captured: when it is created, when it is fulfilled or when it is paid in Shopify. This setting is also taken into account when downloads of historical orders from Shopify are triggered.



Consolidate Orders

DEAR - Shopify Integration allows two options for order consolidation.

  • No Consolidation

  • Daily Consolidation


No Consolidation indicates that sales will be captured from Shopify as they occur. Daily Consolidation will consolidate all orders from that day into a single order. When Daily Consolidation is chosen, an additional setting becomes available: Consolidation Time. This is your local time when all pending orders aggregated during the day will be processed.


See Pending Order Processing section for more details below.



Customer

For the pending order processing to be successful, an existing customer must be selected.


When Consolidation Type is Daily Consolidation, this customer is used to create a new sale task which will combine all daily sales. A customer can be created in DEAR just for this purpose.



Use Company as a Customer

This parameter only has an effect when the No Consolidation option is selected.

In Shopify, each sale order has optional field Company which can be filled in by a customer. If you would like DEAR to create a customer using the company name (as opposed to the Customer name attached to  the sale order in Shopify) this option should be selected.



Pick, Pack and Ship Processing Mode

When pending orders are processed by DEAR new sale tasks are created. This setting tells DEAR if it should try to Auto Pick, Auto Pack and Auto Ship these tasks. If there is not enough stock on hand to pick the full quantity of products in an order, then pick will remain in Draft state and Pack and Ship won’t be completed.


DEAR does not pick up shipment information from Shopify if auto-ship is selected and will not create fulfilment in Shopify in this scenario (if Auto Ship is enabled).



Invoice Status

You can control Invoice Status for Sale tasks created as a result of pending order processing. By default, Invoice will not be authorised and will be in Draft state, adjustable and waiting for authorisation. However if this setting is changed to AUTHORISED the invoice will be automatically authorised and pending sync will be created for it to sync with accounting application of your choice.



Update Stock Levels in Shopify

You may choose to disable automatic stock level update in Shopify performed by DEAR at the time available product quantity changes in DEAR. This may be useful if you are managing stock level in Shopify manually and do not want DEAR to change it. Please ensure you have the correct stock quantities entered in DEAR before you turn on this option as these values will override the stock quantities in Shopify. 



Allow users to purchase item, even if it is no longer in stock

This setting is applied on a per product variation basis. You will need to update/list the out of stock products from your DEAR catalog in Shopify to apply this setting. 



Create fulfilment in Shopify even if tracking number is not available

When this parameter is enabled, DEAR will create fulfilment in Shopify even if a tracking number is not available. This option can be useful if you do not use a fulfilment service. 



Allow DEAR to create Shopify products when DEAR product names are not unique

When this parameter is enabled, DEAR will create a new Shopify product for every not listed combination of product name + SKU which could not be found in Shopify.


Bring Discount Codes from Shopify

When a discount is applied to a sale in Shopify, DEAR can bring the discount code through as an Additional Charge on the sale order. This will create unique service products in DEAR for each unique discount code in Shopify that is applied to a sale. 



Add company to address

Enable to add company name to the address line for the order. 



Location 

Shopify does not allow use of multiple warehouses. Each Shopify store can have a dedicated Location within DEAR which can be selected from the drop down menu. Selecting a particular warehouse will limit the availability of stock in Shopify to that location. The default option, All Locations, will display consolidated stock quantities across all of your locations.



Gift Card Liability Account

DEAR will use this Liability account instead of a Revenue account for Gift Card sales. This account should have ability to accept payments. If a sale is made which contains a gift card, this sale will remain in the Pending Orders area until Gift Card Liability Account is specified. It is mandatory to choose an gift card liability account if using the Shopify Gift Certificate feature. 



Optional revenue account

Revenue account to be used for all sales downloaded from Shopify. This will override settings at the Product/Customer level and any other Account mapping. 



Sales Representative Name

This option allows the shop name to be used as Sales Representative. 


[back to top]


Tax Rule Mapping

When pending order is processed by DEAR, a sale task is created. Each order and invoice line is assigned a tax rule. The tax rules specified in these settings will be used to create these lines. 


DEAR does not apply the tax rule to recalculate tax and is simply using the actual tax amount from the Shopify order. This means that if certain products are not Taxable or with varying tax in Shopify, all data and totals in DEAR will look identical to Shopify, but with DEAR tax rule name selected in this setting.


The Tax Free tax rule mapping specified in this setting is used to create these lines for non-taxable products. This tax mapping could be useful for accounting.


In case of tax recalculation Tax amount will be overwritten with value calculated by DEAR Taxation rule.


IMPORTANT:  Orders will be skipped on download if Taxation mapping not finished! 


NOTE:  For US Shopify stores the provided Sales Tax is used instead of Tax Rule mapping.



Payment Account Mapping

DEAR can capture payments made against orders in Shopify and is able to automatically add payments to a created sale invoice. To do this, Payment Account Mapping must be completed on this integration settings screen. You must choose an account which is able to receive payments from the chart of accounts. 


This setting is not mandatory - if payment mapping is not completed, orders are still captured and downloaded from Shopify, but payments must be manually added to invoices in DEAR. Some customers prefer to keep invoices open and then reconcile them with payouts from Shopify. 



Disconnect from Shopify store

When you disconnect from Shopify store, DEAR removes all associations between DEAR objects and Shopify, including Log and Product Catalog.



Catalog

[back to top]


The DEAR Shopify Catalog page allows user to Download products from Shopify, break the link between a DEAR product and its Shopify listing and update quantities in Shopify according to DEAR available stock.



Downloading Products

[back to top]


Products can be loaded from Shopify to DEAR in the Catalog tab by clicking Load Products. This operation may take some time. 




Products in Shopify can be downloaded as simple Products or as Product Families with up to 3 options, similarly to in DEAR. When downloading products from Shopify, DEAR checks if the product in Shopify is a single product or if it has multiple variations. If Products and Product Families have already been created/linked with Shopify then DEAR updates the existing Products/Product Families instead of creating new ones.


In Shopify, Product SKU is not a unique field whereas it is in DEAR. If there is a conflict, DEAR processes only the first product with a duplicated SKU and skips the others, displaying a warning message about skipped items at the end of the download process. 


Data mapping for products between DEAR and Shopify is as follows:


SKU

Listing SKU if defined, otherwise first 50 characters from combination of (Product title + Option 1 Value + Option 2 Value+ Option 3 Value)

Name
Product title + Option 1 Value + Option 2 Value + Option 3 Value
Category
Product Type
Description
HTML Product Description
Weight
Weight (Converted to KG)
Barcode
Barcode
Price Tier. Default is Price Tier 1
Price
Images
Small product image
Product Tags
First 256 characters of Product Tags
Option 1 Value 
Option 1 Value
Option 2 Value
Option 2 Value
Option 3 Value
Option 3 Value 



Manage Catalog 

[back to top]


There are two possible statuses for products in the Catalog: Not Listed and Listed. 


NOTE: Updating products from the catalog will update the stock level in Shopify regardless of the related Quantity update setting status.


To list a product on Shopify:

  1. Click on the product in the Catalog tab. 
  2. In the pop-up Window, click List on Shopify
  3. Save your changes


To change prices on Shopify:

  1. Click on the product in the Catalog tab. 
  2. In the pop-up Window, change the Price Tier of the product. To manually change the Price Tier cost, you will need to go to the Product in DEAR.
  3. Click Save or Update on Shopify.





To unlist a product on Shopify:

  1. Click on the product in the Catalog tab. 
  2. Click Unlink
  3. Save your changes




To remove a product from Shopify:

  1. Click on the product in the Catalog tab. 
  2. Click Remove from Shopify
  3. Save your changes



Bulk Listing

[back to top]


As well as listing products individually, products can be listed in bulk.


To list products on Shopify in bulk:

  1. Go to the Bulk Listing tab
  2. Select products to upload in bulk. You can select products by Category, Family, Product Tag, Price Tier, Listing Status and through manual search.
  3. Click Start to upload all selected products.


 





Orders and Sales

[back to top]



Processing Pending Orders

[back to top]


When a Shopify store is connected to DEAR, automatic notifications are triggered whenever the following happens:

  • Shopify Order is created
  • Shopify Order is fulfilled
  • Shopify Order is paid

  • Shopify Order is cancelled

  • Shopify Order is deleted


Depending on the Order Capture setting selected, DEAR will capture a Shopify Order and save it as pending order when the Order is created, fulfilled or paid. Sometimes it takes up to 10 minutes for the order to be picked up by DEAR because Shopify may send notifications with some delay.


Whenever a sale is captured from Shopify it is first placed into Pending Orders, and stock is allocated immediately. DEAR imports new orders immediately as individual sale orders (if No Consolidation is selected in the Integration Settings) or once a day as a consolidated sale order (if Daily Consolidation is selected). 


If No Consolidation is selected, each Shopify sale is converted into an identical sale in DEAR, keeping the same customer and shipping information. If Daily Consolidation is selected, the single daily sale task will use the customer selected in the integration settings, and customer, billing and shipping information imported from Shopify will be ignored. 


When a Shopify order is canceled or deleted, DEAR automatically find and voids the corresponding sale task if created or removes associated pending order if the order has not yet processed.


When processing orders, the logic is identical to that of the DEAR UI. DropShipping, Kitting and other important scenarios are implemented in the same was as through the DEAR UI.


Pending Orders can be processed manually by clicking Process. They can then be viewed in the Log tab.



Downloading Customers

[back to top]


The Load Customers button can be found next to Load Products. 



This function downloads all customers from Shopify to DEAR. If the customer already exists in DEAR, this function updates any details that have been changed in Shopify. As DEAR automatically creates customers when processing sale orders (if No Consolidation option is selected), this function is generally only used for testing purposes. 


This function creates a customer in DEAR with Contact, Billing and Business addresses captured from Shopify.



Downloading Orders and Payments

[back to top]



Orders are automatically downloaded if their status in Shopify is changed (for example, a customer pays for an order). 



NOTE:   Generally, you do not need to trigger manual order download, however if an order was not captured by DEAR or to load historical sales you can use manual Load Order option.


Any imported order is saved to the Pending Orders section. It is a temporary storage of all sales and payments in DEAR. If an order already has an entry in the Log (i.e. was imported previously) it will be skipped. This guarantees that no duplicate sales will be created by DEAR.


While saving orders, DEAR captures customer information, billing and shipping addresses. All line items are captured together with quantities, prices and totals. Total order discounts are applied as are additional charges to the whole order, without distribution by lines to reduce the chance of discrepancy.


Shipping and handling are also saved as additional charges in the Sale invoice under Shipping.


If a Payment Account has been specified in the Integration Settings, DEAR will always assign associated payments to the captured Shopify orders.


When an Shopify order is cancelled, DEAR automatically finds and voids the corresponding sale task if already created as a Sale Order or just removes the associated pending order if not yet processed.


The final step in the order download is to trigger update of stock levels in other Shopify stores and other connected eCommerce channels.



Updating Fulfilment in Shopify

[back to top]


When Shipment is authorised in DEAR and the carrier specified, DEAR will try to create order shipment information in Shopify. This will only work in No Consolidation processing mode.



Logs

[back to top]


Each captured Shopify order once saved to Pending Orders creates a Log entry to track the link between the Sale in DEAR and in Shopify. This eliminates the possibility of creating duplicated orders when capturing the same order several times during manual order load. 


Each Log entry has a link to the sale task in DEAR. Depending on the settings selected by the user in the Setup tab, this sales task could be draft or authorised, one or more of the Pick, Pack and Ship tabs could be authorised, and payment could have been applied to the invoice. 


Log entries allow you to see which Sale task reflects a particular Shopify sale. You also have the option to delete a Log entry manually. This will allow to reprocess an order if required. Deleting a log entry will not void or delete its associated sale task.




Reloading Orders from Shopify

[back to top]


If for any reason you need to reload an order from Shopify, this can be managed from DEAR.


To reload an order from Shopify:

  1. Void the sale task. A record of this will be kept in DEAR for reconciliation purposes but the transactional data will be deleted. 
  2. Return to the Shopify integration Log tab and delete the Log entry. This will allow the order to be recaptured from Shopify.
  3. Navigate to the Pending Orders tab and click Load Orders, making sure the date is set to before when the order to reload was made. 


Operation Logs

[back to top]


Each time when user or DEAR downloading sales appropriate record added to operation log. It also contains information about results of downloading, including the count of processed, skipped or cancelled orders.




Common Troubleshooting Issues

[back to top]


When attempting to list a product on Shopify, it may fail. There are two well-known reasons for this:


  • Your product family contains more than 100 products/variations. Shopify has a limit of 100 variations per product. The first 100 variations will be successfully listed but any additional variations will fail.The only way to resolve this is to restructure the DEAR Product family to have less than 100 variations. You may need to remove listed variations from Shopify first.

  • Some of your products in a family have identical option values. Shopify requires that each variant in a product has unique set of 3 option values.