how do mass delete all products from one manufacturer?

[Ajeh]

This would be a bad idea as there are many tables involved with Products ...
products
products_description
specials
featured
reviews
etc. etc. etc.

[kamion]

Ajeh, please remove my previous post. :) Thanks.

[Ajeh]

Actually it is a good post to help people understand that there is more to a Product than just the products table and to not delete them in that manner or they will run into major issues ...

[Kevin205]

So how do you mass delete old products? Do you really have to delete one at a time?

Furthermore, if you delete one by one, or possibly mass delete (let say 200 products); would the remaining record id's create a problem? When year after year you create newer and delete old products? Can the table be somehow compacted?

[schoolboy]

So how do you mass delete old products? Do you really have to delete one at a time?

Furthermore, if you delete one by one, or possibly mass delete (let say 200 products); would the remaining record id's create a problem? When year after year you create newer and delete old products? Can the table be somehow compacted?

No need to "compact" anything... the ID is just an auto-increment and is a database's way of assigning a unique identifier to a record.


If you use Easy Populate, you will see a column called v_status.

There are THREE possible variables for this column:-

1 = Product is active and visible
0 = Product is inactive and hidden (such as when product is out of stock)
9 = Delete product

So if you create an Easy Populate spreadsheet of ONLY the products you want removed, and in the v_status column you put the digit - " 9 " against each product, then run that through easy populate - it will delete the products AND THEIR IMAGES...

If you want to keep the images, then make a backup off the server.

[terraGirl]

You can delete product via Easy Populate by setting the v_status to "9". Any product with 9 invokes the "ep_remove_product" function which in turn uses "zen_remove_product" which wipes the product from all relevant tables and will also delete the associated images from your images folder (/admin/includes/functions/general.php around line 1359). I think that's the easiest option.

The other alternative would be to write a PHP script that looks up all product IDs by manufacturer, loops through them & runs zen_remove_product on each ID. Basically always use zen_remove_product and you're fine.

Hope this helps.

PS oh schoolboy beat me to it by a few seconds :)

[Kevin205]

No need to "compact" anything... the ID is just an auto-increment and is a database's way of assigning a unique identifier to a record.


If you use Easy Populate, you will see a column called v_status.

There are THREE possible variables for this column:-

1 = Product is active and visible
0 = Product is inactive and hidden (such as when product is out of stock)
9 = Delete product

So if you create an Easy Populate spreadsheet of ONLY the products you want removed, and in the v_status column you put the digit - " 9 " against each product, then run that through easy populate - it will delete the products AND THEIR IMAGES...

If you want to keep the images, then make a backup off the server.

You can delete product via Easy Populate by setting the v_status to "9". Any product with 9 invokes the "ep_remove_product" function which in turn uses "zen_remove_product" which wipes the product from all relevant tables and will also delete the associated images from your images folder (/admin/includes/functions/general.php around line 1359). I think that's the easiest option.

The other alternative would be to write a PHP script that looks up all product IDs by manufacturer, loops through them & runs zen_remove_product on each ID. Basically always use zen_remove_product and you're fine.

Hope this helps.

PS oh schoolboy beat me to it by a few seconds :)

WOW, that's pretty cool, great. Thank you.

[schoolboy]

If you have not installed Easy Populate, you will need EP version 4. The earlier versions are not compatible with ZC 1.5.x