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:
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.