Product selling price is unexpectedly changing

Using my Dolibarr
1

Hi all,

For some reason, every time I navigate to a product card and then go to the selling price tab, then the price is changing automatically. Why this is happening?

2

Any clues?

3

Anyway I found it.
The problem was that when mass importing products from the import tool, only the table llx_product is getting updated and NOT the table llx_product_prices.
So when I manually updated the table llx_product_prices (writing a query in any mysql management tool like HeidiSQL for Win or SequelPro for Mac), everything is ok now

4

I raised this issue

Care to share the query you eventually used to update llx_product_prices?

5

For this bug and to auto update the price log after a product import.

https://github.com/Dolibarr/dolibarr/issues/9703