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.

Categories: MagentoOpen Source

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

Darrell · October 21, 2008 at 3:50 pm

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.

Marvin Alvarez · November 4, 2008 at 7:49 am

Hey, that’s a great feature.

Does the import feature update and/or delete inventory?

Or it simply imports?

Brian · December 6, 2008 at 11:25 am

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?

Aleixs · July 16, 2009 at 11:42 pm

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

Molecule · July 17, 2009 at 8:48 pm

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 ~~/,

    Lisa · November 17, 2009 at 7:58 pm

    I need help importing customers. I created a .csv file but don't understand how this works. Could anyone walk me through this? THANKS!! Lisa

chandresh · July 28, 2009 at 11:03 am

how to export my categories ?

please any help me.

Magento · August 26, 2009 at 11:49 am

Mhh where I can find the export files after a export?!

    Archana · October 6, 2009 at 5:09 am

    After export, export files will be saved in varexport folder of magento source code.

      Zoey · November 26, 2009 at 8:20 am

      But where I can find the varexport folder ?? thank you….:-)

        dtx · February 5, 2010 at 8:25 am

        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

Logan · October 2, 2009 at 5:40 am

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?

tim · October 11, 2009 at 2:17 am

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.

David · October 13, 2009 at 1:23 am

yoursite.com/public_html/var/export

shaun b · October 13, 2009 at 8:18 am

Anyone know what to modify the XML of the Export to to just export Caategories?

MohammedAlaa · November 23, 2009 at 4:02 pm

it's a shame they don't have Import/Export Categories. is there anyone figured out how this can be done?

Zoey · November 26, 2009 at 8:19 am

Is there anyone can tell me where I can find the files I exported? yoursite.com/public_html/var/export, this seems do not work…

James · January 7, 2010 at 11:28 pm

Hi,

There is a 'smart' software product by http://www.magdeveloper.com 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…

yana · March 23, 2010 at 1:03 am

I have trouble exporting the products from magento into an excel file. any suggestions?

Vishal · April 15, 2010 at 12:37 am

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

    Upakarti · August 1, 2013 at 9:23 pm

    I am fine exporting thousand of product using Magmi, best free plugin/extension for Magento bulk import.

Mercool McCaber · April 20, 2010 at 1:15 pm

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!

Scott · April 21, 2010 at 6:08 am

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.
http://www.commerceextensions.com/magento-product

    Garth · October 8, 2010 at 7:45 am

    Hi,

    If you are looking for a well documented, stable and feature-rich import extension for Magento, you should try our Advanced Magento Product Import Extension.
    http://www.storefrontconsulting.com/software/mage

    It supports all of the options mentioned above and more, plus is very well documented and supported.

James · May 11, 2010 at 2:19 pm

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 http://magentobridge.myfreeforum.org/sutra7.php#7

chx · June 7, 2010 at 3:50 am

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.

Vinny · July 10, 2010 at 1:37 pm

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.
http://www.designincontrast.com

cochineal · November 5, 2010 at 3:41 pm

Very powerful and powerfully slow in 1.4.1.1

If it's flash and it's slow, it must be Magento!

Tomas Novoselić · December 21, 2010 at 1:22 am

"Hey guys, there is export in Magento and it is cool" Why did you even bother? -_-

sjolzy · January 3, 2011 at 9:14 am

i can not keep the mapping of categories and products

Magentovenaar.nl · May 11, 2011 at 11:48 am

We released the bèta version to import products into magento through webservices, please feel free to take a look at http://www.magento-importer.com. We are planning to release the release v 1.0 in the next weeks…

dezire · August 12, 2011 at 2:12 am

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

Name;Url;Sku;Manufacturer;Ean;categories

How i do that export?

Thanks!

John · April 27, 2012 at 1:58 am

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.

Phill · September 25, 2012 at 4:28 am

Does it import XLS?

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Posts

GruntJS

My First GruntJS Plugin: Bust My Cache

GruntJS is a JavaScript Task runner that has been around for about 2+ year, at least as far as I can remember. I started playing around with GruntJS which uses Node.js about a year ago, Read more…

HTML5

HTML5 Local Storage and Web Personalization

I have just finished doing some research on using HTML5 Local storage instead of Cookies for website personalization and have come to the conclusion that everyone should be using HTML5 local storage in place of Read more…

eCommerce

How to implement Bronto Email JavaScript Conversion tracking in Google Tag Manager

This tutorial will show you how to setup Bronto Advanced JavaScript Conversion tracking using Google Tag Manager. Bronto Advanced JavaScript tracking gives you more visibility to all of the products that customers are purchasing, then Read more…