Import from VM2 - Missing user addresses

-- HikaShop version -- : 2.6.1
-- Joomla version -- : 3.4.8

Hi!

We have a VirtueMart2 webshop that we want to change to Hikashop. Import is worked almost perfectly the only problem I see currently that user address are not imported. Can anybody give me some advice how to solve that somehow?

Thanks in advance,
PePe

nicolas wrote: Hi,

Do you have something in the hikashop_address table after the import ?

nicolas wrote: What is the value of the address_published column for the entries there ?

nicolas wrote: Do you have the tables virtuemart_states and virtuemart_countries with all the data filled there ?

Hi all,
Sorry for my intrusion…
i think i have actually the same issue, i have all product imported as well the clients and commands but no details inside command, no address, nothing...just names and prices
J3 + Vm3

address_published : all
hikashop_address table : Empty

address_published value : 1

tables virtuemart_states and virtuemart_countries : YES

Thanks in advance

nicolas wrote: Hi,

After the line:
'WHERE vmui.virtuemart_user_id > '.$this->options->last_vm_user.' ORDER BY vmui.virtuemart_user_id ASC;';
in the file administrator/components/com_hikashop/helpers/import/vm2.php, add the line:
echo $sql1; exit;
Then, run the import again. That should display at one point the MySQL query that is run by the import system to import the addresses from VM to HikaShop.
Then, run the query in your database which PHPMyAdmin after replacing the #__ by the actual table prefix of your website.
That should provide an error message explaining why it didn't work.

INSERT IGNORE INTO `#__hikashop_address` (`address_user_id`,`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`) SELECT hku.user_id,vmui.first_name,vmui.middle_name,vmui.last_name,vmui.company,CONCAT(vmui.address_1,' ',vmui.address_2),vmui.zip,vmui.city,vmui.phone_1,vmui.phone_2,vmui.fax,vms.state_3_code,vmc.country_3_code,4 FROM `gomb_virtuemart_userinfos` AS vmui INNER JOIN `gomb_virtuemart_states` vms ON vmui.virtuemart_state_id = vms.virtuemart_state_id INNER JOIN `gomb_virtuemart_countries` vmc ON vmui.virtuemart_country_id = vmc.virtuemart_country_id INNER JOIN `#__hikashop_user` AS hku ON vmui.virtuemart_user_id = hku.user_cms_id WHERE vmui.virtuemart_user_id > 0 ORDER BY vmui.virtuemart_user_id ASC;

Hi,
i did it and it works on j3 + vm3 , but i have nothing add in my command adress.
So i restart import , i had the insert message ....
So i deleted all and i imported back still no adresse in command at all ...
Thanks

nicolas wrote: Hi,

Interesting. So at least the database structure didn't change but there is a problem with the VM data or the HikaShop user synchronization.

The import of addresses supposes that the users have already been synched.
Can you check the hikashop_user table. Do you see all your Joomla users in there ?

nicolas wrote: Also, could you do some screenshots of the table virtuemart_userinfos so that we could see all the columns for a few rows ?

Hi,

hikashop_user table /_users have them all almost 600 user on both table

Hi,
thank you very much for help ,

i tryed both method
modifcation :

"LEFT JOIN `".$this->vmprefix."virtuemart_states` vms ON vmui.virtuemart_state_id = vms.virtuemart_state_id ".
"LEFT JOIN `".$this->vmprefix."virtuemart_countries` vmc ON vmui.virtuemart_country_id = vmc.virtuemart_country_id ".

echo $sql1; exit;

Hi,
Thanks you very much Monsieur Nicolas for help and final solution
Best Regards

Yeah, there are 2 parts in the code where it has to be changed.
I've removed the earlier hikashop tables from the database and then reinstalled the component, also then imported from VM, and now it seems totally OK.

Thanks for your help!