Product null Import issue

[VoShay]

I'm having the folowing error code trying to import new items-

[Import(Upload) Information]:-


Importing 11 Products

Value cannot be null.
ImportOrUpdate unsuccessful for Product
ProductId = 0
Name = 8 Small Ceramic Bar Magnets 07001
Error message: Value cannot be null.

at CommerceBuilder.Catalog.CategoryDataSource.LoadForName(String name, Int32 parentCategoryId)
at CommerceBuilder.Catalog.CategoryDataSource.LoadForPath(String path, String delimiter, Boolean create)
at CommerceBuilder.DataClient.Api.ObjectHandlers.ImportHandler.GetCategoryId(String CategoryPath)
at CommerceBuilder.DataClient.Api.ObjectHandlers.ImportHandler.ImportProductCategories(ProductCategory[] arrImportObjects, ProductCategoryCollection productCategoryCollection, Product objProduct)
at CommerceBuilder.DataClient.Api.ObjectHandlers.ImportHandler.<ImportProducts>b__3a(Object& acObject, Object schemaObject)
at CommerceBuilder.DataClient.Api.ObjectHandlers.ImportHandler.ImportChildObjectsArray(Array schemaObjectsArray, Type acType, String objName, String idFieldName, String displayNamePropertyName, Object parentId, TryLoadExistingObject tryLoadExistingObject, TranslateObjectAssociatedIds translateObjectAssociatedIds, SaveACObject saveACObject, ImportObjectChildsAndAssociations importObjectChildsAndAssociations, String csvFields)

Base Exception: Value cannot be null.
at CommerceBuilder.Catalog.CategoryDataSource.LoadForName(String name, Int32 parentCategoryId)
at CommerceBuilder.Catalog.CategoryDataSource.LoadForPath(String path, String delimiter, Boolean create)
at CommerceBuilder.DataClient.Api.ObjectHandlers.ImportHandler.GetCategoryId(String CategoryPath)
at CommerceBuilder.DataClient.Api.ObjectHandlers.ImportHandler.ImportProductCategories(ProductCategory[] arrImportObjects, ProductCategoryCollection productCategoryCollection, Product objProduct)
at CommerceBuilder.DataClient.Api.ObjectHandlers.ImportHandler.<ImportProducts>b__3a(Object& acObject, Object schemaObject)
at CommerceBuilder.DataClient.Api.ObjectHandlers.ImportHandler.ImportChildObjectsArray(Array schemaObjectsArray, Type acType, String objName, String idFieldName, String displayNamePropertyName, Object parentId, TryLoadExistingObject tryLoadExistingObject, TranslateObjectAssociatedIds translateObjectAssociatedIds, SaveACObject saveACObject, ImportObjectChildsAndAssociations importObjectChildsAndAssociations, String csvFields)

This is happning for every product Iine I try to upload, but here's an example .csv

[Naveed]

You were specifying the categories data in wrong way. For categories you were specifying:

Door Announcers:

Which should be:

Door Announcers

without the colon(:) character, as there are no child categories.

[VoShay]

Never noticed that, but it makes sense. Thanks for your assistance.