This is a simple format where a single file contains a single record.
Main mapping table of Sales order (sale.order)
Map the XML elements to their corresponding Odoo fields to ensure proper data integration and synchronization.
If it is a One2many field, such as ‘Order Lines,’ you need to create a sub-table for it and map it. In such cases, the sub-table should be created first, followed by the main table.
Sub mapping table of Sales order line (sale.order.line)
Map sales order line fields with XML element.
Sample of Product (In one file multiple records)
This format is different as it contains multiple records within a single file.
Main mapping table of Product (product.template)
To handle multiple records in a single file, the main table needs to be configured as shown below.
The repetitive XML tag associated with all products should be defined within the XML element and must be directly mapped to the sub-table.
Sub mapping table of Product (product.template)
In the sub-table, XML elements need to be mapped to the corresponding Odoo fields.
In the sub-table, you need to enter the 'Search record from this value' field value to prevent duplication.
Sample of Inventory (In one file multiple records)
This format is different as it contains multiple records within a single file.
This format contains multiple nested XML tags, followed by the main records tag.
Main mapping table of Quants/Inventory (stock.quant)
In ‘Mapping XML Elements with Fields,’ you can specify nested XML tags using /.
Additionally, if it is an inventory table, you need to select the ‘Inventory Location’ where the stock will be stored.
Sub mapping table of Quants/Inventory (stock.quant)
In import inventory you only need to add two fields i.e. product and quantity.
You must select the Inventory Location to specify the location where the inventory is being added or updated.
There's no need to include location mapping in the mapping table anymore, as it is now managed through the Inventory Location field.
Sample of Product (In one file multiple records)
This format is different as it contains multiple records within a single file.
An example demonstrating the concept of multiple nested XML elements.
Main mapping table of Product (product.template)
To handle multiple records in a single file, the main table needs to be configured as shown below.
The repetitive XML tag associated with all products should be defined within the XML element and must be directly mapped to the sub-table.
Sub mapping table of Product (product.template)
In the sub-table, XML elements need to be mapped to the corresponding Odoo fields.
If nested elements then you can specify nested XML tags using /.
In the sub-table, you need to enter the 'Search record from this value' field value to prevent duplication.
In search if you want to search with a nested type of element, you must include the nested XML tag using / in the search field.
EXPORT
Export Invoice (In one file one record)
Main mapping table of Journal Entry (account.move)
Sub mapping table of Journal Item (account.move.line)
Sample XML data prepared from the above mapping configuration
Export multiple records (In one file multiple records)
Main mapping table
The main export table supports exporting multiple records into a file, specifically for records that include the partner_id field—such as Sales Orders, Purchase Orders, Account Moves, etc. In this type of configuration, selecting a Trading Partner is mandatory.
To export multiple products in a single file, an additional field, ‘Export Multiple Records' XML Element Name’, is provided, which corresponds to the repetitive main tag for products.
For product variants specifically, the Trading Partner value is not required.
Sample XML data prepared from the above mapping configuration