Introduced in Feature Pack 3

Extracting prices from price rules to the EPCMF file

If your store uses price rules to set catalog entry prices, you can customize the data extraction utility to extract price rule prices. By default, the data extraction utility uses the access profile IBM_Admin_DataExtract, which extracts prices directly from the OFFERPRICE table. To extract price rule prices instead, you can switch to a different access profile provided with the utility, IBM_Admin_DataExtract_with_PriceRule.

Procedure

  1. Open your business object configuration file for EPCMF data at the following path:
    • WebSphere Commerce DeveloperWCDE_installdir/samples/DataExtract/Catalog/CatalogEntry/wc-dataextract-catalog-entry.xml
    • WebSphere Commerce EnterpriseWebSphere Commerce - ExpressWebSphere Commerce ProfessionalWC_installdir/samples/DataExtract/Catalog/CatalogEntry/wc-dataextract-catalog-entry.xml
  2. Specify the access profile that extracts price rule prices:
    1. Locate the following line of code, which specifies the default access profile that the utility uses:
      <_config:property name = "accessProfile" value = "IBM_Admin_DataExtract"/>
    2. Replace the value IBM_Admin_DataExtract with the name of the access profile that extracts price rule prices, IBM_Admin_DataExtract_with_PriceRule.

      The revised line of code should look like this:

      <_config:property name="accessProfile" value="IBM_Admin_DataExtract_with_PriceRule"/>
  3. Save and close the file.
  4. Test your customization by running the data extraction utility for IBM Product Recommendations, formerly known as Coremetrics Intelligent Offer. View the EPCMF file that contains price rule prices. For more information, see Running the IBM Product Recommendations data extraction utility.