Product Catalog To Use PriceLists
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:
1. list price,
2. 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.
How to use the PriceListMigration component:
1. Run the price list SQL script against your catalog database. This script can be found at:
C:/ATG/ATG10.1.2/DCS/sql/db_components/dbvendor/priceLists_ddl.sql
2. Start the /atg/commerce/pricing/priceLists/PriceListMigration component.
3. Open the component editor for the PriceListMigration component. Invoke the runMigration method from the methods tab in the component editor.
Note:
The ATG Control Center allows users to create, edit, and delete price lists. When a user attempts to view or edit a price list, the security system checks the security information associated with the object and grants or denies access based on the information.
For example, if a user does not have write access to a particular item, then the ACC will display the item in gray characters. Additionally, certain objects might not be visible to certain users.
Based on these criteria's we need to follow on when doing PriceListMigration, so that security policies cannot be overridden.
