Remove product from Top Level Category

[anjordan77]

For some reason there is a product that is put in my very top level category which i cannot access to remove the product. I have an active site with over 1500 products on it and plenty of categories etc. If someone could tell me how to make a higher top level or remove that product it would be great.

Example here:
http://allpaintballsupplies.com/inde...cts_id=1000070

[Ajeh]

Do you see the M for MOVE on the line for the Product?

You can use that to move it to and existing Category ... then make a new Top Level Category and Move it to that ...

[anjordan77]

Negative, can't view this product in the admin side. it only show the categories that are under the top level ...rather stumped on this, i know it's not the end of the world, but it's a definite glitch. I've read about people having this problem that use Easy Populate, so it would be a good one to figure out. The older versions you could change the top level and add a higher level above that etc. Like for instance, if i decided to go from a Paintball only store like i am now to also carry Airsoft i would have 2 main categories Paintball and Airsoft....but right now i'm only showing the paintball category...how would i add a "Master" category above my top level now?

Go figure a product named "Drone" would come back to bite me in the backside.

[Ajeh]

If you peek in phpMyAdmin, and look in the table:
products

search for the products_id, what is the:
master_categories_id

If you peek in the table:
products_to_categories

search for the products_id and see if:
1 is it in there

2 is it associated with a valid categories_id

[anjordan77]

Thanks Ajeh, i managed to search the Database using MYSQLworkbench for that product, then just deleted that row to remove it, for some reason i couldn't move it to a working category but it was outdated anyways. All seems well now...hopefully i didn't mess too much up.

[Ajeh]

make sure to test the other tables:
products_description
specials
etc. etc.

that it is not referencing that products_id ...

[anjordan77]

Got it, i must say the 1.5.1 is much more stable than my 1.3.9h build i had. My server used to crash about once a week i think from the database access, now it seems it's been up for a couple weeks without any real problems. Great work on this latest build!