Forums / Templates, Stylesheets, Page Layout / Products In Top Level Category Error

Products In Top Level Category Error

Locked
Results 1 to 4 of 4
This thread is locked. New replies are disabled.
19 Nov 2009, 14:47
#1
jill8026 avatar

jill8026

Totally Zenned

Join Date:
May 2007
Posts:
461
Plugin Contributions:
0

Products In Top Level Category Error

I took over a site today for a client - the previous person has limited Zencart knowledge...

I went into the site today and saw that he had placed products in with the categories....of course that is a BIG no-no...

I moved all of the products that were in the top level into a turned off category, so all that shows now is the categories...

But the message is STILL there.....but there are no products in the top level....

Any advice on how I can make that go away so I can add new categories...?!?!?!

Thanks!!!!!
19 Nov 2009, 15:05
#2
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Posts:
10,324
Plugin Contributions:
0

Re: Products In Top Level Category Error

There could be "residual" data in the database - could be caused by products that were ORIGINALLY in with the categories, having been ordered by customers. The database's order tables will now probably refer to those products and their old "categories".

I am not absolutely sure on the above - the only way to check is to look at the database via phpMyAdmin.

But try "Optimizing" your database by going to admin >>> tools >>> store manager, then (at the bottom) click the optimize button.
19 Nov 2009, 15:09
#3
jill8026 avatar

jill8026

Totally Zenned

Join Date:
May 2007
Posts:
461
Plugin Contributions:
0

Re: Products In Top Level Category Error

Thanks schoolboy - I was just shooting blanks hoping there would be an easy fix.....since I have never seen this before I thought there might be something I was overlooking...I did try the optimize feature but no luck....and unfortunately I cannot get to the database so this is not going to be good....
19 Nov 2009, 15:22
#4
afo avatar

afo

Totally Zenned

Join Date:
Aug 2004
Posts:
6,800
Plugin Contributions:
0

Re: Products In Top Level Category Error

No promises that this will work, but ...

1) put the products back where they were (let's say the category was widgets)
2) rename the category to oldwidgets and disable it (click on the green icon to turn it red)
3) create a new widgets category
4) create the needed subcategories under the new widgets category
5) link the products from oldwidgets to the new subcategories.

For step 5, you can also duplicate them in the new subcategories and disable them in the old category. Either way, you'll retain the products for historical purposes.

Try it with one first an see if it works.

I had a similar problem (my own fault), but I was able to temporarily move the products to another category (as you did) and successfully created the subcategory under the original category. Are you sure the category is empty?