How to Upload Multiple Products Into Odoo

The accurateness of Assay and Reports generated by an ERP lies in the abundant amount of information it consumes from the user.  ERP will store and process the consummate database of an system to go far at its conclusions.  Simply sometimes we have to import a new fix of data into the ERP to update older data sets or for some other purposes.  In Odoo, the user can import whatsoever kind of data in different formats. By default, Odoo allows data import on Odoo's any business organisation object using Excel (.xlsx) or CSV (.csv) formats.  The user can hands import details like contacts, products, bank statements, periodical entries, sales orders etc. to Odoo in any of the above formats.

Here I will explain the easiest way to follow for the successful importing of your valuable data. Earlier we motion on to the importing we need to know about data exporting from Odoo. Don't worry we already have a weblog on exporting in Odoo. You can refer to our previous blogs.

To import a set of data into Odoo, you lot only need to select the respective data file in .csv or .xlsx format and upload information technology. Simply the process may invite errors while mapping the fields of the file and Odoo database. To avoid such errors, the safest way is to export a sample information set of the model (eg: auction order) you wish to import information. Information technology will give you the template with correct data fields. Populate the exported file with new data and import equally usual. With this approach, you tin can easily map the fields and the possibility of data errors are minimized.

Hither I am going to explain this with an example information of Sale orders.

Steps  to follow :

1. Export a Sample Auction order

- Sales > Sale order > Activity > Export

- Consign the important details you lot need.

- Pick all the mandatory fields.

- Consign the contents in .csv format

2. Edit the contents of the exported '.csv' file and populate information technology with new information.

This will exist the format of the exported data file. Add the new data to the corresponding column.

If you want to import sales orders having several lodge lines; for each order line, you need to reserve a specific row in the CSV file. The first gild line will exist imported on the same row as the data relative to order. Any additional guild lines will need an additional row that does not have any information in the fields relative to the order.

three.Importing of Data

You can skip the previous ii steps because information technology is not important. You can avoid the chances of errors if you follow those steps.Instead of these steps, you tin directly import your information file onto odoo and map to its corresponding columns.

Notation: All the relational field such as customers, products, users etc.. need to be imported earlier importing Auction orders. This is the same for all objects.

Sales > Sale Orders > Import

When nosotros import our data, Odoo might not exist able to map information technology automatically if the label doesn't fit any of the fields in Odoo database. Don't worry! Yous tin map new columns manually when you examination the import. Search the listing for the corresponding field. If we don't map correctly, there will be the chance of getting errors.

Database ID and External ID

Some fields define a relationship with some other object. For example, suppose the country of a contact has a link to a tape of the 'Country' object. So when you lot import such fields, Odoo will have to recreate links between the different records. To avert complexities in mapping, Odoo provides 3 mechanisms. You must use one mechanism per field y'all want to import.

For example, to reference the state of a contact, Odoo proposes you 3 different

fields to import:

- State: The proper noun or lawmaking of the country

- Land/Database ID: The unique Odoo ID for a record, defined by the ID PostgreSQL column

- State/External ID: the ID of this record referenced in another application (or the .XML file that imported it)

For the country Belgium, you can apply one of these iii means to import:

- Country: Belgium

- Land/Database ID: 21

- Land/External ID: base.be

Co-ordinate to your demand, you should apply i of these iii ways to reference records in relations. Here is when you should utilise one or the other

- Use Land: This is the easiest way when your data comes from CSV files that have been created manually.

- Employ Country/Database ID: You should rarely use this note. Information technology'due south generally used by developers equally its primary advantage is to never have conflicts (you may have several records with the aforementioned name, but they always have a unique Database ID)

- Utilise Land/External ID: Use External ID when you lot import information from a third-party application.

When you use External IDs, you lot tin can import CSV files with the "External ID" column to define the External ID of each record y'all import. Then, yous volition be able to make a reference to that tape with columns similar "Field/External ID". The following ii CSV files give y'all an example of Products and their Categories.

When the Mapping is complete, yous tin validate the data. You tin import the data if in that location are no errors.

Now, you can become with the new data

nielsenprece1962.blogspot.com

Source: https://www.cybrosys.com/blog/how-to-import-data-in-odoo