Solved

how to import xls file, which contain product data into the  magento

Posted on 2008-10-27
4
2,390 Views
Last Modified: 2012-05-05
right now i m working on magento,how to import xls file in to magento
0
Comment
Question by:prasalogin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 1

Accepted Solution

by:
Rane2_0 earned 250 total points
ID: 22819440
as far as I'm aware you cant, Magento Supports CSV and XML formats for Importing, so try exporting your excel data to one of these formats then importing
0
 
LVL 29

Assisted Solution

by:fibo
fibo earned 250 total points
ID: 22819631
Action list:
1 - Use magento to have a format of a data file.
From the admin panel, "System" / "Import/export" / "Profiles"  / "Export products".
This will give you a csv file with columns titles in the first line.

2 - Open this csv file in Excel, open your own product file in excel.
Make a copy of your product file under another name. Change columns so that they match those of the Magento-generated one: the point here is not to have columns in the same order, but to have exactly these columns.
Once you file is ready, save it as xls AND as a csv.

3 - You can now import into Magento
From the admin panel, "System" / "Import/export" / "Profiles"  / "Import products".
Give your filename. And go!
IMPORTANT: you will be asked how many products to import at the same time. For your initial test with few records, this does not matter really.... but for real life applications select to import records with a bucket of 100 or 200.
WHY: a value of 1 will take a long time to import; a value of 1000 would need lots of memory and will probably crash your system; a value of 100 to 200 is a good initial bet.
[If you are doing just a one-shot, this is probably the best bet. If you plan to do it on a regular basis, you will need some tuning to get the best performance]

4 - The initial import of products may not provide the expected categories. Anticipate to spend some time on mass assignation to categories ( "Catalog" / "Manage Categories" then select your existing category; then "category products" tab, select "all" value in the leftmost column, place some name value in the "name column", "Search",
then select all the products you want to include in this category).
5 - The forums and wiki of Magento will give you more detailed ideas when you will want to improve this import.
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Using Quotation Marks in PHP This question (http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/Q_28217211.html) seems to come up a lot for developers who are new to PHP.  And it got me thinking, "How can we explain the rule…
Developer tools in browsers have been around for a while, yet they are still heavily underused by developers. Developers still fix html or CSS then refresh page to see effect, or they put alert or debugger in JavaScript and then try again and again …
This video teaches viewers how to create their own website using cPanel and Wordpress. Tutorial walks users through how to set up their own domain name from tools like Domain Registrar, Hosting Account, and Wordpress. More specifically, the order in…
Learn how to set-up PayPal payment integration in your Wufoo form. Allow your users to remit payment through PayPal upon completion of your online form. This is helpful for collecting membership payments, customer payments, donations, and more.

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question