Oracle ATG Web Commerce includes a tool that can be used to convert your existing product catalog without price lists so that it can use price lists.
The PriceListMigration component first creates two price lists: one for the list price, and the other for the sales price. For each SKU in the product catalog, the PriceListMigration component creates a price that points to the list price list and sets its list price as the SKU’s list price. If the onSale property for the SKU is true, it creates another price that points to the sales price list and set its list price as the SKU’s salePrice.
To use the PriceListMigration component:
Run the price list SQL script against your catalog database. This script can be found at:
<ATG10dir>/DCS/sql/db_components/dbvendor/priceLists_ddl.sqlStart the
/atg/commerce/pricing/priceLists/PriceListMigrationcomponent.Open the component editor for the
PriceListMigrationcomponent. Invoke therunMigrationmethod from the methods tab in the component editor.
