Test Database from Production

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
egormsen
Captain (CAPT)
Captain (CAPT)
Posts: 236
Joined: Fri May 16, 2008 9:16 am

Test Database from Production

Post by egormsen » Tue May 17, 2016 6:53 am

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,
Eldon Gormsen
Weigh Down Ministries
AC Gold R12 SR1
http://store.weighdown.com

Odettes
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 102
Joined: Wed Apr 02, 2008 11:00 am
Location: Stockholm, Sweden
Contact:

Re: Test Database from Production

Post by Odettes » Tue May 17, 2016 11:36 am

Just disable the smtp server to avoid sending out emails from your developer store.
Sincerely,
Thomas Berglund

https://traileronline.se
AbleCommerce Gold R11 Custom

egormsen
Captain (CAPT)
Captain (CAPT)
Posts: 236
Joined: Fri May 16, 2008 9:16 am

Re: Test Database from Production

Post by egormsen » Wed May 18, 2016 3:11 am

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?
Eldon Gormsen
Weigh Down Ministries
AC Gold R12 SR1
http://store.weighdown.com

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2649
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: Test Database from Production

Post by Katie » Wed May 18, 2016 3:51 am

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
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

Post Reply