piThis post is part of a series by the a href="http://www.magentocommerce.com/product/enterprise-edition" title="Magento Enterprise Edition"Magento Enterprise Edition/a subscription support team covering tips, tricks and hints to some of the most common, and uncommon, issues as submitted by support customers./i
/p
p
+++++++
/p
p
Although it is fairly simple to do, many Magento users offer encounter difficulties when attempting to use the import functionality built in to Magento.nbsp; We see a fair number of inquiries about this here at the Magento Enterprise Support Desk, so we#8217;ve decided to write a little tutorial to help you better understand and use Magento?s bImport Profile/b.
/p
p
First, let#8217;s take a look at how to create an import file, which will include all the data we want to bring into Magento.nbsp; To get the correct fields and values, we recommend exporting a product, i.e. a simple product or configurable product, through the Admin.nbsp; This is done through bi?System - Import/Export - Profiles?/b/i.nbsp;
/p
p
In the out-of-the-box Magento configuration, there are a couple of default #8220;Export profiles#8221; that you may use depending on which data you would like to export.nbsp; This depends on the data which you wish to export, and there are options for customers, products, stock, etc.nbsp; Running the profile will open a new window or tab which will show the progress of the export profile, as you can see in the example below:
/p
p
img src="http://www.magentocommerce.com/images/uploads/export.png" style="border: 0;" alt="image" width="505" height="309" /
/p
p
The export file is saved in the bi/var/export/b/i folder in your running Magento instance.nbsp; The screenshot below shows a sample of the export file created when running the ?Export All Products? profile, filtering only the simple products:
/p
p
a href="http://www.magentocommerce.com/images/uploads/export_file.png"img src="http://www.magentocommerce.com/images/uploads/export_file.png" style="border: 0;" alt="image" width="600" height="82" //a
br /
ih7Click image for full-size/h7/i
/p
p
Now that you have a template to work with, edit the file and add the relevant information which you would like to import.
/p
p
We now come to the most important part of the process which is often missed when saving the import file and causes many of the issues which are referred to us.
/p
p
It is very important to note that bthe import file must be in UTF-8 encoding/b to ensure that the file can be read and processed by Magento. Microsoft Excel, OpenOffice Calc, Apple Numbers and GNU Iconv, amongst many other applications have the capabilities of encoding a file in this format.
/p
p
In addition to that, the bPHP memory limit/b must be set with a value that meets the Magento System Requirements.
/p
p
Once you have completed updating the file and checked that the memory limit has met the system requirements, you may now run the import profile in the Admin back office under bi?System - Import/Export - Profiles?/b/i.
/p
p
In this tutorial, we are going to use ?Import All Products?.nbsp; First, we must upload the file and click ?Save and Continue Editing? so that the file will be uploaded into folder b/var/import/b in the server.nbsp; After saving, select the uploaded file from the dropdown list and run the profile as we see below:
/p
p
a href="http://www.magentocommerce.com/images/uploads/importfile.png"img src="http://www.magentocommerce.com/images/uploads/importfile.png" style="border: 0;" alt="image" width="600" height="210" //a
br /
ih7Click image for full-size/h7/i
/p
p
The screenshot below shows that we have successfully imported our data into Magento:
/p
p
img src="http://www.magentocommerce.com/images/uploads/import.png" style="border: 0;" alt="image" width="494" height="282" /
/pbr /hr style="border:none; background:#bbb; height:1px; overflow:hidden;"/table cellpadding="0" cellspacing="0" border="0"trtd valign="top" width="90" align="left"a href="http://twitter.com/magento"img src="http://www.magentocommerce.com/img/magento_on_twitter.png" //a/tdtd valign="top" width="220" style="padding:0;"strongfont size="-2"FROM THE MAGENTO TWITTER FEED/font/strong/spanpa href="http://twitter.com/magento/statuses/11464520325"RT @amitrshah: Magento Enterprise customer profiled in Wall Street Journal: http://www.toms.com//a/ppa href="http://twitter.com/magento"strongfont size="-2"Follow Magento on Twitter ?/font/strong/a/p/tdtdimg src="http://www.magentocommerce.com/img/clear.gif" width="10px" /img src="http://www.magentocommerce.com/img/feed_separator.png" //tdtd valign="top" width="90" align="left"a href="http://www.magentocommerce.com/support/magento-user-guide-book"img src="http://www.magentocommerce.com/img/magento_ebook.png" //a/tdtd valign="top" width="220" style="padding:0;"strongfont size="-2"NOW AVAILABLE/font/strongpa href="http://www.magentocommerce.com/support/magento-user-guide-book"The Official Magento User Guide by Varien is here!/a/ppa href="http://www.magentocommerce.com/support/magento-user-guide-book"strongfont size="-2"Get your eBook today ?/font/strong/a/p/td/tr/tablediv class="feedflare"
a href="http://feeds.feedburner.com/~ff/magento?a=DXk9ME-kHtw:kl5ufwrgSpk:yIl2AUoC8zA"img src="http://feeds.feedburner.com/~ff/magento?d=yIl2AUoC8zA" border="0"/img/a a href="http://feeds.feedburner.com/~ff/magento?a=DXk9ME-kHtw:kl5ufwrgSpk:7Q72WNTAKBA"img src="http://feeds.feedburner.com/~ff/magento?d=7Q72WNTAKBA" border="0"/img/a a href="http://feeds.feedburner.com/~ff/magento?a=DXk9ME-kHtw:kl5ufwrgSpk:V_sGLiPBpWU"img src="http://feeds.feedburner.com/~ff/magento?i=DXk9ME-kHtw:kl5ufwrgSpk:V_sGLiPBpWU" border="0"/img/a
/divimg src="http://feeds.feedburner.com/~r/magento/~4/DXk9ME-kHtw" height="1" width="1"/
Read more: http://feedproxy.google.com/~r/magento/~3/DXk9ME-kHtw/
