The ERP system used is EULANDA® (www.eulanda.eu), which is based on a MySQL database and allows both read and write access. The online shop system is Gambio, which also operates on a MySQL database. Both systems therefore use compatible database technologies, enabling a direct, performant, and stable synchronization between ERP and shop. 1. Product Synchronization (EULANDA → Gambio) EULANDA is the master system for product data. Data to be transferred: Product number (SKU) Product name / description Sales price Tax class Stock quantity Active / inactive status Product images Functional requirements: Automatic detection of new or modified products Create or update products in Gambio Image transfer (FTP or database entry) Optional: category assignment 2. Order Import (Gambio → EULANDA) Gambio is the master system for online orders. Data to be imported: Order header (customer, address, payment method, shipping method, date) Order items (SKU, quantity, price, tax) Shipping costs, total amounts Functional requirements: Automatic import of new orders Customer matching or creation in EULANDA Creation of an order including all line items Reduction of stock levels in EULANDA Mark order in Gambio as “exported” 3. Status and Tracking Updates (EULANDA → GAMBIO) Data to be transferred: Order status changes (received, processing, shipped, cancelled) Tracking number Shipping date Functional requirements: Automatic detection of status changes in EULANDA Update order status in Gambio Insert tracking information into orders_status_history Trigger Gambio’s customer notification system 4. Stock Synchronization (EULANDA → GAMBIO) Functional requirements: Automatic transfer of current stock levels Optional rules: Stock = 0 → deactivate product Stock > 0 → activate product 5. Technical Requirements Both systems run on MySQL Interface should run as a background service or cron job Preferred programming languages: Python or PHP (other suggestions welcome) Logging of all actions (success/error) Robust error handling Documentation for installation and configuration 6. Expected Deliverables Fully functional interface Installation guide