Integrating Community Builder user addresses

We use Community Builder and have about 300 registered users. HikaShop works perfectly but one issue is that users have to enter their addresses when they shop the first time.

Given that Community Builder already stores a user's physical address as well as their billing address (we have CB Subs installed) is there a way that either or both of these addresses can be imported or used automatically rather than requiring the user to once-again enter it?

Thanks

Cliff

Hello, I'm looking at this also - looking at a full integration of database information from a community /membership 'thing' with an e-commerce 'thing'. So at the moment I'm exploring the trio of Joomla iteslf, with Comunity Builder and HikaShop - but will they do the job properly as an integrated system?
What is your experience? and are you planning to expand the inter-ability with, say, Community Builder? Or perhaps Joomla 1.6 has improved things regarding customer databases??
I'm wanting to rebuild our website www.sightlines-initiative.com
Thanks, Robni Duckett

Thanks Nicolas - what details Are synchronised, if the addresses can't be?

Nicolas

I think you may be missing the point here, and its not a big thing to create at least ONE billing address when a user is created in CB. Here's the problem - we have a PAID membership website and a user can only purchase something in the shop once they have subscribed and paid to a membership plan through community builder. They will NEVER first go to Hikashop.

We use CB SUbs as well and CB subs has this clever little thing that once a user registers, you can map registration fields to CB Subs fields, so what we do is that we map field 'Address' to cb_subs_billing_address_1", and so on..

It would be very easy for you to add a small routine to transfer the CB Subs address to the #__hikashop_address table as you already do with the CB and Joomla users. ALL the fields already exist in #__comprofiler so it's a piece of cake!

As we have just started setting up the shop, this evening, I did a simple SQL query and extracted all the #__comprofiler fields using this query:

SELECT b.user_id, b.firstname, b.lastname, b.address, b.city, b.state, b.zipcode, b.country, b.phone, b.cb_cellphone, d.user_id, d.user_cms_id 	
FROM #__users a, #__comprofiler b, #__cbsubs_subscriptions c, #__hikashop_user d
WHERE a.id=b.id
AND b.id=c.user_id
AND c.user_id=d.user_cms_id
AND c.status='A'
AND c.parent_plan=0
AND b.lastname<>'Administrator'
ORDER BY b.user_id

INSERT INTO `jos_hikashop_address` (`address_id`, `address_user_id`, `address_title`, `address_firstname`, `address_middle_name`, `address_lastname`, `address_company`, `address_street`, `address_post_code`, `address_city`, `address_telephone`, `address_telephone2`, `address_fax`, `address_state`, `address_country`, `address_published`, `address_vat`) VALUES
(1, 276, 'Mr', 'Test Name', NULL, 'Test Surname', NULL, '12 Any Avenue', 'SW11 1XW', 'City', '00044567890', NULL, NULL, 'state_Surrey_4220', 'country_United_Kingdom_222', 1, NULL),
(2,275, '', 'Another Name', NULL, 'Simpson', NULL, 'Address here','KTXX XXX','Unknown', '00223457687', '0777777689', NULL, 'state_Surrey_4220', 'country_United_Kingdom_222', 1, NULL),
(3,274, '', 'Mary', NULL, 'Last Name', NULL, '12 Amazing Road','SW16 4QR','Reigate', '01348 09765', '08633346587', NULL, 'state_Surrey_4220', 'country_United_Kingdom_222', 1, NULL);

So... after 5 years, has this progressed? Are the addresses coordinated as yet?

Thanks,

Dave

Would also love to have this sync capability

+1 for this feature.

Also +1 for me

With the popularity of Community Builder, I would suggest that Hikashop develop an integration of the user database with the Hika user registration process for purchases and event registrations. I've been using Community Builder for about 10 years and it helps me manage my websites in so many ways. I would like to avoid duplicate registrations. I've downloaded the CB plugin and will see how much I can use that to try to simplify my customers shopping experience using Hika...thanks, Tim