Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2008-10-27
4
Medium Priority
?
2,399 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
4 Comments
 
LVL 1

Accepted Solution

by:
Rane2_0 earned 1000 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 1000 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction ( All good things must come to an end ) The original MySQL API has gone away.  It was deprecated (years ago) by PHP in Version 5.5, and removed from PHP in all current releases .  As a result, the issue is upon us today.  It's time to …
While opting for any web-to-print solution, you need to discuss with your team and some of your end users and know their opinions about your decisions. In this article we list down some questions you need to ask yourself.
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…
This video teaches users how to migrate an existing Wordpress website to a new domain.
Suggested Courses

927 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