This module is useful to import data from CSV/Excel file. You can import custom fields from CSV or Excel.
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.
Custom fields added into, import product template, import invoice lines, import customers/suppliers, import purchase order lines, import sale order lines from CSV/Excel modules.
Features
The separate group assigns to for mass import buttons view.
You can do mass import from one view.
The separate group assigns to for mass import buttons view.
Import Data Using CSV/Excel.
Skip error data and notify row no at the end of import.
Different Accessrights Groups.
Very well formated Excel and CSV files.
Well, documentation and Videos.
All-time support.
No special configuration required, install it, use it.
This module saves your important time.
It reduces human efforts.
Version
v11.0.3 (18th August 2020)
-
Import Product Template-Multi Barcodes.
Import Product Variants-Multi Barcodes.
-
1) You can import all the things at one place. You can do mass import from one view.
2)The separate group assigns to for mass import buttons view.
- Initial Release
New updates (v 11.0.2)
You can import all the things at one place. You can do mass import from one view.
The separate group assigns to for mass import buttons view.
v 11.0.1
Features
-
Import products/product templates from CSV or Excel.
-
You can import multiple barcodes for single products and product variants.
-
Import product by Name, Barcode, Internal Reference.
-
Import product image by path/URL.
-
Easy to import products with stock on-hand quantity.
-
Easy to import custom fields from CSV or Excel.
-
Easy to import Text, Integer, Float, Character, Boolean, Selection, Many2one, Many2many custom fields.
First, you need to tick the "Import Product Template" group to import product template.
"Import Products" menu in products.
When you click the "Import Products" button, the wizard will open, here you can choose the import file type(CSV/Excel), method(create product/create or update product), product update by(Barcode/Internal Reference), remove existing(If you tick this tickbox then remove existing barcode otherwise not) and file.
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 barcodes 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.
Custom fields format.
Product template import with many2many & custom selection fields.Custom fields format.
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.
Features
-
You can create or update product variants by barcode, name & internal reference.
-
You can import multiple barcodes for single products and product variants.
-
You can identify the same name product/product variant by "Unique Identification" fields.
-
Easy to import Product Variant (image, price, quantity, stock, etc) from CSV or Excel.
-
Easy to import custom fields with product variants.
-
You can import product images by image URL or local image path.
-
Easy to import products with stock on-hand quantity.
First, you need to tick the "Import Product Variants" group to import product Variant.
"Import Product Variants" menu
When you click the "Import Product Variants" button, the wizard will open, here you can choose the import file type(CSV/Excel), method(create product/create or update product), product update by(Name/Barcode/Internal Reference), remove existing(If you tick this tickbox then remove existing barcode otherwise not) and file.
You can create or update product variants by barcode, name & internal reference.
Success message looks like below it shows successfully imported records.
The following product template fields are imported.
We see the imported product "Collar T-Shirt" fields.
Product variants.
The "Sales" tab in the product "Collar T-Shirt".
The following barcodes are imported.
You can configure the product from here.
Product variant imported succesfully.
Using the "Variant" feature you can see product variant details.
Product variant details with qty on hand & UOM.
You can see the product variant field which is imported.
The following custom fields are imported (Text, Integer, Float, Character, Boolean, Selection, Many2one, Many2many custom fields are supported).
Your CSV/Excel file format must match like below.
In the "Can be sold & purchased?" take true by default if not provided.
In the "Product type" take consumable by default if not provided.
Take the same name as ERP in the "UOM".
Taxes are separated by comma(,).
Enter the same text of selection field the same as ERP in the"Invoice policy" otherwise by default it takes ordered quantities.
Variant attributes like color, size, or blank.
Enter the complete URL or local path in the "Image path/URL".
Enter the complete URL or local path in the "Image path/URL".
Multiple barcodes field.
You can import any number of custom fields.
All custom fields must exist on the product.product model.
You can import any number of custom fields.
All custom fields must exist on the product.product model.
Features
-
Easy to import.
-
import csv or excel.
-
import image by path/URL.
-
Custom fields added.
First you need to tick "Import Customers/Suppliers" groups in order to import customers/suppliers.
"Import Customers/Suppliers" menu in Orders.
When you click "Import Customers/Suppliers" menu, wizard will open and it's looks like below.
Success message looks like below it's shows successfully imported records and also provides 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.
The "GSTIN" & "Tags" custom fields are imported.
Your CSV file must match like below and You can add custom fields column after the last column as shown in the below image.
Your Excel file format looks like below.
Features
-
Easy to import.
-
import csv or excel.
-
import product image by path/URL.
-
Update product based on Barcode/Internal Reference.
-
Import "Qty On Hand".
-
Custom fields added.
First you need to tick "Import Product Template" groups in order to import product template.
"Import Products" menu in Products.
When you click "Import Products" menu, wizard will open and it's looks like below.
Success message looks like below it's shows successfully imported records and also provides 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 CSV file must match like below and add custom fields after the last column.
Your Excel file must match like below and add custom fields after the last column.
Features
-
Easy to import
-
import csv or excel
-
Add product by Name, Barcode, Internal Reference
-
Auto Confirm Sale option
-
Create customer if never exist option
-
Quotation/Order Number auto/as per sheet option
First you need to tick "Import Sale Order" group in order to import sale order
"Import Sale Order" menu in Orders.
When you click "Import Sale Order" menu, wizard will open that looks like below
Success message looks like below it's shows successfully imported records and also provides 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.
Features
-
Easy to import.
-
import csv or excel.
-
import product by Name, Barcode, Internal Reference.
-
Custom fields added.
First you need to tick "Import Sale Order Lines" group in order to import sale order lines.
"Import Sale Order Lines" button in sale order form view.
When you click "Import Sale Order Lines" button, wizard will open that looks like below.
Success message looks like below it's shows successfully imported records and also provides list of unimported records with row number in sheet and relative details of data invalidation.
following sale order lines are imported.
Your CSV file format must match like below.
Your Excel file format must match like below.
Custom Fields
Custom fields format.
Sale order line import from CSV sheets with many2many fields.
Your CSV file must match like below and add custom fields after the last column.
Your Excel file must match like below and add custom fields after the last column.
Features
-
Easy to import
-
import csv or excel
-
import stock inventory by product Name, Barcode, Internal Reference
First you need to tick "Import Inventory" group in order to import stock inventory
"Import Inventory" menu in Operations.
When you click "Import Inventory" menu, wizard will open that looks like below
Success message looks like below it's shows successfully imported records and also provides 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.
Features
-
Easy to import
-
import csv or excel
-
import stock inventory by product Name, Barcode, Internal Reference
-
import Lot/Serial Number and also create new Lot/Serial Number if never exist
First you need to tick "Import Inventory With Lot/Serial Number" group in order to import stock inventory with lot/serial number
"Import Inventory With Lot/Serial Number" menu in Operations.
When you click "Import Inventory With Lot/Serial Number" menu, wizard will open that looks like below
Success message looks like below it's shows successfully imported records and also provides list of unimported records with row number in sheet and relative details of data invalidation.
Following fields are imported.
New lot/Serial Number created if never exist.
Your CSV file format must match like below.
Your Excel file format must match like below.
Features
-
Easy to import
-
import csv or excel
-
import product by Name, Barcode, Internal Reference
-
Auto Confirm Order option
-
Create vendor if never exist option
-
Reference Number auto/as per sheet option
First you need to tick "Import purchase Order" group in order to import purchase order
"Import Purchase Order" menu in Purchase.
When you click "Import Purchase Order" menu, wizard will open that looks like below
Success message looks like below it's shows successfully imported records and also provides 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.
Features
-
Easy to import.
-
import csv or excel.
-
import product by Name, Barcode, Internal Reference.
-
Custom fields added.
First you need to tick "Import Purchase Order Lines" group in order to import Purchase order lines.
"Import Purchase Order Lines" button in RFQ/Purchase order form view.
When you click "Import Purchase Order Lines" button, wizard will open that looks like below.
Success message looks like below it's shows successfully imported records and also provides list of unimported records with row number in sheet and relative details of data invalidation.
following Purchase order lines are imported.
Your CSV file format must match like below.
Your Excel file format must match like below.
Custom Fields
Custom fields format.
Purchase order line import from CSV sheets with many2many & char fields.
Your CSV file must match like below and add custom fields after the last column.
Purchase order line import from Excel sheets with many2many & char fields.
Your Excel file must match like below and add custom fields after the last column.
Features
-
Easy to import.
-
import csv or excel.
-
import product by Name, Barcode, Internal Reference.
-
Auto Validate invoice/bill option.
-
import Customer/Vendor Credit Notes.
-
import invoice/bill.
-
Invoice/Bill Number auto/as per sheet option.
First you need to tick "Import Invoice" group in order to import Invoice.
"Import Invoice" menu in Customers.
When you click "Import Invoice" menu, wizard will open that looks like below.
Success message looks like below it's shows successfully imported records and also provides 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.
Features
-
Easy to import.
-
import csv or excel.
-
import product by Name, Barcode, Internal Reference.
-
import invoice/bill lines.
-
import Customer/Vendor Credit Notes lines.
-
Custom fields added.
First you need to tick "Import Invoice/Bill/Credit note Lines" group in order to import invoice/bill/credit note lines.
"Import Invoice/Credit note Lines" button in customer invoice form view.
When you click "Import Invoice/Credit note Lines" button, wizard will open that looks like below.
Success message looks like below it's shows successfully imported records and also provides list of unimported records with row number in sheet and relative details of data invalidation.
following invoice lines are imported.
You can also import customer credit note lines.
You can also import Vendor Bill lines.
You can also import vendor credit note lines.
Your csv file must match like below.
Your excel file must match like below.
Custom Fields
Custom fields format.
Account Move Line Import from CSV sheets with many2many fields.
Your CSV file must match like below and You can add custom fields column after 'Taxes' column as shown in the below image.
Import custom fields for Bills.
Your Excel file must match like below and add custom fields after the 'Taxes' column.
You May Also Like
