Try ERPNext Buy Support Partners Foundation

How to import all HSN codes into ERPNext

Although there are plenty of posts about HSN codes but I am unable to import all HSN codes into my ERPNext self hosted version.
I had an impression that if INDIA is selected as country GST and HSN codes automatically gets updated but that’s not the case. GST settings I managed to do but I could not import HSN codes in bulk. Prompt resolution would be appreciated.

There are already 14,000+ HSN codes present in the system. They mostly cover almost all the HSN codes. Check “GST HSN Code” list.

Check the following link for more info: https://docs.erpnext.com/docs/user/manual/en/regional/india/gst-setup#2-setting-up-hsn-codes

Hope this helps.

No these HSN Codes are not present in my ERPNext. On HSN Code field only create new HSN Code is showing none of the HSN Codes. MY ERPNext is a SELF HOSTED on oracle virtual machine

Hi
You need to import all the HSN code by excel file

To do so, you will have to allow import for HSN codes. Go to the doctype list, open GST HSN Code, and check “Allow Import (via Data Import Tool)” checkbox.

Hope this helps.

1 Like

That is correct. The HSN codes are supposed to load when India is selected as the country on startup. For this, the HSN and SAC codes are preloaded from the JSON files under the regional settings:

In your case, can you share the ERPNext/Frappe versions and method of install for the VM?

Alternatively, you can run the import as suggested in batches to get the codes.

1 Like

ERPNext%20and%20Frappe%20versions

Standalone install on virtualbox
I downloaded virtual box and ERPNext ova file and installed and ran on localhost:8080

Thanks but which excel file. From where shall I get the excel file?