Please help us to make AbanteCart Ideal Open Source Ecommerce Solution for everyone.

Support AbanteCart eCommerce

Author Topic: Products Showing More than Once  (Read 5885 times)

Offline Gordon Taylor

  • Global Moderator
  • Full Member
  • *****
  • Posts: 150
  • Karma: +28/-1
    • View Profile
    • Natural Handcrafted Soaps
Products Showing More than Once
« on: June 06, 2015, 12:32:56 PM »
I have several instances of a product showing up in the same category twice.

In the admin panel, under products or categories, they are only listed once.

And the products, when clicked on, go to the same product page, so it's not like there are different copies of the products in question.

Any ideas guys?

+++++++++++++++++++++++++++++++ Update++++++++++++++++++++

I checked DB and nothing is duplicated there either.

I have noticed that if I change the sort option on the category view, it changes which products are duplicated. Very strange.
« Last Edit: June 06, 2015, 02:04:47 PM by Gordon Taylor »

Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4358
  • Karma: +298/-10
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: Products Showing More than Once
« Reply #1 on: June 06, 2015, 05:12:04 PM »
This sounds like an incorrect sql join. Where does this happen? Is this something custom you work on?
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

Offline Gordon Taylor

  • Global Moderator
  • Full Member
  • *****
  • Posts: 150
  • Karma: +28/-1
    • View Profile
    • Natural Handcrafted Soaps
Re: Products Showing More than Once
« Reply #2 on: June 06, 2015, 05:56:23 PM »
No, nothing custom at all. It seems to be dependent on the number of items the user chooses to display within the category. llegrand was able to duplicate, and it's not browser specific.

i.e. Choose to display 25 items and the duplicates change. In fact, there are even items that don't belong in that category. Go to 40 items to display and the duplicates change again.

I am running 1.2.1

Caches have been cleared also. The fact that llegrand can see it tells me it's the cart, not me.

Here's the link,

https://naturalhandcraftedsoaps.com/secure/nearly-natural-hand-crafted-soaps

Notice that Sweepea and red clover tea are repeated on the second page.

Switch the view to 45 items, the dupes are gone. Change it to 25 and you'll see a soap Vanilla Sugar Goats Milk at the bottom of the first page that is out of category, it doesn't show when the quantity to view is 40 or 45.



Offline webdevmerc

  • Full Member
  • ***
  • Posts: 172
  • Karma: +32/-1
    • View Profile
Re: Products Showing More than Once
« Reply #3 on: June 07, 2015, 09:58:33 AM »
I am playing around with your site and am wondering if this is due to a sort preference?

For example, when I click on your link, I see the Sweet Pea, but if you look at the sort preference of the linked page in your message, it is sorted by A-Z.

When you click on Page 2, it's sorted by Default making the Sweet Pea pop up again.

If you select sort by A-Z on Page 2, the Sweet Pea is not there anymore making me think that the Sweet Pea item was added earlier, but the sort preference is changing when you click from Page 1 to Page 2 making it look like the items are duplicated when they probably aren't.

If you keep using the same sort preference, the items don't seem to duplicate anymore.



EDIT:
Hmm, playing around with my site, I think the "bug" is that if you sort by a preference OTHER THAN default, clicking on page 2 puts your sort preferences BACK to default causing some display problems to pop up.

« Last Edit: June 07, 2015, 10:15:56 AM by webdevmerc »

Offline Gordon Taylor

  • Global Moderator
  • Full Member
  • *****
  • Posts: 150
  • Karma: +28/-1
    • View Profile
    • Natural Handcrafted Soaps
Re: Products Showing More than Once
« Reply #4 on: June 07, 2015, 11:04:38 AM »
At least I'm not alone! And yes, sort affects it too!

Offline webdevmerc

  • Full Member
  • ***
  • Posts: 172
  • Karma: +32/-1
    • View Profile
Re: Products Showing More than Once
« Reply #5 on: June 07, 2015, 11:30:13 AM »
Maybe this can just be reclassified and submitted as a sort bug since that seems to be the actual problem.

The arrow keys on product pages are utilizing the default sort preference, not the setting based on the "Sort Products as default by:" setting on the admin tool.

If you go to this link first and use the default sort option, page 2 won't have the problem anymore.
https://naturalhandcraftedsoaps.com/secure/nearly-natural-hand-crafted-soaps&sort=p.sort_order-ASC&limit=40

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: Products Showing More than Once
« Reply #6 on: June 08, 2015, 04:20:45 AM »

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2046
  • Karma: +318/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
« Last Edit: July 10, 2015, 04:37:05 AM by Basara »
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

 

Powered by SMFPacks Social Login Mod