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.
First, ensure that you have a worksheet that is linked to the Products data in your Shopify store. Then, follow these steps:
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:
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).
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.
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.