Shopify Integration

Sync inventory, pull sales information, and sync products to and from Shopify. Customers who use Shopify can use Shopify as an online store or a POS store within the same DEAR integration. 


NOTE: When a refund is processed for an unfulfilled Shopify sale, this will cause an error with restocking the unfulfilled items. These will appear on the Log as Pending fulfillment. If you are experiencing this error, you will need to enable the Ignore restock for non-fulfilled sales setting. This setting is not enabled automatically in order to preserve system logic continuity for users.


Prerequisites


Table of Contents

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


Shopify Integration Setup

[back to top]


First, you must connect DEAR to your Shopify store.


IMPORTANT! It is possible to link several Shopify stores to a single DEAR account, with each linked store having its own independent catalog, logs and settings. However, only two (2) free external integrations are available under DEAR's standard subscription plan. If you plan to integrate more than two (2) Shopify stores or you have already integrated a couple of external platforms other than Shopify with DEAR, you will first need to purchase licenses for the additional external integrations under the My Subscription page.


To connect Shopify to DEAR: 

  1. Navigate to Integration → Shopify.
  2. Click + to connect a new store. 
  3. Enter your Shopify portal name and click Connect to Shopify.
  4. You will be redirected to the Shopify login screen. Enter your details and continue. 
  5. You will be asked to confirm sharing data between Shopify and DEAR. Click Agree to continue.
  6. You will be directed back to DEAR to complete the setup. 
  7. Repeat these steps to connect as many Shopify stores as you require.


Note: You will not be able to perform any operations on your Shopify store unless you authorise the connection between the store and DEAR.


Integration settings

[back to top]


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


Capture order when it is

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.


Regardless of the consolidation mode, credit notes and refunds will sync into DEAR automatically once the Shipping and Invoice tabs are authorised. See the Pending Orders Processing section below for more details.


Customer

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


When the 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 an 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.


Sale Price Tier

This is the price tier that DEAR will use as the default price when products are downloaded from and updated in Shopify.

 

Pick, Pack and Ship Processing Mode for online sales

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 sales downloaded from Shopify website. If there is not enough stock on hand to pick the full quantity of products in an order, then Pick will remain in the 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).


Fulfillment status for Shopify POS orders are managed from Shopify POS settings. See Fulfillment for Shopify POS orders for more information.


Process auto-assembly

This setting applies when products with an Assembly BOM and auto-assembly enabled are sold via the Shopify store. This dropdown field has two options:

  • For ordered quantity: Does not check stock quantity. Current auto-assembly eCommerce behaviour. An assembly order is created for the quantity specified in the sale order, regardless of stock availability. 
  • For minimum quantity required for picking:Assemble stock required to meet the quantity of specific sale order. 
    • If stock availability is negative, auto-assembly will produce a finished goods quantity which is more than the quantity ordered through sale order. 
    • If there is already stock available in inventory but not enough to fulfill the sale order quantity, auto-assembly will assemble the difference in quantity needed to meet the sale order requirement.
    • If stock availability exceeds sale order quantity, auto-assembly is not triggered.  


Stock availability is validated against the sale order location and does not take On Order quantity into account. 


Ignore Restock for non-fulfilled sales

When a refund is processed for an unfulfilled Shopify sale, this will cause an error with restocking the unfulfilled items. These will appear on the Log as Pending fulfillment. If you are experiencing this error, you will need to enable this setting. Restock/stock allocation quantities will be edited to match the fulfilled items of the sale.


Invoice Status

You can control the Invoice Status for Sale tasks created as a result of pending order processing. By default, an invoice will not be authorised and will be in the 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 an accounting application of your choice.


List Products as Draft

Enable this option to list products as Draft when they are uploaded to Shopify.

 

Update Stock Levels in Shopify

You may choose to disable an automatic stock level update in Shopify performed by DEAR at the time the available product quantity changes in DEAR. This may be useful if you are managing the 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 allows products to be sold through the Shopify store even if there is zero stock. When the setting is enabled and a zero stock product is sold, DEAR generates a backorder for the negative item quantity on DEAR end. When its disabled, the zero stock item cannot be sold through Shopify store even if the item is listed.


