Thread: Delete products

Results 1 to 10 of 18

Hybrid View

  1. #1
    Join Date
    Mar 2008
    Location
    Cape Town & London (depends on the season)
    Posts
    2,975
    Plugin Contributions
    0

    Default Re: Delete products

    It can be done via sql. (Though I'm not a sql expert...)

    I use EasyPopulate module to manage MASS updates/additions/deletions in my stores

    With easypopulate, 600 deletions should take you no more than 15 minutes.

    Open the WIKI and search for Easy Populate for a tutorial.

    EasyPopulate 1.2.5.5 can be downloaded in the free add ons section (link at top of page).

  2. #2
    Join Date
    Sep 2005
    Location
    The Internets
    Posts
    190
    Plugin Contributions
    0

    Default Re: Delete products

    Thanks! I do have ezpopulate running, but did not know products could be deleted!
    Make regular site and database backups!

  3. #3
    Join Date
    Sep 2005
    Location
    The Internets
    Posts
    190
    Plugin Contributions
    0

    Default Re: Delete products

    I suppose I should have asked... how do I do this?
    Make regular site and database backups!

  4. #4
    Join Date
    Mar 2008
    Location
    Cape Town & London (depends on the season)
    Posts
    2,975
    Plugin Contributions
    0

    Default Re: Delete products

    v_status

    This controls it.

    • v_status = 1 (Product is active and displays in shop)


    • v_status = 0 (Product is inactive and does not display in shop - equivalent to being "out of stock")


    • v_status = 9 (DELETE Product - will also remove associated images).


    In the WIKI, there is a good tutorial on Easy Populate. (Go to the WIKI (link above) search for Easy Populate (2 words) and click "Go" button.

  5. #5
    Join Date
    Sep 2005
    Location
    The Internets
    Posts
    190
    Plugin Contributions
    0

    Default Re: Delete products

    fairestcape,

    You rock. Saved me a boatload of time!
    Make regular site and database backups!

  6. #6
    Join Date
    Sep 2008
    Posts
    130
    Plugin Contributions
    0

    Default Re: Delete products

    Quote Originally Posted by fairestcape View Post
    v_status

    This controls it.

    • v_status = 1 (Product is active and displays in shop)


    • v_status = 0 (Product is inactive and does not display in shop - equivalent to being "out of stock")


    • v_status = 9 (DELETE Product - will also remove associated images).


    In the WIKI, there is a good tutorial on Easy Populate. (Go to the WIKI (link above) search for Easy Populate (2 words) and click "Go" button.
    You rock. That is all.

    -Tim

  7. #7
    Join Date
    Nov 2007
    Posts
    18
    Plugin Contributions
    1

    help question Re: Delete products

    exactly what I'm looking for for EasyPop

    6500+ products takes a bit longer than 15min., but I've got all day

    BTW, does this delete categories and groups as well?

  8. #8
    Join Date
    Mar 2008
    Location
    Cape Town & London (depends on the season)
    Posts
    2,975
    Plugin Contributions
    0

    Default Re: Delete products

    Quote Originally Posted by kairen View Post
    BTW, does this delete categories and groups as well?
    No, categories and groups stay there - but these are easy and quick to remove via admin panel (unless you have 1000's of categories )

 

 

Similar Threads

  1. Delete Products
    By danbm in forum General Questions
    Replies: 1
    Last Post: 23 Nov 2010, 07:50 PM
  2. Products delete
    By ruffendz in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 6 Nov 2009, 10:39 PM
  3. Can't delete products in cart with delete button
    By DaveS in forum General Questions
    Replies: 4
    Last Post: 20 Sep 2009, 09:54 PM
  4. Replies: 5
    Last Post: 19 Nov 2006, 05:40 PM

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