Intermediate | Creating Item in Bulk (Item Import)

1 - Generate Master Data Format for Item Import

1. System Configuration
2. Import -> Under Item -> Import Items Data -> Select Generate File Format

• This format file will be generated in .csv file.

 

2 - Data Entry for New Item

1. Open the generated file with a compatible program. Eg: Microsoft Excel

2. Fill in all the necessary info according to the column.

   • Item Code & Item Name are compulsory fields (do not remove these columns).

   • You may leave the columns blank (except for Item Code & Item Name) if the field is not in used. The system will ignore the blank data and will not overwrite the existing data to empty (blank).

   • You may delete the columns that are not in used.

3. Save the file and go back to System Configuration -> Import -> Item -> Import Items Data.

4. Click on the Import button and choose the file which you have edited earlier.

5. Import Browser will prompt and this is the final verification before the items are being imported into the system. There is no undo button once we proceed to the next step, so verify the data carefully!

6. Click the OK button once it's done. The system will begin the item import process.

   • This may take awhile depends on your machine performance and the numbers of data being imported into the system.

Frequently Asked Questions

Is it possible to delete items in bulk?
This function is only available in our latest AppVersion.