Rebrickable LEGO Data Import and Optimization

We are looking for an ERPNext expert to handle the full import and optimization of LEGO inventory data into ERPNext 15. The project involves processing 12 structured CSV files to ensure accurate relationships between parts, sets, colors, and other attributes. The goal is to create a fully automated, dependency-aware database setup that supports 50,000+ products while maintaining high performance and data integrity.

IMPORTANT:
Only apply if you have actual experience with ERPNext. General ERP or data import experience is not sufficient.
Please review the Rebrickable CSV structure and dependencies here: https://rebrickable.com/downloads/. Understanding these relationships is essential for this project.

Data needs
-Import 12 CSV files containing LEGO parts, categories, elements, relationships, sets, and minifigs.

-Establish correct dependencies between various entities:

-Parts to Colors, Parts to Categories, Parts to Elements, Parts to Part Relationships

-Sets to Inventories to Inventory Parts, Minifigs to Inventory Minifigs, Themes to Sets

-Ensure accurate mapping of relationships without manual adjustments.

-Optimize database performance for 50,000+ products using indexing and efficient structuring.

-Automate the import process to support future updates.

-Include item condition fields: New, Used, Heavily Used, Scrap.