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.sql
Start the
/atg/commerce/pricing/priceLists/PriceListMigration
component.Open the component editor for the
PriceListMigration
component. Invoke therunMigration
method from the methods tab in the component editor.