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
11 years 21 hours ago #236191 by andrew432
I need to vary the price of a subscription plan during registration, the length of the plan remains fixed for 1 year.

The plan is for a group membership, and there's a fixed price per member, on the registration form I want them to enter the number of members, and multiply this by the price, the result becomes the price of the subscription.

Please tell me the best way to accomplish this.

regards,
Andrew

Joomla 2.5.14, standard SEF URL's with suffix
CB 1.9, Auto Actions, Groupjive
CB Subs 3.0.0

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48473
  • Thanks: 8281
  • Karma: 1443
11 years 14 hours ago #236226 by krileon
Replied by krileon on topic Group subscription plan with variable price
Only way to do this is to apply negative promotions using CBSubs Promotions. For example you can have 10 CBSubs Promotions that check if the field is equal to a certain value and have that increase the price. For example if the member field equals 1 apply a -20 promotion, which will increase the price by $20. If you want this to support an unlimited number of members you'll need to use a CB Query Field to calculate the cost per person then supply that to a CBSubs promotion as the value. Few of this exact usages have been posted already, please search for further details.


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
11 years 13 hours ago #236239 by andrew432
Replied by andrew432 on topic Group subscription plan with variable price
Thanks, I did see the other posts regarding this but I thought It was worth asking in case there was another way.

I've just installed the CB Query field plugin to try and calculate the price to display it for the person registering, I have a field called cb_members which the user types in, and a field called cb_price which is the CB Query field.

Please give me some idea of how to add this query, or a link to some documentation, or examples.

regards,
Andrew

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48473
  • Thanks: 8281
  • Karma: 1443
11 years 12 hours ago #236246 by krileon
Replied by krileon on topic Group subscription plan with variable price
The below query for example should multiply the member count by a static value.

Code:
SELECT ( `cb_members` * 20 ) FROM `#__comprofiler` WHERE `id` = '[user_id]'

This makes each member cost $20. Adjust the number as needed. You then should be able to substitute it in as the promotion amount using the below.

-[cb_queryfield]

Please understand this is all just an example. It is not tested and you will need to adjust field names as needed.


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
11 years 12 hours ago #236253 by andrew432
Replied by andrew432 on topic Group subscription plan with variable price
Thanks, I tried this but I can't make the CB query field display on the registration form, it's published and Show at Registration? is set to yes.

Is there something else I need to do?

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 #236273 by krileon
Replied by krileon on topic Group subscription plan with variable price
CB Query Field can't display on registration form. It has no edit display. It also can't display in profile edit. You only need it to calculate the cost for your CBSubs Promotions and it's not intended to be displayed.


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.

Moderators: beatnantkrileon
Powered by Kunena Forum