TDBilling Posted August 7, 2016 Report Share Posted August 7, 2016 I am trying to remove a monthly price from a package and only have annual. I have no clients on the monthly price any longer but it is telling me I cannot modify the price: The term could not be removed because it is used by one or more services. Any ideas? Quote Link to comment Share on other sites More sharing options...
0 Michael Posted August 7, 2016 Report Share Posted August 7, 2016 It's because it's on a cancelled service. You'd have to restrict that package and copy it removing the old price. Quote Link to comment Share on other sites More sharing options...
0 TDBilling Posted August 7, 2016 Author Report Share Posted August 7, 2016 Any way to just do it in the database to remove that price only and keep the annual? Quote Link to comment Share on other sites More sharing options...
0 Michael Posted August 7, 2016 Report Share Posted August 7, 2016 39 minutes ago, TDBilling said: Any way to just do it in the database to remove that price only and keep the annual? Not that I'm aware of, Paul will know more, he will be online tomorrow. Quote Link to comment Share on other sites More sharing options...
0 Blesta Addons Posted August 7, 2016 Report Share Posted August 7, 2016 a soft delete of pricing is a must have now, we have the same probleme in so many packages . we are sure the term price is not used anywhere . when we have imported from v2.5 , some package has a lot of term price doubled 10 times or more, and we can't delete it from admin UI , an we can't restrict package as it used in so many plans . no time for me to enter database & delete about 100 lines .all of them are 1 term with price 0 . i remember a task for this already exist . i hope it done in v 4 . Michael 1 Quote Link to comment Share on other sites More sharing options...
0 Michael Posted August 7, 2016 Report Share Posted August 7, 2016 There is a soft delete pricing in 4.0: CORE-1041 but I'm not sure how to do it safely without breaking something. Quote Link to comment Share on other sites More sharing options...
0 Blesta Addons Posted August 7, 2016 Report Share Posted August 7, 2016 maybe i have a unique situation . i have a package normally with 3 term or 1 term , and the doubled term is 0$ term , and i'm sure only one term is used , but i don't know why is not the other term cna't be deleted , they was added when we have imported the database fromv2.5 . Quote Link to comment Share on other sites More sharing options...
0 Paul Posted August 8, 2016 Report Share Posted August 8, 2016 Pricing that is in use can't be deleted because it will cause problems. Najahost mentioned a soft delete for pricing, this is planned as part of CORE-1041 It's not likely it will be in 4.0 at this point, but it's a high priority item for me. Michael 1 Quote Link to comment Share on other sites More sharing options...
0 Paul Posted August 8, 2016 Report Share Posted August 8, 2016 Oh just to add.. for imported packages, from 2.5 or in cases where you need to delete pricing that's in use.. I suggest marking the package as inactive or restricted and adding a new package instead. Until CORE-1041 is resolved anyway. Michael 1 Quote Link to comment Share on other sites More sharing options...
0 Blesta Addons Posted August 8, 2016 Report Share Posted August 8, 2016 6 hours ago, Paul said: Oh just to add.. for imported packages, from 2.5 or in cases where you need to delete pricing that's in use.. I suggest marking the package as inactive or restricted and adding a new package instead. Until CORE-1041 is resolved anyway. as mentioned above , for some package we can't put them in inactive or restricted . my question is why some terms are not in use and we can't delete them ? like my screenshot , i have tried to delete one by one but always the same error . Quote Link to comment Share on other sites More sharing options...
0 Paul Posted August 8, 2016 Report Share Posted August 8, 2016 3 hours ago, naja7host said: as mentioned above , for some package we can't put them in inactive or restricted . my question is why some terms are not in use and we can't delete them ? like my screenshot , i have tried to delete one by one but always the same error . Are you certain they are not in use? By "in use" I mean any service is using the pricing id, regardless of the status of the service (Active, pending, cancelled, etc). Michael 1 Quote Link to comment Share on other sites More sharing options...
0 Blesta Addons Posted August 8, 2016 Report Share Posted August 8, 2016 Yes totally certain they are not in use . only 1 term line is used . They are created from the import proccess . Quote Link to comment Share on other sites More sharing options...
0 TDBilling Posted August 8, 2016 Author Report Share Posted August 8, 2016 Mine is 100% not in use. I imported over from WHMCS and the monthly cost is not in use at all. I have switched the plan that was on it to a custom restricted package. I need to keep the annual fee for my silver package but not the monthly. Just need a way to delete the monthly fee. Quote Link to comment Share on other sites More sharing options...
0 Blesta Addons Posted August 8, 2016 Report Share Posted August 8, 2016 3 hours ago, TDBilling said: Mine is 100% not in use. I imported over from WHMCS and the monthly cost is not in use at all. I have switched the plan that was on it to a custom restricted package. I need to keep the annual fee for my silver package but not the monthly. Just need a way to delete the monthly fee. so i'm not lonely here . Quote Link to comment Share on other sites More sharing options...
0 Paul Posted August 8, 2016 Report Share Posted August 8, 2016 I'm not able to duplicate that. I was able to remove a pricing item from a package that was not in use without error. Quote Link to comment Share on other sites More sharing options...
0 Blesta Addons Posted August 8, 2016 Report Share Posted August 8, 2016 when i get time i will make a further investigation in this . what i can imagine is the services are canceled for all the unused pricing maybe , but not sur . Quote Link to comment Share on other sites More sharing options...
0 Paul Posted August 10, 2016 Report Share Posted August 10, 2016 On 8/8/2016 at 4:20 PM, naja7host said: when i get time i will make a further investigation in this . what i can imagine is the services are canceled for all the unused pricing maybe , but not sur . That is likely the case. Even cancelled services that use the pricing_id will cause it not to be deleted. It could cause issues when queries try to look up the pricing for a cancelled service. This is why the soft delete is necessary, to remove it from view and ability to order, but still maintain the link. Quote Link to comment Share on other sites More sharing options...
Question
TDBilling
I am trying to remove a monthly price from a package and only have annual. I have no clients on the monthly price any longer but it is telling me I cannot modify the price:
The term could not be removed because it is used by one or more services.
Any ideas?
Link to comment
Share on other sites
16 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.