Develop > Persistence layer > Data assets

Create pricing assets

There are three main methods to create pricing assets.

To create 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 can also create a new price list. You need to associate the new price list 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:

Procedure

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

   • WC_INSTALL/xml/sar/

   • workspace_dir/wc/xml/sar/

2. Use the following example as the guide, create a trading position container in the 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. Use the following example as the 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;"
   />
   

5. Use the following example as the guide, create an offer price 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"
   />
   

   To display multiple currencies in the 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 the catalog.

Related concepts

Price 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

Price data model

Database asset groups dependencies

+

Search Tips   |   Advanced Search