CSV upload issues

Hi all,

I’m trying to import 3000 + products into my website,

The first time I imported them, they all went into they’re respective categories however duplicate categories were created in many instances, these duplicates have subcategories and those subcategories also have subcategories, so its a bit of a mess.

Also the products were evenly distributed among where they were supposed to be and the duplicate categories/subcategories which means deleting the duplicates sends all the products to uncategorised where I then have to sort everything manually.

This is a pain so I tried deleting all categories that had duplicates, and the duplicated categories and all subcategories and products relating to these.

I made up a new CSV file and tried importing again;

There were some positives and 265 negatives, I only have 3 duplicated categories now, from this test specimen and about 20 duplicated subcategories, i have no duplicated products which is good.

However 265 products were designated uncategorised for no apparent reason.

Has anyone had this issue?

Any help would be massively appreciated.

Thanks.

Michael

The page I need help with: [log in to see the link]