I have a script that sets a position to every product per category, by editing the catalog_category_product table.
It runs well and seems to be working, but every few hours Magento resets all values to 1 (default value).
There’s no other script that i can find that changes this, and its not consistent on timings either (sometimes is at 2am ,others 6pm, doesn’t matter)
Anyone have a clue what’s could be happening?
I’m on Magento 2.3.6-p1
Thanks