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

by
Odoo 2
v 12.0 Third Party 22

59.00 €

You bought this module and need support ? Click here !
Technical name gt_generic_import
LicenseSee License tab
Websitehttps://www.globalteckz.com
Read description for v 11.0 v 10.0
Required Apps Inventory (stock)
Invoicing (account)
Manufacturing (mrp)
Sales (sale_management)
Purchase (purchase)
Sales (sale)
Technical name gt_generic_import
LicenseSee License tab
Websitehttps://www.globalteckz.com
Read description for v 11.0 v 10.0
Required Apps Inventory (stock)
Invoicing (account)
Manufacturing (mrp)
Sales (sale_management)
Purchase (purchase)
Sales (sale)

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.

With the help of this module you can Import all the data such as :
  • Import invoice
  • Import customer
  • Import supplier
  • Import product
  • Import purchase order
  • Import sale order
  • Import inventory
  • Import BOM (Bill of Materials)
Some of the Features of this Module
  • Import sales order using Odoo sequence
  • Import sales order using own sequence
  • Import Purchase Order using odoo sequence
  • Import Purchase Order using own sequence
  • Import Purchase Order with state
  • Import products
  • Import picking
  • Import Payments customer payments
  • Import Payments Supplier payments
  • Import Partners
  • Import invoices using Odoo sequence
  • Import invoices using own sequence
  • Import invoices with invoice state (validate, Draft
  • Import invoices by customer or Supplier type
  • Import inventory with Name
  • Import inventory with Code
  • Import inventory with Barcode
  • Import inventory with Serial/lot number with expiry date
  • Import inventory for particular location
  • Import Bill of Materials

Here we go with the presentation of the Odoo App

Click on install button to install the module

Import Sales Order / Order line

After installing the module follow the points number which is shows in screenshots.
(1) Click on Sale button It will navigate you to sale page.
(2) Click on import sales button it will open import sales order wizard form where you can import the csv/xls file

(1) select file type which you want to upload like (csv/xls)
(2) click on upload your file button and attach the file you want to upload
(3) select sequence type of the each records.
(4) select the state of the records which is imported by file which you have attached

All sales order data should be in same sequence in file which is shown in screenshot

After importing xls/csv file the record will create and it shows in list view

In this screenshot you can see the details of record which was imported in xls/csv file and also whatever options you selected in wizard form according to that record has created.

(1) file type has changed from xls to csv
(2) file has attached csv file
(3) sequence of all record has changed from file sequence to system sequence

In this screenshot you can see the record has created

In this screenshot you can see the information has generated according to csv file and option you have changed wizard

Import Invoice / Inovice Lines

In this screenshot you can see the details available in xls file is only for creating the invoice.The data structure should be in same sequence which is shows in file.

(1) By click on Invoicing button It will navigate you to invoice page.
(2). By click on import invoice button it will open import invoice wizard form where you can import the csv/xls file.

(1) select file type which you want to upload like (csv/xls)
(2) click on upload your file button and attach the file you want to upload
(3) select sequence type of the each records.
(4) select the state of the records which is imported by file which you have attached
(5) select the type of invoice for generate invoice

After importing xls/csv file the record will creating and it will shows in list view

In this screenshot you can see the details of record which was imported by xls/csv file and also whatever options you selected in wizard form according to that record has created.

(1) file type has changed from xls to csv
(2) file has attached csv file
(3) sequence of all record has changed from file sequence to system sequence
(4) This time state selection will be change from validate to draft state

After importing csv file and according to wizard option the record has created

In this screenshot you can see the information has generated according to csv file and option you have changed from wizard
(1) csv file data shows
(2) The record state is in draft state as you were chosen in wizard form
(3) According to sequence option you selected, the sequence of each record is in systems default sequence

Import Inventory

Below screenshot shows the details information about creating the inventory in three different ways like using barcode, code, and name of the products

For create inventory by uploading xls and csv file.
(1) Click on inventory button on top of the screen
(2) Click on import inventory button for opening import inventory wizard

(1) Enter the inventory name
(2) Select file type which you want to upload
(3) If import serial/lot number with expiry date checkbox checked then it will also import and create the serial/lot number
(4) Select the inventory location
(5) Select the import product by using (barcode, code, name)which is already available in xls or csv file.
(6) Attach xls/csv file for import data

As you can see the inventory has created which is shows in list view

(1) In this screenshot we can see the name of inventory was given on wizard which was shown above the csv file
(2) As we selected the import product by option was barcode and we checked the import serial/lot no with expiry date checkbox based on that products with serial/lot no has created

(1) Click on Lots/Serial Number menu for open the lots/serial numbers form
(2) As we can see the whatever lots/serial number we had imported with products in xls/csv file has created in this place.

(1) It shows the lot/serial number which is came from xls and csv file
(2) Whatever barcode had in xls file based on that the product will be selecting.
(3) And also expiry date came from xls/csv file with each barcode,code,name

Import Purchase Order / Purchase Order Line

In this screenshot as you can see the details available in xls file is only for creating the purchase order. The data structure should be in same sequence which is shows in file.

(1) Click on Purchase button for navigate to purchase order form.
(2) Click on import purchase order button for open import xls/csv file file where you can attach file for create purchase order.

(1) select file type which you want to upload like (csv/xls)
(2) click on upload your file button and attach the file you want to upload
(3) select the state of the records which is imported by file that you have attached
(4) select sequence type of the each records.

After importing xls/csv file the record will creating and it will shows in list view

In this screenshot as you can see the details of record which was imported by xls/csv file and whatever options we selected in wizard form according to that record has created.
(1) As we had selected file sequence from wizard form the system will accepted the file sequence.
(2) The record data shows which is available in file.
(3) The record is in draft state as we had selected option on wizard form

(1) File type has changed from xls to csv
(2) File has attached csv file
(3) This time state selection will be change from validate to draft state
(4) Sequence of all record has changed from file sequence to system sequence

(1) As the record sequence will be system sequence
(2) Data has shows as csv file has
(3) State on draft state

Import Customer Inovice / Import Supplier Invoice

In this screenshot data shows in xls file is for creating Customer/Supplier Payments. The data file structure should be same for form import payment

(1) Click on Invoice button for navigate to invoice page
(2) Click on import payment button for open wizard form where we can import xls/csv file for create payments

(1) Select the payment for
(2) Attach xls/csv file for import data

As we can see the whatever data in xls file which we had imported accordingly the record has generated

(1) Payment option changed from customer to supplier
(2) Attach xls file for import data

As we can see the record has generated after importing the xls file

Import Customer / Supplier

(1) For create customers by uploading xls/csv file, click on sale button for navigate to sale form and we can see the import partner button at left side bottom.
(2) Click on that button for open wizard form form import file.

(1) Select file type you want to upload
(2) Click on upload button and select and attach file you want to import

(1) Click on customer button for shows all customers information.
(2) As we can see customer has created.

(1) Customer name
(2) Detail information about customer which we had imported file

Import Products

In this screenshot the data shows in xls file is for generating product by importing file.All data should be in sequence according to header

(1) For create product click on sale button for navigate to sale order form. (2) On left side menu click on import products button for open import product wizard

(1) Select file type which we want to upload (2) Click on upload file button and select or attach file we want to import

(1) As we can see the product has created after the import the file (2) The file has total 3 records according that three product has created

As we can see product name and other details for particular product shows in form.

Import journals entry line

In this screenshot the data shows in xls file is for generating journal items/lines by importing file.All data should be in sequence according to header

(1) For create journal items/lines click on Invoicing button for navigate to invoice form.
(2) On left side menu click on Journal Entries button for open journal entries form.
(3) As we can see there is already one record created now we just have to open it.

(1) On this point we can see there is no lines/items currently available in journal
(2) For import journal items/lines click on Import Journal button

(1) Select file type which you want to import
(2) Attach xls/csv file for import journal items/lines

As we can see journal items/lines imported after click on import button from wizard.

Import statement Line

In this screenshot the data shows in xls file is for generating bank statement lines by importing file.All data should be in sequence according to header

(1) For create bank statement lines click on Invoicing button for navigate to invoice form.
(2) On center of the dashboard click on New Statement link button for open bank statement form.

(1) Enter the reference name for new statement.
(2) As we can see at the bottom there is no statement/transaction line shows.
(3) For import bank statement lines click on Add Line button.

(1) Select file type which you want to import
(2) Attach xls/csv file for import account statement transactions/lines

As we can see bank statement transactions/lines imported after click on import button from wizard.

Import BOM (Bill of Materials)

In this screenshot the data shows in xls file is for generating BOM and bom lines by importing xml file.All data should be in sequence according to header

(1) For create BOM and bom lines click on Manufacturing button for navigate to manufacturing form.
(2) Click on Import BOM button for open impor mrp wizard form.

(1) Select file type which you want to import
(2) Select type of bom which you want to create.
(3) Attach xls/csv file for import account statement transactions/lines

As you can see record has generated

(1) The main product(Product template) comes from xls file
(2) Product reference number for main product
(3) As you selected bom type from wizard which is selected
(4) Bom lines imported for create mai product.

Before installing module install the below packages

1. sudo pip install xlrd
or
sudo apt-get install python-xlrd
2. sudo pip install xlwt
or
sudo apt-get install python-xlwt

1 Year 360 Free Support

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 can be helpful for your business feel free to email us on sales@globalteckz.com or raise a ticket on support

Globalteckz

Official Odoo Partner

Odoo Support / Customisation Service

You can contact us for further Odoo Support, Odoo customisation, Odoo implementation, Odoo 3rd Party integration with any software, Odoo training, You can communicate with any mode to contact us.

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

Odoo
Good App
by on

good extension working perfectly


Odoo
Perfect
by on

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