patch
diff --git a/erpnext/patches/v5_0/update_item_desc_and_image.py b/erpnext/patches/v5_0/update_item_desc_and_image.py
index 4e03f59..456c505 100644
--- a/erpnext/patches/v5_0/update_item_desc_and_image.py
+++ b/erpnext/patches/v5_0/update_item_desc_and_image.py
@@ -4,4 +4,19 @@
import frappe
def execute():
- pass
\ No newline at end of file
+ dt_list= {"Purchase Order Item","Supplier Quotation Item", "BOM", "Bom Explosion Item" , \
+ "Bom Item", "Opportunity Item" , "Quotation Item" , "Sales Order Item" , "Delivery Note Item" , \
+ "Material Request Item" , "Purchase Receipt Item" , "Stock Entry Detail"}
+
+ for dt in dt_list:
+ names = frappe.db.sql("""select name, description from `tab{0}` doc where doc.description is not null""".format(dt),as_dict=1)
+ for d in names:
+ try:
+ data = d.description
+ image_url = data.split('<img src=')[1].split('" width=')[0]
+ desc = data.split('<td>')[1].split('</td>')[0]
+ frappe.db.sql("""update `tab{0}` doc set doc.description = %s, doc.image = %s
+ where doc.name = %s """.format(dt),(desc, image_url, d.name))
+ except:
+ pass
+
\ No newline at end of file