HCL Commerce Version 9.1.12.0 or later

Apply the Near Real Time (NRT) index to Profit Margin Customization

This section of the tutorial describes the steps required to apply the Near Real Time (NRT) index for Profit Margin Customization.

Before you begin

Apply the Profit Margin customization to your environment. For more information, refer to Indexing profit margin data using the Catalog Asset Model.

Procedure

  1. Right click the custom.cas-_Template-DatabaseETL-CAS process group and select Copy.
  2. Paste to a blank space beside auth.product.cas - Send Product to Elasticsearch.
  3. Insert this new process group between Price Stage 1b (Find Bundle Prices) and Send Product to Elasticsearch, as the following example:

    Right click on the _Template-DatabaseETL-CAS process group and select Enable all controller services.

    Right click on the _Template- DatabaseETL-CAS process group and select Start to start the process group.

  4. Test the NRT index to ensure that the profit margin customization is successful..
    1. Select a product whose Profit Margin must be updated.

    2. Open the product and note down the product code.

    3. Open the Catalogs tool in the CMC and search for the product code noted earlier.

    4. Open the product and go to the Pricing section.
    5. Update the List price and Offer price and click Save. For example, here the prices are updated from $35.00 to $70.00.

    6. Open the costprice_data file downloaded previously and note down the cost price of the product. In this example, the cost price is $3.5.
    7. Calculate the updated profit margin as follows:

      For example in this product:

      Offer price = $70

      Cost price = $3.5

      Hence, the updated profit margin is given by the formula,

      Profit margin (%) = (Offer price - Cost price) / Offer price * 100

      = (70 – 3.5) / 70 * 100

      = 95

    8. Validate the updated Profit Margin at the ESpot in the store preview.

Results

You have verified that your customization is successful.