Odoo all import for BOM, Sales, Purchase, Invoice, Inventory, Customer/Supplier Payment, Bank Statement, Journal Entry, Picking, Product, Customer.

by
Odoo

53.37

v 10.0 v 11.0 v 12.0 Third Party 71
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Inventory (stock)
Invoicing (account)
Manufacturing (mrp)
Purchase (purchase)
Sales (sale_management)
Discuss (mail)
Lines of code 2232
Technical Name gt_generic_import
LicenseSee License tab
Websitehttps://www.globalteckz.com
Versions 17.0 16.0 10.0 14.0 13.0 15.0 11.0 12.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Inventory (stock)
Invoicing (account)
Manufacturing (mrp)
Purchase (purchase)
Sales (sale_management)
Discuss (mail)
Lines of code 2232
Technical Name gt_generic_import
LicenseSee License tab
Websitehttps://www.globalteckz.com
Versions 17.0 16.0 10.0 14.0 13.0 15.0 11.0 12.0

Odoo Import for BOM, Sales, Purchase, Invoice, Inventory, Payment, Picking, Product and Customer using csv/xls

Importing Multiple data is time consuming and problematic area as Odoo user use many apps to import different data, there are chances where you may have un even sequences of data if you are using multiple apps for data import. Now with this app you can import all your data such as sales, purchase, invoice, inventory, products and so on . . . . very easily, which reduces time, efforts and issues during data import from multiple modules of Odoo. This module will help user to easily creating bunch of records in sales, invoice, purchase, inventory, payment, picking, products and customers by importing csv and xls file in Odoo.

This module will provide with below features

  • Import Sales Order
  • Import Products
  • Import Customers
  • Import Suppliers
  • Import Purchase order
  • Import Inventory
  • Import Bill of Materials (BOM)
  • Import Shipment / Delivery Order
  • Import Customer invoice
  • Import Supplier invoice
  • Import Customer Payment
  • Import Supplier payment
  • Import Journal entries
  • Import Bank Statement
  • Logs to track the missing records not imported

Import Sales Order / Order line

(1) Click on Sale button It will navigate you to sale page.
(2) Click on import sales it will help to import the sales order with csv/xls file

(1) select file type as XLS in this example
(2) Select in which state you want to import order can be in quotation or confirm
(3) select sequence type
(4) click on upload your file button and attach the file you want to upload
(5) You can select the operation to create or skip if product not found in system and available in xls file.

XLS file format sample which will help to import the sales order

Here it can been that product was not available in system and we selected operation as create so it created the product with same name.

As per the xls sheet order is imported with taxes, in the below screnshot

Now will take example of csv format
(1) select file type as CSV
(2) Select in which state you want to import order can be in quotation or confirm
(3) select sequence type
(4) click on upload your file button and attach the file you want to upload
(5) You can select the operation to create or skip if product not found in system and available in xls file.

CSV format template

As Skip was selected that if product not found in system dont import in the system, for that logs can be maintained

Import Products

(1) Click on Sale button It will navigate you to sale page.
(2) Click on import Product it will help to import the product with csv/xls file

There are 2 options to import the products via xls / csv now will use xls format to import

Template for importing the products with detail fields as per the standard are added in the template

Imported the products with xls format product got created with all fields added in the xls template















There are 2 options to import the products via xls / csv now will use csv format

Template for importing the products with detail fields as per the standard are added in the template

Imported the products with xls format product got created with all fields added in the csv template

Import Partner

(1) Click on Sale button It will navigate you to sale module.
(2) Click on import Partner it will help to import the customers and suppliers with csv/xls file

While importing partner there are options via csv/xls now will use as xls to import partner

Template for importing the partner with detail fields as per the standard are added in the template

Imported the partners with xls format partner got created with all fields added in the xls template





There are 2 options to import the partners via xls / csv now will use csv format

Template for importing the partners with detail fields as per the standard are added in the template

Imported the partners with csv format partner got created with all fields added in the csv template

Import Purchase Order

(1) Click on Purchase module It will navigate you to purchase module.
(2) Click on configuration and than import purchase order and it will open the wizard to import purchase order

(1) select file type as XLS in this example
(2) Select in which state you want to import purchase order it can be in Draft or confirm
(3) select sequence options
(4) click on upload your file button and attach the file you want to upload
(5) You can select the operation to create or skip if product not found in system and available in xls file.

Template file to import purchase order with all necassary fields

Purchase order got imported as per the template and the options selected in the wizard

Now will import the purchase order with csv format with other options which are available

Template file to import purchase order in csv format

