Shopware SQL Befehle für Massenupdates MySQL Alle Hauptartikel deaktivieren anhand eines Kriteriums in der „details“ Tabelle -- Ein SELECT zum testen SELECT * FROM `s_articles` WHERE `id` IN ( SELECT `articleID` FROM `s_articles_details` WHERE `ordernumber` LIKE 'DS%'); -- Das update UPDATE `s_articles` SET `active` = 0 WHERE `id` IN ( SELECT `articleID` FROM `s_articles_details` WHERE `ordernumber` LIKE 'DS%'); 12345 -- Ein SELECT zum testenSELECT * FROM `s_articles` WHERE `id` IN ( SELECT `articleID` FROM `s_articles_details` WHERE `ordernumber` LIKE 'DS%'); -- Das update UPDATE `s_articles` SET `active` = 0 WHERE `id` IN ( SELECT `articleID` FROM `s_articles_details` WHERE `ordernumber` LIKE 'DS%'); -- Alle Artikel aus der Detailtabelle holen eines bestimmten suppliers SELECT * FROM `s_articles_details` WHERE `articleID` IN (SELECT id FROM `s_articles` WHERE `supplierID` = 10) 12 -- Alle Artikel aus der Detailtabelle holen eines bestimmten suppliersSELECT * FROM `s_articles_details` WHERE `articleID` IN (SELECT id FROM `s_articles` WHERE `supplierID` = 10) -- Alle Artikel eines suppliers deaktivieren UPDATE `s_articles` SET `active` = 0 WHERE `supplierID` = 10; -- Alle Details eines bestimmten suppliers deaktivieren UPDATE `s_articles_details` SET `active` = 0 WHERE `articleID` IN (SELECT id FROM `s_articles` WHERE `supplierID` = 10) 12345 -- Alle Artikel eines suppliers deaktivierenUPDATE `s_articles` SET `active` = 0 WHERE `supplierID` = 10; -- Alle Details eines bestimmten suppliers deaktivierenUPDATE `s_articles_details` SET `active` = 0 WHERE `articleID` IN (SELECT id FROM `s_articles` WHERE `supplierID` = 10) 1900 465