Click to Chat

Blog Post

  • Home
  • Blogs
  • Import Product Template from CSV/Excel file v11
Import Product Template from CSV/Excel file

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

Videos

New Features


Easy to import custom fields.

Easy to import custom fields from CSV or Excel.

Easy to import Text, Integer, Float, Character, Boolean, Selection, Many2one, Many2many custom fields.

Features


Category import enhancement like - All / Saleable / Physical.

Download Sample CSV or Excel file from import wizard directly.

Easy to import.

Import CSV or Excel.

Import product by Name, Barcode, Internal Reference.

Import product image by path/URL. (Local URL means URL of your odoo server files location, please note it is not your odoo user local system path.)

Import "Qty On Hand".

No special configuration required, install it, use it.

This module saves your important time.

It reduces human efforts.

Version


v11.0.3 (11th February 2022)
  • Fixed Minor Bug Fixed.
v11.0.2 (06th April 2020)
  • Easy to import custom fields from CSV or Excel.
v11.0.1 (26th December 2019)
  • Initial Release.

First, you need to tick the "Import Product Template" group to import product template.


When you click the "Import Products" button, the wizard will open that 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.


The following fields are imported.


The following fields are imported.


The following fields are imported.


The following fields are imported.


Your CSV file must match like below.


Your Excel file must match like below.


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.


Custom Fields








Important Notes:


Don't remove the column from the sample sheet given, you can leave an empty column if the column is not the required type. You can see the table above for that.

Don't change the sample sheet column sequence.

Don't use excel if you don't know the column formatting part which is given in the sample sheet. Use CSV in this case.

Add Custom Fields or Non-Exist Standard odoo fields at the end, For adding those fields pls check the custom fields section.

Help & Support

You will get free 90 days support and assistance in case of any issues


Import Product Images from Excel (from Path and URL) v11

Transforming Businesses with Next-Gen Solutions

Our next-generation solutions are built to transform businesses and drive growth in the digital era.

Find Us

530, West Gate 2,
Ayodhya Chowk, 150 Feet Ring Road Rajkot, Gujarat 360006.

Contact No.

HR : +91 90232 46069
Sales : +91 93288 25451

Reach Us Read Blog Contact Us Submit Support Ticket Watch Video Tutorial