Problems with query change price in 2 tables

[DrByte]

Your posts used upper/lower case, but your tables use only lowercase in the field names.

So rewrite the query as:

update zen_products p, inventory i set p.products_price = i.price where p.products_model = i.itemnumber;

And you must run this query in phpMyAdmin. YOU CANNOT run it in your Zen Cart Admin sqlpatch tool.

[Petje007]

thank you again dr. Byte, i had already see the mistake and changed that, but still not working

i do run this in phpMyAdmin

i have tryed somany solution the last 2 days, i am really frustrated

i don't know why it is not working

[DrByte]

I tested it here before I posted my first solution for you, and it works fine for me.
I can in phpMyAdmin that my products_price field is correctly updated with the new prices for me.
And then in my store if I run Admin->tools->store manager->reset products price sorter, my storefront will also show the new prices correctly.

So something must be wrong with your data. Perhaps your itemnumber values don't properly match your products_model numbers. Mismatched itemnumber-vs-products_model would cause a 0 price to be entered.

[Petje007]

When i start de query in Phpmyadmin, there is a message
i translate this message for you.

"there is missing a value in this form'

[DrByte]

When did that message start? Why didn't you mention it earlier?

[DrByte]

I just reconstructed a new table named inventory, added an itemnumber field and price field, using the same structure as the products_model and products_price fields in my zen_products table. Then I filled the inventory table with some sample entries, using itemnumbers that match products_model values.
I used phpMyAdmin to run the same query I posted above, and it worked without any error.

[Petje007]

because the second time i started the query in the startscreen (localhost » jvw_testdb) , i don't know how to tell you.

the first try with the query i was in the table inventory ( localhost » jvw_testdb » inventory) and after that i push the SQL button,
and start the query, there was no message and no changes in the prices

the last try with the message i was here in ( localhost » jvw_testdb) and started the same query, with result that message.

[Petje007]

i have found the problem why it is not working,

the field products_model in zen_products align to the left
the field itemnumber in inventory is floating?

How i don't know?

But now, how can i change the field itemnumber in inventory, also the the left?

thank you!