• Enable subscribed resellers to export product data (data + docs) from selected suppliers as CSV or via PrestaShop WebService
• Automate catalog synchronization between the European Sourcing database and reseller PrestaShop shops
• Manage a quota system to control export volumes per reseller
• Provide a complete validation workflow: request → confirmation → billing → execution → email delivery
• Support parallel execution of up to 6 simultaneous exports with robust process management (PID, kill, zombie detection)

• Revenue generation - exports are a billed service. The workflow explicitly includes invoice sending before triggering execution
• B2B client satisfaction - export quality and reliability directly impacts resellers' ability to populate their online shops
• Data volume - the system handles up to 500,000 product references with docs
• Multi-language support - exports manage 5 languages (FR, EN, DE, IT, ES)

B2B resellers using the module to populate their PrestaShop shops, promotional product suppliers (Anda, ELASTO FORM, KARL KNAUER, PAUL STRICKER, PORTIA, Troika, etc.), OVH (production hosting), Systonic (historical infrastructure, SVN server).

• Complete dual authentication system (resellers + administrators)
• CSV export module with automatic ZIP generation (data + docs)
• CSV export in PrestaShop-specific format
• PrestaShop WebService synchronization via REST/XML API
• Full export lifecycle management (asked → confirmed → running → scheduled/none/error)
• Admin interface with real-time process monitoring
• PrestaShop purge tools (products, categories, suppliers, brands, attributes)
• Per-reseller quota system (CSV and WebService separately)
• Multi-recipient email notification system
• Cross-platform category mapping engine (European Sourcing ↔ PrestaShop)
• Automatic zombie process detection and recovery
• Multi-language product data support (5 languages)
• PrestaShop multi-shop support
• Configurable incremental update system

• Direct revenue generation - each export is a billed service with integrated invoicing workflow
• Catalog capacity - system dimensioned for up to 500,000 product references
• Replaced a costly manual process - automated the integration of supplier catalogs into reseller shops
• B2B client enablement - resellers could automatically populate their PrestaShop e-commerce sites with up-to-date product data and docs

• First experience designing and building a complete B2B data integration platform end-to-end
• Mastered the PrestaShop WebService API (REST/XML) with all its quirks and undocumented behaviors
• Learned concurrent process management in PHP - PID tracking, zombie detection, deadlock prevention
• Developed deep understanding of B2B e-commerce workflows: quotas, billing integration, multi-language catalogs
• Strengthened MySQL skills with complex queries (subqueries, multi-table joins, FIELD ORDER)
• Gained experience managing a production system under real business pressure (billed service = zero tolerance for downtime)

• Clean modular architecture - clear separation between web interface (controllers/views) and CLI execution scripts, enabling background exports without blocking the UI
• Robust concurrency management - the multi-level limitation system (6 max, 3 per IP, 1 per URL) with MySQL deadlock detection demonstrates operational maturity gained through real production experience
• Zombie process detection - the /proc/PID verification mechanism is an elegant solution to detect stuck exports and automatically recover them
• Complete business workflow - the export lifecycle (asked → confirmed → running → scheduled → none/error) with email notifications at each step represents a well-implemented business process
• Quota system - fine-grained per-reseller quota management (CSV and WebService separately) shows understanding of B2B commercial constraints

• Security - authentication uses MD5 without salt (obsolete and vulnerable). Shell exec() calls with incompletely sanitized parameters (PID) present a command injection risk
• Framework technical debt - the custom mynd-framework, while functional, lacks the robustness and documentation of community frameworks (Symfony, Laravel)
• No application tests - the only tests present belong to the framework ORM. The export business code has no unit or integration tests
• Procedural CLI code - CLI scripts use many global variables and goto statements (labels mail:, nomail:), reducing maintainability
• No message queue - exports are managed via direct SQL queries rather than a proper queue system (RabbitMQ, Redis), limiting scalability

• Use a standard PHP framework (Symfony or Laravel) instead of a custom framework to benefit from the ecosystem, documentation, and community support
• Implement a proper message queue (RabbitMQ, Beanstalkd) for asynchronous export management
• Use bcrypt/argon2 for password hashing instead of MD5
• Add functional tests on the export workflow
• Set up a CI/CD pipeline to automate deployments
• Use a process supervisor (Supervisord) instead of managing processes directly from PHP code