Skip to main content

How to Resolve Duplicate Inventory Products in ES

If duplicate inventory products exist, this guide covers two ways to merge them: Automated Script for large datasets or Manual Reconciliation for smaller ones. Once merged, the duplicate is archived, and inventory is consolidated.

M
Written by Maria Katrechko
Updated over 2 months ago

Solution Options

Option 1: Manual Reconciliation (Recommended for Small Numbers of Entries)

If you have only a few duplicate products, manual reconciliation can be an effective way to consolidate inventory.

Steps to Manually Reconcile Inventory:

  1. Prepare for Reconciliation:

    • Identify the incorrect product and the correct product to consolidate into.

  2. Create a Reconciliation Work Order:

    • Navigate to the Work Orders section in Elevated Signals.

    • Select Reconciliation Work Order from the dropdown menu.

    • Set the incorrect product as the Input Inventory.

    • Set the correct product as the Output Inventory.

  3. Reconcile Inventory:

    • Use the reconciliation work order to consume the inventory from the incorrect product.

    • Output the same quantity into the correct product.

  4. Archive the Duplicate Product:

    • Once the incorrect product’s inventory has been fully transferred, navigate to the Inventory Products section.

    • Archive the duplicate product to prevent further use.


Benefits:

  • No need for development team involvement.

  • Provides immediate control over the process.

Limitations:

  • Time-consuming for large datasets.

  • Manual tracking required to ensure no errors.


Option 2: Automated Script (Recommended for Large Numbers of Entries)

This option involves Elevated Signals' team running an "Inventory Product Squash" script to consolidate the duplicate products automatically.

What the Script Does:

  1. Combines Inventory:

    • Merges all quantities of the duplicate products into a single product.

  2. Merges Vendor Associations:

    • Transfers all associated vendors from both products into the consolidated product.

  3. Archives the Duplicate Product:

    • The empty duplicate product is archived to prevent further use.

Steps to Use This Option:

  1. Contact Elevated Signals support and request the "Inventory Product Squash" script.

  2. Provide the names and IDs of the duplicate inventory products you wish to merge.

  3. Wait for confirmation from the support team once the process is complete.

Benefits:

  • Quick and efficient for a large number of entries.

  • Minimal manual work required from your team.


Choosing the Right Option

Scenario

Recommended Solution

Large number of duplicate products

Option 1: Automated Script

Small number of duplicate products

Option 2: Manual Reconciliation


Key Notes

  • The Automated Script option is ideal for organizations with many duplicate entries and requires Elevated Signals’ development team.

  • The Manual Reconciliation option is suitable for quick fixes or a small number of duplicates.

  • Archiving empty products ensures they are no longer usable in the system.


Need Assistance?

If you need help deciding which option is best for your situation or require additional support, feel free to contact Elevated Signals support. We’ll guide you through the process and ensure a seamless resolution.

Did this answer your question?