- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
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
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
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 √
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
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 √
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
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 √
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Issue in product price update
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"
}
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
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.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!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
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 √
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
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 √
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Issue in product price update
@Jyoti_Sinha I have only one RatePlan with only one recurring charge.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
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 √
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Issue in product price update
@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 |