Zen Cart Logo
Forums / All Other Contributions/Addons / Can't Edit Product Not In A Category

Can't Edit Product Not In A Category

Views: 840

Results 1 to 8 of 8
1 Feb 2021, 8:30 PM
#1
gregwhite avatar

gregwhite

New Zenner

Join Date:
Sep 2017
Location:
United States
Posts:
21
Plugin Contributions:
0

Can't Edit Product Not In A Category

The guy (now dead) that set up my Zen Cart installation somehow ended up with several products that are not in any Category, but still show up on the website products list. But I can't seem to get to them to edit or delete them in the Admin area.

I do have the same products in the correct category, so when you search for the product by name or number, they both show up.

Any ideas?

1 Feb 2021, 8:51 PM
#2
gregwhite avatar

gregwhite

New Zenner

Join Date:
Sep 2017
Location:
United States
Posts:
21
Plugin Contributions:
0

Re: Can't Edit Product Not In A Category

I meant Can't Edit Product Not In A Category

2 Feb 2021, 1:02 AM
#3
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: Can't Edit Product Not In A Category

Generally a product that is not in a category actually has a master_categories_id of 0 or is linked to that category.

So couple of things, likely easier to address through having one or more links to the site, but if the products_id is the same on the catalog side for these two "product" then there is a different solution than if both have a different products_id. Further, if the product when viewed within the category is linked, it should be possible to see that fact and then to adjust the category links...

Further it could be that there is this "special" category or other designation that has been setup to display these product as if they have no category...

Offer whatever info you have available to see what next to suggest. :)

3 Feb 2021, 6:29 PM
#4
gregwhite avatar

gregwhite

New Zenner

Join Date:
Sep 2017
Location:
United States
Posts:
21
Plugin Contributions:
0

Re: Can't Edit Product Not In A Category

Hi,

Thanks for the response.

If I search for BK23 on the website, both products are displayed, and either one can be ordered.

https://www.texaselectrolysissupply.com/index.php?main_page=advanced_search_result&search_in_description=1&keyword=bk23

But if I'm in the Admin section and search for BK23, only the 79.95 one shows up and can be modified.

The path to that one, shown on the website,

https://www.texaselectrolysissupply.com/index.php?main_page=product_info&cPath=221&products_id=1699

shows a products_id of 1699.

But the other one, the one I can't modify or delete, shows this,

https://www.texaselectrolysissupply.com/index.php?main_page=product_info&cPath=191&products_id=1356

with a products_id of 1356.

I have several more products like this that I would just like to delete.

As far as I can tell, the products are not linked in any way, nor is there a 'special' category that I'm aware of.

Thanks for your help.

3 Feb 2021, 6:44 PM
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Can't Edit Product Not In A Category

You've identified product IDs.
In the Admin, if you click on any product to edit, you'll see that the &products_id=XXXX is in the browser's address bar.
Edit that to one of those problematic IDs, and press Enter to open its page.
Set the Master Category ID, and Save.
Now you can do further edits, or even delete from the category listing screen.

3 Feb 2021, 7:21 PM
#6
gregwhite avatar

gregwhite

New Zenner

Join Date:
Sep 2017
Location:
United States
Posts:
21
Plugin Contributions:
0

Re: Can't Edit Product Not In A Category

Took me a minute to figure out that I also had to change the path as well as the products_id, but that got me to the hidden one and I was able to turn it off.

Thanks a lot. Didn't realize I could click on the ID in the Admin section like that.

3 Feb 2021, 7:43 PM
#7
swguy avatar

swguy

Administrator

Join Date:
Feb 2006
Location:
Tampa Bay, Florida
Posts:
10,711
Plugin Contributions:
56

Re: Can't Edit Product Not In A Category

If you want to fix these products, you can use my Audit tool.

https://www.zen-cart.com/downloads.php?do=file&id=2261

3 Feb 2021, 7:52 PM
#8
gregwhite avatar

gregwhite

New Zenner

Join Date:
Sep 2017
Location:
United States
Posts:
21
Plugin Contributions:
0

Re: Can't Edit Product Not In A Category

Thanks.

I just downloaded it.