Solved

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

Posted on 2008-10-27
4
2,383 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 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Suggested Solutions

Title # Comments Views Activity
Trouble with decrypting PGP encrypted file using PHP & GnuPG 4 494
Collecting Customer Data 5 38
Web Application Running Slow 8 62
Web Config File 3 100
A Change in PHP Behavior with Session Write Short Circuit (http://php.net/manual/en/book.session.php#116217) (Winter 2014)** With the release of PHP 5.6 the session handler changed in a way that many think should be considered a bug.  See the note …
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…
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to choose which pages of your form are visible to your users based on their inputs. The page rules feature provides you with an opportunity to create if:then statements for y…
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.

856 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