Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Menu Path: Inventory > Item > Upload Item Code

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

Image Modified

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 

Image Modified

Notes:

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


Excel sample:

Inventory Type

Image Modified

Encoded Type

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

Image Modified

Image Modified

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

Step 4: Upload file

Image Modified

Image Modified

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

...

  • 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

Image Modified

  • 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:

Image Modified

  • 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 NameNAME

Category Level 1

CATEGORY1

Category Level 2

CATEGORY2

List/Retail Price

PRICE_LIST
Sales/Wholesale / Dealer PricePRICE_SALE

Discounted price 1

PRICE_DISC1

Discounted price 2

PRICE_DISC2

Discounted price 3

PRICE_DISC3

Minimum Purchase Price

PURCHASE_PRICE_MINIMUM
Minimum Selling PriceMIN_QTY
Maximum Selling PriceMAX_QTY
Location CodeLOCATION_CODEMust be provided if MAX_QTY and MIN_QTY have value


Related Wiki Page:
Panel

Search Results
spacekeyWMS
maxLimit5
queryUpload Item Code
typepage

...