/*查询所有产品的group_price*/
SELECT t2.sku,t3.`value` from catalog_product_entity_decimal AS t1
LEFT JOIN catalog_product_entity AS t2 ON t2.entity_id = t1.entity_id
LEFT JOIN catalog_product_entity_group_price t3 ON t3.entity_id = t1.entity_id
WHERE attribute_id=75
Magento查询所有产品的Group Price, 返回 SKU和 价格
最新推荐文章于 2024-04-27 09:54:33 发布