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