Quote Originally Posted by Serious View Post
Sigh......

Guess I need to learn how to use OO now.


I hate my life.....
The trick is to save in either xls or ods while you are editing and only save a copy in csv when you need to upload.

=======

Can I ask a question?

I have a store with about 200 products. Recently I have taken on a new supplier and need to add 2000 more products. Over the past few weeks I have been in spreadsheet hell trying to get everything perfectly categorised and in order. In the process, I have decided on a better category structure. I've also broken an EP rule and changed some product titles and even model numbers. I can probably fish out the products that are already in the store, but I'm wondering if it wouldn't be better to just remove everything and re-add it.

Is this advisable? What might the consequences be?