-->
Welcome, Guest
Username: Password: Remember me

TOPIC: Product selling price is unexpectedly changing

Product selling price is unexpectedly changing 2 months 1 week ago #34086

  • jonkon
  • jonkon's Avatar
  • OFFLINE
  • Newcomer
  • Posts: 9
  • Karma: 0
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?
The administrator has disabled public write access.

Product selling price is unexpectedly changing 2 months 1 week ago #34088

  • jonkon
  • jonkon's Avatar
  • OFFLINE
  • Newcomer
  • Posts: 9
  • Karma: 0
Any clues?
The administrator has disabled public write access.

Product selling price is unexpectedly changing 2 months 1 week ago #34098

  • jonkon
  • jonkon's Avatar
  • OFFLINE
  • Newcomer
  • Posts: 9
  • Karma: 0
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
The administrator has disabled public write access.

Product selling price is unexpectedly changing 1 week 2 days ago #35009

  • torvista
  • torvista's Avatar
  • OFFLINE
  • Senior
  • Posts: 46
  • Thank you received: 9
  • Karma: 1
I raised this issue
https://github.com/Dolibarr/dolibarr/issues/9703

Care to share the query you eventually used to update llx_product_prices?
Last Edit: 1 week 2 days ago by torvista.
The administrator has disabled public write access.
Time to create page: 0.071 seconds