new category button missing....

[nashvilleskyline]

Pardon my ignorace but, where can I find this products_to_categories table?? I've been searching for this for a long time.
thank you

You can do this by setting the categories_id for each product in the products_to_categories table from 0 to categories_id 1 ...

First, backup your database ...

Next, this will change all Products from being in the Top Level Category of categories_id 0 to categories_id 1 ...

Then run the following in the Tools ... Install SQL Patches ...

UPDATE products_to_categories SET categories_id = 1 where categories_id = 0;

Next, go to the Catalog ... Categories/Products ... and you should be able to click the NEW CATEGORY button ...

Create a Category and when done, all Products should end up in this new Category ... if not, check what categories_id your new Category is and this can be updated on the products_to_categories table after a couple or three additional questions, should this problem arise ... otherwise, you should be set now and can build your Categories and move your Products around to proper Categories ...

[Ajeh]

The products_to_categories table is in your database ...

You can visually see it with phpMyAdmin from your Control Panel for your domain ...

The command I gave you just issues the command to take all of the products that are assigned to the categories_id 0 and set them all to categories_id 1 so that when you make your first Category and it is assigned the categories_id 1 all of the Products will be associated with it so you can Move them to new Categories that you will be able to create ...

[nashvilleskyline]

Thank you very much.
I found the php file but I don't know where to make those changes. So I guess I'll delete every files and start all over again. It seemed not to be too complicated but I'm not familiar with php so I don't want to mess things up.
thank you for your time.
philippe

[Ajeh]

All you have to do is go to your Zen Cart Admin and click on the TOOLS ... INSTALL SQL PATCHES ... and in the box enter:

UPDATE products_to_categories SET categories_id = 1 where categories_id = 0;

And then go back to Catalog ... Categories/Products ... and click on the NEW CATEGORY button that should now be show and ADD you first Category which should end up as categories_id and when you SAVE that new first Category all of your Products will "magically" appear in that new Category ...

Now, you can make your Categories and MOVE these Products to the right Category without having to delete them all and remake each one of them ...

If you don't care about deleting each Product that you already made, then delete each one ... otherwise, run that command after backing up your database ...

[JJDoench]

I have a similar problem. I accidentally added products that were supposed to be in a sub-category into the main category using EP. Can I use this same solution?

So I could change:

UPDATE products_to_categories SET categories_id = 1 where categories_id = 0;

to

UPDATE products_to_categories SET categories_id = (NewNumber) where categories_id = (CurrentMainCategory);

Then delete the new category? Or would this also move the subcategories?

I thought I had a good backup, which I always do before I EP. Unfortunately, I had made a mistake, and lost my backup, so now I have a big mess to clean up. I'm trying to avoid having to delete my whole catalog and reinstall it.

Thanks,
Jessica
www.bestfriendsquilts.com

[Ajeh]

The idea is, your Products are in the products_to_categories under categories_id XXX and you want to put them in the next categories_id you create YYY but to do that you need to first get them out of the current categories_id XXX to a categories_id not yet used YYY ...

If you ONLY have categories_id XXX on ALL products, you can use:

UPDATE products_to_categories SET categories_id = YYY;

If you have several categories_id and just need to fix one categories_id set of products then you can use:

UPDATE products_to_categories SET categories_id = YYY where categories_id = XXX;

Once you do that, you

[Ajeh]

NOTE: you also need to update the master_categories_id on the products table to reflect this change ...

There are several ways to do this, or, if you move them into New Real Categories that will be done for you during the Move ...