Delete products

[kburner]

Is there any way to delete products faster than admin/categories, but I still need to see title name? I had someone do a download from my distributor, but added all products and many do not go with my site. I can tell my looking at title. It is taking a long time to go back and forth on the pages with categories. As soon as I do a delete system takes me back to page 1. I have 846 PAGES to go through.

Is there another area where I can delete and stay on same page for next deletion without system taking me back to beginning page?

Thanks,
Kim

[xt0rt]

Bump!

I have about 600 to remove, as I want to copy an existing database to a new site without moving the products over.

Can this be done in phpMyAdmin? If so, how? I have no experience editing mySQL databases.

[fairestcape]

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

[xt0rt]

Thanks! I do have ezpopulate running, but did not know products could be deleted!

[xt0rt]

I suppose I should have asked... how do I do this?

[fairestcape]

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.

[xt0rt]

fairestcape,

You rock. Saved me a boatload of time!

[yelow]

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

[kairen]

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?

[fairestcape]

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 )