Thread: Changing recurring order price

I am using 7.0.2.5 SP1 and I need to change the price of all recurring orders to 9.95 is there a simple SQL query I can use to do this?


Thanks

If what you mean is to bulk edit the price of all products which their IsRecurring field were set to yes/true, then this could be done by executing this query:

Code:

update ProductVariant set Price = 9.95 where IsRecurring = 1

But if it something like overriding the order record, as a PCI compliant software, we do not recommend such action esp. to captured one.

Sorry should have specified this is for people who have already purchased the recurring product. I have traced some of the code and I think i would change it in the Shoppingcart table. I just want to make sure this would do the trick.

Yep. That's where the recurring shipments were stored from, editing the price of the item there should do the trick, but you should be careful in doing that. Please have a full backup of the DB first before doing any change.