Not so New
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.
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.
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.
Most Users Ever Online: 1012
Currently Browsing this Page:
Jim @ Moogento: 688
Steve Froggatt: 514
Badeth - UE: 513
Paul Cartwright: 414
Administrators: Matthew Ogborne: 4565, Dave Furness: 4606