Sort by: Default, repeating some products from 1st page, not showing others…

ThemeBurn SupportForumsOpenCart ThemesShoppica OpenCart ThemeSort by: Default, repeating some products from 1st page, not showing others…

This topic has been marked as resolved.

I have an issue when I click on the category of a product (in this case, “Eyes”). The first page is fine, but when you click to see the next page of products, some products from the first page are repeated and other products don’t show at all. This only happens when it’s sorted by default, which is obviously problematic because customers won’t see all the products unless they sort it by brand/price/etc….or if they choose to show more than 12 products at a time.

Anyone have a solution for this? Thanks!

-Andrea

September 18, 2011 at 7:52 pm #1811

Hi,

I wasn’t able to confirm the problem you describe. I’ve tested on the default shoppica installation here. There are not repeating products in the two pages when the default sorting is used.

Please, give us more information about your shop, according to these rules.

September 21, 2011 at 11:35 am #1909

Hi. I have exactly the same problem. I am using shoppica Version 1.0.9 for opencart 1.5.1.1.

It’s very easy to reproduce this problem. Just go to my website http://www.chickenstitches.com.
In the top menu go to Stitch Markers category, then click on Medium sub-category (or any other that contain more than 12 products, like Sheep Shape for example). After you opened sub-category start clicking on the arrow on the bottom to next page. You will see many repeats. And many products are not showing up at all.
If you switch sort order from default to any other (like Name (A-Z) etc) then everything is working fine.

October 4, 2011 at 2:38 pm #2168

I have the same problem. I wasn’t sure if it OC issue or Shoppica issue. Sounds like Shoppica issue. Some products show up more than once when there are pages. When all products are shown on one page, it is ok. Please fix this asap or give an update? Thanks

Using OC 1.5.1.1 and Shoppica 1.0.9

  • This reply was modified 4587 days ago by  honeybadger.
October 4, 2011 at 7:48 pm #2176

Hi,

Have you tried to use the default OpenCart themes, as this a doesn’t have to be related with Shoppica.

You could give your website access so we could check as well.

Best regards,
ThemeBurn team

October 6, 2011 at 3:41 pm #2209

Yes, it’s seem to be a problem with opencart, because in default template it works the same (bad).
Any ideas how we can deal with this serious issue?

October 7, 2011 at 3:05 pm #2234

It is an Shoppica issue. The Shoppica theme upload must have overwrote something it shouldn’t have.

I did a new/clean install of OpenCart and added products needing pages and there were no duplicate products. After uploading and activating Shoppica, the problem appeared. Went back to default theme, and the problem is still there.

So I think we can deduct it was a core file that the Shoppica upload overwrote and changed. Please fix this please. I think this is a major bug. Eliyohu showed you the problem on his/her website given above too.

October 8, 2011 at 8:33 am #2237

err ok I can’t be sure. Tried disabling shoppica control panel and upload opencart files again over my install and problem stuck

October 8, 2011 at 9:32 am #2238

does this get stored in the database?

October 8, 2011 at 9:34 am #2239

Hi,

We have checked the issue a bit more and it is the default order, which is causing the duplication.

If you switch to A-Z in the sort drop down everything will work correctly.

The problem comes from the fact that you haven’t probably assigned a sort order to your products. Eventually this messes the default sort.

Best regards,
ThemeBurn team

October 11, 2011 at 10:59 am #2311

First of all, this issue was discussed here http://code.google.com/p/opencart/issues/detail?id=456 in August.

Second, since I am not sure it’s a good idea to clear cache from products as suggested in above link, I used (at least temporary) different solution.
In the /catalog/controller/product/category.php (line 15) I commented this line
// $sort = 'p.sort_order'; original code
and added in the next one
$sort = 'pd.name';

Now if you open one of my categories with a few pages of products, they dot sorted by name A-Z.
You can take a look here http://www.chickenstitches.com/stitch-markers/czech-glass

October 11, 2011 at 2:09 pm #2318

Clearing the cache can’t lead to issues, I am pretty sure. It can’t solve this problem, however.

You can either use the @Eliyohu’s suggestions and make the default sorting by name.

You can also make the default sorting by date added:

You will need to register in order to post topics and read replies in the ThemeBurn.com support forums!
October 13, 2011 at 11:08 am #2403

i had this problem when i used a negative sort order (ex: -1) after replacing all negative values the problem disappeared.

October 13, 2011 at 12:14 pm #2412

Thank you guys! I went with @Eliyohu’s alphabetical sort. That solved the issue. The support here is awesome :)

October 13, 2011 at 7:24 pm #2449

Thanks for the kind words!

We try keep the level high :)

October 14, 2011 at 3:06 pm #2500
Viewing 15 posts - 1 through 15 (of 17 total)
  • You must be logged in to reply to this topic.