İçereği Atla
Bu soru işaretlendi
quickstartQuickstartQuickstar
1 Cevapla
3823 Görünümler
Avatar
Sergio Antonio Macedo Herrera (samh)
Importing Images from a Google Drive Folder (massive)


There are many cases where product images need to be imported (massive). The only way to do this is by obtaining the direct link to the image so that Odoo can read and import it. However, tools like Google Drive and Google Sheets can help us quickly obtain a URL for the image.



Avatar
Vazgeç
Avatar
Sergio Antonio Macedo Herrera (samh)
Üretici En İyi Yanıt

Importing Images from Google Drive to Odoo


Part 1: Setting up Google Drive and Import Template


Create a folder in Google Drive with the following access permissions:

General access: Anyone with the link - Viewer.



In this Google Drive folder, you can only upload images in JPG, JPEG, and PNG formats; other formats like WebP, PDF, AVIG, etc., are not supported.


In a Google Sheet, create an App Script:

Go to: Spreadsheet > Extensions > App Script.



Clicking on this section will open a new tab. We need to rename it and add the following code:


Code

function generateCSV() {

  var folderId = '1FWSmcU5f5B4PAidjdvIHgl-7zVzVxKnS'; // Replace with your Google Drive folder ID

  var folder = DriveApp.getFolderById(folderId);

  var files = folder.getFiles();

 

  var data = [];

  while (files.hasNext()) {

    var file = files.next();

    var fileName = file.getName();

    var fileId = file.getId();

    var link = 'https://drive.google.com/uc?export=view&id=' + fileId;

    data.push([fileName, link]);

  }

 

  var sheet = SpreadsheetApp.getActiveSpreadsheet().insertSheet('Image Links');

  sheet.appendRow(['product_name', 'image_url']);

 

  for (var i = 0; i < data.length; i++) {

    sheet.appendRow(data[i]);

  }

 

  SpreadsheetApp.getUi().alert('The CSV data has been created in the "Image Links" sheet.');

}



Google Drive Folder ID

In the second line of the code:


We will place the ID of our folder with images. To obtain the ID, open the folder in your browser, and it will be found after the word “folders/IMTHEID”.



Save and run the code.


This code will generate another tab in our spreadsheet, and we can use the URL to import it into the image_1920 field in Odoo.


NOTE: This method is very effective, but it depends on the size and format of the image. Images that are not successfully uploaded can be manually loaded.

NOTE 2: For better data management, it is recommended that the image names contain the product name or internal reference.


Part 2: Importing into Odoo


Once the import file is ready (example image):



Go to your Odoo instance and navigate to the Inventory app - Products - Products (the path doesn’t matter; the import can be done in the product.template model).



In the list view and the Favorites section, select “Import Files” (for versions below 17.0).



In the list view and the action button, select “Import Files” (for versión upper 17.0).




• Upload the file and import.



Avatar
Vazgeç
İlgili Gönderiler Cevaplar Görünümler Aktivite
"How to make rent movements for tracking inventory on projects " Çözüldü
quickstart Quickstart qsmx Quickstar
Avatar
1
Eyl 25
1006
How to dowload in bulk the attachments on my chatter and my product images? Çözüldü
quickstart Quickstart qsmx Quickstar
Avatar
Avatar
2
Eyl 25
1295
How do I connect the Epson TM-T88VII to Odoo?
quickstart Quickstart
Avatar
Avatar
2
Eki 25
1013
How to Set Customer-Specific Product Names Çözüldü
quickstart Quickstart
Avatar
1
Kas 25
1569
✅ Odoo E-commerce: How to discriminate deliveries based on the type of clients
quickstart Quickstart
Avatar
0
Ağu 25
1516