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.

 

If you already have an Excel spreadsheet of products then importing them into kBilling® is easy.

 

Open your spreadsheet in Excel and add a new row at row 1.

 

Label each column with the appropriate header by putting the header text in row 1 for each column. The full list of available headers :

 

The smallest set of data kBilling® can import is a single column of either product names or SKU codes. If you do not have a column for the corresponding data in your spreadsheet just leave the column out or leave the heading blank. Columns without headers are ignored.

 

SKU

ProductName

Description

Category

Stock

LowLimit

 

 

Price

Cost

Taxable

Taxable2

Service

BinLocation

Status [Active, Inactive]

 

The columns Taxable,Taxable2 and Service are "yes or no" fields. The column data can be t, true, y or yes, or f, false, n, or no.

 

Case is ignored in the headers so "ProductName" is the same as "productname" (don't include the quotes).

 

Once the headers are in place select File -> Save As from Excel and for format, choose "Text (Tab delimited) (*.txt), then click the Save button.