Bulk Edit Customer-Specific Prices - MassEditPrixClient

MassEditPrixClient — Bulk Edit Customer-Specific Prices for Dolibarr

Managing customer-specific prices in Dolibarr normally means opening each product card one by one, navigating to the customer price tab, and updating values individually. MassEditPrixClient eliminates this friction by providing a dedicated page where you can create, update, and delete specific prices for any customer across your entire product catalog — all from a single, efficient table.

⚠️ Prerequisite: In the product pricing rules, the option "Different prices for each customer" must be selected for customer-specific prices to be applied in quotes and invoices.

Two dedicated tabs

• By product — Displays your full product catalog for a selected customer. For each product, you can see the base price, the existing customer-specific price (highlighted in green), and an input field to set or update the price. A green left border instantly identifies products that already have a specific price for this customer.
• Existing prices by customer — Displays only the products that already have a specific price for the selected customer. Ideal for auditing and quickly correcting a customer's pricing. You can also delete a specific price by clearing the field — the product then reverts to its base price.

Smart INSERT / UPDATE / DELETE logic

The module automatically applies the correct SQL operation depending on the situation:

• No specific price exists + price entered → INSERT
• Specific price exists + price entered → UPDATE
• Specific price exists + field cleared → DELETE (product reverts to base price)

No manual intervention needed — the module handles everything in a single transaction with full rollback on error.

Smart editing experience

• Modified fields are automatically highlighted in yellow
• Rows are automatically checked as soon as a value is changed
• The status bar shows the count of selected rows and pending modifications at all times
• A quick filter lets you display only products with an existing specific price for fast auditing

Powerful search and filters

• Full-text search on product reference and label
• Category filter to narrow down the product list
• Customer selector (up to 500 active customers, sorted by name)
• Configurable rows per page: 10 to 1000 — memorized per session
• Full pagination controls

Safe and reliable saves

Only checked rows are processed on save. If an error occurs on any line, the entire transaction is rolled back — no partial updates, no corrupted data. Result messages clearly indicate how many records were inserted, updated, or deleted.

Installation

1. Go to Home → Configuration → Modules → Deploy an external module and upload the ZIP file
2. In the product pricing rules, select "Different prices for each customer"
3. Find MassEditPrixClient in the module list and click Enable
4. The menu entry Edit customer prices in bulk will appear under Products in the left navigation bar

Requires Dolibarr v17 or higher.

Technical details

Stop setting customer prices one product at a time. MassEditPrixClient gives you full control over your entire pricing strategy in minutes.