Purchase order got imported as per the template and the options selected in the wizard

Import Inventory

(1) Click on Inventory module It will navigate you to inventory module.
(2) Click on Master data and than import inventory and it will open the wizard to import inventory

There are 2 options to import the inventory via xls / csv now will use csv format, if create option is selected it will create the product if not found in system while importing inventory

Template to import inventory with Barcode, Code and Name, in template you can replace the column name if you want to import via barcode, code and name as per the options selected

Imported the inventory with xls format inventory adjustment got created with all fields added in the csv template



There are 2 options to import the products via xls / csv now will use xls format, now will operation to skip the product if not found in system while importing the inventory

As we selected operation as Skip so product was not available in system while importing inventory so it skipped and shown in logs why it didnt imported

Import Bill of Materials (BOM)

(1) Click on MRP module It will navigate you to MRP page.
(2) Click on configuration and than import BOM it will help to import the BOM with csv/xls file

(1) select file type as XLS in this example
(2) Import product can be done by Name, barcode and code. In template change the column accordingly
(3) BOM can be created or update if already exists in system
(4) Operation can create or skip it.
(5) You can select the operation to create or skip if product not found in system and available in xls file.

Template for importing the BOM with detail fields as per the standard are added in the template

As selected option was create so now product not exists in system

After importing BOM now products are also created in Odoo







Now will have csv format for importing BOM with update of BOM as selected so it dont create and update existing BOM.



As we have selected as operation as Skip so it shows in logs that is been not imported or updated as product was not available in system

Import Shipments / Delivery Order

(1) Click on Inventory module It will navigate you to inventory module.
(2) Click on Operations and than import shipment/delivery order it will open the wizard to import shipment/delivery

(1) select file type as XLS in this example
(2) Select the sequence as default of odoo or file sequence need to be imported
(3) Import stage to create in Draft or validated
(4) Operation can create or skip if product or partner is not available in system

Template for importing the shipment/delivery order with detail fields as per the standard are added in the template

Delivery order is been created from the template which is been fulfiled

Now will import picking with csv format with options as per required

Imported the Picking with csv format with state as draft

Import customer/supplier invoice

(1) Click on Accounting module It will navigate you to accounting module.
(2) Click on Configuration than on import invoice which will help to import invoices

(1) select file type as XLS in this example
(2) Type as customer invoice
(3) Sequence options to be as system or xls to be imported
(4) Accounting options use from product category or use mentioned in file
(5) Import product with Barcode, code or Name it be change in template from which options needs to be imported
(6) Invoice stage can be in draft or validated
(7) Operations to create the product if missing in system and added in file.

Template for importing the invoices with detail fields as per the standard are added in the template

Here customer invoice got imported as per the template file.

Now will have csv format import of Supplier invoice with all options highlighted in screenshot

As taxes was not in system and skip operation was selected so it shows in log that taxes are missing.

Created new options in wizard and create supplier invoice

Import Payment

(1) Click on Accounting module It will navigate you to accounting module.
(2) Click on configuration than import payment which will help to import payments

(1) select file type as XLS in this example
(2) Payment to customer or supplier
(3) State can be Draft or posted as required
(4) Operation can create or skip as required

Template for importing payments

Payments got imported as per the template as options selected

Now with csv will import supplier payments with options required

Supplier payment got imported as per the options selected

Import Journal entries

(1) Click on Accounting module It will navigate you to accounting module.
(2) Click on configuration than import journal entries which will help to import journal entries.

(1) select file type as XLS in this example
(2) Import state as Draft or Validated
(3) Sequence option can be file or system sequence
(4) Operations can be created or skip if partner not found

Template for importing Journal entries

As per the template and options selected in wizard journal entries are imported

Now will have csv format to import journal entries

Template for importing Journal entries with csv format

Import Bank Statement

(1) Click on Accounting module It will navigate you to accounting module.
(2) Click on configuration than import bank statement which will help to import statements

(1) select file type as XLS in this example
(2) State can be Draft or posted as required
(3) Operation can create or skip if partner is not available in system as required

Template file for importing bank statement

As per the template and options selected in wizard bank statements are imported



Now will have csv format to import Bank statement

Template for importing Bank statement with csv format

Maintain logs for what is been skipped or not imported from the template is been prepared which can be seen Sales -> Generic Logs -> Generic import logs

Free support for 90 days

Contact Us for any problem for Odoo Magento connector

You will be provided with Free support for 1 year in case any bugs or support while installing and testing the module. Free updates of modules for 1 year for the client who have purchased our connector.

