TMS

*Correction

New database per sub-site, not table (that obviously already happens!)

Actually @petervandoorn I just noticed the ‘after order status’ part of the woo one. I might look into that. Thanks! ??

For anyone looking for this function, Woocommerce Cart Abandonment Emails might do the job. Anyone with the plugin who gets it working, please feel free to post back to confirm. Thnank you.

https://docs.woocommerce.com/wp-content/uploads/2015/10/Screen-Shot-2015-10-20-at-12.33.35-PM.png

Funny how you make that plugin @tychesoftwares ??

———-

Apologies I should be more specific.

The customer would have paid for the order, it is essentially complete.

However the order status will not actually be “complete” as this is for a takeaway so the order is still being made up.

However if the order is still not set to collection (a custom order status) within 30 mins, that is when I need to trigger an email (or SMS

I would prefer to use a function – and yes, i’m looking into writing it myself, I
just know nothing about PHP ??

oops, please remove my post, no point in two links!

https://www.ads-software.com/support/topic/if-a-woocommerce-order-is-not-complete-after-30mins-send-email/

I’m closing this topic and i’ll ask it there, thanks.

@redlinebuddy
Try this:

Let’s say you have an existing WordPress installation, and you want to share the existing users database with a second website.

First of all make sure you are using the same WordPress version on the two websites and make sure your two websites are using the same database. To be able to have the two websites using the same database, you have to use different table prefix for each install.

To change the default WordPress table prefix, you have two choice. You can do it during the installation or editing the wp-config.php file where you must change $table_prefix value.

Once the second website has been installed, add these two lines in wp-config.php file, just before this line:

/* That's all, stop editing! Happy blogging. */

Add these two lines:

define('CUSTOM_USER_TABLE', 'wp_users');
define('CUSTOM_USERMETA_TABLE', 'wp_usermeta');

Make sure you replace “wp_” by the first website table prefix.

With this code you’re asking the second website to use the first website users table. Isn’t it great?

Now we are facing a small problem. Cookies… Yes, each website has its own cookies parameters, so your two websites have to use the same cookies parameters. So, still in wp-config.php of the second website, change the COOKIE_DOMAIN with the url of the first website:

define('COOKIE_DOMAIN', '.yoursite.com'); //replace with the 1st website url
define('COOKIEPATH', '/');

And now your’re done, now logged users will have their sessions opened accross your two websites.

From here: https://www.remicorson.com/share-users-database-on-different-wordpress-installs/

You can also add functions to create something like CUSTOM_WOO_ORDER and use the the Woocommerce tables: https://github.com/woocommerce/woocommerce/wiki/Database-Description to select your orders. Perhaps woocommerce_order_items.

• This reply was modified 7 years, 9 months ago by TMS.

make sure the !important is in there, it’s important!

Heya,

May I suggest this:

https://www.ads-software.com/plugins/username-changer/ to change usernames without dealing with MySQL

Or possibly: https://www.ads-software.com/plugins/admin-renamer-extended/
(more up to date)

Perhaps something including this?

<?php $users = get_users(); $id = array_rand( $users, 1 ); $user = $users[$id]; ?>