database prices update but dont synchro with backoffice

[gaspas]

Hi,

 

We have a script that update prices, stock and a more few values, but that values on BO keeps the old values...

It seems that there's no  database synchronization. Should I change product data update or set some field to warn prestashop about this changes?

Thanks

 

UPDATE
I find the problem
http://www.prestashop.com/forums/topic/252957-solved-updated-minimal-quantity-field-through-database-changes-not-shown/

But my doubt now is, should I update only table ps_product_shop or both?

Edited February 14, 2014 by gaspas (see edit history)

[prestashopninja]

Please see Vekia's response to this topic:

http://www.prestashop.com/forums/topic/224957-difference-between-ps-product-and-ps-product-shop/

[gaspas]

Thanks, now I understand the reason for the 2 tables.
But I still have the doubt if I should update both tables or just ps_product_shop.

I believe I should update both, but I have huge quantity of products about 80.000 and run the script to update values in both tables will be the double of the work..

 

update...

For what I see I could only update http://www.prestashop.com/forums/topic/271652-difference-between-the-two-tables-shop/ ps_product_shop

http://www.prestashop.com/forums/topic/265318-query-sql-update/

Edited February 14, 2014 by gaspas (see edit history)

[prestashopninja]

Unfortunately you must update both as many existing methods and modules still check ps_product table.

[gaspas]

OK, I get it,

Thanks @prestashopninja

 

SOLVED