Get Free Odoo Consultancy

Our team at Globalteckz is not only bound to provide support for this particular app. Incase of any other issues related to Odoo or Magento you would like to discuss feel free to connect with us via email – info@globalteckz.com. We ensure you proper Odoo Consultancy for the development of the solution.

About Globalteckz :

Globalteckz is an official Odoo partner completed more than 50+ Odoo projects across the globe. Quality is key of our coding and we follow strict rules on Odoo Standard coding ensuring every module is bug free. At GlobalTeckz we specialize in providing ERP implementation using the best of industry methodology that ensures successful ERP implementation. Be it manufacturing trading or eCommerce industry our resource thrive to make every project success for our clients.
If you feel that this module (Odoo Magento Connector) can be helpful for your business feel free to email us on sales@globalteckz.com or raise a ticket on support

Get Help & Support


Odoo Proprietary License v1.0

This software and associated files (the "Software") may only be used (executed,
modified, executed after modifications) if you have purchased a valid license
from the authors, typically via Odoo Apps, or if you have received a written
agreement from the authors of the Software (see the COPYRIGHT file).

You may develop Odoo modules that use the Software as a library (typically
by depending on it, importing it and using its resources), but without copying
any source code or material from the Software. You may distribute those
modules under the license of your choice, provided that this license is
compatible with the terms of the Odoo Proprietary License (For example:
LGPL, MIT, or proprietary licenses similar to this one).

It is forbidden to publish, distribute, sublicense, or sell copies of the Software
or modified copies of the Software.

The above copyright notice and this permission notice must be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM,
DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
DEALINGS IN THE SOFTWARE.

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.
Good App
by
Khadija
on 5/6/19, 3:25 AM

good extension working perfectly


Perfect
by
RAMACOM
on 2/10/19, 3:00 PM

The company is perfect . even i wanted some modification and the Company provided a dedicated Developer and helped me till end of my job done . Excellent Job done by Shoib Anwar for tremendous Support . I have purchased Health Management system from this company and my customer is very happy . Wish you more success for the out of the box services . GOOD LUCK


Good App
by
Ali Khalid
on 2/24/20, 8:02 AM

Could you please give me demo on this app.


Good App
by
Ali Khalid
on 2/24/20, 8:01 AM

Could you please give me demo on this app.


What about odoo 13?
by
adil adil
on 1/12/20, 6:34 PM

Hello please, could you confirm to me if this module is developed for Odoo 13? regards

Re: What about odoo 13?
by
Globalteckz
on 1/15/20, 11:11 AM Author

Hi Adil, We will be migrating in few days, its still not migrated Thanks


Import Partner error
by
Paul
on 10/10/19, 4:20 AM Confirmed Purchase

Is it because my template is not used correctly? Please help me, thank you. Odoo Server Error Traceback (most recent call last): File "/usr/lib/python3/dist-packages/odoo/http.py", line 656, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/usr/lib/python3/dist-packages/odoo/http.py", line 314, in _handle_exception raise pycompat.reraise(type(exception), exception, sys.exc_info()[2]) File "/usr/lib/python3/dist-packages/odoo/tools/pycompat.py", line 87, in reraise raise value File "/usr/lib/python3/dist-packages/odoo/http.py", line 698, in dispatch result = self._call_function(**self.params) File "/usr/lib/python3/dist-packages/odoo/http.py", line 346, in _call_function return checked_call(self.db, *args, **kwargs) File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 97, in wrapper return f(dbname, *args, **kwargs) File "/usr/lib/python3/dist-packages/odoo/http.py", line 339, in checked_call result = self.endpoint(*a, **kw) File "/usr/lib/python3/dist-packages/odoo/http.py", line 941, in __call__ return self.method(*args, **kw) File "/usr/lib/python3/dist-packages/odoo/http.py", line 519, in response_wrap response = f(*args, **kw) File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 966, in call_button action = self._call_kw(model, method, args, {}) File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 954, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "/usr/lib/python3/dist-packages/odoo/api.py", line 749, in call_kw return _call_kw_multi(method, model, args, kwargs) File "/usr/lib/python3/dist-packages/odoo/api.py", line 736, in _call_kw_multi result = method(recs, *args, **kwargs) File "/usr/lib/python3/dist-packages/odoo/addons/gt_generic_import/models/partner_wizard.py", line 97, in Import_partner if row[17]: IndexError: list index out of range

Re: Import Partner error
by
Globalteckz
on 10/10/19, 5:37 AM Author

Hi Paul, Can you please email on info@globalteckz.com for further support Thanks