Product Import Module in Odoo
This module intended to import the products to a database with different field values mentioned as per a CSV Sheet. The menu for product import can be located as Purchase -> Import Product, which will result into a wizard pop up as shown below in the screenshot.
The products are imported based on the file that have selected. The constraints while uploading a file to import products are:
- The file should be of CSV Format.
- The column names that are mandatory are
- Template Internal Reference
At Least these two columns must be present in the selected csv file
It is also possible to specify the following columns with their values:
- Sales Price
- Arabic Character
The products imported will be Stockable with can be purchased and can be sold boolean fields checked.
- If we have “Template Internal Reference” column in the csv file, then on importing product, as usual product creation, one product template and one product variant related to the Product Template will get created (normal process). It should be noted that before creating a product, we will search for products in the database with Internal Reference as the ‘Template Internal Reference’ Value. If such a product exists, we will only update the field values based on the csv column values, to the existing product.
It is also possible to import product with their variants using this module.This is possible by specifying ‘Variant Internal Reference’ column in the csv file, along with ‘Template Internal Reference’ column , so that we will create a Product Template (if not already exists), and create product variants with field values same as that of its product Template but with a different Internal Reference. Upon importing Product Variants, we should define a Attribute column (Size, Color etc) , with its values.
Sample csv file format shown below:
Purchase Order Creation
we can also specify whether to create a purchase order with purchase order lines as the products mentioned with the csv file , by checking/unchecking the create purchase Boolean field. If we check the ‘Create Purchase’ Boolean , we will have to specify two more fields in the wizard, i,e. Purchase Date & Supplier
While importing Purchase Order, we will have to define two more columns additionally in the csv file, which are:
- Unit Cost
These column values will get passed to the ‘Quantity’ & ‘Unit Price’ fields in the purchase order lines.
Price list Import
It is possible to import the products mentioned in the csv file to a price list already present in the database. This is possible by checking the ‘Import Pricelist’ boolean in the wizard. Then we will find all the price lists in the database and check whether the csv file trying to import, contain any of the pricelist name as column header. If not will raise a warning message to specify the price list column in the csv file. If the price list column mentioned in the file, then the products will get imported to that pricelist specified with a fixed price defined in the pricelist column values.
An example shown below: