Menu Path: Inventory > Item > Upload Item Code
Step 1: Click file link: 'Upload Item Template'
...
Use Open Office Calc to open the template file.
...
On the next screen, select by Separated By "Comma", Text Delimiter "Double Quotes".
...
Fill in the template content.
Not all the fields on the template are required, some may be optional. Please refer to the EMP Upload Item Code Screen on the required fields.
You may delete the non required fields at your discretion.
Key in in the Item / Product that you wish to bring into the system into the template. Kindly refer to EMP Upload Item Code Screen if unclear on the data format.
...
You may Upload the Item/ Product by following steps below.
Notes:
- select source fields and add to target fields (The compulsory fields are pre-selected and can not be removed)
- 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
EMP Field Name | Import Item Field Name | Description |
|---|---|---|
Item Code | ITEM_CODE | |
| Item Name | NAME | |
Category Level 1 | CATEGORY1 | |
Category Level 2 | CATEGORY2 | |
List/Retail Price | PRICE_LIST | |
| Sales/Wholesale / Dealer Price | PRICE_SALE | |
Discounted price 1 | PRICE_DISC1 | |
Discounted price 2 | PRICE_DISC2 | |
Discounted price 3 | PRICE_DISC3 | |
Minimum Purchase Price | PURCHASE_PRICE_MINIMUM | |
| Minimum Selling Price | MIN_QTY | |
| Maximum Selling Price | MAX_QTY | |
| Location Code | LOCATION_CODE | Must be provided if MAX_QTY and MIN_QTY have value |
Related Wiki Page:
| Panel | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|