Catalog item Price is set to 0 but not showing in the list view.

[aryan-jha]

I need to set the price to 0 for certain catalog items where the price is currently not 0.

With the condition Category = "Hardware Requests", I identified 5 catalog items where the price was not equal to 0. I updated the price field to 0 for all of them.

However, I am observing an inconsistency:

• For 3 catalog items, the price is correctly showing as 0 in the list view.
• For the remaining 2, the list view still does not display the price as 0, even though when I open those catalog items, the price field is set to 0.

Could you please help me understand why the list view is not reflecting the updated value and how I can ensure that the price shows as 0 in the list view as well?

[Tanushree Maiti · Accepted solution]

Hi @aryan-jha 

Refer KB: KB0957498 Value of the currency field is showing as 0 instead of the actual value 

Cause

• The cause of the issue is duplicate records that exist in fx_price.
• Search the fx_price with the sysid of the affected record.
• The current prices are stored on the fx_price table which needs to be one record in the table - fx_price but here two records are existing one with value "0" and another one with an actual value.

Resolution

By deleting the record in fx_price which is no longer required that would fix the issue.

Validate this for your requirement.