Map products to Shopify

Map products to Shopify

Overview

Find out how to map, unmap, and remap Shopify and Cin7 Omni products.

A mapping links a product in Shopify to a product in Cin7 Omni.

Mappings ensure your products’ costs and prices, sales and purchase orders, stock levels and other descriptive details stay in sync. They reduce the need for manual data entry, improve the customer experience, and ultimately underpin a centralized inventory.

For example, if you dispatch a product in Shopify, the product it’s mapped to gets dispatched in Omni. And if you receive units of product in Omni, the stock level of the product it’s mapped to increases in Shopify.

When you upload a new product to Shopify  or download a new product from Shopify, mappings are automatically created between the product’s Omni and Shopify versions. But you can create mappings for products that already exist in both Shopify and Omni, too, and delete mappings that are obsolete.

What products can I map?

You can create mappings from

  • a Shopify product to an Omni product

  • a Shopify product to an Omni product option

  • a Shopify product to an Omni size option

  • a Shopify product to an Omni unit of measure (UOM)

  • a Shopify variant to an Omni product

  • a Shopify variant to an Omni product option

  • a Shopify variant to an Omni size option

To create a mapping, the products must be mappable. That means the SKU or Barcode of the Shopify product or variant must match the Code or Barcode of the Omni product, product option, size option, or unit of measure.

The products must be completely unmapped, too. For Omni products, that means neither the product nor any of its options, size options, or units of measure have mappings. And for Shopify products, it means neither the product nor any of its variants have mappings. (To view current mappings, see below.) To create new mappings for a partially mapped product, you must remap the product instead (see below).

Keep in mind that Cin7 products always have at least one option. So when you create a mapping from an Omni product, you’re really creating a mapping to the product’s default option.

Warning! Don’t map Shopify variants to Omni units of measure (UOMs). Mappings between UOMs and variants will get deleted when executing certain functions, such as updating product details and prices.

Find out more about mapping units of measure (UOM) to Shopify.

Create mappings

To create mappings, you must have enabled Download Products in your Shopify integration settings. Then:

  1. Log in to Cin7 Omni.

  2. From the Integrations menu in the navigation, open your Shopify integration.

  3. On the Product Status tile, select Download Products.

  4. Open the Download Products tab.

  5. Select either

    • Import Products Created Since Last Import to only create mappings for unmapped Shopify products created since you last downloaded products, or

    • Import All Products to create mappings for all unmapped Shopify products.

  6. You’ll be given the total number of unmapped Shopify products. Some of these products may be unmappable and won’t have mappings created – you can download these products  instead, or create custom mappings (see below). Select Next to create the mappings.

  7. You'll be given a summary. The number of Existing Price Options Linked is the number of mappings that were created.

You’ve created your mappings. Now select Back to Dashboard, where you can view your mappings (see below).

Create custom mappings

A custom mapping links unmapped, unmappable products.

Like a regular mapping, a custom mapping links Shopify and Omni products. The difference is that neither the SKU nor the Barcode of the Shopify product needs to match the Code or Barcode of the Omni product.

To create a custom mapping, follow the steps above to create regular mappings. Then:

  1. Select Next. You’ll be taken to the Custom Mappings tab.

  2. Select Download Products to Apply Custom Mappings. A spreadsheet will download.

  3. Open the spreadsheet. Each row is an unmapped, unmappable Shopify product. You can create custom mappings for any of these products.

  4. For each product you want to create a custom mapping for, enter the Code of the Omni product, product option, size option, or unit of measure that you want to map it to into the column “Cin7 Code.”

  5. Save the spreadsheet.

  6. In Cin7 Omni, select Choose File and upload the edited spreadsheet.

  7. Select Next. You’ll be given a summary. The number of Product Options Mapped is the number of custom mappings that were created.

You've create your custom mappings. Now select Back to Dashboard, where you can view your mappings (see below).

View and delete mappings

  1. Log in to Cin7 Omni.

  2. From the Integrations menu in the navigation, open your Shopify integration.

  3. On the Product Status tile, select View Mapped Products.

  4. Either

    1. to delete a single mapping, select Delete next to it, or

    2. to delete all mappings, select Delete All – this cannot be undone.

Remapping

In order to create a new mapping, the Omni and Shopify products must both be entirely unmapped – for example, you can’t create a mapping between a new product option and its matching variant if existing options and variants of that product are already mapped.

So, if you create new Omni products, product options, size options, or units of measure to map to Shopify – or, conversely, if you create new Shopify products or variants to map to Omni – and either the Omni or Shopify product is already partially mapped, you must completely remap the product:

  • Delete the mappings (see View and delete mappings above) connected to the Omni product (including options, size options, and units of measure) and the Shopify product (including variations) for which you want to create an additional mapping.

  • Create new mappings (see Create mappings above).

Was this article helpful?

Have more questions? Submit a request