Skip to Content
This question has been flagged
1 Atsakyti
964 Rodiniai
Portretas
DT

Hello, 


I am looking for a new ERP system and am evaluating Odoo in this context. Odoo has made a good impression so far, but I have now reached a point where I am stuck:

It is about (product) data import. Small test imports were satisfactory, but now I wanted to import a first larger chunk of data (about 350,000 products). The import via the GUI does not work (the import page has been showing a spinning circle for over an hour). I haven't tried splitting into "smaller" chunks yet, but from what I have read, this tip is also given to people who want to import only a few thousand products. I don't feel like creating 350 or more chunks now. Besides that, I am looking for a solution to automate the import (preferably daily). Ultimately, I want to regularly (daily) import about 700,000 products.

What are my options? Can I script the import? Are there any examples for this? In a quick search, I did find a few scripts, but they are generally more than 5 years old. Are there alternative approaches to solve my problem? Is bulk import easier / more performant in the Enterprise version?

I am currently using Odoo 17 community in an on-premise installation on a Debian 12 host.

Portretas
Atmesti
Portretas
Niyas Raphy (Walnut Software Solutions)
Best Answer

Hi,
Either you can split and import data into odoo using the import feature of odoo or as you mentioned you can create python  script which takes data from some db/sheet at regular interval and create data inside odoo.

From python script using the service like xmlrpc or json rpc, you can connect into odoo db and created records in it.

Sample:  Read Data From CSV File And Create Records Inside Odoo Database Using Python Scrypt



Thanks

Portretas
Atmesti