Importing Products from existing SQL database

I am trying to populate product information directly into the Sitefinity 5 (on Azure) "sf_ec_product" database table.  I have a local SQL database with my products.  I have copied the product tables up to Azure using SQL to Azure migration tool, http://sqlazuremw.codeplex.com/.

I have created a new product type and given my product type attribute fields.  This causes Sitefinity to create a new SQL table called sf_ec_prdct_mygreatproducts.  I can not Insert products directly into this table because of a FK restraint.  It appears I have to insert the product into sf_ec_product instead.

So far, adding products directly to sf_ec_product via SQL Insert commands allows them to show up as a product on the Sitefinity back-end.  But when I go into edit one, I can not save it because there is no reference to it in the sf_ec_prdct_mygreatproducts table.  

So I guess I am interested to know if there is a smarter way to get products into the Sitefinity sql tables, specifically products that have their own Product Type defined in the eCommerce section.

Hey Corby,

Thank you!  Consuming this content now.