Guides

How to set Shopify product categories in bulk

By Pratik Poddar, developer of Botfound · Updated 10 November 2026

To set the product category on many products, select them in Products, click Bulk edit, show the Product category column and set or drag the value down. For hundreds of products, import a CSV with the category breadcrumb or ID, or use a rule that sets one category on every product matching a product type, tag, vendor or title, with a preview before it saves.

Why it matters

The product category comes from Shopify's Standard Product Taxonomy, a fixed list shared by every store. It's separate from product type, which is your own free text. Sales channels, tax rules, category metafields and AI shopping agents all key off the category, so an uncategorised product is harder to find everywhere.

Option 1: the Shopify bulk editor (up to a few hundred products)

  1. In your Shopify admin, open Products and select the products. Filter first (for example by product type) so every selected product gets the same category.
  2. Click Bulk edit. If you don't see Product category, open Columns and add it.
  3. Set the category in the first row, then drag that cell down to fill the rows below.
  4. Click Save. If the save fails, a hidden column such as a required SKU or a metafield can be the cause (Shopify's bulk editing help).

Option 2: CSV import

Export your products, fill the Product Category column with the full breadcrumb (for example Home & Garden > Decor > Clocks > Alarm Clocks) or the category ID, and import with overwrite on. Test with a few rows first: a CSV import overwrites whatever columns you include.

Option 3: a rule that matches products

When your catalog already has consistent product types, tags or titles, a rule is faster and repeatable. In Botfound's Fix rules: IF product type equals "Sneakers" THEN set category to Shoes > Athletic Shoes, optionally only where the category is empty. Preview shows every product the rule will change and the before and after values. Apply runs in the background, and the whole run can be undone in one click.

Pick the most specific category

Choose the deepest category that's true ("Alarm Clocks", not "Decor"). The deeper category unlocks more specific category attributes, which is what the next guide fills in.

Questions

Is product type the same as product category?

No. Product category is a standard value from Shopify's taxonomy. Product type is your own label. Set both; agents and channels rely on the category.

Can I accept Shopify's suggested categories?

Shopify suggests a category on the product page. Review it before accepting: suggestions are a starting point and can be too general.

Can I undo a bulk category change?

The admin bulk editor and CSV import have no undo, so export a backup first. Botfound records the old value of every change so a run can be undone.

Want to see where your store stands first? The free Botfound check scores your 50 newest public products and your discovery files in about 10 seconds, with no install and no sign-up. Botfound is on the Shopify App Store: free for your first 100 products; Pro is US$19/month with a 7-day free trial.

More guides

Botfound by Tinkerer (Pratik Poddar) · 76, Vrindavan Vihar, Ajmer Road, Jaipur, Rajasthan 302019, India · pratik.phodu@gmail.com
Home · Free check · Guides · Support · Privacy policy · Terms · Shopify App Store