Odoo all import for Sales, Purchase, Invoice, Inventory, Picking, Product and Customer.

by
Odoo          
v 11.0 Third Party 47

89.00 €

Add to Cart
Technical name bi_generic_import
LicenseOPL-1
Also available for v 10.0 v 9.0 v 8.0

All in one Import for Sales, Purchase, Invoice, Inventory, Picking, Product and Customer.

Importing all kind of data now easy never been before, Importing different sort of data is always been headache,Module is like VLC player of Odoo.

It can import all important data whether its Sales, Purchases, Invoice, Inventory Product, Customer and Picking ,How resourceful it is ,It can reduce you work efforts and makes your life hassle free.

key features:

  • You can import different data of Sales, Purchase, Invoice and Inventory in this single module.
  • You can easily import Customer and Sales Invoices.
  • You can add multiple lines in single order.
  • You can add different Currency of invoices in single import.
  • Module will be suppported in both Enterprise and Community version.

All in one Import


Import Multiple Tax.

If there is need of adding tax you can add multiple tax separate with semicolon but if there is no need of adding tax you have to leave it blank.

Import data with Currency/Pricelist.

You can import data with different Currency/PriceList for different orders(Sale,Purchase Order,Invoice).

Import Sequence Number.

You can Import Sale, Purchase and Invoice number which is available in your Database instead of default that Odoo provides.

Import Date.

You can Import Date which you have in your Database instead of default that Odoo provides.

Different Warning.

You will have Different Warning which avoids the error on import time(you can see this below with details).

CSV/XLS File Format.

You can import CSV or XLS file both as per as your convinience. In this module sample of import files are given,It is mandatory to use given format to create CSV or XLS file.You need to maintain the column order.

Support Translation.

If there is need of translation then this module also support language translation.

Support For 90 Days

As this module is the very useful for all type of Industries. You can contact us for any Query regarding this Module.

Sample Excel.

Given is the sample of import file,It is mandatory to use given format to create CSV or XLS file.You need to maintain the column order.

Generate Sequence Number

You can Import Sale, Purchase and Invoice number which is available in your Database instead of default that Odoo provides.

Import Bulk Data.

You can import multiple(bulk of) lines in single order.

How to use

How to Import Data of Invoice

INVOICE ID
- Invoice number for the invoice.
PARTNER
- Vendor/Customer name for the invoice order.
CURRENCY
- Currency for the invoice.
PRODUCT
- Product name for the invoice order.
QUANTITY
- Quantity for the above product.
UOM
- UOM for the above product.
DESCRIPTION
- Description for the product
PRICE
- Price for the above product.
Salesperson
-Name of salesperson
Date
-Date of invoice
TAX
-Tax for the product

Given below is the sample of import file.

The "INVOICE ID" should be same, as you can see in the image,"INVOICE ID" is same for different product list.This defines single invoice with different product lines.

Tax column is important you have to add "Tax column" though there is no need of adding tax.


Figure shows the menu for importing data of Invoices.


Import Invoice Wizard

If you want to import details of invoice number from CSV/XLS you can also have option regarding this in import invoice wizard.

If you select "Use Excel/CSV Sequence Number" option then name field will came from CSV/XLS file.


After importing CSV/XLS you can see the invoice number is same as we given in CSV/XLS file.


Views

This is the tree of invoice created from given data file.


If you select "Use System Default Sequence Number" option then name field will follow the system sequence.


If all taxes are found in system then invoice will be generated.


It will generate error if you import wrong partner which is shown in Figure.

It will also generates errors when you import wrong value of Currency,Pricelist,UOM,Salesperson and Tax.


How to Import Data of Sales Order.


ORDER
- Sale order number
CUSTOMER
- Customer name for the sale order.
PRICELIST
- Pricelist is used for identify Currency for the sale order.
PRODUCT
- product name for the sale order line.
QUANTITY
- Quantity for the above product.
UOM
- UOM for the above product.
DESCRIPTION
- Description for the product
PRICE
- Price for the above product.
SALESPERSON
- Name of salesperson.
TAX
-Tax for the product
DATE
- Date of sale order.

Given below is the sample of import file.

The "ORDER" should be same, as you can see in the image,"ORDER" is same for different product list.This defines single order with different product lines.

Tax column is important you have to add "Tax column" though there is no need of adding tax.


Figure shows the menu for importing data of Sales Orders.


Import Sales Wizard

If you want to import details of sales number from CSV/XLS you can also have option regarding this in import sales wizard.

If you select "Use Excel/CSV Sequence Number" option then name field will came from CSV/XLS file.


