Question

zencart 批量删产品。 例如我想要产生产品 ID 从 44567 到 44667 的产品，如何冲从产品表中批量删除，

Answer 1

直接在mysql里后台处理,这四个SQL语句依次执行便可彻底删除:
delete from products_attributes where products_id>=44567 and products_id<=44667;
delete from products where products_id>=44567 and products_id<=44667;
delete from products_to_categories where products_id>=44567 and products_id<=44667;
delete from meta_tags_products_description where products_id>=44567 and products_id<=44667;

Answer 2

如果只是删除products表的话，运行一个SQL就可以了。
delete from products where products_id > 44566 and products_id < 44668
做之前建议备份数据库。
不过其实删产品还有别的表需要清理的。。

追问

能否把其他产品相关表的SQL 语句写下
在这万分感谢啊。。

追答

delete from products_to_categories where products_id > 44566 and products_id < 44668
其实还有很多个表有关联的。。如果你的网站经过二次开发。。可能有更多。。
反正如果你找到哪个表里面有products_id字段的。就执行上面的SQL。把表名替换就好。

Answer 3

不是有批量删除插件么？

追问

哪个批量删除插件啊
求插件名

哪个批量删除插件啊
求插件名