Then IF I could reset Product ID’s and then Reload using Lessons Learning to avoid a repeat of the error again….
It was worth a try. The worst that could happen is I would have to “start over” and that was already a “real” possibility.
I am happy to say that it does seem to have worked and I will now be spending the next few days, rethinking my product ID numbering plans, and using Easy Populate to Reload.
Still VERY VERY annoyed over the lack of information that could have helped me to avoid the problem in the first place – NOT with ZenCart – learning curves are part of the package when you choose Open Source.
BUT we purchased Easy Populate Advanced JUST to avoid the problems of “no documentation”. More about that another day, for now, my recommendation is DON”T Buy it if you are doing so with an expectation of Support beyond excuses for why no support has been forthcoming.
My thanks to the folks in the forum, who have been so helpful. Guess I need to buy some coffee this week for the Zen Team
March 29th, 2008 at 09:58 am »
Comments (0)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