Page 1 of 1

Test Database from Production

Posted: Tue May 17, 2016 6:53 am
by egormsen
I would like to take a copy of our current production database and use it on our test store. If the past that has been pretty straightforward, but now that we have automatic recurring orders enabled I am worried about the test store generating emails and causing confusion for customers.

Any guidelines on the best way to do this?

Thanks,

Re: Test Database from Production

Posted: Tue May 17, 2016 11:36 am
by Odettes
Just disable the smtp server to avoid sending out emails from your developer store.

Re: Test Database from Production

Posted: Wed May 18, 2016 3:11 am
by egormsen
Thanks for that idea. I could do that temp work around, but there are times I like to get emails from the test store when working on new template or features.

What about going to the ac_Subscriptions table and setting the IsActive to 0 for every row, would that do it?

Re: Test Database from Production

Posted: Wed May 18, 2016 3:51 am
by Katie
That might work as long as you disable the email. It still might send one for the subscription being deactivated.

You could go to the Configuration page for Recurring Orders and disable all the email templates.

If you have any (pre-RO) classic subscriptions, just remove any triggers from the old email templates. (eg. Subscription Activated, Subscription Deactivated, etc)

That would work as well.

Katie