How can I change prices from within the database (not controlpannel) v1.2.7

10 Sep 2008, 10:53 AM

#1

New Zenner

Join Date:: Sep 2008
Location:: Amsterdam
Posts:: 10
Plugin Contributions:: 0

How can I change prices from within the database (not controlpannel) v1.2.7

Dear Zencarters,

Does anyone know how to change the prices from within the database MYSQL itself?
I cant find it through "zen_group_pricing" , or "zen_orders_products"..

There is something wrong in the controlpannel and i cant enter it. This is of other concern but in the meantime i need to change the prices.

thanx a lot

ovdjajoh

10 Sep 2008, 1:48 PM

#2

charmedbytina2

Totally Zenned

Join Date:: Mar 2007
Location:: AZ
Posts:: 1,890
Plugin Contributions:: 0

Re: How can I change prices from within the database (not controlpannel) v1.2.7

My sugesstion is to get Easy Populate from the downloads section and use that to change your prices.

Tina

Zen4Dummies

10 Sep 2008, 3:12 PM

#3

ovdjajoh

New Zenner

Join Date:: Sep 2008
Location:: Amsterdam
Posts:: 10
Plugin Contributions:: 0

Re: How can I change prices from within the database (not controlpannel) v1.2.7

thanx,

im running a 1.2.7 version zencart, can i still use Easy Populate..?

12 Sep 2008, 7:28 AM

#4

ovdjajoh

New Zenner

Join Date:: Sep 2008
Location:: Amsterdam
Posts:: 10
Plugin Contributions:: 0

Re: How can I change prices from within the database (not controlpannel) v1.2.7

There's only around 12 products in the shop and i would prefer changing it via the database itself.

The prices are set to 0.00 and then there's an added value which makes the actual price.
Would anyone know where to find this? :flex:

12 Sep 2008, 8:15 AM

#5

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,513
Plugin Contributions:: 176

Re: How can I change prices from within the database (not controlpannel) v1.2.7

The "products" table and "products_attributes" tables store pricing related to the product and its attributes, respectively.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

20 Sep 2008, 7:53 AM

#6

ovdjajoh

New Zenner

Join Date:: Sep 2008
Location:: Amsterdam
Posts:: 10
Plugin Contributions:: 0

Re: How can I change prices from within the database (not controlpannel) v1.2.7

I didnt succeed in changing prices through the database, but i succeeded in reconnecting the controlpanel to the right database, so everything works now.

thanx anyway