Bulk-edit product specs in Shopify, then show them as a table on the product page
Shopify’s bulk editor can fill in product details for hundreds of products at once. This guide adds the details you want every product of one kind to show, then puts them in a table on a Dawn or Horizon product page, using Stencil Specs.
Draft: steps not yet rehearsed. This guide has not been walked through on a live store, and its screenshots are still to come.
What you need
- A Shopify store on the Online Store channel, using the Dawn or Horizon theme.
- Stencil Specs, which your Shopify admin lists as Stencil Specification Tables.
- A set of products of one kind. This guide uses road bikes.
1. Decide which details make a specification
A specification is the list of details that every product of one kind should show. For road bikes that could be frame material, weight and wheel size.
Write the list down before you touch any product, and settle the unit for each detail, such as kilograms for weight. Each detail needs somewhere to live in Shopify: a product field you already use, or a metafield.
2. Add the values with Shopify’s bulk editor
From your product list in the Shopify admin, select the road bikes and open the bulk editor. Add a column for each detail on your list.
Fill in the values, one row for each product, and save. This step is Shopify’s own tool from start to finish. Specs is not involved yet.
3. Set up the specification in Stencil Specs
Open Stencil Specs from your Shopify admin and create a specification for road bikes. Add a field for each detail and connect it to the product field or metafield you filled in during step 2.
Give each field the label shoppers should read, put related fields in a group, and set the unit. You do this once for the kind of product, not once for each bike.
4. Add the table to your product page
Open your theme in Shopify’s theme editor and go to the product page template. Add the Stencil Specs table where you want it to appear on the page, then save.
Specs’ support page has the placement steps for Dawn and Horizon.
Check it on your storefront
Open one of the road bikes on your storefront. The table should show that bike’s own frame material, weight and wheel size, with your labels and units.
Open a second bike and check that its values are its own. If both are right, the rest of the products you edited in step 2 will show theirs in the same way.
If the table doesn’t show
Check that your theme is Dawn or Horizon, that the table was added to the product page template and saved, and that the product has values for the fields in its specification.
Specs’ support page lists the themes it supports and its limits, and how to get help with Specs.
stencil / specs
Specification tables on your product pages.
Stuck on a step? Write to support@withstencil.com. We aim to respond within one business day, Monday to Friday, 09:00 to 17:00 US Central, excluding US federal holidays.