• Product Synchronization:
  • Automatically sync product data (name, descriptions, images, prices, etc.) from Odoo to Magento
  • Support for configurable, simple, bundle products etc.
• Category Synchronization:
  • Sync product categories from Odoo to Magento.
  • Ensure consistency by seamlessly transferring product categories from Odoo to Magento.
• Stock Level Sync:
  • Real-time inventory updates between Odoo and Magento to prevent stock discrepancies.
• Attribute Sync:
  • Sync product attributes from Odoo to Magento for uniform attribute details.

Note: Radio buttons and multi-checkboxes are considered custom options in Magento, not attributes.

• Order Status Sync:
  • Keep order statuses updated, including fulfilment, payment, and shipping details.
• Order Invoice and Credit Memo Synchronization:
  • Import Magento orders into Odoo in real-time.
  • Sync order status updates from Odoo to Magento.
  • Maintain order history and transaction details.
  • Synchronize invoices and credit memos.
• Customer Data Sync:
  • Sync customer details (name, email, shipping address) from Magento to Odoo.
  • Maintain customer address information.
  • Prevent duplicate customer records with unique identifiers.
• Payment Method Synchronization
  • Sync payment methods from Magento to Odoo.
  • Map payment transactions and reconcile financial records.
• Shipping Method Synchronization
  • Sync shipping methods and carriers from Magento to Odoo.
  • Maintain tracking details and shipping rates.
• Synchronization Logs
  • Maintain detailed logs of all synchronization activities.
  • Track successful and failed synchronization attempts.
  • Error logging with descriptive failure messages.
  • Timestamped records for tracking sync history.
  • Filter logs by entity type (products, categories, orders…).
  • In Magento, even if a sync log fails, the cron runs every minute and will retry the synchronization based on the configured retry count.
• Seamless Integration:
  • User-friendly interface for easy integration without requiring advanced technical skills.
• Real-Time Sync:
  • Instant updates across both platforms to maintain accurate and consistent data.
• Automated Updates:
  • Changes to products, categories, or attributes in Odoo are automatically pushed to Magento, reducing manual effort.

• Improved Efficiency:
  • Automates manual processes, reducing errors and increasing operational efficiency.
• Consistent Data Across Systems:
  • Ensures product, stock, customer, and order data remain uniform across Odoo and Magento.
• Better Inventory Management:
  • Real-time stock updates prevent overselling and display accurate inventory levels.
• Time and Cost Savings:
  • Eliminates manual data entry, saving time and labour costs.
• Enhanced Customer Experience:
  • Accurate product and order details lead to a smoother shopping experience.
• Centralized Management:
  • Odoo serves as a central hub for managing products, orders, stock, and customers.
• Faster Order Processing:
  • Orders from Magento sync directly to Odoo, streamlining fulfilment and processing.
• Minimized Risk of Data Inconsistencies:
  • Reduces errors from manual data entry, ensuring data is always up to date.
• Easy Integration and Maintenance:
  • Simple setup and minimal maintenance make it accessible for non-technical users.
• Better Reporting and Analytics:
  • Synchronization of order and customer data enables improved insights and reporting.

• Magento 2.4.7
• No third-party modules required.

• The Odoo – Magento Connector Plugin is distributed as a package containing two separate modules: one for Magento and one for Odoo.
• Unzip the downloaded file. You will find two folders inside: Magento and Odoo.
• Open the Odoo folder, copy all its contents (folders and files), and paste them into your Odoo custom add-ons directory.
• Open the Magento folder, copy all its contents (folders and files), and paste them into the app/code directory of your Magento installation on the web server.
• Run the following commands from the SSH terminal of the Magento server to complete the installation.
  • Enable the module - php bin/magento module:enable Pits_OdooConnector
  • Update the database schema - php bin/magento setup:upgrade
  • Generate and pre-compile classes - php bin/magento setup:di:compile
  • Deploy static files - php bin/magento setup:static-content:deploy
  • Clear the cache – php bin/magento cache:flush
•  Configure API access and credentials in Magento Admin under Stores > Configuration > PITS Odoo Connector.

• Navigate to the Apps section in Odoo.
• Use the search bar to look for "Odoo Magento Connector".

• Click the "Activate" button on the search result to enable the connector.

The General section in the Magento Odoo Connector configuration contains the essential settings required to establish a connection between Magento and Odoo.

