Post by razmon » Sun Nov 04, 2018 3:55 am

Hi There
Can somebody please help me. It would be very much appreciated. I've had a look at extensions marketplace but can't seem to find the following:

I'm looking for an extension that will allow me to change all products within a single category to a special price of $50.00 and not use % or Value OFF. In other words if I have a category men's watches I want to change all products within that category to a fixed price of $50.

Any urgent assistance would be very much appreciated - this is a great forum

Kind regards

Ray

New member

Posts

Joined
Fri Feb 09, 2018 5:03 am

Post by razmon » Sun Nov 04, 2018 4:11 am

Sorry I run Version 3.0.2.0

Thanks - Ray

New member

Posts

Joined
Fri Feb 09, 2018 5:03 am

Post by xxvirusxx » Sun Nov 04, 2018 7:55 pm

You can use SQL command....

Code: Select all

UPDATE oc_product, oc_product_to_category
SET oc_product.price = 50
WHERE oc_product.product_id = oc_product_to_category.product_id
AND oc_product_to_category.category_id = 59;
Where:

- oc_ is you oc prefix
- 59 is you category ID (men's watches category)

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România
Who is online

Users browsing this forum: No registered users and 33 guests