Symptoms
The Excel import function does not import the category mappings for category 3 and category 4, but other fields are imported properly.
Cause
This issue is caused by improper placement of the import file version identifier.
Solution
To resolve, locate “Import File Version:” in row 1, column E and move left one column so “Import File Version:” is located in row 1, column D. Then move “3.0” in row 1, column F to row 1, column E.
NOTE: Do not remove any columns from the import file sample or your import will fail.