Add a certain percentage to the price of all products with certain keyword in title

[AaronSmith]

Hello,
I am willfully hoping that there is a way to do this as I cannot go and edit more than 500 products one by one.

I have a certain product brand that is prevalant in almost every category of my shop. What I am trying to do is to add 20% to the price of every product in my Zen Cart store that has the name "Orian" in the title or the description.
When I go to "products" and type in "Orion" in the search box on the right all the products that I am trying to add 20% to the price do show up, but I do not know how to add 20% to the price of only these items.

Any help is greatly appreciated, thank you very much.

[gjh42]

You would have to modify the price field in the database for the desired products, with a "where" clause that specifies 'Orian' is in the product name field or the product description field. This is not something to do on a live database unless you are very comfortable with MySQL. Perhaps Ajeh can give the exact statement to use.

[AaronSmith]

Ajeh?
Whoever, whatever, it is, could it, or he, or she, please help.
Thanks.

[Ajeh]

If you needed to do this for Products that had the word 'test' in the products_name or products_description and increase the products_price by 10% you could use:

In phpMyAdmin ...

SELECT to see what Products will be affected by the UPDATE:

select p.products_id, p.products_price, pd.products_name, pd.products_description from products p, products_description pd
where 
p.products_id = pd.products_id 
and (products_name LIKE '%test%'
or products_description LIKE '%test%');

UPDATE to make the changes and raise the products.products_price to 110% of the existing price:

UPDATE products, products_description SET products_price = products_price * 1.10
WHERE products.products_id = products_description.products_id
AND (
products_description.products_name LIKE '%test%'
OR products_description.products_description LIKE '%test%'
);

The, you want to run from your Zen Cart Admin the Tools ... Store Manager ... Update Product Price Sorter ...

You can adapt that code to any word or price change that you want ...

NOTE: be sure to backup your database before attempting this ...

NOTE: this assumes you do not use any Products with Priced by Attribute or that you do not care about those Products ...