# Alle Artikel Daten löschen
**URL:** https://forum.shopware.com/t/alle-artikel-daten-loschen/71190
**Category:** Allgemein
**Created:** [26. November 2020 um 15:31 UTC](https://forum.shopware.com/t/alle-artikel-daten-loschen/71190 "2020-11-26T15:31:34Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@11shop](https://forum.shopware.com/u/11shop)
#### Post date: [26. November 2020 um 15:31 UTC](https://forum.shopware.com/t/alle-artikel-daten-loschen/71190/1 "2020-11-26T15:31:34Z")
Hallo,
Wie kann ich in der Datenbank alle Artikeldaten löschen?
Danke
---
### Author:  [@opalion](https://forum.shopware.com/u/opalion)
#### Post date: [27. November 2020 um 14:02 UTC](https://forum.shopware.com/t/alle-artikel-daten-loschen/71190/2 "2020-11-27T14:02:43Z")
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