Titles of product options are stored in the title
column of the catalog_product_option_title
table:
It a simple case, you can adjust multiple titles at once using the MySQL REPLACE
statement, e.g.:
UPDATE catalog_product_option_title SET title = REPLACE(title, '...', '...');
In a complex case, you can dump the catalog_product_option_title
table using mysqldump, then adjust titles using a text manipulation tool like sed
, and then import the catalog_product_option_title
table back to the database.