[Solved] Product position inside category does not work?

[5haun]

PS 1.6.0.9

 

When I filter my products by category and then change the position of a product, it moves correctly and then says "update successful"

 

BUT

When I refresh the BO and the FO, the product has not moved position. Goes back to the way it was before.

 

Tried clearing cache. Still the same problem.

 

Any help to solve this issue would be hugely appreciated.

 

Thanks

Edited March 4, 2015 by 5haun (see edit history)

[5haun]

Problem, somewhat, solved.

I tried moving all of the items in the category instead of just moving one.
I moved them all to a different position one by one to sort of, 'activate' their position.

So yeah, don't think it's supposed to do that though.

[PeteW]

Afraid that solution doesn't work for me (Prestashop 1.6.0.9) - and my client has too many products in most categories for this to be a practical workaround for him, anyway. As far as I can see, this is a bug in the AJAX code that's supposed to update the _category_product table. Basically, it doesn't. My current workaround is to edit that table manually, but that's not exactly a fix either, is it?

 

Can anyone confirm whether or not this is fixed in 1.6.1 ? I can't upgrade to that yet - theme and plugins aren't compatible - but it would be nice to get this working properly.

[norti]

Hi, are there any updates on this?

 

Working w/ PS 1.6.1.2 still got this issue.

Can't believe it's such an unspectacular bug that it is not solved, yet.

 

Unfortunately, Shaun's workaround is not working for me either.

 

thanks

 

 

[obewanz]

I am thinking this problem is in /classes/product.php, but dang if I can find what is wrong with the code.

 

[using Prestashop 1.6.0.9 - too many things blow up if I go to a later version]

[TimTamTom]

Hey there guys, I had the same problem but just found a solution:

 

- change positions in BO and delete cookies: BO problem fixed

- (unfortunately you have to) disable the module Block Layered: FO problem fixed

 

Best,

 

Tim

[samverdyck]

Hey there guys, I had the same problem but just found a solution:

 

- change positions in BO and delete cookies: BO problem fixed

- (unfortunately you have to) disable the module Block Layered: FO problem fixed

 

Best,

 

Tim

 

Do you mean just to clear the browser cookies? 

[obewanz]

I upgraded to 1.6.1.4 a little while back, and still have the sorting problem, except now when using firefox it works sometimes, but it still never works when using chrome.

[TimTamTom]

Do you mean just to clear the browser cookies? 

 

I do not recall now but I guess so yes.. Otherwise try to clear the cache in the backoffice (Advanced Parameters --> Performance) instead.

[ubiq]

Well, i just spent some time on that question this evening and i think i have something to add to this conversation.

For me, positioning problems occur only when i have holes in my position numbers. Let me explain.

I create 10 products in a category => In the order position, they get the numbers 1 to 10 => No problem, i can reorder them, everything works fine, as long as the position numerotation is continuous.

Some time later, i erase product 4 to 7.

Now, in my category, position numbers are : 1 - 2- 3 -8 - 9 - 10

If i now try to put 3 in, let's say 4th position (to replace actuel position number 8), then the problems will start, in my case.

The recalculation of position is done, but not their saving on all the products.

By luck, i have only small categories (less than 40 products), so when i erase some of my products; i go to the corresponding categories and "fill the holes" but pushing my high position number products to lower number position.

To be sure, that everything is saved, i often have to go back and forth with my product (if i want him to go to 4th position, i first drag it to 3rd, let it go, and then drag him to 4th.

Edited August 30, 2018 by ubiq
spelling (see edit history)

[obewanz]

I have one category with 1800 items, I have other categories with as few as 3 or 4 items, the issue happens on all reordering of products within any category. Even the simple addition of a new product and then an attempt to position it somewhere, anywhere else in the category reveals the ajax position bug.

The ONLY thing that works reliably for me is to complete the following sequence - then the new position will "stick":

1) click on the word "products" near the top of the list (above the category structure at "Catalog / Products") ... this appears to establish the cached positions.

2) move one item to the position I want it in.

3) click on a category, any category AFTER the update success for the position has appeared.

4) click back on the category I am working in.

5) select another item and repeat the process starting at step 2.

THE ABOVE sequence works for me EVERY TIME... I am almost certain it is an ajax code problem.

Still running Prestashop 1.6.1.4, deleting cookies is not really a viable option for me.

CAVEATS: You CANNOT move more than one item at a time, and you can only move an item within a single category page, so for my 1800 item category I have to manipulate the "display" feature to get the desired item in a "page" where I can move it past any given "page".

I am planning to install PS1.7 in preparation for testing out the upgrade process as I will soon need to enhance the site response speed and this appears to be the cheapest solution to get there from here. I have been told, however, that this bug STILL exists in Prestashop 1.7.x

Edited September 1, 2018 by obewanz
clarification (see edit history)