Follow

Special Instructions for Importing Products CSV for Magento Versions 1.3-1.4.2 - Export Categories Names

The Magento versions 1.3-1.4.2 provide categories by their numbers and not by their names.

Please install this free extension in order to have your store displaying your category names.

 

You can follow the next steps without any required knowledge, and have your CSV extracted with your category names:

 

  1. System> Magento Connect> Magneto connect manager
  2. At the text box of #2, add the following extension key –  magento-community/Omikron_ExportExtension
  3. Click on the Get back to admin link
  4. Click: system> Import/Export/ Advanced profile
  5. Click: Add new profile button (top right)
  6. Enter any name at the first text box and the below xml at the second text box
  7. Click save profile button (top right)
  8. Click run profile (top left)
  9. Go to your hosting service and search for the CSV (according to the name you gave it above) at the following path - Var/Export
  10. Open you CSV, go to its “category” column (should be the last column), and change it to “_category”.
  11. Log in to StoreYa.com and upload your CSV.

 

XML:

<action type="catalog/convert_adapter_product" method="load">

    <var name="store"><![CDATA[0]]></var>

</action>

<action type="catalog/convert_parser_product" method="unparse">

    <var name="store"><![CDATA[0]]></var>

    <var name="url_field"><![CDATA[0]]></var>

</action>

<action type="dataflow/convert_mapper_column" method="map">

</action>

<action method="unparse" type="exportextension/modifier">

    <var name="remove_line_breaks">true</var>

    <var name="remove_html_tags">true</var>

    <var name="add_categories">true</var>

    <var name="category_field_name">category</var>

    <var name="category_delimiter">#</var>

    <var name="category_first_level">-1</var>

    <var name="category_path_delimiter"><![CDATA[>]]></var>

</action>

<action type="dataflow/convert_parser_csv" method="unparse">

    <var name="delimiter"><![CDATA[,]]></var>

    <var name="enclose"><![CDATA["]]></var>

    <var name="fieldnames">true</var>

</action>

<action type="dataflow/convert_adapter_io" method="save">

    <var name="type">file</var>

    <var name="path">var/export</var>

    <var name="filename"><![CDATA[export_all_products.csv]]></var>

</action>

Was this article helpful?
0 out of 1 found this helpful
Have more questions? Submit a request

9 Comments

Please sign in to leave a comment.
Powered by Zendesk