# Products

> Any product belongs to a category. Before being able to make a product you must have a category to add this product to. Name Type Length Null allowed Default id integer 11 No Auto increment reference…

- Page: https://cloud.orderlemon.com/knowledge_base/view/12-products
- Part of: [Knowledge base](https://cloud.orderlemon.com/knowledge_base/llms.txt) on OrderLemon Cloud — https://cloud.orderlemon.com/llms.txt
- Updated: 2026-10-26T10:10:44Z

Any product belongs to a category. Before being able to make a product you must have a [category](https://cloud.orderlemon.com/knowledge_base/view/11) to add this product to.

| Name | Type | Length | Null allowed | Default |
| --- | --- | --- | --- | --- |
| id | integer | 11 | No | Auto increment |
| reference | string | 30 | Yes | Null |
| name | string | 200 | No |  |
| description | string | 65535 | Yes | Null |
| image_path | string | 65535 | Yes | Null |
| The image URL on our server, after downloading, prefixed by our image domain. |  |  |  |  |
| unit_price | double | 10,2 | No |  |
| sale_price | double | 10,2 | Yes | Null |
| sale_price_start | DateTime |  | Yess | Null |
| sale_price_end | DateTime |  | Yes | Null |
| vat_percentage | integer | 2 | No | 0 |
| enabled | boolean |  | No |  |
| category_name | string | 24 | No |  |
| category_id | integer | 11 | No |  |
| stock | integer | 11 | No | 0 |
| isstock | boolean |  | No | True |
| position | integer | 4 | Yes | 1 |
| The position in which to show the categories in the WhatsApp flow, when not using a web catalog. |  |  |  |  |
| isfav | boolean |  | No | False |
| ol_code | string | 10 | Yes | Null |
| campaign_id | integer | 11 | Yes | Null |
| If you add a product to a special, the campaign id gets stored here and the product is no longer available in a normal catalogue. |  |  |  |  |
| google_code | string | 10 | Yes | Null |
| fb_code | string | 10 | Yes | Null |
| allowed_dow | string | 65535 | Yes | Null |
| Holds a comma separated list, 0 is monday, 6 is sunday. E.g. "0,1,2,3,4,5,6" or "0" |  |  |  |  |
| reset_stock | integer | 11 | No | 0 |
| reset_hours | string | 100 | Yes | Null |
| reset_days | string | 100 | Yes | Null |
| happy_hour | boolean |  | No | False |
| minimum | integer | 11 | Yes | Null |
| Minimum quantity to choose, optional. E.g. choose at least 2 of this product. Overrides from the category's minimum. |  |  |  |  |
| maximum | integer | 11 | Yes | Null |
| Maximum quantity to choose, optional. E.g. choose at most 2 of this product. Overrides from the category's maximum. |  |  |  |  |
| unit | string | 50 | Yes | Null |