Preparing to integrate with Dynamic Pricing

Before you can integrate with Dynamic Pricing, you must update your WebSphere Commerce environment with the IBM Dynamic Pricing connector for IBM WebSphere Commerce V7 package.

Before you begin

Ensure that you have a working installation of WebSphere Commerce Developer Version 7.0 Feature Pack 8, with the latest maintenance applied. For more information, see Installing WebSphere Commerce Developer.
Stop your WebSphere Commerce test server.
Back up your development environment.
Download and extract the WCS7_DP.zip file from the IBM Dynamic Pricing connector for IBM WebSphere Commerce V7 V1.0 to a temporary directory on your WebSphere Commerce development environment.

About this task

Procedure

Update your database with the transport and command values.
1. Copy the SQL statements from the following file:
  
  local_temp\WCS7_DP\sql\DynamicPricingIntegrationSQL.txt
  
  Where:
  
  local_temp
  
  Is the temporary directory where you extracted the WC7_DP.zip package.
2. Connect to your development database.
3. Run the copied SQL statements against your database.
Update your WebSphere Commerce configuration file with the export and import connector configurations.
1. Copy all the contents from the following file:
  
  local_temp\WCS7_DP\xml\config\wc-server-dp.xml
  
  Where:
  
  local_temp
  
  Is the temporary directory where you extracted the WC7_DP.zip package.
2. Paste the contents inside the <outbound></outbound> section of the following file:
  
  WCDE_installdir\workspace\WC\xml\config\wc-server.xml
3. Save and close the file.
Update your Administration Console properties files with the properties for Dynamic Pricing SFTP Export and Dynamic Pricing SFTP import.
1. Open the following file, and copy all the contents:
  
  local_temp\WCS7_DP\resources\MsgMessagingNLS_en_US.properties
  
  Where:
  
  local_temp
  
  Is the temporary directory where you extracted the WC7_DP.zip package.
2. Paste the file contents at the bottom of the following properties files:
  - WCDE_installdir\wc.modules\workspace\WC\properties\com\ibm\commerce\tools\adminconsole\properties\MsgMessagingNLS_en_US.properties
  - WCDE_installdir\workspace\WC\properties\com\ibm\commerce\tools\adminconsole\properties\MsgMessagingNLS_en_US.properties
3. Save and close the files.
Update your com.ibm.commerce.price directory.
1. Copy all the contents from the following directory:
  
  local_temp\WCS7_DP\config\db_type\com.ibm.commerce.price
  
  Where:
  
  local_temp
  
  Is the temporary directory where you extracted the WC7_DP.zip package.
  
  db_type
  
  Is the type of database you are using.
2. Paste the contents into the following directory:
  
  WCDE_installdir\workspace\WC\xml\config\com.ibm.commerce.price
  
  Note: If com.ibm.commerce.price does not exist, create the directory.
Add the wcs7_dp.jar file to your WebSphere Commerce library.
1. Copy the wcs7_dp.jar file from the following directory:
  
  local_temp\WCS7_DP\jar
2. Paste the .jar file in the following directory:
  
  WCDE_installdir\workspace\WC\lib
Start your WebSphere Commerce test server

What to do next

After you configure your development environment, you can configure scheduled jobs to export pricing to the Dynamic Pricing service for real-time analysis. Business users can review the analysis and pricing recommendation that is provided by Dynamic Pricing, and then approve or reject the pricing. If pricing is approved, the updated product prices can be imported from Dynamic Pricing to WebSphere Commerce.

Note: If you want to enable this integration on your runtime environment, check the updated files into your source control repository, and then build and deploy the updated files. For more information, see WebSphere Commerce Build and Deployment tool.