Applying the Near Real Time (NRT) index to Profit Margin Customization with Java ETL

This tutorial section describes how to apply the Near Real Time (NRT) index for Profit Margin Customization with the Custom Java ETL process group.

Before you begin

Apply the Profit Margin customization to your environment. For more information, refer to Create the customization in NiFi.

Procedure

Right-click the custom - _Template-DatabaseETL process group and select Copy.
Paste to a blank space beside auth.product - Price Stage 1a (Find Product Prices).
Connect the Process groups in the following way.
The following screenshot shows how the custom - _Template-DatabaseETL is connected between auth.product - Price Stage 1a (Find Product Prices) and auth.product - Price Stage 1b (Find Bundle Prices) process groups.
Right click on the custom - _Template-DatabaseETL process group and select Enable all controller services
Right click on the custom - _Template-DatabaseETL process group and select Start to start the process group.
Test the NRT index to ensure the profit margin customization succeeded.
1. Select a product whose profit margin is to be updated.
2. Open the product and note down the product code.
3. Open the Catalogs tool in the Management Center and search for the product code noted earlier.
4. Open the product and navigate 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. 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.