Merge pull request #1230 from akhileshdarjee/hotfix
[fix] [minor] update item_name and description in item price
diff --git a/patches/1312/p02_update_item_details_in_item_price.py b/patches/1312/p02_update_item_details_in_item_price.py
new file mode 100644
index 0000000..c19988c
--- /dev/null
+++ b/patches/1312/p02_update_item_details_in_item_price.py
@@ -0,0 +1,10 @@
+# Copyright (c) 2013, Web Notes Technologies Pvt. Ltd. and Contributors
+# License: GNU General Public License v3. See license.txt
+
+from __future__ import unicode_literals
+import webnotes
+
+def execute():
+ webnotes.conn.sql("""update `tabItem Price` ip INNER JOIN `tabItem` i
+ ON (ip.item_code = i.name)
+ set ip.item_name = i.item_name, ip.item_description = i.description""")
\ No newline at end of file
diff --git a/patches/patch_list.py b/patches/patch_list.py
index 49c0779..608ba77 100644
--- a/patches/patch_list.py
+++ b/patches/patch_list.py
@@ -262,4 +262,5 @@
"patches.1311.p07_scheduler_errors_digest",
"patches.1311.p08_email_digest_recipients",
"execute:webnotes.delete_doc('DocType', 'Warehouse Type')",
+ "patches.1312.p02_update_item_details_in_item_price",
]
\ No newline at end of file