So I need to remove all the products and all product information. Instead of deleting them from the admin UI I just want to clean up the tables and truncate them.

This is for shopware version 6.4.20.1

What tables to cleanup ?

Products

  • product
  • product_category
  • product_category_tree
  • product_configurator_setting
  • product_cross_selling
  • product_cross_selling_assigned_products
  • product_cross_selling_translation
  • product_custom_field_set
  • product_download
  • product_media
  • product_option
  • product_price
  • product_property
  • product_review
  • product_translation
  • product_visibility

To clean them up run

TRUNCATE TABLE product;
TRUNCATE TABLE product_category;
TRUNCATE TABLE product_category_tree;
TRUNCATE TABLE product_configurator_setting;
TRUNCATE TABLE product_cross_selling;
TRUNCATE TABLE product_cross_selling_assigned_products;
TRUNCATE TABLE product_cross_selling_translation;
TRUNCATE TABLE product_custom_field_set;
TRUNCATE TABLE product_download;
TRUNCATE TABLE product_media;
TRUNCATE TABLE product_option;
TRUNCATE TABLE product_price;
TRUNCATE TABLE product_property;
TRUNCATE TABLE product_review;
TRUNCATE TABLE product_translation;
TRUNCATE TABLE product_visibility;

All products and option releations should now be clean.