| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 630 |
| Technical Name |
rc_spreadsheet_product_search |
| License | OPL-1 |
| Website | https://www.rivecon.de |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 630 |
| Technical Name |
rc_spreadsheet_product_search |
| License | OPL-1 |
| Website | https://www.rivecon.de |
Spreadsheet Product Search for Odoo
Search products directly inside Odoo Spreadsheet and insert them as plain text or as live ODOO.LIST formulas. Configurable fields, multi-language UI, and admin-only settings make it the perfect tool for building product catalogs, price lists, and order sheets. Also a perfect companion for the Odoo Quote Builder — quickly look up products and place them into your spreadsheet-based quotation templates.
Why this module?
This module adds a search panel directly inside the spreadsheet toolbar. Find any product in seconds and insert it as text or as a live ODOO.LIST formula that stays connected to your product database.
Ideal for the Odoo Quote Builder: When building quotation templates with Odoo's spreadsheet-based Quote Builder, use this module to search and insert product references, prices, and descriptions directly — no switching between windows, no copy-pasting from the product form.
Search & Insert
✔ Full-text product search directly inside Odoo Spreadsheet
✔ Search across multiple fields simultaneously (name, internal reference, barcode, etc.)
✔ Insert product data as plain text into the active cell
✔ Insert product data as ODOO.LIST formula — live link to your database
✔ Multiple fields inserted side by side (one field per column)
✔ Visual feedback: last inserted product is highlighted in the result list
Configurable Fields
✔ Admin-configurable: choose which product fields are inserted
✔ Drag-and-drop ordering: field sequence determines column order
✔ Per-field search toggle: decide which fields are included in the search
✔ Supports all standard product fields including Many2one relations
Product Level
✔ Switch between Product Templates and Product Variants
✔ Setting is saved globally and persisted across sessions
Multi-Language
✔ Full UI translation support — automatically adapts to the user's Odoo language
✔ Built-in German and English translations
✔ Extensible: add more languages by extending the translation dictionary
ODOO.LIST Formula Integration
✔ Automatic list creation with a dedicated backing sheet for data sources
✔ Reuses existing lists when the same product is inserted again
✔ Formulas stay live: changes to product data are reflected in the spreadsheet
Installation
- Install the module from the Odoo App Store or copy it to your addons directory
- Ensure that
spreadsheet_dashboard,sale, andproductmodules are installed - Open any Odoo Spreadsheet — the Products button appears in the toolbar
- Configure fields under Sales → Configuration → Spreadsheet Product Fields
Requirements
| Requirement | Details |
|---|---|
| Odoo Version | 19.0 (Community or Enterprise) |
| Odoo Modules | spreadsheet, sale |
| Python Packages | None (pure JavaScript frontend module) |
| Hosting | Compatible with Odoo.sh, on-premise, and Docker deployments |
Getting Started
This guide walks you through using the product search in Odoo Spreadsheet and configuring it for your needs.
1. Opening the Product Search
Navigate to any spreadsheet (e.g. via Dashboards or Documents). The Products button appears automatically in the spreadsheet toolbar.
A side panel opens on the right with a search field. Start typing at least 2 characters to search across all configured search fields.
2. Inserting Products
Click on a product in the result list to insert its field values as plain text into the active cell. Each configured field is placed in a separate column, starting from the cursor position.
Click the link icon next to a product to insert ODOO.LIST formulas. These formulas create a live connection to your product database — when product data changes in Odoo, the spreadsheet updates automatically.
3. Understanding the Legend
Below the search results, a legend explains the two insert modes:
- Mouse pointer icon — Click on a product row to insert as plain text
- Link icon — Click the link button to insert as ODOO.LIST formula
The last inserted product is highlighted in the result list so you can easily see which product you just added.
4. Switching Product Level
In the Settings section at the bottom of the side panel, switch between Product Templates and Product Variants. This controls which Odoo model is searched and inserted.
5. Configuring Fields (Admin)
Navigate to Sales → Configuration → Spreadsheet Product Fields. Here you see the list of fields that are inserted into the spreadsheet.
Add new product fields using the Add a line button. Select any field from the product model. Drag rows to change the column order in the spreadsheet.
Toggle the Use for Search checkbox on each field to include it in the search query. All active search fields are OR-linked — a match in any field returns the product.
6. Troubleshooting
| Problem | Solution |
|---|---|
| Products button not visible | Make sure the module is installed and you are inside an Odoo Spreadsheet (not a regular Odoo view). |
| Search returns no results | Check that at least one field has Use for Search enabled. Also ensure you typed at least 2 characters. |
| Only product name is inserted | Add more fields in Sales → Configuration → Spreadsheet Product Fields. By default, only the product name is configured. |
| ODOO.LIST formula shows an error | The product may have been archived or deleted. Check the product status in Odoo. Also verify the field name still exists on the product model. |
| Settings section not visible | The product level setting is visible to all users but can only be changed by administrators. |
Version History
| Version | What's New |
|---|---|
| 19.0.1 |
• Initial release • Product search panel integrated into the Odoo Spreadsheet toolbar • Insert as plain text or as ODOO.LIST formula • Configurable product fields with drag-and-drop ordering • Per-field search toggle (OR-linked multi-field search) • Product Templates / Product Variants toggle • Multi-language UI (German and English built-in) • Automatic backing sheet management for ODOO.LIST formulas • Reuse of existing lists to avoid duplicates |
Author
rivecon GmbH
Website: www.rivecon.de
About Us
With deep technical expertise and a pragmatic approach, we help companies analyze, implement, and customize their Odoo systems.
Contact
WhatsApp: wa.me/4940696389900
Web: www.rivecon.de/kontakt
Phone: +49 40 5730758-0
Address: rivecon GmbH, Am Strandkai 4, 20457 Hamburg, Germany
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