Shopware 5.5 - reset article and related data

truncate_articles.sql

SET foreign_key_checks = 0;
TRUNCATE shopware.s_addon_premiums;
TRUNCATE shopware.s_articles;
TRUNCATE shopware.s_articles_also_bought_ro;
TRUNCATE shopware.s_articles_attributes;
TRUNCATE shopware.s_articles_avoid_customergroups;
TRUNCATE shopware.s_articles_categories;
TRUNCATE shopware.s_articles_categories_ro;
TRUNCATE shopware.s_articles_categories_seo;
TRUNCATE shopware.s_articles_details;
TRUNCATE shopware.s_articles_downloads;
TRUNCATE shopware.s_articles_downloads_attributes;
TRUNCATE shopware.s_articles_esd;
TRUNCATE shopware.s_articles_esd_attributes;
TRUNCATE shopware.s_articles_esd_serials;
TRUNCATE shopware.s_articles_img;
TRUNCATE shopware.s_articles_img_attributes;
TRUNCATE shopware.s_articles_information;
TRUNCATE shopware.s_articles_information_attributes;
TRUNCATE shopware.s_articles_notification;
TRUNCATE shopware.s_articles_prices;
TRUNCATE shopware.s_articles_prices_attributes;
TRUNCATE shopware.s_articles_relationships;
TRUNCATE shopware.s_articles_similar;
TRUNCATE shopware.s_articles_similar_shown_ro;
TRUNCATE shopware.s_articles_supplier;
TRUNCATE shopware.s_articles_supplier_attributes;
TRUNCATE shopware.s_articles_top_seller_ro;
TRUNCATE shopware.s_articles_translations;
TRUNCATE shopware.s_articles_vote;
TRUNCATE shopware.s_article_configurator_dependencies;
TRUNCATE shopware.s_article_configurator_groups;
TRUNCATE shopware.s_article_configurator_groups_attributes;
TRUNCATE shopware.s_article_configurator_options;
TRUNCATE shopware.s_article_configurator_options_attributes;
TRUNCATE shopware.s_article_configurator_option_relations;
TRUNCATE shopware.s_article_configurator_price_variations;
TRUNCATE shopware.s_article_configurator_sets;
TRUNCATE shopware.s_article_configurator_set_group_relations;
TRUNCATE shopware.s_article_configurator_set_option_relations;
TRUNCATE shopware.s_article_configurator_templates;
TRUNCATE shopware.s_article_configurator_templates_attributes;
TRUNCATE shopware.s_article_configurator_template_prices;
TRUNCATE shopware.s_article_configurator_template_prices_attributes;
TRUNCATE shopware.s_article_img_mappings;
TRUNCATE shopware.s_article_img_mapping_rules;
TRUNCATE shopware.s_filter;
TRUNCATE shopware.s_filter_articles;
TRUNCATE shopware.s_filter_attributes;
TRUNCATE shopware.s_filter_options;
TRUNCATE shopware.s_filter_options_attributes;
TRUNCATE shopware.s_filter_relations;
TRUNCATE shopware.s_filter_values;
TRUNCATE shopware.s_filter_values_attributes;
SET foreign_key_checks = 1;