Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2009
    Posts
    21
    Plugin Contributions
    0

    Default Is there an automated way to delete catagories that have just one product listed?

    Hi

    Hope there is an SQL guru out there

    What I need to do is delete every sub catagories recursively that has only one product listed in it. nb all my products are multi linked to different catagories.

    Done a load of bulk product additions, and didnt notice that I had told the software to create new catagories rather than place them in my newcat catgory for manual adition later. As I have thousands of catagories it is taking forever to do manually.

  2. #2
    Join Date
    Feb 2009
    Posts
    21
    Plugin Contributions
    0

    Default Re: Is there an automated way to delete catagories that have just one product listed?

    I have managed to delete the products in bulk from these catagories

    So how can i mass delete the catagories that have no products or sub catagories to them

 

 

Similar Threads

  1. Is there an automated way to remove discontinued products via a feed?
    By floridaguy43 in forum Setting Up Categories, Products, Attributes
    Replies: 3
    Last Post: 2 Jan 2015, 02:40 AM
  2. Replies: 0
    Last Post: 29 Jan 2013, 12:58 AM
  3. Replies: 0
    Last Post: 5 Aug 2009, 10:00 PM
  4. Is there a way to just show the Products and not have a category?
    By tanyaleann in forum Setting Up Categories, Products, Attributes
    Replies: 7
    Last Post: 15 Oct 2008, 05:32 PM
  5. Is there a way to mass delete attributes that are not being used?
    By GGWS in forum Setting Up Categories, Products, Attributes
    Replies: 8
    Last Post: 3 Jun 2007, 03:49 PM

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