Bulk edit your Shopify store’s data

Mixtable’s Excel-like spreadsheet interface was designed from the ground up to be the best way out there to bulk edit the data in your Shopify store. You can edit almost everything, and you can customize your workbook to suit your needs.

In Mixtable you work within a workbook. Mixtable workbooks look, feel and behave almost exactly as Excel does. They just run in your browser. To begin bulk editing your Shopify data you first have to create a workbook and link that workbook with your Shopify store’s data. You have two paths to start when creating a workbook.

The first path is to create a blank workbook. This workbook looks and feels exactly as a new workbook you would create in Excel. It has one empty worksheet. After the workbook is created you are free to add worksheets for only the data that you need to sync.

The second path to start when creating a workbook is to select the option to create a workbook based on Mixtable’s Shopify template. This template gives you the worksheets that are most commonly used by our users and within those worksheets there are columns preset up with the most commonly synced data. Something to note is that not all data is automatically populated into these template worksheets, just the most commonly used one. You are free to add more data as needed.

Columns in Mixtable can either be standard ones, i.e., work just like in Excel, or they can be linked to a particular data field in Shopify. To convert a column from a standard column to one linked to Shopify data, right-click on the column’s header and select the Shopify Sync Settings menu option.

You will now be presented with a set of options for the data you want to sync. These options will change depending on what data (e.g., products) you have set to sync to the particular worksheet. The column sync settings options are:

• Core Field - This option allows you to further select and map this column to one of the “core” data fields that Shopify has for each data type. For example, allowing you to map the “Description” for Products, or the “Email Address” of a Customer.
• Metafield - This option allows you to map a column to sync with a particular metafield, by specifying the namespace, metafield name, and the type of the metafield.
• Product’s Manual Collections - Maps a column to show the handles of the Manual Collections that the product is a part of, and allowing you to add/remove a product from a Manual Collection.
• Inventory (Products - Complete (with Variants) worksheet only) - Allows you to sync inventory from Shopify and sync inventory to Shopify. If Inventory is mapped to a worksheet containing Products, then the inventory synced will be the inventory for the first variant of the product only.
• Additional Order Detail (Orders only) - If you have any Additional Order Details data as part of your orders, you can map each such field to sync to a column.
• Line Item Custom Property (Order Line Items only) - If you have any Order Line Item Customizations data as part of your line items (e.g., engravings), you can map each such field to sync to a column.
• Google Shopping Fields - This category of fields comprises the Google Shopping fields that are available to you in Shopify. You have a number of options to select to sync to a column.
• Product Category - Mixtable makes it easy to change your Shopify product categories in bulk. You have three options for what to map to a column to edit your product category. One is the ID of the category. Second is the short name of the category and third is the full name of the category. You can select whichever version you use.
• International Market Prices - You can map columns to set fixed prices and Compare-At pricing for any international markets that you sell to. This allows you to modify Shopify international prices in bulk.

When a column is added to a worksheet, whether that is during worksheet creation or by you afterward, the column immediately begins populating with data. This might take a bit of time, depending on how much data you have. For example, if you are trying to populate the product title for 100,000 products, that will take considerably longer than if you have 1,000 products. So please be patient while your data loads. You will see a visual indicator at the top of the screen in the formula bar saying that the worksheet is read-only as it is being populated with data. Once the data population is done, you can begin to bulk edit your content.

This part is fairly straightforward. Find the cell that contains existing data you want to update, modify its value, and then initiate a sync of your data to Shopify. You initiate the sync by pressing the Sync sheet to Shopify button in the upper right corner of your screen. Please note that data is synchronized to Shopify on a per-worksheet basis. So when you click the Sync sheet to Shopify button, Mixtable will begin to sync the changed cells in the currently opened worksheet. Any changes in other worksheets that are currently not active will not be touched. This allows you to modify multiple worksheets and trigger their sync to Shopify one at a time as you see fit.