This setting applies to all listed products. Backordering at the product-level can be enable/disabled from the Catalog to override 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. If this setting is disabled, an additional charge will be created with the description "Discount". Item discounts can also be applied by reducing product prices, using the below setting Add a discount as


Add a company to the address

Enable this option to add the company name to the billing address after the order has been processed in Shopify.


Location for online sales

Location specified in this field defines which location will be set in DEAR sale header when sale is imported from Shopify (Online Shopify sales only). Only one default location can be set per Shopify online store. Selecting a location for online sales will limit the availability of stock in the Shopify store to that location. This dropdown allows a specific location to be chosen or the default location for your organisation (set from Settings → Reference Books → Locations and Bins). 


NOTE: This setting does not apply to Shopify POS sales. Shopify POS sales have a specific location set for them. The location mapping table (see below) is used to link Shopify POS locations to related DEAR location and to control stock level update process. 


Gift Card Liability Account

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


Optional revenue account

The 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 specified name to be used as a Sales Representative.


Add a discount as

Add a discount as an additional charge to the sale order or by reducing product prices. Shopify sends DEAR total discount value which includes discounts applied to individual items. This setting controls whether item discounts are applied as a product price reduction or as additional charges. Once the total value of item discounts has been applied as product price reductions, any remaining discount value is applied to the order as an additional charge. 


Auto-retry sale order sync

Occasionally, during order syncing from Shopify, some sales are not created on the DEAR end. This function retries the sale order sync daily at midnight to ensure all sales created in Shopify are also created on DEAR on a daily basis. This function is carried out automatically by the DEAR backend system. 


Any errors of failure to load sales through auto retry functionality will be captured in the operations log recorded under the subsequent sale record. Sale orders which fail to load will also generate an internal notification for DEAR users containing sale order details and error information. 



Link Shopify and DEAR Tax Rules (Tax Rules Mapping)

When a 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 used for accounting. However, If a DEAR tax rule is mapped to this Shopify rule, it will override any other taxes in cases where tax amounts are zero on the line.


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


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


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



Link Shopify Locations to DEAR Locations

Shopify Locations are downloaded every day from Shopify to DEAR. These can be mapped to DEAR locations here. 

If there is no mapping between Shopify locations and DEAR location, Shopify location will be mapped to stock from all DEAR locations. 


Products can be listed only to specific Shopify locations. Stock levels will update for each location according to which products are listed in that location. 


NOTE: This is a separate feature to the Location for online sales setting above, which specifies the sale header location for sales generated in DEAR from sales in your online Shopify store. 


 

