Products

Field	Type	Length	Unique	Required	Format	Description
identifier	varchar	80	yes	yes		Product ID
name	varchar	255	no	yes		Product Name (usually the short name of the product that appears on printed invoices)
description	varchar	32768	no	no		Product Description (the long product name or description, if none exists then use Product Name here also)
is_active	boolean		no	yes	true/false	Is Product active? If your system has no active/inactive flag then always make this 'true'
selling_price	float	8	no	yes		Selling Price including sales tax
is_selling_price_inc_tax	boolean		no	yes	true/false	Is Tax included in selling price. This should always be true
buying_price	float	8	no	no		Buying Price including sales tax (optional)
is_buying_price_inc_tax	boolean		no	no	true/false	Is Tax included in buying price. This should always be true (optional)

Example CSV-File: products.csv

ProfitDiagnostix Public knowledge base