Hello,

I'm in the process of creating a new zencart store. The 7800 lines of data/categories/products have all been compiled into a handfull of csv documents that correspond with the appropriate db tables:

zen_categories_description.csv
zen_categories.csv
zen_manufacturers_info.csv
zen_manufacturers.csv
zen_meta_tags_products_description.csv
zen_products_description.csv
zen_products_to_categories.csv
zen_products.csv

I am using cocoaMySql to import the data and some of them have gone in just fine. I am having an issue with zen_categories.csv.

My category/subcategories id's are setup as follows:

10 Top Cat
1001 Sub Cat
1002 Sub Cat
20 Next Top Cat
2001 Next Sub Cat
2002 Next Sub Cat .... and so on

When i try to import it with the db's default settings it overwrites the caterogies_id column with sequential numbers.

If i turn off auto_increment, each caterogies_id defaults to 0, only writes 1 row and i get errors kicked back.

I have a similar issue with zen_products_to_categories.csv where there are some rows that should have duplicate product_id's but they get written as sequential numbers.

Any help would be awesome

TIA DD