Products
Index of tables:

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_categcode5.2 VAT category code CHAR 10       linked to from vatc_code from tbl_vatcateg
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_service5.0 =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

ISO code of the language - uppercase
[VIEW the table of Language Codes]

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 (e.g.: IT, EN, FR, DE, ES, RO) CHAR 2 yes yes IT ISO code of the language - uppercase
[VIEW the table of Language Codes]
fieldname Field name VARCHAR 50        
value Field value VARCHAR 255        
unit_of_mesure Unit of measurement VARCHAR 50