| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Contacts (contacts)
• Inventory (stock) • Invoicing (account) • Purchase (purchase) • Discuss (mail) |
| Lines of code | 560 |
| Technical Name |
erpl_all_in_one_basic_import |
| License | OPL-1 |
| Website | https://erplabz.com |
| Versions | 16.0 17.0 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Contacts (contacts)
• Inventory (stock) • Invoicing (account) • Purchase (purchase) • Discuss (mail) |
| Lines of code | 560 |
| Technical Name |
erpl_all_in_one_basic_import |
| License | OPL-1 |
| Website | https://erplabz.com |
| Versions | 16.0 17.0 18.0 19.0 |
All In One Basic Import for Odoo 19
Comprehensive data import solution for Partners, Products, Sales, Purchases, Accounts, and Inventory
Overview
The All In One Basic Import module provides a unified solution for importing various types of data into Odoo. This module eliminates the need for multiple import tools by offering a single, easy-to-use interface for importing partners, products, sales orders, purchase orders, accounts, and inventory data from CSV or Excel files.
Key Features
Multiple Import Types
Import Partners, Products, Sales Orders, Purchase Orders, Accounts, and Inventory in one module
CSV & Excel Support
Import data from both CSV and Excel (XLSX) files with automatic format detection
Flexible Field Mapping
Automatic field mapping with support for common column names
Error Handling
Comprehensive error reporting with detailed logs for failed imports
Import Logging
Track all import activities with success/failure statistics
Update Existing Records
Automatically updates existing records when duplicates are found
Supported Import Types
Partners/Contacts
- Name, Email, Phone, Mobile
- Address (Street, City, ZIP, Country)
- Company information
- Automatic duplicate detection
Products
- Product Name, SKU/Code
- Sale Price, Cost Price
- Product Type & Category
- Auto template creation
Sales Orders
- Customer/Partner information
- Product details
- Quantity and pricing
- Order dates
Purchase Orders
- Supplier/Partner information
- Product details
- Quantity and pricing
- Order dates
Accounts
- Account Code and Name
- Account Type
- Company association
- Chart of accounts
Inventory/Stock
- Source and Destination Locations
- Product information
- Quantities
- Automatic picking creation
How It Works
- Access the Import Wizard: Navigate to Data Import â Import Data
- Select Import Type: Choose Partners, Products, Sales, Purchases, Accounts, or Inventory
- Upload Your File: Upload CSV or Excel file with optional header row
- Configure Settings: Set file type, delimiter, and header options
- Execute Import: Click Import - the module validates and creates records
- Review Log: Check import log for success/failure statistics
File Format Guidelines
CSV Format
- Use comma (,) or semicolon (;) as delimiter
- First row should contain column headers
- Use UTF-8 encoding for special characters
- Enclose text fields with commas in quotes
Excel Format
- Use XLSX format (not XLS)
- First row should contain column headers
- One sheet per import
- Data starts from first or second row
Benefits
- Save time by importing bulk data instead of manual entry
- Reduce data entry errors with validation and error reporting
- Single module for all import needs - no need for multiple tools
- Track all imports with detailed logging
- Easy to use wizard interface - no technical knowledge required
- Automatic duplicate detection and update
Usage Tips
- Always backup your database before performing bulk imports
- Test imports with a small sample file first
- Review the import log after each import to identify any issues
- Ensure required fields are present in your import file
Technical Details
DEPENDENCIES
base, contacts, product, sale, purchase, account, stock
Need Support?
For support, customization requests, or any questions about this module
Visit ERP LabzAll In One Basic Import for Odoo 19
Developed with by ERP Labz
© 2024 ERP Labz - All rights reserved
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