Prices not displaying on categories or search results

Technote (troubleshooting)


Problem(Abstract)

When selecting a particular currency on the storefront, prices display on ProductDisplay pages but not on the categories or search results

Symptom

Instead of the Price you see "Price Pending" on the category and search result pages


Cause

The currency selected is not indexed which is where the price should come from on the particular pages (not ProductDisplay). To check which currencies are indexed out of the box, see article: Temporary table schema definition.

... and go down to "TI_OFFERPRICE_#INDEX_SCOPE_TAG#"

Resolving the problem

Open this file:

wc-dataimport-preprocess-offerprice.xml

... It guides you as to where you need to add entries for an additional currency. For example:

<!--
To add a new currency, add a new column in the create statement, the column name has to PRICE_XXX, XXX is the three letter
currency code from the ISO 4217.
-->

You will also need to change the corresponding wc-data-config.xml file. Look for any occurrence of "TI_OFFERPRICE.PRICE_USD" and add in a similar entry for the new currency in every query where you find it.

Also add a specific field tag for the new currency. For example:

<field config="PRICE_XXX" name="price_XXX"/>

...Now preprocess and rebuild the index.


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

WebSphere Commerce Enterprise
Contracts / Pricing / Offer

Software version:

7.0.0.2, 7.0.0.3, 7.0.0.4, 7.0.0.5, 7.0.0.6

Operating system(s):

AIX, IBM i, Linux, Solaris, Windows, i5/OS

Software edition:

All Editions

Reference #:

1625329

Modified date:

2013-04-15

Translate my page

Machine Translation

Content navigation