I exported my Item Categories from my dev Environment and imported to prod environment using Frappe own import and export tool. Guess what?

 

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’t understand how this is possible. ChatGPT says:

 

 

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.