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.