This documentation is for a version that has reached its End Of Life. Such versions are no longer supported and don't receive security updates. Consider updating to a newer version.
SesExternalData¶
Field Type sesexternaldatatype uses external storage to store data.
The data is stored in the ses_externaldata table with the following structure:
| Field | Type | Description |
|---|---|---|
sku |
char(40) | Unique ID of the Product category (CatalogElement). |
identifier |
char(40) | ID of the Field. Consists of a constant prefix (ses) and lowercase letters from the ERP fields.Example: VENDOR_NO --> ses_vendor_no. |
language_code |
char(8) | Language code, for example, ger-DE. |
ses_field_type |
char(20) | The data type used for this data. |
content |
longtext | Serialized data in string format. |
Storing data in ses_externaldata¶
Data that is stored in the ses_externaldata table must be either a simple datatype: int, float, bool or a Field Type.
Field Type data is stored in the database in serialized form by using the toHash() method.
Simple data types (int, float, bool) are stored in serialized form.