Adding catagories via csv

HI,
I've just bought Hikashop Essential and need to add some categories in order to assign discounts on certain items within certain price ranges. My question is this: I have over 1,100 items and therefore would like to do a csv upload. How do I add a category to an item which is already assigned to a few different categories. In other words; I wish to add a category without deleting the existing ones via csv import.

Thanks,
Steve

I've been playing with this to do something similar.

My understanding is that if a product already exists then deltas on the import are applied.

So if you do an export file, add the new category to the product line in the file and then import, the new category is just applied to the changed products.

I'll know in the next couple of days if this is true but that's my understanding from the documentation. I've also read that you can use the category ID or the name on the import - I prefer the ID as it helps prevent typos on big files. Again not tried yet.

Tony

Well I tried a test csv import . It certainly imports and updates prices but places them in the new category BUT, it takes them out of the old ones. As for exporting from Hikashop and then opening in excel; that doesn't seem to work in 2007 on my Vista machine. All I get is this (see attached)

Brilliant! Thank you!!