The file imported will need to be in a comma delineated CVS format. The column headers have to be exactly the same as they are in the MicroBiz database. Here is an example of what the CSV file should look like with the headers at the top of the columns.
sku,desc,price,price_b
“ITEM1″,”SAMPLE ITEM”,12.00,12.00
“ITEM2″,”SAMPLE”,20.00,20.00
You can also add new columns by adding column headers that match the MicroBiz database headers.
sku,desc,price,price_b,cost,vendor
“ITEM1″,”SAMPLE ITEM”,12.00,12.00,5.00,123
“ITEM2″,”SAMPLE”,20.00,20.00,10.00,123
The CSV file should be saved in the root of the drive or within the BizWin or Business folder and can be created in Excel or Notepad. If you need any help creating the CSV file for import, please contact MicroBiz support at 702-749-5353.