EDI Odoo Integration (FTP/SFTP/AS2 - Import/Export Records) |
Community Enterprise Odoo.sh |
Bridge the gap between Odoo and your trading partners with an all-in-one EDI solution supporting FTP, SFTP, and AS2 protocols. This module features a dynamic XML mapping engine that gives you the power to import, export, create, or update any Odoo record without a single line of code. Beyond simple file transfers through FTP/SFTP, you can manage secure file transfer with AS2 protocol directly from Odoo, handle MDN acknowledgments, and automate the entire workflow via scheduled actions. Whether you are syncing folder structures from remote directories or managing high-security file transfer, this tool ensures accurate, automated, and bidirectional data flow for any Odoo model.
01 Applications on Dashboard
After downloading the Odoo EDI Integration App from the Odoo store, place it in the Odoo Addons path or any desired location. Restart your Odoo instance and go to the Apps section in the dashboard. Click on "Update Apps List" from the menu. Once the list is updated successfully, the Odoo EDI Integration app will appear in the Apps section.
Click the "Install" button, and you're all set! You can now use the Odoo EDI Integration app in your Odoo instance.

02 FTP/SFTP Configuration (From menu Sync FTP/SFTP/AS2 Syncing)
You need to set up FTP syncing connection by entering the URL, port, username, and password.
After entering the proper details, the right-side ribbon indicates whether your FTP connection is properly configured or not.

You need to set up SFTP syncing connection by entering the Host, username, password, host. Additionally you need to enter root directory path, so we will import inner all directories.
After entering the proper details, the right-side ribbon indicates whether your SFTP connection is properly configured or not.

03 Fetch Directories from FTP/SFTP
After successfully syncing with FTP/SFTP, you will see the 'Sync FTP/SFTP Directories' button. Clicking this button will fetch the directories from FTP/SFTP and create corresponding records in Odoo.

04 AS2 (Applicability Statement 2) Configuration
If you would like to use the AS2 protocol please follow steps below.

01 Integration Steps
02 1. EDI Table integration (From EDI menu)
You need to mention the required details for the incoming/outgoing table.
03 In Mapping XML Elements with Fields table
04 Main Table

05 Sub Table

06 Contact Sub Table for Is Address Field

07 2. Import Records Process (From FTP/SFTP to Odoo)
Fetch Inner files/attachments from directories through button "Sync Inner Files"
We have also provided a scheduled action option for automation. A scheduled action will be created for each FTP/SFTP configuration, and you can review it using the smart button within the form view. You can configure the execution time according to your requirements.
Before pressing the button or executing the scheduled action, certain configurations must be completed. The details are provided below.
First, in the directory list view, specify which directory will be used for the Download operation, so from those directory we will fetch inner files.
In the directory configuration, there's an option stating, "Daily new file coming in this directory". If a directory receives new files with the same name every day, and you need to fetch and process them in Odoo daily, you should enable this checkbox.

Second, in the directory itself you need to select Mapping Model/Table if you don't want to search using XML header.
We’ve added a feature that allows automatic mapping table search using an XML file’s header. Enable the "Search mapping table using XML header" option in the directory form view to support multiple file formats in one directory. Ensure the mapping table is configured for different XML headers.

08 After making these selections of download option & mapping Model/table you need to press 'Sync Inner Files' button, that process fetch inner files/attachments from the directories chosen for downloading will be fetched into Odoo, creating Odoo attachments.
Along with FTP/SFTP attachments, EDI transaction records will also be created. If you have received the file from the AS2 URL then, it will directly create the EDI transaction records. (Transaction records will be processed when the scheduled action executes.)

Additionally, we have implemented a directory-wise auto-sync feature. If you have numerous files across different directories that are marked for download, there is a possibility where the common scheduled action of sync inner files encounters timeouts due to Odoo's processing limits, resulting in incomplete synchronization.
To address this issue, we have provided an option to enable auto-sync on a per-directory basis. Simply click the "Generate Auto Sync" button in the desired directory, and the sync process will run individually for the files within that directory, ensuring complete synchronization. You can review it using the smart button within the form view.

