I was having similar problem when I tried to import products on my site. I then (after a lot of frustration) used Open Office instead of excel and it worked for me.
I used open office on one of my subsequent attempts too, but the same errors resulted. It was originally an excel file, but I saved it under another name using open office and nothing. Not sure what to do here.
Iám having the same issues here. Did anyone got it working? Iam using openoffice and export it to a csv file. When running I got the following error: # Skip import row, is not valid value “29521” for field “type”. I things it looks into a different field but, I have checked the csv file and the field mapping and there it is good. Hope someone found a solution.
I’ve had the same problem in the past and it seemed to come from the number of column mapped and the actual number of column in the csv file. Plus I think the columns order needs to be the same in the mapping and csv file.
Has anybody had any success with this, I’ve been trying all day and no joy. I can export and import the 3 test products I put on the site without a problem, but as soon as you add a 4th you get the error Skip import row, is not valid value “” for field “type” ?
Tried with Open Office and Excel and even in Notepad and always the same error for the extra product that is added, all the 3 existing test products re-import with out an error?
I am using Open Office to modify my csv file and it did a lot of work but i am stuck with this ittle problem here.
all the values in text are good but the all the numerical columns are not as they should be. they are not wrapped around like this “number”
- Skip import row, required field “sku” not defined -
As far as I experienced, the fact that OpenOffice works better for importing than Excel is due only to Excel reformatting values automatically. It’s the good old Microsoft habit to secretly do something we didn’t ask for.
If you use Excel to edit CSV files watch out
- to tell Excel to read the value separator right (comma, or semicolon...) and the value limiter (")
- that Excel doesn’t auto-format dates (4.2 becomes Apr 02 or whatever)
- for decimal and thousand separators (dot, comma - some areas of the world use different)
- cell format for numbers/text
The error comes because to import something you must have all the required fields,
the field what you see have red dots when you enter by hand.
what i recomand: export with a predefined profile one article, see the structure and put all the data in the same way
use an excell editor to fill where you do not have data like in the exported article.
Ok - it took me a while to work my issue out. I used CSV from Excel - I think the issue was to do with the UTF-8 stuff. I think Open Office handles it differently.
Basically, I had the same issue getting the # Skip import row, is not valid field “price” or something
You need to make sure there is actually a heading called price. I did, but somehow there where some random spaces on either side of the word that Excel put in. I deleted the spaces and it seems to work.
Solution: most of the time I used copy, sometime you have a space.
and there is a difference between “description” and “description” check this first in the skipping colom
use open office
it is possible by options, languages to set , tot . als decimal sign
save as cvs utf-8 or as xlm file