Products in Home category, position REALLY not saving

[HowHard]

Hi,

 

I have had this problem for a long time now, the store has 1,200 products within the Home category.

 

When I try to reposition them in the back office to change the first 20 as they are to show on the homepage, they move fine and then I save it, message 'save successful'.

 

If I then come out of the page and come back, it has not saved and they are back in original position.

Weird thing is, very occasionally it does save. 

 

Had this problem a long time now and cannot find any problem or fix.

 

Please please any assistance would be greatly appreciated.

[HowHard]

I have removed all but the first 25 products in the Home category (just removed them from Home category).

 

Cleared cache.

 

So now only 25 products in Home category, yet still I cannot move the products, they move, message saved successfully.

 

Click on catalog, products. Products are in the same order as before, nothing moved.

 

Arrrgh!

 

Using PS 1.6.1.10

Edited February 23, 2017 by HowHard (see edit history)

[musicmaster]

Please try sorting them with Prestools - my free tool. Prestashop's sorting occasionally gets stuck due to too many products having the same position number. Sorting them one time with Prestools will unstuck them.

 

And don't forget to clear the cache.