How to Bulk Assign Product Templates in Shopify

Alternate product templates are one of the most useful things in a Shopify theme and one of the most tedious to deploy. You build a bundle layout, or a made-to-order page with a lead-time notice, and then discover the only way to apply it is one product at a time, in the Theme template dropdown, on every product page.

For twelve products, fine. For three hundred, that is a day of clicking and a guarantee that some get missed.

What a template assignment actually is

Behind the dropdown, each product stores a template suffix — a short string telling the theme which Liquid template to render. A product with the suffix bundle renders product.bundle.liquid. An empty suffix renders the default product.liquid.

Template assignment is just a text field. Text fields are exactly what spreadsheets are for.

Common reasons to do this in bulk

• Rolling out a new layout to a whole product line after designing it on one product
• Pre-order and made-to-order pages that need different messaging and a different add-to-cart block
• Bundles and kits that render a component list the default template does not have
• Size guides or compliance notices that only apply to one category
• Reverting after a theme change — clearing suffixes back to default when you retire a template
• Campaign pages that need a richer layout for a few weeks and then switch back

The spreadsheet workflow

SheetSync exports one row per product including the template field, next to handle, title, type and vendor. From there:

Assign by category. Filter to a product type, type the suffix once, fill down the visible rows. Three hundred products get the right template in one action.

Assign by rule. =IF(C2="Bundle", "bundle", IF(D2="Studio Co", "artisan", "")) expresses your whole template policy as one formula you can re-run whenever the catalog grows.

Audit what is live. Sort by the template column and you can see in one screen which products use which layout. A product still sitting on a template you retired six months ago is obvious here and nearly invisible in admin.

Clear in bulk. Blank the column for a filtered set and every one of those products falls back to the default template.

Step by step

1. In SheetSync, open Product Info Sync and include the Template field in your export.
2. Export your catalog to the sheet.
3. Confirm the template names exist in your theme. The suffix must match the filename: product.bundle.liquid means the suffix is bundle.
4. Fill the template column using filters or a formula.
5. Sync back to Shopify.
6. Open two or three affected products on the storefront and confirm they render the layout you expected.

Getting the suffix right

This is the one place a bulk template edit goes wrong, so be precise:

• The value is the suffix only. Write bundle, not product.bundle and not product.bundle.liquid.
• It is case-sensitive and must match the filename exactly.
• An empty cell means the default template. That is a valid, intentional value, not a missing one.
• A suffix that does not exist in your theme is a broken product page. Check spelling against the theme's template list before syncing, not after.
• Templates are per-theme. A suffix that resolves in your live theme may not exist in a backup theme. Suffixes stay on the products through a theme rollback, so keep the template files in both themes or plan to clear the column.

Pairing with other fields

Template assignment rarely stands alone. The same export can carry tags, collections and metafields, so one sync can do the whole launch: set the template, add the tag that drives storefront filtering, assign the right collection, and populate the metafield the new template reads. One pass, one audit trail, no half-finished state where the page expects data that is not there yet.