Magento查询产品SKU和价格的SQL,
SELECT t2.sku,t1.`value` from catalog_product_entity_decimal AS t1
LEFT JOIN catalog_product_entity AS t2 ON t2.entity_id = t1.entity_id
WHERE t1.attribute_id=76 order by t2.sku
我这里 attribute_id=76是 Special Price
(责任编辑:好模板) |