Magento: How to use the Import/Export Tool

The import/export tool is very useful within Magento. Being that there is limited documentation on the topic, I thought I would add my .02.

Basically you can use the import/export tool to do mass imports of products. It makes it much easier if you would like to add 50 products all at once, you would just create a csv or xml file with the matching fields for the database, add your information and then use the import tool to import the products. You can retrieve a sample csv or xml file, but doing an export.

Doing an export is very easy, and allows you to export all of your products out of your website. You might want to do this, if you are moving your website or need to reinstall or upgrade your website, and need to get the products out.

Its a very useful tool.

35 thoughts on “Magento: How to use the Import/Export Tool”

  1. I just did this. I used some formulas in Excel to generate a list of similar simple products titles and descriptions based on various combinations of attributes like size and shapes of the product.
    The import said it processed 0% of them but I do see them in my store now.

  2. This sounds like a great feature

    I need to use a live XML feed from wholesaler to add and update products. How can I do this?

    I guess one of the problems is that the fields will not match up. Also does the feature work with XML?

  3. Vituemart for Joomla has had this feature for years, its just unfortunate Vituemart isn't as bug free as Magento

    The exporting and importing in Magento is also configurable so plug into any resource. Very useful for account systems like MYOB

  4. I was having trouble with Excel editing / magento importing. Mainly due to:
    – Excel putting quotes around some fields
    – I had the 'Product Number' in import set to the number of products… This needs to be between 1 and 20… This solves the 0% thing. To solve Excel thing, I kept mucking around till I could import the CSV back into Excel with no problem:

    – Excel puts quotes around some fields [eg. ,"some text with a, comma",]
    – Some fields may have quotes or commas in

    In Excel find/replace ,/~~ [all commas = ~~ ]
    In Excel find/replace "/' [all quotes = ' ]

    Export as CSV from Excel

    Import into text editor

    Find/replace ,/","
    Find/replace admin"/"admin"
    Find/replace special_from_date/special_from_date"
    Find/replace "n/""n
    Find/replace n"admin"/,"n"admin"

    Add " at very beginning and very end
    f/r ,"""/,""
    Find/replace ~~/,

        1. login to the webserver, where the magento installation is hosted. There you can see folder /var , go into it and there is a export folder inside it

  5. Can Magento map XML fields? For example, on import can I tell Magento to assign certain XML tags in the file I'm using to the tags that Magento recognizes?

  6. I am trying to import 50 products into magento via XML. I havent seen any posts here that actually answer this question. Does anyone know how to do it…. step by step? Thank you in advance for your consideration…. it's much appreciated.

  7. Is there anyone can tell me where I can find the files I exported?, this seems do not work…

  8. Hi,

    There is a 'smart' software product by that offers some great software to bulk import thousands of products from any wholesaler via CSV files.

    From their website:
    The universal product importer allows to import any CSV file without worrying about modifying the Magento Database. It’s universal format allows you to import product data from any whole seller. It's powerful re-use capabilities allows users to use the software over and over again on a wide range of data feeds.

    The converted data (MS XML format) can be uploaded automatically once the conversion is completed. It's user-friendly usage allows anybody to use it. The universal product has been tested on a wide variety of shops.

    It’s a perfect solution to automatic update product data and add the data into your Magento based shop. "

    You should check it out if you want to do large conversions of products. It handles all kinds of problems with the CSV columns of wholesalers very well and also has options to add a markup price…

  9. i have about 5500 of products , when i try from import/export profiles i get Memory error , i increase memory limit & execution time i.e. 384 mb & 18000 then also i am getting memory error,
    Reply asap

  10. Thing is though – are all the required fields that appear in the exported CSV in order to successfully re-import. I am somewhat sceptical having tried this, though will try again!

  11. i just reviewed the "recommend" extension from magdeveloper but after further review the extension is actually kind of a hack. Im not sure why the developer would take the time to make a "conversion" program when magento support "product mappings" already and why not just use magento to handle this on the fly instead of creating a second step? makes no sense. Also the documentation is lacking and there is no mention of all the additional needed options like tier pricing and custom options / configurable products etc. If you are looking for a true product import/export extension and don't want to waste time you can get it for 1/2 the price of the one above and it does 5x more.

  12. Hello
    I found this nice software that allows you to edit your imported and exported files in a nice program. This guy is writting it him self and sharing it. It seems promising and hes adding things like image auto resize, auto upload and all sorts.
    I use this program sometimes when im sick of looking at excell. its not perfect but it does help sometimes

  13. Hi, I have problem exporting.
    This is the message I got:

    Notice: Undefined index: 0 in /app/code/core/Mage/Catalog/Model/Entity/Product/Attribute/Design/Options/Container.php on line 60

    and var/export folder is also not built.

    Pls help.

  14. Those who can't find the file location it's probably because you have not yet exported the products.

    Once on "profile wizard" choose the settings you want then "save profile". After that, you must go to the "Run Profile" tab on the left side and click on "Run Profile in Popup". After doing this you should be able to see the path var/export on your server.

  15. Hi everybody,

    I need Help!

    how i do this? i need export all the products in stock and I need the following information

    I’d like to export the whole name of the category, not just the numbers of them


    How i do that export?


  16. his is working on Magento 1.5 too. Just you need to add a column in csv 'has_options' & set the value to '1' for the products which are having custom options.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: