Feature Pack 7 or later

Troubleshooting: Price pending is shown for newly-indexed languages

The price pending status is shown in starter stores with WebSphere Commerce search for newly-indexed languages.

Problem

Prices are shown as pending in starter stores for newly-indexed languages in WebSphere Commerce search.

Solution

To resolve this issue, perform the following steps:
  1. Update the price mode to 0. For example, for a store with ID 10001:
    
    update storeconf set value=0 where storeent_id = 10001 and name='wc.search.priceMode'
    
  2. Update the currency conversion for the newly-indexed language. For example, for the Turkish language:
    
    insert into db2admin.CURCONVERT(STOREENT_ID,FROMCURR,TOCURR,FACTOR,MULTIPLYORDIVIDE,BIDIRECTIONAL,UPDATABLE, CURCONVERT_ID)
    values(10001,'USD','TRY','2.0','M','Y','Y',20001)