Products |
![]() |
For a product with 'xxx' code to be seen in the public area, a record with code='xxx' must be inserted in tbl_objects and tbl_objects_lng must contain a record with code='xxx' and code_lng=language code for the site (e.g.: EN, IT).
Table tbl_objects -- List of products
Field name | Field description | Field type | Field size | key | required | default | Observation |
---|---|---|---|---|---|---|---|
code | Product code | VARCHAR | 100 | yes | yes | For a product to be seen on the site, it must exist in tbl_objects_lng; for a variant product, the code is obtained from concat(codroot, codvar1, codvar2, codvar3). | |
code_alt | Alternative code | VARCHAR | 20 | ||||
descr_short_obj | Administrative short description | VARCHAR | 255 | ||||
descr_long_obj | Administrative long description | TEXT | |||||
vat | VAT value | DOUBLE | yes | 0 | |||
qty_available | Available quantity in stock | DOUBLE | 0 | ||||
qty_low | Low quantity in stock | DOUBLE | |||||
qty_high | High quantity in stock | DOUBLE | |||||
UNSPSC | UNSPSC | VARCHAR | 50 | ||||
code_disc_class | Code article discount class | VARCHAR | 100 | 0 | The code class (different from 0) must exist in tbl_disc_class with type='o'. | ||
weight | weight | DOUBLE | |||||
dim_l | length | DOUBLE | |||||
dim_w | width | DOUBLE | |||||
dim_h | height | DOUBLE | |||||
is_service | =1 if the product is free of shipping fees | CHAR | 1 | ||||
special_offer_all | =1 if the product is set as special offer for the entire e-business | TINYINT | 3 | ||||
last_modified | Date of last modification | DATETIME | |||||
codroot | The root code for the variant product | VARCHAR | 12 | For the products which are not variants, this field is NULL, otherwise this is the code of the root; linked to another code from tbl_objects. | |||
codvar1 | variant code for level 1 | VARCHAR | 8 | linked to codvar from tbl_artvar with the same codroot and livello=1 | |||
codvar2 | variant code for level 2 | VARCHAR | 8 | linked to codvar from tbl_artvar with the same codroot and livello=2 | |||
codvar3 | variant code for level 3 | VARCHAR | 8 | linked to codvar from tbl_artvar with the same codroot and livello=3 | |||
f_txt1 | -unused field; reserved for future implementations - | TEXT | |||||
f_txt2 | -unused field; reserved for future implementations - | TEXT | |||||
f_txt3 | -unused field; reserved for future implementations - | TEXT | |||||
f_int1 | -unused field; reserved for future implementations - | TINYINT | 3 | ||||
f_int2 | -unused field; reserved for future implementations - | INT | 10 | ||||
f_int3 | -unused field; reserved for future implementations - | INT | 10 |
Table tbl_objects_lng -- Contains the description in various languages for
each product
Field name | Field description | Field type | Field size | key | required | default | Observation |
---|---|---|---|---|---|---|---|
code | Product code | VARCHAR | 100 | yes | yes | Linked to code from tbl_objects | |
code_lng | Language code (e.g.: {IT, EN, FR, DE, ES, RO}) | CHAR | 2 | yes | yes | IT | Code lng is represented by the first 2 letters of the English name of the language (uppercases) |
descr_short_lng | Title product for language specified in “code_lng” | VARCHAR | 255 | yes | ??? | ||
descr_long_lng | Detailed description for language (may contain HTML code) | TEXT | |||||
notes | Notes (may contain HTML code) | TEXT | |||||
image_file | Product image name (e.g.: "myimg.gif") for list presentation | VARCHAR | 255 | The image needs to be uploaded on the server | |||
image_file1 | Product image name (e.g.: "myimg.gif") for detailed presentation | VARCHAR | 255 | The image needs to be uploaded on the server | |||
file_obj | File name associated to product (e.g.: "mydocument.doc") | VARCHAR | 255 | The file needs to be uploaded on the server | |||
link_obj | Link for the product (e.g.: "www.othersite.com") | VARCHAR | 255 | ||||
unit_label | Unit label (e.g.: kg, m) | VARCHAR | 20 | ||||
show_obj | Flag for hiding the product on the public site (0 or 1) | CHAR | 1 | Needs to be 1 to show the product | |||
f_txt1 | -unused field; reserved for future implementations - | TEXT | |||||
f_txt2 | -unused field; reserved for future implementations - | TEXT | |||||
f_txt3 | -unused field; reserved for future implementations - | TEXT | |||||
f_int1 | -unused field; reserved for future implementations - | TINYINT | 3 | ||||
f_int2 | -unused field; reserved for future implementations - | TINYINT | 3 | ||||
f_int3 | -unused field; reserved for future implementations - | TINYINT | 3 |
Table tbl_objects_fields --
Contains the list of all custom fields for each product
Field name | Field description | Field type | Field size | key | required | default | Observation |
---|---|---|---|---|---|---|---|
code | Product code | VARCHAR | 100 | yes | yes | Linked to code from tbl_objects | |
code_field | Field code | VARCHAR | 50 | yes | yes | 0 | Identifier of the custom field for each product |
code_lng | Language code {IT, EN, FR, DE, ES, RO} | CHAR | 2 | yes | yes | IT | Code lng is represented by the first 2 letters of the English name of the language (uppercases) |
fieldname | Field name | VARCHAR | 50 | ||||
value | Field value | VARCHAR | 255 | ||||
unit_of_mesure | Unit of measurement | VARCHAR | 50 |