Skip to Content Skip to Menu

🎃 Happy Halloween! Treat yourself with an awesome discount on memberships! Get 20% off now with code SPOOKY-2024!

[SOLVED] Csubs mass update on expiration?

  • xtech86
  • xtech86
  • OFFLINE
  • Posts: 29
  • Thanks: 1
  • Karma: 0
10 years 10 months ago - 10 years 10 months ago #238265 by xtech86
Hi Guys,

What's the easiest way to update the memberships which expire on a set date?

It turns out I didn't read the start of calendar year formatting and therefore entered it as 01-11 rather than 11-01.

So I need to basically flip this so the expiration is later, I have updated it on the plan now.

If it's only one database table which needs selecting and updating I can do that easy enough, but not sure if you map it across a few.

Thanks
Tony
Last edit: 10 years 10 months ago by krileon.

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48475
  • Thanks: 8281
  • Karma: 1443
10 years 10 months ago #238293 by krileon
Replied by krileon on topic Csubs mass update on expiration?
If you're not using recurring subscriptions you can just do a database query on _subscriptions table to update everyones expiration date. If you're using recurring subscriptions you won't be able to without first cancelling their recurring profiles (done from your gateway account; e.g. PayPal) as the recurring payment will be billed at the date before the change.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

  • xtech86
  • xtech86
  • OFFLINE
  • Posts: 29
  • Thanks: 1
  • Karma: 0
10 years 10 months ago #238321 by xtech86
Replied by xtech86 on topic Csubs mass update on expiration?
Perfect thank you, they were not reoccuring.

Thanks
Tony

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum