JoomlaVM

  • Increase font size
  • Default font size
  • Decrease font size
Home Virtuemart development How to Upload / import of customer details for Virtuemart?

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

< Prev   Next >
 

Main Menu

VirtueMart Shopping Cart

VirtueMart
Your Cart is currently empty.

Newsletter


Newsflash

VMDL importing data instantly

(We just release a new version for Virtuemart 2.0 and Joomla 1.6/1.7 , Please check it here :VMDL for VM2.0 and Joomla 1.6/joomla 1.7)

Vmdl tool allows users to easily create virtuemart product item from data stored in excel and CSV files. When used with vmdl , the powerful functions and cutomer service that also allows for the creation of more complex structured product items,include all of attributes and product types,vmdl allows for the easy transfer of data from excel file into your virtuemart product catalogues, product listings, price listings, and more. With or without vmdl, products input is an essential time-saving tool for any Joomla and Virtuemart site. this new edtion is integrated into the VM backend,more convenient to use,less steps,adding check module,and more quick loading.

Feature Summary

  • Import format CSV file, regardless of size
  • auto-creates categories and auto-creating product item, then auto-loading product detail
  • Support remote host data loading,help you create data anywhere
  • help Service —Help clients use this tool and fill the excel file correctly at first time