Magento: How to use the Import/Export Tool
12 Oct 2008
Posted by Jake Rutter as Magento, Magento Tutorials, Open Source
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.
Category Magento, Magento Tutorials, Open Source
You can follow any responses to this entry through the RSS 2.0 feed.
Darrell
October 21st, 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 4th, 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 6th, 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 16th, 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 17th, 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 ~~/,
chandresh
July 28th, 2009 at 11:03 am
how to export my categories ?
please any help me.
Magento
August 26th, 2009 at 11:49 am
Mhh where I can find the export files after a export?!
Logan
October 2nd, 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?
Archana
October 6th, 2009 at 5:09 am
After export, export files will be saved in varexport folder of magento source code.
tim
October 11th, 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 13th, 2009 at 1:23 am
yoursite.com/public_html/var/export
shaun b
October 13th, 2009 at 8:18 am
Anyone know what to modify the XML of the Export to to just export Caategories?
Lisa
November 17th, 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
MohammedAlaa
November 23rd, 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 26th, 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…
Zoey
November 26th, 2009 at 8:20 am
But where I can find the varexport folder ?? thank you….:-)
James
January 7th, 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…
dtx
February 5th, 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
yana
March 23rd, 2010 at 1:03 am
I have trouble exporting the products from magento into an excel file. any suggestions?
Vishal
April 15th, 2010 at 5: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
Mercool McCaber
April 20th, 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 21st, 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…
James
May 11th, 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 7th, 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 10th, 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
Garth
October 8th, 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.
cochineal
November 5th, 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 21st, 2010 at 1:22 am
"Hey guys, there is export in Magento and it is cool" Why did you even bother? -_-
sjolzy
January 3rd, 2011 at 9:14 am
i can not keep the mapping of categories and products
Magentovenaar.nl
May 11th, 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…
Simon Schick
July 19th, 2011 at 6:35 am
You're absolutly right!
dezire
August 12th, 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!