MBI Mass Edit Prices

🎯 Module Overview

MBI Mass Edit Prices updates the selling prices and the supplier purchase prices of your catalogue from a single page, without opening every product record. The module adds two pages to the Products menu: one for selling prices, one for supplier purchase prices. You filter the rows to work on, enter the new values, check the result in preview, then save. It is aimed at companies running a product catalogue and revising their pricing on a regular basis.

🧭 Benefits

• Update hundreds of prices in a few minutes, without moving from one product record to the next.
• Check the effect of your changes before saving them: nothing is written without your confirmation.
• Prepare your price changes in a spreadsheet, then apply them back in a single operation.
• Put price revision in the right hands, with separate rights for selling and for purchasing.
• Work on a controlled scope: you choose the products concerned and the number of rows displayed.

⚙️ Features

• Mass edit of product selling prices and VAT rates, with amounts displayed excluding or including tax.
• Mass edit of supplier purchase prices: minimum quantity, price, VAT rate, quantity discount and supplier product reference; the supplier is chosen when creating a price and cannot be changed on an existing one.
• Creation of the first purchase prices for products that have none, or addition of a new price alongside an existing one.
• Filters by category, product, supplier, warehouse and free text search, to target exactly the rows to work on.
• Choice of how many rows are displayed, up to the whole selection.
• Row by row preview before saving, showing for each row whether it will be updated, added, left as is or blocked, with the reason.
• Summary of the number of rows loaded, valid, blocked and unchanged, displayed above the table.
• Consistency checks before saving: numeric values, rates, supplier specified, supplier reference already in use and price combination already existing.
• CSV export of the displayed list and re-import of the corrected file, to prepare the changes outside Dolibarr.
• Separate rights to view and to modify, independently for selling prices and for purchase prices; without the modification right, the pages remain available in read-only mode.
• Only the rows actually modified are submitted, and a clear error message is displayed if the data does not reach the server in full.
• The scope covers products; services are not covered by this version.
• On an installation with several price levels, a filter selects the level to work on, and the list, the preview, the save, the export and the import all apply to that level alone. Per-customer prices are not handled by this version.
• On the purchase side, the list shows a single price per product/supplier pair, the most recently created one; other quantity tiers of the same supplier are not displayed, edited or exported, and disabled suppliers are not listed.

🧩 Requirements and Dependencies

• Required: the Dolibarr Products and Suppliers modules must be enabled.
• Required: the users concerned need the Dolibarr right to view products in order to open the pages, the right to create and modify products in order to save, and the right to view suppliers for the purchase prices page.
• Optional: the Categories module enables the category filter; without it, that filter is reported as unavailable.
• Optional: the Stocks module feeds the warehouse filter.

✅ Compatibility

• Minimum Dolibarr required: 22
• No maximum version is declared by the module. Tested version: Dolibarr 23.0
• Module designed to fit into the standard Dolibarr interface, without overriding its core.
• Minimum PHP required: 8.1 — the version Dolibarr 22 and later require; no maximum version is declared, and the module was tested with PHP 8.2.
• Available languages: French, English, German, Spanish, Italian

🔧 Installation

1. Download the ZIP archive of the module without unpacking it.
2. In Dolibarr, go to Home > Setup > Modules/Applications.
3. Open the Deploy/install external app/module tab.
4. Upload the ZIP archive of the module.
5. Search for and enable MBI Mass Edit Prices.
6. Open the module administration page if needed. It carries three tabs: Settings (the default number of rows displayed and the threshold above which the supplier list is loaded on demand), Repair (restores supplier prices saved as 0.00 by a version up to 1.0.2) and About.
7. Grant the required permissions to the users concerned.

For a manual installation, copy the mbimasseditprices folder into the /htdocs/custom/ directory of Dolibarr, then resume from step 5.

🚀 Getting Started

1. Enable the module from Home > Setup > Modules/Applications.
2. Grant the module rights to the users concerned: view and modify selling prices, view and modify purchase prices.
3. Check that those same users hold the Dolibarr rights to view and modify products, as well as the right to view suppliers for the purchase prices page.
4. Open the Products menu, then Mass edit selling prices or Mass edit purchase prices.
5. Filter a few products, change one row and run the preview to check the result before saving.

🔄 Updates and Uninstallation

• Back up the database and the Dolibarr files before any update.
• Read the changelog, then install the new archive over the existing version.
• Disabling the module removes its menu entries and its rights; it does not change any price.
• The module creates no table and no data of its own: the prices it saves are stored in the standard Dolibarr tables and remain in place after the module is disabled or removed.

🛟 Support and Documentation

For any assistance request, contact MB Informatique at: <info@mb-informatique.fr>

To help with diagnosis, please provide:

• the Dolibarr version in use;
• the module version;
• the PHP version;
• a detailed description of the problem and the steps to reproduce it;
• any error messages or screenshots.

This page is the main documentation of the module.

📄 Terms of Use

