|
|
Last updated on July 6, 2008. Email your inquiries and suggestions to vincent
|
wavelet.biz
Copyright of WAVELET.BIZ
To import an existing list of item code from an excel file, please follow instructions below:
All the fields are placed in ONE line, representing details of ONE item.
Sample
| There all together 16 fields to provide for a particular Item Code. Please provide a file with the fields in sequence, e.g: Fields Item Code,Item Name,Category 1,Category 2,Category 3,Category 4,Category 5,Serialized(1-yes/0-no), List Price,Sales Price,Disc1 Price,Min Selling Price,Rebate (in %),EAN Code,Unit of Measurement, Status(1-active/0-inactive) |
| TISPRE3LYR,PREMIER FACE TISSUE,PREMIER,TISSUE,FACE,3 LAYER,WHITE,0,10,9,7.5,6,0.3,026589347,box,1 ***sample 1 is an example of: Item code : TISPRE3LYR Item name : PREMIER FACE TISSUE Cat 1 : PREMIER Cat 2 : TISSUE Cat 3 : FACE Cat 4 : 3 LAYER Cat 5 : WHITE Serialized : 0 (which means No) List Price : 10 Sales Price : 9 Disc1 Price : 7.50 Min Price : 6 Rebate Percentage : 30% EAN Code : 026589347 UOM : box Status : active |
SERPRE1LYR,PREMIER KITCHEN PAPER,PREMIER,KITCHEN PAPER,ROLL,1 LAYER,WHITE,1,12,11,10,8,0,,roll,0 ***sample 2 is an example of: Item code : SERPRE1LYR Item name : PREMIER KITCHEN PAPER Cat 1 : PREMIER Cat 2 : KITCHEN PAPER Cat 3 : ROLL Cat 4 : 1 LAYER Cat 5 : WHITE Serialized : 1 (which means Yes) List Price : 12 Sales Price : 11 Disc1 Price : 10 Min Price : 8 Rebate Percentage : 0 EAN Code : - UOM : roll Status : inactive |
Note:
All fields has to be separated in comma. For any fields which does not apply to you, just leave it blank like the example above (Sample 2, EAN Code). Do not put in space when you intend to leave it blank. All prices and percentage fields have to be filled in even if it's not applicable, in this case, you can always put in '0'.
You can always plot all your information in an excel file (also with the 16 fields) and choose to save as a CSV file, which will automatically produce a file which is similar to the above samples.