Uploader

$ 185.18

v 18.0 Third Party

Availability	Odoo Online Odoo.sh On Premise
Odoo Apps Dependencies	• Discuss (mail) • Invoicing (account)
Lines of code	758
Technical Name	`ol_uploader`
License	LGPL-3
Website	https://www.odolution.com/
Versions	16.0 17.0 18.0

You bought this module and need support? Click here!

Availability	Odoo Online Odoo.sh On Premise
Odoo Apps Dependencies	• Discuss (mail) • Invoicing (account)
Lines of code	758
Technical Name	`ol_uploader`
License	LGPL-3
Website	https://www.odolution.com/
Versions	16.0 17.0 18.0

Why Uploader?

The Uploader allows users to bulk upload data into any Odoo model via a predefined template. It makes it easy to quickly import large batches of records into Odoo through Excel files. It also ensures that data from Excel files is validated, mapped, and uploaded with minimal manual input. While Odoo allows data to be uploaded by default using its import feature, it requires users to manually map fields to columns every time a file is uploaded. The Uploader solves this by letting you define reusable templates that remember the mapping between Excel columns and Odoo fields. This means you can consistently and accurately upload data without repeating the setup process, saving time and reducing the risk of errors during bulk imports.

Need Help?

Connect with us on email

Chat with us on WhatsApp

WATCH QUICK DEMO HERE

Key Attributesof Uploader

Bulk Data Upload

Reusable Template Creation

Data Mapping and Validation

Excel File Integration

Smart Buttons for Easy Access

Uploader Approval

Bulk Data Upload

Enables users to bulk upload data into any Odoo model using a predefined template.

Reusable Template Creation

Allows users to create templates specifying the target model and field mappings between Excel columns and Odoo fields.

Data Mapping and Validation

Automatically validates and maps data from Excel files to corresponding fields in the target model with minimal manual input.

Smart Buttons for Easy Access

Once the upload is successful, smart buttons appear to view records created by the uploader.

Product Variant Handling

Supports creation of product variants by mapping attributes and values directly from Excel columns. Users can map Excel data to specific fields in Product Variant when uploading to Product Template.

Uploader Approval

Requires approval from users in the Uploader Approver group before finalizing the upload to prevent any incorrect or unauthorized uploads.

Install the Uploader Module

Create a Template

Navigate to Uploader > Templates to create a template.

To create a template, click Create and specify the target Odoo model, a version name, and define field mappings. For each mapping, enter the Excel column name (case-insensitive) and the corresponding Odoo field. For One2many fields, a Sub Field must be set to specify which field within the related lines should be used.

If uploading to Product Template, use the Variant Field to map data directly to a specific field in Product Variant (e.g., barcode), leaving the Field and Sub Field empty in that case.

To create product variants, use an Excel column named after the attribute (e.g., Size) and mention the attribute value (e.g., Medium) for each product in that column. In the template, set the Field to attribute_line_ids (Product Attributes) and the Sub Field to product_template_value_ids (Product Attribute Values). If any attribute or value does not exist in the system, an error will be raised during upload.

Upload Data

Navigate to Uploader > Uploader to upload data.

To create an uploader, click Create, select the previously defined template, and attach the Excel file to be uploaded.

Test the Upload

Click Test button to validate the Excel file. If the structure doesnât match the template, errors will highlight missing or unmapped columns.

Once validated, mapping lines will be auto-generated for matched fields, while extra columns must be manually mapped by the user.

A preview of the first row will be shown for each column in the Sample Data field.

Each mapping line has the following flags:

Required: Indicates if the field is mandatory.
To Upload: Specify whether this column should be uploaded (can skip columns).
Sample Data: A preview of what the Excel file contains for that column.

Submission and Approval

Once tested, click Send for approval.

Only users in the Uploader Approver group can approve or reject the uploader.

Upload the Data

After approval, any user can click Upload.

On successful upload, a smart button will display all records created by the uploader.

For product templates, one smart button will show the created products, while another will display the created variants.

Additional Notes

For Many2one and Many2many fields, values in Excel will be matched using the name field of the related model. If no match is found, a User Error is raised.

For Many2many fields, values must be comma-separated.

Need Help? We have Got You Covered!

User Guide

Check out our comprehensive User Guide for step-by-step instructions Here

Demo Video

Want to see the module in action? Watch our demo video to get a quick overview of all the features Here

Still have questions? Don't hesitate to reach out via email at app.support@odolution.com Or via whatsapp at +923356928563 . We are happy to help!

Support Ticket

For any issues you encounter while using our app, we offer free support for 90 days from the date of purchase, provided the issue is related to the app.
To get assistance, please visit www.odolution.com to create a support ticket. Simply register on our platform and provide the details of the issue, and our team will work to resolve it promptly.

FAQs

What is the main benefit of using the Uploader over Odoo's default import feature?

Odoo's default import tool requires users to map fields every time data is uploaded. The Uploader allows you to create reusable templates that remember these mappings, saving time and reducing errors.

Can the Uploader handle One2many and Many2many fields?

Yes, the Uploader supports both field types. For One2many, you must also define a Sub Field. For Many2many, values should be comma-separated, and they will be matched using the name field of the related model.

How does the Uploader handle product variants?

You can define product variants by including attribute columns in your Excel file (e.g., Size, Color) and mapping them to Product Attributes (Field) and Product Attribute Values (Sub Field) in the template. If the attribute or value doesnât exist in Odoo, an error will be raised.

What happens if the Excel file has missing or extra columns?

During the test phase, the Uploader will validate the structure against the template. Missing required fields will generate errors, and extra columns can be manually mapped or skipped.

Who can approve uploads in the Uploader module?

Only users assigned to the Uploader Approver group can approve or reject an uploader after it's submitted for review. Once approved, any user can perform the actual data upload.

Please log in to comment on this module

The author can leave a single reply to each comment.
This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
If you want to start a discussion with the author or have a question related to your purchase, please use the support page.