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:
Code:
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
I then simply placed that into Excel and created a sql query which created the #__hikashop_address table as follows:
EXAMPLE RECORD:
Code:
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);
ETC...
these are just random silly sample records but you get the gist..
You could include a simple "Create default address" as part of the same routine that you use to synchronise the Hikashop user table with that of Joomla/CB..
This will make life so much easier
Cheers
Cliff
