Good day!
Some part numbers have related items under them used for free servicing. The dealers will purchase the parent part but submit a free service claim for the related part.
For example - P5J1W01M0 has 6 related part numbers, as in the snapshot below.
We want to automate the pricing update for the related items when the parent part's pricing is updated.
For example - The retail price is $3011.78 (for 200 litres), and the related items' retail prices are as below:
ENG01L1 1L - (3011.78/200) * 1 = 15.06
If the price changes to 3100, then the related items' RRP should automatically update to (3100/200) * 1 = 15.50
ENG01L42 4.2L - (3011.78/200) * 4.2 = 63.25
If the price changes to 3100, then the related items' RRP should automatically update to (3100/200) * 4.2 = 65.10
We have a custom field where the quantity is mentioned for the related parts.
Is there a way to automatically update the Wholesale and Suggested Retail price of the related items whenever the corresponding parent price values change?
Regards,
Ram