Troubleshooting for Shopify Connections

Here are some issues that have been found using Shopify Connections.

Identifying Duplicate SKUs in Shopify

Products in the Marketplace can only be mapped on a one-to-one basis. This means, if there are any products (or variants) with the exact same SKU (Product code), the integration will fail to sync them successfully. This can result in Shopify failing to import or update products (including stock availability) correctly with the Marketplace. We recommend that all SKUs in Shopify be unique across all active, draft, and variant products to help reduce this occurrence.

A method that can be used is by exporting the products and identifying them in Microsoft Excel (or similar). Here is an example:

In Shopify, navigate to the Products page.
From the top right of the page, select Export > All Products > CSV to Excel. A file will then download.
Open the exported file in Excel, and select the Variant SKU column.
Navigate to Conditional Formatting (location depends on the version of Excel) and select Highlight Cell Rules.
In the second menu, select Duplicate Values.
After selecting OK, a rule apply a highlight to any cell in the excel column that has the exact same value as another cell (duplicate).
Compare the SKUs column, and if you have found any duplicates, edit those Products in Shopify so that they are unique.

Multiple Warehouse Issue

If an order is sent to Shopify (from the Marketplace) that has an item assigned to multiple locations, and one of those locations does not have enough quantity for the ordered amount, there is a possibility that Shopify rejects this based on the Shopify Fulfilment and Inventory Policy.

A recommendations for what is to be done on the Vendor's Shopify is:

Adjust fulfillment priority Put the location that actually carries stock higher in the priority list.
Remove empty locations Unassign the product from locations that don’t normally stock it.
Allow overselling (less common) Set inventory_policy = continue for the variant so orders can be created even if a location has 0.

Order item cannot be a variant with components

That error means you tried to create an order with a composite (bundled) variant instead of a standard variant. Shopify does not allow adding composite/“component” variants directly as line items via the Admin REST API.

https://help.shopify.com/en/manual/products/bundles

Shopify does not allow for bundle creation via standard integration at this stage.

In this case, our support team reach out to the Marketplace Owner and advise if this error has occurred to an order, and the order will need to be created by the Vendor in their own Shopify.

If there are more than one line items, we also have the ability to manually sync the order without the bundle item, however this will advised on a case by case basis.