All In One Import - Partner, Product, Sales, Purchase, Accounts, Inventory, BOM, CRM, Project | Import Product Template | Import Product Variant | Import Product Image | Import Sale Order Lines | Import Reordering Rules| Import Purchase Order Lines

by
Odoo

114.47

v 15.0 Third Party 91
Required Apps CRM (crm)
Employees (hr)
Expenses (hr_expense)
Inventory (stock)
Invoicing (account)
Manufacturing (mrp)
Point of Sale (point_of_sale)
Project (project)
Purchase (purchase)
Sales (sale_management)
eCommerce (website_sale)
Website (website)
Included Dependencies
Lines of code 22921
Technical Name sh_all_in_one_import
LicenseOPL-1
Websitehttps://www.softhealer.com
Also available in version v 10.0 v 9.0 v 14.0 v 11.0 v 12.0 v 13.0
You bought this module and need support? Click here!
Required Apps CRM (crm)
Employees (hr)
Expenses (hr_expense)
Inventory (stock)
Invoicing (account)
Manufacturing (mrp)
Point of Sale (point_of_sale)
Project (project)
Purchase (purchase)
Sales (sale_management)
eCommerce (website_sale)
Website (website)
Included Dependencies
Lines of code 22921
Technical Name sh_all_in_one_import
LicenseOPL-1
Websitehttps://www.softhealer.com
Also available in version v 10.0 v 9.0 v 14.0 v 11.0 v 12.0 v 13.0
logo
Community Enterprise Odoo.sh

All In One Import - Partner, Product, Sales, Purchase, Accounts, Inventory, BOM, CRM, Project

heading

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

Features

heading
  • 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.
  • 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.
  • 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.
  • Custom fields added into, import product template, import invoice lines, import attendance, import bank statement lines, import employee timesheet, import lead, import task, import reordering rules, import customers/suppliers, import purchase order lines, import sale order lines, import Lot-Serial Picking, import variant, import vendor details in the product, import users, import journal items, import chart of accounts from CSV/Excel modules.

Important Notes

heading
  • 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.

You can import all the things at one place. You can do mass import from one view.

accordion_img_1

The separate group assigns to for mass import buttons view.

accordion_img_1

Features

heading
  • Easy to import employee expenses from CSV/XLS file.
  • You can import the expense sheet from CSV/XLS file.
  • Import expense employees by name, work phone, work email & badge ID.
  • Import expense products by name, internal reference or barcode.
  • You can download the sample file format.

Enable the "Import Expenses" group.


accordion_img_1

Click on the "Import Expense" menu.


accordion_img_1

After that, this wizard will open enter details and apply it. You can import expense or expense sheet from CSV/Excel file.


accordion_img_1

You can import expense employees by name, work phone, work email & badge ID and expense products by name, internal reference or barcode.


accordion_img_1

Success message looks like below it's shows successfully imported records.


accordion_img_1

Imported data with form view.


accordion_img_1

Your CSV/Excel/XLS file format must match like below.


accordion_img_1

Now we import expense sheet.


accordion_img_1

Imported data form view.


accordion_img_1

Your CSV/Excel/XLS file format must match like below.


accordion_img_1

Features

heading
  • Easy to import partner payments with payment details from CSV or Excel files.
  • Import partner by partner name, email, contact number, reference & database ID.
  • We provide "Auto Post" and "Auto Create Partner" options while importing.
  • Easy to import custom fields from CSV or Excel.
  • You can download the sample file format.

Enable the "Import Payments" group.

accordion_img_1

Click on the "Import Payments" menu.

accordion_img_1

After that, this wizard will open enter details and apply it. You can create auto partner & auto-post payments by enabling "Create Customer Customer/Vendor" & "Confirm Posted Payment".

accordion_img_1

Success message looks like below it's shows successfully imported records.

accordion_img_1

Imported data with list view.

accordion_img_1

Following fields are imported and state change to "Posted".

accordion_img_1

Now we enable"Create Customer Customer/Vendor" only so it not validate or post auto payments.

accordion_img_1

Success message looks like below it's shows imported records and validate records.

accordion_img_1

Imported data form view, here we did not enable "Confirm Posted Payment" so state not change.

accordion_img_1

Now we do not enable"Create Customer Customer/Vendor".

accordion_img_1

So it generates an alert message of a partner not found that does not exist, that looks like this.

accordion_img_1

Your CSV/Excel/XLS file format must match like below.

accordion_img_1

Custom fields format.


accordion_img_1

Features

heading
  • You can import COA(chart of account) from CSV/Excel file.
  • You can import a bulk chart of accounts in a single click.
  • Easy to import custom fields with the chart of accounts.
  • Download Sample CSV or Excel file from import wizard directly.

Enable the "Import Chart Of Account" group.

accordion_img_1

Click on the "Import Chart Of Account" menu.

accordion_img_1

After that, this wizard will open enter details and apply it.

accordion_img_1

Success message looks like below.

accordion_img_1

Following COA are imported, Imported data with list view.

accordion_img_1

Following fields are imported.

accordion_img_1

Your CSV file format must match like below.

accordion_img_1

Your Excel/XLS/XLSX file format must match like below.

accordion_img_1

You can import any number of custom fields. All custom fields format must same as this.

accordion_img_1

