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 [email protected].
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 [email protected].
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
$ 55.00
$ 55.00
v
17.0
0
| Technical name | sh_all_in_one_import |
| License | OPL-1 |
| Website | https://www.softhealer.com |
| Read description for | |
| Included Dependencies | Product Multi Barcode |
All In One Import - Partner, Product, Sales, Purchase, Accounts, Inventory, BOM, CRM, Project
This module is useful to import data from CSV/Excel file. You can import custom fields from CSV or Excel.
Related Modules
Features
- You can import purchase order by vendor's Name or Reference or ID. New
- You can import sale order, invoice, journal entry & invoice with payment & pos order, by customer's Name or Reference or ID. New
- 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
- 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.
- Add Custom Fields or Non-Exist Standard odoo fields at the end, For adding those fields pls check the custom fields section.
These screenshots are taken in Odoo 16 version. We will be updating new screenshots in the near future. If you have any queries, please feel free to reach out to us at support
You can import all the things at one place. You can do mass import from one view.
The separate group assigns to for mass import buttons view.
Features
- 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.
Click on the "Import Expense" menu.
After that, this wizard will open enter details and apply it. You can import expense or expense sheet from CSV/Excel file.
You can import expense employees by name, work phone, work email & badge ID and expense products by name, internal reference or barcode.
Success message looks like below it's shows successfully imported records.
Imported data with form view.
Your CSV/Excel/XLS file format must match like below.
Now we import expense sheet.
Imported data form view.
Your CSV/Excel/XLS file format must match like below.
Features
- 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.
Click on the "Import Payments" menu.
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".
Success message looks like below it's shows successfully imported records.
Imported data with list view.
Following fields are imported and state change to "Posted".
Now we enable"Create Customer Customer/Vendor" only so it not validate or post auto payments.
Success message looks like below it's shows imported records and validate records.
Imported data form view, here we did not enable "Confirm Posted Payment" so state not change.
Now we do not enable"Create Customer Customer/Vendor".
So it generates an alert message of a partner not found that does not exist, that looks like this.
Your CSV/Excel/XLS file format must match like below.
Custom fields format.
Features
- 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.
Click on the "Import Chart Of Account" menu.
After that, this wizard will open enter details and apply it.
Success message looks like below.
Following COA are imported, Imported data with list view.
Following fields are imported.
Your CSV file format must match like below.
Your Excel/XLS/XLSX file format must match like below.
You can import any number of custom fields. All custom fields format must same as this.
Custom fields format.
Features
- 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.
Click on the "Import Invoice With Payment" menu.
After that, this wizard will open enter details and apply it.
You can import invoice with the different payment method.
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.
Imported data with list view.
following fields are imported.
Your CSV file format must match like below.
Your Excel/XLS file format must match like below.
Features
- 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.
"Import Internal Transfer Advance" menu in the operations.
When you click the "Import Internal Transfer Advance" menu, the wizard will open that looks like below.
Success message looks like the below it shows successfully imported records.
Following internal transfers are imported.
The imported internal transfer form view with the source and destination location.
The imported internal transfer form view with the source and destination location.
Your CSV file format must match like below.
Your Excel file format must match like below.
Features
- 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.
"Import Inventory Without Lot/Serial Number" menu in operations.
When you click the "Import Inventory Without Lot/Serial Number" menu, the wizard will open that looks like below.
Success message looks like below.
Imported records tree view.
The following fields are imported, the "Product Moves" smart button shows product moves.
Product moves without lot/serial number.
Product kanban view with on-hand quantity.
Your CSV file format must match like below.
Your Excel file format must match like below.
Features
- 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'.
Tick "Analytic Accounting Tags" & "Analytic Accounting" for import analytic accounts and tags with journal entries.
Import journal entries menu and tree view.
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.
After click to apply you see the success message of import.
As you can see the whole imported journal entries.
Imported records form view.
Your CSV file format must be like this.
Your Excel file format must be like this.
Journal entry wizard with an accounting date field that is used for your journal entry which has a same date. (Latest Update)
Your CSV/Excel file format must be like this. (Latest Update)
Features
- 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.
Tick "Import Sales pricelist".
The import pricelist menu.
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.
You can apply price computation by percentage wise or discount wise.
You can apply price computation by formula wise((sales price, cost price or other pricelist).
You can apply price computation by formula wise((sales price, cost price or other pricelist).
You can apply price computation by formula wise((sales price, cost price or other pricelist).
Success message looks like below.
Pricelist tree view with imported pricelist.
Imported pricelist form view.
It opens the popup with pricelist item details when you click on the product.
Imported pricelist form view.
Your CSV file must looks like below.
Your CSV file must looks like below.
Your Excel file must looks like below.
Your Excel file must looks like below.
Features
- 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.
After enabling that option you can see this 'Export Images eCommerce' in action.
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.
After click 'Export' you can see one file is created in 'zip', just click it and download it.
Extract that zip file.
Images successfully exported.
Images successfully exported.
Images successfully exported.
We provide the "Export Images eCommerce" option for product variants also.
You can export the eCommerce images for the product and product variants.
- 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.
"Import Product Variants eCommerce" menu.
After that one wizard open here you can import products with product variants From CSV/Excel.
You can create or update product variants by barcode, name & internal reference.
Success message looks like below it shows successfully imported records.
The following product template fields are imported.
We see the imported product "Collar T-Shirt" fields.
Product variants.
The "Sales" tab in the product "Collar T-Shirt".
The eCommerce category with extra product media.
You can configure the product from here.
Product variant imported succesfully.
Using the "Variant" feature you can see product variant details.
Product variant details.
You can see the product variant field which is imported.
The following custom fields are imported (Text, Integer, Float, Character, Boolean, Selection, Many2one, Many2many custom fields are supported).
In Attribute, Our app works only when "Variants Creation Mode" must be set "Instantly".
Your CSV/Excel file format must match like below.
Your CSV/Excel file format must match like below.
Your CSV/Excel file format must match like below.
Your CSV/Excel file format must match like below.
You can import variant-wise cost.
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.
Result of auto-created record during import.
Sample sheet.
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.
Please tick this option during import to create a record auto for the product category.
Result of auto-created record during import.
Result of auto-created record during import.
- 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.
Import images from the zip file eCommerce menu on the website.
Import images from zip file wizard.
Success message after import done.
Below eCommerce products, images are imported.
Below eCommerce products, images are imported.
- Import products/product templates from CSV or Excel.
- You can import multiple barcodes for single products and product variants.
- Import product by Name, Barcode, Internal Reference.
- Import product image by path/URL.
- Easy to import products with stock on-hand quantity.
- Easy to import custom fields from CSV or Excel.
- Easy to import Text, Integer, Float, Character, Boolean, Selection, Many2one, Many2many custom fields.
First, you need to tick the "Import Product Template" group to import product template.
"Import Products" menu in products.
When you click the "Import Products" button, the wizard will open, here you can choose the import file type(CSV/Excel), method(create product/create or update product), product update by(Barcode/Internal Reference), remove existing(If you tick this tickbox then remove existing barcode otherwise not) and file.
Success message looks like below it shows successfully imported records and also provides a list of unimported records with row number in sheet and relative details of data invalidation.
The following fields are imported.
The following barcodes are imported.
The following fields are imported.
The following fields are imported.
The following fields are imported.
Your CSV file must match like below.
Your Excel file must match like below.
Custom fields format.
Product template import with many2many & custom selection fields.Custom fields format.
Your Excel file must match like below and You can add custom fields column after last column as shown in the below image.
Your CSV file must match like below.
- You can create or update product variants by barcode, name & internal reference.
- You can import multiple barcodes for single products and product variants.
- You can identify the same name product/product variant by "Unique Identification" fields.
- Easy to import Product Variant (image, price, quantity, stock, etc) from CSV or Excel.
- Easy to import custom fields with product variants.
- You can import product images by image URL or local image path.
- Easy to import products with stock on-hand quantity.
First, you need to tick the "Import Product Variants" group to import product Variant.
"Import Product Variants" menu
When you click the "Import Product Variants" button, the wizard will open, here you can choose the import file type(CSV/Excel), method(create product/create or update product), product update by(Name/Barcode/Internal Reference), remove existing(If you tick this tickbox then remove existing barcode otherwise not) and file.
You can create or update product variants by barcode, name & internal reference.
Success message looks like below it shows successfully imported records.
The following product template fields are imported.
We see the imported product "Collar T-Shirt" fields.
Product variants.
The "Sales" tab in the product "Collar T-Shirt".
The following barcodes are imported.
You can configure the product from here.
Product variant imported succesfully.
Using the "Variant" feature you can see product variant details.
Product variant details with qty on hand & UOM.
You can see the product variant field which is imported.
The following custom fields are imported (Text, Integer, Float, Character, Boolean, Selection, Many2one, Many2many custom fields are supported).
In Attribute, Our app works only when "Variants Creation Mode" must be set "Instantly".
Your
CSV/Excel
file
format
must
match
like
below.
In
the
"Can
be
sold
&
purchased?"
take
true
by
default
if
not
provided.
In
the
"Product
type"
take
consumable
by
default
if
not
provided.
Take
the
same
name
as
ERP
in
the
"UOM".
Taxes
are
separated
by
comma(,).
Enter
the
same
text
of
selection
field
the
same
as
ERP
in
the"Invoice
policy"
otherwise
by
default
it
takes
ordered
quantities.
Variant
attributes
like
color,
size,
or
blank.
Enter
the
complete
URL
or
local
path
in
the
"Image
path/URL".
Enter
the
complete
URL
or
local
path
in
the
"Image
path/URL".
Multiple
barcodes
field.
You
can
import
any
number
of
custom
fields.
All
custom
fields
must
exist
on
the
product.product
model.
You
can
import
any
number
of
custom
fields.
All
custom
fields
must
exist
on
the
product.product
model.
You can import variant-wise cost.
Custom fields format.
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.
Result
of
auto-created
record
during
import.
Sample
sheet.
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.
Please
tick
this
option
during
import
to
create
a
record
auto
for
the
product
category.
Result
of
auto-created
record
during
import.
Result
of
auto-created
record
during
import.
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.
Result of auto-created record during import.
Sample sheet.
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.
Please tick this option during import to create a record auto for the product category.
Result of auto-created record during import.
Result of auto-created record during import.
Features
- 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.
"Import POS Order" menu in orders.
After that one wizard will open and it's looks like below.
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.
The following fields are imported.
Your CSV file format must match like below.
Your Excel file format must match like below.
Features
- 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.
First, Tick "Import Images From Zip File" group.
Import images from zip file menu in sale.
Import images from zip file wizard.
Success message after import done.
Below product images are imported.
Import partner images from zip file options.
Below partner images are imported.
Import employee images from zip file options.
Below employee images are imported.
Features
- 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'.
In Attendance, there is a menu for 'Import Attendance'.
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'.
After click 'Apply' this success message will show with the total imported record.
Custom
fields
format.
Import
custom
character
field
"Information".
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.
Your
CSV/Excel
file
format
looks
like
below.
Custom fields format.
Import custom character field "Information".
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.
Your CSV/Excel file format looks like below.
Features
- 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.
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".
You need to tick the "Import Users" group to import the users.
"Import Users" menu in the Users & Companies.
When you click the "Import Users" menu, the wizard will open and it looks like below.
Success message looks like below it shows successfully imported records.
The following users are imported.
User imported with extra rights.
After successfully import, the user can log in with id and password given in sheet, if you try with wrong details then comes alert.
Enter user details for login that given in sheet.
The login screen looks like below.
Features
- 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.
User Setting Enable group 'Import Journal Items'.
As you can see the button 'Import Journal Item' in Journal Entries form view.
After clicking the button 'Import Journal Items' one wizard will popup. Select a file type (CSV or Excel) and upload the file.
After click to apply you see the success message of import.
As you can see the whole imported journal items in line at journal entries.
CSV/Excel file formate must be like this.
Features
- Easy to import
- import csv or excel
- import image by path/url
- Custom fields added.
First you need to tick "Import Customers/Suppliers" groups in order to import customers/suppliers.
"Import Customers/Suppliers" menu in Orders.
When you click "Import Customers/Suppliers" menu, wizard will open and it's looks like below.
Success message looks like below it's shows successfully imported records and also provides list of unimported records with row number in sheet and relative details of data invalidation.
following fields are imported.
Your CSV file format must match like below.
Your Excel file format must match like below.
Custom fields format.
The "GSTIN" & "Tags" custom fields are imported.
Your CSV file must match like below and You can add custom fields column after the last column as shown in the below image.
Your Excel file format looks like below.
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).
Features
- Easy to import
- import csv or excel
- import product image by path/url
- update product based on Barcode/Internal Reference
- Import "Qty On Hand"
- Custom fields added.
First you need to tick "Import Product Template" groups in order to import product template.
"Import Products" menu in Products.
When you click "Import Products" menu, wizard will open and it's looks like below.
Success message looks like below it's shows successfully imported records and also provides list of unimported records with row number in sheet and relative details of data invalidation.
following fields are imported.
Your CSV file format must match like below.
Your Excel file format must match like below.
Custom
fields
format.
Product
template
import
with
many2many
&
custom
selection
fields.
Your
Excel
file
must
match
like
below
and
You
can
add
custom
fields
column
after
last
column
as
shown
in
the
below
image.
Your
CSV
file
must
match
like
below.
Custom fields format.
Product template import with many2many & custom selection fields.
Your Excel file must match like below and You can add custom fields column after last column as shown in the below image.
Your CSV file must match like below.
Features
- 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.
"Import Product Variants" menu.
After that one wizard open here you can import products with product variants From CSV/Excel.
Success message looks like below it shows successfully imported records.
The following product template fields are imported.
We see the imported product A fields.
You can configure the product from here.
Product variant imported succesfully.
Using the "Variant" feature you can see product variant details.
Product variant details with qty on hand.
You can see the product variant field which is imported.
The following custom fields are imported.
In Attribute, Our app works only when "Variants Creation Mode" must be set "Instantly".
Your CSV file format must match like below.
Your Excel file format must match like below.
You can import variant-wise cost.
Custom fields format.
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.
Result
of
auto-created
record
during
import.
Sample
sheet.
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.
Please
tick
this
option
during
import
to
create
a
record
auto
for
the
product
category.
Result
of
auto-created
record
during
import.
Result
of
auto-created
record
during
import.
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.
Result of auto-created record during import.
Sample sheet.
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.
Please tick this option during import to create a record auto for the product category.
Result of auto-created record during import.
Result of auto-created record during import.
Schedule Import Flow
Features
- 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.
"Import Product Image" menu in Products.
When you click "Import Product Image" menu, wizard will open and it's looks like below.
Success message looks like below it's shows successfully imported records and also provides list of unimported records with row number in sheet and relative details of data invalidation.
following Images are imported.
Your CSV file format must match like below.
Your Excel file format must match like below.
Features
- Easy to import
- import csv or excel
- Add product by Name, Barcode, Internal Reference
- Auto Confirm Sale option
- Create customer if never exist option
- Quotation/Order Number auto/as per sheet option
First you need to tick "Import Sale Order" group in order to import sale order
"Import Sale Order" menu in Orders.
When you click "Import Sale Order" menu, wizard will open that looks like below
Success message looks like below it's shows successfully imported records and also provides list of unimported records with row number in sheet and relative details of data invalidation.
following fields are imported.
Your CSV file format must match like below.
Your Excel file format must match like below.
Discount
column
added
in
CSV
sheets
so
that
column
is
imported
when
import
sale
order.
Your
CSV
file
format
must
match
like
below.
Discount
column
added
in
Excel
sheets
so
that
column
is
imported
when
import
sale
order.
Your
Excel
file
format
must
match
like
below.
Discount column added in CSV sheets so that column is imported when import sale order. Your CSV file format must match like below.
Discount column added in Excel sheets so that column is imported when import sale order. Your Excel file format must match like below.
Features
- Easy to import
- import csv or excel
- import product by Name, Barcode, Internal Reference.
- Custom fields added.
First you need to tick "Import Sale Order Lines" group in order to import sale order lines
"Import Sale Order Lines" button in sale order form view.
When you click "Import Sale Order Lines" button, wizard will open that looks like below.
Success message looks like below it's shows successfully imported records and also provides list of unimported records with row number in sheet and relative details of data invalidation.
following sale order lines are imported.
Your CSV file format must match like below.
Your Excel file format must match like below.
Custom fields format.
Sale order line import from CSV sheets with many2many fields.
Your CSV file must match like below and add custom fields after the last column.
Your Excel file must match like below and add custom fields after the last column.
Features
- Easy to import
- import csv or excel
- import stock inventory by product Name, Barcode, Internal Reference
- Import Lot/Serial Number and also create new Lot/Serial Number if never exist
First you need to tick "Import Inventory With Lot/Serial Number" group in order to import stock inventory with lot/serial number
"Import Inventory With Lot/Serial Number" menu in Operations.
When you click "Import Inventory With Lot/Serial Number" menu, wizard will open that looks like below
Success message looks like below it's shows successfully imported records and also provides list of unimported records with row number in sheet and relative details of data invalidation.
Following fields are imported.
New lot/Serial Number created if never exist.
Your CSV file format must match like below.
Your Excel file format must match like below.
Features
- Easy to import
- Import csv or excel
- Import product by Name, Barcode, Internal Reference
- Custom fields added.
First you need to tick "Import Reordering Rules" group in order to import reordering rules
"Import Reordering Rules" menu, In master data.
When you click "Import Reordering Rules" menu, wizard will open that looks like below
Success message looks like below it's shows successfully imported records and also provides list of unimported records with row number in sheet and relative details of data invalidation.
following fields are imported.
Your CSV file format must match like below.
Your Excel file format must match like below.
Custom fields format.
Reordering rules import from CSV/Excel sheets with Many2one & Text fields.
Your CSV file must match like below and You can add custom fields column after the last column as shown in the below image.
Your Excel file format looks like below.
Features
- Easy to import
- Import csv or excel
- Import product by Name, Barcode, Internal Reference
- Auto Confirm Order option
- Create vendor if never exist option.
- Reference Number auto/as per sheet option.
First you need to tick "Import purchase Order" group in order to import purchase order
"Import Purchase Order" menu in Purchase.
When you click "Import Purchase Order" menu, wizard will open that looks like below
Success message looks like below it's shows successfully imported records and also provides list of unimported records with row number in sheet and relative details of data invalidation.
following fields are imported.
Your CSV file format must match like below.
Your Excel file format must match like below.
Features
- Easy to import
- Import csv or excel
- Import product by Name, Barcode, Internal Reference.
- Custom fields added.
First you need to tick "Import Purchase Order Lines" group in order to import Purchase order lines
"Import Purchase Order Lines" button in RFQ/Purchase order form view.
When you click "Import Purchase Order Lines" button, wizard will open that looks like below.
Success message looks like below it's shows successfully imported records and also provides list of unimported records with row number in sheet and relative details of data invalidation.
following Purchase order lines are imported.
Your CSV file format must match like below.
Your Excel file format must match like below.
Custom fields format.
Purchase order line import from CSV sheets with many2many & char fields.
Your CSV file must match like below and add custom fields after the last column.
Purchase order line import from Excel sheets with many2many & char fields.
Your Excel file must match like below and add custom fields after the last column.
Schedule Import Flow
Features
- 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
"Import Supplier Info" menu in purchase.
When you click "Import Supplier Info" menu, wizard will open that looks like below
Success message looks like below it's shows successfully imported records and also provides list of unimported records with row number in sheet and relative details of data invalidation.
following fields are imported.
Your CSV file format must match like below.
Your Excel file format must match like below.
Custom fields format.
Import custom character field "Information".
Your CSV file must match like below and add custom fields after the last column.
Your Excel file must match like below and add custom fields after the last column.
New Updates
First, you need to tick the "Import Supplier Info" group to import the Import Supplier Info.
When you click the "Import Supplier Info" menu, the wizard will open, you can see "Create Supplier & Create Or Update Supplier" field.
Upload file.
Success message looks like below it shows successfully imported records.
The following record is imported.
Your CSV/XLS file format must match like below.
Features
- 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
"Import Invoice" menu in Customers.
When you click "Import Invoice" menu, wizard will open that looks like below
Success message looks like below it's shows successfully imported records and also provides list of unimported records with row number in sheet and relative details of data invalidation.
following fields are imported.
Your CSV file format must match like below.
Your Excel file format must match like below.
When you click the "Import Invoice" menu, the wizard will open, you have to choose an account as per requirement.
Your CSV file format must match like below.
Your Excel file format must match like below.
Features
- Easy to import
- Import csv or excel
- Import product by Name, Barcode, Internal Reference
- Import invoice/bill lines
- Import Customer/Vendor Credit Notes lines
- Custom fields added.
First you need to tick "Import Invoice/Bill/Credit note Lines" group in order to import invoice/bill/credit note lines
"Import Invoice/Credit note Lines" button in customer invoice form view.
When you click "Import Invoice/Credit note Lines" button, wizard will open that looks like below.
Success message looks like below it's shows successfully imported records and also provides list of unimported records with row number in sheet and relative details of data invalidation.
following invoice lines are imported.
You can also import customer credit note lines
You can also import Vendor Bill lines
You can also import vendor credit note lines
Your csv file must match like below
Your excel file must match like below
Custom fields format.
Account Move Line Import from CSV sheets with many2many fields.
Your CSV file must match like below and You can add custom fields column after 'Taxes' column as shown in the below image.
Import custom fields for Bills.
Your Excel file must match like below and add custom fields after the 'Taxes' column.
Features
- 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
"Import Bill of Materials" menu in master data.
When you click "Import Bill of Materials" menu, wizard will open that looks like below
Success message looks like below it's shows successfully imported records and also provides list of unimported records with row number in sheet and relative details of data invalidation.
following fields are imported.
Your CSV file format must match like below.
Your Excel file format must match like below.
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.
Your CSV file format must match like below.
Your Excel file format must match like below.
Features
- 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.
Import Task menu in project.
default import wizard.
Project and user wise import wizard.
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.
Imported task looks like below.
Default import csv file format (your file format must match like below).
Default import excel file format (your file format must match like below).
User and project wise import csv file format (your file format must match like below).
User and project wise import excel file format (your file format must match like below).
Custom fields format.
Custom fields imported with many2one & many2many fields.
Default imported CSV file format with custom fields.
Default imported Excel file format with custom fields.
User and project wise imported CSV file format with custom fields.
User and project wise imported Excel file format with custom fields.
Features
- Easy to import
- Import csv or excel
- Custom fields added.
First you need to tick "Import Lead" groups in order to import lead.
"Import leads" menu Leads.
"Import leads" menu in CRM and default import wizard. Just select file type and upload your file and hit "apply" button.
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.
Imported leads looks like below.
Your csv file format must match like below.
Your excel file format must match like below.
Custom fields format.
The "Contact Name", "Tags" & "Sales Team" custom fields are imported.
Your CSV file must match like below and You can add custom fields column after the last column as shown in the below image.
Your Excel file format looks like below.
Features
- 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.
"Import Employee Image" menu in Configuration.
When you click "Import Employee Image" menu, wizard will open and it's looks like below.
Success message looks like below it's shows successfully imported records and also provides list of unimported records with row number in sheet and relative details of data invalidation.
following Images are imported.
Your CSV file format must match like below.
Your Excel file format must match like below.
Features
- Easy to import
- Import csv or excel
- Custom fields added.
First you need to tick "Import Employee Timesheet" group in order to import timesheet.
"Import Timesheet" menu in Timesheet.
When you click "Import Timesheet" menu, wizard will open and it's looks like below.
Success message looks like below it's shows successfully imported records and also provides list of unimported records with row number in sheet and relative details of data invalidation.
following Timesheets are imported.
Your CSV file format must match like below.
Your Excel file format must match like below.
Custom fields format.
Import custom field with many2many fields.
Your Excel file must match like below and You can add custom fields column after the last column as shown in the below image.
Your CSV file format looks like below.
Features
- 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
"Import Internal Transfer" menu in Operations.
When you click "Import Internal Transfer" menu, wizard will open that looks like below
Success message looks like below it's shows successfully imported records and also provides list of unimported records with row number in sheet and relative details of data invalidation.
following fields are imported.
Your CSV file format must match like below.
Your Excel file format must match like below.
Features
- 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.
"Import Customer Image" menu in Orders.
When you click "Import Customer Image" menu, wizard will open and it's looks like below.
Success message looks like below it's shows successfully imported records and also provides list of unimported records with row number in sheet and relative details of data invalidation.
following Images are imported.
Your CSV file format must match like below.
Your Excel file format must match like below.
These screenshots are taken in Odoo 16 version. We will be updating new screenshots in the near future. If you have any queries, please feel free to reach out to us at support
To import a purchase order, click on the 'Import PO'.
In the import PO wizard, you have the option to select the vendor by their Name, Reference, or Id.
To import a sale order, click on the 'Import SO'.
In the import SO wizard, you have the option to select the customer by their Name, Reference, or Id.
To import a invoice, click on the 'Import Invoice'.
In the import invoice wizard, you have the option to select the customer by their Name, Reference, or Id.
To import a journal entry, click on the 'Import Journal Entry'.
In the import journal entry wizard, you have the option to select the customer by their Name, Reference, or Id.
To import a journal entry, click on the 'Import Invoice With Payment'.
In the import invoice wizard, you have the option to select the customer by their Name, Reference, or Id.
Form view of the journal entry. You can import journal items by clicking on that button.
In the import journal items wizard, you have the option to select the customer by their Name, Reference, or Id.
To import a pos orders, click on the 'Import POS'.
In the import pos order wizard, you have the option to select the customer by their Name, Reference, or Id.
Version 17.0.1 | Released on : 9th December 2023
Initial
Initial
Release.
- Yes, this app works perfectly with Odoo Enterprise (Odoo.sh & Premise) as well as Community.
- Please Contact Us at [email protected]to request customization.
- Yes, we provide free support for 100 days.
- Yes, you will get free update for lifetime.
- No, you don't need to install addition libraries.
- Yes, You have to download module for each version (13,14,15) except in version 12 or lower.
- No, this application is not compatible with odoo.com(odoo saas).
- No, We do not provide any kind of exchange.
Multi-Languages
You May Also Like
Most Demanded Apps
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.