Delete products

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

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.

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

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

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

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.

fairestcape,

You rock. Saved me a boatload of time! :clap:

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.

You rock. That is all.

-Tim

exactly what I'm looking for for EasyPop :clap:

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

BTW, does this delete categories and groups as well?

kairen:

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 :laugh:)

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? :frusty:

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.

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.
:wink:

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.

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.

Yeah I don't know how to do that...

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.

ok i clicked the optimize database button, and it redirects me to a blank page, is that right? isn't it supposed to redirect me back or something,could that be a problem with my sql database?

No, you should not get a blank page. A blank page suggests that an error occurred.
Ref: https://www.zen-cart.com/tutorials/index.php?article=82

DrByte:

No, you should not get a blank page. A blank page suggests that an error occurred.
Ref: https://www.zen-cart.com/tutorials/index.php?article=82

thanks for the advice but im still not getting any where, blank page are all over my admin, i can make a new product, but when i try to add an image, it gives me a blank page, same with multiple different things, somebody help please!
:frusty:
:lamo: