Product Duplicate Prevention Checker
(Pre-Installation Diagnostic Tool)

for Odoo 19 Community Edition & Enterprise On Premise

Scan your entire product database for duplicate names with intelligent detection that catches duplicates regardless of letter case or extra spaces. Export results to Excel for mass editing and archive management.

Key Features

• Smart Duplicate Detection: Scans all products and identifies duplicates using case-insensitive and space-normalized comparison (e.g., "USB Cable" = "usb cable" = "USB CABLE").
• Visual Wizard Interface: Easy-to-use wizard showing duplicate groups with color-coded status (green = keep, yellow = review).
• Excel Export for Mass Editing: Export duplicates to Excel with pre-formatted columns for bulk renaming and archiving.
• Archive Management: Rename and archive duplicate products directly via Excel import - no manual clicking needed.
• Detailed Instructions: Excel file includes step-by-step guide for editing and importing back to Odoo.
• External ID Support: Uses Odoo-compatible External IDs for safe import/update without creating new records.
• Safe & Read-Only: Scanning only - no automatic changes to your data. You control what to keep, rename, or archive.
• Zero Configuration: Works immediately after installation with no setup required.

Why Use This Module?

Scenario: You want to install the Product Duplicate Prevention module, but your database has existing duplicate products from years of data entry by multiple users.

Solution: Use this Checker module to:

1. Scan and identify all existing duplicates
2. Export duplicates to Excel for review
3. Mass edit product names and archive status in Excel
4. Import back to Odoo to update all products at once
5. Verify zero duplicates before installing Prevention module

How It Works

Step 1: Scan for Duplicates

Go to Inventory → Configuration → Check Product Duplicates and click "Scan Duplicates".

The wizard will show:

• Total products scanned
• Number of duplicate groups found
• List of all duplicates with color coding:
  • Green (KEEP) = Suggested master product to keep
  • Yellow (REVIEW) = Duplicates that need action

Step 2: Export to Excel

Click "Export to Excel" button to download a pre-formatted Excel file containing:

• Column A: Duplicate group number
• Column B: External ID (do not modify)
• Column C: Database ID (reference only)
• Column D: Name (edit here for REVIEW products)
• Column E: Active status (TRUE/FALSE for archive)
• Column F-I: Reference information

Step 3: Edit in Excel

For each REVIEW product (yellow rows), choose one of three options:

1. Rename Only: Fill Column D with new unique name, keep Column E = TRUE
2. Rename and Archive: Fill Column D with new unique name, set Column E = FALSE
3. Skip: Leave empty, fix manually later in Odoo

Step 4: Import Back to Odoo

Import the edited Excel file:

1. Inventory → Products → Products
2. Favorites (⭐) → Import records
3. Upload Excel file
4. Map columns:
   • External ID → External ID
   • Name → Name
   • Active → Active
5. Test → Import

Step 5: Verify

Run the scanner again. Should show: "✓ No Duplicates Found!"

Now you can safely install the Product Duplicate Prevention module.

Excel Export Features

Sheet 1: Duplicate Products

• Color-coded rows (green = keep, yellow = review)
• Pre-filled names for KEEP products
• Empty fields for REVIEW products (ready for editing)
• Active status column for archive management
• External ID for safe import (no duplicate creation)

Sheet 2: Instructions

• Step-by-step guide for editing in Excel
• Odoo import instructions with screenshots reference
• Troubleshooting common import errors
• Examples of rename, archive, and skip scenarios

Archive Management

Important: If you want to archive duplicate products, you must rename them first!

Why? Archived products with duplicate names will still be detected by the scanner and will block installation of the Prevention module.

Best Practice: Rename with clear suffix before archiving:

• "Product ABC" → "Product ABC [ARCHIVED 2026]"
• "Old Item" → "Old Item - Discontinued"

Real-World Example

Before Scan:

After Export & Edit:

Result: 3 unique products, no duplicates detected!

Benefits

• ✅ Mass Edit: Fix hundreds of duplicates in minutes via Excel instead of clicking one by one
• ✅ Safe Import: Uses External ID to update existing products (never creates duplicates)
• ✅ Full Control: You decide what to keep, rename, or archive - no automatic changes
• ✅ Time Saver: Export → Edit → Import workflow is 10x faster than manual editing
• ✅ Archive Management: Rename and archive in one import operation
• ✅ Clear Reporting: Visual wizard shows exactly what needs attention
• ✅ Preparation Tool: Ensures clean database before installing Prevention module
• ✅ No Data Loss: Read-only scanning - your data stays intact until you import changes

Installation

1. Download and install this module first
2. No configuration needed - works immediately
3. Go to Inventory → Configuration → Check Product Duplicates
4. Scan, export, edit, and import to clean up duplicates
5. After cleanup, install Product Duplicate Prevention module

Technical Details

• Module Name: wimpy_product_duplicate_checker
• Model: TransientModel (wizard - no permanent database tables)
• Dependencies: stock (Inventory module)
• Python Library: xlsxwriter (for Excel export)
• Menu Location: Inventory → Configuration → Check Product Duplicates
• Compatible: Odoo 19.0 Community & Enterprise

FAQ

Q: Will this module prevent duplicate creation?

A: No. This is a diagnostic tool only. It scans and helps you fix existing duplicates. To prevent new duplicates, install the Product Duplicate Prevention module after cleanup.

Q: Can I use this without installing the Prevention module?

A: Yes! This checker is useful on its own for periodic duplicate audits and cleanup.

Q: What if import creates new products instead of updating?

A: Make sure you map "External ID" column correctly. This tells Odoo which product to update.

Q: Do I need to install xlsxwriter?

A: Yes, for Excel export. Install with: pip3 install xlsxwriter

Q: Can I archive without renaming?

A: Not recommended. Archived duplicates will still be detected. Always rename before archiving.

Support

Version: 19.0.1.0.0
Author: Wimpy Nastian F.
Contact: LinkedIn

Clean Up Your Product Database Today!

Install Product Duplicate Checker and fix duplicates in minutes, not hours.

✓ Export to Excel    ✓ Mass Edit    ✓ Safe Import    ✓ Archive Management