u/EfficientJury

Context:

- B2B distributor migrating from legacy ERP to Odoo 19 Enterprise

- ~50k active SKUs + ~8M historical/staging products (XML imports from suppliers)

- Magento frontend (eshop), real-time stock sync (every 1-5 min)

- ~1500 sales orders/day, 300 concurrent users

- Self-hosted

Questions:

1. Has anyone run Odoo with 8M+ product.product rows in production?

   Issues hit? ORM cache pressure? search_read performance?

2. Is active=False the right pattern for "staging/archive" products,

   or did you split into a separate table/DB?

3. Magento connector — did you need customization?

4. Any tips?

Thanks