Related Products
Accessories Compatibility Rules
Overview
DataSource provides accessory compatibility information as part of the Publishable Components. This information can be used to direct shoppers to additional products that they may want to consider at the time of purchase.
The Related Products are available in two ways:
- Accessories (Related Products Links) - provide Accessory SKU-to-Parent SKU relation.
- Accessory compatibility information (Compatibility Rules) - provide Accessory SKU-to-Parent Product Line/Model relation.
Accessories
The accessories information is delivered in the table Acc_Links.
Acc_Links
This table shows accessory-parent relationship, which products are accessories to which parent products. It includes products with specific related products designated by the manufacturer as well as those generated from a product's being an accessory to a specific product line / model. The table should be used to build accessory lists on product detail pages.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ProdID |
varchar(40) |
not null |
Accessory product identifier |
|
PProdID |
varchar(40) |
not null |
Accessory’s Parent Product identifier |
|
Delivery: Increment |
|||
Acc_Updates
The Acc_Updates table contains the list of accessories whose compatibility information has changed since the last delivery (either newly associated with parent products or unlinked from some parent products).
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ProdID |
varchar(40) |
not null |
Accessory product identifier |
|
Delivery: Increment |
|||
Related Queries
Sample query to extract the accessories can be found here.
Compatibility Rules
Accessory compatibility information is delivered in two tables: Acc_Compatibility and Acc_Compatibility_Complement.
Acc_Compatibility
The table provides the information on accessories to parent product line/model relationship.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ProdID |
varchar(40) |
not null |
Accessory product identifier |
|
PProductLine |
varchar(10) |
null |
Attribute value of a parent ProductLine related to this accessory |
|
PModel |
varchar(10) |
null |
Attribute value of a parent Model related to this accessory |
|
ComplementID |
int |
null |
Compatibility condition identifier – a reference to the table Acc_Compatibility_Complement_xx |
|
PCatID |
char(2) |
not null |
Category Code for the Accessory’s Parent Product |
|
PMfID |
varchar(10) |
not null |
Manufacturer identifier of the Accessory’s Parent Product |
|
Delivery: Increment |
|||
For each accessory product the information includes the parents’ Product Line, Product Model (where available), Category and Manufacturer name (the appropriate attribute values) even if the parent products are not a part of your catalog.
Acc_Compatibility_Complement_xx
It specifies under what condition compatibility of an accessory with parent products is valid and may also provide additional information regarding compatibility.
“xx” in the table name is for a language code which the data is delivered in.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ComplementID |
int |
not null |
Compatibility condition identifier |
|
ApplicableCondition |
varchar(2000) |
null |
Text that describes when the accessory fits the parent product line or parent model. |
|
Details |
varchar(2000) |
null |
Text that provides additional details in certain cases. |
|
Delivery: Increment |
|||
Sometimes compatibility of an accessory to a parent product is subject to a condition ("only for …", "except for…"). Conditions are formalized using searchable attributes and their values and are provided in a text format.
For example, a condition could be “When Service & Support Type = 1 year warranty” or “When Display Native Resolution is not 3200 x 1800”.
Accessory compatibility information is also provided in the Standardized Description as well as in Main and Extended Specifications as part of Designed For section.
For example in the Main Specifications:
|
Designed For |
HP 550, 67XX; Elite x2; EliteBook 2170, 25XX, 27XX, 720 G1, 72X G2, 740 G1, 74X G2, 750 G1, 75X G2, 820 G1, 84XX, 850 G2, 85XX, 87XX; EliteBook Folio 1020 G2, 10XX G1, 94XX; EliteBook Revolve 810 G1, 810 G3; Pro x2; ProBook 440 G2, 4530, 53XX, 6360, 64X G1, 64XX, 65X G1, 65XX; TouchSmart Elite 7320 |
Related Queries
Sample query to extract the compatibility information is here.