Product Sub-Categories do not show up, after moving products

A client had created a master category called Specials (cPath 52) and a sub-category called Clothing Specials (cPath 53). By mistake, customer places all their products under sub-category Clothing Specials (cPath 53).

Last week he decided to organize his specials, and adds several more categories called Jackets (cPath 58), Pants (cPath 59) and Shirts (cPath 60) under Specials (cPath 52). Through admin he then moves these sub-categories to Clothing Specials (cPath 53).

Then he moves all products to their proper sub-categories.
From:
Home > Specials > Clothing Specials
To:
Home > Specials > Clothing Specials > Jackets
Home > Specials > Clothing Specials > Pants
Home > Specials > Clothing Specials > Shirts

After all this when he goes to the following URI:
domainDOT.com/index.php?main_page=index&cPath=52_53, none of the other sub-categories (Jackets, Pants and Shirts) show up. Even thought all newly created sub-categories and products show up in admin, where they are supposed to be.

When he goes to domainDOT.com/index.php?main_page=index&cPath=52_53_58 URI, all the Jackets show up, and the same with Pants and Shirts.

What could be causing the subcategories NOT to show up?

Zen Cart's message is "There are no products to list in this category", at URI domainDOT.com/index.php?main_page=index&cPath=52_53

Zen Cart's message is "There are no products to list in this category", at URI domainDOT.com/index.php?main_page=index&cPath=52_53

Quote:

---

Originally Posted by Kevin205

Zen Cart's message is "There are no products to list in this category", at URI domainDOT.com/index.php?main_page=index&cPath=52_53

---

Potentially having products and categories together is one... Hmm, I've seen the solution to this worked out a couple of times. Sometimes it has involved database review/search from within myphpadmin looking at the products_to_categories table for potential overlap with categories, or possibly thought there was a sort of refresh button under tools->store manager or similar.

Sure there are no products left in the specials category? Active or not?

Quote:

---

Originally Posted by mc12345678

Potentially having products and categories together is one... Hmm, I've seen the solution to this worked out a couple of times. Sometimes it has involved database review/search from within myphpadmin looking at the products_to_categories table for potential overlap with categories, or possibly thought there was a sort of refresh button under tools->store manager or similar.

Sure there are no products left in the specials category? Active or not?

---

I will look at the table.

And Yes I just checked again and there are no products under Specials Category (Master Category) or Clothing Specials (sub-Category).

Quote:

---

Originally Posted by Kevin205

I will look at the table.

And Yes I just checked again and there are no products under Specials Category (Master Category) or Clothing Specials (sub-Category).

---

I took a look under Store Manager of the tools section, about midway down I think it is a button associated with linked products..m has that been selected to see about clearing things up? I realize that we're not talking about linked products, but?

Quote:

---

Originally Posted by mc12345678

I took a look under Store Manager of the tools section, about midway down I think it is a button associated with linked products..m has that been selected to see about clearing things up? I realize that we're not talking about linked products, but?

---

I will give it try and will keep you posted. Thanks.

Unfortunately, it did not work.

I ran the following with no success.
Admin -> Tools -> Store Manager, and click on "Reset ALL Products Master Categories ID"

also ran
Admin -> Tools -> Store Manager, and click on "Reset ALL Products Price Sorter"

No luck.

So the question is, if someone creates products under main category, and then decides to create sub-categories, then what is the proper way to move products to those newly created sub-categories?

Apparently Admin's move function did not work in this case!

Have you an URL for your site that we could perhaps peek at?

Quote:

---

Originally Posted by Ajeh

Have you an URL for your site that we could perhaps peek at?

---

Hello Linda. May I PM?

Sure ...

Also, if you switch to the Classic Template does it work?

Quote:

---

Originally Posted by Ajeh

Sure ...

Also, if you switch to the Classic Template does it work?

---

Tried classic still does not show up. I will pm the path. Thank you.

Could you go to phpMyAdmin and in the table:
products_to_categories

do a search on:
categories_id

for the value:
63

what comes up?

Quote:

---

Originally Posted by Ajeh

Could you go to phpMyAdmin and in the table:
products_to_categories

do a search on:
categories_id

for the value:
63

what comes up?

---

SELECT * FROM `zen_products_to_categories` WHERE `categories_id`=63

resulted:
products_id 5357

If you have no Products in categories_id 63, then there should not be a record for anything with categories_id 63 ...

Check the tables:
products
products_description

for the:
products_id

5357 ... do you have any records?

From what I can see, you do not have a products_id 5357 ... so this is a bad record ...

If that is correct, then delete that record from the table:
products_to_categories

for products_id 5357 categories_id 63

and see if your subcategories are now working ...

Quote:

---

Originally Posted by Ajeh

If you have no Products in categories_id 63, then there should not be a record for anything with categories_id 63 ...

Check the tables:
products
products_description

for the:
products_id

5357 ... do you have any records?

From what I can see, you do not have a products_id 5357 ... so this is a bad record ...

If that is correct, then delete that record from the table:
products_to_categories

for products_id 5357 categories_id 63

and see if your subcategories are now working ...

---

That did it. Thank you.

How did you know it was products_id 5357

Quote:

---

Originally Posted by Kevin205

That did it. Thank you.

How did you know it was products_id 5357

---

You told her: (see below).

Quote:

---

Originally Posted by Kevin205

SELECT * FROM `zen_products_to_categories` WHERE `categories_id`=63

resulted:
products_id 5357

---

I couldn't remember the query/table associated, but that basically was what I was trying to guide to: a product was "associated" with the category in question, but wasn't readily identified without doing some of the ajeh magic. :)

Quote:

---

Originally Posted by mc12345678

You told her: (see below).


I couldn't remember the query/table associated, but that basically was what I was trying to guide to: a product was "associated" with the category in question, but wasn't readily identified without doing some of the ajeh magic. :)

---

Solved.

MC, that's why they call you guys the experts. I did not realize it.

MC and Linda, Thank you.

Thanks for the update that all is working correctly now ... :smile: