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

8 Comments

  • 0
    Avatar
    Laurie Barker

    "Log in to StoreYa.com and upload your CSV." Where exactly is the Upload CSV located?

  • 0
    Avatar
    Emma Harper

    Hi Laurie,

    Please see attached print screens.

    Please let me know if you have any further questions.

    Thanks,

    Emma 

  • 0
    Avatar
    Laurie Barker

    Okay this makes a little more sense but I am using Magento, would is it possible to "seed" the account with a CSV and then update the pricing a visibility of product via Magento API?

  • 0
    Avatar
    Emma Harper

    Hi Laurie,

    Yes, that is possible.

    You can upload the products via CSV and then sync the Facebook store using API.

    Thank you,

    Emma 

  • 0
    Avatar
    Laurie Barker

    Hi Emma

    Following importing our products via CSV and given we would import a subset of our store products, would the API go on to import products that were not present on the original CSV import from StoreYa?

    Would the API pick up when new products are created and import these automatically?

    We have a large amount of products on our site, realistically we do not need or want every product on our StoreYa Facebook Store, is there a method by which we could configure the API to only include specific products.

    Thanks in advance, Laurie

  • 0
    Avatar
    Emma Harper

    Hi  Laurie,

    I've sent you an answer by email, but in short ...

    There are different methods to limit products that imported to Facebook. For example you can create new category and limit import to this category. But there are also another methods. We need to collaborate in order to find the best solution for your configuration.

     

    Thanks,

    Emma.

  • 0
    Avatar
    Tyler Bean

    Hi Emma, how can I upload csv to storeya.com?

  • 0
    Avatar
    Emma Harper
Please sign in to leave a comment.
Powered by Zendesk