Tuesday, 26 August 2025, 11:05 AM
Created by: Mathieu Van daele
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 | 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 |