Hello,
I'm using v1.5.5e and have over 5000 products. I'd like to change the products_model using MySQL to standardize them. Can I run multiple update statements, for example:
UPDATE `products` SET `products_model` = 'BOR4000' WHERE `products`.`products_id` = 5205;

My concern is that there are fields/tables that relate to products_model that need updated as well. I understand the best way to accomplish this would be through the GUI however that is not an option for over 5000 products.

Installed plugins:
Sales Tax Summary
Easy Populate 4
Ceon URI Mapping (SEO)

Thanks!