Issue in product price update

[irachamreddy]

I am trying to update product price using the API https://rest.apisandbox.zuora.com/v1/action/update

{
"type": "ProductRatePlanChargeTier",
"objects": [{
"price": 351.00,
"Id":"2c92c0f95ad9c24d015addf33b090b12"
}]
}

Price is getting updated to 0. Is there anything wrong with the approach that I am following?

Thank You!

Regards,

Indira.R

[Viktor]

Hi @irachamreddy could you send me the results of a GET ProductRatePlanChargeTier call please, using the mentioned ID in question?

https://rest.apisandbox.zuora.com/v1/object/product-rate-plan-charge-tier/{ID_HERE}

More information on:

https://www.zuora.com/developer/api-reference/#operation/Object_GETProductRatePlanChargeTier

Thanks!

[Jyoti_Sinha]

Hi Indira,

I tried to follow the same steps and and could replicate the sceanrio, I will check further details on same and keep you updated.

[irachamreddy]

@Viktor 

Here is below:

{
"ProductRatePlanChargeId": "2c92c0f95ad9c24d015addf33b090b11",
"Id": "2c92c0f95ad9c24d015addf33b090b12",
"CreatedById": "2c92c0f85ab26970015ac8347f106b00",
"CreatedDate": "2017-03-17T13:26:29.000-07:00",
"UpdatedDate": "2017-03-24T07:26:41.000-07:00",
"StartingUnit": 0,
"Currency": "USD",
"EndingUnit": 0,
"PriceFormat": "Flat Fee",
"Price": 399,
"Tier": 1,
"UpdatedById": "2c92c0955ab279d4015ac81e574e1908"
}

[irachamreddy]

@Jyoti_Sinha @Viktor To give you some more information, I just did export of RatePlanChargeTier data source based on product name. The result of the same is below,

ProductRatePlanChargeTier.Id	ProductRatePlanChargeTier.Price
2c92c0f95ad9c24d015addf33b090b13	0
2c92c0f95ad9c24d015addf33b090b14	0
2c92c0f95ad9c24d015addf33b090b15	0
2c92c0f95ad9c24d015addf33b090b16	0
2c92c0f95ad9c24d015addf33b090b12	399

I would like to understand why there are other columans with 0 price?

Thank You!

[Jyoti_Sinha]

Hi Indira,

Do you have 5 tiers in the product rate plan charge defined, hence you can see 5 IDs and prices.

Also, regarding the product price update issue, I will raise an internal ticket and keep you posted on same.

[Jyoti_Sinha · Accepted solution]

Hi Indira,

The reason reported call is updating the Price for ProductRatePlanChargeTier to 0 is because you are using 'price' instead or 'Price'.

Could you please use below call and let me know if this works for you.

{
"type": "ProductRatePlanChargeTier",
"objects": [{
"Price": 351.00,
"Id":"2c92c0f95ad9c24d015addf33b090b12"
}]
}

[irachamreddy]

@Jyoti_Sinha I have only one RatePlan with only one recurring charge.

[Jyoti_Sinha]

Hi Indira,

Just wanted to check if you were able to update product price with the changes you referred.

Also, please private message me your tenantID so that I can have a look at the RatePlanChargeTier data you are referring to.

[irachamreddy]

@Jyoti_Sinha Sorry for the late reply. Price update worked Thank you for that.

My question on RatePlanChargeTier still exists and it is confusing me a lot.

I have created a Product with only one RatePlan.

I have executed the following queries to get the price.

Procedure-1: POST https://rest.apisandbox.zuora.com/v1/action/query

==========

ProductId - {"queryString":"SELECT id from Product where name='xxxxxx'"}

ProductRatePlanId - {"queryString":"SELECT id from ProductRatePlan where ProductId='xxxxxx'"}

ProductRatePlanChargeId - {"queryString":"SELECT id from ProductRatePlanCharge where ProductRatePlanId='xxxxxx'"}

