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.
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.
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.