My suppliers provide me with 'discontinued items' xml feeds. While I have already intergrated a live stock status feed into my website, I would like to do the same for discontinued products.

So, I would like the discontinued products and their images to be automatically deleted.

I can easily extract the information from my suppliers xml file, but how would I delete the products (and their images) from my store database?

I understand that when you delete a product from the admin it's not the same end result as simply removing that product record from the database.

Can anyone advise me on this please? Thanks in advance. :)