
Running the list price migration utility
By running the list price migration utility, you migrate your existing list price data from the LISTPRICE table to different database tables (OFFER, OFFERPRICE, and OFFERDESC). The migration utility uses the Data Load utility to perform the migration.
Before you begin
- Complete all tasks leading up to this task in Task flow: Setting up an existing store to use Management Center price rules and price lists.
- Ensure you have reviewed and understood the information in Deciding whether to migrate list price data.
About this task
- Single stores (stores that are not extended site stores)
- Extended sites – complete this task on the following stores:
- Storefront asset store
- Catalog asset store
- Each extended site store
The list price migration utility is a script that loads a data load configuration file to perform the migration. A sample data load configuration file (wc-listprice.xml) containing the correct settings for this list price migration is provided.

This supplied data load configuration file points to two other standard data load configuration files that must be present on your machine before running the migration utility:
- Data Load utility environment settings file (wc-dataload-env.xml)
- Data Load utility business object configuration file (wc-loader-offer.xml)
Procedure
-
Copy the sample data load configuration file (wc-listprice.xml) to the
correct location for the list price migration utility:
Copy this file To this location For the HCL Commerce development environment, you must download the wc-listprice.xml file from the following link:
For an HCL Commerce server, the file installs at this path:
WC_installdir/components/management-center/samples/DataLoad/Price/MigrateListPrice/wc-listprice.xml
WCDE_installdir/samples/DataLoad/Price/MigrateListPrice/
WC_installdir/samples/DataLoad/Price/MigrateListPrice/
-
Make sure your existing data load configuration files are set up appropriately for the store
you are migrating:
Ensure that you run the list price migration utility as the appropriate user:
su - wasuser_ID where: wasuser_ID is the non-root user ID created before installing HCL Commerce. The default WebSphere Application Server user name is wasuser.
-
Check the logging configuration in the data load logging file and make any necessary
changes:
WCDE_installdir/workspace_dir/WC/xml/config/dataload/logging.properties
workspace_dir/WC/xml/config/dataload/logging.properties
The following settings in this file are relevant to this migration utility:
Setting Description Logging level Specify either: - level=INFO
- This is the typical level to use while running the utility. This level also lists all SQL statements you can use to roll back the migration.
- level=FINE
- This level lists all details as the utility runs. Use this level if you encounter errors or exceptions during the migration and you need additional information for troubleshooting.
Log file location java.util.logging.FileHandler.pattern=../logs/wc-dataload.log
The Data Load utility provides some command line options to change the trace level. For more information, see the Data Load utility.
An error log file is generated for the migration, if there are any errors. The error log file is located in the same directory as the wc-dataload.log file.
- Open a command prompt window.
-
Run the list price migration utility with arguments specifying the build file and the store
ID.
-
Review the log file to understand the results of the migration.
The location of the log file is configured in the logging.properties file; for more information, see step 4.
-
At this point in the task flow, you should be able to view the applicable price lists and price
rules that the migration utility has created in Management Center. To perform this check:
- Close Management Center.