Shopware SQLs
Zum durchforsten in der Datenbank sollten die SQL Anweisung weiterhelfen
Auflistung aller Gutscheine in den Bestellungen
SELECT * FROM s_order_details details INNER JOIN s_order orders ON details.orderID = orders.id INNER JOIN s_emarketing_vouchers voucher ON details.articleordernumber = voucher.ordercode LEFT JOIN s_emarketing_voucher_codes codes ON codes.id = details.articleID WHERE details.modus = 2 && orders.ordernumber != 0 ORDER BY orders.id DESC LIMIT 0,25
Auflistung der Bestelldaten nach Artikelnummer
SELECT o.ordernumber as Besellnummer, od.articleordernumber as Artikel, od.quantity as Menge, DATE_FORMAT(o.ordertime, "%d.%m.%Y %H:%i:%s") as Bestelldatum, IF(u.salutation="ms", "Frau", "Herr") as Anrede, u.firstname as Vorname, u.lastname as Nachname, u.email as Email FROM s_order_details as od LEFT JOIN s_order as o ON o.id=od.orderID LEFT JOIN s_user as u ON u.id=o.userID WHERE od.articleordernumber IN ("SW10013", "SW10015", "SW10016") ORDER BY o.ordertime
Alle aktiven Drittanbieter Plugins deaktivieren
UPDATE `s_core_plugins` SET `installation_date`= NULL WHERE `active` = 0; UPDATE `s_core_plugins` SET `active`= 0 WHERE `source` = 'Community' || `source` = 'Local' || `namespace` = 'ShopwarePlugins';
Zuletzt gelesen