You can import data from the following popular programs: Access and Dbase.
It will also import database from the previous version of Shop Creator program in *.t format.

For Access or Dbase, you have to either export the database to a text file or use the ‘Save As’ command of the program to save the database as a text file. These text files must be space or tab delimited.

These four fields are mandatory for successful importing to Zilron StoreCreator program:
Item ID, Item Name, Category Name, Item Unit price

We have created a demo.txt (comma delimited) file for this lesson. You may use Notepad or any text editor program to view this file:

"Item ID","Item Name","Item Description","Parent Category","Category Name","Price"
"L1010","ABC Laserjet 4","Home use printer 4 ppm","ABC Laser","Laser 1000","350"
"L1011","ABC Laserjet 10","Home use printer 10 ppm","ABC Laser","Laser 1000","450"
"L1012","ABC Leserjet 12","Home use printer 12 ppm","ABC Laser","Laser 1000","1000"
"L1013","ABC Laser G10","Business use printer 10 ppm","ABC Laser","Laser 2000","850"
"L1014","ABC Laser G20","Business use printer 20 ppm","ABC Laser","Laser 2000","1250"
"L1015","ABC Laser M","Commercial Hi-speed printer 25 ppm","ABC Laser","Laser 5000","2300"

Note: the first row is the header row and will not be imported. The Parent Category is ‘ABC Laser’. The Parent Category and the Item Description are optional fields.

Select the ‘computer’ store.

At Store Editor screen:

• Click on the ‘Import Database’ button
• Select ‘MS Access’
• Locate and open ‘demo.txt’
• Check the ‘Header in the first row’ box as we do not intend to import the first header row
• Click ‘Ok’
• Select ‘0::L1010’ as the ‘Item ID’ field, click ‘Select’
• Select ‘1::ABC Laserjet 4’ as the ‘Item Name’ field, click ‘Select’
• Select ‘4::Laser 1000’ as the ‘Category Name’ field, click ‘Select’
• Click ‘Ignore this field’ for ‘Category Sort ID’
• Select ‘3::ABC Laser’ as the ‘Parent Category Name’ field, click ‘Select’
• Select ‘5::350.00’ as the ‘Item Unit Price’

• Click ‘Ignore this field’ for ‘Item Old Unit Price’
• Select ‘2::Home use printer 4 ppm’ as the ‘Item Description’ field’, click ‘Select’
• Click ‘Ignore this field’ for the rest of the fields
• Click ‘Start’ on the final dialog screen to start importing the database.
• Click ‘Ok’
• You should now see a new category ‘ABC Laser’ printers added to the catalog.