IMPORT
Sample of Sale Order (In one file single record)
- 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 products (In one file multiple records)
Main mapping table of the Product Variant (product.product)
- For products specifically, multiple records can be exported in a single file.
- 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.
- Sample XML data prepared from the above mapping configuration