Bulk import product with images

Hi,

I have like 10K products with images. I loaded the products to my own inventory table, want to update the nop_product and productvariant table with that table. I also want to bulk load the images, the image is sku.jpeg or sku_1.jpeg.

Does anyone have some samples to achieve this? Current nop implementation has to add the images to the database, and load products from excel, I found that is not easy to automate the process.

Any comments are highly appreciated.

Thanks.

Also, since I already have all the images in 2 different sizes in two folders. Is there anyway that I don't need to insert the binary to the database again?