Comprehensive work on transferring business data between radically different versions of the system with full auditing and cleaning of the database structure (PostgreSQL).
Completed works:
Revision and cleaning of the structure: Complete removal of "historical clutter" and remnants of outdated modules, which allowed for the elimination of technical debt and conflicts during updates.
Intelligent migration of products: Not just copying, but a complete parsing of the catalog. Automated distribution of products into logical categories and subcategories for convenient navigation.
Working with CRM data: Secure transfer of the entire database of leads and contacts while preserving relationships and interaction history.
Updating inventory balances: Accurate transfer of current product balances at the time of migration to ensure continuity of trading processes.
Technical stack: Python (ETL scripts), PostgreSQL, Odoo API, SQL.
Result: The client received a "clean" system on the latest version of Odoo with up-to-date data, optimized product structure, and without unnecessary load on the database.
Completed works:
Revision and cleaning of the structure: Complete removal of "historical clutter" and remnants of outdated modules, which allowed for the elimination of technical debt and conflicts during updates.
Intelligent migration of products: Not just copying, but a complete parsing of the catalog. Automated distribution of products into logical categories and subcategories for convenient navigation.
Working with CRM data: Secure transfer of the entire database of leads and contacts while preserving relationships and interaction history.
Updating inventory balances: Accurate transfer of current product balances at the time of migration to ensure continuity of trading processes.
Technical stack: Python (ETL scripts), PostgreSQL, Odoo API, SQL.
Result: The client received a "clean" system on the latest version of Odoo with up-to-date data, optimized product structure, and without unnecessary load on the database.