After importing CSV/XLS you can see the Sequance(Sale Order number) is same as we given in CSV/XLS file.


Views

This is the tree of sales order created from given data file.


If you select "Use System Default Sequence Number" option then name field will follow the system sequence.


If all taxes are found in system then sale order will be generated.


It will generate error if you import wrong pricelist,which is shown in Figure.

It will also generates errors when you import wrong value of Currency,Customer,UOM,Salesperson and Tax.


How to Import Data of Inventory


This is the file format you need to follow to import inventory data.


1. When code is selected in Import option, please select file that contains code of products.

2. When barcode is selected in Import option, please select file that contains barcode of products.

3. When Name is selected in Import option, please select file that contains name of products.

Figure shows the menu for importing data of Inventory


Import Inventory Wizard.

In this wizard you have to upload properly formated CSV or XLS file which you want to import.


Here, we can check the inventory generated and goes to the progress state.

You can import inventory of products by Internal Reference or Barcode.


How to Import Data of Purchase Order.


PURCHASE ID
- Purchase number for the purchase order.
SUPPLIER
- Vendor name for the purchase order.
CURRENCY
- Currency for the purchase order.
PRODUCT
- Product name for the purchase order.
QUANTITY
- Quantity for the above product.
UOM
- UOM for the above product.
DESCRIPTION
- Description for the product
PRICE
- Price for the above product.
TAX
-Tax for the product
DATE
- Date of purchase order.

Given below is the sample of import file.

The "PURCHASE ID" should be same, as you can see in the image, "PURCHASE ID" is same for different product list.This defines single order with different product lines.

Tax column is important you have to add "Tax column" though there is no need of adding tax.


Figure shows the menu for importing data of Purchase Orders.


Import Purchase Wizard

If you want to import details of purchase number from CSV/XLS you can also have option regarding this in import purchase wizard.

If you select "Use Excel/CSV Sequence Number" option then name field will came from CSV/XLS file.


After importing CSV/XLS you can see the Sequance(Purchase Order number) is same as we given in CSV/XLS file.


Views

This is the tree of purchase order created from given data file.


If you select "Use System Default Sequence Number" option then name field will follow the system sequence.


If all taxes are found in system then purchase order will be generated.


It will generate error if you import Unavailable UOM,which is shown in Figure.

It will also generates errors when you import wrong value of Currency,Customer,Pricelist,Salesperson and Tax.


How to Import Incoming Shipment/Delivery Order.


NAME
- Stock Picking Name
Customer
- Name of the customer.
Source Document
- Name of the Source Document.
Date
- Date of Picking.
Product
- Product name for the Picking.
Quantity
- Quantity for the above product.

Given below is the sample of import file.


Figure shows the menu for importing data of Incoming Shipment/Delivery Order.


Import Incoming Shipment/Delivery Order Wizard: In this wizard you have to upload properly formated XLS and CSV file you want to import


Form view: This is the form view of delivery order.


It will generate error if you not select a proper file.


How to Import Product.


NAME
- Product Name
INTERNAL REFERENCE
- Internal reference for the product.
CATEGORY
- Product's internal category.
TYPE
- Product Type.
BARCODE
- Product identification code.
UOM
- UOM for the above product.
PURCHASE UOM
- Purchase UOM for the above product.
SALE PRICE
- Sale price for the above product.
COST PRICE
- Cost price for the above product.
WEIGHT
- Weight for the above product.
VOLUME
- Volume for the above product.

Given below is the sample of import file.


Figure shows the menu for importing data of Products.


Import Product Wizard: In this wizard you have to upload properly formated XLS file which you want to import.


Views:This is the tree of product created from given data file.


Form view: This is the form view of products.


It will generate error if you import wrong data e.g Empty category.


How to Import Partner.


NAME
- Partner Name
Type
-.
PARENT
- Partner's Parent.
STREET
- Partner's Address.
STREET 2
- Partner's Address.
CITY
- Partner's City.
STATE
- Partner's State.
ZIP
- Partner's Zip code.
COUNTRY
- Partner's Country.
WEBSITE
- Website of partner.
PHONE
- Partner's Phone Number.
MOBILE
- Partner's Mobile Number.
EMAIL
- Partner's Email Address.
CUSTOMER
- True/False for customer.
VENDOR
- True/False for Vendor.
SALESPERSON
- Salesperson of partner.
INTERNAL REFERENCE
- Partner's Internal Reference.
CUSTOMER PAYMENT TERMS
- Days for customer's payment term.
VENDOR PAYMENT TERMS
- Days for vendor's payment term.

