Invisible Product

[ausstone]

The product that I posted with a link below is not in my admin area of ZenCart...I deleted all of the products and this one did not go away. Help?

http://www.sportyclaus.com/index.php...414ec7d8f98abe

[kuroi]

Could it be that you've deleted the category it was in but not the product, so that there's nowhere to display it in your admin, even though it's still in your database?

What do you see if you look into your product table using (say) phpMyAdmin?

[ausstone]

Perfect! Thanks...found it there.

[kuroi]

Great. But now what are you going to do about it? If the plan is to delete it, there are a number of linked tables to deal with too.

[kuroi]

Just in case, this is the SQL you'd need to run

SET @pid = 49;
DELETE FROM products WHERE products_id = @pid;
DELETE FROM products_attributes WHERE products_id = @pid;
DELETE FROM products_description WHERE products_id = @pid;
DELETE FROM products_discount_quantity WHERE products_id = @pid;
DELETE FROM products_notifications WHERE products_id = @pid;
DELETE FROM products_to_categories WHERE products_id = @pid;
DELETE FROM media_to_products WHERE product_id = @pid;
DELETE FROM customers_basket WHERE products_id = @pid;
DELETE FROM customers_basket_attributes WHERE products_id = @pid;
DELETE FROM coupon_restrict WHERE product_id = @pid;
DELETE FROM featured WHERE products_id = @pid;
DELETE FROM meta_tags_products_description WHERE products_id = @pid;
DELETE r.*, rd.* FROM reviews r, reviews_description rd WHERE products_id = @pid AND r.reviews_id = rd.reviews_id;
DELETE FROM specials WHERE products_id = @pid;