Product duplicated

Just some weirdness.

One product, out of over a thousand products, has a duplicate in the shop, but not in the admin.

Everything, including the ID is the same.

Why would a category page pull up just one of its products twice and not the search box pull it up twice?

Not seeing this on any other category page.

I'll fix it by just deleting and re-entering it, but wonder if anyone else has seen this?

Remember the logic needed to use computers and run code...

• there is only one product being displayed by the code twice
• the product exists as two 'duplicate' products
• the code is returning search criteria within one or multiple pages that follow written conditions within the code that are conflicting
• there is no spoon.

If we could see the page, the code or understand in detail the steps or behaviours to recreate then we can find an answer. Perhaps a corrupt db field, maybe an SQL query is returning what it sees - double.

Or maybe someone made a second product with the same name and somewhere in the cart there's an SQL query using the 'name' field and not the unique 'ID' field - This has happened to myself and my clients in the past.

Thank you,

Here is the Category listing showing the first product there as a duplicate

iPod + Tabliet + MP3

Here is the resulting page from typing in that product into the search box or just type in the product ID 1500 or any combination. No duplicates:

eSeries

If you were to go to phpMyAdmin and search the table for:
products_id 1500

How many records are found?

What are the categories_id for those with products_id 1500?

Just one. Thank you, Linda

If you then search the table:
products_description

for the products_id 1500 how many records to you see?

Just one there as well. Thanks

I just checked, also, the search for "1500" and there don't seem to be any duplications of product ID in any of my tables.

Well ... for giggles and grins you could try, in phpMyAdmin, doing a repair on each of the tables ...

I do not have any idea the size of your database or tables so you may want to do just a few tables at a time ...

OK. We'll keep an eye out to see if this should pop up again and I'll post here if so. Thanks for your time.

I'd love to see the code that's responsible for this on your site:

  <tr  class="productListing-odd">    <td class="productListing-data" align="center"><a href="[URL="http://www.zen-cart.com/view-source:http://topkayaker.com/index.php?main_page=product_info&cPath=5_44&products_id=1500"]http://topkayaker.com/index.php?main_page=product_info&cPath=5_44&products_id=1500[/URL]"><img src="[URL="http://www.zen-cart.com/view-source:http://topkayaker.com/images/CAS-06507.jpg"]images/CAS-06507.jpg[/URL]" alt="eSeries E-Reader 14" title=" eSeries E-Reader 14 " width="100" height="100" class="listingProductImage" /></a></td>    <td class="productListing-data"><h3 class="itemTitle"><a href="[URL="http://www.zen-cart.com/view-source:http://topkayaker.com/index.php?main_page=product_info&cPath=5_44&products_id=1500"]http://topkayaker.com/index.php?main_page=product_info&cPath=5_44&products_id=1500[/URL]">eSeries E-Reader 14</a></h3><div class="listingDescription">The E-Case brand eSeries™ E-Reader 14 masters the perfect blend of full...</div></td>    <td class="productListing-data" align="right">$34.95<br /><br />Add: <input type="text" name="products_id[1500]" value="0" size="4" /><br /><br /></td>   </tr>
  <tr  class="productListing-even">    <td class="productListing-data" align="center"><a href="[URL="http://www.zen-cart.com/view-source:http://topkayaker.com/index.php?main_page=product_info&cPath=5_44&products_id=1500"]http://topkayaker.com/index.php?main_page=product_info&cPath=5_44&products_id=1500[/URL]"><img src="[URL="http://www.zen-cart.com/view-source:http://topkayaker.com/images/CAS-06507.jpg"]images/CAS-06507.jpg[/URL]" alt="eSeries E-Reader 14" title=" eSeries E-Reader 14 " width="100" height="100" class="listingProductImage" /></a></td>    <td class="productListing-data"><h3 class="itemTitle"><a href="[URL="http://www.zen-cart.com/view-source:http://topkayaker.com/index.php?main_page=product_info&cPath=5_44&products_id=1500"]http://topkayaker.com/index.php?main_page=product_info&cPath=5_44&products_id=1500[/URL]">eSeries E-Reader 14</a></h3><div class="listingDescription">The E-Case brand eSeries™ E-Reader 14 masters the perfect blend of full...</div></td>    <td class="productListing-data" align="right">$34.95<br /><br />Add: <input type="text" name="products_id[1500]" value="0" size="4" /><br /><br /></td>   </tr>
  <tr  class="productListing-odd">    <td class="productListing-data" align="center"><a href="[URL="http://www.zen-cart.com/view-source:http://topkayaker.com/index.php?main_page=product_info&cPath=5_44&products_id=1501"]http://topkayaker.com/index.php?main_page=product_info&cPath=5_44&products_id=1501[/URL]"><img src="[URL="http://www.zen-cart.com/view-source:http://topkayaker.com/images/CAS-06516.jpg"]images/CAS-06516.jpg[/URL]" alt="iPad Case" title=" iPad Case " width="100" height="100" class="listingProductImage" /></a></td>    <td class="productListing-data"><h3 class="itemTitle"><a href="[URL="http://www.zen-cart.com/view-source:http://topkayaker.com/index.php?main_page=product_info&cPath=5_44&products_id=1501"]http://topkayaker.com/index.php?main_page=product_info&cPath=5_44&products_id=1501[/URL]">iPad Case</a></h3><div class="listingDescription">Whatever you want your iPad® tablet to be: an ebook at the coast, a camera in...</div></td>    <td class="productListing-data" align="right">$39.95<br /><br />Add: <input type="text" name="products_id[1501]" value="0" size="4" /><br /><br /></td>

Let me know if you'd like to look deeper.

Thank you. We have over 1500 products. We have over 20 categories and subcategories.

It is only happening with this one product and only on the category listing page, not when a search for the product is done. The product is only in one category.

So I'm reluctant to delete it now because it means something is off somewhere and not many of our visitors access this category so it's no biggy to leave it.

The only difference between it and other products in that category is it's description. So for what it's worth:

The E-Case brand eSeries™ E-Reader 14 masters the perfect blend of full functionality with waterproof protection, sized for an array of popular e-readers and 7-inch tablets. The eSeries 14 case accommodates unrestricted access to features, buttons and capacitive* touchscreens. Reading on the boat deck? Carry on with the confidence of submersible protection and lash points for safely tethering your device. Ultra-clear urethane windows allow full use of touchscreens, cameras and audio functions. Every case is individually tested to meet IPX7 standard of withstanding submersion in 1 meter of water for 30 minutes. One-step, waterproof SealLock™ zipper and rugged RF-welded seams guarantee protection from the elements. PVC-free materials. Die-cut lash points for tethering. UV-resistant windows.
 <br><br>Fits Amazon® Kindle Fire™, Samsung® Galaxy Tab® 7.0 & 7.7, Galaxy™ Nexus™ 7, Barnes & Noble® NOOK®, NOOK® Tablet™, NOOK® Color™, and other 7-inch tablets.
<br><br>Color is GRAY. Weight 2 oz. Compartment width 5.6 in. Overall width 6.9 in. Compartment length 8.75 in. Overall length 9.8 in.
<br><br><img src="http://topkayaker.com/images/usasmall.jpg" alt="Made In The USA" /> Made in USA.<br> <br>