Ensure Each Product Has a Unique Internal Reference (Barcode or SKU):

• Go to Sales ‣ Products.
• Assign a unique internal reference (SKU) to each product.

Modify Sales Report to Group by Internal Reference Instead of Product Name:

• In Reporting ‣ Sales, switch to Pivot/Table view.
• Group sales by Internal Reference instead of Product Name.
• This will merge Product X and Product X (2) into one entry if they share the same reference.

If Using External Reporting Tools (Excel, Power BI, etc.):

• Export reports from both databases.
• Use the Internal Reference column as a unique identifier to merge data.