VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: nexus.006 on December 18, 2016, 13:16:44 PM

Title: Copy Shoppers to another site!
Post by: nexus.006 on December 18, 2016, 13:16:44 PM
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
Title: Re: Copy Shoppers to another site!
Post by: GJC Web Design on December 18, 2016, 13:28:05 PM
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
Title: Re: Copy Shoppers to another site!
Post by: nexus.006 on December 18, 2016, 13:34:37 PM
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!
Title: Re: Copy Shoppers to another site!
Post by: GJC Web Design on December 18, 2016, 13:37:15 PM
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
Title: Re: Copy Shoppers to another site!
Post by: nexus.006 on December 18, 2016, 13:44:16 PM
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 :)
Title: Re: Copy Shoppers to another site!
Post by: GJC Web Design on December 18, 2016, 17:04:46 PM
needs careful checking and debugging..  a sometimes/sometimes not problem isn't likely to be configuration
Title: Re: Copy Shoppers to another site!
Post by: nexus.006 on December 19, 2016, 16:47:28 PM
ok, thank you !