Hi, after importing, we have a large number of categories that need new colors - it’s a bit of a Christmas tree right now and people are complaining :wink: How can I easily ‘batch update’ categories? The ideal solution would be to set a category and all its children to a specified value, but as a temporary work around setting all (sub-) categories to the same color will do too.

The below will make child categories have the same color as their parents. This needs to be pasted into the rails console in two parts. The first will put you in a viewer to see all the categories that it found, press q to quit, then paste the next part. I tested it on my copy of @bartv’s import and it performed as expected. cats=Category.where('parent_category_id > 0') cats.each do |cat| parent = Category.find(cat.parent_category_id) cat.color = parent.color cat.save! end

You see, people used to complain that they were all brown. I would do it from the rails console. I think that I could come up with code to make all sub categories the same color as the parent without to much trouble.

People always have something to complain, of course :wink: If you have some code laying around I’d love to see it! I don’t want to give you extra work though.

How to mass update category colors?

Product Support

bartv (Bart ) May 8, 2018, 6:12am 5

Thanks so much Jay!

Topic		Replies	Views
Bulk editing Categories Product Support	2	1053	February 20, 2018
Random colors for imported categories Feature	10	1343	May 23, 2018
Move categories with command line Self-hosting rails-console	2	838	January 11, 2020
Categories bulk edition Feature	5	886	August 6, 2025
Categories boxes border-color broken after update Product Support	16	846	June 12, 2023

How to mass update category colors?

Related topics