How to stop syncing orders, if products are mismatched
What is the scenario?
Many businesses sell on multiple channels. For many reasons, the products are mismatched:
- The user hand entered a product on Shopify and the product sold, before the product was entered into QuickBooks.
- There is a typo and the product was entered incorrectly.
How does Connex match products?
We match the product SKU from your selling channel to the product SKU field in our database.
How do I fix mismatched products?
Make sure Connex creates no new products:
- Log into Connex.
- Go to settings.
- Select your connection.
- Click product.
- Select flag as error. This instructs Connex to put mismatched products into a queue, located under products > unmatched products:
Once the product enters the queue, click match:
Select the correct product in Connex.
Next, resync the sale:
- Click settings.
- Click order settings.
- Adjust the sync dates.
- Click save.
- The orders should sync shortly.
I have multiple products that match the same product in Connex. How do I match them?
On Amazon, you can have multiple listings for the same product. The SKU field must be different, so users enter the same SKU on multiple listings. It is possible Amazon and Shopify have different typos for the same product.
Here is some sample data:
Product | Master |
El, Paso Elsewhere | |
VHP Chocolate Meal | El, Paso Elsewhere |
El, Paso Elsewhere | WM-4000 Ultra |
Here are the steps:
- Go to the product matching.
- Click add mapping.
- Under target product, enter the master product ABC123.
- Under source product, enter ABC123-1