Link Shopify Payment Methods to Payment Accounts (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 a 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 users to download products from Shopify, list a DEAR product in Shopify, break the link between a DEAR product and its Shopify listing, allow backorder of a product, 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 Download  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, similar to the current process 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, DEAR updates the existing Products/Product Families instead of creating new ones.


In Shopify, the 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 duplicate SKU and skips the others, displaying a warning message about skipped items at the end of the download process. The SKUs for skipped items can be manually entered in DEAR.


Except for the SKU, any changes in a product that has been downloaded previously from Shopify will also update the product's details in DEAR every time Load Downloads is clicked. The same is true when using the Bulk Listing feature to upload products from DEAR to Shopify.


If a product is not in the Catalog, but it is included in a sale, the product is automatically imported into DEAR.


If Update stock levels in Shopify is set to Yes in Setup, if a product is deleted from Shopify, any attempt to update the quantity in Shopify from DEAR will unlink the items, and the product will become unlisted in DEAR.


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


DEAR
SHOPIFY

SKU

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

NameProduct title + Option 1 Value + Option 2 Value + Option 3 Value
CategoryProduct Type
DescriptionHTML Product Description
WeightWeight (Converted to KG)
BarcodeBarcode
Price Tier. Default is Price Tier 1Price
ImagesSmall product image
Product TagsFirst 256 characters of Product Tags
Option 1 Value Option 1 Value
Option 2 ValueOption 2 Value
Option 3 ValueOption 3 Value
VariationVariation
BrandBrand


Manage the 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 status of the Update Stock Levels in Shopify setting.


To list a product on Shopify: 

  1. Click on the product in the Catalog tab. 
  2. Select the Price Tier for that product. 
  3. Choose which Shopify location(s) to map the product to.
    • NOTE: Mapping a product to a location will ensure that stock levels are correctly updated for that location. If there is no mapping between Shopify locations and DEAR location, Shopify location will be mapped to stock from all DEAR locations. 
  4. In the pop-up window, click List on Shopify.
  5. Save your changes.


To update price tier 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. See Pricing and Price Tiers for more information. 
  3. Click Save or Update on Shopify.


To send updated product information to Shopify: 

  1. Click on the product in the Catalog tab. 
  2. Make any changes to the product management settings here if applicable (e.g. location mapping, allow backorder status). Any changes to the product information that have been made in DEAR can be exported to Shopify by clicking 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. Click Save.


Bulk Listing

[back to top]


As well as listing products individually, products can be listed in bulk. If products are already listed, this action will update them.


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, Brand, Family, Product Tag, Price Tier, Listing Status, Products Listed in (another sales channel or store), and through manual search.

NOTE: If you have multiple stores in another sales channel, e.g. two different Magento stores, these will be displayed separately in the list of sales channels from which products can be selected for upload.

  1. Choose which Shopify location(s) to map the product to.
    • NOTE: Mapping a product to a location will ensure that stock levels are correctly updated for that location. If there is no mapping between Shopify locations and DEAR location, Shopify location will be mapped to stock from all DEAR locations. 
  2. Click List to upload all selected products.
  3. You can also select Unlist to remove selected products from Shopify or Unlink to break the link between Shopify product and DEAR product (but not remove the product from Shopify).


WARNING! Do not use the Bulk Listing feature if you are only going to update stock levels in Shopify. Since bulk listing updates other information from DEAR to Shopify aside from the product quantity, it may take longer than necessary. To update stock levels in Shopify, go to Integration → Shopify Catalog and click Update quantities in Shopify.


Allow backorder of individual products

[back to top]


DEAR Shopify integration has the option to globally enable/disable backordering of Shopify products with the setting Allow user to purchase item, even if it is no longer in stock. When the setting is enabled and a zero stock product is sold, DEAR generates a backorder for the negative item quantity on DEAR end. When it is disabled, the zero stock item cannot be sold through Shopify store even if the item is listed. However, backordering can also be enabled/disabled  at the product level. 


Allow backorder status of a product can be viewed from the Catalog or Bulk Listing tab. By default, it will be set to match the Allow user to purchase item, even if it is no longer in stock setting.


Clicking a product to open the product management window will allow you to enable/disable backorder at the product level. This setting will override the global setting.  (e.g. if backorder is disabled globally, it can be enabled at the product level and vice versa.)


NOTE: Only products with an assigned supplier can be backordered. 


This setting can be edited for several products at once from the Bulk Listing tab. There are three options: Allow backorder, Don't Allow, or Don't update existing setup


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 a 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). 


NOTE: During sale events, there can be a large spike of transactions created within a very short time period. This requires a large number of queries to sync all of the orders to DEAR. Shopify limitations on large numbers of queries can lead to delays in data loading and updates to related operations such as stock level updates, shipment updates, etc.

To handle these cases, an automatic backend configuration which checks for sales spikes and temporarily disables sale capturing and stock level updates to DEAR when Shopify API capacity is close to being exceeded. The pending sales will be logged and then uploaded with a single API call at 5 minute intervals. Sales created during the disabled period will be uploaded to the “Logs” table with the newly implemented status, “To be loaded” to process them later.  Manual loading of sales is not affected and the setting will automatically be returned to normal when the sales spike is over.


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.


NOTE: Refunds are processed in both No Consolidation and Daily Consolidation modes.


When a Shopify order is cancelled or deleted, DEAR automatically finds and voids the corresponding sale task, if created, or removes an associated pending order if the order has not yet been 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 way 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]


Products can be loaded from Shopify to DEAR in the Catalog tab by clicking Download → Products.


