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

[ovdjajoh]

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

[charmedbytina2]

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

Tina

[ovdjajoh]

thanx,

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

[ovdjajoh]

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?

[DrByte]

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

[ovdjajoh]

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