Skip to Content Skip to Menu

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

CBSubs invoice not grabbing the country or state

  • krileon
  • krileon
  • ONLINE
  • Posts: 48466
  • Thanks: 8280
  • Karma: 1443
11 years 2 months ago - 11 years 2 months ago #233087 by krileon
It should be synchronizing fine and does in all my tests. Country and State often will not, because the value supplied often does not match what CBSubs is expecting. Using Chrome or Firebug for Firefox right click and inspect the dropdown and you'll see what values it expects. Currently the only way to match CBSubs value > label pairs is to use CB Query Field to build a select field from database values. However, next CB release will let you specify separate value > label pairs for select fields.

Please for future reference and other users sake do not resurrect year old topics. This topic is almost 2 years old. Please just create a new topic in situations like this and provide a link to the older topic in your new topic if you feel it is relevant.


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.
Last edit: 11 years 2 months ago by krileon.

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

  • dotcom22
  • dotcom22
  • OFFLINE
  • Posts: 522
  • Thanks: 14
  • Karma: 4
11 years 2 months ago - 11 years 2 months ago #233097 by dotcom22

Using Chrome or Firebug for Firefox right click and inspect the dropdown and you'll see what values it expects.


Yes I made already this and my User Country field contain the right value who is for example "US" for United States. No matter if the value is inside a text, select, or delimiter field because CBsubs is not able to fetch the value.


It should be synchronizing fine and does in all my tests.


You mean this work without problem for Country field at your side? For example if you mapped the country with a simple text field who contain always for all user the value "AL", CBsubs detect this as "Albania" and don't ask to choose the country in the select field?

Is not a big deal but is a bit frustrating because all fields are correctly mapped except this one. This add an annoying supplementary step for user during their first purchase. Is especially because users come from always the same country is frustrating. Ideally in my case, if I could set a default country or even deactivate this country field it will be better.



However, next CB release will let you specify separate value > label pairs for select fields.


Great news because right now, options for select and radio field are not enough flexible.


Please for future reference and other users sake do not resurrect year old topics. This topic is almost 2 years old. Please just create a new topic in situations like this and provide a link to the older topic in your new topic if you feel it is relevant.



Ok I will remember that. I re-opened this topic because I seen many people had same problem without a concrete solution.

I use Joomla 3.3.6 - CB 2.0.4 - CBSubs 4 - Several Incubator plugins
Last edit: 11 years 2 months ago by dotcom22.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48466
  • Thanks: 8280
  • Karma: 1443
11 years 2 months ago #233116 by krileon

Yes I made already this and my User Country field contain the right value who is for example "US" for United States. No matter if the value is inside a text, select, or delimiter field because CBsubs is not able to fetch the value.

I suppose you could try using a Field action in CB Auto Actions on the after registration trigger to force the fields values to CBSubs invoice fields using a Field action and see if it'll work then.

You mean this work without problem for Country field at your side? For example if you mapped the country with a simple text field who contain always for all user the value "AL", CBsubs detect this as "Albania" and don't ask to choose the country in the select field?

Have retested and can confirm country field is not synchronizing. We've a bug ticket in place already to investigate and fix this issue. Perhaps my above solution will working using CB Auto Actions to force the values to the database?

Is not a big deal but is a bit frustrating because all fields are correctly mapped except this one. This add an annoying supplementary step for user during their first purchase. Is especially because users come from always the same country is frustrating. Ideally in my case, if I could set a default country or even deactivate this country field it will be better.

You can disable the Invoice Address entirely if you like. If you don't actually need it and aren't using it then it doesn't really matter. In cases of PayPal it is especially pointless as all the billing information is directly in your PayPal account and also sent to CBSubs via the IPN. It's mostly useful for onsite purchases and Offline purchases.


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.

  • dotcom22
  • dotcom22
  • OFFLINE
  • Posts: 522
  • Thanks: 14
  • Karma: 4
11 years 1 month ago #233130 by dotcom22
So I tried to set a "Field Action" for the field "Invoice to: Country" with trigger onAfterUserRegistration + onAfterUserUpdate. I specified the country code such "US" or the country name such "United States" but this don't work and I always need to choose a country in select field.

I looked in database (table cbsubs_payments) and if I'm not wrong, the field "address_country_code" is the one who must contain in Cbsubs the country code. I suppose if this field was filled, the select country will not ask to choose a country. But it seem the field "Invoice to: Country" is related to Cbsubs field "address_country" and not "address_country_code".

??

I use Joomla 3.3.6 - CB 2.0.4 - CBSubs 4 - Several Incubator plugins

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48466
  • Thanks: 8280
  • Karma: 1443
11 years 1 month ago #233131 by krileon
I don't know. I have yet to investigate the issue. So I can't tell you specifically what it's doing wrong at this time. CBSubs is supposed to use the invoice fields within _comprofiler and push them to the payment basket when the basket is created, but the country field is not properly pulling a value and always resetting to default empty.


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.

  • dotcom22
  • dotcom22
  • OFFLINE
  • Posts: 522
  • Thanks: 14
  • Karma: 4
11 years 1 month ago #233134 by dotcom22
Ok nevermind... I hope you will be able later to look at this and maybe to publish a patch or just to indicate which file need to be modified and how.

Ideally if this can be solved before the next CBsubs or CB release this will be cool.

thank

I use Joomla 3.3.6 - CB 2.0.4 - CBSubs 4 - Several Incubator plugins

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

Moderators: beatnantkrileon
Powered by Kunena Forum