Same product from multiple databases

Question

I have two databases on the same accounts with exactly the same products and customers.
When I generate a sales report combining the two databases, I get a duplicate product names. For an example, I get Product x and Product x (2).

Is there a way to group the same product from the databases into one?

vijay kushwaha · Answer

*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 B

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
How can I restrict product creation from order ? (Odoo 16) Sales	4 lokak. 25	5185
How to Link a Salesperson to Customers Within a Defined Map Region? Sales	0 huhtik. 25	3304
Pay online with instalments Sales	1 maalisk. 25	162
UNIT OF MEASURE NOT BEEN DISCUSS IN THE VIDEO Sales	1 jouluk. 24	3123
The Video is private Sales	0 elok. 23	3029

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!