Magento product import: 4 excellent solutions that definitely work

One of the greatest advantages of Magento is that shoppers can search for nearly an endless number of parameters and terms and browse among the products. This makes shopping easier and also increases the chance of conversion because it is more likely that they will find the most desired product, even out of thousands of options. To be able to accomplish this, obviously, you need to fill up your store with products. No one stops by an empty shop window. Simple as that. Luckily, a number of different solutions are available for such a project.

 

The basics: via the Magento admin panel

The most trivial and simple way is to import the products manually into the Catalog. In the admin panel, under Catalog, you can find the Add Product button on the Manage Products page. With Magento’s CMS (Content Management System) you can easily and quickly modify the product database.

You can assign different parameters to the products so that customers not only can search the products with better results, but can also activate intelligent filters. Additionally, thanks to the parameters, you can also set up different user groups that will see specific offers. This all makes your life easier while managing your online store, however, throughout the database building process, you will need a more effective way.

 

1. Simple importing in Magento

It is a basic function of Magento with which, after only a few clicks, you can import your products from a .csv file. This method is quite simple after you have got the hang of it, like where to find the items and what sequence you should follow during the process. It offers a rather limited number of possibilities though.

 

Default Magento Product Importer

 

If the file contains parameters that are not set included in the system (because you have not yet created the specific attributes), then importing will fail and the process will get stuck during the data check. Thus such a process is needed where the attributes contained in the .csv file are identical to the ones that the system holds.

This can be done on this page: System -> Import/Export -> Import. Since you can also upload customer data here, you need to select whether you want to do this or upload product data instead. You also need to choose from the following:

  • add new data of the .csv file to the existing database,
  • change the existing database to the imported one,
  • or delete the items from the database that are present in the import file.

 

2. Bulk import with some extra steps

Of course, Magento’s admin panel provides the option to import more products at a time. Let’s see how bulk product import works that contains product attributes set beforehand.

 

Magento bulk product import

 

First you need to create a category in the admin panel. This can be done in Catalog -> Manage Categories. Create all the categories you need at the moment, then, after filling out the required information panels, save them.

It is recommended to save the IDs of the newly created categories in a text file. The ID is shown by the system when you save the newly created category. Here it is also worth giving or creating those attributes that you want to use later on.

It is understandable that the Magento system cannot comprise all the things you may need, but it certainly provides the features to be able to add whatever you want. So you can add the attributes in Catalog -> Attributes -> Manage Attributes. Having this done, the “sample product” is created, which can be used as a “template” for the rest of the product imports. After saving it, it appears in the product list.

The next step seems a little more complicated, but in fact it is a simple process as well. The goal is to have access to the parameters of the sample product on your own computer so that you can modify the parameters in a simple way and then reload them up to the store. This can be done the following way: Go to System -> Import/Export -> Dataflow – Profiles and select the Export All Products option.

You need to define the online store where you wish to import the products under Profile Information (logically, this store must be the same where the sample product was created). Under the Data Transfer drop down menu select Local/Remote Server and make sure that CSV is selected with the format.

Next, save the profile and then export all the products again and click the button Run Profile in Popup. Thus you will get a file “export_all_products.csv” (whose name you can change if you wish), which is saved in Magento’s installation directory. You can download this file to your computer with the help of an FTP client, containing the columns with the previously defined attributes. If you open the file in a spreadsheet program (e.g. Microsoft Excel), you can easily fill out the fields and thus you can add the products you want to import. You need to add the category IDs here as well, make sure you place the proper products in the correct categories.

Finished? Now go to System -> Import/Export -> Dataflow – Profiles -> Import All Products and select Upload File and then choose the modified .csv file. After the upload, go to Import All Products again and select Run Profile in Popup and then click the uploaded file in the dropdown menu. Now all you have to do is check the product list to see if the upload has been successful.

 

3. Using Magento Mass Importer, aka Magmi

If you want to have a clear and easy-to-use solution with several other options, the free Magmi application may be the answer.  This is basically an external user platform which offers you a number of import/export functions that are originally not included in the Magento system.

 

Magmi import for Magento

 

Based on our experience, it is simpler to import products with the use of Magmi, however, you will still need to create the necessary .csv files. So the database needs to be created by you, but with Magmi it can be easier to upload it to your system. The only initial drawback may be that you have to learn how to use a new admin area, but before you start worrying, it is not such a big deal.

