Import a lot of Product

This is really precious info. Thank you very much Feryt.

Sharing of this code has saved me a lot of time.
Thank you very much.
Regards

Yes ,you can use sql update the database.
But ,first of all ,you need clear up the relation of product.

how can i update database using EXCEL
if excel product name is equals to database product name...
then
no update...

KumarKovuru wrote:

Through database.

Import your excel into new table in database and write SQL request that will update fields in NopCommerce Product Table with selecting data from your new table.

@kaunuk that's a good way, another is to use formula in excel to create update statements then run them against the DB

I'm new in nopcommerce can you please explain more about procedure parameters and what each one mean ,some of them i don't know what mean and thank you alot

I am developing new tool and it is almost done,
you can map any Data Source (currently SQL,Excel,WebService) to nopcommerce (currently supports v3.50 and v3.60)


Supports;
Product with pictures, attributes, specifications,
manufacturer (with logo),
categories (including sub categories and images),
Tiers

Support snippets for each fields.

http://picpaste.com/pics/importapp.1438188467.jpg

http://picpaste.com/pics/importapp2-XKHEyymK.1438188072.jpg

http://picpaste.com/pics/importapp3-dyqfSdKi.1438188092.jpg


PM me for details.
Thanks.
Karay

looks great. hopefully you can finish soon and we can use it for uploading 150K+ products :)

Mapping the entities dynamically to other sources with XML is not easy. That is the hard part.
+ It is using builtin Nop.Services and business logic.
Not custom functions.

Thanks,