Hi all Im trying to track down whats best practice with subscriptions records to avoid the situation described below
Ive created a test user for our website and I originally assigned a free registration.
I then logged in as Test User and upgraded to a paid membership subscription
The system is keeping the original free subscription as well as the single membership subscription and causing in some cases people to get erroneous expiry/renewal
notices.
Its probably a simple solution but I cant seem to find it!
cheers
Swampy5
Tony Marsh GoGreen Computing
Attachments:
Last edit: 3 years 5 days ago by krileon. Reason: Added [SOLVED] tag to subject
In the screendump provided, the 2nd subscription has Status "R" which means registered and unpaid, while being ready to upgrade the 1st (replaces_subscription matches id of 1st), while 1st has status "A" means (still) active.
Looks to me like the upgrade wasn't paid, or got cancelled and/or refunded ?
Ok thanks Beat - yes the second subscription was unpaid and the subs status shows that with the R = Registered Unpaid code - I suspect Ive paid insufficient attention to those codes. When I marked it as paid the status of the first subscription changed to U - upgraded to other - and the second subscription to A - Active as you indicated.
Now Im wondering
1. how does CBSubs mailer respond to subs status codes
A = Active
R = Registered Unpaid
X = Expired
C = Unsubscribed
U = Upgraded to other
I = Invalid
2. Under what circumstances might the mailer get it wrong eg send out a reminder to a person with a subs status code of U for example and not to or as well as a subs status code of A for an upgraded subscription?
This example was obviously setup to explore this scenario - but it highlights that I need to capture the codes when this problem arises on the live site.
Your mailers can specifically check against a subscriptions status using the "Must be in state" parameter after selecting plans within "To which plans this date condition applies" assuming "Relative to this date" is relative to a subscription date. So for example if you only want it to send for the explicit expired status then set "Must be in state" to "Expired".
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.
Ok thanks for the explanation - the status codes make a lot more sense now - and I can adjust sql queries we have generated to return membership data we are really after now
cheers
Swampy5
beat
