1. Help Point
  2. Personalized ERP Integration

Import and export of product data in ERP

Streamline your inventory management with the flexible product data import and export features in our ERP system.

Export product data

  1. Log in.
  2. Select the Inventory module. 1
  3. Navigate to the Products submenu and select the Products option. 2
  4. Select List view of the products. 3
  5. Select the specific product(s) you wish to export. 4.1
  6. Click the Actions button and select Export. 4
  7. Complete the process by pressing the Export button. export product

Customize the export report by selecting the fields to be included or excluded and the format you want it exported to - XLSX or CSV. 6

Important: If you select the I want to update data option the system will automatically adjust the Available Fields and Fields to export to the fields that allow updates, removing the ones that don't. Useful for importing data when you want to update information on an existing product. This option includes an ID field in the exported file that corresponds to the existing product ID, so the system recognizes which product to update.

 

Import product data

Steps to import product data:

  1. Go through the previous navigation steps (1-4) again.
  2. Click the Favorites button and select Import records from the available options. 1.1
  3. Upload a file in CSV or XLXS format, verifying that the fields contain valid information (e.g., making sure the category exists). 2.1

Once the file is uploaded, a new form will appear that contains information about the mapping between the file columns (File Column) and the ERP system fields (Odoo Field), as well as 4 possible actions to take with the import file: 3.1

  • IMPORT - this button will trigger the import of the uploaded file.
  • TEST - this button will run a test to verify that all fields are filled in and mapped correctly. 5.1If any of the information in the file is missing or incorrect, a system message will indicate the type of error. 5.2

Note: When mapping the fields, sometimes there may be a difference between the name in the file and the name in the ERP system. In this case, select an option from the drop-down menu that matches the field name in the ERP.

 6.1

If all the information in the file is correct, a system message will indicate that the file is ready for import.

  • LOAD FILE - this button allows you to select a file to import (after making corrections to the file, as prompted by the system message previously).
  • CANCEL - this button will cancel the import operation.
5.    Finalize the process by clicking the Import button. 6.22