Importing data

Hi,

Does anyone know of a way to import data into nopceommerce? Either direct into the DB or via code?

I currently have all products in a DB and imags on file system I would like to import them all into nopcommerce...

Any pointers would be great..

Thanks.

There is no built in way of doing this currently. You could create an SQL Server SSIS package to do this. Seem to remember a few people discussing using SSIS to import into nc. Not sure if they actually did it.

I imported records through a two step process. First I created a C# application that read in each product and loaded the image file. I was then able to insert the record in nopCommerce. My products have many variant values, so then I created a SQL script that went through each item and created the necessary variant and variant values in nopCommerce.

Maybe you can tell us where you're stuck?

Tod

I was able to get products imported via sql into the NOP_product table but when I go to the NOP admin panel to assign these items I imported to a category they don't show.  Can you help?  I think I need data in the Nop_ProductVariant table maybe be I can't figure it out.

Tod,

Your scripts are exactly what our backend needs. We have over 10000 products to load...I have been working on an all inclusive SSIS package and DataMapping for this but am stuck on the Variants part.

My package is trying to include all possible Product Options.

Thanks any script files or C# code you have already would be very helpful.

Thanks,
nike76

Can anyone share their code or scripts for importing product?

Can anyone share with us this script ?

Giuseppe

I'll bump this thread - scripts would be great. Even better if they were publically available in the downloads section :)