Quote Originally Posted by nicksab View Post
mc12345678,

I owe you a sincere apology and thank you for pointing me in the right direction.

For anyone facing the same issue, the answer is in post #3294
Well thank you. The issue was though described in a way different than those previously reporting the same type of problem and I know full well how it is always desirable for everything to work with zero additional change or adjustment. I still suggest using the standard zen Cart process to "move" the product though really am more concerned about the customer experience, but hope that you are able to accomplish what is needed.

If you do decide to continue using this to move product *and* retain product reference for customers or search engines, then there is another configuration switch that I suggest modifying away from default settings on both stores which is to use the Product's ID as the primary key instead of the default products model.