Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
1 Trả lời
1252 Lượt xem

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?

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

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.
Ảnh đại diện
Huỷ bỏ
Bài viết liên quan Trả lời Lượt xem Hoạt động
0
thg 4 25
980
1
thg 3 25
162
1
thg 12 24
991
0
thg 8 23
1016
3
thg 12 24
2977