Deleted All Categories - How to create a new one?

New install v 1.5

I'm going for rookie of the year here. Hoping I don't win it multiple years.
I sell a single product with accessories. didn't think a needed categories so deleted them all. Now getting error message on my product page:

"WARNING: You have Products in the Top Level Category. This will cause pricing to not work properly in the Catalog. Products found: 1.

Been all through the FAQ's, the forums but . . .

Any ideas?

Thanks

The Warning is due to having a Product in the Top Level, or if you had Categories with both Categories and Products in it ...

Categories hold either Products or Categories, but never both ...

To fix this, go to the Tools ... Install SQL Patches ... and run this:

UPDATE products_to_categories SET categories_id = 1;

this will make your Product "disappear" for a few minutes ...

Now, go to Catalog ... Categories/Products ...

you should now see the NEW CATEGORIES button ... and no Warning message ...

Next, add a New Category ...

When done, go into that Category ...

If you see your Product(s) then you are done ...

If you do NOT see your Product(s), look in the URL and see what the cPath says, such as:
cPath=2

Using the number you see, go to the Tools ... Install SQL Patches ... and re-run the command with following change:

UPDATE products_to_categories SET categories_id = [B]2[/B];

where 2 is the number you saw on the:
cPath=2

in your URL on your browser ...

Now, go to Catalog ... Categories/Products ... and you should now see your Product(s) ...

Worked like a charm! Product appeared without the need for step 2. Thank you for your quick response!
If you provide Zen consulting on a fee for service basis perhaps you can help me a few other things I'm trying to achieve?
You may contact me at [email protected]
Thanks again! You've saved me a ton of time.
Bill

Thanks for the update that this worked for you ...

There is always our Free Zen Cart forums for questions that you might have ... :smile: