Getting Started

User Guide

Add variants to your Shopify products in bulk

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:

  • 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