[SOLVED] Same Product Listings on the storefront

Hi, I am using OpenCart 1.5.1.1 and I dont know if this is a bug within Opencart itself so I will post here for now.

If you look at this I have added 26 products under "Books" and from within OC Administration I see all 26 different books, from storefront some of the item from the 1st page is repeating on the 2nd page at same time some are missing which should be showing up as it says its enabled. Default show is set to 15 per page.

http://tibetgiftchicago.com/index.php?r ... ry&path=35

Now if you set the view to show "100" on each page then it displays all 26 different books and none are repeating.

http://tibetgiftchicago.com/index.php?r ... &limit=100

What could be causing this? I check to make sure Product code aren't same, which they aren't.

Thank you in advance for all help.

Tenzin

Well I thought it might be one of the extensions I have added so, I created a new store without any extensions and its doing the same thing.

Anyone else having the same issue?

The problem seems to lie with the default sort ordering (p.sort)

If you haven't given each product a sort order (most people don't) then this is what is causing the random behaviour. When page 2 is clicked, the query is run again but with a LIMIT 15,15 and so on.

As soon as you change to sort by A-Z etc it should work fine.

It is not a bug as such, but I believe the default sort order would be better as p.product_id DESC

thanks uksitebuilder! got that fixed.

sorry looks like its not fixed. I thought it worked but turned out its still the same.
can someone show me what i need to edit?

attached is my category.php from /catalog/controller/product/

EDIT: For now I have decided just to give each product sort order and it fixes it as you have stated, I will just go with this solution for now.

I have the same problem. I confirm that giving sort order works. I guess that will have to do for now