Can it be done?
Can I make a 15% price raise on all products in a specific category?
Please help,
Chaiavi.
Can it be done?
Can I make a 15% price raise on all products in a specific category?
Please help,
Chaiavi.
If all of those Products use that Category's categories_id as their master_categories_id ...
You can backup your database and then run:
where XX is the master_categories_id for these Products ...Code:UPDATE products SET products_price = products_price * 1.15 WHERE master_categories_id = XX;
Then, go to the Tools ... Store Manager ... and run the:
Update ALL Products Price Sorter
to be able to sort by displayed prices: Update
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
Nice hack
Thanks.
Thanks for the update that this was able to do the Product Price increase that you needed ...
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
Is there any addon / plugin that does the same thing without manual direct DB access?
You can run the same command from the Zen Cart Admin in the Tools ... Install SQL Patches ...
Otherwise, you would need to customize the code to build this in as something more user friendly ...
Linda McGrath
If you have to think ... you haven't been zenned ...
Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
i had to update my hole store buy 11% , i used obisan's codenote this will do ALL products in the storePHP Code:
UPDATE products SET products_price = products_price * 1.11
tyvm obi for showing me the way :)
Hi,
Where to make the modifs in the code?
Which line more precisely because I need to add a tax on a specific category for particular products??
Is it in the script 'categories.php'?
Am a newbie to Zen Cart..
Thanks
Liizz
Hi Liizz - No to add tax to all your items or items from a category you can do another SQL query on your database - I am not good at SQL, but it would look something like this:
UPDATE products SET products_tax_class_id = 1 WHERE master_categories_id = XX
Where xx is the category you want to update all products
Remember - always backup before doing any SQL queries :)
Good Luck,
Ryan
If you use a spreadsheet program like Excel or Open Office you can do it real simple, its called Paste Special - I just learned about it.
In an empty cell (anywhere on that active sheet is fine) enter the percentage you wish to increase prices by i.e 1.35 for 35% or 1.11 for 11% etc.
Now Click CTRL C (Copy) over the cell you just created
Highlight the cells/column you wish to change
Click on EDIT -> PASTE SPECIAL
In that screen select MULTIPY
CLick OK
Your Done!
I would suggest trying it out on fresh spreadsheet to get a handle on what you're doing.
If I can find the link to that forum page I will respond back and post it. Otherwise, you should be able to find it in a google search: Paste Special (open office or excel)
Bookmarks