Post by jayman » Fri Oct 29, 2010 1:38 am

I am running oc version 1.46
I am wanting to run a site wide special on black monday for all of my inventory for 30% off. Is there a way through sql to add this to my products? I have over 900 items in inventory and not really looking forward to manually editing each product to put on special for that one day.


New member


Wed Apr 07, 2010 1:32 pm

Post by justinv » Fri Oct 29, 2010 4:16 am

You could unleash this query on your database:

UPDATE product SET price=(price*0.7);

Or you could just set a site wide banner proclaiming 30% off and set up a Coupon "BLACKMONDAY".

Documentation: OpenCart User Guide
Mods: Total Import PRO | CSV Import PRO | Ecom Tracking | Any Feed | Autosuggest | OpenCart CDN

Active Member


Tue Oct 12, 2010 1:24 pm
Who is online

Users browsing this forum: No registered users and 31 guests