Advanced Search

— Forum Scope —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters

Help with import please
January 5, 2015 - 12:57 pm
Member Since: March 23, 2014
Forum Posts: 227
sp_UserOfflineSmall Offline


I have a product CSV to import via Magmi with over 2000 products. Three questions:

1. Can I have blank cells, will that affect the import?
2. I am using OpenOffice rather than excel, how should I save the spread sheet correctly for Magmi?
3. I have simple and configurable products to import, can they be mixed up even if the configurable products are under the correct simple products?

Thanks for any advice.

Stephen Maguire
Atlanta, GA USA
January 5, 2015 - 10:05 pm
Member Since: May 20, 2014
Forum Posts: 184
sp_UserOfflineSmall Offline

1. Blank cells should not be an issue, as long as a value is not mandatory.
2. Open office should not be a problem, just save as a csv.
3. You can mix simple and configurable products in the same spreadsheet, but the configurable product must be listed after all the simple products that pertain to the configurable product. Don’t forget to associate all the simple products to the configurable product and define your config_attributes (size, color, etc).



Dave Furness

January 6, 2015 - 9:39 am
Member Since: July 19, 2013
Forum Posts: 4606
sp_UserOfflineSmall Offline

^ I couldn’t have said it better myself! Thanks Steve


Every expert was once a beginner


Why Should You Join UnderstandingE?

  • Access to over 500 step-by-step video tutorials
  • +20 video courses available
  • Magento, M2E Pro, Magmi, eBay, Amazon & Design all covered
  • Everything is in 100% Plain English
  • Learn how to build your own multi-channel software for eBay & Amazon
  • Access to the community forums, meet fellow business owners like yourself

Join Now with 2 Clicks


Join now for less that £1 per day you can gain access to over 400 step-by-step video tutorials & learn how to build your very own multi-channel software.


Forum Timezone: Europe/London

Most Users Ever Online: 1012

Currently Online:
20 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Jim @ Moogento: 688

Steve Froggatt: 514

Badeth - UE: 513

Jimbob: 453

Paul Cartwright: 414

Forum Stats:

Groups: 6

Forums: 37

Topics: 5223

Posts: 27502

Administrators: Matthew Ogborne: 4565, Dave Furness: 4606