Defect HC-15195

SKU element has null in response when sales catalog is passed


Customer case Applies to Corrected in
CS0289066 V9.1.8.0

Observed behavior

The SQL used in Product Stage1i only looks at the CATEGPENREL table, if SKU does not have parent category records in this table, the category hierarchy won't be built for the SKU.

Expected behavior

The SQL should be including the parent product's parent category in the SKU results.


The Product Stage1i SQL was changed to add parent category records of the SKU's parent product to SKU. This allows for SKU's that do not have a parent category to included in the hierarchy.