Copy Shoppers to another site!

[nexus.006]

Joomla! 3.6.4 + Virtuemart 3.0.18.

Hello Community,

I have 2 sites, with both the same versions of Joomla & Virtuemart. I would like to export my shoppers from one site and import to another. Is that possible by just exporting and importing the relevant SQL tables without using an external software like CSV? If yes, which tables should be ex/imported?

Thanks
Chris

[GJC Web Design]

are there already shoppers in the 2nd site?

If so you will need to do some adjustments to the userids so they don't clash

Then it is possible to just append or just replace depending on what your doing the Joomla user tables and the VM user tables and vm order tables if u want orders as well
Chk also shopper group stuff as well

[nexus.006]

Hi GJC Web Design,

thank you for your answer. The second site is a clean install with now shoppers and only the admin joomla account! So I think I shouldn't get any problems with ID's. In the "old" page I have some custom Shopper fields created - I created them in the backend of the "new"site with the same ID's! Shopper groups I only have "default", old orders I don't need!

[GJC Web Design]

then just make sure the superadmin id doesn't clash ( just delete or change it if it does)

and drop in all the j user and VM user tables,, the shopper fields should be picked up

[nexus.006]

have hooked up an Indian company which I found on "peopleperhour" with the problem.....result: shoppers are all there, some can login on the new site, some can't and the additional shopper fields that I created are shown in the checkout form, you can fill them in, but the information will not be send in the order/confirmation mail...  ANY IDEA

[GJC Web Design]

needs careful checking and debugging..  a sometimes/sometimes not problem isn't likely to be configuration

[nexus.006]

ok, thank you !