Navigation:  Importing Data >

Importing Products

 Previous pageReturn to chapter overviewNext page

 

Open kBilling and the company file you would like to use. From the File menu on the main window's menu bar choose Import -> Import Products The format of the import file is 1 record per line with tab characters between the fields. Do not include a leading or trailing tab!

 

There should be 10 tabs total per line, any more or less and an error will be displayed.

 

Keep each record on a single line and place 1 tab character between the following fields in the order shown:

 

1.Product Name [Any format]
2.Category Name [Default or blank if none]
3.Status [Active or Inactive]
4.SKU [Any format, must me unique if not blank]
5.Product Description [Any format]
6.Stock [Amount in stock - numbers only]
7.Low Limit [ Limit at which to display an alert]
8.Price [Numbers and decimal only]
9.Cost [Numbers and decimal only]
10.Taxable [t or f indicating true or false]
11.Service [t or f (stock/cost isn’t applicable)]