Create pricing assets

You have two options for creating your pricing assets:

• Create prices using the Product Management tools in the WebSphere Commerce Accelerator. Using the tools in the WebSphere Commerce Accelerator is most suited to creating prices for a very small catalog. Note that only the master price list can be modified this way.

• Create prices in an XML file, which can be loaded by the WebSphere Commerce loading utilities, or as a part of a store archive, which can be published through the Publish wizard. This method is more suitable for creating large amounts of data. You can import this data to any existing price list. You may also create a new price list, but it is up to the you to associate that new price list appropriately (through contract Terms and Conditions).

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

1. Create an XML file that follows the offering.dtd. The DTD files are located in the following directory:

   • WC_installdir/xml/sar/

   • WCDE_installdir/xml/sar/

2. Use 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. Use the following example as your guide, create an offer for a catalog entry by adding information to the
   OFFER table. Note that 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;"
   />
   

4. Use 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 have created catalog entries before you can create prices.

   <offerprice
   offer_id="@offer_product_id_furniture_loungechair_1"
   currency="USD"
   price="449.99"
   />
   

   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 use a conversion, allowing the customer to display different rates based on the currency they select.

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

Related concepts

• Pricing assets

• Contract and account assets

Related tasks

• Add a price to a prebuilt kit

• Add a price to a product

• Add a price to a SKU

Related reference

• Pricing data model

• Database asset groups dependencies