Products that are not in a category - can't find them to delete them

[KsR01]

I have a new Zen-Cart set up, installed via Softaculous, no plugins or addons. It is set up with a Template Monster Template that came with some sample products. I went through the product/categories manager, and deleted their products and categories and made my own. I still have 4 products hovering around that aren't in any category. I can see them on the store, I can leave reviews for them, but I can't access them through the admin panel to delete them because they don't seem to be in any category - and I only have 14 items or so, it's not like I could miss them.

Please advise if there's an easy way to track down these 4 floating mysteries and delete them. Everything else is working fine, I'm just stuck with 4 fishing reels in a store that doesn't sell them.

Let me know if there's any more information you need, this is my first post, and I've only been working with ZenCart software for a few weeks.

[Ajeh]

If you can see the 4 Products on your site, what is their URL?

Sounds like they are either missing/using incorrect entries in the products_to_categories table or missing master_categories_id or something similar ...

[KsR01]

http://fightingsheepdog.com/store/in...products_id=28

http://fightingsheepdog.com/store/in...products_id=25

http://fightingsheepdog.com/store/in...products_id=26

http://fightingsheepdog.com/store/in...products_id=27

I'd be willing to believe that you're correct. Is there a way to add those categories back in by number to the categories listing? Any new categories I'm adding have higher numbers...by design, I'm sure.

[KsR01]

Edit - I don't even care if I can delete them, per se - I'd happily settle for hiding them from customers.

[Ajeh]

Could you peek in your Zen Cart Admin in the Catalog ... Categories/Products and see if you have a Category with the ID of 7?

If it is hard to find that, you can go to phpMyAdmin and search the two tables:
categories
categories_description

for the:
categories_id

that is set to 7 ...

If so ...

Next, go to phpMyAdmin and search the table:
products_to_categories

for the:
products_id

that would be 25, 26, 27 and 28 and see what their value for:
categories_id

or if they do not exist at all ...

[KsR01]

Took me a second to work that out, but I browsed those tables(they're short, no searching necessary) and you're right, there's no categories id set to 7, and no products ids set to 25,26,27 or 28. Am I taking my life in my hands editing them in?

[Ajeh]

Did you find in the two tables:
categories
categories_description

a categories_id 7?

[KsR01]

Did you find in the two tables:
categories
categories_description

a categories_id 7?

I found both tables, but no categories_id 7

[Ajeh]

Okay ... let's get tricky ...

Go to your Zen Cart Admin and make a new Category for Junk ...

What is its categories_id?

Let's say it is 98 ...

Go in phpMyAdmin to the table:
products_to_categories

and add each of these Products with their products_id and the categories_id 98 ...

Now go to the Category you just made called Junk ... are these Products now in there?

If so, you can delete that new Category Junk, and it will delete both that Category Junk and those 4 products correctly ...

[KsR01]

That did it! Quick fix, thanks a lot, that was a huge help.