如何仅使用mysql在magento中提取所有产品ID，Skus，产品名称，说明？

一个商店视图的标题可能与另一个商店视图的标题不同。相同的描述。另外，某些商店视图可以使用后端中设置的默认值。

这是有关如何获取特定商店视图（标识1）的所有产品所需的数据（SKU，名称，说明）的完整查询。

SELECt     `e`.`sku`,     IF(at_name.value_id > 0, at_name.value, at_name_default.value) AS `name`,    IF(at_description.value_id > 0, at_description.value, at_description_default.value) AS `description`FROM    `catalog_product_entity` AS `e`     INNER JOIN          `catalog_product_entity_varchar` AS `at_name_default`     ON (`at_name_default`.`entity_id` = `e`.`entity_id`) AND        (`at_name_default`.`attribute_id` = (SELECt attribute_id FROM `eav_attribute` ea LEFT JOIN `eav_entity_type` et ON ea.entity_type_id = et.entity_type_id  WHERe `ea`.`attribute_pre` = 'name' AND et.entity_type_pre = 'catalog_product')) AND        `at_name_default`.`store_id` = 0     LEFT JOIN`catalog_product_entity_varchar` AS `at_name`     ON (`at_name`.`entity_id` = `e`.`entity_id`) AND        (`at_name`.`attribute_id` = (SELECt attribute_id FROM `eav_attribute` ea LEFT JOIN `eav_entity_type` et ON ea.entity_type_id = et.entity_type_id  WHERe `ea`.`attribute_pre` = 'name' AND et.entity_type_pre = 'catalog_product')) AND        (`at_name`.`store_id` = 1)     INNER JOIN          `catalog_product_entity_text` AS `at_description_default`     ON (`at_description_default`.`entity_id` = `e`.`entity_id`) AND        (`at_description_default`.`attribute_id` = (SELECt attribute_id FROM `eav_attribute` ea LEFT JOIN `eav_entity_type` et ON ea.entity_type_id = et.entity_type_id  WHERe `ea`.`attribute_pre` = 'description' AND et.entity_type_pre = 'catalog_product')) AND        `at_description_default`.`store_id` = 0     LEFT JOIN`catalog_product_entity_text` AS `at_description`     ON (`at_description`.`entity_id` = `e`.`entity_id`) AND        (`at_description`.`attribute_id` = (SELECt attribute_id FROM `eav_attribute` ea LEFT JOIN `eav_entity_type` et ON ea.entity_type_id = et.entity_type_id  WHERe `ea`.`attribute_pre` = 'description' AND et.entity_type_pre = 'catalog_product')) AND        (`at_description`.`store_id` = 1)

如果您希望将其用于其他商店视图，只需

1

(`at_name`.`store_id` = 1)

和

(`at_description`.`store_id` = 1)

我不知道为什么您需要sql格式的文件。这是一个奇怪且大的错误源。您可以通过代码轻松获得它：

$collection = Mage::getResourceModel('catalog/product_collection')        ->addAttributeToSelect(array('sku', 'name', 'description'));foreach ($collection as $item) {    $sku = $item->getSku();    $name = $item->getName();    $description = $item->getDescription();     //do something with $sku, $name & $description}