![logo](/web/image/436461/softhealer.png)
All In One Import - Partner, Product, Sales, Purchase, Accounts, Inventory, BOM, CRM, Project
![heading](/web/image/436462/heading.png)
This module is useful to import data from CSV/Excel file. You can import custom fields from CSV or Excel.
Features
![heading](/web/image/436462/heading.png)
- You can import purchase order by vendor's Name or Reference or ID.
- You can import sale order, invoice, journal entry & invoice with payment & pos order, by customer's Name or Reference or ID.
- You can add/update the pricelist while importing vendor & sales pricelists.
- You can import product images using schedule import.
- You can import vendor pricelists using schedule import.
- 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.
-
Custom fields
added into, import product template, import invoice lines, import attendance,
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](/web/image/436462/heading.png)
- 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. If you want to use excel and want to clear the format then please check this video.
You can import all the things at one place. You can do mass import from one view.
![](/web/image/480694/s_1.png)
The separate group assigns to for mass import buttons view.
![](/web/image/480695/s_2.png)
Features
![heading](/web/image/436462/heading.png)
- 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.
![](/web/image/480696/1.png)
Click on the 'Import Expense' menu.
![](/web/image/480697/2.png)
After that, this wizard will open enter details and apply it. You can import expense or expense sheet from CSV/Excel file.
![](/web/image/480698/3.png)
You can import expense employees by name, work phone, work email & badge ID and expense products by name, internal reference or barcode.
![](/web/image/480699/4.png)
Select file and click on the 'Apply' button.
![](/web/image/480700/5.png)
Success message looks like below it's shows successfully imported records.
![](/web/image/480701/6.png)
Imported data with form view.
![](/web/image/480702/7.png)
Your CSV/Excel/XLS file format must match like below.
![](/web/image/480703/8.png)
Now we import expense sheet.
![](/web/image/480704/9.png)
Imported data form view.
![](/web/image/480705/10.png)
Your CSV/Excel/XLS file format must match like below.
![](/web/image/480706/11.png)
Features
![heading](/web/image/436462/heading.png)
- 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.
Enable the 'Import Payments' group.
![](/web/image/480707/1.png)
Click on the 'Import Payments' menu.
![](/web/image/480708/2.png)
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'.
![](/web/image/480709/3.png)
Success message looks like below it's shows successfully imported records.
![](/web/image/480710/4.png)
Imported data with list view.
![](/web/image/480711/5.png)
Following fields are imported and state change to 'Posted'.
![](/web/image/480712/6.png)
Now we enable 'Create Customer Customer/Vendor' only so it not validate or post auto payments.
![](/web/image/480713/7.png)
Success message looks like below it's shows imported records and validate records.
![](/web/image/480714/8.png)
Imported data form view, here we did not enable 'Confirm Posted Payment' so state not change.
![](/web/image/480715/9.png)
Now we do not enable 'Create Customer Customer/Vendor'.
![](/web/image/480716/10.png)
So it generates an alert message of a partner not found that does not exist, that looks like this.
![](/web/image/480717/11.png)
Your CSV/Excel/XLS file format must match like below.
![](/web/image/480718/12.png)
Features
![heading](/web/image/436462/heading.png)
- 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.
![](/web/image/480719/1.png)
Click on the 'Import Chart Of Account' menu.
![](/web/image/480720/2.png)
After that, this wizard will open enter details and apply it.
![](/web/image/480721/3.png)
Success message looks like below.
![](/web/image/480722/4.png)
Following COA are imported, Imported data with list view.
![](/web/image/480723/5.png)
Following fields are imported.
![](/web/image/480724/6.png)
Your CSV file format must match like below.
![](/web/image/480725/7.png)
Your Excel/XLS/XLSX file format must match like below.
![](/web/image/480726/8.png)
![](/web/image/480727/9.png)
Features
![heading](/web/image/436462/heading.png)
- 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.
- Easy to import partner by Name, Reference, Id.
Enable the 'Import Invoice With Payment' group.
![](/web/image/436487/1.png)
Click on the 'Import Invoice With Payment' menu.
![](/web/image/436488/2.png)
After that, this wizard will open enter details and apply it.
![](/web/image/436489/3.png)
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.
![](/web/image/436490/4.png)
Imported data with list view.
![](/web/image/436491/5.png)
Following fields are imported.
![](/web/image/436492/6.png)
![](/web/image/436493/7.png)
You can import invoice with the different payment method.
![](/web/image/436494/8.png)
Imported data with list view.
![](/web/image/436495/9.png)
Following fields are imported.
![](/web/image/436496/10.png)
List view of the vendor payments, here you can see the memo number.
![](/web/image/436497/11.png)
The memo number is in the vendor payments form view.
![](/web/image/436498/12.png)
Features
![heading](/web/image/436462/heading.png)
- 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.
![](/web/image/480728/1.png)
'Import Internal Transfer Advance' menu in the operations.
![](/web/image/480729/2.png)
When you click the 'Import Internal Transfer Advance' menu, the wizard will open that looks like below.
![](/web/image/480730/3.png)
Success message looks like the below it shows successfully imported records.
![](/web/image/480731/4.png)
Following internal transfers are imported.
![](/web/image/480732/5.png)
The imported internal transfer form view with the source and destination location.
![](/web/image/480733/6.png)
The imported internal transfer form view with the source and destination location.
![](/web/image/480734/7.png)
Your CSV file format must match like below.
![](/web/image/480735/8.png)
Your Excel file format must match like below.
![](/web/image/480736/9.png)
Features
![heading](/web/image/436462/heading.png)
- 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.
![](/web/image/436499/1.png)
'Import Inventory Without Lot/Serial Number' menu in operations.
![](/web/image/436500/2.png)
When you click the 'Import Inventory Without Lot/Serial Number' menu, the wizard will open that looks like below.
![](/web/image/436501/3.png)
Success message looks like below.
![](/web/image/436502/4.png)
Imported records tree view.
![](/web/image/436503/5.png)
Your CSV file format must match like below.
![](/web/image/436504/6.png)
Your Excel file format must match like below.
![](/web/image/436505/7.png)
Features
![heading](/web/image/436462/heading.png)
- 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.
- Easy to import customer by Name, Reference, Id.
User Setting Enable group 'Import Journal Entries'.
![](/web/image/480737/1.png)
Import journal entries menu and tree view.
![](/web/image/480738/2.png)
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, accounting date field that is used for your journal entry which has a same date. Select a customer by (Name).
![](/web/image/480739/3.png)
After click to apply you see the success message of import.
![](/web/image/480740/4.png)
As you can see the whole imported journal entries.
![](/web/image/480741/5.png)
Imported records form view.
![](/web/image/480742/6.png)
Your CSV file format must be like this.
![](/web/image/480743/7.png)
Your Excel file format must match like below.
![](/web/image/480744/8.png)
Features
![heading](/web/image/436462/heading.png)
- You can import sales pricelist from CSV/Excel file.
- You can import Vendor pricelist from CSV/Excel file.
- You can apply sales pricelist on the product, product variant & product category.
- You can import pricelists by name, internal reference number & barcode.
- You can compute price by fix price, discount wise, cost price, sales price or other pricelist in the sales pricelist.
- In the vendor pricelist, we support both "Product Variants" and "Product Template" models.
- You can add/update the pricelist while importing vendor & sales pricelists.
Sale pricelist configuration.
![](/web/image/480745/1.png)
Tick 'Import Sales pricelist'.
![](/web/image/480746/2.png)
The import pricelist menu.
![](/web/image/480747/3.png)
You can download a sample file by clicking on 'PRICELIST CSV FILE' or 'PRICELIST EXCEL FILE' button. You can apply a pricelist on the product, product variant & product category by name, internal reference number & barcode. You can apply import pricelist by Add sales pricelist or Update sales pricelist & price computation by fixed price. Apply price computation by Fixed price. Select the file which you want to import. Click on 'Apply' button.
![](/web/image/480748/4.png)
![](/web/image/480749/5.png)
You can apply price computation by percentage wise or discount wise.
![](/web/image/480750/6.png)
You can apply price computation by formula wise(sales price, cost price or other pricelist).
![](/web/image/480751/7.png)
Success message looks like below.
![](/web/image/480752/8.png)
Pricelist tree view with imported pricelist.
![](/web/image/480753/9.png)
Imported pricelist form view.
![](/web/image/480754/10.png)
Your CSV file must looks like below.
![](/web/image/480755/11.png)
Your Excel file must looks like below.
![](/web/image/480756/12.png)
Features
![heading](/web/image/436462/heading.png)
- 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'.
![](/web/image/480757/1.png)
Select 'By Lots' in Acoustic Bloc Screens product and on hand qty is 0(Zero) now.
![](/web/image/480758/2.png)
Acoustic Bloc Screens product 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'.
![](/web/image/436466/3.png)
![](/web/image/436467/4.png)
After pressing that button this wizard opens, press the 'Import Lot/Serial' button.
![](/web/image/436468/5.png)
Select the import file type, choose the file type & select lot/serial type, and press the 'Apply' button.
![](/web/image/436469/6.png)
Success message looks like below.
![](/web/image/436470/7.png)
Stock move pop-up.
![](/web/image/436471/8.png)
Now we press the 'Validate' button and our stage is changed from ready to done.
![](/web/image/436472/9.png)
Lot/Serial Numbers list view with imported lot/serial picking.
![](/web/image/436473/10.png)
Now the Acoustic Bloc Screens product on hand qty is changed.
![](/web/image/436474/11.png)
Select 'By Unique Serial Number' in Cabinet with doors product and the on-hand qty is 0(Zero) now.
![](/web/image/436475/12.png)
Select the import file type, choose the file type & select lot/serial type, and press the 'Apply' button.
![](/web/image/436476/13.png)
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.
![](/web/image/436477/14.png)
Stock move operation wizard with the imported lot/serial picking.
![](/web/image/436478/15.png)
Total QTY is visible here.
![](/web/image/436479/16.png)
Lot/Serial Numbers list view with imported lot/serial picking.
![](/web/image/436480/17.png)
Now the Cabinet With doors product on hand qty is changed.
![](/web/image/436481/18.png)
The 'Location' list view looks like this.
![](/web/image/436482/19.png)
Features
![heading](/web/image/436462/heading.png)
- 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.
![](/web/image/480759/1.png)
After enabling that option you can see this 'Export Images eCommerce' in action.
![](/web/image/480760/2.png)
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.
![](/web/image/480761/3.png)
After click 'Export' you can see one file is created in 'zip', just click it and download it.
![](/web/image/480762/4.png)
Extract that zip file.
![](/web/image/480763/5.png)
We provide the 'Export Images eCommerce' option for product variants also.
![](/web/image/480764/6.png)
Features
![heading](/web/image/436462/heading.png)
- 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 You can import product images by image URL or local image path. (Local URL means URL of your odoo server files location, please note it is not your odoo user local system path.)
- Easy to import products with stock on-hand quantity.
First, you need to tick the 'Import Product Variants eCommerce' group.
![](/web/image/480765/1.png)
'Import Product Variants eCommerce' menu.
![](/web/image/480766/2.png)
After that one wizard open here you can import products with product variants From CSV/Excel.
![](/web/image/480767/3.png)
You can create or update product variants by barcode, name & internal reference.
![](/web/image/480768/4.png)
Success message looks like below it shows successfully imported records.
![](/web/image/480769/5.png)
The following product template fields are imported.
![](/web/image/480770/6.png)
We see the imported product 'Collar T-Shirt' fields.
![](/web/image/480771/7.png)
Product variants.
![](/web/image/480772/8.png)
The "Sales" tab in the product 'Collar T-Shirt'.
![](/web/image/480773/9.png)
Using the 'Variant' feature you can see product variant details.
![](/web/image/480774/10.png)
Product variant details.
![](/web/image/480775/11.png)
ou can see the product variant field which is imported.
![](/web/image/480776/12.png)
The following custom fields are imported (Text, Integer, Float, Character, Boolean, Selection, Many2one, Many2many custom fields are supported).
![](/web/image/480777/13.png)
In Attribute, Our app works only when 'Variants Creation Mode' must be set 'Instantly'.
![](/web/image/480778/14.png)
Features
![heading](/web/image/436462/heading.png)
- 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.
![](/web/image/480779/1.png)
Import images from the zip file eCommerce menu on the website.
![](/web/image/480780/2.png)
Import images from zip file wizard.
![](/web/image/480781/3.png)
Success message after import done.
![](/web/image/480782/4.png)
Below eCommerce products, images are imported.
![](/web/image/480783/5.png)
Features
![heading](/web/image/436462/heading.png)
- 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. (Local URL means URL of your odoo server files location, please note it is not your odoo user local system path.)
- 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.
![](/web/image/436506/1.png)
'Import Products Using Multi Barcode' menu in products.
![](/web/image/436507/2.png)
When you click the 'Import Product templates' 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.
![](/web/image/436508/3.png)
![](/web/image/436509/4.png)
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.
![](/web/image/436510/5.png)
The following fields are imported.
![](/web/image/436511/6.png)
The following barcodes are imported.
![](/web/image/436512/7.png)
The following fields are imported.
![](/web/image/436513/8.png)
The following fields are imported.
![](/web/image/436514/9.png)
The following fields are imported.
![](/web/image/436515/10.png)
Your CSV file must match like below.
![](/web/image/436516/12.png)
Your Excel file must match like below.
![](/web/image/436517/11.png)
- 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. (Local URL means URL of your odoo server files location, please note it is not your odoo user local system path.)
- Easy to import products with stock on-hand quantity.
- Easy to create and update product variants.
First, you need to tick the "Import Product Variants" group to import product Variant.
![](/web/image/436518/1.png)
'Import Product Variants' menu in products.
![](/web/image/436519/2.png)
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.
![](/web/image/436520/3.png)
![](/web/image/436521/4.png)
Success message looks like below it shows successfully imported records.
![](/web/image/436522/5.png)
The following product template fields are imported.
![](/web/image/436523/6.png)
We see the imported product 'Collar T-Shirt' fields.
![](/web/image/436524/7.png)
Product variants.
![](/web/image/436525/8.png)
The 'Sales' tab in the product 'Collar T-Shirt'.
![](/web/image/436526/9.png)
The following barcodes are imported.
![](/web/image/436527/10.png)
You can configure the product from here.
![](/web/image/436528/11.png)
Product variant imported succesfully.
![](/web/image/436529/12.png)
Custom Fields.
![](/web/image/436530/custom.png)
Features
![heading](/web/image/436462/heading.png)
- 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.
- Easy to import customer by Name, Reference, Id.
First, you need to tick the 'Import POS Order' group to import product.
![](/web/image/480784/1.png)
'Import POS Order' menu in orders.
![](/web/image/480785/2.png)
After that one wizard will open and it's looks like below.
![](/web/image/480786/3.png)
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.
![](/web/image/480787/4.png)
The following fields are imported.
![](/web/image/480788/5.png)
Your CSV file format must match like below.
![](/web/image/480789/6.png)
Your Excel file format must match like below.
![](/web/image/480790/7.png)
Features
![heading](/web/image/436462/heading.png)
- 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.
First, Tick 'Import Images From Zip File' group.
![](/web/image/480791/1.png)
Import images from zip file menu in sale.
![](/web/image/480792/2.png)
Success message after import done.
![](/web/image/480795/3.png)
Below product images are imported.
![](/web/image/480796/4.png)
Success message after import done.
![](/web/image/480797/5.png)
Below partner images are imported.
![](/web/image/480798/6.png)
Import employee images from zip file options.
![](/web/image/480799/7.png)
Below employee images are imported.
![](/web/image/480800/8.png)
Features
![heading](/web/image/436462/heading.png)
- 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.
- 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.
- Import attendance based on Employee Badge.
- Easy to download the exact formate of CSV or Excel files.
User Setting: Just tick right 'Import Attendance'.
![](/web/image/480801/1.png)
In Attendance, there is a menu for 'Import Attendance'.
![](/web/image/480802/2.png)
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'.
![](/web/image/480803/3.png)
After click 'Apply' this success message will show with the total imported record.
![](/web/image/480804/4.png)
Import custom character field 'Information'.
![](/web/image/480805/5.png)
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.
![](/web/image/480806/6.png)
Your CSV/Excel file format looks like below.
![](/web/image/480807/7.png)
Features
![heading](/web/image/436462/heading.png)
- 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 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.
You need to tick the 'Import Users' group to import the users.
![](/web/image/480808/1.png)
'Import Users' menu in the Users & Companies.
![](/web/image/480809/2.png)
When you click the 'Import Users' menu, the wizard will open and it looks like below.
![](/web/image/480810/3.png)
Success message looks like below it shows successfully imported records.
![](/web/image/480811/4.png)
The following users are imported.
![](/web/image/480812/5.png)
User imported with extra rights.
![](/web/image/480813/6.png)
After successfully import, the user can log in with id and password given in sheet, if you try with wrong details then comes alert.
![](/web/image/480814/7.png)
The login screen looks like below.
![](/web/image/480815/8.png)
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'.
![](/web/image/480816/9.png)
Custom fields format.
![](/web/image/480817/custom.png)
Features
![heading](/web/image/436462/heading.png)
- User Setting: Enable group 'Import Journal Items'.
- Easy to import journal items from CSV or Excel files.
- Import journal items in a single click.
- Easy to import custom fields.
- Easy to import custom fields from CSV or Excel.
- Easy to Easy to import Text, Integer, Float, Character, Boolean, Selection, Many2one, Many2many custom fields.
- Easy to import customer by Name, Reference, Id.
Enable group 'Import Journal Items'.
![](/web/image/480818/1.png)
As you can see the button 'Import Journal Item' in Journal Items form view.
![](/web/image/480819/2.png)
After clicking the button 'Import Journal Items' one wizard will popup. Select a file type (CSV or Excel) and upload the file.
![](/web/image/480820/3.png)
As you can see the whole imported journal items in line at journal entries.
![](/web/image/480821/4.png)
CSV/Excel file formate must be like this.
![](/blog/odoo-store-9/screenshots/sh_import_journal_item/5.png)
Custom fields format.
![](/web/image/480822/custom.png)
Features
![heading](/web/image/436462/heading.png)
- 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.
![](/web/image/480696/1.png)
"Import Customers/Suppliers" menu in Orders.
![](/web/image/480697/2.png)
When you click "Import Customers/Suppliers" menu, wizard will open and it's looks like below.
![](/web/image/480698/3.png)
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.
![](/web/image/480699/4.png)
following fields are imported.
![](/web/image/480700/5.png)
Your CSV file format must match like below.
![](/web/image/480701/6.png)
Your Excel file format must match like below.
![](/web/image/480702/7.png)
The "Tax ID" & "Tags" custom fields are imported.
![](/web/image/480703/8.png)
Your CSV file must match like below and You can add custom fields column after the last column as shown in the below image.
![](/web/image/480704/9.png)
Your Excel file format looks like below.
![](/web/image/480705/10.png)
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).
![](/web/image/480706/11.png)
Features
![heading](/web/image/436462/heading.png)
- 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. (Local URL means URL of your odoo server files location, please note it is not your odoo user local system path.)
- 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.
- This module is compatible with Odoo's Multi-Company Feature.
First, you need to tick the 'Import Product Template' group to import product template.
![](/web/image/436560/1.png)
'Import Products' menu in products.
![](/web/image/436561/2.png)
When you click the 'Import Products' button, the wizard will open that looks like below.
![](/web/image/436562/3.png)
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.
![](/web/image/436563/4.png)
The following fields are imported.
![](/web/image/436564/5.png)
![](/web/image/436565/6.png)
![](/web/image/436566/7.png)
Your csv file must match like below.
![](/web/image/436567/8.png)
Product template import with many2many & custom selection fields.
![](/web/image/436568/10.png)
Your CSV file must match like below.
![](/web/image/436569/11.png)
Features
![heading](/web/image/436462/heading.png)
- You can create or update product variants by barcode, name & internal reference.
- 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. (Local URL means URL of your odoo server files location, please note it is not your odoo user local system path.)
- Easy to import products with stock on-hand quantity.
First, you need to tick the 'Import Product Variants' group to import product Variant.
![](/web/image/436531/1.png)
'Import Product Variants' menu.
![](/web/image/436532/2.png)
After that one wizard open here you can import products with product variants From CSV/Excel.
![](/web/image/436533/3.png)
You can create or update product variants by barcode, name & internal
reference.
Please tick this option during import to create record auto for many2many.
![](/web/image/436534/4.png)
Success message looks like below it shows successfully imported records.
![](/web/image/436535/5.png)
The following product template fields are imported.
![](/web/image/436536/6.png)
We see the imported product 'Collar T-Shirt' fields.
![](/web/image/436537/7.png)
Product variants.
![](/web/image/436538/8.png)
The 'Sales' tab in the product 'Collar T-Shirt'.
![](/web/image/436539/9.png)
The 'Purchase' tab in the product 'Collar T-Shirt'.
![](/web/image/436540/10.png)
Product variant imported succesfully.
![](/web/image/436541/11.png)
Product variant details with on hand qty.
![](/web/image/436542/12.png)
You can see the product variant field which is imported.
![](/web/image/436543/13.png)
![](/web/image/436544/14.png)
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'.
![](/web/image/436545/15.png)
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.
![](/web/image/436546/16.png)
You can import any number of custom fields. All custom fields must exist on the product.product model.
![](/web/image/436547/19.png)
You can import any number of custom fields. All custom fields must exist on the product.product model.
![](/web/image/436548/custom.png)
Schedule Import Flow
![heading](/web/image/436462/heading.png)
![](/web/image/480823/flow.png)
Features
![heading](/web/image/436462/heading.png)
- 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.
![](/web/image/480824/1.png)
'Import Product Image' menu in Products..
![](/web/image/480825/2.png)
When you click "Import Product Image" menu, wizard will open and it's looks like below.
![](/web/image/480826/3.png)
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.
![](/web/image/480827/4.png)
Following Images are imported.
![](/web/image/480828/5.png)
Your CSV file format must match like below.
![](/web/image/480829/7.png)
Features
![heading](/web/image/436462/heading.png)
- You can import unit price based on sheet.
- You can import unit price based on pricelist.
- Easy to import sale orders.
- Import from 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.
- Import customer by Name, Reference, Id.
First you need to tick "Import Sale Order" group in order to import sale order
![](/web/image/436570/1.png)
'Import Sale Order' menu in orders.
![](/web/image/436571/2.png)
When you click 'Import Sale Order' menu, wizard will open that looks like below
![](/web/image/436572/3.png)
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.
![](/web/image/436573/4.png)
Following fields are imported.
![](/web/image/436574/5.png)
![](/web/image/436575/6.png)
CSV/XLS file format must match like below.
![](/web/image/436576/7.png)
Features
![heading](/web/image/436462/heading.png)
- You can import unit price based on sheet.
- You can import unit price based on pricelist.
- Easy to import product by Name, Barcode, Internal Reference.
- 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 Sale Order Lines' group to import the sale order lines.
![](/web/image/436577/1.png)
'Import Sale Order Lines' button in the sale order form view.
![](/web/image/436578/2.png)
When you click the 'Import Sale Order Lines' menu, the wizard will open and it looks like below.
![](/web/image/436579/3.png)
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.
![](/web/image/436580/4.png)
The following sale order lines are imported.
![](/web/image/436581/5.png)
Your CSV file format must match like below.
![](/web/image/436582/6.png)
Your Excel file format must match like below.
![](/web/image/436583/7.png)
![](/web/image/436584/8.png)
Sale order line import from CSV sheets with many2many fields.
![](/web/image/436585/9.png)
Your CSV file must match like below and add custom fields after the last column.
![](/web/image/436586/10.png)
Your Excel file must match like below and add custom fields after the last column.
![](/web/image/436587/11.png)
Features
![heading](/web/image/436462/heading.png)
- 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 the 'Import Inventory With Lot/Serial Number' group to import stock inventory with lot/serial number.
![](/web/image/436588/1.png)
'Import Inventory With Lot/Serial Number' menu in operations.
![](/web/image/436589/2.png)
When you click the 'Import Inventory With Lot/Serial Number' menu, the wizard will open that looks like below.
![](/web/image/436590/3.png)
Success message looks like below it hows successfully imported records and also provides a list of unimported records with row number in sheet and relative details of data invalidation.
![](/web/image/436591/4.png)
New lot/Serial Number created if never exist.
![](/web/image/436592/5.png)
Your CSV file format must match like below.
![](/web/image/436593/6.png)
Your Excel file format must match like below.
![](/web/image/436594/7.png)
Features
![heading](/web/image/436462/heading.png)
- Easy to import product by Name, Barcode, Internal Reference.
- 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 Reordering Rules' group to import the reordering rules.
![](/web/image/480830/1.png)
'Import Reordering Rules' menu in the master data.
![](/web/image/480831/2.png)
When you click the 'Import Reordering Rules' menu, the wizard will open and it looks like below.
![](/web/image/480832/3.png)
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.
![](/web/image/480833/4.png)
The following fields are imported.
![](/web/image/480834/5.png)
Your CSV file format must match like below.
![](/web/image/480835/6.png)
Features
![heading](/web/image/436462/heading.png)
- You can import unit price based on sheet.
- You can import unit price based on pricelist.
- 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
- Easy to import vendor by Name, Reference, Id.
First you need to tick 'Import purchase Order' group in order to import purchase order
![](/web/image/436595/1.png)
'Import Purchase Order' menu in purchase
![](/web/image/436596/2.png)
When you click "Import Purchase Order" menu, wizard will open that looks like below
![](/web/image/436597/3.png)
Following fields are imported.
![](/web/image/436598/4.png)
CSV/XLS file format must match like below.
![](/web/image/436599/5.png)
![](/web/image/436600/6.png)
Features
![heading](/web/image/436462/heading.png)
- You can import unit price based on sheet.
- You can import unit price based on pricelist.
- 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.
- Import CSV or Excel.
- Easy to import product by Name, Barcode, Internal Reference.
First, you need to tick the 'Import Purchase order lines' group to import the Purchase order lines.
![](/web/image/436601/1.png)
'Import Purchase Order Lines' button in RFQ/Purchase order form view.
![](/web/image/436602/2.png)
When you click the 'Import Purchase Order Lines' menu, the wizard will open and it looks like below.
![](/web/image/436603/3.png)
The following purchase order lines are imported.
![](/web/image/436604/4.png)
Purchase order line import from CSV/XLS sheets with many2many.
![](/web/image/436605/5.png)
Your CSV file must match like below and add custom fields after the last column.
![](/web/image/436606/6.png)
Schedule Import Flow
![heading](/web/image/436462/heading.png)
![](/web/image/480836/8.png)
Features
![heading](/web/image/436462/heading.png)
- You can import vendor details using schedule import.
- Easy to import records manually or usign cron.
- You can set default values for import records.
- Easy to import product by Name, Barcode, Internal Reference.
- Support both 'Product Variants' and 'Product Template' models.
First, you need to tick the 'Import Supplier Info' group to import the Import Supplier Info.
![](/web/image/480837/1.png)
'Import Supplier Info' menu in the purchase.
![](/web/image/480838/2.png)
When you click the 'Import Supplier Info' menu, the wizard will open and it looks like below.
![](/web/image/480839/3.png)
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.
![](/web/image/480840/4.png)
The following fields are imported.
![](/web/image/480841/5.png)
![](/web/image/480842/6.png)
Your CSV/ Excel file format must match like below.
![](/web/image/480843/7.png)
Features
![heading](/web/image/436462/heading.png)
- 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.
- Import partner by Name, Reference, Id.
First you need to tick 'Import Invoice' group in order to import Invoice
![](/web/image/436607/1.png)
When you click 'Import Invoice' menu, wizard will open that looks like below
![](/web/image/436608/2.png)
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.
![](/web/image/436609/3.png)
Following fields are imported.
![](/web/image/436610/4.png)
Your CSV file format must match like below.
![](/web/image/436611/5.png)
Your Excel file format must match like below.
![](/web/image/436612/6.png)
Features
![heading](/web/image/436462/heading.png)
- Import invoice/bill lines.
- Import From CSV or Excel.
- Import product by Name, Barcode, Internal Reference.
- Import Customer/Vendor Credit Notes lines.
- Easy to import Text, Integer, Float, Character, Boolean, Selection, Many2one, Many2many custom fields.
First, you need to tick the 'Import Invoice/Bill/Credit note Lines' group to import invoice/bill/credit note lines.
![](/web/image/436613/1.png)
'Import Invoice/Credit note Lines' button in customer invoice form view.
![](/web/image/436614/2.png)
When you click the 'Import Invoice/Credit note Lines' button, the wizard will open that looks like below.
![](/web/image/436615/3.png)
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.
![](/web/image/436616/4.png)
The following invoice lines are imported.
![](/web/image/436617/5.png)
You can also import customer credit note lines.
![](/web/image/436618/6.png)
You can also import Vendor Bill lines.
![](/web/image/436619/7.png)
You can also import vendor credit note lines.
![](/web/image/436620/8.png)
Features
![heading](/web/image/436462/heading.png)
- Easy to import.
- Import csv or excel.
- Import product by Name, Barcode, Internal Reference.
- Very well formated Excel and CSV files.
First you need to tick 'Import Bill of Materials' group in order to import Bill of Materials.
![](/web/image/480844/1.png)
'Import Bill of Materials' menu in master data
![](/web/image/480845/2.png)
When you click 'Import Bill of Materials' menu, wizard will open that looks like below
![](/web/image/480846/3.png)
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.
![](/web/image/480847/4.png)
Following fields are imported.
![](/web/image/480848/5.png)
Your CSV file format must match like below.
![](/web/image/480849/6.png)
Features
![heading](/web/image/436462/heading.png)
- Easy to import.
- Import CSV or Excel.
- Easy to import different modes of the project task.
- 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.
First, you need to tick the 'Import Project Task' group to import the project task.
![](/web/image/480850/1.png)
'Import Project Task' menu in the projects.
![](/web/image/480851/2.png)
When you click the 'Import Task' menu, the wizard will open and it looks like below.
![](/web/image/480852/3.png)
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.
![](/web/image/480853/4.png)
Project and user wise import wizard.
![](/web/image/480854/5.png)
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.
![](/web/image/480855/6.png)
The following task is imported.
![](/web/image/480856/7.png)
Default import CSV/Excel file format looks like below.
![](/web/image/480857/8.png)
Features
![heading](/web/image/436462/heading.png)
- Easy to import.
- Import CSV or Excel.
- 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.
First, you need to tick the 'Import Lead' group to import the lead.
![](/web/image/480858/1.png)
'Import leads' menu in the leads.
![](/web/image/480859/2.png)
When you click the 'Import Leads' menu, the wizard will open and it looks like below.
![](/web/image/480860/3.png)
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.
![](/web/image/480861/4.png)
The following Leads are imported.
![](/web/image/480862/5.png)
![](/web/image/480863/6.png)
Features
![heading](/web/image/436462/heading.png)
- Multiple import options by ID, Identification No, Name.
- Import csv or excel
- Easy to select url or local system path (Local URL means URL of your odoo server files location, please note it is not your odoo user local system path.)
- Very useful for mass records.
First you need to tick 'Import Employee Image' group in order to import employee Image.
![](/web/image/480864/1.png)
'Import Employee Image' menu in configuration.
![](/web/image/480865/2.png)
When you click 'Import Employee Image' menu, wizard will open and it's looks like below.
![](/web/image/480866/3.png)
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.
![](/web/image/480867/4.png)
Following Images are imported.
![](/web/image/480868/5.png)
Your CSV file format must match like below.
![](/web/image/480869/6.png)
Your Excel file format must match like below.
![](/web/image/480870/7.png)
Features
![heading](/web/image/436462/heading.png)
- Easy to import
- Import csv or excel
- Custom fields added.
First, you need to tick the 'Import Employee Timesheet' group to import the timesheet.
![](/web/image/480871/1.png)
'Import Timesheet' menu in the timesheet.
![](/web/image/480872/2.png)
When you click the 'Import Timesheet' menu, the wizard will open and it looks like below.
![](/web/image/480873/3.png)
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.
![](/web/image/480874/4.png)
The following Timesheets are imported.
![](/web/image/480875/5.png)
Your CSV file format must match like below.
![](/web/image/480876/6.png)
Your Excel file format must match like below.
![](/web/image/480877/7.png)
Import custom field with many2many fields.
![](/web/image/480878/8.png)
Your Excel file must match like below and You can add custom fields column after the last column as shown in the below image.
![](/web/image/480879/9.png)
Your CSV file format looks like below.
![](/web/image/480880/10.png)
Features
![heading](/web/image/436462/heading.png)
- Easy to 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
![](/web/image/480881/1.png)
'Import Internal Transfer' menu in Operations.
![](/web/image/480882/2.png)
When you click 'Import Internal Transfer' menu, wizard will open that looks like below.
![](/web/image/480883/3.png)
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.
![](/web/image/480884/4.png)
Tree view of teh internal transfer.
![](/web/image/480885/5.png)
Following fields are imported.
![](/web/image/480886/6.png)
Your CSV file format must match like below.
![](/web/image/480887/7.png)
Your Excel file format must match like below.
![](/web/image/480888/8.png)
Features
![heading](/web/image/436462/heading.png)
- Multiple import options by ID, Internal Reference, Name.
- Import csv or excel
- Easy to select url or local system path (Local URL means URL of your odoo server files location, please note it is not your odoo user local system path.)
- Very useful for mass records
First you need to tick 'Import Customer Image' group in order to import customer Image.
![](/web/image/480889/1.png)
'Import Customer Image' menu in Orders
![](/web/image/480890/2.png)
When you click 'Import Customer Image' menu, wizard will open and it's looks like below.
![](/web/image/480891/3.png)
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.
![](/web/image/480892/4.png)
Following Images are imported.
![](/web/image/480893/5.png)
Your CSV file format must match like below.
![](/web/image/480894/6.png)
Your Excel file format must match like below.
![](/web/image/480895/7.png)
V17.0.6
![heading](/web/image/436462/heading.png)
Go to the inventory configuration and tick 'Multi -step routes'.
![](/web/image/480896/0.png)
Add location field in the XLS/CSV file.
![](/web/image/480897/1.png)
Click on 'Import Reordering Rules' from the Product menu.
Fill details in the wizard and click on 'Apply'.
![](/web/image/480898/2.png)
Success message after import done.
![](/web/image/480899/3.png)
Here, you can see the imported reordering rules.
![](/web/image/480900/4.png)
V17.0.5
![heading](/web/image/436462/heading.png)
Add currency field in the XLS/CSV file.
![](/web/image/480901/1.png)
![](/web/image/480902/2.png)
Purchase order form view with imported currency.
![](/web/image/480903/3.png)
![](/web/image/480904/4.png)
Version 17.0.7 | Released on : 15th August 2024
Version 17.0.6 | Released on : 7th August 2024
Version 17.0.5 | Released on : 12th April 2024
Version 17.0.4 | Released on : 11th April 2024
Version 17.0.3 | Released on : 29th February 2024
Version 17.0.2 | Released on : 19th February 2024
Version 17.0.1 | Released on : 25th January 2024
- Yes, this app works perfectly with Odoo Enterprise (Odoo.sh & On-Premise) as well as Community.
- No, this application is not compatible with odoo.com(odoo saas/Odoo Online).
- Please Contact Us at [email protected] to request customization.
- Yes, you will get free update for lifetime.
- No, you don't need to install addition libraries.
- For version 12 or upper, you will need to purchase the module for each version that you want to use.
- Yes, we provide free support for 100 days.
- No, We do not provide any kind of exchange.