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

[Kevin205]

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?

[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

[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

[mc12345678]

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?

[Kevin205]

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).

[mc12345678]

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?

[Kevin205]

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.

[Kevin205]

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!

[Ajeh]

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

[Kevin205]

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

Hello Linda. May I PM?