Alternative Searchable Attributes
Description
(ASA) / Alternative Categorization
Alternative Searchable Attributes are intended to simplify and improve integration of DataSource’s regular searchable attributes delivered to our customers in the cds_Atr table.
The benefits of Alternative Searchable Attributes feed for our customers include:
- Alternative (ready-to-publish and user-friendly) attribute names for all searchable attributes
- Translations of alternative searchable attribute names to all DataSource supported languages
- Identification of searchable attributes recommended for parametric search and comparison
- Recommended searchable attributes for each of level-4 Alternative DataSource Categories
- Display order of searchable attributes
- Attribute value ranges for numeric searchable attributes (e.g. Clock Speed or Hard Drive Size)
Feed Download
Supported Encodings
Alternative Searchable Attributes feed is available in the following encodings:
- Windows 1252
- Unicode UTF-8
- Unicode UTF-16
You can Download the Alternative Searchable Attributes Feed Here
Feed Integration
Alternative Searchable Attributes are available as a stand-alone feed not incorporated into the standard DataSource download.zip file.
The ContentConnector supports the processing of this feed.
Feed Update
The Alternative Searchable Attribute feed does not depend on customer catalog as it contains only meta data which is not SKU-specific.
Alternative Searchable Attribute feed is updated on monthly basis following modifications of the searchable attributes. The feed update is announced in the DataSource Technical Bulletin.
Supported Languages
Windows 1252 and Unicode UTF-8 / UTF-16 feeds contain the same tables and data elements.
The only difference between them is that the Unicode feed contains additional languages that are not supported in Windows 1252 encoding.
| Windows 1252 Feed Languages | Unicode UTF-8 / UTF-16 Feed Languages |
|---|---|
|
BR Brazilian Portuguese |
BR Brazilian Portuguese EE British English DA Danish NL Dutch NO Norwegian EN English US FI Finnish FR French DE German IT Italian PT Portuguese ES Spanish SV Swedish CS Chinese Simplified HK Chinese Traditional, Hong Kong TW Chinese Traditional, Taiwan CZ Czech JA Japanese KO Korean PL Polish TR Turkish RU Russian ID Indonesian |
Database Structure
cds_Asa_Cat
The table defines searchable and comparable attributes for each of the legacy DataSource categories delivered in cds_Prod of download.zip.
cds_Asa_Cat_Alt
The table defines searchable and comparable attributes for each of the Alternative DataSource categories delivered in cds_Cct_Products of download.zip.
cds_Asa_Voc
The table provides translations of attribute names to all of the supported languages.
Same table is also used for attribute range names and their translations:
cds_Asa_Ranges_Imperial
The table provides value ranges for the numeric searchable attributes. This table will contain attribute range values in Imperial system (ft, in, lbs).
cds_Asa_Ranges_Metric
The table provides value ranges for the numeric searchable attributes. This table will contain attribute range values in metric system (cm, km, kg).
cds_Asa_Metric
There are several attributes that display product characteristics always in inches, both in US and in Europe. Such attributes include display diagonal sizes (e.g. 15.6” laptop), hard drive form factors (e.g. 3.5” x 1/6H), etc.
As certain countries in Europe require all product information to be in metric system, we also duplicate all non-metric information in dedicated metric attributes.
This table defines replacing metric attributes for each searchable or comparable attributes that are normally provided to European customers in Imperial unit system (inches).
|
Field name |
Comments |
Examples |
Format |
Nullable |
|
AtrID |
Attribute ID matching AtrID field of cds_Atr table |
A00963 |
varchar(10) |
not null |
|
AttributeName |
Publishable Attribute Name in English |
Diagonal Size |
varchar(255) |
not null |
|
MetricAtrID |
Attribute ID of the metric attribute matching AtrID field of cds_Atr table |
A02902 |
varchar(10) |
not null |
|
MetricAttributeName |
Publishable Attribute Name in English for the metric attribute |
Diagonal Size (cm) |
varchar(255) |
not null |
Primary Key: AtrID
cds_Asa_Cat_Updates
The table provides alternative searchable attributes versioning for the legacy DataSource categories.
cds_Asa_Cat_Alt_Updates
The table provides alternative searchable attributes versioning for the Alternative DataSource Categories.
Related Queries
Please find Alternative Searchable Attributes queries Here.
