A few years back I used to do a lot of work with Magento e-commerce based websites. You’ll find a few posts in the archives about wrestling Magento to do certain things. Recently I have been working with Magento again (v188.8.131.52) and one thing that is still incredibly limiting in Magento is the import facility. If you’ve ever had to try and import products through the Magento Dataflow profiles you’ll know what a world of pain it is:
- No ability to import multiple images (for gallery images and the like)
- No ability to import categories
- No ability to import cross/up-sells and related items
- No ability to include tiered pricing (dependent upon customer group)
- Plus it runs like a sack of loose shit…
When making a test CSV for Magmi import, just make sure you have the ability to enclose all values in double quotes. Excel can’t save to CSV doing this (surprise surprise) but OpenOffice can. From the menu go File, Save As, select ‘Edit filter settings’ and click Save. Then choose ‘Keep Current Format’ and ensure ‘Quote all text cells’ is selected.
"store","attribute_set","type","sku","pack_size","name","short_description","description","dimensions","qty","price","special_price","tier_price:B2B","categories","image","small_image","thumbnail","image_label","small_image_label","thumbnail_label","media_gallery","weight","tax_class_id","meta_title","meta_description","Colour:drop_down:1","news_from_date","news_to_date","special_from_date","special_to_date"You’ll notice there’s a few things in there you can’t easily do with Magento, namely gallery images and product options. A breeze with Magmi! Another killer feature is you can specify the categories you want a product to live in like this in your CSV:
"My category/sub category;Another cat/another sub category"Not only will that put the product in those two categories, if they don’t already exist, it will make them on import! The best bit? It’s lightning fast! If you are used to watching Magento trundle through product imports a line at a time you will be in for a pleasant surprise. Magmi does it in seconds. In case you hadn’t already gathered, I’m a bit of a fan. If you do any sort of product importing for Magento, do yourself a favour and get acquainted with Magmi. It will make your life a lot easier!