Bulk Edit Shopify Blog Posts

Mixtable is a powerful spreadsheet tool designed to streamline the management of your Shopify store. While it’s commonly used for tasks like inventory management and order tracking, it can also be a valuable asset for managing your Shopify blog posts.

This guide will walk you through the steps to set up Mixtable for bulk editing your Shopify blog posts.

Setting up a blog posts worksheet in Mixtable

Step 1: Create a Blogs and Blog Posts 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 have initiated an initial download of your Shopify blog posts.
3. From the list of pre-built workbook templates, choose Blogs and Blog Posts:

The Blogs and Blog posts workbook has two worksheets:

• One is called Blogs, where you see the Title, Handle, Shopify ID, Tags, and Comment Policy of the blogs you have on your Shopify store.
• The other is called Blog Posts and has the following columns: Title, Handle, Content, Author, Tags, Shopify ID, Blog ID.

Step 2: Add a new blog posts worksheet (optional)

1. You can add a worksheet with blog posts to an existing workbook by clicking 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 blog posts.
3. The worksheet will have a set of default columns mapped to data such as blog post title, content, tags, etc. Feel free to add columns for any other blog post 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 blog posts are created or updated. To sync new or updated blog posts from Shopify to Mixtable, click the “Sync blog post data from Shopify” button in your blog posts worksheet.

Optional Step 3: Set up a Conditional Worksheet

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

Editing existing blog posts

1. Navigate to the worksheet containing your Shopify blog posts.
2. Locate the cells corresponding to the blog posts you wish to edit.
3. Modify the existing cells to change the blog post title, content, tags, or any other metadata.
4. If you wish to use the rich-text (WYSIWYG) editor to make changes to the blog post content, select the row of the blog post you want to edit and click to open the sidebar.

5. Once you’ve made your changes, initiate a sync from Mixtable to Shopify to update the blog posts.

Adding new blog posts

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

Manage Shopify data with spreadsheet functions

Operating in the Mixtable Spreadsheet Editor app allows you to use any spreadsheet function to analyze and manage your data, such as:

• sort ascending or descending,
• find-replacе,
• filter,
• use formulas, e.g., for price changes, etc.

Find out more about the Mixtable suite of products here.