magento2 product Item with the same ID

4.70K 浏览开发笔记
0 Comments

magento2 product Item with the same ID

 magento2 product Item (MagentoCatalogModelProductInterceptor) with the same ID 

查找重复的产品并删掉多余的

SELECT * FROM cataloginventory_stock_item WHERE product_id in ( SELECT product_id FROM cataloginventory_stock_item GROUP BY product_id HAVING ( COUNT(product_id) > 1 ) )

0