The eCommerce Hub's Shopify integration requires that products only be mapped on a one-to-one basis with a Shopify SKU. This means, if there are any products or variants in Shopify with the same SKU (product code), the integration will fail to sync them successfully. This can result in Shopify orders failing to import to Unleashed or product updates (such as stock availability) failing to sync to Shopify.
We recommend that all SKUs in Shopify be unique across all active, draft, and variant products to help reduce the occurrence of duplicate SKU errors.
Follow these steps from within your Shopify account to identify any duplicate SKUs:
In Shopify, go to the Products page for your store.
In the top right of the page, select Export and then All Products and CSV to Excel.
Once you've received the exported file, open it and highlight the Variant SKU column.
In the Home tab of Excel, select the Conditional Formatting button
In the drop-down menu, select Highlight Cells Rules
In the second menu, select Duplicate Values
When you select OK, the file will apply the rule, and any cell within the Variant SKU column that has the same value as another cell in the same column will be highlighted (usually in red).
The highlighted cells identify which of your products or variants have a SKU that's been used more than once across your product list.
Once you've identified the duplicate SKUs, head back into Shopify and edit the products or variants so that all SKUs are unique.
If the duplicate SKUs you've identified triggered an error in your Shopify Connection Log and you've since updated your SKUs so they are unique, but still receive a duplicate error, you will need to remap the updated SKU to ensure the integration has been updated successfully.