Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Property Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
      • Get a Tailored Demo
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +32 2 290 34 90
    • Get a Tailored Demo
  • Pricing
  • Help
  1. APPS
  2. Extra Tools
  3. Universal Field Update v 19.0
  4. Sales Conditions FAQ

Universal Field Update

by Links4engg https://www.links4engg.com
Odoo
v 19.0 Third Party 9
Download for v 19.0 Deploy on Odoo.sh
Apps purchases are linked to your Odoo account, please sign in or sign up first.
Versions 17.0 18.0 19.0
You bought this module and need support? Click here!
Versions 17.0 18.0 19.0
  • Description
  • Manifest

Universal Field Update & Model Explorer

The ultimate database administration tool to safely inspect, search, and bulk update any field on any Odoo model — with full audit trails!

Main Banner

Stop Writing One-Off Scripts to Fix Your Data

Every growing Odoo database eventually needs a correction that standard views were never built for — a salesperson reassigned across thousands of leads, a discontinued product swapped out everywhere it's referenced, a mis-mapped selection value left over from a data migration, or a duplicate partner that needs to be merged into the correct one across dozens of unrelated modules. Doing this by hand means opening every record one at a time, or asking a developer to write and run a one-off script in the Odoo shell — risky, slow, and impossible to audit afterwards.

Universal Field Update replaces that risk with a guided, permission-controlled wizard. Pick any model and any field, define the current and replacement values, preview exactly which records will be touched, and apply the change with a single click — while every execution is written to a permanent, sequential audit log for full accountability.

The "Before & After"

Without App

Ask a developer to write a script
Run it manually in the Odoo shell
Hope nothing outside scope gets touched
No record of what changed or when
Repeat the risk for every future correction...
Recommended

With App

Pick Model, Field & Values in Wizard
Preview & prune the matching records
Click Apply Field Update
Done instantly, with an audit trail!

Business Problems Solved

Salesperson reassigned across thousands of leads
A discontinued product or contact needs replacing everywhere
Duplicate partner records need to be pointed to the correct one
Wrong selection/status values left over from a migration
Boolean flags set incorrectly on a batch of records
Text or numeric typos repeated across many records
Large historical data migration cleanup
Company restructuring and department re-allocations
A reference record used across many unrelated modules
No developer available for a quick one-off data fix
Need a defensible audit trail of manual data changes
Locked/posted records need a controlled override

Module Features

Any Model, Any Field

Dynamically select any installed model and any stored field — text, numeric, boolean, selection, date, datetime, or Many2one — with automatic type detection.

Interactive Review Grid

The wizard populates a grid of matching records (up to a 1,000 record preview). Visually review and deselect anything that shouldn't be touched.

Secondary Filter Field

Narrow a wide match down to an exact subset by adding an optional second field/value filter before the search runs.

Global Reference Replace

Pick a reference record — like a Partner or User — and scan every model in the database that points to it, so you can replace it everywhere in one shot.

Force Update (Guarded)

An optional SQL-level bypass writes directly around locked or posted document guards for the rare cases that truly need it — hidden behind the Manager security group.

Permanent Audit Log

Every run creates a sequential log entry recording records requested, updated, skipped, and failed — with per-record error detail for full traceability.


Complete Workflow Diagram

Bulk Field Update Workflow

Universal Field Update Menu ↓ Select Model & Field ↓ Set Current & Replace With Values (Optional Filter Field) ↓ Find Matching Records ↓ Review & Prune Grid ↓ Apply Field Update ↓ Concurrency & Access Checks ↓ Audit Log Created

Visual Guide

How the interface looks inside your Odoo database.

1 "Universal Field Update" menu item clicked/highlighted

Find the dedicated "Universal Field Update" root menu, visible only to authorized users and managers.

Universal Field Update Menu

2 Select Model, Field & Values, Then Search

Choose the target model and field, enter the current and replacement values, and optionally add a filter field. Click Find Matching Records to populate the review grid.

Field & Value Selection

3 Success Notification & Audit Log

After confirming, the system instantly applies the update and displays a success message, while a permanent audit log entry records exactly what changed.

Success Notification

Functional Capabilities

Works across every installed model
Supports Char, Text, Integer, Float, Monetary
Supports Boolean, Selection, Date, Datetime
Supports Many2one relational fields
Dynamic OWL record selector for relations
Optional secondary filter field
Global cross-model reference replacement
Per-record selection in global scan results
Concurrency protection against overwrites
1,000 record preview safety warning
Dedicated User & Manager security groups

Ideal For

Odoo Implementation Partners
Database Administrators
IT & Data Migration Teams
Multi-Company Organizations
Growing SMEs with legacy data
ERP Consultants
Support Teams Handling Data Requests
Financial & Compliance Audits

Benefits

Eliminates one-off developer scripts.
Reduces risk of accidental mass changes.
Creates a defensible audit trail.
Restricts access to authorized staff only.
Saves hours of manual record editing.
Handles large datasets efficiently.
No coding knowledge required.
Works across every module, not just accounting.
Prevents overwrite conflicts during edits.

Notes

Bulk updates are only available to the Manager security group.
The Force Update (SQL bypass) option skips Python-level business logic — use with caution.
Record preview is capped at 1,000 matches at a time.
Every execution is written to a permanent audit log.
Compatible with Odoo 18 Community and Enterprise.
Recommended for administrators, not end users.

Why Choose Universal Field Update?

Unlike ad-hoc scripts or the Odoo developer shell, this module gives administrators a controlled, permission-gated interface for bulk data corrections — complete with preview grids, concurrency protection, and a permanent audit log. Whether fixing migration errors, reassigning ownership across modules, or replacing a reference record everywhere it's used, the module dramatically reduces effort while keeping every change traceable and accountable.

Need Help or Customization?

Our expert team at Links4Engg is ready to assist you. Whether you need support configuring this app or want to request custom Odoo features, get in touch with us!

support@links4engg.com
www.links4engg.com
Availability
Odoo Online
Odoo.sh
On Premise
Lines of code 1805
Technical Name l4e_universal_field_update
LicenseLGPL-3
Websitehttps://www.links4engg.com

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, please use the developer contact information. They can usually be found in the description.
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with