Upload Item Code

Menu Path: Inventory > Item > Upload Item Code

Step 1: Click file link: 'Upload Item Template'

Notes:

1. select source fields and add to target fields (The compulsory fields are pre-selected and can not be removed)
2. default format is “comma” delimiter

Step 2: Fill in the data 

Notes:

• Do not put invalid sign ( ' and & ) under ITEM CODE

Excel sample:

Inventory Type

Encoded Type

Step 3: Save file, save as comma separated values (.csv) format

Remarks: If want Chinese use this UTF-8(Only applicable for item name, item code must be in alphabetical)

Step 4: Upload file

Notes:

• If you want to update the exisiting information under item master data
• Please generate ITEM LISTING and follow Step 1 (download) to Step 4 (Upload)
• If item code exist, the system will overwrite it
• "Option" tickbox uses to check the completeness of the Tax Fields

Sample of Error Message 1:

• If user tick the "Option" box, and system found missing fields on Tax Column

• If the file is not sucessfully uploaded, please refer to the column with RED color background
• Please move the cursor to the RED color background to see the Error Message

• If this situation happen, please verify and correct the error eg: in the above case, put the add the PRICE_TAX_OPTION_INPUT Column in the file
• After editing the file, please repeat STEP 4

Sample of Error Message 2:

• If this situation happen, please verify and correct the error eg: in the above case, put the Remove the invalid sign from the Item Code ( ' and & ) Column in the file
• After editing the file, please repeat STEP 4

Field Description

Related Wiki Page: