Advanced Search

— Forum Scope —




— Match —





— Forum Options —





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

mail_open
Beginner Question - Magmi CSV upload error.
Anton van Maanen

Not so New
March 13, 2015 - 4:44 am
Member Since: March 13, 2015
Forum Posts: 5
sp_UserOfflineSmall Offline

Hey there,

I am new to Magmi and have been growing my knowledge thanks to UE. I have reached a point where I am ready to upload a test .csv file. I have used the generic UE template and inserted my own product information into the cells.

When I upload my csv through Magmi I am getting the following error:

plugin;Magmi_CSVDataSource;warning:CSV Datasource v1.3 – warning: line 1 , wrong column number : 74 found over 72, line skipped

And no successful Skus were added. (there is only one is the document).
Not sure where I am going wrong but I am sure it’s simple.
Any help would be greatly appreciated.

Screenshot + csv file attached.

Best,

Anton

Chris Brown

Excellent
March 13, 2015 - 8:32 am
Member Since: August 27, 2014
Forum Posts: 19
sp_UserOfflineSmall Offline

Hi Anton,

The csv import facility can be as simple or as complex as you like and the UE template is great for seeing the possibilities. Without being able to currently see your csv and screenshot there may be a few things just to check.

Firstly your import settings, if you are adding a new product make sure you have the import setting to one of the selections which allows you to INSERT a new record.

Secondly, it may be worth a bit of expirementation just so you can better understand how the whole import thing works and you can use it the best way you for you. When you add a product manually (through the magento product screen) you will have certain fields which you need to be populated such as sku, website title and price. I would (for a first attempt) try a csv with the minimal information required to create your product, it does not matter if it is 2, 3, 5 or 10 columns as long as sku is the first one. Think of it a bit like this, the fewer columns of info you have then there is less chance of it failing whilst you are still working it out.

If you can get the import to run successfully then go back to the product record, take a look at what attributes are missing then create a new csv that will UPDATE existing records, again with the sku as the first column and then the other columns will be the missing attributes. Again just do a few (columns) at a time until you are comfortable.

If needs be then create a new bigger template as you go and try adding more products a few at a time so you can see where things are working and where they are not.

The only onther thing you need to be sure of is that the column headers match the attribute names in Magento. You will soon be ready to confidently import thousands of records with masses of information.

Hope this helps.

Chris.

Anton van Maanen

Not so New
March 16, 2015 - 5:03 am
Member Since: March 13, 2015
Forum Posts: 5
sp_UserOfflineSmall Offline

Thanks Chris.

Finally had success. Patience and baby steps is the lesson I have learnt.

Best,

Anton

 

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:
35 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: 5221

Posts: 27485

Administrators: Matthew Ogborne: 4565, Dave Furness: 4606