Overview:

When syncing a Shopify order to QuickBooks, you may encounter the error:

“The name supplied already exists.”

This error mainly occurs when SKU is selected as the product matching criteria in our app, and a product with the same name already exists in QuickBooks with a different SKU or no SKU.

Why does this error occur?

When SKU matching is enabled, our app uses the Shopify SKU to find the corresponding item in QuickBooks.

For example:

Shopify Product

  • Name: Sample Product

  • SKU: SHOP-001

QuickBooks Item

  • Name: Sample Product

  • SKU: QB-001

Since the Shopify SKU SHOP-001 does not exist in QuickBooks, the app cannot match the product to the existing item. It attempts to create a new item, but QuickBooks rejects it because an item with the same name already exists.

The same can happen if the existing QuickBooks item has no SKU.

How to resolve the error:

Option 1: Update the QuickBooks SKU

If the existing QuickBooks item is the same product, update its SKU to match the Shopify SKU.

For example:

Shopify SKU: SHOP-001
QuickBooks SKU: SHOP-001

If the QuickBooks item has no SKU, add the Shopify SKU to it. The app can then match the products using the SKU.

Option 2: Change the QuickBooks Product Name

If the existing QuickBooks item is a different product, change its name to avoid the duplicate name conflict. The app can then create a new item for the Shopify product.

Re-sync the Order

After making the required changes, go to the Orders>>Unsynced Orders section and re-sync the affected order. You can also contact our support team if you would like us to re-sync it for you.