Custom fields format.

accordion_img_1

Features

heading
  • Easy to import invoices/bills with payment from CSV or Excel file.
  • Import product by name, barcode, internal reference.
  • You can import invoice with partial payment & fully paid.
  • We provide "Auto Post" and "auto Payment" option while importing.
  • You can download the sample file format.

Enable the "Import Invoice With Payment" group.

accordion_img_1

Click on the "Import Invoice With Payment" menu.

accordion_img_1

After that, this wizard will open enter details and apply it.

accordion_img_1

You can import invoice with the different payment method.

accordion_img_1

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.

accordion_img_1

Imported data with list view.

accordion_img_1

following fields are imported.

accordion_img_1

accordion_img_1

accordion_img_1

accordion_img_1

Your CSV file format must match like below.

accordion_img_1

Your Excel/XLS file format must match like below.

accordion_img_1

Features

heading
  • Easy to import internal transfers from the CSV or Excel.
  • You can import multiple internal transfers from a single sheet.
  • You can import internal transfers by product Name, barcode & internal reference number.

First, you need to tick the "Import Internal Transfer Advance" group in order to import internal transfers.

accordion_img_1

"Import Internal Transfer Advance" menu in the operations.

accordion_img_1

When you click the "Import Internal Transfer Advance" menu, the wizard will open that looks like below.

accordion_img_1

Success message looks like the below it shows successfully imported records.

accordion_img_1

Following internal transfers are imported.

accordion_img_1

The imported internal transfer form view with the source and destination location.

accordion_img_1

The imported internal transfer form view with the source and destination location.

accordion_img_1

Your CSV file format must match like below.

accordion_img_1

Your Excel file format must match like below.

accordion_img_1

Features

heading
  • Easy to import inventory from CSV or Excel file.
  • Import inventory by product name, barcode & internal reference number.

First, you need to tick the "Import Inventory Without Lot/Serial Number" group to import inventory without lot/serial number.

accordion_img_1

"Import Inventory Without Lot/Serial Number" menu in operations.

accordion_img_1

When you click the "Import Inventory Without Lot/Serial Number" menu, the wizard will open that looks like below.

accordion_img_1

Success message looks like below.

accordion_img_1

Imported records tree view.

accordion_img_1

The following fields are imported, the "Product Moves" smart button shows product moves.

accordion_img_1

Product moves without lot/serial number.

accordion_img_1

Product kanban view with on-hand quantity.

accordion_img_1

Your CSV file format must match like below.

accordion_img_1

Your Excel file format must match like below.

accordion_img_1

Features

heading
  • Easy to import journal entries from CSV or Excel files.
  • You can import multiple journal entries quickly.
  • You can import analytic accounts and tags with journal entries.

User Setting Enable group 'Import Journal Entries'.

accordion_img_1

Tick "Analytic Accounting Tags" & "Analytic Accounting" for import analytic accounts and tags with journal entries.

accordion_img_1

Import journal entries menu and tree view.

accordion_img_1

After clicking on the 'Import Journal Entries' one wizard will popup. Select a file type (CSV or Excel), accounting date, journal, company and upload the file.

accordion_img_1

After click to apply you see the success message of import.

accordion_img_1

As you can see the whole imported journal entries.

accordion_img_1

Imported records form view.

accordion_img_1

Your CSV file format must be like this.

accordion_img_1

Your Excel file format must be like this.

accordion_img_1

Features

heading
  • You can import sales pricelist from CSV/Excel file.
  • You can apply pricelist on the product, product variant & product category.
  • You can import pricelist by name, internal reference number & barcode.
  • You can compute price by fix price, discount wise, cost price, sales price or other pricelist.

Sale pricelist configuration.

accordion_img_1

Tick "Import Sales pricelist".

accordion_img_1

The import pricelist menu.

accordion_img_1

You can apply a pricelist on the product, product variant & product category by name, internal reference number & barcode. You can apply price computation by fixed price.

accordion_img_1

You can apply price computation by percentage wise or discount wise.

accordion_img_1

