Products' images URL

Question

Hello, I am trying to sync odoo with an existing ecommerce platform. Right now, I am trying to upload products from odoo to this platform. In order to upload the product image, I have to send the image url.
I tried to do so through the path  /web/image?model=product.template&id={{product.id}}&field=image
But it didn't work, since the url doesn't return the image file.
I also tried to use the path  /web/image/product.template/{{product.id}}/image
In this case it didn't work either, because of a 4

Yenthe Van Ginneken (Mainframe Monkey) · Accepted Answer

Hi Arthur,
By default the images are stored in the database in a base64 format so they're not really stored as an attachment. If you have the image as an attachment on the product you can create a public URL for it as you can look at the paths from the fields 'local_url' and 'website_url' (from the model ir.attachment) to make a full URL to your image(s). This way you could provide links but then you have to attach the images as an attachment on the products. I've added those two fields to the v

Ahmad Rahban · Answer

I managed to solve this issue by doing it manually.. I used a free app called "image from url" and pasted the image url there and then exported the value of the image_from_url field which's the image link!

fudo · Answer

Currently, to get the product image as url, we could use:
from odoo.tools.image [1] import image_data_uri
product_image = image_data_uri(product.image_1920)
In my case,
product.image_1920 is the column of saved product image, you can replace it with your column to make it work.
Note: after get
product_image, you can see it still look like base64 encrypted format, but it's not, try to paste it to web browser such as Chrome, and you will see the image appear.

[1] https://odoo%5C%5C.tools%5C%5C.i

Stefano Savanelli · Answer

/
By default the images are **NOT** stored in the database, but in filestore.
In ir_attachment table for images  by  default  type  field  is  set  to  "binary"  and  store_fname field is  set  to  filestore path of the file.
Other behavior  can  be  set  by  config  or  by  addons.

arthur · Answer

I managed to create the attachment and get its .local_url. However the route is also private. Is there a way can make it public?

Jhe · Answer

I have same issue, is there any solution?

関連投稿	返信	ビュー
Get image (field Binary) for public user public images	0 4月 24	1899
How to create a public url to download an attachment? 解決済 public attachment url download	1 2月 17	24367
Products image from URL, csv. product url images ascii	2 12月 16	5259
[ODOO13] Create a link to the res partner image res.partner attachments url images Odoo13.0	0 4月 21	3873
Suggestion for image management for the website, mailings... images	0 6月 25	3451

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！