ERP Labz Import Product Template

ERP Labz Import Product Template is a powerful Odoo module that allows you to import product templates from CSV or Excel files into Odoo. This module simplifies the process of bulk importing products with all their attributes, making it easy to set up your product catalog.

Key Features

• CSV Import: Import products from CSV files with customizable delimiters
• Excel Import: Import products from Excel (XLSX) files
• Flexible Field Mapping: Supports multiple field name variations (e.g., Name, Product Name, name)
• Update Existing Products: Option to update existing products or create new ones
• Comprehensive Field Support: Import all product attributes including prices, categories, UOM, etc.
• Error Handling: Detailed error logging for failed imports
• Import Logs: Track all import operations with success/failure statistics
• Header Detection: Automatic detection of header row in files
• Multiple Encoding Support: Supports UTF-8, Latin-1, and Windows-1252 encodings
• User-Friendly Interface: Easy-to-use wizard for importing products

Supported Fields

The module supports importing the following product fields:

Field Name	Alternative Names	Required	Description
Name	Product Name, name, product_name	Yes	Product name/title
SKU	Code, Internal Reference, default_code, internal_reference	No	Internal reference/SKU code
Barcode	EAN, ean, barcode	No	Product barcode/EAN
Sale Price	Price, price, list_price, sale_price	No	Sales price of the product
Cost Price	Cost, cost, standard_price, cost_price	No	Cost price of the product
Type	Product Type, type, product_type	No	Product type (product, service, consu)
Category	Product Category, category, categ_id, product_category	No	Product category name
Unit of Measure	UOM, uom, uom_id, Unit, unit_of_measure	No	Unit of measure name
Purchase Unit of Measure	Purchase UOM, purchase_uom, uom_po_id	No	Purchase unit of measure name
Weight	weight	No	Product weight
Volume	volume	No	Product volume
Description	Product Description, description	No	Product description
Sale OK	Can be Sold, sale_ok, sale	No	Can be sold (true/false)
Purchase OK	Can be Purchased, purchase_ok, purchase	No	Can be purchased (true/false)
Active	active	No	Product active status (true/false)

How to Use

1. Install the module from Apps menu
2. Go to Inventory → Products → Import Products
3. Click Import Products button
4. In the wizard:
   • Upload your CSV or Excel file
   • Select the file type (CSV or Excel)
   • Check "First row is header" if your file has headers
   • For CSV files, specify the delimiter (comma, semicolon, tab, etc.)
   • Choose whether to update existing products
5. Click Import button
6. Review the import results and check the import log for any errors

File Format Example

CSV Format:

Name,SKU,Barcode,Sale Price,Cost Price,Type,Category,Unit of Measure
Product A,SKU001,1234567890123,100.00,50.00,product,All / Saleable,Units
Product B,SKU002,1234567890124,200.00,100.00,service,All / Saleable,Hours
Product C,SKU003,1234567890125,50.00,25.00,consu,All / Saleable,Units
        

Excel Format:

Excel files should follow the same structure with the first row containing column headers.

Import Options

• Update Existing Products: When enabled, the module will update existing products based on Internal Reference (SKU) or Name. When disabled, it will only create new products.
• First row is header: Check this if your file's first row contains column names.
• CSV Delimiter: Specify the delimiter used in your CSV file (comma, semicolon, tab, space).

Import Logs

All import operations are logged with detailed information including:

• Total number of records processed
• Number of successful imports
• Number of failed imports
• Detailed error messages for failed records
• Import date and user information

You can view import logs at Inventory → Products → Import Logs

Technical Details

• Module Name: erpl_import_product_tmpl
• Dependencies: base, product, stock
• License: LGPL-3
• Category: Inventory/Product

Requirements

For Excel file support, you need to install the xlrd library:

pip install xlrd

Support

For support, feature requests, or bug reports, please visit our website:
Website: https://www.erplabz.com

Author Information

Author: ERP Labz
Company: ERP Labz
Maintainer: ERP Labz
Website: https://www.erplabz.com