09 3. To process EDI Transactions through Scheduled Action (Cron)
From the scheduled action, all EDI transactions in the draft state are processed based on the type.
On successful EDI transaction processed that record will move to the done state, if any issue arises then it will move into the failed state & log will generated to check issue.
10 Scheduled Action

11 Incoming record created of Sale Order

12 Incoming record created of Purchase Order

13 4. Log management
A log is created for reference in case of any faults during the import/export process.
We also set a scheduled action to delete log records older than 13 days.


14 5. Sample XML files
Sample Sale order file which gets imported from FTP.


01 1. Export Records Process (From Odoo to FTP/SFTP)
Firstly you need to do some configuration.
Inside FTP/SFTP Syncing form view you need to enable Upload option beside those directory in which you want to export files from Odoo to FTP/SFTP.

In Configuration table of type outgoing, you need to select partner whom records you need to export.bold text
Fields for Export only
Mapping XML elements level Fields

02 A scheduled action has been created to fetch export records based on the EDI Table configuration of the Trading Partner and Odoo Model, which will then create EDI transaction records in ‘Draft’ state. (Those records will be processed when the scheduled action executes.)


03 If something goes wrong or required field values are missing, those EDI transaction records will be set to a failed state, and a log will be generated for them. After rectifying the issue, you can recompute the XML content by clicking the 'Re-compute' button. Upon successful recomputation, the XML content will be available, and the state will change to draft.


04 2. To process EDI Transactions through Scheduled Action (Cron)
From the scheduled action, all EDI transactions in the draft state are processed based on the type.
On successful EDI transaction processed that record will move to the done state, if any issue arises then it will move into the failed state & log will generated to check issue.
Scheduled Action

Outgoing record: XML file is generated and exported to the configured FTP/SFTP directory.

05 3. Log management
A log is created for reference in case of any faults during the export process.
We also set a scheduled action to delete log records older than 13 days.


01 1. We are managing a distinct configuration setup for the import multiple records in a single file.
In Mapping XML Elements with Fields table
Main Table of Import multiple records in a file

Sub Table

Sub Table of Import Quants

Sample Product file which gets imported from SFTP & having multiple products data in single file.

Sample file of Import Quants

01 1. Main Table of Export multiple product records in a file

02 2. Export Multiple Product Records Process
We have given separate process for it, you need to click on 'Export Records' menu, a wizard like this will open.
You need to select mapping model of product variant which you created.
You can select single/multiple product records in products field.
Upon completion of the process, EDI transactions will be created for the Outgoing type. These transactions can be processed manually or automatically through a scheduled action.

