[Fix] Website Conversion factor query (#15866)
* [Fix] Conversion factor query
* Update product.py
diff --git a/erpnext/utilities/product.py b/erpnext/utilities/product.py
index 6f984a5..a2867c8 100644
--- a/erpnext/utilities/product.py
+++ b/erpnext/utilities/product.py
@@ -108,8 +108,8 @@
uom_conversion_factor = frappe.db.sql("""select C.conversion_factor
from `tabUOM Conversion Detail` C
- inner join `tabItem` I on C.uom = I.sales_uom
- where C.parent = %s""", item_code)
+ inner join `tabItem` I on C.parent = I.name and C.uom = I.sales_uom
+ where I.name = %s""", item_code)
uom_conversion_factor = uom_conversion_factor[0][0] if uom_conversion_factor else 1
price_obj["formatted_price_sales_uom"] = fmt_money(price_obj["price_list_rate"] * uom_conversion_factor, currency=price_obj["currency"])