Bulk Edit Shopify Pages

Mixtable is a robust spreadsheet tool engineered to simplify the management of your Shopify store. While it’s widely used for inventory management and order tracking, it’s also an invaluable resource for managing your Shopify pages. This guide will show you how to set up Mixtable for bulk editing your Shopify pages.

Setting up a pages worksheet in Mixtable

Step 1: Create a workbook

1. Open Mixtable and click on the “Add Workbook” button.
2. If you’ve already installed the Mixtable app from the Shopify App Store, Mixtable will initiate an initial download of your Shopify pages.

Step 2: Create a new pages worksheet

1. Once your workbook is set up, click the [+] button in the workbook toolbar to add a new worksheet.
2. When prompted, select the option to create a worksheet that syncs with your Shopify store’s pages.
3. The worksheet will have a set of default columns mapped to data such as page title, content, tags, etc. Feel free to add columns for any other page data you want to manage.
4. Mixtable will automatically populate these columns with existing data from your Shopify store.

Note: Shopify does not notify Mixtable when pages are created or updated. To sync new or updated pages from Shopify to Mixtable, click the “Sync page data from Shopify” button in your pages worksheet.

Optional step 3: Configure a Conditional Worksheet

If you wish to edit only specific pages or a range of pages, you can set up a Conditional Worksheet. This feature allows you to specify the criteria for the pages that should be included in the worksheet.

Editing existing Shopify pages

1. Navigate to the worksheet containing your Shopify pages.
2. Locate the cells corresponding to the pages you wish to edit.
3. Modify the existing cells to change the page title, content, tags, or any other metadata.
4. Once you’ve made your changes, initiate a sync from Mixtable to Shopify to update the pages.

Adding new Shopify pages

1. Navigate to the worksheet containing your Shopify pages.
2. Scroll down to find a blank row.
3. Fill in the blank row with the new page data, including title, content, tags, and any other metadata.
4. Once you’ve added the new page data, initiate a sync from Mixtable to Shopify to create the new pages.