Stop cleaning up duplicate order lines by hand

Detect, preview, and merge duplicate lines on Sales and Purchase Orders in a few clicks — with a full audit log and one-click undo, so you never have to trust a bulk operation blindly again.

The problem

Quotations, orders, and their purchase counterparts pile up duplicate product lines from rushed data entry, imports, and multi-editor workflows. Scanning a long document by eye to find and merge them is slow, and a mistake can silently change what a customer is invoiced for or what stock gets moved.

The solution

Merge Duplicate Lines flags duplicates the moment they appear, shows an on-screen preview of exactly what will change before anything is committed, and merges them in one click — keeping the correct price, tax, and discount. Every merge is logged and reversible, and a batch wizard sweeps duplicates across your entire back-catalogue.

Capabilities

Everything you need to keep documents clean

Every capability below is implemented in the module.

01

On-form duplicate detection

A banner and highlighted rows appear directly on Sales and Purchase Order forms the moment duplicate lines are found, so nothing is hidden in a long document.

02

Configurable matching modes

Choose exact matching, sum-quantities-of-same-product, or fuzzy name/SKU matching so detection fits how duplicates actually show up on your documents.

03

Live merge preview

The merge wizard shows the combined quantity and the resulting price, tax, and discount before you confirm — so you approve with confidence instead of trusting a black box.

04

Configurable conflict resolution

When duplicate lines carry different prices, choose to keep the first line, the highest price, or the lowest price on the survivor line.

05

One-click undo

Every completed merge can be reversed from its log entry, restoring the original lines exactly as they were — not just a rollback on error, a true undo after the fact.

06

Full merge history & audit log

Every merge is recorded with mode, line counts, and a snapshot of the original lines, so you can explain a document's history to a customer or auditor at any time.

07

Batch cleanup wizard

Sweep duplicates across many existing Sales and Purchase Orders in one pass, with a date range, an editable-only filter, and a configurable document ceiling.

08

On-entry duplicate warning

An inline warning fires the instant a product already on the document is added again, preventing most duplicates before they ever reach a finished order.

09

Simple, centralized settings

Set the default matching mode, conflict resolution, fuzzy-match threshold, entry warning, and batch ceiling from one settings screen — works out of the box with sensible defaults.

Workflow

How it works

1

Open the order

A banner and highlighted rows appear automatically on any Sales or Purchase Order that has duplicate lines.

2

Review the preview

Click Merge Duplicates to open the wizard and see the exact combined quantity, price, tax, and discount before anything changes.

3

Confirm the merge

One click consolidates the duplicate lines and logs the change, with a clear summary of what was merged.

4

Undo if needed

Open the merge log at any time and restore the original lines in one click, or run the batch wizard across your back-catalogue.

Questions

Frequently asked

No sales fog. If your question isn't here, email us and we'll answer it the same way.

Version 1 supports Sales Orders and Purchase Orders in their editable states. The detection and merge logic lives in a shared mixin, so more document types can be added later without rework.

Get the app

Buy it on the Odoo App Store

Purchase, download and install directly from the official Odoo Apps Store — you'll always get the latest supported build.

Merge Duplicate Lines

Detect and merge duplicate lines on sales and purchase orders with configurable matching, a live preview, conflict resolution, one-click undo and batch cleanup across existing documents.

Buy on Odoo App Store