new category button missing....

[Ajeh]

How many Products do you have added?

If you have a number of them and don't want to delete them, then I can work out a fix for you ...

If you only have 1 Product, delete it ... and start over and you will see both the New Product and the New Category buttons ...

[nashvilleskyline]

How many Products do you have added?

If you have a number of them and don't want to delete them, then I can work out a fix for you ...

If you only have 1 Product, delete it ... and start over and you will see both the New Product and the New Category buttons ...

I will need that fix...
I searched the forum for hours but can't find the solution.
I have way too many items and stuff to start from scratch..that would take me days. Can you point me to a solution. Thank you very much!!!
Philippe

[Ajeh]

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

[nashvilleskyline]

Thank you very much.
I'm backing up everything right away to try it.
thank you
p

[nashvilleskyline]

for some odd reason I can't download and change persmissions for a file located in cache/sess_749c1b029b5626daa4731d84a2d5a6d9
Do you know why. It stops me from being able to back up my db.
p

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