Defect HC-15195
SKU element has null in response when sales catalog is passed
Software
| Customer case | Applies to | Corrected in |
|---|---|---|
| CS0289066 | V9.1.8.0 | 9.1.10.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.
Resolution
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.