Getting Started

User Guide

Add products to your Shopify store in bulk

Mixtable's Excel-like interface is the perfect way to quickly add products to your Shopify store. You can add products individually or in bulk, and you can manually enter the product information or paste it from Excel.

First, prepare your Shopify products worksheet

To get things going, add a new worksheet that is set up to sync with your Shopify store's products.

The worksheet comes preloaded with columns for the most commonly needed product fields. You are free to delete columns you don't need (right-click on the column headers to see the delete option), or to map blank columns to sync the data you need. To make a column show a particular field (e.g., the product's description) you need to map a column to the field. To do so right-click on the column header and select Edit Column Settings.

In the window that opens, you have a choice whether to map a Core Field, a Metafield, a Mixtable Analytics field, a list of the product's Manual Collections, or Inventory for the first variant of the product. Once you've selected the field you want to map to the column click on Save and you'll see any existing Shopify data start to populate in the column.

Second, add your products' data

Now that you've set up the columns you need, it's time to add your data. You can either manually enter the information, or paste it from another spreadsheet application (e.g., Excel). All the cells that you modify will get a light, purple background. This denotes that these cells' contents has changed, but hasn't been "committed" yet. When you commit the cells, Mixtable will sync their contents to Shopify.

Third, start the sync

Once you are done entering all your products' data, and are good for the data to be synced to Shopify, simply click the Done Editing button in the upper-right-hand corner. This will "commit" the changes, and trigger their sync to Shopify.

© 2020 Intelaria Corporation