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.

[buzltyr]

I have deleted all the products, but under the admin/Product types it shows I have 8 products. this is probably why I can't add categories as the add shows add product only, I have searched all through the menus in the catalog but I can't find anymore products to delete. Nor does the site show any, where do I find those products?

[fairestcape]

You've probably got dribs and drabs of corrupt data lurking in the product tables in the database.

Try this:-

ADMIN>>>TOOLS>>>STORE MANAGER...

... right at the the bottom is a button to optimise the database.

Click it.

[buzltyr]

I tried that and I still do not have the add category. I have 8 products in the Product Types/ Products General. I did see on a thread somewhere there is an sql patch that is run through the admin that fixes this but cannot find it as yet. Will keep looking and thanks for your help.

[fairestcape]

There is still some residual (perhaps corrupted) data in your dbase tables.

If you are familiar with phpMyAdmin, it's possible to remove this stuff using that interface (phpMyAdmin).

It's quite handy (phpMyAdmin) for those of us who know a smattering of SQL, but are too terrified of running a detailed SQL query!

A SQL query query to remove data would include the truncate command, so search the forum for other examples of SQL where truncate features in the syntax.