New Zenner
- Join Date:
- Nov 2007
- Posts:
- 25
- Plugin Contributions:
- 0
Can I increase prices on all parts for one Manufacturer?
I want increase my prices $10 for only one manufacturer but all of their products.
Is this possible?
Started by ncmx1 on 11 Nov 2007, 9:38 PM · Views: 5,206
New Zenner
I want increase my prices $10 for only one manufacturer but all of their products.
Is this possible?
Oba-san
yeps ... :cool:
Linda McGrath
If you have to think ... you haven't been zenned ...
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
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!
New Zenner
And How might I do this?
Sorry..I have searched for this but I do not want to mess my site up since I am a newbie.
Totally Zenned
http://www.zen-cart.com/forum/showthread.php?t=75958
if you look here it explains how to increase prices of products from a single supplier / manufacturer etc etc etc
Oba-san
You need to decide what the manufacturers_id in the products table is for the manufacturer ...
Then, you can run the UPDATE on the products table for the products_price field where the manufacturers_id = XX ...
You will then want to run in the Tools ... Store Manager ... the Update Products Price Sorter so that you displays by Price sort properly ...
NOTE: Backup your database before you make any changes like this ...
NOTE: if attribute prices are involved, this gets more complicated, but it can be done ...
Linda McGrath
If you have to think ... you haven't been zenned ...
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
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!
New Zenner
well I am stuck on this:
Then, you can run the UPDATE on the products table for the products_price field where the manufacturers_id = XX ...
I can find the products price sorter but not this part?
New Zenner
My Manufacturer id = 6
FYI
Totally Zenned
give me a link to your site and the manufacturor you want to increase the price
Totally Zenned
update products set products_price = products_price + 10.00 where manufacturers_id = 6;
just copy and paste that into the sql patch in admin.
this should work but please **backup your database **before running this as its not tested.
New Zenner
Totally Zenned
yeah the above code i gave you should work in theory
New Zenner
So I use this whole Patch
"update products set products_price = products_price + 10.00 where manufacturers_id = 6"
Thanks!
Totally Zenned
dont forget the ; on the end.
open admin the tools then in thw sql patch in the box copy and paste
update products set products_price = products_price + 10.00 where manufacturers_id = 6;
and run and it sould come back with a sql patch was successfull message at the top.
PLEASE BACK UP YOUR DATABASE FIRST!!!!!!
New Zenner
Can I put .02 for 2%?
Thanks alot!
Oba-san
You need to do the math ...
10.00 + .02 is 10.02 ...
10.00 + .02% is 10.02 ...
10.00 + (10.00 * .02) is 10.00 + .20 = 10.20
So, products_price = products_price + (products_price * .02) would be the more correct update ...
NOTE: Always backup your database before attempting updates like this or you will be doomed ... :eek:
Linda McGrath
If you have to think ... you haven't been zenned ...
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
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!
Totally Zenned
if you want to increase price by a percent then look at my inflation post. on page 1 of this post for more information but to increase by a percent
is basically the following
update products set products_price = products_price * 1.insert number percent here where manufacturers_id = insert number of products id ;
so if you want to increase all products from company 6 as in this example thread by 5%
update products set products_price = products_price * 1.05 where manufacturers_id = 6;
REMEMBER TO BACK UP FIRST!!!!!!!!!
New Zenner
Now I need to decrease my manufacture by 2.5%. Can I do this the same way but put a - in there?
Thanks,
Ben
Totally Zenned
the code is the same for anything you want too update you just need to change the manufactures ir number and the mathmatics to add or subtract what you want to do.
update products set products_price = products_price / 1.025 where manufacturers_id = insert number of products id ;
think that should work. the maths is right just not sure is mysql understands / as devide. back up and try it. make a product at $100 in the same cat or manufacture as a test, run the patch, if its now 97.56 then it worked
PLEASE BACK UP FIRST
New Zenner
kitcorsa:
the code is the same for anything you want too update you just need to change the manufactures ir number and the mathmatics to add or subtract what you want to do.
update products set products_price = products_price / 1.025 where manufacturers_id = insert number of products id ;
think that should work. the maths is right just not sure is mysql understands / as devide. back up and try it. make a product at $100 in the same cat or manufacture as a test, run the patch, if its now 97.56 then it worked
PLEASE BACK UP FIRST
That code is incorrect.
You will need this code:
update products set products_price = products_price*0.975 where manufacturers_id = 6;
Outcome for $100 will be $97.50 which is $100 less 2.5%
**There is no such thing as too much clothing..
Totally Zenned
CAREFULL!!!!!!!!!!!!!!
97.50 + 2.5% does not = 100 !!!!!!!!!!!!!!!
97.56 + 2.5% = 99.99999999999999999999 which is 100 in money
carfull with nthe maths here!!!!!
Tell staff why this post should be reviewed.