Images that were uploaded to Linnworks inventory (Primary Images, Image1, Image2 ) are hosted on Linnworks servers. The following custom script will retrieve the URLs of the images on the server if you run it in Query Data > Custom script:


select 'http' +'://s3-eu-west-1.amazonaws.com/images.linnlive.com/'+lower(CONVERT(NVARCHAR(32),HASHBYTES('MD5', CONVERT(varchar(max), DB_NAME())), 2))+'/'+LOWER(CONVERT(NVARCHAR(max), sir.pkImageId))+'.jpg' as 'Image' FROM Stock_ImageReg sir
HTML