There is a lot of documentation which guides you through the process step by step, even a dedicated Wiki page has been set up to help users get every bit of information they need. Its huge advantage is that such tasks as mass import of images or automatic category creation with the importing process can be accomplished.

 

4. Paid Magento extensions

The “capabilities” of Magento can be broadened by buying and adding special extensions to it. Most users employ the Magmi application because it has a great variety of functions and can be downloaded for free. But if you need a special feature, you can find extensions fulfilling your requirements.

 

Magento Store Manager

 

It is good to know that such extensions cost approx. USD50-100 per extension, so if you want to have some custom extensions to maximize efficiency, obviously, you will need to spend a certain amount of money and it is wise to allocate a portion of your budget to such developments for the future.

 

tips Useful Tips:

 

Appropriate Software

As you could see above, in the case of Magento, one of the major challenges is to make the basic templates that you can later use for importing the products. If you do not pay special attention to this process, problems with compatibility may arise even because of some minor missing attributes. Therefore the template should be created within the online store itself and thus the system will be able to read it afterwards. This file needs to be exported to your computer and edited in such a way that it contains the detailed information of every product you want to offer.

To Magento, however, it is very important what kind of program you use to manage the .csv files. We have seen that Excel is not suitable to handle such tasks flawlessly, so we recommend using other software. You can find the free-to-download Calc program in the Libre Office software package, which is easy to use for Excel users and has all the functions you need for your files.

Special Characters

When saving CSV files, use UTF-8 formatting. It is probably the safest way to avoid any problems in the future, but it is still not a 100% problem-free solution. You have to be careful with special characters, for example. If a product attribute contains special characters that the given format is incompatible with, it may cause difficulties when importing.

The error usually manifests in the way that the product field is left empty. If you really need to use special characters, e.g. line breaks or commas, place the content of the field between quotation marks (see examples below where we describe attributes), thus it will likely appear properly. This mainly applies to product descriptions, with the rest of the attributes it is better not to use special characters at all.

Put the images you would like to import in the /media/import directory

The system needs to process every single image during importing. Upload the raw images to the /media/import directory before importing the product database. It is also crucial how you set the names of the images. In order to avoid unpleasant surprises, make sure to set the same names and extensions as the table includes.

Do not change the columns of the table

The essence of the process mentioned above is to use the same attributes that the engine of your ecommerce store can recognize and handle. If you change these even just a little while editing the file, it may cause unforeseen errors. Most likely the import process will fail.

The columns (/attributes) that you must set

We have already described thoroughly what compatibility problems you may encounter if you upload your products in an inappropriate format. Now let us see which columns or attributes you definitely need to include in your source .csv file.

  • websites – the website entity which has a “base” value by default.
  • store – the online store assigned to the product, has an “admin” value by default.
  • type – the type of the product.
  • attribute_set – default, or another group of attributes, you can check this in the admin panel on the following page: Catalog -> Attributes -> Manage Attributes
  • tax_class_id – the tax type assigned to the product, you can find its features in the admin panel at Sales -> Tax
  • status – the status of the product, its value can either be “Enabled” or “Disabled”.
  • weight – the weight of the product; if you do not need it, simply type 1 here.
  • sku – the unique identifier of the product.
  • name – the name of the product.
  • price – the price of the product.
  • description – the detailed description of the product, which will appear on the product page.
  • short_description – the short description of the product, it can appear in different places (e.g. on search result pages) depending on the settings.
  • visibility – the visibility of the product, it may have values such as “Not Visible Individually”, “Catalog, Search”, “Catalog” and “Search”.
  • category_ids – category identifiers (ID); we have already mentioned it.
  • qty – the quantity of the product.
  • is_in_stock – the inventory value assigned to the product, where 1 means that the product is in stock and 0 that it is not. Those products that are not in stock are not shown on the main page of the online store and cannot be purchased either.
  • image, small_image, thumbnail – here we can define the paths and file names of the images assigned to the products. You need to know that the system makes a difference to letter case, i.e. small and capital letters. You should avoid using spaces all together. You can use the same larger image file for displaying the three different  image types (image, small_image, thumbnail), the system will automatically resize it.

 

Potential errors

Magento import errors

“Image does not exist”

You may see this message if you have given the names of the image files in the .csv file inappropriately. You should check the names again carefully not to have any problematic characters in them.

Products fail to appear

