I have a question on the product import/export.
In the release notes for the product import/export its said that:
Product Export Function
-
The ability to export all products in the same format as the product import spreadsheet
When you click Product Export, you get a .CSV file. You have to save this file once you get it into a .XLS.(I had to search the forum to find this out) In addition, when you import this XLS file, it doesn't replace products, it adds them to your current database, I've tried this multiple times with the same XLS file, and it has never updated once. Also, the format of categories it seems to completely ignore and now I have several hundred items with a category of 'Null', there is also no ability to have any items being imported being Archived. With my company, seasonal products I have to now go in and manually change certain items to archived or not, which defeats the purpose of having this easier method of importing/exporting products.
I'm not a SQL genius, I can navigate through most of this just fine, but this excel option doesn't seem to work nearly as close as you explain it.