How to quickly auto-assign categories to a large number of products?

91 7 18

Hi guys,


I have a large number of products in my store that need categories assigning to them to make them compliant within my Google Merchant Centre.

Does anyone know the best and ideally fastest way to achieve this?


Thanks in advance.

Replies 2 (2)

Shopify Partner
7678 1493 1496

Hi @Loz86 

Dan from Ryviu: Product Reviews & QA.


You must add conditions when creating collections so products will automatically be assigned to a collection if they reach your conditions settingsScreenshot 2024-02-29 at 09.37.19.png


- Helpful? Like or Accept solution! or Buy me a coffee
- Ryviu - Product Reviews app, collect product reviews, import reviews from AliExpress, Amazon, Etsy, Shopee and Walmart and CSV.
- Lookfy app: Easy and fast to create Photo Gallery, Lookbook, Shop The Look
- Enjoy 1 month of Shopify for $1. Sign up now

Shopify Partner
3048 226 731

My recommendations is to ensure all your products have a product type values, because this value will be pushed to Google Merchant Center. Than using feed rules create a rule for each product type and assign a category:


However, plase note, it is not required to add Google Product Categories. But if you see that Google's auto tagging is wrong, then it is best to self assign it.

Get in touch with Emmanuel: a Google Shopping Specialist, Google Ads Diamond Product Expert, and also a a Google Product Expert Education 2021 & Tailwind 2023 Award winner.
Need Google Merchant Center or Google Shopping support?.