Export order tables and import them in another database

Started by idor, May 13, 2020, 12:15:34 PM

Previous topic - Next topic

idor

Hi,
I made a clone of my website in a subdomain where I am going to make several changes and also update joomla, plugins etc.
Later I want to delete the order from the subdomain and import the ones from the actual site.
How can I import those orders? Note that the actual site is not up to date.
I suppose I will need orders, order status, users? Can someone tell me the whole process and which tables I need to replace?

Thank you

pinochico

Manually with mysql export/import (but you must export another table too - a table order is not enough)
I think table order user infos, maybe some tables for shipping and payment plugins.

Or you can use JMigrator
www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds for FB, GMC,.. from products, categories, orders, users, articles, acymailing subscribers and database table
Virtuemart Email Manager - customs email templates
Import products for Virtuemart - from CSV and XML
Rich Snippets - Google Structured Data
VirtueMart Products Extended - Slider with products, show Others bought, Products by CF ID and others filtering products