News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Export shoppers

Started by pm4698, June 09, 2014, 11:21:30 AM

Previous topic - Next topic

pm4698

Hello there,

If i go to my database i see 2 tables:

prefix_virtuemart_userinfos and prefix_virtuemart_vmusers.

All i need to do is export all shoppers with all their details (name,lastname,address,e-mail etc).

If i go into those 2 tables i cannot see e-mail stored in it.

An idea is to export this table and also export prefix_users table and somehow join those, but i don't know if its the right way or if i can do something different.

Thank you in advance

GJC Web Design

email is in the Joomla users table - the vm users are linked to Jusers - so u need to join that table as well
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation