May 7, 2020

Issues Resolved

[ZPD-10208] - Web Store - Product related issues:

• Same Frequently Bought Together products were getting displayed multiple times in the Frequently Bought Together product widget on the PDP.

• Child product attribute related changes were not getting reflected on PDP with enhanced publish.

[ZPD-10282] - In some scenarios, Znode_GetPublishProducts stored procedure used to timeout.

Implementation Details

[ZPD-10208] - Web Store - Product related issues:

• Same Frequently Bought Together products were displayed multiple times in the Frequently Bought Together product widget on the PDP. To resolve this issue, changes were made in Znode_GetPublishProductbulk stored procedure. 

• Child product attribute related changes were not getting reflected on PDP with enhanced publish.

To resolve this issue, changes were made in Znode_InsertUpdatePimCatalogProductDetail stored procedure.

[ZPD-10282] - In some scenarios, Znode_GetPublishProducts stored procedure used to timeout.

To resolve this issue, index IDX_ZnodePublishAssociatedProduct_PimProductId was created on the ZnodePublishAssociatedProduct table for the PimProductId column.