|
|
I need an extra customization in this application, how can I get it?Yes, you can contact us on support@vrajatechnologies.com or can schedule a DEMO with our team to customize additional features. |
|
|
Is the application compatible with Odoo Enterprise and Community?Yes, this application module is supported by both. It is also compatible with test and production environments. |
|
|
Do I get free upgrades and support if I purchase this application?If there is a bug or any issues, our team will be there to help you out. If you need to add any new features, you will need to upgrade the application. |
|
|
Is technical knowledge required to set up the integration?While some technical understanding may be helpful, the integration is designed to be user-friendly. Detailed documentation and support may be provided to aid in the setup process. |
|
|
Is this free customization and implementation?Our team has produced a support video that guides you through the implementation process step by step. If you encounter any issues, please feel free to contact us for assistance. |
|
|
Which protocol you have used to transfer file?We have used FTP protocol to transfer files. |
|
|
Does this support all type of import records?Yes, mostly all types of records will supported, for import inventory we have given separate configuration that mentioned in documentation. |
|
|
Which file format supported?XML file format supported. |
|
|
From one directory currently 5 files are there & those imported in Odoo, next time when there are total 10 files(5 old and 5 new) that time if I fetch inner files from same directory is it create old records again in Odoo?No, we have managed that thing. Only new files will import in Odoo & from those files records will create. |
|
|
Once records exported from Odoo to FTP, is that export again?No, we have managed that thing. Those records which exported that not export again, system only pick fresh records next time. |
|
|
Included App Support90 Days Complimentary Support for Supported Versions If you encounter issues caused by the app itself, our team provides complimentary support for 90 days from the date of purchase for supported Odoo versions. |
90 Days Complimentary Support for Supported Versions
If you encounter issues caused by the app itself, our team provides complimentary support for 90 days from the date of purchase for supported Odoo versions.
Customer SupportNeed help with installation, configuration, technical issues, or general questions about the module? Submit a support ticket through our dedicated support portal. |
||
|
Support Portal
vrajatechnologies.com/helpdesk
|
Support PolicyReview our support policy for complete information about support coverage, issue eligibility, exclusions, version compatibility, and other support conditions. |
||
|
Support Policy
vrajatechnologies.com/support-policy
|
Scan for Support |
||
|
Support Portal
vrajatechnologies.com/helpdesk
|
A powerful Odoo import/export solution supporting CSV, TSV, XLSX, TXT, FTP/SFTP, and manual file upload for seamless data transfer. It offers dynamic mapping, default values, validations, filters, relational data handling, error tracking, and complete logging for reliable operations.
This module manages the complete transportation EDI workflow in Odoo, including 204 Load Tender, 990 Carrier Response, 214 Shipment Status, 210 Freight Invoice, and 820 Payment Order. It supports secure FTP-based communication with carriers and trading partners, enabling smooth shipment processing, tracking, billing, and payment data exchange.
Automates ANSI X12 EDI integration in Odoo by supporting export of EDI 850 Purchase Orders, 860 PO Changes, and 846 Product Inventory, along with import of 810 Bills, 856 ASN, 855 PO Acknowledgments, 997 Functional Acknowledgments, and 832 Vendor Pricelists. It ensures accurate data synchronization with trading partners using FTP protocols and ANSI 4010 format for secure, reliable, and streamlined EDI file exchange.
This module automates warehouse communication with third-party logistics providers using ANSI X12 EDI documents, including 943 Shipment Advice, 944 Receipt Advice, 940 Shipping Order, and 945 Shipping Confirmation. It supports secure FTP/SFTP file exchange to streamline inventory transfer, order fulfilment, shipment updates, and warehouse operations between Odoo and any EDI-supported 3PL partner.
This module automates trading partner communication by importing EDI 850/860 Purchase Orders into Odoo as Sales Orders and exporting EDI 855 PO Acknowledgments, 856 ASN, 810 Invoices, and 832 Sales Pricelists. It supports ANSI 4010 format and secure FTP-based data exchange, helping suppliers reduce manual work, improve order accuracy, and streamline EDI operations directly from Odoo.
This module automates the complete purchasing workflow, including ORDERS, ORDRSP, ORDCHG, DESADV, RECADV, INVOIC, REMADV, PRICAT, and INVRPT documents. It supports secure FTP/SFTP data exchange and EDIFACT D96A/D97A formats, helping businesses streamline supplier communication, order processing, delivery confirmation, billing, and payment updates in Odoo.
This all-in-one Odoo EDI solution connects Odoo with trading partners using FTP and SFTP protocols, with a dynamic XML mapping engine to import, export, create, or update any Odoo record without coding. It supports remote directory synchronization, scheduled automation, and reliable bidirectional data exchange across any Odoo model for accurate and streamlined business workflows.
This module automates B2B document exchange by importing ORDERS and ORDCHG into Odoo Sales Orders and exporting ORDRSP, DESADV, INVOIC, PRICAT, and INVRPT to trading partners. It also supports RECADV and REMADV processing with secure FTP/SFTP communication, helping suppliers reduce manual entry, improve accuracy, and streamline order, delivery, invoicing, payment, pricing, and inventory operations.
Explore Before Purchase |
Start with a free trial
Test the connector with your real workflows using our 15-day free trial. If you need help, our product experts will guide you throughout the trial.
|
|
Test the connector with your real workflows.Our product experts will guide you during the trial to help you evaluate, configure, and use the connector with confidence.
15-Day
Trial
Expert
Guidance
Real
Workflow Testing
|