Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2009
    Posts
    5
    Plugin Contributions
    0

    Default Ghost Items From a Deleted Category

    In trying to tidy my site up I moved some items around and deleted the original category that they were in. It appears that I may have missed one however as I have an item that a customer purchased from the site, but I cannot locate it in the Admin section.

    I was still able to search for it on the online catalog, and saw from the page that it was in category 77, but looking through my categories I believe that was one that was deleted. Is there a way to simply show all categories at once?

    Even though I can search for the item on the active site, I cannot search for it in the Admin section, which is making it hard to move it to a new category, delete or disable it. Is there a way to find it? I'm worried about situations where we may actually run out of them, but a customer can still purchase it on the site...

  2. #2
    Join Date
    Oct 2009
    Posts
    5
    Plugin Contributions
    0

    Default Re: Ghost Items From a Deleted Category

    So nothing like this has happened before?

  3. #3
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Ghost Items From a Deleted Category

    Check the table:
    products

    and see what the master_categories_id is ...


    Check the table:
    products_to_categories

    and search for the categories_id 77 or the products_id to see what it is related to ...


    Check the table:
    categories

    and make sure that there is not a categories_id 77 ...


    Check the table:
    categories_description

    and make sure that there is not a categories_id 77 ...


    Check the table:
    specials

    and see if there is a products_id for the Product in there ...


    Check the table:
    featured

    and see if there is a products_id for the Product in there ...
    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: v1.5.5]
    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!

 

 

Similar Threads

  1. Replies: 3
    Last Post: 2 Aug 2016, 01:03 PM
  2. v151 Images deleted when entire category deleted
    By jghogue in forum Customization from the Admin
    Replies: 1
    Last Post: 3 Oct 2013, 04:20 PM
  3. how to prevent image from being deleted when a product is deleted?
    By denniszc in forum All Other Contributions/Addons
    Replies: 7
    Last Post: 7 Mar 2013, 03:01 PM
  4. v139h Removing Category Picture from Items
    By GenomeTuning in forum General Questions
    Replies: 4
    Last Post: 29 Aug 2012, 02:54 PM
  5. Blocking Category from New Items
    By dng in forum General Questions
    Replies: 5
    Last Post: 10 Oct 2006, 01:52 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR