Mirror / Duplicate Site - Live Orders

Post by andyd92 » Mon May 25, 2015 6:25 pm

Hi all

I have recently site up a site mirror / duplicate of a Opencart 2.0.1.1 store for testing purposes on a sub-domain.

Now I was wondering if there is anyway I can get the mirror site to pull in orders as and when they come in. That is, both the original site and mirror site are functioning exactly the same with orders flowing in as and when.

The reason for this is that I need to test some changes which effect the funtionality of the ordering system, which I cannot test without live orders coming in, obviously I cannot test on a live site incase I break it, which is likely )

Any suggestions greatly appreciated?

Thanks in advance

Post by viethemes » Mon May 25, 2015 9:33 pm

http://www.viethemes.com - OpenCart turtorials, news, tips and stricks, extension

Our extensions:
Visual Theme Editor - Powerful tool for customizing style of any theme visually
Live Theme Editor - Customize layout, colors, backgrounds, fonts of the default theme
Theme Animation - Animation Editor for any theme

Extra Positions PRO, Custom JavaScript, Custom CSS and others

Post by deepvision » Mon May 25, 2015 9:41 pm

CREATE ALGORITHM=MERGE VIEW test_database.order AS SELECT * FROM live_database.order;

Post by andyd92 » Tue May 26, 2015 9:02 pm

Post by deepvision » Wed May 27, 2015 12:46 am

Post by andyd92 » Wed May 27, 2015 2:12 pm

Post by deepvision » Wed May 27, 2015 6:49 pm