Every day it seems I find yet another reason why sooner or later I am going to have get a LOT smarter about DataBases.

Today’s hard lesson was taught in the process of getting zenned.

Apparently when selecting PRODUCT Numbers there is a limitation in how you decide on product numbers.

Let me just say that I have now learned the hard way TWICE, that use of ISBN’s and UPC as Product Numbers in conjunction with EZ Populate is NOT a good idea.

So if you get an error message that starts.

1062 Duplicate entry ’2147483647′ for key…

There is a very good possibility you will soon be erasing your store and starting over “from scratch”

Talk about undocumented unintended consequences.

If I find out an easy solution, I promise to share –

For now, well, time to go try the dangerous solutions, and if they don’t work “start over”

Happy Spring