This function downloads all customers from Shopify to DEAR. If a 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 the 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. Customers cannot be uploaded from DEAR to 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, you can use the manual Load Order option if an order was not captured by DEAR or to load historical sales.


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 a 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 an update of stock levels in other Shopify stores and other connected eCommerce channels.


Fulfillment for Shopify POS orders

[back to top]


For DEAR Shopify integrations, the same business could have their operations running through a website and POS for the same Shopify store. Shopify users would like to have different fulfillment processes defined for the sales initiated through Shopify POS compared to through their Shopify website. 


Fulfillment method (auto pick, auto pick + pack, etc.) for online sales is managed from the integration setting 

Pick, Pack and Ship Processing Mode for online sales on the Setup tab of the DEAR Shopify integration screen.


Fulfillment status for Shopify POS orders is managed from Shopify POS settings. In Shopify POS settings, mark orders as fulfilled can be enabled or disabled (typically enabled if customers take their purchase with them upon payment). This fulfilled/not fulfilled status is passed to DEAR when the sale is downloaded to DEAR. 


NOTE: Shopify POS orders are marked as not fulfilled even if the POS setting is set to mark orders as fulfilled when there is at least one product with serial/batch costing method in the order. These orders must be manually fulfilled in DEAR. This is due to issues importing auto-fulfilled orders with serial/batch numbered products. 



Updating a 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 the 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 duplicate order records 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 reprocessing an order if required. Deleting a log entry will not void or delete its associated sale task.


NOTE: During sale events, there can be a large spike of transactions created within a very short time period. This requires a large number of queries to sync all of the orders to DEAR. Shopify limitations on large numbers of queries can lead to delays in data loading and updates to related operations such as stock level updates, shipment updates, etc.

To handle these cases, an automatic backend configuration which checks for sales spikes and temporarily disables sale capturing and stock level updates to DEAR when Shopify API capacity is close to being exceeded. The pending sales will be logged and then uploaded with a single API call at 5 minute intervals. Sales created during the disabled period will be uploaded to the “Logs” table with the newly implemented status, “To be loaded” to process them later. Manual loading of sales is not affected and the setting will automatically be returned to normal when the sales spike is over.



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 to set the date before the order to reload was made.


View Sales over time

[back to top]


You can view sales and returns over time for all connected stores as well as each individual Shopify store from Shopify Overview screen. Press Update after changing the filter options to refresh the display with the new information. 


Choose between showing:

  • Sales Count: The cumulative sales count for the sales period. The sales count will not consider deleted and refunded sales, but every other sale will be considered. 
  • Returns Count: The cumulative returned sales count of all the shopify stores (that belongs to the filtered period) that are connected to this integration. 
  • Gross Sales: The cumulative sales values of all the shopify stores (that belongs to the filtered period) that are connected to this integration. The sales will not consider deleted and refunded sales, but every other sale will be considered.


Results can be filtered according to the following ranges:

  • Today
  • Yesterday
  • Last 7 days
  • Last 30 days
  • Last 90 days
  • Last month
  • Last year
  • Week to date
  • Month to date
  • Quarter to date
  • Year to date
  • Custom date range


Results in the filtered date range are grouped according to the following options:

  • Day
  • Week
  • Month
  • Hour of Day
  • Day of Week


Operations Log

[back to top]


Each time when the user or DEAR download sales, an appropriate record is added to the 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]


  1. When attempting to list a product on Shopify, it may fail. This may be due to any of the following reasons:
    • 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 a unique set of 3 option values.

    • There might be a problem with your connection to your Shopify store. Go to the Bulk Listing tab on the DEAR Shopify Integration page and check if there is an Update Shopify Connection at the top. If there is such a button, click on it and wait for the connection between DEAR and Shopify to be updated. Once the connection is working, that button should disappear.

  2. When attempting to update stock levels in Shopify, it may fail. This may be due to the following:
    • Shopify allows execution of up to 60 API calls per minute. To update the stock level for a single product/variant in a single location, one call is needed. If you have several locations and/or hundreds of products in each location, stock level updates may take longer than usual, if not fail entirely, due to this limitation. DEAR is currently in discussions with Shopify on how to resolve this issue.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.