Before Running an Import
Always take a quick check of the total products shown on the Manage Products landing screen before running an import. This is shown as: ‘Total xxx records found’
If your import should be working but is giving errors, check the items below. Check and check again and you will often find that you have made some silly mistake despite being certain your work is perfect.
CSV File Malformations
Sometimes EXCEL exported cvs files become badly formed because of unseen or non-obvious issues in the source XLS(x) sheet. Best practice is to always inspect your csv before upload.
Often you will find issues with extra rows which are often empty or worse extra columns. Best option is to remove these with a text editor.