The imported products do not appear on the main page if you do not properly define certain attributes. Properties that are needed for making images appear:

  • websites = base
  • store = admin
  • status = Enabled
  • visibility = Catalog, Search
  • category_ids = # (it must be an existing category identifier!)
  • qty > 1
  • is_in_stock = 1

 

Summary

The basic functions of the Magento system give you the opportunity to create very useful properties such as products, attributes, product groups, and other entities. However, successful importing from pre-set databases may be a challenge when relying only on built-in options.

Thanks to the previously described methods and Magento’s flexible system, with the use of .csv files you can easily upload databases containing even tens of thousands of products in a way that the software can manage them without any problem. Consequently, you save a lot of time as you do not have to upload every single product or manually set every parameter. Just think of how much it would cost you to get such a lengthy work process done. Also, this means that there is a simpler way to successfully migrate databases to Magento from other systems.

Having said all these, if you still feel you need any further assistance, we are happy to offer you our Magento Project Rescue service which helps you solve basically any problem that you experience at the moment with your Magento ecommerce store.

 

 

>

63 replies
  1. Carl Tempel says:

    Hey, you used to write magnificent, but the last several posts have been kinda boring?K I miss your tremendous writings. Past few posts are just a little out of track! come on!

  2. Alcohol Rehabilitation Near Me says:

    Rehab Treatment Center http://aaa-rehab.com Drug Rehab Centers http://aaa-rehab.com Alcohol Rehabilitation Center
    http://aaa-rehab.com

  3. stock market close time today says:

    Having read this I thought it was very informative. I appreciate you taking the time and effort to put this article together. I once again find myself spending way to much time both reading and commenting. But so what, it was still worth it!

  4. fiat money definition says:

    This is the right blog for anyone who wants to find out about this topic. You realize so much its almost hard to argue with you (not that I actually would want…HaHa). You definitely put a new spin on a topic thats been written about for years. Great stuff, just great!

  5. Serviceyards says:

    We are working with TigerMin for many years now and we are very satisfied with this extension, because it makes product management in your Magento store way faster.

  6. blog says:

    Thanks for finally writing about >Magento product import:
    4 excellent solutions that definitely work – aionhills.com <Loved it!

  7. Ladyjorns.Com says:

    Are you familiar with product imports in Magento? What are the difficulties you faced? What would you like to have in a tool to help you make daily imports from CSV files?

  8. APKun says:

    The best place to start if you need help with a specific extension is to contact the developer. All Magento developers have both a contact email and a support email listed.

  9. APKun says:

    A little while back I had to automate product importing from external CSV source for a client of ours. We used Magmi to do so. Magmi is awesome and you can do so much with it. However, there was one thing I needed to write my own plugin for. In our case the clients catalog must only contain the products from the CSV source, which means that products imported at a certain date could possible be removed from the CSV in a later stage. But, using Magmi this products, that are no more existing in the CSV source, will still exist in my Magento store.

  10. Worries says:

    So, I made this real simple and tiny plugin (actually 2 plugins) with which you can delete or disable product from your Magento store when they do not exist anymore in the CSV source.

  11. Worries says:

    Hi Mike, the plugin itself does not re-enable products but you could very easily arrange that with Magmi. For example, using the default values setter plugin which comes with Magmi by default, you could add a default value for attribute status . So, on import you enable all products, and since our script runs at the end of the import it will disable products missing in CSV.

  12. Med Advice says:

    We already used different product export extensions, but this one is absolutely the best so far. Great quality, no problems and an outstanding support. If you search for an excellent product export extension, go for it. Absolutely worth the money!

  13. Daysis says:

    Excellent product. Works extremely well and saves us a lot of time every week managing our store. This is absolutely one of the most valuable extensions you can get that I know of. Homekeur Bouwtechnische keuring

  14. Daysis says:

    Top level service for an excellent module! If you need custom forms, MageMe has it covered. Will gladly use again. Aside from the fact that this extension works as advertised, the service is excellent. We definitely recommend using it.

  15. Lady says:

    Vladimir is amazing. When you have problems with a special solution he will instant help you and give you different solutions to help. Or even write the code for you – best support ever.

  16. baixar filmes cult says:

    Whats up very cool web site!! Guy .. Excellent .. Superb .. I’ll bookmark your site and take the feeds additionally?KI am glad to seek out so many useful info here in the publish, we need work out extra techniques on this regard, thank you for sharing. . . . . .

  17. erjilopterin says:

    Great ?V I should certainly pronounce, impressed with your website. I had no trouble navigating through all tabs and related info ended up being truly simple to do to access. I recently found what I hoped for before you know it at all. Reasonably unusual. Is likely to appreciate it for those who add forums or anything, site theme . a tones way for your client to communicate. Nice task..

  18. sanchore hospital says:

    hello!,I like your writing so so much! share we be in contact extra approximately your post on AOL? I need an expert on this space to resolve my problem. Maybe that is you! Having a look forward to see you.

  19. Solar Street Light says:

    Great paintings! That is the type of information that are meant to be shared across the net. Shame on Google for no longer positioning this put up higher! Come on over and seek advice from my web site . Thank you =)

  20. kilim cushion says:

    Useful information. Lucky me I found your web site by accident, and I am stunned why this coincidence did not happened in advance! I bookmarked it.

  21. LED Panel 120 x30 says:

    I not to mention my pals came going through the nice advice from the website and so unexpectedly got a horrible suspicion I had not thanked the blog owner for them. These ladies had been for that reason passionate to study them and now have in reality been having fun with them. Thanks for getting indeed helpful and for settling on this kind of tremendous information most people are really needing to be informed on. My very own sincere apologies for not expressing gratitude to you earlier.

  22. whiteboard advertisers says:

    Together with almost everything that appears to be developing within this subject material, your viewpoints are actually quite radical. Nonetheless, I am sorry, but I do not subscribe to your entire idea, all be it stimulating none the less. It looks to everyone that your comments are not totally validated and in actuality you are generally yourself not really wholly confident of your argument. In any case I did take pleasure in looking at it.

  23. web hosting services says:

    F*ckin¦ remarkable things here. I¦m very happy to look your article. Thank you a lot and i’m looking forward to touch you. Will you please drop me a e-mail?

  24. advertise ezyspot says:

    fantastic submit, very informative. I ponder why the opposite specialists of this sector do not understand this. You should continue your writing. I am confident, you’ve a huge readers’ base already!

  25. delivery churrasco says:

    I am glad for writing to let you be aware of what a notable discovery my friend’s girl had reading through your web site. She came to understand several things, not to mention what it’s like to possess an ideal helping character to have the mediocre ones quite simply understand some advanced subject areas. You really surpassed visitors’ desires. Thanks for delivering such precious, trusted, revealing and cool guidance on the topic to Mary.

  26. Joker388 Online says:

    Howdy! Would you mind if I share your blog with my facebook group? There’s a lot of folks that I think would really enjoy your content. Please let me know. Thank you

  27. Joker388 Gamming says:

    It?¦s actually a great and helpful piece of info. I am satisfied that you just shared this helpful info with us. Please keep us up to date like this. Thank you for sharing.

  28. nao chame sua mulher de obesa says:

    Very nice post. I just stumbled upon your weblog and wanted to say that I’ve truly enjoyed browsing your blog posts. In any case I will be subscribing to your rss feed and I hope you write again soon!

  29. kevin david book says:

    I’d have to examine with you here. Which is not one thing I usually do! I take pleasure in reading a post that may make folks think. Additionally, thanks for permitting me to comment!

  30. VivoSlot Gamming says:

    Hey! I know this is kind of off topic but I was wondering if you knew where I could get a captcha plugin for my comment form? I’m using the same blog platform as yours and I’m having difficulty finding one? Thanks a lot!

  31. job advertising site says:

    Just wish to say your article is as surprising. The clarity in your post is simply nice and i could assume you’re an expert on this subject. Well with your permission let me to grab your feed to keep up to date with forthcoming post. Thanks a million and please carry on the gratifying work.

  32. tours privados en Portugal y España says:

    I have been surfing online more than 3 hours lately, yet I never found any fascinating article like yours. It’s beautiful value sufficient for me. In my opinion, if all site owners and bloggers made excellent content material as you did, the internet might be a lot more helpful than ever before.

  33. Keneth Ehrke says:

    El mecanizado, en términos simples, utiliza el Control Numérico Computerizado para mover una herramienta de corte a lo largo de cinco ejes de manera simultánea. Desde el año 2013 AUF&ZU produce utilizando máquinas de HOLZ-HER. Brochadora : Máquina en la que el movimiento de corte lo realiza una herramienta brocha de múltiples filos progresivos que van arrancando material de la pieza con un movimiento lineal.

  34. Industry News says:

    As I website possessor I believe the content material here is rattling excellent , appreciate it for your hard work. You should keep it up forever! Best of luck.

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published.