This issue is way over my head! When I add a new product using the OSC Admin console, I receive the following error:
1062 - Duplicate entry '29-1' for key 1
insert into products_description (products_name, products_description, products_url, products_id, language_id) values ('Baby On Board', ' Is it a boy or is it a girl? Either way your wrist will be decorated with Baby on Board. This beautiful bracelet combines Light Sapphire and Light Rose Swarovski Crystals set off by Squaredelles with White Swarovski Pearls and Sterling Stardust Beads. It includes the Baby on Board charm and our signature heart extender chain. Optional, after the baby is born you can change the charm to an It's A Boy or It's A Girl charm. Makes a great gift for the expectant mom. ', '', '29', '1')
An even larger problem is that the product insertion attempt overwrites another pre-existing products attributes (e.g. Price).