Wednesday, September 9, 2009

Import data into nopCommerce

skiltz.nopImport
Current Version - Alpha 0.1 *****NOT for Production Systems******

What does skiltz.nopImport do?

skiltz.nopImport will import data from a data source into the nopCommerce database.

What assumptions are made?- Each product has 1 product variant and zero attributes.
- Only products with SKU's that don't exist in nopCommerce will be imported.
- That you have a ProductTypeID that = 1
- That you have a TemplateID that = 4
- That your product images are stored in the database(nop Default) not on the file system.
- That you can remotely connect to your nopCommerce database.
- That your product images are on the file system.
- .net 3.5 framework is installed on PC

What data sources can I Import from?
Currently you can import from Excel or Microsoft Sql Server.

Where can I get help?
Please post all bugs on the nopCommerce forums or email mskilton@gmail.com

Install guide.

Where can I download the installation from?
It can be downloaded from http://skiltzonnet.blogspot.com


Double click on the install file and follow the prompts.


To open the program go to "Program Files"/skiltz/skiltz.nopimport

Steps to complete a import.
Step 1:
Right Mouse Click on NopSqlConnection and click "Update Connection String"
• Type in your server name i.e /home/sqlexpress
• Choose if using Windows Authentication or username and password
• Type in your database name
• Click test connection
• If successful then click ok

Step 2:
Right Mouse Click on Database (under External Data Sources) and click "Add Connection"
• Click "change" on right and choose your data source type (Excel or Sql Server)
• Type in your server name i.e /home/sqlexpress
• Choose if using Windows Authentication or username and password
• Type in your database name
• Click test connection
• If successful then click ok
• Type name of connection
• Click Save

Step 3:
Right mouse click on the connection you made and click "Database Mapping"
• Choose the table you want to import from
• Choose the column that contains your SKU code.
• Match your columns with the columns in nop using the dropdown boxes.
• click save to save you database mapping.

Step 4:
Right mouse click on the connection you made and click "Analyze data" this should some details about the file you are importing and information about nopCommerce.

Step 5:
Right mouse click on the connection you made and click "Import New Products". This should import products. Go to your website and see if it worked.


File can be downloaded from
http://www.agentx.info/setup.msi