• Enable Odoo Connector – This option allows the administrator to enable or disable the Odoo Connector. When enabled, Magento can communicate with Odoo for data synchronization.
• Odoo URL – This field is used to specify the base URL of the Odoo instance. The connector will use this URL to send and receive data from Odoo.
• API Username - Enter the Odoo API username for authentication.
• API Password - Enter the Odoo API password. This will be used to obtain a bearer token required for secure communication with Odoo.
• Database Name - Enter the name of the Odoo database used for login.
• Test Connection (Button) - A Test Connection button is now available to verify if the provided credentials can successfully connect to the Odoo instance. After entering the URL, username, password, and database name, click Test Connection to ensure connectivity after saving the configuration.
• Maximum Allowed Cron Failures – The setting is used to manage real-time synchronization tasks. When a Cron job fails consecutively during real-time synchronization, it will attempt to rerun after reaching the specified threshold of allowed failures.

• User: Can only view data available from the Magento sync.
• Admin: Can configure Magento settings and manage data synchronization.
• Technical Admin: Has all Admin permissions plus access to view synchronization logs.

• Navigate to Settings
• Enable developer mode by clicking on the ‘Activate the developer mode’.
• Navigate to User & Companies menu -> Select Users.
• Open the desired User -> Select the role in the Odoo Magento Connector.

• Access the Magento Connector Menu
  • In Odoo, navigate to the Magento Connector from the main menu.
• Enter Magento Store Details
  • In the Magento Connector interface, enter your Magento Store URL, API Username and API password to authorize API access.
• Establish Secure Communication
  • Once the correct Magento URL, API Username and API password are provided, Odoo will securely communicate with your Magento store, allowing synchronization of products, orders, and customer data.
  • Click on the Test Connection button to check the connection to Magento.

• Default Attribute Set
  • Specify the Magento Attribute Set to be used when syncing products from Odoo that do not have a specific attribute set assigned.
• Default Attribute Group
  • Define the default Attribute Group under which attributes will be organized in Magento during sync.
• Default Warehouse
  • To sync product stock levels from Odoo to Magento, you must specify the default warehouse in Odoo. The quantities available in this warehouse will be used to update stock levels in Magento.

• Product Sync – Sync product details, images, and pricing.
• Category Sync – Ensure category consistency across both platforms.
• Stock Level Sync – Keep inventory updated in real time.
• Order, Invoice and credit memo Sync – Transfer customer orders, invoices and credit memos from Magento to Odoo.
• Customer Sync – Maintain updated customer records.
• Order Status Sync – Keep fulfillment, payment, and shipping status aligned.

By configuring these provisions, you ensure seamless data flow between the two platforms.

• Navigate to the Magento connector app in Odoo
• Click the Sync Store data
• To Sync all the Store Data such as Websites, Stores and Store Views, click the sync Store Data button
  • Navigate to Magento Sync > Magento Website
    All Magento Website data will be stored and visible in this section
  • Navigate to Magento Sync > Magento Stores
    All Magento Stores data will be stored and visible in this section
  • Navigate to Magento Sync > Magento Store view
    All Magento Store view data will be stored and visible in this section.

This section enables the synchronization of various Magento data into Odoo, ensuring data consistency across both platforms.

Available Options:

• Sync Attribute Set – Import product attribute sets from Magento to Odoo for uniform product specifications.
• Sync Tax Rates – Transfer tax rates from Magento to Odoo for accurate tax calculations.
• Sync Customers – Sync customer details (name, email, address, etc.) from Magento to Odoo for streamlined order management.
• Sync Payment Methods – Import payment methods configured in Magento to Odoo, ensuring payment options align when processing orders.
• Sync Shipping Methods – Transfer available shipping methods and carriers from Magento to Odoo for efficient shipment management.
• Sync Order Status – Keep order statuses updated in Odoo to ensure consistency in tracking order progress.
• Sync Categories – Import and sync product categories from Magento to Odoo to maintain a consistent category tree.
• Sync Attribute Group – Import attribute groups from Magento to Odoo to maintain proper attribute organization.

Available Options:

• Sync Products – Transfer product information (name, description, price, etc.) from Odoo to Magento, keeping your online store updated.
• Sync Categories – Sync product categories from Odoo to Magento to maintain a consistent category structure.
• Sync Attributes – Transfer product attributes (such as size, color, etc.) from Odoo to Magento for uniform product specifications.
• Sync Stock Transfers– Transfer shipment and delivery information from Odoo to Magento, ensuring accurate order status and tracking updates

• Access the Magento Connector
  • In Odoo, navigate to the Magento Connector menu.
• Go to Configuration Settings
  • Open the Odoo Magento Configuration section.
