How can I delete all Products by manufacture

11 Aug 2006, 8:41 PM

milobloom

Totally Zenned

Join Date:: Feb 2004
Posts:: 1,267
Plugin Contributions:: 1

How can I delete all Products by manufacture

How can I delete all Products by manufacture??

I am sure there is some SQL function for it.

Thanks in adavance.

12 Aug 2006, 7:19 AM

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,513
Plugin Contributions:: 176

Re: How can I delete all Products by manufacture

**DANGER TERRITORY **

find your manufacturers_id

then run:

DELETE FROM products where manufacturers_id = XXXX;

But ... before you do that, you really need to SELECT all those records, identify the products_id for each, and then remove all the related records from the rest of the products_xxxxxxxxxxx tables.

Otherwise you'll end up with lost records all over and will have your store operating very strangely.

USE AT OWN RISK, AND ONLY IF YOU KNOW SQL COMMANDS WELL****

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.