You can apply price computation by formula wise((sales price, cost price or other pricelist).

accordion_img_1

You can apply price computation by formula wise((sales price, cost price or other pricelist).

accordion_img_1

You can apply price computation by formula wise((sales price, cost price or other pricelist).

accordion_img_1

Success message looks like below.

accordion_img_1

Pricelist tree view with imported pricelist.

accordion_img_1

Imported pricelist form view.

accordion_img_1

It opens the popup with pricelist item details when you click on the product.

accordion_img_1

Imported pricelist form view.

accordion_img_1

Your CSV file must looks like below.

accordion_img_1

Your CSV file must looks like below.

accordion_img_1

Your Excel file must looks like below.

accordion_img_1

Your Excel file must looks like below.

accordion_img_1

Features

heading
  • Easy to import lot/serial picking from CSV/Excel file.
  • You can transfer a lot/serial pickings from one to other locations.
  • Easy to import custom fields.

Tick the group "Imports Lot/Serial Picking".


Import Lot Picking From CSV/Excel Workflow

Select "By Lots" in product 1.


The product 1 on hand qty is 0(Zero) now.


Product 1 demand qty is 10(Ten) and our done qty is 0(Zero). So we import lot/serial using the smart button that button is given besides "Done QTY".


After pressing that button this wizard opens, press the "Import Lot/Serial" button.


Select the import file type, choose the file type & select lot/serial type, and press the "Apply" button.


Success message looks like below.


After successfully imported picking our done qty is now equal to demand qty. Press the smart button that is given besides "Done QTY" to see detailed operations.


After pressing that button this wizard opens, you can see an imported lot/serial pickings here after press the "Confirm" button.


Now we press the "Validate" button and our stage is changed from ready to done.


Lot/Serial Numbers list view with imported lot/serial picking.


Now the product 1 on hand qty is changed.


Import Serial Picking From CSV/Excel Workflow


Select "By Unique Serial Number" in product 2 and the on-hand qty is 0(Zero) now.


Select the import file type, choose the file type & select lot/serial type, and press the "Apply" button.


Success message looks like below. If you choose the "Lot" in the lot/serial type and your product traceability is the Serial then it generates an alert for that and also If you choose the "Serial" in the lot/serial type and your product traceability is a Lot then it generates an alert.


Detailed operation wizard with the imported lot/serial picking.


Lot/Serial Numbers list view with imported lot/serial picking.


Now the product 2 on hand qty is changed.


Transfer Lot/Serial Picking Workflow

Select source and destination location, our product 1 qty demand is 5(five) and done qty is 0(Zero).


Press the "Import Lot/Serial" button to import lot/serial picking.


Select the import file type, choose the file type & select lot/serial type, and press the "Apply" button. When you transfer lot/serial picking, you have the option to create a lot/serial on the destination location.


After imported lot/serial pickings we validate the pickings.


Now we go to the "Locations" menu, select location & see current stock from the "Current Stock" smart button.


The "Current Stock" list view looks like this.


Your CSV/Excel format looks like below.


Your CSV/Excel format looks like below.


  • You can export multiple eCommerce product images in a zip file quickly.
  • You can export extra product eCommerce images.

User Setting: Just enable the 'Export Product Images eCommerce' option.

accordion_img_1

After enabling that option you can see this 'Export Images eCommerce' in action.

accordion_img_1

After click 'Export Images' this wizard will popup. Here in this wizard, you can see the list of selected products and options for an image where you can save image names like Name, Barcode, ID, Internal Reference, and click the 'Export' button. We provide export extra product media feature and "is export for import" option for importing the exported file in the system.

accordion_img_1

After click 'Export' you can see one file is created in 'zip', just click it and download it.

accordion_img_1

Extract that zip file.

accordion_img_1

Images successfully exported.

accordion_img_1

Images successfully exported.

accordion_img_1

Images successfully exported.

accordion_img_1

We provide the "Export Images eCommerce" option for product variants also.

accordion_img_1

You can export the eCommerce images for the product and product variants.

accordion_img_1

  • Easy to import product variant eCommerce category from CSV/Excel.
  • You can add extra product media in the eCommerce category.
  • You can import product variant (image, price, quantity, stock, etc) from CSV or Excel by barcode, internal reference, or name.
  • You can create or update product variants from CSV/Excel.
  • You can identify the same name product/product variant by "Unique Identification" fields.
  • You can import product images by image URL or local image path.
  • Easy to import products with stock on-hand quantity.
  • Very useful for mass records.

First, you need to tick the "Import Product Variants eCommerce" group.

accordion_img_1

"Import Product Variants eCommerce" menu.

accordion_img_1

After that one wizard open here you can import products with product variants From CSV/Excel.

accordion_img_1

You can create or update product variants by barcode, name & internal reference.

accordion_img_1

Success message looks like below it shows successfully imported records.

accordion_img_1

The following product template fields are imported.

accordion_img_1

We see the imported product "Collar T-Shirt" fields.

accordion_img_1

Product variants.

accordion_img_1

The "Sales" tab in the product "Collar T-Shirt".

accordion_img_1

The eCommerce category with extra product media.

accordion_img_1

You can configure the product from here.

accordion_img_1

Product variant imported succesfully.

accordion_img_1

Using the "Variant" feature you can see product variant details.

accordion_img_1

Product variant details.

accordion_img_1

You can see the product variant field which is imported.

accordion_img_1

The following custom fields are imported (Text, Integer, Float, Character, Boolean, Selection, Many2one, Many2many custom fields are supported).

accordion_img_1

Your CSV/Excel file format must match like below.

accordion_img_1

Your CSV/Excel file format must match like below.

accordion_img_1

Your CSV/Excel file format must match like below.

accordion_img_1

Your CSV/Excel file format must match like below.

accordion_img_1

You can import variant-wise cost.

accordion_img_1

Auto Create Record (Custom/Extra Fields)

Many2many fields:Many2many extra fields record auto-create option: This option useful to create a record if a record does not exist in many2many type of field. This option only applicable on custom fields or other extra fields which is not in the sample and which have a model with the only specified field as mandatory. if more than one field mandatory in the model then it can not be able to create a record.

Please tick this option during import to create record auto for many2many.

accordion_img_1

Result of auto-created record during import.

accordion_img_1

Sample sheet.

accordion_img_1



Product category field:Product category fields option useful to create a record if a record does not exist in the product category field.

Sample sheet.

accordion_img_1

Please tick this option during import to create a record auto for the product category.

accordion_img_1

Result of auto-created record during import.

accordion_img_1

Result of auto-created record during import.

accordion_img_1

  • You can import the bulk of eCommerce images from a zip file.
  • You can export extra product eCommerce images.
  • You can import images by name, reference, barcode & ID.

First, Tick the "Import Images From Zip File eCommerce" group.

accordion_img_1

Import images from the zip file eCommerce menu on the website.

accordion_img_1

Import images from zip file wizard.

accordion_img_1

Success message after import done.

accordion_img_1

Below eCommerce products, images are imported.

accordion_img_1

Below eCommerce products, images are imported.

accordion_img_1

  • 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.

accordion_img_1

"Import Products" menu in products.

accordion_img_1

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.

accordion_img_1

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.

accordion_img_1

The following fields are imported.

accordion_img_1

The following barcodes are imported.

accordion_img_1

The following fields are imported.

accordion_img_1

The following fields are imported.

accordion_img_1

The following fields are imported.

accordion_img_1

Your CSV file must match like below.

accordion_img_1

Your Excel file must match like below.

accordion_img_1

Custom fields format.

accordion_img_1

Product template import with many2many & custom selection fields.Custom fields format.

accordion_img_1

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

accordion_img_1

Your CSV file must match like below.

accordion_img_1

  • 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.

accordion_img_1

"Import Product Variants" menu

accordion_img_1

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.

accordion_img_1

You can create or update product variants by barcode, name & internal reference.

accordion_img_1

Success message looks like below it shows successfully imported records.

accordion_img_1

The following product template fields are imported.

accordion_img_1

We see the imported product "Collar T-Shirt" fields.

accordion_img_1

Product variants.

accordion_img_1

The "Sales" tab in the product "Collar T-Shirt".

accordion_img_1

The following barcodes are imported.

accordion_img_1

You can configure the product from here.

accordion_img_1

Product variant imported succesfully.

accordion_img_1

Using the "Variant" feature you can see product variant details.

accordion_img_1

Product variant details with qty on hand & UOM.

accordion_img_1

You can see the product variant field which is imported.

accordion_img_1

The following custom fields are imported (Text, Integer, Float, Character, Boolean, Selection, Many2one, Many2many custom fields are supported).

accordion_img_1

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".

accordion_img_1

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.

accordion_img_1

Variant attributes like color, size, or blank.
Enter the complete URL or local path in the "Image path/URL".

accordion_img_1

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.

accordion_img_1

You can import any number of custom fields. All custom fields must exist on the product.product model.

accordion_img_1

You can import variant-wise cost.

accordion_img_1

Custom fields format.

accordion_img_1

Auto Create Record (Custom/Extra Fields)

Many2many fields:Many2many extra fields record auto-create option: This option useful to create a record if a record does not exist in many2many type of field. This option only applicable on custom fields or other extra fields which is not in the sample and which have a model with the only specified field as mandatory. if more than one field mandatory in the model then it can not be able to create a record.

Please tick this option during import to create record auto for many2many.

accordion_img_1

Result of auto-created record during import.

accordion_img_1

Sample sheet.

accordion_img_1



Product category field:Product category fields option useful to create a record if a record does not exist in the product category field.

Sample sheet.

accordion_img_1

Please tick this option during import to create a record auto for the product category.

accordion_img_1

Result of auto-created record during import.

accordion_img_1

Result of auto-created record during import.

accordion_img_1

Features

heading
  • Easy to import point of sale product using CSV/Excel.
  • Easy to import bulk POS order.
  • You can import product using the name, reference number & barcode.
  • Very useful for mass records.
  • Very well formated Excel and CSV files.
  • If there is no customer created than it will create a customer.
  • Easy to install and use it, No more configuration required.
  • This module saves your important time.

First, you need to tick the "Import POS Order" group to import product.

accordion_img_1

"Import POS Order" menu in orders.

accordion_img_1

After that one wizard will open and it's looks like below.

accordion_img_1

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 product invalidation.

accordion_img_1

The following fields are imported.

accordion_img_1

Your CSV file format must match like below.

accordion_img_1

Your Excel file format must match like below.

accordion_img_1

Features

heading
  • Easy to use.
  • For product images, If you have a number of images and you want all images to import into Odoo then just rename image same as Product name/barcode/internal reference/id and put it into one folder then make a zip file and import.
  • For partner(customer/vendor) images, If you have a number of images and you want all images to import into Odoo then just rename image same as partner name/id/internal reference and put it into one folder then make a zip file and import.
  • For employee images, If you have a number of images and you want all images to import into Odoo then just rename image same as employee name/id/Identification No. and put it into one folder then make a zip file and import.

How to make a zip file.

accordion_img_1

First, Tick "Import Images From Zip File" group.

accordion_img_1

Import images from zip file menu in sale.

accordion_img_1

Import images from zip file wizard.

accordion_img_1

Success message after import done.

accordion_img_1

Below product images are imported.

accordion_img_1

Import partner images from zip file options.

accordion_img_1

Below partner images are imported.

accordion_img_1

Import employee images from zip file options.

accordion_img_1

Below employee images are imported.

accordion_img_1

Features

heading
  • User Setting: Just tick right 'Import Attendance'.
  • Easy to import attendance from CSV files.
  • Easy to import attendance from Excel sheet.
  • Import attendance based on Employee ID.
  • Import attendance based on Employee Badge.
  • Easy to download the exact formate of CSV or Excel files.
  • No special configuration required, install it, use it.
  • Custom fields added.
  • This module saves your important time.
  • This It reduces human efforts.

User Setting: Just tick right 'Import Attendance'.

accordion_img_1

In Attendance, there is a menu for 'Import Attendance'.

accordion_img_1

After click that menu this wizard will popup and select import file type(CSV/Excel File), select attendance import type(Employee ID/Badge) and after that upload file and click 'Apply'.

accordion_img_1

After click 'Apply' this success message will show with the total imported record.

accordion_img_1

Custom fields format.

accordion_img_1

Import custom character field "Information".

accordion_img_1

Your CSV/Excel file must match like below and You can add custom fields column after the 'Check Out Date & Time' column as shown in the below image.

accordion_img_1

Your CSV/Excel file format looks like below.

accordion_img_1

Features

heading
  • Easy to import users from CSV or Excel files.
  • You can import large records of users in Odoo from CSV or Excel files.
  • You can import users with a group name or ID.
  • Easy to install and use it, No more configuration required.
  • This module saves your important time.
  • Custom fields added.

Custom fields format.

accordion_img_1

You can import users with a group name or ID, If you give name then you have to follow the format "module category name/group name".

accordion_img_1

You need to tick the "Import Users" group to import the users.

accordion_img_1

"Import Users" menu in the Users & Companies.

accordion_img_1

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

accordion_img_1

Success message looks like below it shows successfully imported records.

accordion_img_1

The following users are imported.

accordion_img_1

User imported with extra rights.

accordion_img_1

After successfully import, the user can log in with id and password given in sheet, if you try with wrong details then comes alert.

accordion_img_1

Enter user details for login that given in sheet.

accordion_img_1

The login screen looks like below.

accordion_img_1

Features

heading
  • Enable group 'Import Journal Items'.
  • Easy to import journal items from CSV or Excel files.
  • Import journal items in a single click.
  • Easy to install and use it, No more configuration required.
  • This module saves your important time.
  • Custom fields added.

Custom fields format.

accordion_img_1

User Setting Enable group 'Import Journal Items'.

accordion_img_1

As you can see the button 'Import Journal Item' in Journal Entries form view.

accordion_img_1

After clicking the button 'Import Journal Items' one wizard will popup. Select a file type (CSV or Excel) and upload the file.

accordion_img_1

After click to apply you see the success message of import.

accordion_img_1

As you can see the whole imported journal items in line at journal entries.

accordion_img_1

CSV/Excel file formate must be like this.

accordion_img_1

Features

heading
  • 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.

accordion_img_1

"Import Customers/Suppliers" menu in Orders.

accordion_img_1

When you click "Import Customers/Suppliers" menu, wizard will open and it's looks like below.

accordion_img_1

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.

accordion_img_1

following fields are imported.

accordion_img_1

accordion_img_1

Your CSV file format must match like below.

accordion_img_1

Your Excel file format must match like below.

accordion_img_1

Custom fields format.

accordion_img_1

The "GSTIN" & "Tags" custom fields are imported.

accordion_img_1

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

accordion_img_1

Your Excel file format looks like below.

accordion_img_1

You can choose the customers/suppliers method, if you want to create new customers/vendors then choose "create customer/vendor" & if you want to update customers/suppliers then choose "create or update customer/vendor", You can update customers/suppliers by(name, email, phone, mobile).


accordion_img_1

Features

heading
  • 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.

accordion_img_1

"Import Products" menu in Products.

accordion_img_1

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

accordion_img_1

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.

accordion_img_1

following fields are imported.

accordion_img_1

accordion_img_1

accordion_img_1

accordion_img_1

Your CSV file format must match like below.

accordion_img_1

Your Excel file format must match like below.

accordion_img_1

Custom fields format.

accordion_img_1

Product template import with many2many & custom selection fields.

accordion_img_1

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

accordion_img_1

Your CSV file must match like below.

accordion_img_1

Features

heading
  • 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.
  • Easy to create and update product variants.
  • Download Sample CSV or Excel file from import wizard directly.
  • Very useful for mass records.
  • Very well formated Excel and CSV files.
  • Easy to install and use it, No more configuration required.
  • This module saves your important time.

First, you need to tick the "Import Product Variants" group to import product Variant.

accordion_img_1

"Import Product Variants" menu.

accordion_img_1

After that one wizard open here you can import products with product variants From CSV/Excel.

accordion_img_1

Success message looks like below it shows successfully imported records.

accordion_img_1

The following product template fields are imported.

accordion_img_1

We see the imported product A fields.

accordion_img_1

accordion_img_1

accordion_img_1

You can configure the product from here.

accordion_img_1

Product variant imported succesfully.

accordion_img_1

Using the "Variant" feature you can see product variant details.

accordion_img_1

Product variant details with qty on hand.

accordion_img_1

You can see the product variant field which is imported.

accordion_img_1

The following custom fields are imported.

accordion_img_1

Your CSV file format must match like below.

accordion_img_1

accordion_img_1

accordion_img_1

accordion_img_1

accordion_img_1

Your Excel file format must match like below.

accordion_img_1

You can import variant-wise cost.

accordion_img_1

Custom fields format.

accordion_img_1

Auto Create Record (Custom/Extra Fields)

Many2many fields:Many2many extra fields record auto-create option: This option useful to create a record if a record does not exist in many2many type of field. This option only applicable on custom fields or other extra fields which is not in the sample and which have a model with the only specified field as mandatory. if more than one field mandatory in the model then it can not be able to create a record.

Please tick this option during import to create record auto for many2many.

accordion_img_1

Result of auto-created record during import.

accordion_img_1

Sample sheet.

accordion_img_1



Product category field:Product category fields option useful to create a record if a record does not exist in the product category field.

Sample sheet.

accordion_img_1

Please tick this option during import to create a record auto for the product category.

accordion_img_1

Result of auto-created record during import.

accordion_img_1

Result of auto-created record during import.

accordion_img_1

Features

heading
  • Easy to import
  • import csv or excel
  • import product image by path/url
  • import/update product images by Name, Barcode, Internal Reference
  • Support both "Product Variants" and "Product Template" models

First you need to tick "Import Product Image" group in order to import product Image.

accordion_img_1

"Import Product Image" menu in Products.

accordion_img_1

When you click "Import Product Image" menu, wizard will open and it's looks like below.

accordion_img_1

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.

accordion_img_1

following Images are imported.

accordion_img_1

Your CSV file format must match like below.

accordion_img_1

Your Excel file format must match like below.

accordion_img_1

Features

heading
  • 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

accordion_img_1

"Import Sale Order" menu in Orders.

accordion_img_1

When you click "Import Sale Order" menu, wizard will open that looks like below

accordion_img_1

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.

accordion_img_1

following fields are imported.

accordion_img_1

accordion_img_1

Your CSV file format must match like below.

accordion_img_1

Your Excel file format must match like below.

accordion_img_1

Discount column added in CSV sheets so that column is imported when import sale order. Your CSV file format must match like below.

accordion_img_1

Discount column added in Excel sheets so that column is imported when import sale order. Your Excel file format must match like below.

accordion_img_1

Features

heading
  • 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

accordion_img_1

"Import Sale Order Lines" button in sale order form view.

accordion_img_1

When you click "Import Sale Order Lines" button, wizard will open that looks like below.

accordion_img_1

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.

accordion_img_1

following sale order lines are imported.

accordion_img_1

Your CSV file format must match like below.

accordion_img_1

Your Excel file format must match like below.

accordion_img_1

Custom fields format.

accordion_img_1

Sale order line import from CSV sheets with many2many fields.

accordion_img_1

Your CSV file must match like below and add custom fields after the last column.

accordion_img_1

Your Excel file must match like below and add custom fields after the last column.

accordion_img_1

Features

heading
  • 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

accordion_img_1

"Import Inventory With Lot/Serial Number" menu in Operations.

accordion_img_1

When you click "Import Inventory With Lot/Serial Number" menu, wizard will open that looks like below

accordion_img_1

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.

accordion_img_1

Following fields are imported.

accordion_img_1

New lot/Serial Number created if never exist.

accordion_img_1

Your CSV file format must match like below.

accordion_img_1

Your Excel file format must match like below.

accordion_img_1

Features

heading
  • Easy to import
  • Import csv or excel
  • Import product by Name, Barcode, Internal Reference
  • Custom fields added.

First you need to tick "Import Reordering Rules" group in order to import reordering rules

accordion_img_1

"Import Reordering Rules" menu, In master data.

accordion_img_1

When you click "Import Reordering Rules" menu, wizard will open that looks like below

accordion_img_1

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.

accordion_img_1

following fields are imported.

accordion_img_1

Your CSV file format must match like below.

accordion_img_1

Your Excel file format must match like below.

accordion_img_1

Custom fields format.

accordion_img_1

Reordering rules import from CSV/Excel sheets with Many2one & Text fields.

accordion_img_1

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

accordion_img_1

Your Excel file format looks like below.

accordion_img_1

Features

heading
  • 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

accordion_img_1

"Import Purchase Order" menu in Purchase.

accordion_img_1

When you click "Import Purchase Order" menu, wizard will open that looks like below

accordion_img_1

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.

accordion_img_1

following fields are imported.

accordion_img_1

accordion_img_1

Your CSV file format must match like below.

accordion_img_1

Your Excel file format must match like below.

accordion_img_1

Features

heading
  • 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

accordion_img_1

"Import Purchase Order Lines" button in RFQ/Purchase order form view.

accordion_img_1

When you click "Import Purchase Order Lines" button, wizard will open that looks like below.

accordion_img_1

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.

accordion_img_1

following Purchase order lines are imported.

accordion_img_1

Your CSV file format must match like below.

accordion_img_1

Your Excel file format must match like below.

accordion_img_1

Custom fields format.

accordion_img_1

Purchase order line import from CSV sheets with many2many & char fields.

accordion_img_1

Your CSV file must match like below and add custom fields after the last column.

accordion_img_1

Purchase order line import from Excel sheets with many2many & char fields.

accordion_img_1

Your Excel file must match like below and add custom fields after the last column.

accordion_img_1

Features

heading
  • Easy to import
  • Import csv or excel.
  • Import product by Name, Barcode, Internal Reference
  • Support both "Product Variants" and "Product Template" models.
  • Custom fields added.

First you need to tick "Import Supplier Info" group in order to import supplier info

accordion_img_1

"Import Supplier Info" menu in purchase.

accordion_img_1

When you click "Import Supplier Info" menu, wizard will open that looks like below

accordion_img_1

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.

accordion_img_1

following fields are imported.

accordion_img_1

accordion_img_1

Your CSV file format must match like below.

accordion_img_1

Your Excel file format must match like below.

accordion_img_1

Custom fields format.

accordion_img_1

Import custom character field "Information".

accordion_img_1

Your CSV file must match like below and add custom fields after the last column.

accordion_img_1

Your Excel file must match like below and add custom fields after the last column.

accordion_img_1

Features

heading
  • Easy to import
  • Import csv or excel
  • Import product by Name, Barcode, Internal Reference
  • Import Auto Validate invoice/bill option
  • 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

accordion_img_1

"Import Invoice" menu in Customers.

accordion_img_1

When you click "Import Invoice" menu, wizard will open that looks like below

accordion_img_1

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.

accordion_img_1

following fields are imported.

accordion_img_1

Your CSV file format must match like below.

accordion_img_1

Your Excel file format must match like below.

accordion_img_1

When you click the "Import Invoice" menu, the wizard will open, you have to choose an account as per requirement.

accordion_img_1

Your CSV file format must match like below.

accordion_img_1

Your Excel file format must match like below.

accordion_img_1

Features

heading
  • 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

accordion_img_1

"Import Invoice/Credit note Lines" button in customer invoice form view.

accordion_img_1

When you click "Import Invoice/Credit note Lines" button, wizard will open that looks like below.

accordion_img_1

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.

accordion_img_1

following invoice lines are imported.

accordion_img_1

You can also import customer credit note lines

accordion_img_1

You can also import Vendor Bill lines

accordion_img_1

You can also import vendor credit note lines

accordion_img_1

Your csv file must match like below

accordion_img_1

Your excel file must match like below

accordion_img_1

Custom fields format.

accordion_img_1

Account Move Line Import from CSV sheets with many2many fields.

accordion_img_1

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

accordion_img_1

Import custom fields for Bills.

accordion_img_1

Your Excel file must match like below and add custom fields after the 'Taxes' column.

accordion_img_1

Features

heading
  • Easy to import
  • import csv or excel
  • Custom fields added.

First you need to tick "Import Bank Statement Lines" groups in order to import bank statement lines.

accordion_img_1

"Import Bank Statement Lines" Button in bank statement form view.

accordion_img_1

When you click on "Import Bank Statement Lines button", import wizard will opened where you can upload csv/excel file and hit apply button.

accordion_img_1

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.

accordion_img_1

Imported bank statement lines looks like below.

accordion_img_1

Your CSV file format must match like below.

accordion_img_1

Your Excel file format must match like below.

accordion_img_1

Custom fields format.

accordion_img_1

Import custom character field "Information".

accordion_img_1

Your CSV/Excel file must match like below and You can add custom fields column after the 'Check Out Date & Time' column as shown in the below image.

accordion_img_1

Your CSV/Excel file format looks like below, You can add custom fields column after the last column.

accordion_img_1

Features

heading
  • Easy to import
  • Import csv or excel
  • Import product by Name, Barcode, Internal Reference

First you need to tick "Import Bill of Materials" group in order to import Bill of Materials

accordion_img_1

"Import Bill of Materials" menu in master data.

accordion_img_1

When you click "Import Bill of Materials" menu, wizard will open that looks like below

accordion_img_1

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.

accordion_img_1

following fields are imported.

accordion_img_1

Your CSV file format must match like below.

accordion_img_1

Your Excel file format must match like below.

accordion_img_1

When you click the "Import Bill of Materials" menu, the wizard will open that looks like below, here you can import product variants also when import bill of materials.

accordion_img_1

Your CSV file format must match like below.

accordion_img_1

Your Excel file format must match like below.

accordion_img_1

Features

heading
  • Easy to import
  • Different modes for import
  • Custom fields added.

First you need to tick "Import Project Task" groups in order to import project task.

accordion_img_1

Import Task menu in project.

accordion_img_1

default import wizard.

accordion_img_1

Project and user wise import wizard.

accordion_img_1

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.

accordion_img_1

Imported task looks like below.

accordion_img_1

Default import csv file format (your file format must match like below).

accordion_img_1

Default import excel file format (your file format must match like below).

accordion_img_1

User and project wise import csv file format (your file format must match like below).

accordion_img_1

User and project wise import excel file format (your file format must match like below).

accordion_img_1

Custom fields format.

accordion_img_1

Custom fields imported with many2one & many2many fields.

accordion_img_1

Default imported CSV file format with custom fields.

accordion_img_1

Default imported Excel file format with custom fields.

accordion_img_1

User and project wise imported CSV file format with custom fields.

accordion_img_1

User and project wise imported Excel file format with custom fields.

accordion_img_1

Features

heading
  • Easy to import
  • Import csv or excel
  • Custom fields added.

First you need to tick "Import Lead" groups in order to import lead.

accordion_img_1

"Import leads" menu Leads.

accordion_img_1

"Import leads" menu in CRM and default import wizard. Just select file type and upload your file and hit "apply" button.

accordion_img_1

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.

accordion_img_1

Imported leads looks like below.

accordion_img_1

accordion_img_1

Your csv file format must match like below.

accordion_img_1

Your excel file format must match like below.

accordion_img_1

Custom fields format.

accordion_img_1

The "Contact Name", "Tags" & "Sales Team" custom fields are imported.

accordion_img_1

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

accordion_img_1

Your Excel file format looks like below.

accordion_img_1

Features

heading
  • Multiple import options by ID, Identification No, Name.
  • Import csv or excel.
  • Easy to select url or local system path
  • Very useful for mass records.

First you need to tick "Import Employee Image" group in order to import employee Image.

accordion_img_1

"Import Employee Image" menu in Configuration.

accordion_img_1

When you click "Import Employee Image" menu, wizard will open and it's looks like below.

accordion_img_1

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.

accordion_img_1

following Images are imported.

accordion_img_1

Your CSV file format must match like below.

accordion_img_1

Your Excel file format must match like below.

accordion_img_1

Features

heading
  • Easy to import
  • Import csv or excel
  • Custom fields added.

First you need to tick "Import Employee Timesheet" group in order to import timesheet.

accordion_img_1

"Import Timesheet" menu in Timesheet.

accordion_img_1

When you click "Import Timesheet" menu, wizard will open and it's looks like below.

accordion_img_1

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.

accordion_img_1

following Timesheets are imported.

accordion_img_1

Your CSV file format must match like below.

accordion_img_1

Your Excel file format must match like below.

accordion_img_1

Custom fields format.

accordion_img_1

Import custom field with many2many fields.

accordion_img_1

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

accordion_img_1

Your CSV file format looks like below.

accordion_img_1

Features

heading
  • Easy to import
  • Import csv or excel
  • Import internal transfer by product Name, Barcode, Internal Reference

First you need to tick "Import Internal Transfer" group in order to import internal transfer

accordion_img_1

"Import Internal Transfer" menu in Operations.

accordion_img_1

When you click "Import Internal Transfer" menu, wizard will open that looks like below

accordion_img_1

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.

accordion_img_1

following fields are imported.

accordion_img_1

Your CSV file format must match like below.

accordion_img_1

Your Excel file format must match like below.

accordion_img_1

Features

heading
  • Multiple import options by ID, Internal Reference, Name.
  • Import csv or excel
  • Easy to select url or local system path
  • Very useful for mass records

First you need to tick "Import Customer Image" group in order to import customer Image.

accordion_img_1

"Import Customer Image" menu in Orders.

accordion_img_1

When you click "Import Customer Image" menu, wizard will open and it's looks like below.

accordion_img_1

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.

accordion_img_1

following Images are imported.

accordion_img_1

Your CSV file format must match like below.

accordion_img_1

Your Excel file format must match like below.

accordion_img_1

Version 15.0.2 | Released on : 16th November 2021

New Import HR Expense From CSV/Excel File Added.

Version 15.0.1 | Released on : 15th October 2021

Initial Initial Release.
  • Yes, this app works perfectly with Odoo Enterprise (Odoo.sh & Premise) as well as Community.
  • Yes, This app is compatible with Odoo's Multi-Company Feature.
  • Yes, we provide free support for 100 days.
  • Yes, you will get free update for lifetime.
  • Yes, You have to download module for each version (13,14,15) except in version 12 or lower.

Multi-Languages

heading
We have added predefined some languages(English, German / Deutsch, Arabic, Spanish / Espanol, French / Francais, Chinese) in module, If you want to add other language you can contact us on support@softhealer.com. We use google translator tools for multi-languages so possible translations can be not accurate. we accept suggest to make more accurate translations also on support@softhealer.com.

english germany arab spanish Chinese French

Most Demanded Apps

heading
Odoo Proprietary License v1.0
This software and associated files (the "Software") may only be used (executed,
modified, executed after modifications) if you have purchased a valid license
from the authors, typically via Odoo Apps, or if you have received a written
agreement from the authors of the Software (see the COPYRIGHT file).
You may develop Odoo modules that use the Software as a library (typically
by depending on it, importing it and using its resources), but without copying
any source code or material from the Software. You may distribute those
modules under the license of your choice, provided that this license is
compatible with the terms of the Odoo Proprietary License (For example:
LGPL, MIT, or proprietary licenses similar to this one).
It is forbidden to publish, distribute, sublicense, or sell copies of the Software
or modified copies of the Software.
The above copyright notice and this permission notice must be included in all
copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM,
DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
DEALINGS IN THE SOFTWARE.

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.
There are no ratings yet!
by
vittorio tomasi
on 1/17/22, 12:20 PM

Hello,

I am interested in this module. I have to import about 10,000 products with Magento 2 to odoo15 variants. I need to know if I can import the gallery images (extra media) where there can be up to 10 images per product) This is sustainable fashion. See: https://www.ecovisioni.com




Vittorio Altagamma Srl Italy

Re:
by
Softhealer Technologies
on 1/20/22, 12:04 AM Author

Hello,

Yes you can import extra images using feature call "Import Product Images From Zip For E-Commerce".  You can import more than 10 images as well but it will be depends on your server configuration and image size for execution time. 

Thank you.