• Initiate Attribute Set Sync
  • Under Sync Data from Magento to Odoo, click the Sync Attribute Set button.
• Fetch Attribute Sets from Magento
  • The system will retrieve attribute sets from Magento and sync them to Odoo.
• View Synced Attribute Sets in Odoo
  • After syncing, all the Attribute Sets will be listed in the Default Attribute Set dropdown in Magento Configuration
• Mapping to a Default Attribute Set
  • Since Odoo does not have an exact equivalent of Magento’s attribute sets, the integration will map them to a default attribute set in Odoo, ensuring a smooth and structured synchronization.
  • Give the default attribute set in the Magento Configuration Default value.

• Access the Magento Connector
  • In Odoo, go to the Magento Connector menu.
• Navigate to Configuration
  • Open the Magento Configuration section.
• Initiate Attribute Group Sync
  • Under Sync Data from Magento to Odoo, click the Sync Attribute Group button.
• Fetch Attribute Groups from Magento
  • The system will fetch all available attribute groups linked to attribute sets in Magento.
• View Synced Attribute Groups in Odoo
  • After syncing, all the Attribute Groups will be listed in the Default Attribute Group dropdown in Magento Configuration
• Mapping for Structured Sync
  • Synced attribute groups help organize attributes during product sync. Odoo uses this structure internally for mapping Magento's product specifications

• Access the Website Module
  • In Odoo, navigate to the Website module.
• Go to eCommerce Categories
  • Click on eCommerce from the top menu.
  • Select eCommerce Categories from the available options.
• Add a New Category
  • Click on the Create button.
  • Enter the category name, description, and other relevant details.
• Update an Existing Category
  • Select the category you want to modify.
  • Edit the name, description, or other fields as needed.
• Save and Sync
  • Click Save to store the changes in Odoo.
  • The updates will be automatically synchronized to Magento via the connector.
• Verify in Magento
  • After synchronization, check your Magento store to confirm the updated category details.

In Magento configuration, located under Odoo Connector > Category Synchronization manages the categories sync between Odoo and Magento.

• Enable Category Synchronization – Allows category data to be synced from Odoo to Magento.
• Reset All Magento Categories and Sync from Odoo – Deletes all existing categories in Magento and fetches a fresh category structure from Odoo.
• Sync Category from Odoo (Button) – Triggers manual synchronization of categories from Odoo to Magento.

• Access the Sales Module
  • In Odoo, navigate to the Sales module from the main dashboard.
• Go to Product Attributes
  • Click on Configuration in the Sales module.
  • Under Configuration, select Products.
  • Click on Attributes to manage product attributes.
• Create a New Attribute
  • Click the Create button.
  • Enter the attribute name and type (e.g., selection, pills, color).
• Configure Attribute Type
  • For selection, pills, or color options, configure them as attributes.
  • For radio buttons and multi-select fields, configure them as custom options (instead of attributes) in Magento.
• Save and Sync
  • Click Save to store the changes in Odoo.
  • When data is synced from Odoo to Magento, attribute distinctions are maintained:
    • Attributes (selection, pills, color) will appear as standard attributes in Magento
    • Custom options (radio buttons, multi-select fields) will betransferred as custom options in Magento when mapped to a product.
• Verify in Magento
  • After synchronization, check your Magento store to ensure attributes and custom options are displayed correctly.

The Attribute Synchronization section manages the synchronization of product attributes between Odoo and Magento.

• Enable Attribute Synchronization – This option allows the administrator to enable or disable the automatic synchronization of product attributes from Odoo to Magento. When enabled, Magento will fetch attribute data from Odoo as needed.
• Sync Attributes from Odoo – This button triggers a manual synchronization process, fetching all product attributes from Odoo and updating them in Magento. This is useful mass sync all attributes from Odoo.

• Access the Sales Module
  • In Odoo, navigate to the Sales module from the main dashboard.
• Go to Products
  • Click on Products under the Sales menu.
• Create a New Product
  • Click the Create button.
  • Enter the product name, description, price, and other relevant details.
• Configure Product Attributes
  • Select Attributes and configure them as required.
• Save and Sync
  • Click Save to store the product details in Odoo.
  • Once saved, the product is automatically treated as a configurable product in Magento.
  • Each product variant (e.g., different sizes or colors) will be synced as a simple product in Magento.
• Automatic Updates
  • Any updates made to the product name, description, price, or stock levels in Odoo will be automatically reflected in Magento.
