I just downloaded Database I/O Manager. I installed it on a fresh copy of ZC with the sample products.

I exported a test CSV file with the “products” handler and then imported it to an Excel file (easier to read).

I’m sure that this is a really stupid question but I still need to ask,

1) When creating the Excel file to convert to CSV when adding products, I use the exact headings like v_products_id, v_products_type, etc,etc?

2) In the “v_categories_name” all I have to do is use the “^” symbol to separate from sub-categories like
Main-cat^sub-cat1 or Main-cat^sub-cat1 ^sub-cat2?

3)Does this process have to be repeated for adding attributes(provided they already exist) using a different handler/separate CSV file?