Community
Enterprise

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 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