| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Purchase (purchase)
• Discuss (mail) • Invoicing (account) |
| Lines of code | 197 |
| Technical Name |
eg_import_purchase_order_line |
| License | OPL-1 |
| Website | http://www.inkerp.com |
| Versions | 16.0 17.0 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Purchase (purchase)
• Discuss (mail) • Invoicing (account) |
| Lines of code | 197 |
| Technical Name |
eg_import_purchase_order_line |
| License | OPL-1 |
| Website | http://www.inkerp.com |
| Versions | 16.0 17.0 18.0 19.0 |
Our Most Suggested Products
Import Bulk Purchase Order Lines from Excel or CSV File
The Import Purchase Order Line module for Odoo is a powerful tool designed to streamline the procurement process by allowing businesses to import purchase order lines directly from Excel or CSV files. This eliminates the need for manual entry of products and quantities, saving time and reducing errors. Users can effortlessly upload bulk data, including product prices and tax details, with all calculations such as tax amounts and total amounts performed automatically, just like in standard Odoo operations.
Video Tutorial
Features
Screenshots
Support
Service
Features
Bulk Import of Purchase Order Lines
This feature allows users to import multiple purchase order lines in one go, directly from Excel or CSV files, eliminating the need to manually enter each product and quantity line by line. It drastically reduces the time spent on creating purchase orders, especially when dealing with large inventories. Additionally, the system automatically calculates taxes, total amounts, and other financial details, ensuring accuracy and saving procurement teams from manual errors.
Flexible Price Options
When importing products, users can choose whether to take the product price from the uploaded file or from existing Odoo product records. This flexibility ensures that businesses can maintain pricing consistency or apply new pricing strategies depending on the source of the data.
Predefined Templates for Easy Upload
The module provides ready-to-use XLS and CSV templates for importing purchase order lines, guiding users to format their data correctly. These templates reduce errors by specifying required fields such as product names, quantities, and tax details.
Screenshot
1.) Import Purchase Line Button in RFQ
Shows the âImport Purchase Lineâ button in the Request for Quotation screen. Users can click this button to start importing purchase order lines from an Excel or CSV file, saving time on manual data entry.
2.) XLS File Import Wizard
Displays the wizard that appears after clicking âImport Purchase Line.â Users can choose the file type (XLS) and decide whether to take product prices from Odoo or the uploaded file, then upload their file for import.
3.) Download XLS Template
Shows the option to download a ready-made XLS template. This template ensures that data like product names, quantities, and taxes are correctly formatted for import, reducing errors.
4.) Sample XLS File Format
Displays an example of a properly formatted XLS file. Users can see how to organize their purchase order data before importing it, including columns for product, quantity, price, and taxes.
5.) Imported Order Lines with File Price
Shows the imported purchase order lines where product prices are taken from the uploaded file. All calculations, including tax and total amounts, are automatically applied.
6.) CSV File Import Wizard
Similar to the XLS wizard, this screenshot shows importing through a CSV file. Users select the CSV file and decide whether to take product prices from Odoo or the file itself.
7.) Download CSV Template
Displays the option to download the CSV template, guiding users to structure their data correctly for a smooth import process.
8.) Sample CSV File Format
Shows an example of how a CSV file should look for import. This ensures that usersâ product lines, quantities, and pricing are correctly mapped to Odoo.
9.) Imported Order Lines with Odoo Product Price
Shows the final imported order lines using product prices from Odoo. All taxes and totals are automatically calculated, reflecting the correct purchase order values.
User Guide
Teams
team@inkerp.com
Suggested Products
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