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
You can use SQL command....
Where:
- oc_ is you oc prefix
- 59 is you category ID (men's watches category)
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;
- 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
Who is online
Users browsing this forum: No registered users and 33 guests