Import Master File
Click here to download sample of sku file.
Click here to download sample of membership file.
- Click on System menu.
- Click Import Masterfile.
Click on Browse.
Select SKU/Member csv file.
Wait a moment. If error message, open csv file and edit data, repeat Step 4.
Click on Import button.
Restart ARMS LITE.
CSV Master File Format
Data Type | Description | Example |
C | Currency | 10.58 |
N | Numeric | 123 |
AN | AlphaNumeric | ABCD1234 |
Date | Date | 2015-01-01 (yyyy-mm-dd) |
SKU
No | Column | Data Type | Remarks |
1. | Line | AN | 1st Level Category Mandatory Only allow 20 character |
2. | Department | AN | 2nd Level Category Only allow 20 character |
3. | Manufacturer's Barcode | AN | Must be Unique |
4. | Alternative Barcode | AN | |
5. | Receipt Description | AN | Mandatory Only allow 40 character |
6. | Open price | AN | Default value: No Accepted Values: Yes, No |
7. | Selling Price | C | Mandatory Allow max 9999999.99 |
8. | Cost | C | Mandatory Allow max 9999999.99 |
9. | Stock Balance | N | Default Value: 0 |
10. | Member1 | C | Allow max 9999999.99 |
11. | Member2 | C | Allow max 9999999.99 |
12. | Member3 | C | Allow max 9999999.99 |
13. | Wholesales1 | C | Allow max 9999999.99 |
14. | Wholesales2 | C | Allow max 9999999.99 |
15. | Wholesales3 | C | Allow max 9999999.99 |
16. | Price1 | C | Allow max 9999999.99 |
17. | Price2 | C | Allow max 9999999.99 |
18. | Price3 | C | Allow max 9999999.99 |
Member
No | Column | Data Type | Remarks |
1. | Name | AN | Mandatory |
2. | NRIC | AN | Mandatory Must be unique |
3. | Card No | AN | Mandatory Must be unique |
4. | Join Date | Date | Mandatory Must greater than Date of Birth |
5. | Expiry Date | Date | Mandatory Must greater than Join Date |
6. | Date of Birth | Date | Mandatory |
7. | Member Type | AN | Values accepted: member1, member2 or member3 If not fill in system will set 'member1' as default |
8. | Race | AN | Values accepted: C, I, M or O If not fill in system will set 'O' as default |
9. | Contact No | AN | Mandatory |
10. | AN | Format Accepted: example@gmail.com | |
11. | Address1 | AN | Mandatory |
12. | Address2 | AN | |
13. | Postcode | AN | Mandatory |
14. | City | AN | Mandatory |
15. | State | AN | Mandatory Refer Appendix: State |
Appendix
State
No | State Name |
1. | Johor |
2. | Kedah |
3. | Kelantan |
4. | Kuala Lumpur |
5. | Labuan |
6. | Malacca |
7. | Negeri Sembilan |
8. | Pahang |
9. | Perak |
10. | Perlis |
11. | Pulau Pinang |
12. | Putrajaya |
13. | Sabah |
14. | Sarawak |
15. | Selangor |
16. | Terengganu |