Forum Replies Created

Viewing 15 replies - 16 through 30 (of 43 total)
  • Here is a follow up ticket I received back from WooCommerce support. It is very helpful.

    Thank you for contacting WooCommerce – I’m happy to help.

    Are there any database tables that store user information?

    The main tables used, include:

    wp_options
    wp_postmeta
    wp_posts
    wp_users
    wp_usermeta
    However, many extensions use additional DB tables outside of the ones listed above.

    With that said, moving from staging to live can be a tricky process if you have an existing live site, especially when it involves merging orders / customers / products.

    While support for the exact database tables falls outside the scope of support we’re able to offer (more information in our Support Policy), I would strongly recommend taking a closer look at WP Migrate DB Pro – essentially this will allow you to push / pull DB tables in both directions.

    Normally, the process would include the following:

    Enable maintenance mode on live to prevent any further user activity taking place (i.e. placing orders);
    Create backups of live AND staging;
    Use WP Migrate DB Pro to merge all tables from live to staging;
    Confirm everything is working on staging;
    Push entire staging site to live
    Deactivate maintenance mode on live
    Finally, I’d also like to point you to a guide written by my colleague that might be worthwhile reading: http://conschneider.de/sync-wordpress-woocommerce-staging-production-site-current-overview/

    Of course I did. It was the first thing I did…. I didn’t get any help from them. My question has nothing do do with hosting at all. I’m making edits to a copy of a live site, then once done moving that copy to override the live site. But there are some parts of the live site I don’t want to override. I was simply explaining what I am doing which I’m probably not communicating very well. This is a general database issue that would be the same no matter who or where the site is hosted. This is why I’m hoping I can get some help here. Someone has to know what database files effect what parts of a wordpress website. And yes I looked up the tables on WooCommerce’s documentation and put in a support ticket with them and again I have not got any specific answers.

    So basically I’m asking this:

    1. What WooCommerce database tables affect the orders? I have Zapier connecting my WooCommerce registration form (with extra fields I added) with infusionsoft so when someone fills our a form the info goes to infusionsoft as a new contact. Works great. So when I move the tables to the live site they are overriding the orders and overriding the Zapier intergration. I have tried moving some tables systimatacly trying to figure out what effects what but I’m not having any luck. These are my WooCommerce Tables
    – wp_kgrb_woocommerce_api_keys
    – wp_kgrb_woocommerce_attribute_taxonomies
    – wp_kgrb_woocommerce_downloadable_product_permissions
    – wp_kgrb_woocommerce_order_itemmeta
    – wp_kgrb_woocommerce_order_items
    – wp_kgrb_woocommerce_payment_tokenmeta
    – wp_kgrb_woocommerce_payment_tokens
    – wp_kgrb_woocommerce_sessions
    – wp_kgrb_woocommerce_shipping_zone_locations
    – wp_kgrb_woocommerce_shipping_zone_methods
    – wp_kgrb_woocommerce_shipping_zones
    – wp_kgrb_woocommerce_tax_rate_locations
    – wp_kgrb_woocommerce_tax_rates
    – wp_kgrb_woocommerce_termmeta

    2. What tables are effecting the comments? I thought this was easy because these tables looked pretty obvious:
    – wp_commentmeta
    – wp_comments
    – wp_kgrb_comments
    – wp_kgrb_commentmeta
    But when I moved all the other tables but did not move these the comments still were overridden.

    3. What tables are effecting the Zapier integration? Not having any luck with their support either.

    I’m trying to move as much of the site as I can with out changing/overiding the Comments, WooCommerce orders, Users and Zapier connections between WooCommerce and Infusionsoft and Gravity forms and Infusionsoft.

    I think what I’m asking is pretty straight forward but maybe I am making it sound more complicated.

    Thanks. I just checked it and it seems to be working now. Not sure why or what the problem was because I have done nothing to it.

    Simple fix, I had to change the url to the same page as the form is on in the confirmations section

    Forgot tags

    Josh, I used the shortcode and it worked perfictaiy. Guess I over looked that. Thank you

    I am having this exact same problem using the enfold theme. Here is the theme’s website. I also have this issue with any theme. If the template list is long I can see the bottom of the list. It should really scroll or something. As it is the relevant files I’m looking for could be at the bottom of the list, making the plugin useless.

    Hey Ya. It is. Sorry about my late replay. I’m in work mode, locked in 🙂

    I found the solution. I used the page id instead of the slug. Go figure but it worked. Thanks bdbrown for getting me most of the way there. Here is what worked

    <?php
    if ( is_page(‘2705’) ) {
    get_footer( ‘pillpack’ );
    } else {
    get_footer();
    }
    ?>

    Thanks bdbrown for the reply. Neither one of those worked. I’ve been reading the WP codex and it seems like they should. I’ll gladly try any other suggestions you have. Thanks

    Thanks! I’m trying to find that dashboard “Page” that controls the http://proservicescontractors.com/services/ page. I’m probably not explaining this correctly as cache is really not the issue being I’ve tried all that. This is a hard one to explain but let me try.

    I can see the page http://proservicescontractors.com/services/ while viewing the site online just fine.

    Dashboard > Pages > the page titled “Services” (I know the title can be anything). I believe this page in my dashboard contains the content for the above online page because the URL is the same; http://proservicescontractors.com/services/ I also know WP can’t have the same URL for 2 pages. If you try it WP will put a “-2” or -3 etc… at the end of the URL.

    If you look at the above page online, all the “Residential and Commercial Services” are being pulled in from the “Services” section of my dashboard, Ok. What’s left on the dashboard “Page” called “Services” is the orange full-screen button at the bottom.

    Ok here’s the issue:
    When I change something on the aforementioned “Services Page” in my dashboard my changes do not show while visiting the site online. Even when I “Preview” my changes directly from my dashboard the changes don’t show. However, If i change the URL to a random URL like http://proservicescontractors.com/services-dog/ my changes show but the “Residential and Commercial Services” are gone. Weird!
    (Nope.. don’t have a clue.)

    All my other pages work fine. I’m trying to change the meta page title to something else and I can’t do it. Can’t do it with yoast on the dashboard Services page, and I can’t change it directly on the page title section. I’ve tried disabling yoast, still have the same issue.

    Anybody know what’s going on and/or how to change the meta title or edit the page?
    Thanks, Greg

    I found it, was a simple fix.

    Your right… Thanks it worked

    Yeah I tried your suggestion and it didn’t work. Tried many more variations of selectors, on different elements, still not working.

    the url to the above home page
    http://936.678.myftpupload.com

Viewing 15 replies - 16 through 30 (of 43 total)