Article 1 — Publisher. The MBI Mass Edit Prices module is published by MB Informatique, a société à responsabilité limitée (SARL) registered with the Mulhouse Trade and Companies Register (RCS Mulhouse) under number 834 342 362 (SIRET 834 342 362 00029, EU VAT number FR07834342362), whose registered office is located at 120 rue de l'Île Napoléon, 68170 Rixheim, France. Telephone: 03 67 262 242 — Email: info@mb-informatique.fr — Website: https://www.mb-informatique.fr.

Article 2 — Purpose and acceptance. These Terms of Use (ToU) govern the use of the MBI Mass Edit Prices module ("the Module") for Dolibarr ERP/CRM as well as the associated services provided by MB Informatique SARL (support, updates, activation). Installing, enabling or using the Module constitutes full and unreserved acceptance of these ToU. They apply in addition to the terms of sale of the platform through which the Module was acquired (e.g. DoliStore), which govern the purchase itself.

Article 3 — Code licence. The source code of the Module is distributed under the GNU General Public License version 3 or later (GPL v3+), the full text of which is included in the COPYING file shipped with the Module. These ToU do not restrict the rights granted to the User by that licence; they govern the services provided by MB Informatique SARL and the conditions of use of the Module.

Article 4 — Requirements and compatibility. The Module is designed for the environments stated in its documentation (Dolibarr 22 minimum required, no maximum version declared, tested version Dolibarr 23.0, PHP 8.1 minimum required). Its operation is not guaranteed outside those versions, in the event of a modification of the Dolibarr core, or in the presence of conflicting third-party modules. It is the User's responsibility to check the compatibility of their environment before installation.

Article 5 — User obligations. The User undertakes to: (a) perform a full backup (files and database) before any installation or update; (b) test the Module on a test environment before going live whenever possible; (c) use the Module in accordance with its documentation and with applicable regulations; (d) keep their Dolibarr instance under normal security and update conditions.

Article 6 — Support and updates. Support is provided by email at info@mb-informatique.fr, under the conditions and for the duration, if any, specified at the time of purchase. Excluded from support are: malfunctions caused by a modification of the Module or of the Dolibarr core by the User or a third party, by an environment that does not meet the requirements, or by a conflict with a third-party module. Some updates may require a more recent version of Dolibarr.

Article 7 — Warranties. The Module is provided "as is", in accordance with sections 15 and 16 of the GPL and within the limits permitted by law. MB Informatique SARL does not warrant that the Module is free of defects, operates without interruption or meets any particular need of the User. Applicable mandatory legal warranties are not affected by this article.

Article 8 — Liability. Within the limits permitted by law, MB Informatique SARL shall not be held liable for indirect damages (in particular loss of data, business interruption, loss of revenue, reputational harm), nor for damages resulting from: improper use of the Module; the absence of a prior backup; a modification of the Module by the User or a third party; an event of force majeure. For professional Users, the total liability of MB Informatique SARL, on all grounds combined, is limited to the amount actually paid for the Module over the last twelve (12) months. Nothing herein excludes liability that cannot lawfully be excluded, in particular in the event of wilful misconduct or gross negligence.

Article 9 — Personal data. The Module operates within the User's Dolibarr instance: the functional data it processes remains stored on the User's systems, and the User remains the data controller within the meaning of the GDPR. In order to allow checking the availability of a version or accessing the activation service, the Module may declare to the Dolibarr core certain service addresses operated by MB Informatique SARL. When the User triggers one of these functions, Dolibarr may contact the service concerned and send it the technical identifier of the Module. The Module contains no licence key and does not itself transmit either the content of the Dolibarr database or the domain of the instance. As with any connection to an Internet service, the public IP address used to establish the connection may appear in the technical logs of the receiving server, for security and operational purposes. The User may exercise their rights regarding personal data by writing to info@mb-informatique.fr.

Article 10 — Intellectual property and trademarks. "Dolibarr" is a trademark belonging to its respective holders. The Module is an independent development by MB Informatique SARL, not affiliated with nor endorsed by the Dolibarr association. The copyright notices appearing in the Module files must not be removed, in accordance with the GPL.

Article 11 — Duration and changes. These ToU apply from the first use of the Module and for the whole duration of its use. MB Informatique SARL may change the ToU for future versions of the Module; the applicable version is the one shipped with the version of the Module in use. Termination of the services does not affect the rights granted by the GPL.

Article 12 — Governing law and disputes. These ToU are governed by French law. In the event of a difficulty, the User is invited to first send a written claim to MB Informatique SARL in order to seek an amicable solution. Failing an amicable resolution, any dispute with a professional User falls within the exclusive jurisdiction of the Commercial Court of Mulhouse, even in the event of summary proceedings, warranty (third-party) claims, incidental claims or where there are several defendants. Consumer Users retain the benefit of the mandatory rules of jurisdiction and may use the consumer mediation scheme free of charge under the conditions set out in articles L.612-1 et seq. of the French Consumer Code. Up-to-date information on the consumer mediation applicable to the services of MB Informatique SARL is set out in its General Terms and Conditions of Sale, available at https://www.mb-informatique.fr/cgv.html.

