Alle Shopware-Artikel aus der Datenbank entfernen + Media-DB für Artikel leeren. Achtung: Artikelbilder müssen noch manuell vom Server entfernt werden /media/img/

gistfile1.sql

SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE `s_articles`;
TRUNCATE TABLE `s_articles_attributes`;
TRUNCATE TABLE `s_articles_categories`;
TRUNCATE TABLE `s_articles_categories_ro`;
TRUNCATE TABLE `s_articles_details`;
TRUNCATE TABLE `s_articles_img`;
TRUNCATE TABLE `s_articles_prices`;
TRUNCATE TABLE s_article_configurator_sets;
TRUNCATE TABLE s_article_configurator_set_group_relations;
TRUNCATE TABLE s_article_configurator_set_option_relations;
TRUNCATE TABLE s_article_configurator_option_relations;
TRUNCATE TABLE `s_articles_similar_shown_ro`;
TRUNCATE TABLE `s_articles_top_seller_ro`;
TRUNCATE TABLE `s_emarketing_lastarticles`;
TRUNCATE TABLE `s_filter_articles`;
DELETE FROM `s_media` WHERE `albumID` = -1;
SET FOREIGN_KEY_CHECKS = 1