Skip to Content Skip to Menu

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

Group subscription plan with variable price

  • andrew432
  • andrew432
  • OFFLINE
  • Posts: 72
  • Thanks: 8
  • Karma: 2
10 years 11 months ago #236275 by andrew432
Replied by andrew432 on topic Group subscription plan with variable price
OK fine, strange that it has Show at Registration in the options, maybe this needs to be removed to avoid confusion.
Is it possible to use a form component instead, RSformPro for example for registration?

regards,
Andrew

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48473
  • Thanks: 8281
  • Karma: 1443
10 years 11 months ago #236285 by krileon
Replied by krileon on topic Group subscription plan with variable price
It can only show at registration if the query makes sense at registration. In your case the query will always return nothing so nothing will display. Only flat queries that don't depend on substitutions (unlike the query you need) will display something at registration. It's not possible to query information for a user that doesn't exist yet.

Is it possible to use a form component instead, RSformPro for example for registration?

No, we do not support any registration other than CBs.


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.

  • andrew432
  • andrew432
  • OFFLINE
  • Posts: 72
  • Thanks: 8
  • Karma: 2
10 years 11 months ago #236291 by andrew432
Replied by andrew432 on topic Group subscription plan with variable price
If they register first and then upgrade will it be possible?

regards,
Andrew

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48473
  • Thanks: 8281
  • Karma: 1443
10 years 11 months ago #236292 by krileon
Replied by krileon on topic Group subscription plan with variable price
Yes as the information will exist at that point (assuming you ask for member count at registration). Is there a reason you need to show the calculated member cost at registration? You can inform them the cost per member at registration then in the CBSubs basket it'll show them the exact cost.


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.

  • andrew432
  • andrew432
  • OFFLINE
  • Posts: 72
  • Thanks: 8
  • Karma: 2
10 years 11 months ago #236293 by andrew432
Replied by andrew432 on topic Group subscription plan with variable price
I guess as long as I display cost per member, and make the number of members a required field it will be OK.

I'll carry on in this way and try it.

regards,
Andrew

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

  • andrew432
  • andrew432
  • OFFLINE
  • Posts: 72
  • Thanks: 8
  • Karma: 2
10 years 11 months ago #236460 by andrew432
Replied by andrew432 on topic Group subscription plan with variable price
This is the query field, number of members is cb_pupils which is entered at registration, and multiplied by -5.99 to determine the negative promotion amount.
SELECT ( `cb_pupils` * -5.99 ) FROM `#__comprofiler` WHERE `id` = '[user_id]'

The plan is a 1 year subscription, the price is set as 0 in the plan, the promotion is set to run at registration, screen shots attached.

The membership plan is created for a year but no invoice or payment request is generated, is there something else I have missed? do I need to add an auto action?

regards,
Andrew
Attachments:

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

Moderators: beatnantkrileon
Powered by Kunena Forum