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.