How to import product images in V12 and V13 ?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
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 :-).
You can use the imghippo tool.
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.
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign upRelated Posts | Replies | Views | Activity | |
---|---|---|---|---|
|
12
Dec 23
|
38507 | ||
|
3
Jun 17
|
7980 | ||
|
1
Nov 24
|
628 | ||
Import Products by SKU
Solved
|
|
2
Mar 24
|
1969 | |
|
4
Mar 22
|
16468 |