# Artikel bulk löschen auf Testdomain

**URL:** <https://forum.shopware.com/t/artikel-bulk-loschen-auf-testdomain/20057>\
**Category:** Shopware 3.5\
**Tags:** administration\
**Created:** [2. Mai 2014 um 19:56 UTC](https://forum.shopware.com/t/artikel-bulk-loschen-auf-testdomain/20057 "2014-05-02T19:56:05Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mykoenigskinder](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@mykoenigskinder](https://forum.shopware.com/u/mykoenigskinder)\
**Post date:** [2. Mai 2014 um 19:56 UTC](https://forum.shopware.com/t/artikel-bulk-loschen-auf-testdomain/20057/1 "2014-05-02T19:56:05Z")

</div>

Hallo zusammen! Wir nutzen eine Testumgebung u. a. auch für Artikelimporte. Das Seitenweise löschen ist nicht sehr komfortabel. Gibt es ein Plugin das z. B. alle Artikel oder nur bestimmte einer Kategorie löscht? Wie macht Ihr sowas, andere Herangehensweise? Danke Marc

---

<div class="post-metadata">

**Author:** ![EikeBrandtWarneke](https://avatars.discourse-cdn.com/v4/letter/e/cdc98d/32.png) [@EikeBrandtWarneke](https://forum.shopware.com/u/EikeBrandtWarneke)\
**Post date:** [2. Mai 2014 um 22:02 UTC](https://forum.shopware.com/t/artikel-bulk-loschen-auf-testdomain/20057/2 "2014-05-02T22:02:08Z")

</div>

Löscht alle Artikel: ` SET FOREIGN\_KEY\_CHECKS = 0; DELETE FROM s\_core\_translations WHERE objecttype = 'article'; TRUNCATE s\_addon\_premiums; TRUNCATE s\_articles\_bundles; TRUNCATE s\_articles\_bundles\_articles; TRUNCATE s\_articles\_bundles\_customergroups; TRUNCATE s\_articles\_bundles\_prices; TRUNCATE s\_articles\_bundles\_stint; TRUNCATE s\_articles\_lives; TRUNCATE s\_articles\_live\_customer\_groups; TRUNCATE s\_articles\_live\_prices; TRUNCATE s\_articles\_live\_shoprelations; TRUNCATE s\_articles\_live\_stint; TRUNCATE s\_articles\_also\_bought\_ro; TRUNCATE s\_articles\_similar\_shown\_ro; TRUNCATE s\_articles\_top\_seller\_ro; TRUNCATE s\_articles; TRUNCATE s\_filter\_articles; TRUNCATE s\_articles\_attributes; TRUNCATE s\_articles\_avoid\_customergroups; TRUNCATE s\_articles\_categories; TRUNCATE s\_articles\_categories\_ro; TRUNCATE s\_articles\_details; TRUNCATE s\_articles\_downloads; TRUNCATE s\_articles\_downloads\_attributes; TRUNCATE s\_articles\_esd; TRUNCATE s\_articles\_esd\_attributes; TRUNCATE s\_articles\_esd\_serials; TRUNCATE s\_articles\_img; TRUNCATE s\_articles\_img\_attributes; TRUNCATE s\_articles\_information; TRUNCATE s\_articles\_information\_attributes; TRUNCATE s\_articles\_notification; TRUNCATE s\_articles\_prices; TRUNCATE s\_articles\_prices\_attributes; TRUNCATE s\_articles\_relationships; TRUNCATE s\_articles\_similar; TRUNCATE s\_articles\_translations; TRUNCATE s\_articles\_vote; TRUNCATE s\_article\_configurator\_dependencies; TRUNCATE s\_article\_configurator\_groups; TRUNCATE s\_article\_configurator\_options; TRUNCATE s\_article\_configurator\_option\_relations; TRUNCATE s\_article\_configurator\_price\_surcharges; TRUNCATE s\_article\_configurator\_sets; TRUNCATE s\_article\_configurator\_set\_group\_relations; TRUNCATE s\_article\_configurator\_set\_option\_relations; TRUNCATE s\_article\_configurator\_templates; TRUNCATE s\_article\_configurator\_templates\_attributes; TRUNCATE s\_article\_configurator\_template\_prices; TRUNCATE s\_article\_configurator\_template\_prices\_attributes; TRUNCATE s\_article\_img\_mappings; TRUNCATE s\_article\_img\_mapping\_rules; SET FOREIGN\_KEY\_CHECKS = 1; ` Viele Grüße

---

<div class="post-metadata">

**Author:** ![mykoenigskinder](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@mykoenigskinder](https://forum.shopware.com/u/mykoenigskinder)\
**Post date:** [2. Mai 2014 um 22:32 UTC](https://forum.shopware.com/t/artikel-bulk-loschen-auf-testdomain/20057/3 "2014-05-02T22:32:57Z")

</div>

Super, danke ö))