Hierarchy Excel Upload

• For Hierarchy XL upload, click on ‘Hierarchy’ to upload the hierarchy masters through excel. Now select the ‘Generate XL’ which will generate excel format for the hierarchy data upload, fill the new data (no duplicates), save the excel. Through Excel at a time, it will allow Maximum 4000 records more than that it won't allow to upload.

• Now click on the ‘Load from Excel’ button to select the saved excel, select the masters excel, after selecting the excel click on Import button to import the master which are there in the selected excel, finally click on the ‘Save’ button to upload the data, uploaded data will be downloaded in the form of excel after save.



• If any duplicate data or invalid data found in the excel, then it shows the list of error data which we can send to a mail by giving a mail id at ‘To Mail ID’ and clicking on ‘Send Mail’ button, we can also export this error data in the excel as well.



• Below is the excel format for the Hierarchy upload. Column’s heading which are having * symbol is must to be filled.



• Location Name – Hyderabad
  HG code means Hierarchy Group Code – HYDHG1001
  H1 Code means Department Code - 10001
  H1 Description means Department Description Name – Food
  H2 Code means Category Code - 2001
  H2 Description means Category Description Name - Vegetables
  H3 code means Sub Category Code - 3001
  H3 Description means Sub-Category Description Name - Tomato
  

• Now Hierarchy group code which is HYDG1001 linked with the Department code/Description which is 10001/ Food, that Department linked with Category code/Description which is 2001/Vegetables, that category is linked with Subcategory Code/Description which is 3001/Tomato like this need to link through excel.