Shopify Integration

🎯 VERSION 2.0.29 - CRITICAL MULTI-ENTITY FIXES

Critical multi-entity bugs fixed + Accurate diagnostics + Enhanced GitHub workflow

🚨 CRITICAL BUGS FIXED
• BUG #83 MULTI-ENTITY: "Failed to fetch company" error blocking order synchronization resolved
• Entity-aware solution: SQL queries now filtered by entity to prevent cross-entity conflicts
• BUG #84 DIAGNOSTICS: Hardcoded version "2.0.27" in diagnostic JSON export fixed
• Dynamic version: Automatic version retrieval from module for accurate technical support
• Zero blockage: Multi-entity Dolibarr environments now 100% compatible

✨ ENHANCED PROFESSIONAL DIAGNOSTICS
• Complete JSON export: 47 checks + dynamic version for optimal technical support
• Color interface: Visual CSS classes for Shopify connection status (green/orange/red)
• Secure configuration: Export with automatic masking of sensitive keys (API keys, tokens)
• GitHub workflow: Anti-duplicate ZIP with tag vs version coherence validation

🔄 COMPLETE MULTI-ENTITY COMPATIBILITY
• Dolibarr multi-entity: Full support for complex installations with guaranteed data separation
• Smart filtering: Entity-aware customer queries for perfect environment isolation
• Backward compatibility: No impact on existing single-entity installations
• Robustness: Enhanced error handling + detailed logging for all environment types

📊 INHERITED FEATURES v2.0.28

Synchronization fixes + Universal Dolibarr compatibility + Advanced diagnostics

CRITICAL SYNCHRONIZATION FIXES (v2.0.28)
• HOTFIX BUG #80: Orders becoming "paid" after creation now automatically synchronized
• updated_at solution: Using updated_at_min instead of created_at_min + 24h security window
• BUG #81 COMPATIBILITY: getDolGlobalBool() error on Dolibarr v19-20 resolved with automatic polyfill
• Universality: Dolibarr v19/v20/v21+ universally supported with optimal performance

COMPLETE BIDIRECTIONAL COLLECTIONS (v2.0.26)
• Issue #70 resolved: Lost collections functionality completely restored
• Smart mapping: Dedicated robust llx_shopify_collections_mapping table
• 3 synchronization modes: Dolibarr → Shopify, Shopify → Dolibarr, Bidirectional
• Conflict resolution: 3 automatic strategies with administrative interface

GUARANTEED FIRST SYNCHRONIZATION
• Critical HOTFIX v2.0.25: Fixed first sync not retrieving recent orders
• Smart fallback: Automatic installation date with robust hierarchical logic
• Immediate impact: All new installations work correctly from start
• Total compatibility: No impact on existing synchronizations

🚀 MAIN FEATURES

AUTOMATIC BIDIRECTIONAL SYNCHRONIZATION
Products, variants, orders, customers, stocks, images, collections - Real-time GraphQL API sync

NATIVE MULTI-ENTITY MANAGEMENT
Full support for complex Dolibarr installations with guaranteed data separation

PROFESSIONAL ADMIN INTERFACE
Complete dashboard, intuitive configuration, expert 47-point diagnostics, detailed logs

ROBUST TECHNICAL ARCHITECTURE
Shopify GraphQL API, automatic retry, enhanced security, atomic transactions

🔧 MAIN PRESERVED FEATURES

Advanced product synchronization + Automated order management + Unified customers

Simple products and variants: Complete management of parent products and variations
• Configurable synchronization: Prices, descriptions, images, stocks, attributes by choice
• Multi-level pricing: Complete support for Dolibarr pricing with price level selection
• High-quality images: Automatic synchronization with WebP to JPEG conversion
• Hierarchical collections: Smart bidirectional mapping to Shopify collections

Automated order management
• Real-time import: Smart batch retrieval configurable with pagination
• Complete discount management: Support for promo codes and global discounts
• Precise VAT calculations: Weighted VAT and international tax management
• Synchronized statuses: Bidirectional order status updates
• Historical import: Installation date as automatic reference

Unified customer synchronization
• Centralized CRM base: Automatic import and updates from Shopify
• Complete addresses: Billing and shipping address synchronization
• Multi-entity management: Full support for multi-company environments

🚀 PERFORMANCE AND RELIABILITY v2.0.29

Critical fixes: Complete resolution of multi-entity bugs and diagnostics
• Universal compatibility: Automatic polyfill for all Dolibarr versions (v19-21+)
• Enhanced diagnostics: JSON export 47 checks + dynamic version
• Professional diagnostics: Complete interface for automated problem identification/resolution inherited from v2.0.27
• Modernized architecture: Migration to Dolibarr standards with optimized performance (+40%)

💼 ENHANCED BUSINESS ADVANTAGES

Lossless synchronization: Critical bug fixes ensuring no missed orders
• Multi-entity compatibility: Automatic adaptation to complex Dolibarr environments
• Complete diagnostics: Technical support with enhanced diagnostic JSON export
• Guaranteed performance: Modernized architecture with native cache (+40% speed)
• Unlimited scalability: Handling thousands of products/orders without interruption

🔧 TECHNICAL SPECIFICATIONS

Compatibility: Dolibarr 19-21+, PHP 7.4-8.3+
• API: Shopify Admin GraphQL 2024-07 with 4 new collections methods
• Database: MySQL/MariaDB with universal conditional queries
• Languages: French, English, German, Spanish, Italian (complete translations)
• Performance: Configurable batch processing for server optimization

📞 PROFESSIONAL SUPPORT

Developed by P'tite Tête Association, specialist in Dolibarr e-commerce solutions since 2021.

• Complete documentation: Integrated step-by-step configuration guide
• Technical support: Dedicated assistance via DoliStore with automated diagnostic JSON export
• Regular updates: Continuous evolution based on user feedback
• Dedicated site: shopifyintegration.ptitetete.com

Diagnose and synchronize your Shopify-Dolibarr systems with the most advanced solution!

AUTHOR: P'tite Tête
WEBSITE: https://shopifyintegration.ptitetete.com
SUPPORT: shopifyintegration@ptitetete.com
VERSION: 2.0.29 (2025-09-05)