From v6.6.0.0 of KonaKart is is possible to use custom fields as part of Product Descriptions. The advantage of these custom fields is that they can be defined for each language you support in the system (as with the other attributes on Product Descriptions such as Name, Description, URL etc).

By default these custom fields are created to use very little space in the database. The reason for this is to optimise overall KonaKart performance for those users who do not wish to use these fields. For those users who do wish to use these fields and need them to be able to hold more data in each field it is possible to increase the size of these columns in the database as required. All that is required is to execute an SQL statement appropriate for the database you are using. Therefore, to enlarge customd4 to 2000 bytes for a MySQL database you should execute:

ALTER TABLE products_description MODIFY customd4 VARCHAR(2000);

Having extended the sizes of the these columns the KonaKart APIs will continue to work in the same way - except that they will return the extended data items from these columns.

By default the product description custom fields are not displayed in the Admin App. To maintain these product description custom fields in the Admin App you need to enable the "showing" of these using File-Based Configuration (Business or Enterprise-Only - in the konakartadmin_gwt.properties file). You can enable all of the custom fields or just the fields that you require:

# Product Description Custom fields are all hidden by default
# The Admin App displays fields 1-3 in 1-line textboxes and fields 4-6 in multi-line edit areas.
#fbc.kk_panel_editProduct.desc.show_custom1                 = true
#fbc.kk_panel_editProduct.desc.show_custom2                 = true
#fbc.kk_panel_editProduct.desc.show_custom3                 = true
#fbc.kk_panel_editProduct.desc.show_custom4                 = true
#fbc.kk_panel_editProduct.desc.show_custom5                 = true
#fbc.kk_panel_editProduct.desc.show_custom6                 = true

By default the product description custom fields are validated according to their default sizes (and allowing empty fields). To change the validation for these fields to suit your needs, set the required validation in the CustomValidation.properties file for example (set these as required and uncomment the respective lines):

# Product.desc.custom1           = 0;128
# Product.desc.custom2           = 0;128
# Product.desc.custom3           = 0;164
# Product.desc.custom4           = 0;2000
# Product.desc.custom5           = 0;2000
# Product.desc.custom6           = 0;2000