Alle Shopware-Produkte aus der Datenbank entfernen. Dabei bleiben Kategorien, Configurator-Sets, Konfiguration usw. unangetastet.

truncate_shopware_db.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_articles_similar_shown_ro`;
TRUNCATE TABLE `s_articles_top_seller_ro`;
TRUNCATE TABLE `s_emarketing_lastarticles`;
TRUNCATE TABLE `s_filter_articles`;
TRUNCATE TABLE s_article_configurator_sets;
TRUNCATE TABLE s_article_configurator_options;
TRUNCATE TABLE s_articles_also_bought_ro;
TRUNCATE TABLE s_article_configurator_set_group_relations;
TRUNCATE TABLE s_article_configurator_set_option_relations;
TRUNCATE TABLE s_core_rewrite_urls;
DELETE FROM `s_media` WHERE `albumID` = -1;
TRUNCATE TABLE s_article_configurator_option_relations;
SET FOREIGN_KEY_CHECKS = 1