Import Product Template from CSV/Excel file-Multiple Barcodes
About Module
This module is useful to import a product template from CSV/Excel file. You can import custom fields as well from CSV/Excel file. You can import and manage multiple barcodes for single products and product variants. It will auto-create or update product template with image, price, quantity, stock, etc from CSV/Excel.
5) Go to Apps menu and click on ‘Update Modules List’, Press Update Button.
6) In the search bar, search ‘sh_import_product_tmpl_mb’.
7) Click on ‘Install’ to install it.
Workflow
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.
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.
Support
You will get free support and assistance in case of any issues