How to Bulk Edit Product Template (Template Suffix)

Templates in Shopify are a group of sections arranged to give your store a consistent design and feel. The sections you can include in your templates depend on the theme you are using.

When you rearrange a template, your changes apply to every page that uses the template. If you decide to mass-change the templates for a set of products, it would be very convenient to set the templates per product from a spreadsheet app like the Mixtable Spreadsheet Editor instead of going to the product pages one by one via the Shopify admin.

Here’s what the manual change looks like:

Change Product Templates in Shopify Admin:

1. Go to the product page
2. In the sidebar, locate Template Suffix and choose the desired product template from the drop-down.

Change Product Templates in Bulk with Mixtable Spreadsheet Editor:

1. After installing the Mixtable Spreadsheet Editor, load a Mixtable Workbook with Products (no variants) (unless you don’t have one already)
2. Sync the Product Field > Product Template Suffix data in a new column.

3. Use the spreadsheet to change the product template for the products you need and sync it back to Shopify.

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.