Country display for members

Good morning guys,

We use hikashop as the initial user payment component for our site and then port the user's hikashop details (name, birthdate, address, etc) over to Community Builder for them to view, manage and modify later.

One of the data we capture is country via zones (countries) provided in a hikashop table called hikashop_zone:

We have studied the article here:

www.joomlapolis.com/support/tutorials/107-use-cases/18377-configuring-a-country-field-with-cb-query-field-plugin

But this is different as our source is the hikashop data table. How should we configure our community builder field to capture the hikashop data? Upon creation in hikashop we will use the following to move data to community builder comprofiler tablers:

if(!empty($addressData->address_country)){
$fields[]='cb_country';
$values[]=$this->database->Quote($addressData->address_country);

We would like members to be able to update their country data once created in community builder.

CB Query Field just outputs the results of a database query. It does not move the information from 1 table to the other or anything of the sort. It does not process PHP so no your PHP doesn't do anything in this case. The Query Select field types do not store their information anywhere outside of CB either (so it can't use hikashop to store its values); they only pull their dropdown options from the results of a query.

Ideally Hikashop should allow you to write an integration that sends the profile data to CBs tables, which CB would do the same for Hikashop using CB Auto Actions. The alternative is to use CB Auto Actions for both directions, but CB Auto Actions pulling Hikashop data will be limited (e.g. act on the after login trigger with a Code action to update the user object as needed).

If you only need this information to go from CB to Hikashop then a CB Auto Actions acting on the after registration and after profile update (both frontend and backend of each) with a Query action would work. You'd then just grab those CB fields and update their corresponding Hikashop database row.