Hello @woodfordrugby
Thank you for your time in doing the screen sharing and showing me the issue. As we found, the issue is happening because the product is assigned to multiple categories.
In such situations, the plugin assigns only the last found sort order to the product.
e.g.
Category A
— 1) Product 1
— 2) Product 2
Category B
— 1) Product 1
— 2) Product 3
— 3) Product 4
Here Product 1 is assigned to 2 both categories.
Now let’s say we change it’s order to this:
Category A
— 2) Product 2
— 1) Product 1
Category B
— 1) Product 1
— 2) Product 3
— 3) Product 4
The Product 1 inside Category A will still get reset to position (1) as the last sort order is Category B – Product 1 which is position (1). So it will again assign Position (1) To Category A – Product 1. This limitation has been mentioned inside the yellow notice as well.
I understand this is quiet annoying limitation but that is how woocommerce provides us the database structure.
Although I am thinking about hiring someone to figure out a working solution. I am not willing to disappoint any of my plugin users.