• Contents

Matching Products between Etsy and Cin7

Last updated 05/07/2017

Overview


If you have products in both Etsy and Cin7, and no products need be imported to either system, you'll simply need to match products to each other. The matching process allows Cin7 to update information like stock levels from Cin7 to Etsy.

Matching is not necessary for downloading orders.

Matching Products


The matching process is really easy. Products will be loaded from Etsy and matches will be made to products in Cin7 using based on the code/SKU.

  1. Click on Import All Products.
    This loads products to compare with existing products in Cin7. N.B. it does not import products into Cin7. A sample of this data is shown below.
  2. Click Next.
    A summary of matches will be shown in the next page.
  3. Make note of any SKUs that do not match - this will be due to the SKU not being found in Cin7.
    If this is the case, you will either be given the option to remove unmatched products or download them as per the Download Process.
  4. To confirm the matches, click Finish.

Once products are matched, you will also need to add the Etsy channel to a product - see instructions below.

Adding a Channel Options to Products


Each product has a Channel option - this flags products to be updated to Etsy.

Products that have been downloaded from Etsy to Cin7 will automatically have their Channel option checked.

For stock and pricing to be updated to Etsy you will need to select the channel Etsy in the products page.

First, make sure the Channel field exists in the products module:

  1. Whilst logged in as an Administrator click on your username, top right, then click Settings.
  2. From the Products menu, bottom left, select Product Settings.
  3. Under the Show Channel Options menu, select Etsy.
  4. Click Save.

Next update a product or products:

  1. From the products module, select a product by clicking on its name.
  2. From the classifications menu, on the right-hand side, check Etsy.
  3. Click Save and Close.

By checking the channel field in the product, this allows you to update the stock levels and pricing for this product.

Bulk Updating Channels

Products can also be updated in bulk using the Import and Update products process. Multiple channels can be added when updating by separating each channel by commas in the Channels field. Be sure to make sure the name of the channel matches exactly.

Reviewing or Deleting Matches


If you are unsure how you have matched products or you have matched a product to another product incorrectly you can view product matchings and delete matching as appropriate.

  1. Whilst logged in as an Administrator from the left navigation, select Integrations, then Etsy.
  2. From the Product Status tile, click View Mapped Products.
  3. In this list you will be able to see a list of all Cin7 products that have been matched, and a list of their Etsy IDs.
  4. There are two actions you can take in this list:
    • Delete - deletes matchings that are incorrect
    • Download Products Mappings - downloads in csv format the data on display.

Deleting matchings does not affect products in either system, and you can rematch by following the process above if necessary.