You can use Mixtable's Excel-like interface to quickly add variants to products in your Shopify store. You can add variants to products individually or in bulk.
First, 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:
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.