Home Virtuemart development How to Upload / import of customer details for Virtuemart?

VirtueMart Shopping Cart

VirtueMart
Your Cart is currently empty.

Newsletter

How to Upload / import of customer details for Virtuemart?

  I had to migrate users from old e-shop into VirtueMart. After short research on web I found tool for import Joomla users (userport, author: Parvus) but no one for VM.
After another research I found tables which must be filled, but also with main problem: How to generate "user_info_id", solved by this function:
md5( date_format( date_add( sysdate( ) , INTERVAL FLOOR( 1 + ( RAND( ) *998 ) ) MICROSECOND ) , "%Y%m%d%H%i%s%f" )

My “quickly prepared” solution use several steps and tools described below:
1) Joomla component – userport
2) MS Excel tool for user import from any user list source
3) MS Access query – for extract new user only (not assigned to VM shopper groups)
4) MS Excel tool for bulk MySQL query

Author:Palo

 
Copyright © 2017 JoomlaVM. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.

Joomla!® name is used under a limited license from Open Source Matters in the United States and other countries.

joomlavm.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.