<<SOLVED>> One product is showing blank and I can't find it to delete it.

[rmturner]

Here's my URL:  https://www.collectibleartwear.com/

There is a missing product that just goes to the home page if you click it.  The last time this happened, I found an answer that had me go into PHPAdmin and run some SQL code to find the product and delete it.  I can't find that answer.  I know the product numbers of the products that were created before and after the missing product.  I know that's what I did last time but now I can't find it.

I appreciate any help.

Edited September 8, 2022 by rmturner (see edit history)

[ZIKODK]

If you know the product number before and after, you know the number you want to delete.

With SQL you can delete that number in the table products.

[endriu107]

It happens when you try create new product and save it with empty product name field. You can in back office go to any product edit page and in browser change ID to 3369 that how you can go to this product edit page, then just fill name field and save, this product should be visible on product list in BO and you can manage it or remove.

[rmturner]

Thanks for the responses.  I went into phpmyadmin and deleted 3369 and 3370.  Apparently those weren't the missing product.  Still searching.

 

[rmturner]

Oops, I needed to clear the cache.  Thanks all.