{"id":5081,"date":"2025-12-17T11:41:03","date_gmt":"2025-12-17T07:41:03","guid":{"rendered":"https:\/\/nayarweb.com\/blog\/?p=5081"},"modified":"2025-12-17T11:41:03","modified_gmt":"2025-12-17T07:41:03","slug":"import-export-flaw-in-erpnext-why","status":"publish","type":"post","link":"https:\/\/nayarweb.com\/blog\/2025\/import-export-flaw-in-erpnext-why\/","title":{"rendered":"Import\/Export Flaw in ERPNext. Why?"},"content":{"rendered":"<p>I exported my Item Categories from my dev Environment and imported to prod environment using Frappe own import and export tool. Guess what?<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5082\" src=\"https:\/\/nayarweb.com\/blog\/wp-content\/uploads\/2025\/12\/Screenshot-2025-12-17-at-11.31.28.png\" alt=\"\" width=\"796\" height=\"526\" srcset=\"https:\/\/nayarweb.com\/blog\/wp-content\/uploads\/2025\/12\/Screenshot-2025-12-17-at-11.31.28.png 796w, https:\/\/nayarweb.com\/blog\/wp-content\/uploads\/2025\/12\/Screenshot-2025-12-17-at-11.31.28-300x198.png 300w, https:\/\/nayarweb.com\/blog\/wp-content\/uploads\/2025\/12\/Screenshot-2025-12-17-at-11.31.28-768x507.png 768w\" sizes=\"auto, (max-width: 796px) 100vw, 796px\" \/><\/p>\n<p>It added quotes around the ID and failed to remove it during Import time. So I was unable to update my items due to ID (name) not matching. I really don&#8217;t understand how this is possible. ChatGPT says:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5083\" src=\"https:\/\/nayarweb.com\/blog\/wp-content\/uploads\/2025\/12\/Screenshot-2025-12-17-at-11.34.11.png\" alt=\"\" width=\"1092\" height=\"846\" srcset=\"https:\/\/nayarweb.com\/blog\/wp-content\/uploads\/2025\/12\/Screenshot-2025-12-17-at-11.34.11.png 1092w, https:\/\/nayarweb.com\/blog\/wp-content\/uploads\/2025\/12\/Screenshot-2025-12-17-at-11.34.11-300x232.png 300w, https:\/\/nayarweb.com\/blog\/wp-content\/uploads\/2025\/12\/Screenshot-2025-12-17-at-11.34.11-1024x793.png 1024w, https:\/\/nayarweb.com\/blog\/wp-content\/uploads\/2025\/12\/Screenshot-2025-12-17-at-11.34.11-768x595.png 768w\" sizes=\"auto, (max-width: 1092px) 100vw, 1092px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5084\" src=\"https:\/\/nayarweb.com\/blog\/wp-content\/uploads\/2025\/12\/Screenshot-2025-12-17-at-11.38.44.png\" alt=\"\" width=\"1734\" height=\"568\" srcset=\"https:\/\/nayarweb.com\/blog\/wp-content\/uploads\/2025\/12\/Screenshot-2025-12-17-at-11.38.44.png 1734w, https:\/\/nayarweb.com\/blog\/wp-content\/uploads\/2025\/12\/Screenshot-2025-12-17-at-11.38.44-300x98.png 300w, https:\/\/nayarweb.com\/blog\/wp-content\/uploads\/2025\/12\/Screenshot-2025-12-17-at-11.38.44-1024x335.png 1024w, https:\/\/nayarweb.com\/blog\/wp-content\/uploads\/2025\/12\/Screenshot-2025-12-17-at-11.38.44-768x252.png 768w, https:\/\/nayarweb.com\/blog\/wp-content\/uploads\/2025\/12\/Screenshot-2025-12-17-at-11.38.44-1536x503.png 1536w, https:\/\/nayarweb.com\/blog\/wp-content\/uploads\/2025\/12\/Screenshot-2025-12-17-at-11.38.44-1272x417.png 1272w\" sizes=\"auto, (max-width: 1734px) 100vw, 1734px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>ERPNext is an awesome piece of software. Unfortunately built on the wrong foundation I think. A primary key cannot and should not be a string containing real data.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I exported my Item Categories from my dev Environment and imported to prod environment using Frappe own import and export tool. Guess what? &nbsp; It added quotes around the ID and failed to remove it during Import time. So I was unable to update my items due to ID (name) not matching. I really don&#8217;t &hellip; <a href=\"https:\/\/nayarweb.com\/blog\/2025\/import-export-flaw-in-erpnext-why\/\" class=\"continue-reading\">Continue reading <span class=\"screen-reader-text\">Import\/Export Flaw in ERPNext. Why?<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-5081","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/nayarweb.com\/blog\/wp-json\/wp\/v2\/posts\/5081","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nayarweb.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nayarweb.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nayarweb.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nayarweb.com\/blog\/wp-json\/wp\/v2\/comments?post=5081"}],"version-history":[{"count":1,"href":"https:\/\/nayarweb.com\/blog\/wp-json\/wp\/v2\/posts\/5081\/revisions"}],"predecessor-version":[{"id":5085,"href":"https:\/\/nayarweb.com\/blog\/wp-json\/wp\/v2\/posts\/5081\/revisions\/5085"}],"wp:attachment":[{"href":"https:\/\/nayarweb.com\/blog\/wp-json\/wp\/v2\/media?parent=5081"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nayarweb.com\/blog\/wp-json\/wp\/v2\/categories?post=5081"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nayarweb.com\/blog\/wp-json\/wp\/v2\/tags?post=5081"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}