product_string_properties

This table represents the content of the product properties with the format string. The product properties represent calculated data for each product which should be loaded in the Solr Index. By filling this table and declaring the properties in the product_properties_metada, the system will will automatically upload and create/update your product properties in the Solr Index.

Field name

Type

Mode

Description

Field name

Type

Mode

Description

product_id

STRING

REQUIRED

PK - the product id

property_name

STRING

REQUIRED

PK - the product property name

property_value

STRING

REQUIRED

PK - the product property value

origin

STRING

REQUIRED

please provide a unique key defining the origin system of these data, not used, but useful for debugging / monitoring

creation_tm

TIMESTAMP

REQUIRED

please provide timestampe of the initial creation of this row

last_modified_tm

TIMESTAMP

REQUIRED

please provide timestampe of the last modification of this row