More in this section

Forums / General Discussions / Importing Products from existing SQL database

Importing Products from existing SQL database

3 posts, 0 answered
  1. Corby
    Corby avatar
    48 posts
    Registered:
    19 Sep 2011
    28 Mar 2012
    Link to this post
    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.
  2. Jochem Bökkers
    Jochem Bökkers avatar
    787 posts
    Registered:
    13 Aug 2007
    28 Mar 2012
    Link to this post
    Hey Corby,

    Fortunately there is...
    Venkata (the brains behind it all) already solved your problems in this detailed explanation (http://www.sitefinity.com/devnet/forums/sitefinity/e-commerce/mass-load-new-product-into-database.aspx)

    Good luck!
    Jochem
  3. Corby
    Corby avatar
    48 posts
    Registered:
    19 Sep 2011
    28 Mar 2012
    Link to this post
    Thank you!  Consuming this content now.  
3 posts, 0 answered