Import Product, Customer/Vendor, Sales Order, Purchase Order, Customer Invoice/ Vendor Bill, Stock, Picking, bank Statement, Journal Items, Customer/Supplier Payment
Available Key Features
- You can Import all Data in Odoo using XLS/CSV.
- Import Product, Customer/Vendor, Sales Order, Purchase Order, Customer Invoice/ Vendor Bill, Stock, Picking, bank Statement, Journal Items, Customer/Supplier Payment.
- Generate invoices / bills number from sequence or from file using CSV/XLS
- All sample file available in each modules.
Path:- static > Sample File - Please check date format pattern per modules
1. Import Products
![](/apps/assets/16.0/ip_import_all/img/import_pro_excel.png)
![](/apps/assets/16.0/ip_import_all/img/import_product_stock.png)
![](/apps/assets/16.0/ip_import_all/img/import_products_wiz.png)
2. Import Customer/Vendor
![](/apps/assets/16.0/ip_import_all/img/contact_excel.png)
![](/apps/assets/16.0/ip_import_all/img/cust_ven_excel.png)
![](/apps/assets/16.0/ip_import_all/img/import_contacts.png)
![](/apps/assets/16.0/ip_import_all/img/import_cust_ven.png)
![](/apps/assets/16.0/ip_import_all/img/show_contacts.png)
3. Import Sale Orders
![](/apps/assets/16.0/ip_import_all/img/sale_order_excel.png)
![](/apps/assets/16.0/ip_import_all/img/import_sale_order_menu.png)
![](/apps/assets/16.0/ip_import_all/img/import_sale_order.png)
4. Import Purchase Orders
![](/apps/assets/16.0/ip_import_all/img/purchase_order_excel.png)
![](/apps/assets/16.0/ip_import_all/img/purchase_order_import.png)
![](/apps/assets/16.0/ip_import_all/img/purchase_order_menu.png)
5. Import Customer Invoice / Vendor Bills
![](/apps/assets/16.0/ip_import_all/img/customer_invoice_excel.png)
![](/apps/assets/16.0/ip_import_all/img/customer_invoice_menu.png)
![](/apps/assets/16.0/ip_import_all/img/customer_invoice_wiz.png)
6. Import Shipment/Delivery/Internal Transfer
By Product Name:
![](/apps/assets/16.0/ip_import_all/img/operation_with_name.png)
![](/apps/assets/16.0/ip_import_all/img/operation_with_barcode.png)
![](/apps/assets/16.0/ip_import_all/img/operation_with_code.png)
![](/apps/assets/16.0/ip_import_all/img/import_operation_menu.png)
![](/apps/assets/16.0/ip_import_all/img/import_operation_wiz.png)
7. Import Stock Inventory with Serial/Lot Number
By Name:
![](/apps/assets/16.0/ip_import_all/img/import_with_name.png)
![](/apps/assets/16.0/ip_import_all/img/imports_with_barcode.png)
![](/apps/assets/16.0/ip_import_all/img/import_with_code.png)
![](/apps/assets/16.0/ip_import_all/img/import_inventory_menu.png)
![](/apps/assets/16.0/ip_import_all/img/import_inventory_wizard.png)
8. Import Journal Items
![](/apps/assets/16.0/ip_import_all/img/import_journal_entry_excel.png)
![](/apps/assets/16.0/ip_import_all/img/import_journal_entries_menu.png)
![](/apps/assets/16.0/ip_import_all/img/import_journal_entries_wiz.png)
9. Import Bank Statements
![](/apps/assets/16.0/ip_import_all/img/statement_excel.png)
![](/apps/assets/16.0/ip_import_all/img/import_bank_statement_menu.png)
![](/apps/assets/16.0/ip_import_all/img/import_bank_statement_wiz.png)
10. Import Payment
![](/apps/assets/16.0/ip_import_all/img/import_payment_excel.png)
![](/apps/assets/16.0/ip_import_all/img/import_payment_menu.png)
![](/apps/assets/16.0/ip_import_all/img/import_payment_wiz.png)
Installation Guide
Before installing this module you have to install following packages.
>> sudo pip / pip3 install xlrd
>> sudo pip / pip3 install xlwt
OR
>> sudo apt-get install python-xlrd
>> sudo apt-get install python-xlwt
Install Following Packages:
- xlrd
- xlwt
>> sudo pip / pip3 install xlrd
>> sudo pip / pip3 install xlwt
OR
>> sudo apt-get install python-xlrd
>> sudo apt-get install python-xlwt
Technical Help , Queries & Support
For any other assistance related to the new Odoo feature, customization or Odoo Development.