Artikel bulk löschen auf Testdomain

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

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

1 Like

Super, danke ö))