Import products

You can create more than one product at once by importing a list of products from a .csv file. The product importer is a widget that you place a page, which you then open in a browser and select the .csv file to be imported. Once you have uploaded your file, the product importer widget reads the values from your file and inserts them in the database. The Product Import is deployed as a NuGet package, which you import using NuGet. NuGet is a Visual Studio extension that makes it easy to install and update third-party libraries and tools in Visual Studio.

RESTRICTIONS: Using the product uploader, you can import only top level departments and you cannot upload custom classifications.

To import products, perform the following:

1. Download and install NuGet from http://nuget.org/.
2. Open the project manager, select your project and click Actions » Edit in Visual Studio.
3. In the Solution Explorer, open the context menu of SitefinityWebApp and click Manage NuGet Packages…
4. In the left, select Online tab.
5. In the search box type Sitefinity.
6. Install Sitefinity CMS Ecommerce Product Upload.
7. Click Close.
8. In the context menu of SitefinityWebApp, click Add » New Folder.
9. Name the folder upload.
10. Download the .zip file with Product Upload widget and sample .csv files from https://github.com/esitefinity/Sitefinity-Ecommerce-Product-Upload.
11. The file contains the widget and two sample .csv files.
12. Extract the files from the .zip.
13. In the Solution Explorer, open the context menu of SitefinityWebApp and click Add » Existing Item…
14. In the extracted .zip files folder, open folder ProductsUpload and select file CsvUploader.
    This is the widget.
15. Register the widget in the Ecommerce toolbox using Sitefinity CMS Thunder.
    For more information, see Thunder: Register a widget.
16. Build your solution.
17. Login to the backend of Sitefinity.
18. Create a page called productimport and add the Product Upload widget on it. 
    Make sure the page is not visible on the frontend of your site.
19. Open the page in a browser and upload the .csv file that contains your products.

NOTE: You must have created all product types and custom fields of your products. The order of the columns in the .csv file and the order of the fields in the product types must be the same. For reference, use sample .csv files provided in the .zip.