OK, so I also faced athe same issue. It’s a bit disappointing that we see more of the same questions than answers. It would be good for the community if the people who already solved issues with Magento post the solutions for others to view.
It seems that you have to try to create a product first and take note of the required fields.
At first, I created 4 fields: name, short description, price, and sku and it gives the error:
Skip import row, is not valid value "" for field "type"
Heck, what does that even mean?! So I tried to see if there is a field “type” in the mapping, and it’s there so I added it. The error now changed to
Skip import row, is not valid value "" for field "attribute_set"
Ok, now I’m sure that I just need to add the missing required fields in the mapping and the CSV. I ended up with the following:
To see the valid values for the fields you’re not sure of, make sure you installed Magento with the sample data, and run the profile “Export All Products.” Examine the output csv for patterns for the appropriate field.
Also take notice of the note in the profile section Profile Wizard / Data Format / Original Magento attribute names in first row:
(When ‘No’, only mapped fields will be imported. When mapping, use ‘column1’, ‘column2’, etc.)
So I mapped name to column1, short_description to column2, ..., visibility to column12.
Here’s my sample csv
"test","test upload","1","TEST","admin","simple","Default","Some Description","1","Enabled","Taxable Goods","Catalog, Search"
That’s it. It should work.