How to import product image

Hi all,

Does someone knows how to import product image in the xlsx file ?

I tried the image URL, the image encode in base64...

thank you

Like 0

Like

5 comments

Hello,

if we take a look at the table in DB where information on products is stored, you can see that the column which stores information on images is called "PictureId". This column takes information directly from "SysImage" table where all images are stored. The image itself is stored in "Data" column and it is stored as binary code there. Unfortunately there is no way to import data to SysImage table directly using data import tool. I will create a problem to our R&D team so to develop this functionality in future and I hope it will be implemented soon enough. As for now you need to update images manually via product page. Thank you for helping us to make our application better.

Best regards,

Oscar

thank you Oscar

Do you know how to encode Line feed in the excel import file for BPM multi-line fields ?

LÉZORAY Nicolas,

 I ve got it, i replace line feed by <br/> in my SQL results, next in the xlsx file, i replace <br/> with ALT+010

LÉZORAY Nicolas,

Are you saving this into a standard field or the Notes field? When I did importing of data into the Notes field, it has never worked.

Mark Roberts, into the Notes Field it works

Show all comments