Troubleshooting: Prices are not reflected in the storefront and show Price pending

After deploying HCL Commerce Developer with the Solr-based search solution, storefront URLs may display Price pending instead of actual product prices.

Solution

  1. Verify the database configuration.
    Check the database to ensure that the parameter wc.search.priceMode.compatiblePriceIndex is set to 0 in the storeconf table. If not, run the following SQL command to update it:
    update storeconf set VALUE='0' where  NAME='wc.search.priceMode.compatiblePriceIndex';
    
  2. Refresh registries.
    Refreshing registries is essential. Use any one of the methods listed below:
    • Restart the Transaction server, or
    • From Admin Console: Go to Configuration > Registry > Update All, or
    • From Management Center: Open Management Center and go to System Administration > Registries, then click Update all registries.
    For more information, see Displaying price ranges in the storefront
  3. Clear Redis cache.
    Run the following commands:
    docker exec -it <redis container> bash
    redis-cli
    FLUSHALL
    
  4. Restart the Search server in RAD (Rational Application Developer).

Result

The product price is displayed on the storefront.