GS VISION Posted November 24, 2009 Share Posted November 24, 2009 I want to change the positions of the products in Home category but when I try I get error: Failed to update the position. Why can be this ? Link to comment Share on other sites More sharing options...
spetzie Posted December 2, 2009 Share Posted December 2, 2009 same error here also my products do not get added as new in featured products the oldest stay on top whatever i do.. Any help? Link to comment Share on other sites More sharing options...
ChrisU2R Posted December 2, 2009 Share Posted December 2, 2009 I'm having the same problem but am able to move products closer to the top by 'dragging' them up the list by hovering over the up/down arrows, getting a + type cursor and dragging up or down the list. My problem is that I can't get a product into the first position, only into second.I found the solution in this threadThe upshot is you need to go into phpMyAdmin, select the relevant database (If you're running several, your host may have only given you 1 database so this option might not be there). Once selected, click on to highlight ps_category_product and then the browse tab. You'll see 3 columns titled id_category, id_product and position.If you click on id_category, it will put the category list in descending order - look at the items in that category number and make sure the products run sequentially. If they don't, click the edit button and change them. This worked for me.Apologies for teaching how to suck eggs with regard phpMyAdmin but the above is not that obvious if you are new to using it as I am. Link to comment Share on other sites More sharing options...
Recommended Posts