I am using 2.10 and am able to import from an excel file. The only issue I see is that we then have to go into the admin and link the products to categories and then upload images for each product. This will take a while.
Is there a way if the image is on the server already to include the path to the local file to import how you would do in the admin area one product at a time?
From my findings so far it appears that images are stored in the 'picture' table in binary format. I see the table to tell what product has what image is in 'product_picture_mapping'.
If it's online why is there 5 different files in the /content/images/thumbs/ folder?
For example product 331 has the following files:
-0000317.jpeg
-0000317_100.jpeg
-0000317_125.jpeg
-0000317_300.jpeg
-0000317_70.jpeg
Any thoughts on how we can do this quickly?
Thanks.