Guest Posted July 4, 2005 Posted July 4, 2005 Hello, my site is www.better-beads.com. I have a mystery product that is showing up on my front page under the 'bestsellers of the month' (used to be my new products section). It has no image, no title, isn't clickable and shows a $0.00 amount. I can't find this thing in my database. Can someone please tell me how to get rid of it? Thanks! Autumn
stevel Posted July 4, 2005 Posted July 4, 2005 You have an entry in your "products" table wth an empty name. The contents of this box are taken from the products table, so it has to be there somewhere. Steve Contributions: Country-State Selector Login Page a la Amazon Protection of Configuration Updated spiders.txt Embed Links with SID in Description
Enzo_UK Posted July 4, 2005 Posted July 4, 2005 Look at the page in internet explorer, go to 'View' in the top bar, and then down to 'Source' this will show you the parsed html that makes up the page..... find the bit of the page that has the best sellers on it.... and you get this.... <td align="center" class="smallText" width="33%" valign="top"><a href="http://better-beads.com/catalog/product_info.php?products_id=81"></a><br><a href="http://better-beads.com/catalog/product_info.php?products_id=81"></a><br>$0.00</td> So its your product No. 81 which appears to be one you have deleted, so dont really know why its still showing up in best sellers!
Guest Posted July 4, 2005 Posted July 4, 2005 Look at the page in internet explorer, go to 'View' in the top bar, and then down to 'Source' this will show you the parsed html that makes up the page..... find the bit of the page that has the best sellers on it.... and you get this.... ? ?<td align="center" class="smallText" width="33%" valign="top"><a href="http://better-beads.com/catalog/product_info.php?products_id=81"></a><br><a href="http://better-beads.com/catalog/product_info.php?products_id=81"></a><br>$0.00</td> So its your product No. 81 which appears to be one you have deleted, so dont really know why its still showing up in best sellers! <{POST_SNAPBACK}> Ok, now it's time to show just how dumb I am with this stuff. How do I get to my products database so that I can delete #81. The only thing I am familiar with is getting to PHPMyAdmin and seeing everything BUT my actual products in my database. So....I'm stuck....can you help? Thanks! Autumn
Enzo_UK Posted July 4, 2005 Posted July 4, 2005 I am no good with phpmyadmin either! Only thing I can add to help is that if you entered all your products in the same order, #81 was in CRYSTALS - 5301 BICONES and was either the last of the 3mm ones, or the first of the 4mm ones.
Enzo_UK Posted July 4, 2005 Posted July 4, 2005 Actually thinking about it.... It may not actually be deleted... Like stevel originally said, its probably just missing its name. The only reason it tells you it doesnt exist when you try and link to it directly http://better-beads.com/catalog/product_in...?products_id=81 is that the qty in stock is zero. Atleast you now know the category that you have to start looking for it in.
stevel Posted July 4, 2005 Posted July 4, 2005 It would be better if you locate the item in admin under the proper category and delete it there. There are several interlocking tables one would want to update. Steve Contributions: Country-State Selector Login Page a la Amazon Protection of Configuration Updated spiders.txt Embed Links with SID in Description
Guest Posted July 5, 2005 Posted July 5, 2005 It would be better if you locate the item in admin under the proper category and delete it there. There are several interlocking tables one would want to update. <{POST_SNAPBACK}> Thanks so much you guys for trying to help me figure this one out..... Now, having read all the comments and suggestions posted, here is my 'issue'. I am using easypopulate so I have a product 81 for just about every single spreadsheet I am using (and there are about 50 of them, so far). The $0.00 isn't showing up just in my crystals section. It actually shows up on the front page no matter what new products I just added to the catalog. Which, btw, the Bestseller's box on my page is really the newest items that have just been added. (Still going to check out my crystals pages though just to make sure.) So, going through admin and each category would take a ton of time (especially on dial-up....lol) although I am willing to do that if necessary. How does the products in the catalog get assigned their unique product # anyways, if I am uploading multiple spreadsheets of products? Like product 81. Again, thanks for the help, I really appreaciate it! Autumn
Guest Posted July 5, 2005 Posted July 5, 2005 Ok, I went into easypopulate and downloaded my entire database to edit....found product 81 (crystals, so very correct) but it had an ID, price and everything. So.....now where to? Could there be a different product 81? Autumn
Recommended Posts
Archived
This topic is now archived and is closed to further replies.