Hallo,
Wie kann ich in der Datenbank alle Artikeldaten löschen?
Danke
Nur über die Datenbank. Und in dieser Reihenfolge. Achtung: Löscht auch die Kategorien (category)… Und die Produktbilder in der Medienbibliothek bleiben natürlich auch bestehen.
DELETE FROM product_tag;
DELETE FROM product_translation;
DELETE FROM product_visibility;
DELETE FROM product_stream_translation;
DELETE FROM product_stream_filter;
DELETE FROM product_stream;
DELETE FROM product_search_keyword;
DELETE FROM product_review;
DELETE FROM product_property;
DELETE FROM product_price;
DELETE FROM product_option;
DELETE FROM product_media;
DELETE FROM product_keyword_dictionary;
DELETE FROM product_export;
DELETE FROM product_custom_field_set;
DELETE FROM product_cross_selling_translation;
DELETE FROM product_cross_selling_assigned_products;
DELETE FROM product_cross_selling;
DELETE FROM product_configurator_setting;
DELETE FROM product_category_tree;
DELETE FROM product_category;
DELETE FROM product;
DELETE FROM product_manufacturer_translation;
DELETE FROM product_manufacturer;
DELETE FROM seo_url;
ALTER TABLE product AUTO_INCREMENT = 1