• Verify in Magento
  • After synchronization, check the Magento store to confirm that the product and its variants are correctly displayed.

The Product Synchronization section handles the import and management of product data from Odoo to Magento.

• Enable Product Synchronization – This option enables or disables automatic product synchronization from Odoo. When enabled, Magento will receive product data updates from Odoo, ensuring consistency between the two platforms.
• Enable URL Key Error Handling on Product Creation – This setting manages URL key generation during product creation via the REST API. If enabled, Magento will handle potential URL key conflicts to prevent errors when importing products from Odoo.
• Sync Product from Odoo – This button triggers product mass synchronization from Odoo, where products will be sent from Odoo to Magento.

• Access the Magento Connector
  • In Odoo, navigate to the Magento Connector menu.
• Initiate Tax Rate Sync
  • Click Sync Data from Magento to Odoo.
• Fetch Tax Rates
  • In the Sync Data section, select Sync Tax Rates.
  • Navigate to Invoicing > Configuration > Taxes to check the synced tax rate
• Synchronization Process
  • The system retrieves tax rates from Magento and adds them to the Tax Rates section in Odoo.
• Automatic Updates
  • Any modifications to tax rates in Magento are automatically updated in Odoo.
• Verification
  • After synchronization, review the tax rates in Odoo to ensure they match those from Magento and are correctly applied to sales and invoicing.

The Tax Synchronization section manages the tax-related data sync from Magento to Odoo.

• Enable Tax Synchronization – When enabled, the option to manually sync tax data becomes available, but enabling this does not trigger automatic synchronization.
• Map Tax to Odoo (Button) – This button appears only when tax synchronization is enabled. Clicking it manually triggers the synchronization of tax rules and tax regions from Magento to Odoo, ensuring that the tax settings are updated as needed.

• Access Customer Management in Odoo
  • Navigate to the Sales module from the Odoo dashboard.
  • Under the Sales menu, go to Orders and click on Customers.
• Initiate Customer Sync
  • Open the Magento Connector menu.
  • Click Sync Data from Magento to Odoo.
• Fetch Customer Data
  • In the Sync Data section, select Sync Customers.
• Synchronization Process
  • The system retrieves customer details from Magento and creates corresponding customer records under Contacts in Odoo.
• Multiple Address Sync
  • The integration ensures that multiple shipping and billing addresses for each customer are added to Odoo, maintaining consistency and improving order fulfillment.
• Verification
  • After synchronization, review the customer records in Odoo to confirm that all details, including addresses, have been correctly imported.

• Enable Customer Synchronization – When enabled, customer data will be automatically synced from Magento to Odoo.
• Sync Customer to Odoo (Button) – Manually triggers the synchronization of all customer data from Magento to Odoo.

• Orders placed in Magento are automatically synced to Odoo.
• Status updates in Magento (e.g., payment confirmation) trigger corresponding changes in Odoo.
• In Odoo, synced orders can be found under Sales > Orders > Orders.
• Once confirmed in Odoo, a shipment is created. Upon validation, shipping status and tracking details are sent back to Magento.

• Enable Order Method Synchronization – When enabled, orders from Magento will be synced to Odoo.
• Enable Synchronization of Order Statuses with Odoo from the Order Status Grid – When enabled, any status changes in the Magento order status grid will be updated in Odoo.
• Enable Real-Time Order Method Synchronization – When enabled, orders will be instantly sent to Odoo upon creation or update.

• When an order is marked as "Completed" in Magento after successful payment, Odoo automatically creates a corresponding invoice, marked as "Paid".
• This ensures accurate financial tracking without manual intervention.
• To view the invoice in Odoo:
  • Navigate to Sales > Orders > Orders
  • Select the desired order
  • Click the Invoices button

• Enable Invoice Synchronization – When enabled, invoices generated in Magento will be synced with Odoo.
• Enable Real-Time Invoice Synchronization – When enabled, invoices will be sent to Odoo as soon as they are created.
• Sync Orders & Invoice Data to Odoo (Button) – Manually triggers the synchronization of orders and invoices from Magento to Odoo.

• When a credit memo is issued in Magento (due to refund or return), the order is marked "Closed".
• This triggers automatic creation of a credit notes in Odoo, reflecting the refunded amount and any returned product quantities.
• This process ensures accurate after-sales management and keeps financial records aligned.
• To view the credit note in Odoo:
  • Go to Sales > Orders > Orders
  • Select the relevant order
  • Click the Invoices button to see associated credit notes

