Change Product Model Numbers en masse?

[Kevin205]

Got it and Thank you.

[allthingsidLeroy]

UPDATE zen_products SET products_model = CONCAT("GHD-",products_model) WHERE manufacturers_id = 5;

As long as those column names match up to your, this seems correct.

Yes, you can execute this from PHPMyAdmin. There should be a place to execute custom queries.

Like I said, though, you should make a backup first.

[Kevin205]

Backup...

All the time.

[g2ktcf]

All of my cart tables have zen_ prefix in SQL. So it would be:

UPDATE zen_products SET products_model = CONCAT("GHD-",products_model) WHERE manufacturers_id = 5;

This should be executed from PHPMyAdmin. Correct?

if "zen_" is your db prefix, then this is the correct code to run from phpMyAdmin

[g2ktcf]

Understand that anything more complex than this simple task would not be done this way.

If I had to do anything more complex than this.... I would make a copy of my database and TEST the sql statement on that new copy. Then you evaluate the changes done by the SQL statement. If it works as expected, then I would do it on the real database.