Article 13 — Miscellaneous. If any provision hereof is declared void or unenforceable, the others retain their full validity. These ToU are written in French; in the event of a discrepancy between the French version and a translation, the French version prevails.

👨 💻 Publisher

MBI Mass Edit Prices is a custom Dolibarr module developed by MB Informatique.

It is aimed at companies whose product catalogue changes regularly and who want to revise both their selling prices and their purchase prices faster, with a review step before saving.

Publisher: MB Informatique Contact: <info@mb-informatique.fr> Website: https://www.mb-informatique.fr
 

👨 💻 Changelog

UPDATE 1.1.0 (2026-10-13)

• ⚠️ Action required: disable then re-enable the module after the update so that the changes brought by this version are taken into account.
• New: on an installation with several price levels, a filter selects the selling price level to edit; the list, the preview, the save, the export and the import then apply to that level alone.
• New: a "Repair" tab in the module setup finds the supplier prices saved as 0.00 by a previous version and restores the last known price.
• New: on the selling price page, a filter allows the minimum selling price to be lowered along with the price.
• New: the module "About" page shows the changelog.
• New: the module setup offers two settings: the default number of rows displayed and the threshold above which the supplier list is loaded when the drop-down is opened instead of being repeated on every row.
• Improved: much faster display of purchase prices on catalogues holding many supplier prices.
• Improved: rows refused during a save are counted and reported instead of being ignored without any message.
• Improved: the module permission labels appear translated in the permission management.
• Improved: the German, Spanish and Italian translations get their accented characters back.
• Improved: a save carrying no value at all says so, instead of reloading the page without a message.
• Improved: in update mode, a row typed for a product without a purchase price is reported with its reason (creation is reserved to add mode) instead of being counted as unchanged.
• Security: the product a save applies to is determined from the displayed row and no longer from a value sent by the form.
• Security: the rows a save may change follow the current filters only, whatever the number of rows displayed.
• Security: CSV exports neutralise the cells a spreadsheet would read as a formula.
• Security: the module pages refuse direct URL access while the module is disabled.
• Security: product labels and error messages are escaped on display, including when a label containing code reached Dolibarr through an import or another module.
• Fixed: on an installation using the Multi-currency module, a purchase price mass save wrote 0.00 instead of the entered price.
• Fixed: the packaging of a supplier price could be replaced by the minimum quantity during a mass edit.
• Fixed: the minimum selling price was compared with a price including tax although it is expressed excluding tax, which wrongly refused or accepted some saves.
• Fixed: a CSV file prepared including tax could be imported on a page displayed excluding tax, and the other way round; the import is now refused with a message.
• Fixed: an export holding only part of the selection is no longer downloaded silently; it is refused with a message until every row is displayed.
• Fixed: non-numeric input ("abc", "5abc", "12,34,5") in a price, a quantity, a VAT rate or a discount was saved as 0 or as a truncated number; it is now refused with a message.
• Fixed: in a language where the comma separates thousands, English in particular, "12,5" was saved as 125; the comma is now refused there, the dot remaining the decimal separator as in the CSV export.
• Fixed: in update mode, giving a supplier price the ref and quantity of another price of the same supplier is now refused from the preview on, instead of failing at save time on a technical error.
• Fixed: accented characters in error messages were displayed as HTML codes.
• Compatibility: the module now requires PHP 8.1 as a minimum, like Dolibarr 22 and later.
• Compatibility: CSV reading and writing aligned with PHP 8.4, and a property use deprecated since PHP 8.2 removed.

UPDATE 1.0.2 (2026-09-07)

• New: a field lets you choose how many rows are displayed, up to the whole selection.
• Improved: the selected row count also applies to the CSV export and import.
• Improved: a message warns when rows matching the filters are not displayed.
• Improved: the row order stays identical between two displays for identical filters.
• Improved: purchase prices display faster on lists holding many suppliers.
• Improved: the row summary is now shown above the table instead of below it.
• Fixed: on long lists, rows edited past the first ones were ignored without any message.
• Fixed: an incomplete submission now shows an explicit error instead of saving part of the rows.

UPDATE 1.0.1 (2026-05-12)

• New: a supplier filter on the selling prices page, applied to the list, the preview, the CSV export and import.
• Improved: the availability of a new module version is reported in the module list.

UPDATE 1.0.0 (2026-04-20)

• New: two entries in the Products menu to mass edit selling prices and supplier purchase prices.
• New: mass edit of selling prices, with filters by category, product and warehouse.
• New: mass edit of supplier purchase prices, both creating and updating them.
• New: preview of the changes row by row before the final save.
• New: CSV export and import to prepare the changes outside Dolibarr.
• New: separate rights to view and to modify selling prices and purchase prices.
• New: module available in French, English, German, Spanish and Italian.