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 spreadsheet

1. Open Mixtable and click on the “Create Spreadsheet” 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 spreadsheet templates, choose Blogs and Blog Posts:

The Blogs and Blog posts spreadsheet 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 spreadsheet by clicking the [+] button in the spreadsheet 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 download new or updated data from Shopify, click the Blog posts download button in the Shopify sync widget (or Blogs on a Blogs 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.

You're ready!

Mixtable is an online spreadsheet designed to sync data with Shopify. It looks, feels, and behaves like Excel (including formulas), but runs in your browser. With Mixtable you can:

• Bulk add products to collections, edit metafields, add or remove tags;
• Change product prices, including international prices, and review price history;
• Manage customers with a spreadsheet CRM for Shopify;
• Use Excel features like sort ascending or descending, find-replace, filter, and more.

Best of all, you can sync changes back to Shopify with a single click. Find out more about the Mixtable suite of products here.