Short of uninstalling and reinstalling (upgrade doesnt do this) is there a way I can reset the ProductID and CategoryID counter?
Yes you can seed an identity column to start at any number you want. Here is a forum post that explains how:
https://www.smith-consulting.com/foru...
-Scott