Magento导出产品问题

Question

我使用 magento 产品导出的默认配置文件，当我单击运行配置文件时，我得到一个空白屏幕，我在数据库中有 1000 个产品。 导入就像魅力一样。 我也无法出口产品库存，但我能够出口客户。 我使用magento 1.4版本。 请帮忙

Answer 1

在您的 Magento 目录中有一个 .htaccess 文件。打开它并找到以下几行：

php_value memory_limit 128M
php_value max_execution_time 18000

将 memory_limit 增加到 256M 或更高（如果您愿意）。通过在 Magento 目录中创建一个如下所示的文件来确认更改：

<?php phpinfo();

通过直接在浏览器中输入文件名来访问该文件，您应该能够看到 memory_limit 现在是多少。

Answer 2

如果设置限制不起作用，我建议打开平面目录或使用 sql。我提供了一个仅链接的答案，现已过期，但 WayBackMachine 挽救了这一天（http://web.archive.org/web/20110112232603/http://basdebie.com/magento/magento-export-time-out-尝试-plain-sql)

SELECT DISTINCT P.entity_id, P.sku, V.value AS Name, T1.value AS ProdDesc, T2.value AS ShortDesc,
V3.value AS MetaTitle, V4.value AS MetaDescription,
C2.value AS CatName,
D.value AS Price,
G.parent_id AS Product_parent,
    CASE
        WHEN V2.Value = 'no_selection'
        OR V2.Value = '/'
                THEN NULL
        ELSE V2.value
    END AS Image
    FROM  mgnt_catalog_product_entity AS P INNER JOIN
    mgnt_catalog_product_entity_varchar AS V  ON P.entity_id = V.entity_id  AND V.attribute_id  = 60  LEFT JOIN
    mgnt_catalog_product_entity_varchar AS V2 ON P.entity_id = V2.entity_id AND V2.attribute_id = 74  LEFT JOIN
    mgnt_catalog_product_entity_varchar AS V3 ON P.entity_id = V3.entity_id AND V3.attribute_id = 71  LEFT JOIN
    mgnt_catalog_product_entity_varchar AS V4 ON P.entity_id = V4.entity_id AND V4.attribute_id = 73  LEFT JOIN
    mgnt_catalog_category_product AS C1 ON P.entity_id = C1.product_id LEFT JOIN
    mgnt_catalog_category_entity_varchar AS C2 ON C1.category_id = C2.entity_id AND C2.attribute_id = 33 LEFT JOIN
    mgnt_catalog_product_relation AS G ON P.entity_id = G.child_id LEFT JOIN
    mgnt_catalog_product_entity_text    AS T1 ON P.entity_id = T1.entity_id AND T1.attribute_id = 61  LEFT JOIN
    mgnt_catalog_product_entity_text    AS T2 ON P.entity_id = T2.entity_id AND T2.attribute_id = 62  LEFT JOIN
    mgnt_catalog_product_entity_decimal AS D  ON P.entity_id = D.entity_id  AND D.attribute_id  = 64
ORDER BY P.entity_id ASC