eServiceWeb - Help Desk

Managing Items > Import & Export Item List
Import & Export Item List:
 
This Import/Export feature is only available for certain solution packages.  Please check if your order is including this feature.
 
Item Manager: Import/Export Feature

This feature is very helpful for quick editing of your items, especially your item information is changing frequently.  Please take special care when using this feature to avoid data corruption.
 
 
1. Export your item list first: file name is items.csv
2. Keep a copy with another name (eg. itemsBackup.csv) in case you want to recover it
3. Edit the items.csv and save with the same file name with the same layout and heading(You can only import this file with same file name)
 
Special Care for data:
 
1. Add new items: When adding new items, you must fill at least two fields - item No. and Name fields
2. Category and Sub-category: The category and sub-category will be separated with two colons" :: "
Eg. The item is listed in the sub-category of Acer LCD Monitor (LCD Monitors is the main category and Acer LCD Monitors is sub-category)
Display on the item.csv file Category column: LCD Monitors::Acer LCD Monitors
3. Multi-Category Listing: If the item is displaying in multi-category, each category will be separated with two straights "||"
Eg. The item is listed in multi categories: Listed in the main category name LCD Monitors and also in the sub-category of Acer LCD Monitor
Display on the item.csv file Category column: LCD Monitors::Acer LCD Monitors||LCD Monitors