Forums / Setting Up Categories, Products, Attributes / Same price for ALL products

Same price for ALL products

Started by juukyuu on 21 Jan 2012, 11:08 PM · Views: 1,036

Results 1 to 4 of 4
21 Jan 2012, 11:08 PM
#1
juukyuu avatar

juukyuu

New Zenner

Join Date:
Jan 2012
Posts:
23
Plugin Contributions:
0

Same price for ALL products

Hello!

Probably you'll think it's so weird once reading the subject. I'm working on a small crafting business, and each product will have the same materials. The phrase will be the content, so it wouldn't be necessary that each phrase will be charged differently from other phrases since the materials will be same.

Anyways, the thing is: there are over 500 phrases (yes, I know.... crazy) and I'd like to set the same price for ALL products rather than manually setting for each of them.

Is this possible?

22 Jan 2012, 5:16 PM
#2
ajeh avatar

ajeh

Oba-san

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

Re: Same price for ALL products

If you want ALL of the Products to be set to the same Product Price and you set that in the Product Price setting, you should be able to run in the Tools ... Install SQL Patches:

UPDATE products SET products_price= xxx.xx;

where xxx.xx is the price you want to set ...

Then go to the Tools ... Store Manager ... and run the Update Products Price Sorter ...

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!

23 Jan 2012, 10:34 PM
#3
juukyuu avatar

juukyuu

New Zenner

Join Date:
Jan 2012
Posts:
23
Plugin Contributions:
0

Re: Same price for ALL products

Wow! Thank you so much, Ajeh!

23 Jan 2012, 11:18 PM
#4
ajeh avatar

ajeh

Oba-san

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

Re: Same price for ALL products

You are most welcome .. remember to make a backup to your database before making changes ... :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!