Forums / Setting Up Categories, Products, Attributes / Remove product from Top Level Category

Remove product from Top Level Category

Views: 1,726

Results 1 to 7 of 7
4 Mar 2013, 9:56 PM
#1
anjordan77 avatar

anjordan77

Zen Follower

Join Date:
Jun 2006
Location:
Midlothian, Virginia, United States
Posts:
110
Plugin Contributions:
0

Remove product from Top Level Category

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/index.php?main_page=product_info&cPath=376321&products_id=1000070

5 Mar 2013, 3:01 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Remove product from Top Level Category

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

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

5 Mar 2013, 6:06 PM
#3
anjordan77 avatar

anjordan77

Zen Follower

Join Date:
Jun 2006
Location:
Midlothian, Virginia, United States
Posts:
110
Plugin Contributions:
0

Re: Remove product from Top Level Category

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.

5 Mar 2013, 6:12 PM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Remove product from Top Level Category

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

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

5 Mar 2013, 6:20 PM
#5
anjordan77 avatar

anjordan77

Zen Follower

Join Date:
Jun 2006
Location:
Midlothian, Virginia, United States
Posts:
110
Plugin Contributions:
0

Re: Remove product from Top Level Category

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.

5 Mar 2013, 6:23 PM
#6
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Remove product from Top Level Category

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

that it is not referencing that products_id ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

5 Mar 2013, 8:18 PM
#7
anjordan77 avatar

anjordan77

Zen Follower

Join Date:
Jun 2006
Location:
Midlothian, Virginia, United States
Posts:
110
Plugin Contributions:
0

Re: Remove product from Top Level Category

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!