Add variants to your Shopify products in bulk

Mixtable's Excel-like interface is the perfect way to quickly add variants to the products in your Shopify store. You can add variants to products individually or in bulk. You can also do it from a worksheet displaying your products, or from a worksheet displaying your variants.

Adding variants from a worksheet displaying your Products

First, ensure that you have a worksheet that is linked to the Products data in your Shopify store. Then, follow these steps:

  1. Find a column that is currently empty, and right-click on the header of the column (the header contains the column's letter)
  2. Click on the Shopify Sync Settings option
  3. In the "Shopify Sync Settings" interface that opens, select the "Core Field" radio button
  4. You will now see a dropdown containing the various product fields that you can sync. Select the Variants field
  5. Click on the "Save" button
  6. The "Shopify Sync Settings" interface will close, and you will see the column populate with the variant data you currently have for your products.

Now that you have the Variants column mapped you need to know how to use it. Since we are dealing with spreadsheet cells that behave like Excel's, and because we want to make the data exportable, Mixtable stores a product's variants in the cell in a particular way.

What you see in the cell are the Option Values of the variants. These are the values for Option 1, Option 2, and Option 3. Mixtable concatenates them and stores them in the cell in the following manner:

  • Different variants are separated by a comma ( , )
    E.g., if you have a product with a single option (say, Color), the following cell value represents three different variants for that product - red, blue, orange
  • Different option values for the same variant (i.e., option 1, option 2, and option 3 values) are separated with a slash ( / ), similar to how Shopify displays them.
    E.g., if you have a product with three options (say, Color, Size, and Material), the following cell value represents a single variant for the product - red / large / silver
  • You can combine commas and slashes to define multiple variants, each with multiple option values.
    E.g., the following value represents two variants, each having three options - red / large / silver, green / medium / gold

Using a combination of commas and slashes you can change the value in the cell to add/remove variants from your product.

You can also add a new option to the product, and immediately update the product's variants for the option. In the example below we are adding a third option name (Material), and adding the necessary option value to the three variants that already exist for the product (we could have also added variants).

Adding variants from a worksheet displaying your Variants

Ensure that you have a worksheet that is linked to the Product Variants data in your Shopify store. There are two key pieces of data that are the minimum required for the creation of a new variant:

  • The handle of the product you want to add the variant to. This handle is the part of the product URL that uniquely identifies a product within your store. You can easily find the relevant product handle from a worksheet that is linked with your product data, or from your Shopify Admin. You can also use the Product Picker widget to select a product as described below.

  • Any option values that are needed for the variants of the particular product. For every option label that is specified for your product each variant must have a specified value. Otherwise, Shopify will refuse the new variant data when Mixtable attempts to sync it.
    For example, if your product has two options defined - color and size - then each variant that belongs to this product needs to have a value specified for color, and a value specified for size.

With the above information in hand you are ready to create your variant. In your product variants worksheet find the next empty row. Fill in the handle of the product into the cell of the Product Handle column. You can manually enter the handle, copy/paste it, or use the Product Picker interface (see below). Then, fill in the option values that are required for this product. Please note that if the product handle column, or the option value columns are missing from the worksheet you will have to add them manually. They are present by default in newly-created worksheets linked with variant data.

Aside from the product handle and option values data, you can enter any other data that is relevant to your variants, such as price. When finished, click the Done Editing button and Mixtable will send the new variant data to Shopify.

Adding a product handle using the Product Picker

When a column in your Variants-linked worksheet is mapped to the Handle of the product related to the variant you'll see a button added to each cell in this column with a + symbol in it. Clicking this button activates the Product Picker widget.

The Product Picker allows you to look up a product to link to your new variant without having to know its handle. The Product Picker presents you with a list of the products you currently have in your Shopify store. If you select a product and click the Update cell with selected product button, the handle of the product will be added to the relevant cell.

© 2020 Intelaria Corporation