Support » Plugin: WooCommerce » Order details are blank in WooCommerce -> Order page

  • Resolved ralbatross

    (@ralbatross)


    I am having a problem on my WooCommerce -> Orders page where the rows for the order table are there, but there is no content in any of the rows. Here, for example, is the HTML output for one of the rows in the order table:

    <tr id="post-96830" class="iedit author-self level-0 post-96830 type-shop_order status-wc-on-hold post-password-required hentry">
        <th scope="row" class="check-column">
            <label class="screen-reader-text" for="cb-select-96830">Select Order – August 24, 2018 @ 08:34 PM</label>
            <input id="cb-select-96830" type="checkbox" name="post[]" value="96830">
            <div class="locked-indicator">
                <span class="locked-indicator-icon" aria-hidden="true"></span>
                <span class="screen-reader-text">“Order – August 24, 2018 @ 08:34 PM” is locked</span>
            </div>
        </th>
        <td class="order_number column-order_number has-row-actions column-primary" data-colname="Order"></td>
        <td class="order_date column-order_date" data-colname="Date"></td>
        <td class="order_status column-order_status" data-colname="Status"></td>
        <td class="billing_address column-billing_address hidden" data-colname="Billing"></td>
        <td class="shipping_address column-shipping_address hidden" data-colname="Ship to"></td>
        <td class="order_total column-order_total" data-colname="Total"></td>
        <td class="wc_actions column-wc_actions hidden" data-colname="Actions"></td>		</tr>

    You will notice that all of the table cells except the check-column is emtpy.

    I have tried deactivating all plugins (except WooCommerce, of course), and I have switched to the Storefront theme instead of the custom theme we are building, and neither of these things has made a difference. I can see the orders in the database, and they appear to be normal. Here are all the rows from the wp_posts table of test orders we have performed:

    
    "96816","1","2018-08-10 16:26:06","2018-08-10 16:26:06",,"Order &ndash; August 10, 2018 @ 04:26 PM",,"wc-cancelled","open","closed","order_5b6dbc9e96777","order-aug-10-2018-0426-pm",,,"2018-08-10 18:00:05","2018-08-10 18:00:05",,"0","https://www.lwcb.shop/?post_type=shop_order&p=96816","0","shop_order",,"5"
    "96817","1","2018-08-10 18:43:51","2018-08-10 18:43:51",,"Order &ndash; August 10, 2018 @ 06:43 PM",,"wc-cancelled","open","closed","order_5b6ddce75253e","order-aug-10-2018-0643-pm",,,"2018-08-10 20:00:02","2018-08-10 20:00:02",,"0","https://www.lwcb.shop/?post_type=shop_order&p=96817","0","shop_order",,"14"
    "96820","1","2018-08-23 20:53:15","2018-08-23 20:53:15",,"Order &ndash; August 23, 2018 @ 08:53 PM","Thanks, pickup on Test.Test.Test","wc-cancelled","open","closed","order_5b7f1ebb1f59a","order-aug-23-2018-0853-pm",,,"2018-08-23 22:00:02","2018-08-23 22:00:02",,"0","https://www.lwcb.shop/?post_type=shop_order&p=96820","0","shop_order",,"4"
    "96822","1","2018-08-24 18:38:41","2018-08-24 18:38:41",,"Order &ndash; August 24, 2018 @ 06:38 PM",,"wc-cancelled","open","closed","order_5b8050b1d550f","order-aug-24-2018-0638-pm",,,"2018-08-24 21:00:06","2018-08-24 21:00:06",,"0","https://www.lwcb.shop/?post_type=shop_order&p=96822","0","shop_order",,"10"
    "96823","1","2018-08-24 19:00:33","2018-08-24 19:00:33",,"Order &ndash; August 24, 2018 @ 07:00 PM",,"wc-cancelled","open","closed","order_5b8055d159542","order-aug-24-2018-0700-pm",,,"2018-08-24 21:00:08","2018-08-24 21:00:08",,"0","https://www.lwcb.shop/?post_type=shop_order&p=96823","0","shop_order",,"4"
    "96824","1","2018-08-24 19:05:28","2018-08-24 19:05:28",,"Order &ndash; August 24, 2018 @ 07:05 PM",,"wc-processing","open","closed","order_5b8056f8c7b1b","order-aug-24-2018-0705-pm",,,"2018-08-24 19:06:25","2018-08-24 19:06:25",,"0","https://www.lwcb.shop/?post_type=shop_order&p=96824","0","shop_order",,"2"
    "96825","1","2018-08-24 20:15:55","2018-08-24 20:15:55",,"Order &ndash; August 24, 2018 @ 08:15 PM",,"wc-cancelled","open","closed","order_5b80677bb6770","order-aug-24-2018-0815-pm",,,"2018-08-24 23:00:02","2018-08-24 23:00:02",,"0","https://www.lwcb.shop/?post_type=shop_order&p=96825","0","shop_order",,"3"
    "96826","1","2018-08-24 20:19:11","2018-08-24 20:19:11",,"Order &ndash; August 24, 2018 @ 08:19 PM",,"wc-on-hold","open","closed","order_5b80683fe44f3","order-aug-24-2018-0819-pm",,,"2018-08-24 20:19:50","2018-08-24 20:19:50",,"0","https://www.lwcb.shop/?post_type=shop_order&p=96826","0","shop_order",,"2"
    "96827","1","2018-08-24 20:25:07","2018-08-24 20:25:07",,"Order &ndash; August 24, 2018 @ 08:25 PM","Thanks","wc-cancelled","open","closed","order_5b8069a3667ae","order-aug-24-2018-0825-pm",,,"2018-08-24 23:00:04","2018-08-24 23:00:04",,"0","https://www.lwcb.shop/?post_type=shop_order&p=96827","0","shop_order",,"3"
    "96828","1","2018-08-24 20:26:47","2018-08-24 20:26:47",,"Order &ndash; August 24, 2018 @ 08:26 PM","Thanks","wc-on-hold","open","closed","order_5b806a07ef624","order-aug-24-2018-0826-pm",,,"2018-08-24 20:27:07","2018-08-24 20:27:07",,"0","https://www.lwcb.shop/?post_type=shop_order&p=96828","0","shop_order",,"2"
    "96829","1","2018-08-24 20:29:11","2018-08-24 20:29:11",,"Order &ndash; August 24, 2018 @ 08:29 PM","Testing Notes","wc-on-hold","open","closed","order_5b806a975d1aa","order-aug-24-2018-0829-pm",,,"2018-08-24 20:29:36","2018-08-24 20:29:36",,"0","https://www.lwcb.shop/?post_type=shop_order&p=96829","0","shop_order",,"2"
    "96830","1","2018-08-24 20:34:14","2018-08-24 20:34:14",,"Order &ndash; August 24, 2018 @ 08:34 PM",,"wc-on-hold","open","closed","order_5b806bc61e330","order-aug-24-2018-0834-pm",,,"2018-08-24 20:34:36","2018-08-24 20:34:36",,"0","https://www.lwcb.shop/?post_type=shop_order&p=96830","0","shop_order",,"2"
    

    Trying to go to the individual order permalinks in the above data results in a 404. What’s going on here?

    Below is my WooCommerce status report

    
    
    ### WordPress Environment ###
    
    Home URL: https://www.lwcb.shop
    Site URL: https://www.lwcb.shop
    WC Version: 3.4.4
    Log Directory Writable: ✔
    WP Version: 4.9.8
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: ✔
    WP Cron: –
    Language: en_US
    External object cache: ✔
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.0.31 - We recommend using PHP version 7.2 or above for greater performance and security. How to update your PHP version
    PHP Post Max Size: 25 MB
    PHP Time Limit: 600
    PHP Max Input Vars: 1000
    cURL Version: 7.61.0
    OpenSSL/1.0.2o
    
    SUHOSIN Installed: –
    MySQL Version: 5.6.40
    Max Upload Size: 25 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 3.4.4
    WC Database Prefix: wp_
    MaxMind GeoIP Database: ✔
    Total Database Size: 717.09MB
    Database Data Size: 610.61MB
    Database Index Size: 106.48MB
    wp_woocommerce_sessions: Data: 0.11MB + Index: 0.00MB
    wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB
    wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.02MB
    wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB
    wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB
    wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB
    wp_aws_cache: Data: 1.93MB + Index: 0.00MB
    wp_aws_index: Data: 78.00MB + Index: 0.00MB
    wp_commentmeta: Data: 0.00MB + Index: 0.01MB
    wp_comments: Data: 0.01MB + Index: 0.01MB
    wp_gf_draft_submissions: Data: 0.00MB + Index: 0.00MB
    wp_gf_entry: Data: 0.00MB + Index: 0.00MB
    wp_gf_entry_meta: Data: 0.00MB + Index: 0.01MB
    wp_gf_entry_notes: Data: 0.00MB + Index: 0.00MB
    wp_gf_form: Data: 0.00MB + Index: 0.00MB
    wp_gf_form_meta: Data: 0.03MB + Index: 0.00MB
    wp_gf_form_view: Data: 0.00MB + Index: 0.00MB
    wp_iwp_backup_status: Data: 0.00MB + Index: 0.00MB
    wp_links: Data: 0.00MB + Index: 0.00MB
    wp_mr_integrator_log: Data: 395.74MB + Index: 20.83MB
    wp_mr_wc_dump_requests: Data: 3.56MB + Index: 0.70MB
    wp_mr_wc_imports: Data: 0.00MB + Index: 0.00MB
    wp_mr_wc_log: Data: 0.00MB + Index: 0.00MB
    wp_mr_wc_stats: Data: 0.00MB + Index: 0.00MB
    wp_options: Data: 9.71MB + Index: 0.07MB
    wp_postmeta: Data: 97.74MB + Index: 74.34MB
    wp_posts: Data: 20.69MB + Index: 5.38MB
    wp_rg_form: Data: 0.00MB + Index: 0.00MB
    wp_rg_form_meta: Data: 0.03MB + Index: 0.00MB
    wp_rg_form_view: Data: 0.00MB + Index: 0.00MB
    wp_rg_incomplete_submissions: Data: 0.00MB + Index: 0.00MB
    wp_rg_lead: Data: 0.00MB + Index: 0.00MB
    wp_rg_lead_detail: Data: 0.00MB + Index: 0.00MB
    wp_rg_lead_detail_long: Data: 0.00MB + Index: 0.00MB
    wp_rg_lead_meta: Data: 0.00MB + Index: 0.00MB
    wp_rg_lead_notes: Data: 0.00MB + Index: 0.00MB
    wp_smush_dir_images: Data: 0.00MB + Index: 0.00MB
    wp_termmeta: Data: 0.02MB + Index: 0.02MB
    wp_terms: Data: 0.00MB + Index: 0.01MB
    wp_term_relationships: Data: 2.83MB + Index: 5.02MB
    wp_term_taxonomy: Data: 0.01MB + Index: 0.01MB
    wp_usermeta: Data: 0.02MB + Index: 0.02MB
    wp_users: Data: 0.00MB + Index: 0.01MB
    wp_wcpv_commissions: Data: 0.00MB + Index: 0.00MB
    wp_wcpv_per_product_shipping_rules: Data: 0.00MB + Index: 0.00MB
    wp_wc_download_log: Data: 0.00MB + Index: 0.00MB
    wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB
    wp_wpgmza: Data: 0.02MB + Index: 0.00MB
    wp_wpgmza_categories: Data: 0.02MB + Index: 0.00MB
    wp_wpgmza_category_maps: Data: 0.02MB + Index: 0.00MB
    wp_wpgmza_circles: Data: 0.02MB + Index: 0.00MB
    wp_wpgmza_maps: Data: 0.02MB + Index: 0.00MB
    wp_wpgmza_polygon: Data: 0.02MB + Index: 0.00MB
    wp_wpgmza_polylines: Data: 0.02MB + Index: 0.00MB
    wp_wpgmza_rectangles: Data: 0.02MB + Index: 0.00MB
    wp_yoast_seo_links: Data: 0.00MB + Index: 0.00MB
    wp_yoast_seo_meta: Data: 0.00MB + Index: 0.00MB
    
    ### Post Type Counts ###
    
    acf-field: 5
    acf-field-group: 1
    attachment: 2393
    gift_card: 1
    google_maps: 1
    lwcb_promo: 5
    lwcb_staff_pick: 3
    nav_menu_item: 112
    page: 16
    post: 3
    product: 53173
    product_variation: 4
    revision: 194
    shop_coupon: 1
    shop_order: 12
    templatera: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ❌Error messages should not be shown to visitors.
    
    ### Active Plugins (26) ###
    
    InfiniteWP - Client: by Revmakx – 1.8.4.1
    Admin Menu Editor: by Janis Elsts – 1.8.4
    Advanced Custom Fields PRO: by Elliot Condon – 5.7.3
    Advanced Woo Search: by ILLID – 1.49
    WP Offload S3 Lite: by Delicious Brains – 1.4.3
    The SEO Framework: by Sybre Waaijer – 3.0.6
    Flexible Shipping: by WP Desk – 2.1.6
    Gravity Forms: by rocketgenius – 2.3.3
    WPBakery Page Builder: by Michael M - WPBakery.com – 5.5.2
    WooCommerce Integrator: by Modern Retail – 2.0.2 – Not tested with the active version of WooCommerce
    MR Custom Fields: by Modern Retail – 1.1.0
    WooCommerce Onsale Page: by wpgenie – 1.0.10 – Not tested with the active version of WooCommerce
    Perfect WooCommerce Brands: by Alberto de Vera Sevilla – 1.6.5
    Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.0.2
    Templatera Widget: by EverDesign – 1.0
    Templatera: by WPBakery – 1.1.12
    Vantiv WooCommerce Gateway: by Radial Studios – 2.1.0 – Not tested with the active version of WooCommerce
    W3 Total Cache: by Frederick Townes – 0.9.7
    WooCommerce Amazon S3 Storage: by WooCommerce – 2.1.6 – 2.1.9 is available – Not tested with the active version of WooCommerce
    WooCommerce Dynamic Pricing: by Lucas Stark – 3.0.9 – 3.1.7 is available – Not tested with the active version of WooCommerce
    WooCommerce Google Analytics Integration: by WooCommerce – 1.4.4 – Not tested with the active version of WooCommerce
    WooCommerce - ShipStation Integration: by WooCommerce – 4.1.22
    WooCommerce: by Automattic – 3.4.4
    WP Crontrol: by John Blackbourn & contributors – 1.6.2
    WP Google Maps: by WP Google Maps – 7.10.28
    Smush: by WPMU DEV – 2.8.0.1
    
    ### Settings ###
    
    API Enabled: ✔
    Force SSL: –
    Currency: CAD ($)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    
    Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
    exclude-from-search (exclude-from-search)
    featured (featured)
    outofstock (outofstock)
    rated-1 (rated-1)
    rated-2 (rated-2)
    rated-3 (rated-3)
    rated-4 (rated-4)
    rated-5 (rated-5)
    
    ### WC Pages ###
    
    Shop base: #4 - /shop/
    Cart: #5 - /cart/
    Checkout: #6 - /checkout/
    My account: #7 - /my-account/
    Terms and conditions: #144 - /privacy/
    
    ### Theme ###
    
    Name: LWCB 2018
    Version: 1.0.1
    Author URL: https://www.innovative.ink/
    Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: lwcb-2018/woocommerce/single-product/review-meta.php
    
    • This topic was modified 1 year, 2 months ago by ralbatross.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Hannah S.

    (@fernashes)

    Automattic Happiness Engineer

    Hey there,

    Thanks for all of that information!

    This kind of thing is usually caused by either a conflict with your theme or with another plugin.

    The best way to determine if the issue is being caused by a theme and/or plugin is to temporarily switch your theme to Storefront and disable all plugins except for WooCommerce. If you can install plugins, install Health Check. On the troubleshooting tab, you can click the button to disable all plugins and change the theme for you while you’re logged in to that session without affecting normal visitors to your site. Note that Health Check may not count Storefront as a default theme, so you can also use Twenty Seventeen as well.

    If that resolves the issue, then one-by-one you can switch back your theme and re-enable your plugins, testing in between, until you find the one causing the conflict.

    Thanks for the feedback Hannah,

    As I mentioned in my original post the problem persists even when I have all plugins except WooCommerce disabled, and I am using the Storefront theme. I have just re-confirmed this fact. It surprises me too, but it is true: I have only WooCommerce and Storefront running, and the orders are still not appearing.

    Aha! I re-installed WordPress and that fixed it. I must have been hacking at core files while troubleshooting something.

    I am having the same problem wherein the order details changes to Order – August 11, 2017 @ 05:00 PM and also when I checked it in my product name, the Physical Gift card changes automatically to Order – August 11, 2017 @ 05:00 PM . I really don’t know what trigger it to changed. I already tried disabling other plugins but same error.

    @ralbatross what version of wordpress you are using? I am already running the latest version of wordpress 5.0.2 and woocommerce latest version 3.5.2.

    Please advise.

    Thank you

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Order details are blank in WooCommerce -> Order page’ is closed to new replies.