How to: Magento Product Import

Posted on: August 21st, 2009 by Ben 10 Comments

Applies to 1.3.2.3

I have recently been importing a customers products into Magento with varying success. Hopefully this post will point you in the right direction to avoid many of the pitfalls I have discovered.

I have found that the best way to import your products into Magento is to manually create a single product in each category, export the csv file of products, edit the CSV for the new products and then import again.

Export

  1. From the Admin Panel. ‘System’ -> ‘Import / Export’ -> ‘Profiles’.
  2. Select ‘Export All Products’
  3. Click ‘Run Profile’ from the left hand navigation
  4. Click the button ‘Run Profile in Pop Up’
  5. Download the export from your ‘varexport’ directory.

Import

  1. After editing and inserting your products, save the file as something like ‘Import Products.csv
  2. From the Admin Panel. ‘System’ -> ‘Import / Export’ -> ‘Profiles’.
  3. Click ‘Import All Products’
  4. Click ‘Upload File’ from the left hand navigation
  5. Click ‘Browse’, select the file and then click ‘Save and Continue Edit’
  6. Select ‘Run Profile’ from the left hand navigation and select the uploaded csv file from the select box. It will have been renamed.
  7. Click the button ‘Run Profile in Pop Up’
  8. Take note of any products that are skipped.

Notes

  • If you have recently upgraded Magento, some of the field titles and values may have changed. For example, make sure the ‘store’, ‘website’ and ‘type’ fields are lower case.
  • Some fields are mandatory like ‘SKU’ and ‘weight’
  • ‘tax_class_id’ and ‘visability’ fields are now uppercase
  • Regarding images, even if you have the same image for the main image, small image and thumbnail, Magento appears to need different values in here. e.g. productimage1.jpg, productimage1-sm.jpg and productimage1-th.jpg

Hopefully this will clear up some of the issues with importing large quatities of products into Magento.

I am happy to offer this import service if requried on your install of Magento. Please contact me for a quote.

10 thoughts on “How to: Magento Product Import

  1. It really helped me out!

    Thanks

  2. What I like about your approach is that it is logical and simple. I’ve been trying to think how to go about this for a rather complicated import (lots of new fields and cross references). I was thinking of Talend and web services…why do I always start with the most complicated approach ;)

    Thanks

    • OMIP, yes I know the feeling. It took a lot of trial and error before I got the import working efficiently. Glad it helped.

  3. Great article on Magento import data. Thank you for sharing it with us.

  4. I’m new to Magento and I’m sure this is a stupid question but where do I find the var/export directory?

    • Hello there will. i have just come across the same problem. cannot find where the exported file has been saved after i have exported all the products.

      Can you let me know if you managed to sort this and how?
      thanks

  5. hi, great post!, just one querstion?, what if i want to import products with images?

    • Hi,
      first as for the images, the trick is to upload them via ftp to your media/import folder and add them in the corresponding column in your csv in the following format: “/yourimage.jpg” It should work this way.
      As for the whole import to Magento, I can advise File2Cart: http://www.file2cart.com/supported-carts/55-magento It does import of products, categories and images and maybe some other data. I use it for bulk imports as it speeds up all the process immensely.
      Thanks for a great post!

  6. I’m using store manager for magento to import products – very sophisticated application, allows to import products from custom .csv files. It’s not free though but works for me well.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>