Odoo 18 CSV Stock Export

Замовник: AI | Опубліковано: 20.12.2025

I need a small, self-contained module for our on-premise Odoo v18 that automatically writes a daily CSV snapshot of our stock levels to a folder on the same Windows pc where Odoo runs. Functional flow • Every evening at 9 PM a scheduled action should launch, fetch every product variant that is both ticked in the custom boolean field “Export Presta” and has a positive on-hand quantity, and then build one CSV row per variant. • The column order must be exactly: Product Name, SKU Variant, Attribute Name 1 (Color), Attribute Value 1, Attribute Name 2 (Bra Size or Size), Attribute Value 2, Quantity in Stock, Custom Field 1, Custom Field 2. • The file is saved (and overwritten each run) to a path I can configure in module settings, e.g. C:\OdooExports\prestashop_stock.csv. Technical expectations – Pure Odoo code: Python, XML, scheduled action (ir.cron), ORM queries only. – No external services or SaaS; everything runs on the local Windows install. – Follow Odoo coding guidelines so the solution survives future minor upgrades. – A button "execute now" to run the export at any time Deliverables 1. Installable Odoo v18 module (zip or Git repo). 2. Brief README showing installation steps, how to change the export path and how to adjust the run time if needed. 3. A short test confirming that products without the “Export Presta” tick or with zero/negative stock are excluded. Once delivered I will install it on our staging database and verify that tomorrow’s 9 PM run produces the expected CSV in the chosen directory.