Documentation | OrderLemon Cloud

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	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