|
Navigation: Importing Data > Importing Products |
![]() ![]()
|
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.