$ 40.48
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Sales (sale)
• Invoicing (account) • Discuss (mail) |
| Technical Name |
import_export_sale_order_drc |
| Website | http://www.drcsystems.com/ |
| Versions | 8.0 9.0 10.0 11.0 12.0 |
Import/Export Sale Order lines by Excel
Requirements
Before you install this module first download xlrd library from Here and install on your system.
OR
Run sudo pip install xlrd command in Terminal.
Sales Configuration to manage large order by Excel
After Installing this module go to Sales->Configurations->Settings.
There is a option "Import Sale Order Line from Excel file?".
If you select that option then you will see option "Import/Export Sale Order lines" in "Action" section at the top bar in Purchase Order form view.
Import/Export Order lines from Excel
By clicking on "Import/Export Sale Order lines", you will see a pop-up to Import / Export Excel file.
Rules for Import Order Lines
- You can import order lines only in case of when your Order is in Draft state.
- You can import only .xls or .xlsx file.
- Please make sure that your file's column headers must be Code, Qty, Name, Price and Discount.
- Code column is mandatory while import.
- Code column value must be match to your product internal reference.
Set Default Qty
In order to set default Qty, user need to go to Settings > Technical > Parameters > System parameters and find the key "Defauly Qty To Import Product in Sale Order" and set the value as per requirement.
Validate Import File
- File is Selected?
- Order is in draft mode or not?
- Selected file is .xls or .xlsx?
- Mandatory column is exist or not?
- Column name is valid or not?
If there is any validation error than system will pop-up Validation Error Message.
If there is no any validation error "Import" button will be visible.
Import File
After Importing File
Not Imported Product List
If Product Code or ID is not found than it will list not imported Product or ID.
Export Order Lines
Import/Update Order Lines with Single Import
Lines which you wants import keep ID blank.
Lines which you wants to update don't remove or change value of ID.
Please log in to comment on this module
Doesn't work. Odoo Server Error
Traceback (most recent call last): File "/odoo/odoo-server/odoo/http.py", line 638, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/odoo/odoo-server/odoo/http.py", line 675, in dispatch result = self._call_function(**self.params) File "/odoo/odoo-server/odoo/http.py", line 331, in _call_function return checked_call(self.db, *args, **kwargs) File "/odoo/odoo-server/odoo/service/model.py", line 119, in wrapper return f(dbname, *args, **kwargs) File "/odoo/odoo-server/odoo/http.py", line 324, in checked_call result = self.endpoint(*a, **kw) File "/odoo/odoo-server/odoo/http.py", line 933, in __call__ return self.method(*args, **kw) File "/odoo/odoo-server/odoo/http.py", line 504, in response_wrap response = f(*args, **kw) File "/odoo/odoo-server/addons/web/controllers/main.py", line 866, in call_button action = self._call_kw(model, method, args, {}) File "/odoo/odoo-server/addons/web/controllers/main.py", line 854, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "/odoo/odoo-server/odoo/api.py", line 681, in call_kw return call_kw_multi(method, model, args, kwargs) File "/odoo/odoo-server/odoo/api.py", line 672, in call_kw_multi result = method(recs, *args, **kwargs) File "/odoo/odoo-server/odoo/addons/base/module/module.py", line 410, in button_immediate_install return self._button_immediate_function(type(self).button_install) File "/odoo/odoo-server/odoo/addons/base/module/module.py", line 484, in _button_immediate_function modules.registry.Registry.new(self._cr.dbname, update_module=True) File "/odoo/odoo-server/odoo/modules/registry.py", line 78, in new odoo.modules.load_modules(registry._db, force_demo, status, update_module) File "/odoo/odoo-server/odoo/modules/loading.py", line 337, in load_modules loaded_modules, update_module) File "/odoo/odoo-server/odoo/modules/loading.py", line 235, in load_marked_modules loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks) File "/odoo/odoo-server/odoo/modules/loading.py", line 156, in load_module_graph _load_data(cr, module_name, idref, mode, kind='data') File "/odoo/odoo-server/odoo/modules/loading.py", line 95, in _load_data tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report) File "/odoo/odoo-server/odoo/tools/convert.py", line 842, in convert_file convert_csv_import(cr, module, pathname, fp.read(), idref, mode, noupdate) File "/odoo/odoo-server/odoo/tools/convert.py", line 898, in convert_csv_import raise Exception(_('Module loading %s failed: file %s could not be processed:\n %s') % (module, fname, warning_msg)) Exception: Module loading import_export_sale_order_drc failed: file import_export_sale_order_drc/security/ir.model.access.csv could not be processed: No matching record found for external id 'model_sale_order_import_export_wizard' in field 'Object' Missing required value for the field 'Object' (model_id)
Please share more details
Hello TIm, After your comment we tried to replicate the issue at out but the modules installs very well for us. Please share more of this issue @ info@drcsystems.com