Happy Business Starts Here

Highlighted

Issue in product price update

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

Tags (1)
12 REPLIES 12
Support SME

Re: Issue in product price update

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!



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

Zuora Support

Re: Issue in product price update

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.






If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

Re: Issue in product price update

@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"
}

Re: Issue in product price update

@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.IdProductRatePlanChargeTier.Price
2c92c0f95ad9c24d015addf33b090b130
2c92c0f95ad9c24d015addf33b090b140
2c92c0f95ad9c24d015addf33b090b150
2c92c0f95ad9c24d015addf33b090b160
2c92c0f95ad9c24d015addf33b090b12399

 

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

 

Thank You!

Zuora Support

Re: Issue in product price update

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.






If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

Zuora Support

Re: Issue in product price update

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"
}]
}






If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

Re: Issue in product price update

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

Zuora Support

Re: Issue in product price update

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.






If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

Re: Issue in product price update

@Jyoti_Sinha Sorry for the late reply. Price update worked Smiley Happy 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: IDProduct Rate Plan Charge Tier: PriceProduct Rate Plan Charge Tier: Starting UnitProduct Rate Plan Charge Tier: TierProduct: IDProduct: NameProduct Rate Plan: IDProduct Rate Plan: NameProduct Rate Plan Charge: Bill Cycle DayProduct Rate Plan Charge: Bill Cycle TypeProduct Rate Plan Charge: Billing PeriodProduct Rate Plan Charge: Billing Period AlignmentProduct Rate Plan Charge: Billing TimingProduct Rate Plan Charge: Charge ModelProduct Rate Plan Charge: Charge TypeProduct Rate Plan Charge: IDProduct Rate Plan Charge: List Price BaseProduct Rate Plan Charge: NameProduct Rate Plan Charge: Number Of PeriodProduct Rate Plan Charge: Revenue Recognition TriggerProduct Rate Plan Charge: Tax CodeProduct Rate Plan Charge: Tax ModeProduct Rate Plan Charge: TaxableProduct Rate Plan Charge: Trigger Event
2c92c0f85b4237e6015b441427d250af270 12c92c0f95b424512015b4411c1c24812KIA Care Plus2c92c0f85b4237e6015b4412762a4a7fAnnual Plan subscription start dayTwo YearsAlign to Subscription StartIn AdvancePer Unit PricingRecurring2c92c0f85b4237e6015b441427d150aeBilling Period2 Year Charge  Z-Tax CodeTax ExclusiveTRUEUpon Service Activation
2c92c0f85b4237e6015b441427d250b00 12c92c0f95b424512015b4411c1c24812KIA Care Plus2c92c0f85b4237e6015b4412762a4a7fAnnual Plan subscription start dayTwo YearsAlign to Subscription StartIn AdvancePer Unit PricingRecurring2c92c0f85b4237e6015b441427d150aeBilling Period2 Year Charge  Z-Tax CodeTax ExclusiveTRUEUpon Service Activation
2c92c0f85b4237e6015b441427d250b10 12c92c0f95b424512015b4411c1c24812KIA Care Plus2c92c0f85b4237e6015b4412762a4a7fAnnual Plan subscription start dayTwo YearsAlign to Subscription StartIn AdvancePer Unit PricingRecurring2c92c0f85b4237e6015b441427d150aeBilling Period2 Year Charge  Z-Tax CodeTax ExclusiveTRUEUpon Service Activation
2c92c0f85b4237e6015b441427d250b20 12c92c0f95b424512015b4411c1c24812KIA Care Plus2c92c0f85b4237e6015b4412762a4a7fAnnual Plan subscription start dayTwo YearsAlign to Subscription StartIn AdvancePer Unit PricingRecurring2c92c0f85b4237e6015b441427d150aeBilling Period2 Year Charge  Z-Tax CodeTax ExclusiveTRUEUpon Service Activation
2c92c0f85b4237e6015b441427d250b30 12c92c0f95b424512015b4411c1c24812KIA Care Plus2c92c0f85b4237e6015b4412762a4a7fAnnual Plan subscription start dayTwo YearsAlign to Subscription StartIn AdvancePer Unit PricingRecurring2c92c0f85b4237e6015b441427d150aeBilling Period2 Year Charge  Z-Tax CodeTax ExclusiveTRUEUpon Service Activation