Multisite is not an option with WordPress WooCommerce Membership Network

  • Greetings,

    I am in need of some help. I love woocommerce. Please don’t let me down!

    Before I begin, I have tried WPMU (multisite). Unfortunately root access to a server is required to make WPMU work. I host with HostGator on the Baby shared hosting plan. Our budget does not yet suit a server upgrade so Multisite will not suit us, at least not yet.

    We have a series of independent wordpress installs on different domains hosted on the same shared plan with Hostgator. These sites offer 3 things:
    ° Memberships (different price plans).
    ° Movie Downloads (pay per download)
    ° Free Guest Accounts (can preview, member access to 3 movies per month.)

    Focusing on the membership operation; what I want to make happen is each membership signup page be hosted on a different site. The user would then be directed to that payment page on that site. Once the transaction is successful however, it would grant the user who is now a paying member access to all sites. BUT Ive ran into a problem there too; all sites send the user the generic wordpress welcome email. I dont want that, I want them to only receive their order confirmation plus one email if need be from the transaction site.

    So essentially we are sharing a registered user across multiple sites in a network fashion.

    Ive tried user synchronization from WPML, but I receive sync errors.

    Ive tried configuring the wp installs to share the same user database but I receive error where I get the white page of death on wp-admin of the main site.

    I have been trying to work on this for over a year now and I end up banging my head against the wall. Im so frustrated. I know there just has to be a way.

    My guess is I need to somehow:
    ° Install WP on every site
    ° Install Woocommerce on each site
    ° Install the usual plugins we use
    ° Install the Membership Plugin we use

    But, sync WooCommerce Orders and users along with the membership plugin. But how?

    I did try connecting the sites via wordpress rest api and the same with woocommerce, that went beyond my expertise and step by step instructions, if that is the route to go would better suit.

    Please, I beg can you help? Tell me what I need to make this happen without WP multisite (hopefully).

    The reason for this platform is:
    ° each site is actually a 3rd party site. We want control of the transaction and security of the billing.
    ° The need for one SSL to keep cost down.
    ° We pay a minimal annual fee for our merchant act. Everything processed by manual entry. (Offline). No other member platform plugins offer offline processing by emailing and creating a secure postback off the customer’s card details.
    ° Gives us better control of the protection of the customer and our brand when working with 3rd party partners.

    Thank you very much for your time.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter redlinebuddy

    (@redlinebuddy)

    Anyone?

    I just want to know how to somehow sync woocommerce orders and users across multiple sites if even possible?

    TMS

    (@themysticalsock)

    @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, 10 months ago by TMS.
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Multisite is not an option with WordPress WooCommerce Membership Network’ is closed to new replies.