More in this section
Blogs RSS feed

Sitefinity Ecommerce – Importing Products into Sitefinity Ecommerce

by User Not Found

Using the Sitefinity API, I would like to show you how you can import products into Sitefinity Ecommerce.  

How it Works

The product importer is actually a widget that is placed onto a page.  Once the page has been created, bring up the page in a browser and follow the instructions to upload your file of products to import.   Once you have uploaded your file, the product importer widget reads the values from your file and inserts them into the database.   The latest version of Product Import(Product upload widget) is available on github and the code behind utility classes that are used by the widget and that you need are available also on github here  We highly recommend using the latest version available from github. There is a NuGet package as well but it is possible that it is outdated.

In the example I am using a .csv file as my data input.  The format of this file has been created such that you can add many custom product type fields at the end of the file.  Here we are only going to create two custom product type fields, CustomProperty1,CustomProperty2.


  Once you have NuGet installed, please follow the following installation steps.

Installation Steps

  1. If you want to try using the NuGet Package: Right click on your solution and select “Manage NuGet Packages…”.
  2. In the Manage NuGet Packages window, select “Online” on the left side column then search for “Sitefinity”.    NuGet will find the Sitefinity package allowing you to install it directly into your Visual Studio Solution.
  3. Create a folder called “upload” at the top level of your solution.  This is where the .csv file will be uploaded in to.
  4. Copy over the file upload widget control into the root of your solution.  You can download latest version of the Widget from GitHub.
  5. Open Sitefinity Thunder and add the widget to Sitefinity
  6. Build your solution
  7. Start your solution without debugging
  8. When your Sitefinity web site comes up, login to the backend of Sitefinity
  9. In the top navigation, click on “Ecommerce” and select   “Type of Products”.  
  10. Create all of your product types that you will be importing all of your products into. 
  11. Create a new page in Sitefinity and call it productimport
  12. Drag and Drop the new widget you inserted using Sitefinity Thunder onto the page.   Save the page.
  13. Bring up this page in your browser and upload your .csv file.  This will upload your .csv file into a folder called “upload”, located in the root of your solution.
  14. In the top navigation, go to “Ecommerce” and select “Products” and you should now see all of your products imported.

I have created a video showing you how to install the Product Upload package using NuGet, add a widget using Sitefinity Thunder and upload your .csv file.

Sitefinity Ecommerce Product Import



Credits and thank you to Venkata Koppaka for programming this! Smile


Leave a comment
  1. Mitch Brown Jul 05, 2012
    This is a fantastic module! Thankyou Steve & Venkata.

    Is there a version compiled for use with 5.0 2860 at all? It errors out looking for the 5.0.2800 assembly on the latest version.

  2. Tobi Jun 14, 2013
    Is there also a way to import the product type(s)?
  3. Betty Sep 04, 2013
    Can it import electronic products?
  4. Ryan Apr 15, 2014

    I tried this and am having an issue. While it creates the product just fine, and while it uploads a file/document to the server, it doesn't actually ASSOCIATE the file to the product. I see the document in there, so it's getting uploaded just fine, but it's not tied to the product. 

    Any idea why? Thanks.

  5. Krish Jun 16, 2014

    I have followed the instructions the concept looks great to me while implementing. Thanks!  The csv file gets uploaded but I face a FileLoadException with the message being "Could not load file or assembly 'CsvHelper, Version=,culture=neutral,publicKeyToken=8c4959082be5c823' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT:0x80131040)"

    Kindly help

    Thanks in advence.

  6. Charbel Jul 24, 2014
    I am facing the problem Krish is having, any idea ? 
  7. Praneeth Sep 08, 2014
    Same issue as Krish & Charbel. Anyone had luck. I am using Sitefinity 7.1
  8. phil crowe May 01, 2015

    Krish's issue can be solved by getting the older version of csvhelper through package console: PM> Install-Package CsvHelper -Version 1.17.0

    But i get an error after that: Index was outside the bounds of the array.

    All my columns match up when i view it in excel

  9. Nelssen Aug 17, 2016
    Same for me phill crowe, did you find a solution?

    Leave a comment