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.

Jason

New member

Posts

Joined
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
Image


Active Member

Posts

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

Users browsing this forum: No registered users and 18 guests