• Enable Credit Memo Synchronization – When enabled, credit memos will be synced from Magento to Odoo.
• Enable Real-Time Credit Memo Synchronization – Sends credit memos to Odoo instantly upon creation.
• Sync Credit Memos to Odoo (Button) – Manually triggers synchronization of invoices first, followed by their associated credit memos.

• Navigate to Sales > Orders > Orders in Odoo.
• Open the Quotation and select the order.
• Click on the delivery button and validate.
• Once the validation is done, the shipment will be automatically synced to Magento if real-time sync is enabled.
• If real-time sync is disabled, then Navigate to Magento connector module in Odoo and then Sync Data - From Odoo to Magento.
• Click the Sync Shipment button, the shipment will be synced to Magento.

• In Odoo, navigate to Magento Connector.
• Click Sync Data from Magento to Odoo.
• In the Sync Data section, select Sync Shipping Methods.
• The system retrieves and imports shipping methods and carriers from Magento to Odoo.
• After synchronization, go to Magento Sync > Magento Shipping Carriers to map Magento Carriers to their Odoo Shipping Method.
• Once mapped, the shipping methods are available in Odoo for order processing.

• Enable Shipping Method Synchronization – When enabled, shipping methods from Magento will be synced to Odoo.
• Enable Real-Time Shipping Method Synchronization – When enabled, any changes to shipping methods in Magento will be instantly updated in Odoo.
• Sync Shipping Method to Odoo (Button) – Manually triggers the synchronization of shipping methods from Magento to Odoo.

• In Odoo, navigate to Magento Connector.
• Click Sync Data from Magento to Odoo.
• In the Sync Data section, select Sync Payment Methods.
• The system retrieves and adds Magento payment methods to Odoo.
• To verify, go to Invoicing > Configuration > Online Payments > Payment Methods in Odoo.
• The synced payment methods are now available for management in Odoo.

• Enable Payment Method Synchronization – Activates the payment method synchronization feature.
• Enable Real-Time Payment Method Synchronization – When enabled, any changes to payment methods in Magento will be instantly updated in Odoo.
• Sync Payment Method to Odoo (Button) – Manually triggers the synchronization of payment methods from Magento to Odoo. This action is required unless real-time synchronization is enabled.

• Go to the Magento Connector module.
• Navigate to Synchronization Log in the top menu.
• All the sync entries will be listed, click on any log to view its full details (including request, response, status, and timestamps).

• Enable Synchronization Logging – When enabled, all synchronization activities will be logged for tracking and debugging purposes.
• Enable Delete Log Using Cron – When enabled, logs will be automatically deleted at scheduled intervals using Magento’s Cron job system.
• Log Delete Cron Time – Specifies how often the Cron job should run to delete logs. Options include hourly, daily, etc.
• Select a Cron Time Interval – Allows selection of a specific interval for log deletion, ensuring automated cleanup at regular intervals.
• Day Interval for Clearing Logs – Defines the number of days after which logs should be deleted, starting from their creation date (e.g., setting 7 will remove logs older than a week).

• Navigate to Admin > ODOO CONNECTOR >Synchronization Logs in the Magento admin panel.
• The log grid displays all synchronization events with timestamps, statuses, and error messages (if any).

• Clear All Synchronization Logs: Clicking this button opens a confirmation popup. Selecting OK deletes all logs permanently.
• Delete Individual Logs: Use the Delete option in the Actions column to remove logs one by one.
• View Detailed Logs: Click the View link in the Action column to open a detailed synchronization log page

• Deletion sync retries are not supported – If a delete operation fails during synchronization, it must be handled manually.
• Mass Sync for Deletions Not Supported – Deleted records in Odoo or Magento cannot be manually re-synced; deletions must be handled directly in both systems.
• During mass synchronization, customers, orders, invoices, and credit memos are added to a queue and processed in batches using cron job. The cron processes 10 records at a time, ensuring efficient and controlled data transfer from Magento to Odoo.
• Ensure that locale settings such as time zone, language, currency, and number/date formats are consistent between Magento and Odoo. Mismatched locale settings may lead to data discrepancies during synchronization.
• MSI (Multi-Source Inventory) and multi-warehouse setups are not supported in the current integration. Only the default source and single-warehouse configuration are supported for product and inventory synchronization between Magento and Odoo.

• Compatible with Odoo Community Edition v18.0
• Compatible with Magento Open Source v2.4.7

• English
• German
• French
• Italian
• Other Magento and Odoo supported languages can be added.

• Version: 1.0.0: July 2025
  • Initial release.