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

Ich denke man müsste das noch erweitern..

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_img`;
TRUNCATE TABLE `s_articles_img_attributes`;
TRUNCATE TABLE `s_article_img_mappings`;
TRUNCATE TABLE `s_article_img_mapping_rules`;
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`;
UPDATE s_media SET albumID = -13 WHERE albumID = -1;
SET FOREIGN_KEY_CHECKS = 1

und im Anschluß die Bilder dann dann per cleanup aus dem Papierkorb löschen, wohin sie verschoben wurden um auf Nummer sicher zu gehen und nicht ausversehen mehr zu löschen als Sinn macht.