Global price change

Locked

Started by vintage on 31 Jan 2010, 8:26 PM · Views: 1,257

Results 1 to 4 of 4
This thread is locked. New replies are disabled.
31 Jan 2010, 8:26 PM
#1
vintage avatar

vintage

New Zenner

Join Date:
Jun 2009
Posts:
16
Plugin Contributions:
0

Global price change

I want to change all the items in my store to ONE price. I don't want to use the sale maker, because it is not a sale. This will be the retail price going forward.

Is there a way to do this without going to each product?

Thanks,
https://www.digiscrapsdezines.com

1 Feb 2010, 5:37 AM
#2
ajeh avatar

ajeh

Oba-san

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

Re: Global price change

If you really want to change every single product to be the same price, such as $2.22 ... then you could, AFTER backing up your database, run im the Tools ... Install SQL Patches ... the command:

UPDATE products SET products_price = 2.22;

Once you run that, every single Product will now be $2.22 ...

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!

1 Feb 2010, 5:13 PM
#3
vintage avatar

vintage

New Zenner

Join Date:
Jun 2009
Posts:
16
Plugin Contributions:
0

Re: Global price change

Thanks so much for the help!:clap:

1 Feb 2010, 5:37 PM
#4
ajeh avatar

ajeh

Oba-san

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

Re: Global price change

Thanks for the update that this worked for you ... :smile:

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!