How can I delete a product via MySQL

[AndersHelbo]

Hi

 

Anyone who knows an easy way to delete a reference number from PrestaShop via MySQL?

[tuk66]

UPDATE ps_product SET reference = '' WHERE id_product = your_id;

[AndersHelbo]

UPDATE ps_product SET reference = '' WHERE id_product = your_id;

 

Thanks a lot

This action - does it delete the product from the cataloge? Maybe I did not explain my self very well.... sorry But I want to delte the product from the cataloge?

[tuk66]

Oh sorry, you wrote "to delete a reference number" so this query removes the reference only.