Import Product Template from CSV/Excel file

About Module

This module is useful to product template with from CSV/Excel file. You can import custom fields from CSV or Excel.

New Features

  • 1) Easy to import custom fields.
  • 2) Easy to import custom fields from CSV or Excel.
  • 3) Easy to import Text, Integer, Float, Character, Boolean, Selection, Many2one, Many2many custom fields.


  • 1) Easy to import.
  • 2) import CSV or excel.
  • 3) import product by Name, Barcode, Internal Reference.
  • 4) import product image by path/URL.
  • 5) Import "Qty On Hand".
  • 6) No special configuration required, install it, use it.
  • 7) This module saves your important time.
  • 8) It reduces human efforts.


  • v13.0
  • v12.0
  • v11.0
  • v10.0
  • v9.0


1) You will receive the link to download the zip file of the module pls download it.

2) Extract the zip file, you will see a folder named ‘sh_import_product_tmpl’.

3) Copy and paste this folder inside your Odoo Addons path / Custom Addons Path.

4) Now, open the odoo as Developer Mode.

5) Go to Apps menu and click on ‘Update Modules List’, Press Update Button.

6) In the search bar, search ‘sh_import_product_tmpl’.

7) Click on ‘Install’ to install it.


 First, you need to tick the "Import Product Template" groups in order to import a product template.

"Import Products" menu in Products .

When you click the "Import Products" menu, the wizard will open and it looks like below.

Success message looks like below it shows successfully imported records and also provides a list of unimported records with row number in sheet and relative details of data invalidation.

following fields are imported.

Your CSV file format must match like below.

Your Excel file format must match like below.

Custom Fields

Custom fields format.

Product template import with many2many & custom selection fields.

Your Excel file must match like below and You can add custom fields column after last column as shown in the below image.

Your CSV file must match like below.