PriceRow applied to all products

[Former Member]

We are running Hybris 1808 and when we are creating model services to create pricerows, sometimes the prices are being applied to all products. When queried using Flexiblesearch, I can see the pricerow has the product associated. I compared the pricerow with other pricerows and i see that productmatchqualifier is not set.

I have never set the productmatchqualifier earlier. Has anyone faced similar issues or any directions/pointer is much appreciated.

[Former Member · Accepted solution]

Thanks for the response. We found the issue. The problem was Pricerows had the products associated but the productMatchQualifier was null. The problem happened because the pricerows got synched before the product associated with pricerow was synched. We resolved the dependency in sync process and now pricerows are working fine.

[Former Member · Accepted solution]

Hi Sanjay, we are seeing the same behavior in v6.6. This happens when we do a full load of products and prices and when sync executes these rogue PriceRow records gets created randomly. Initially, we thought this was caused by Orphaned types but after clearing the Orphaned types we still see this behavior on a full load of products and prices.

Could you describe how you created the dependency in sync process to resolve this?

[Former Member · Accepted solution]

hi we are seeing the same behavior in v6.6. This happens when we do a full load of products and prices and when sync executes these rogue PriceRow records gets created randomly. Initially, we thought this was caused by Orphaned types but after clearing the Orphaned types we still see this behavior on a full load of products and prices.

Could you describe how you created the dependency in sync process to resolve this?

[Former Member · Accepted solution]

So your Staged product contains the productMatchQualifier and not the online. ??because this attribute is set via prepare interceptor.

[Former Member · Accepted solution]

hi , yes the online contains null product match qualifier , before sync we don't see any such price rows , all are created after sync. Also we noticed the products are getting deleting from online catalog and re created during sync and this is not happening for all products only for the one's where productmatchqualifier is zero which further results such price rows getting created micro seconds before the product

[former_member704915]

To match the product, the PriceRow's product attribute must be set to contain the product.

To match the product's price group, the PriceRow's pg (product price group) must be set to contain a price group (an instance of ProductPriceGroup) which contains the product.

If there is a PriceRow that has no Product or ProductPriceGroup assigned to it, that PriceRow is applied to all products and therefore be effective by default.