News:

Looking for documentation? Take a look on our wiki

Main Menu

Exporting customer order using phpMyAdmin

Started by sui_page, December 03, 2013, 23:24:21 PM

Previous topic - Next topic

sui_page

I've used the following tables to export my orders to duplicate of my site on another server. All is well except however payment method and shipment info are no where to be seen on my new server. What tables do I need to get these two fields migrated over too?

aml9y_virtuemart_orders
aml9y_virtuemart_orderstates
aml9y_virtuemart_order_calc_rules
aml9y_virtuemart_order_histories
aml9y_virtuemart_order_items
aml9y_virtuemart_order_userinfos


GJC Web Design

they are in the individual tables e.g.

aml9y_virtuemart_shipment_plg_weight_countries
aml9y_virtuemart_shipment_plg_auspost

etc linked by virtuemart_order_id & order_number (dae605 etc)

payment the same e.g.
aml9y_virtuemart_payment_plg_standard
aml9y_virtuemart_payment_plg_paypal
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