Resetting category and product numbers

Previously I was uploading a 14k product csv file in stages. Now, I have narrowed that down to 4k products and am ready to upload it all at one time.

I want all my category id #'s and product numbers reset before I do.

I have deleted all the products and categories before and uploaded new only to find it picked up where it left off.

How do i get it to start over at 1? :unsure:

I found the AUTO-INCREMENT place in the MyPHPAdmin to change this. I reset it and the product #'s. Started them both over at 1. :cool:

AND, it still works. lol

Hopefully you removed ALL database references to products and categories - including any historical test purchases / orders and the associated order histories.

There are a LOT of places where zc uses ID's for relational data, and missing just one of these can cause problems later.