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

 

VirtueMart Shopping Cart

VirtueMart
Your Cart is currently empty.

Newsletter


Newsflash

Virtuemart Quotation Component

VMQuote , the online Quotation / Invoice system assists the virtuemart shop in preparation, issue, and tracking of customer quotations.
VMQuote ?allows users to quickly and accurately prepare a customer quotation by accessing the products in virtuemart store. with the powerful component, you can create any quotations for any customers, even for unregister customers, it will create a new account for them when you finish creating the quotation, and email the customers the account and quotation with pdf format document. After the new customer login in your website and ?accept the quotation, it will create a new order automatically and wait for customer finishing the payment.
It also provide the invoice function, you can generate ?the invoice of pdf format at the backend, if? you want to track the quotations and analysis the statistic, you can export all kind of tables about quotation,invoices,unpaid order.
It is a Stardand joomla component for virtuemart, so don’t worry about the edition of your virtuemart, the installation is absolutely simple, the usage is absolutely easy.

Feature Summary

  • Integrate with all VM products listed on website.
  • Auto create new customer (registration) if not existing customer ( included login details in email with quotation)
  • Quotation – Send to customer in HTML email? with attached PDF
  • Quotation – Customer are able to accept or reject quotation in the frontend
  • Quotation –? If accepted auto generate purchase order , If rejected ask why
  • Export data to CSV
  • Statements with line item invoices marked paid or unpaid
  • help Service —Help clients use this tool correctly at first time