Alternative Searchable Attributes

 

Description

 

(ASA) / Basic Categorization
 

(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: 

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
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
TR   Turkish
ID   Indonesian

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.