Creating pricing assets

You have two options for creating your pricing assets:

To create pricing assets in the format of XML files that can be loaded into the database using the Loader package:

  1. Create an XML file that follows the offering.dtd. The DTD files are located in the following directory:
  2. Using the following example as your guide, create a trading position container in your XML file in the TRADEPOSCN table:
    <tradeposcn
    tradeposcn_id="@tradeposcn_id_1"
    member_id="&MEMBER_ID;"
    markfordelete="0"
    name="&STORE_IDENTIFIER;"
    precedence="0"
    />
    
  3. Associate the master catalog with a trading position container by adding information to the CATGRPTPC table. When you associate the master catalog with a trading position container, every catalog entry in the master catalog must have a standard price.
    <catgrptpc
    catalog_id="@catalog_id_1"
    tradeposcn_id="@tradeposcn_id_1"
    /> 
    
  4. Using the following example as your guide, create an offer for a catalog entry by adding information to the OFFER table. Note that you must have created catalog entries before you can create prices.
    <offer
    offer_id="@offer_product_id_furniture_loungechair_1"
    startdate="2003-01-01 00:00:00.000000"
    catentry_id="@catentry_product_id_furniture_loungechair_1"
    precedence="0"
    published="1"
    identifier="100"
    flags="1"
    tradeposcn_id="&TRADEPOSCN_ID;"
    />
    
  5. Using the following example as your guide, create an offerprice for a catalog entry by adding information to the OFFERPRICE table. The offer price is the actual price at which a catalog entry is offered for sale. Note that you must have created catalog entries before you can create prices.
    <offerprice
    offer_id="@offer_product_id_furniture_loungechair_1"
    currency="USD"
    price="449.99"
    />
    

    Note: To display multiple currencies in your store, create a separate XML entry in the OFFERPRICE table for each currency. For example, to display the currency in Canadian dollars, use currency="CAD" in a new XML entry. The price value would change to reflect the price in Canadian dollars. Or you can use a conversion, allowing the customer to display different rates based on the currency they select.

  6. Repeat steps 4 and 5 for all catalog entries in your catalog.

Feedback