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

Copying orders to new site

Started by ukfish1, December 12, 2017, 19:33:11 PM

Previous topic - Next topic

ukfish1

VM: 3.2.6
Joomla: 3.8.2

I have created a new version of a joomla site using VM at a test domain and need to copy it back to the live domain. Before I do so, I need to copy across the orders to the test domain. Is there an easy way to do this?

Thanks, Paul

GJC Web Design

if similar/same versions just drop the VM order and user tables into it from the live..  and Joomla user tables if new registrations

then run the table updater to make sure all OK
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

ukfish1

thanks

I have copied across the following tables:

virtuemart_orders.sql
virtuemart_order_histories.sql
virtuemart_order_items.sql
virtuemart_order_userinfos.sql
virtuemart_usertinfos.sql

Although after importing each sql, i did get a message saying "Import has been successfully finished, 16 queries executed. (bsc_virtuemart_userinfos.sql)", I also got an error saying "#1050 - Table 'bsc_virtuemart_userinfos' already exists"

I also updated the DB tables in VM.

The orders in the backend of the website have not been updated.

Is there something I missed?

Paul




Studio 42

Only import datas, not tables, your sql try to create the tables.

ukfish1

sorry if this is stupid question but how do I export just the data rather than the full tables?

Thanks, Paul

Studio 42

in phpmyadmin, on export, you can select advanced and only datas else you remove the create table query from your .sql file

GJC Web Design

you also need to empty the table b4 importing -- or delete/rename and recreate
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