Given below is the sample of import file.




Figure shows the menu for importing data of Partners.


Import Partner Wizard: In this wizard you have to upload properly formated XLS file you want to import.


Views: This is the kanban view of partner created from given data file.


Form view: This is the form view of partner.


It will generate error if you import Unavailable Salesperson.

It will also generates errors when you import wrong value of Company,Unavailable Parent,Unavailable Payment term.


Installation Guide

Before installing this module you have to install following packages in your system.

  • sudo pip install xlrd
  • sudo pip install xlwt
  • OR
  • sudo apt-get install python-xlrd
  • sudo apt-get install python-xlwt

Free Support

You will get 90 Days free support incase any bugs or issue (Except data recovery).

At BrowseInfo we offer end to end solution for Odoo services. Which includes analysis & consultation on the workflows and integration part. Please note that You're not allowed to distribute this module after purchase! Incase of any question regarding this module feel free to email us on sales@browseinfo.in or raise a ticket on 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

Odoo
by on

Oh. comment format is so awful :)

Odoo
Very responsive guys, thank you. But we fixed ourselves Inventory Adjustment import problem.
by on

There was a problem when Importing Inventory Adjustment by barcode. We had barcodes like 88295, 11125, 20351931. Excel formats it to floats like 88295.0, 11125.0, 20351931.0. So we could not import these products to Inventory adjustment and I had fixed stock.py by adding following codes: if row_no <= 0: fields = map(lambda row:row.value.encode('utf-8'), sheet.row(row_no)) else: line = (map(lambda row:isinstance(row.value, unicode) and row.value.encode('utf-8') or str(row.value), sheet.row(row_no))) if line: values.update({'barcode':line[0],'quantity':line[1]}) if values['barcode'].endswith('.0'): values['barcode'] = values['barcode'][:-2] I just shared for anybody who needed help.

Odoo
@David
by on

Right now we have only customer column, but if you want we can adjust customer reference column also for you(add one more new column) you can contact us on contact@browseinfo.in or sales@browseinfo.in.

Odoo
by on
Odoo
by on

Hi! What field do we use for customer reference whilst Importing Sales Orders. Thanks!

Odoo
@Derek
by on

Would you please send email on our support team as sales@browseinfo.in. Our team will look your issue and help you to solve this out. Thanks

Odoo
by on

fp = tempfile.NamedTemporaryFile(suffix=".xlsx") 改为: fp = tempfile.NamedTemporaryFile(delete=False,suffix=".xlsx")

Odoo
by on

Hi,when we use Odoo all import for Sales, Purchase module,there's error below: 1.I found the c:\\users\\admini~1\\appdata\\local\\temp\\2\\tmpzmu5hs.xlsx ,there is no file found 2.my system upload file correctly Please tell us what's wrong may happen? Odoo Server Error Traceback (most recent call last): File "D:\GreenOdoo10\source\odoo\http.py", line 649, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "D:\GreenOdoo10\source\odoo\http.py", line 687, in dispatch result = self._call_function(**self.params) File "D:\GreenOdoo10\source\odoo\http.py", line 334, in _call_function return checked_call(self.db, *args, **kwargs) File "D:\GreenOdoo10\source\odoo\service\model.py", line 119, in wrapper return f(dbname, *args, **kwargs) File "D:\GreenOdoo10\source\odoo\http.py", line 327, in checked_call result = self.endpoint(*a, **kw) File "D:\GreenOdoo10\source\odoo\http.py", line 947, in __call__ return self.method(*args, **kw) File "D:\GreenOdoo10\source\odoo\http.py", line 511, in response_wrap response = f(*args, **kw) File "D:\GreenOdoo10\source\odoo\addons\web\controllers\main.py", line 888, in call_button action = self._call_kw(model, method, args, {}) File "D:\GreenOdoo10\source\odoo\addons\web\controllers\main.py", line 876, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "D:\GreenOdoo10\source\odoo\api.py", line 681, in call_kw return call_kw_multi(method, model, args, kwargs) File "D:\GreenOdoo10\source\odoo\api.py", line 672, in call_kw_multi result = method(recs, *args, **kwargs) File "D:\GreenOdoo10\source\addons\bi_generic_import\models\product.py", line 102, in import_product workbook = xlrd.open_workbook(fp.name) File "D:\GreenOdoo10\runtime\python\lib\site-packages\xlrd\__init__.py", line 395, in open_workbook with open(filename, "rb") as f: IOError: [Errno 13] Permission denied: 'c:\\users\\admini~1\\appdata\\local\\temp\\2\\tmpzmu5hs.xlsx'