CRMEB系统删除商品操作比较繁琐，运营每次要删除商品的时候都会叨叨开发技术。不想在去修改删除逻辑，直接手动数据库删除想要删除的全部商品。【删库有风险，操作需谨慎！！！】
【删库有风险，操作需谨慎！！！】
【删库有风险，操作需谨慎！！！】
这里以删除某个供应商下面的全部商品为例进行删除。需要删除id为110的供应商下面的全部商品，需要删除以下几个表
DELETE FROM eb_store_product_attr WHERE product_id IN (SELECT id FROM eb_store_product WHERE relation_id = 110);
DELETE FROM eb_store_product_attr_value WHERE product_id IN (SELECT id FROM eb_store_product WHERE relation_id = 110);
DELETE FROM eb_store_product_attr_result WHERE product_id IN (SELECT id FROM eb_store_product WHERE relation_id = 110);
DELETE FROM eb_store_product_description WHERE product_id IN (SELECT id FROM eb_store_product WHERE relation_id = 110);
DELETE FROM eb_store_product_log WHERE product_id IN (SELECT id FROM eb_store_product WHERE relation_id = 110);
DELETE FROM eb_store_product_relation WHERE product_id IN (SELECT id FROM eb_store_product WHERE relation_id = 110);
DELETE FROM eb_user_relation WHERE product_id IN (SELECT id FROM eb_store_product WHERE relation_id = 110);
DELETE FROM eb_store_product_stock_record WHERE product_id IN (SELECT id FROM eb_store_product WHERE relation_id = 110);
-- 最后单独执行这一步 删除商品表
-- 最后单独执行这一步 删除商品表
-- 最后单独执行这一步 删除商品表
DELETE FROM eb_store_product WHERE relation_id = 110
如果需要删除的是某个商品的话，直接修改删除条件就可以了