ProductRatePlanChargeTierId - {"queryString":"SELECT id from ProductRatePlanChargeTier where ProductRatePlanChargeId='xxxxxx'"} 

          -- Here I have got only one Id in the response

Update the price:

{
"type": "ProductRatePlanChargeTier",
"objects": [{
"Price": 351.00,
"Id":"2c92c0f95ad9c24d015addf33b090b12"
}]
}

Procedure-2: 

==========

Tried to get the ProductRatePlanChargeId using Datasource by using Product name as a query filter. I am attaching the export result file here. Wonder why I have 5 rows.

Product Rate Plan Charge Tier: ID

Product Rate Plan Charge Tier: Price

Product Rate Plan Charge Tier: Starting Unit

Product Rate Plan Charge Tier: Tier

Product: ID

Product: Name

Product Rate Plan: ID

Product Rate Plan: Name

Product Rate Plan Charge: Bill Cycle Day

Product Rate Plan Charge: Bill Cycle Type

Product Rate Plan Charge: Billing Period

Product Rate Plan Charge: Billing Period Alignment

Product Rate Plan Charge: Billing Timing

Product Rate Plan Charge: Charge Model

Product Rate Plan Charge: Charge Type

Product Rate Plan Charge: ID

Product Rate Plan Charge: List Price Base

Product Rate Plan Charge: Name

Product Rate Plan Charge: Number Of Period

Product Rate Plan Charge: Revenue Recognition Trigger

Product Rate Plan Charge: Tax Code

Product Rate Plan Charge: Tax Mode

Product Rate Plan Charge: Taxable

Product Rate Plan Charge: Trigger Event

2c92c0f85b4237e6015b441427d250af

270

1

2c92c0f95b424512015b4411c1c24812

KIA Care Plus

2c92c0f85b4237e6015b4412762a4a7f

Annual Plan

subscription start day

Two Years

Align to Subscription Start

In Advance

Per Unit Pricing

Recurring

2c92c0f85b4237e6015b441427d150ae

Billing Period

2 Year Charge

Z-Tax Code

Tax Exclusive

TRUE

Upon Service Activation

2c92c0f85b4237e6015b441427d250b0

0

1

2c92c0f95b424512015b4411c1c24812

KIA Care Plus

2c92c0f85b4237e6015b4412762a4a7f

Annual Plan

subscription start day

Two Years

Align to Subscription Start

In Advance

Per Unit Pricing

Recurring

2c92c0f85b4237e6015b441427d150ae

Billing Period

2 Year Charge

Z-Tax Code

Tax Exclusive

TRUE

Upon Service Activation

2c92c0f85b4237e6015b441427d250b1

0

1

2c92c0f95b424512015b4411c1c24812

KIA Care Plus

2c92c0f85b4237e6015b4412762a4a7f

Annual Plan

subscription start day

Two Years

Align to Subscription Start

In Advance

Per Unit Pricing

Recurring

2c92c0f85b4237e6015b441427d150ae

Billing Period

2 Year Charge

Z-Tax Code

Tax Exclusive

TRUE

Upon Service Activation

2c92c0f85b4237e6015b441427d250b2

0

1

2c92c0f95b424512015b4411c1c24812

KIA Care Plus

2c92c0f85b4237e6015b4412762a4a7f

Annual Plan

subscription start day

Two Years

Align to Subscription Start

In Advance

Per Unit Pricing

Recurring

2c92c0f85b4237e6015b441427d150ae

Billing Period

2 Year Charge

Z-Tax Code

Tax Exclusive

TRUE

Upon Service Activation

2c92c0f85b4237e6015b441427d250b3

0

1

2c92c0f95b424512015b4411c1c24812

KIA Care Plus

2c92c0f85b4237e6015b4412762a4a7f

Annual Plan

subscription start day

Two Years

Align to Subscription Start

In Advance

Per Unit Pricing

Recurring

2c92c0f85b4237e6015b441427d150ae

Billing Period

2 Year Charge

Z-Tax Code

Tax Exclusive

TRUE

Upon Service Activation