There's an issue.
For fields that are empty, they need to be set as empty values in the CSV.
Say, I want to export these fields:
Sku Price PriceCost OldPrice TierPrices Name of product Url
But some of my records do not have TierPrices. The exported row looks like this:
NCEVKP-001A600,99.94,0,0,"Kraft Envelopes",http://URL.com/Envelope,
The correct way should be:
NCEVKP-001A600,99.94,0,0,,"Kraft Envelopes",http://URL.com/Envelope,
Notice the blank value after the second zero.
I'll will email you my exported data. If you open it in excel you will see what I mean.
FYI: You may need to remove the trailing comma in the exported row. It's not needed.