If this is your first visit, check our documentation. To post, register or login.
Forums / General Questions / Can I increase prices on all parts for one Manufacturer?

Can I increase prices on all parts for one Manufacturer?

Locked

Started by ncmx1 on 11 Nov 2007, 9:38 PM · Views: 5,206

Results 1 to 20 of 33
This thread is locked. New replies are disabled.
11 Nov 2007, 9:38 PM
#1
ncmx1 avatar

ncmx1

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?

12 Nov 2007, 3:59 AM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Can I increase prices on all parts for one Manufacturer?

yeps ... :cool:

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!]
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!

12 Nov 2007, 6:01 AM
#3
ncmx1 avatar

ncmx1

New Zenner

Join Date:
Nov 2007
Posts:
25
Plugin Contributions:
0

Re: Can I increase prices on all parts for one Manufacturer?

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.

12 Nov 2007, 4:33 PM
#4
kitcorsa avatar

kitcorsa

Totally Zenned

Join Date:
Feb 2007
Posts:
1,724
Plugin Contributions:
0

Re: Can I increase prices on all parts for one Manufacturer?

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


12 Nov 2007, 4:40 PM
#5
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Can I increase prices on all parts for one Manufacturer?

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 ...

**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!]
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!

15 Nov 2007, 4:39 PM
#6
ncmx1 avatar

ncmx1

New Zenner

Join Date:
Nov 2007
Posts:
25
Plugin Contributions:
0

Re: Can I increase prices on all parts for one Manufacturer?

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?

15 Nov 2007, 4:41 PM
#7
ncmx1 avatar

ncmx1

New Zenner

Join Date:
Nov 2007
Posts:
25
Plugin Contributions:
0

Re: Can I increase prices on all parts for one Manufacturer?

My Manufacturer id = 6

FYI

15 Nov 2007, 4:49 PM
#8
kitcorsa avatar

kitcorsa

Totally Zenned

Join Date:
Feb 2007
Posts:
1,724
Plugin Contributions:
0

Re: Can I increase prices on all parts for one Manufacturer?

give me a link to your site and the manufacturor you want to increase the price


15 Nov 2007, 4:54 PM
#9
kitcorsa avatar

kitcorsa

Totally Zenned

Join Date:
Feb 2007
Posts:
1,724
Plugin Contributions:
0

Re: Can I increase prices on all parts for one Manufacturer?

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.


15 Nov 2007, 11:00 PM
#10
ncmx1 avatar

ncmx1

New Zenner

Join Date:
Nov 2007
Posts:
25
Plugin Contributions:
0

Re: Can I increase prices on all parts for one Manufacturer?

https://www.justgastanks.com

IMS is the MFG.

I will see if I can do it...

Thanks alot!

16 Nov 2007, 9:25 AM
#11
kitcorsa avatar

kitcorsa

Totally Zenned

Join Date:
Feb 2007
Posts:
1,724
Plugin Contributions:
0

Re: Can I increase prices on all parts for one Manufacturer?

yeah the above code i gave you should work in theory


21 Nov 2007, 4:08 AM
#12
ncmx1 avatar

ncmx1

New Zenner

Join Date:
Nov 2007
Posts:
25
Plugin Contributions:
0

Re: Can I increase prices on all parts for one Manufacturer?

So I use this whole Patch

"update products set products_price = products_price + 10.00 where manufacturers_id = 6"

Thanks!

21 Nov 2007, 3:11 PM
#13
kitcorsa avatar

kitcorsa

Totally Zenned

Join Date:
Feb 2007
Posts:
1,724
Plugin Contributions:
0

Re: Can I increase prices on all parts for one Manufacturer?

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!!!!!!


23 Nov 2007, 10:40 PM
#14
ncmx1 avatar

ncmx1

New Zenner

Join Date:
Nov 2007
Posts:
25
Plugin Contributions:
0

Re: Can I increase prices on all parts for one Manufacturer?

Can I put .02 for 2%?

Thanks alot!

24 Nov 2007, 1:33 AM
#15
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Can I increase prices on all parts for one Manufacturer?

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 ...

**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!]
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!

26 Nov 2007, 3:15 PM
#16
kitcorsa avatar

kitcorsa

Totally Zenned

Join Date:
Feb 2007
Posts:
1,724
Plugin Contributions:
0

Re: Can I increase prices on all parts for one Manufacturer?

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!!!!!!!!!


8 Feb 2008, 3:29 AM
#17
ncmx1 avatar

ncmx1

New Zenner

Join Date:
Nov 2007
Posts:
25
Plugin Contributions:
0

Re: Can I increase prices on all parts for one Manufacturer?

Now I need to decrease my manufacture by 2.5%. Can I do this the same way but put a - in there?

Thanks,

Ben

8 Feb 2008, 9:42 AM
#18
kitcorsa avatar

kitcorsa

Totally Zenned

Join Date:
Feb 2007
Posts:
1,724
Plugin Contributions:
0

Re: Can I increase prices on all parts for one Manufacturer?

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


8 Feb 2008, 11:48 AM
#19
thefashionhut avatar

thefashionhut

New Zenner

Join Date:
Oct 2007
Location:
UK
Posts:
71
Plugin Contributions:
0

Re: Can I increase prices on all parts for one Manufacturer?

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..

http://www.thefashionhut.co.uk**

8 Feb 2008, 4:20 PM
#20
kitcorsa avatar

kitcorsa

Totally Zenned

Join Date:
Feb 2007
Posts:
1,724
Plugin Contributions:
0

Re: Can I increase prices on all parts for one Manufacturer?

CAREFULL!!!!!!!!!!!!!!

97.50 + 2.5% does not = 100 !!!!!!!!!!!!!!!

97.56 + 2.5% = 99.99999999999999999999 which is 100 in money

carfull with nthe maths here!!!!!