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 „Gefällt mir“
Super, danke ö))