Skip to Content
Menu
This question has been flagged
3 Replies
13165 Views

How to import product images in V12 and V13 ?


Avatar
Discard
Author Best Answer

If a customer wants to import the images associated to their products, here is the best way to import them in Odoo 12.0 or above.

The main purpose of this entry is to explain how to import online hosted images in Odoo. So, the first question is : Are the images currenlty hosted online?


YES : Just put the URL of each image in front of the related product External ID in a spreadsheet and import it !


NO : You will have to host them on your Google Drive and proceed as follow.


1. Copy the following folder to your own Drive : 


2. Please copy the folder. Example

3. Upload the images to convert in the "Images" subfolder

Note that your customer can upload himself the images...

4. Make sure that the sharing property of the "Images" subfolder is set to "Public on the web"

5. Open the GSheet "Images URL Generator"

6. Launch the conversion by clicking on the menu "Scripts > Images URL Generator"

7. The sheet will contain three columns :

- Internal Reference (tip : rename the images with the Internal Reference or the External ID of the product) 

- Name

- Image

8. Download the GSheet as Excel or CSV

9. Import the file

10. Take a Bertinchamps and relax.


Tips :

- The script works with all files format. For example, you can get the sharing URL of PDF files.

- In version 12.0, it is advised to have a maximum of 100 images per imported file. It could be lower or higher depending the size of the images.

- In version 13.0, you can reduce the size of the imported batch and set maximum 100. Once again, it could be lower or higher depending the size of the images.

Importing error in version 12.x :

1. Check if the module named "saas_base_import" is installed. If yes, update it. If no, install it by following the next steps.

2. Create a server action to execute python code.

3. Paste this code : env.ref('base.module_saas_base_import').sudo().button_immediate_install()

4. Run the server action.

5. Import the images :-). 


Avatar
Discard
Best Answer

You can use the imghippo tool.

Avatar
Discard
Best Answer

There is an update regarding this entry because Google does not accept this generation of URL's anymore for security reasons. 

If the images have already their URL then you can import them easily via a CSV file. 

If the images don't have the URL but have something in their name that refers to the product you want to link it, then you can ask a Tech to do a script import. 

If the images don't have anything of these options above, then you should upload them in Odoo product per product manually. 

What I did was using this external website : https://postimages.org/nl/ to generate the URL but still you need to generate the links one by one but at least you can import them all together (again in a CSV file).

But it's up to you to decide what's quicker. 


Avatar
Discard
Related Posts Replies Views Activity
12
Dec 23
38507
3
Jun 17
7980
1
Nov 24
628
2
Mar 24
1969
4
Mar 22
16468