How To Delete Products with SQL? action=delete_product function?

[enigmabomb]

I'm looking for a way to delete products based on product_id's. I tried to look for the function in admin to do it, but I don't see it. Am I correct to assume I just go through each of the product tables and delete any row with the product_id I want to nuke?

THanks

Josh

[Ajeh]

There are lots of peices and parts related to deleting a product ...

It would be better to do a search for the product and delete it in your Zen Cart Admin ...

[enigmabomb]

I've been using the Zencart URL to delete Product ID's and copying and pasting that, but I have several hundred items to nuke. Is the delete_product function available as an include maybe?

I want to write a php script to delete all items with x in their description. This deleting part is giving me fits.

[Ajeh]

You could take the Delete Product proceedure and write your own criteria to manage this ...

You should back up your database before attempting to do this ...

If you look at how a Category is deleted and all of its Products, this should give you am idea of how to delete large quantities of Products based on a given condition ...

[DrByte]

Ajeh is right ... it's safer to use a built-in delete function.

You could write your own script to use zen_remove_product($product_id) on all the products you need to nuke.

[enigmabomb]

What do I need to include to use that function?

I think this is the solution I'm looking for. No need to reinvent the wheel.

Josh

[DrByte]

the application_top.php ... You can see it loaded in most of the /admin files.