Support » Plugin: WooCommerce » Order details missing

  • Resolved Tom M

    (@tominthephilippines)


    Hi,

    A few weeks back I noticed that the order details of the last 10-15 orders was missing. Eventually I thought it was fixed, but now I noticed that for a part of the orders the order details are still missing, also from an order which did show them when I first noticed the issue. > See screenshot: https://ibb.co/RjmGzZw

    In the WC Analytics tab you can even see 2 orders showing ‘0’ in the ‘Items sold’ column, but the order did have products, and you can even see the amount behind it. Weird thing is, for some orders where there is a number of orders showing in that column, the order details are also missing (for example #3411) > See screenshot: https://ibb.co/b6W5ZzH

    I use the Booster plugin to create PDF invoices, and also there are no order details showing. Not sure if the problem already occurs right away when people order or if it happens later on. But in the order confirmation emails I receive I see the products that are being ordered.

    I ran the WC database update already, but that didn’t help.

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://www.gr8mag.be
    Site address (URL): https://www.gr8mag.be
    WC Version: 4.4.1
    REST API Version: ✔ 1.0.15
    WC Blocks Version: ✔ 3.1.0
    Action Scheduler Version: ✔ 3.1.6
    WC Admin Version: ✔ 1.4.0
    Log Directory Writable: ✔
    WP Version: 5.5
    WP Multisite: –
    WP Memory Limit: 2 GB
    WP Debug Mode: –
    WP Cron: ✔
    Language: nl_NL
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache/2
    PHP Version: 7.3.20
    PHP Post Max Size: 2 GB
    PHP Time Limit: 120
    PHP Max Input Vars: 1000
    cURL Version: 7.62.0
    OpenSSL/1.0.2k
    
    SUHOSIN Installed: –
    MySQL Version: 10.2.27-MariaDB-cll-lve
    Max Upload Size: 2 GB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 4.4.1
    WC Database Prefix: wp_
    Totale databasegrootte: 35.33MB
    Database datagrootte: 27.70MB
    Database index grootte: 7.63MB
    wp_woocommerce_sessions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_actions: Data: 0.48MB + Index: 0.42MB + Engine InnoDB
    wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_logs: Data: 0.38MB + Index: 0.23MB + Engine InnoDB
    wp_blogmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_blogs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_blog_versions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_cartflows_ca_cart_abandonment: Data: 0.14MB + Index: 0.02MB + Engine InnoDB
    wp_cartflows_ca_email_history: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_cartflows_ca_email_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_cartflows_ca_email_templates_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 0.14MB + Index: 0.09MB + Engine InnoDB
    wp_fooevents_check_in: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mollie_pending_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_options: Data: 3.52MB + Index: 0.22MB + Engine InnoDB
    wp_postmeta: Data: 8.52MB + Index: 4.03MB + Engine InnoDB
    wp_posts: Data: 1.52MB + Index: 0.25MB + Engine InnoDB
    wp_rank_math_404_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_rank_math_internal_links: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
    wp_rank_math_internal_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_rank_math_redirections: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_rank_math_redirections_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_rank_math_sc_analytics: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_registration_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_signups: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_site: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_sitemeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_termmeta: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
    wp_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wp_term_relationships: Data: 0.09MB + Index: 0.06MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_usermeta: Data: 0.39MB + Index: 0.28MB + Engine InnoDB
    wp_users: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
    wp_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_product_lookup: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
    wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.05MB + Index: 0.09MB + Engine InnoDB
    wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wdp_orders: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wdp_order_items: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wdp_rules: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
    wp_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wfconfig: Data: 1.44MB + Index: 0.00MB + Engine InnoDB
    wp_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wffilemods: Data: 6.52MB + Index: 0.00MB + Engine InnoDB
    wp_wfhits: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wfknownfilelist: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
    wp_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wflogins: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wfstatus: Data: 0.11MB + Index: 0.06MB + Engine InnoDB
    wp_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    astra-advanced-hook: 6
    attachment: 411
    custom_css: 2
    elementor_library: 45
    elementskit_content: 1
    event_magic_tickets: 51
    nav_menu_item: 36
    notificationx: 1
    oembed_cache: 1
    page: 51
    polylang_mo: 2
    post: 25
    product: 156
    product_variation: 41
    revision: 80
    shop_coupon: 60
    shop_order: 109
    shop_order_refund: 3
    wpforms: 5
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (51) ###
    
    Polylang: door WP SYNTEX – 2.8.1
    Advanced Dynamic Pricing for WooCommerce: door AlgolPlus – 3.0.4 – Geïnstalleerde versie niet getest met actieve versie van WooCommerce 4.4.1
    Astra Pro: door Brainstorm Force – 2.6.3
    Astra Widgets: door Brainstorm Force – 1.2.5
    Autocomplete WooCommerce Orders: door Liam McArthur – 1.3.1 – Geïnstalleerde versie niet getest met actieve versie van WooCommerce 4.4.1
    Autoptimize: door Frank Goossens (futtta) – 2.7.7
    Badges Woo: door TaxarPro – 1.0.8
    Ban Hammer: door Mika Epstein – 2.7.1
    CMP - Coming Soon & Maintenance Plugin: door NiteoThemes – 3.8.4
    Polylang Connect for Elementor: door David Decker - DECKERWEB – 1.0.0
    Customer Reviews for WooCommerce: door Customer Reviews – 3.123 – Geïnstalleerde versie niet getest met actieve versie van WooCommerce 4.4.1
    Disable Admin Notices Individually: door Webcraftic  – 1.2.3
    Disable Cart Fragments: door Optimocha – 1.21 – Geïnstalleerde versie niet getest met actieve versie van WooCommerce 4.4.1
    Elementor Pro: door Elementor.com – 3.0.2
    Elementor: door Elementor.com – 3.0.5
    ElementsKit Lite: door Wpmet – 1.5.12
    Essential Addons for Elementor: door WPDeveloper – 4.2.2 – Geïnstalleerde versie niet getest met actieve versie van WooCommerce 4.4.1
    EU Cookie Law: door Alex Moss
    Marco Milesi – 3.1.4
    
    Flying Pages by WP Speed Matters: door Gijo Varghese – 2.4.2
    FooEvents for WooCommerce: door FooEvents – 1.11.45 – Geïnstalleerde versie niet getest met actieve versie van WooCommerce 4.4.1
    FooEvents Express Check-in: door FooEvents – 1.4.7
    FooEvents Multi-Day: door FooEvents – 1.2.11
    FooEvents PDF Tickets: door FooEvents – 1.7.10
    GA Google Analytics: door Jeff Starr – 20200815
    Happy Elementor Addons: door weDevs – 2.13.3
    Heartbeat Control by WP Rocket: door WP Rocket – 2.0
    Limit Login Attempts Reloaded: door WPChef – 2.15.1
    Loco Translate: door Tim Whitlock – 2.4.3
    Mollie-betalingen voor WooCommerce: door Mollie – 5.8.2 – Geïnstalleerde versie niet getest met actieve versie van WooCommerce 4.4.1
    NotificationX: door WPDeveloper – 1.8.3
    Order / Coupon / Subscription Export Import Plugin for WooCommerce (BASIC): door WebToffee – 1.6.6 – Geïnstalleerde versie niet getest met actieve versie van WooCommerce 4.4.1
    PW WooCommerce Copy Coupon: door Pimwick
    LLC – 1.12 – Geïnstalleerde versie niet getest met actieve versie van WooCommerce 4.4.1
    
    Rank Math SEO: door Rank Math – 1.0.47.1
    User Role Editor: door Vladimir Garagulya – 4.56
    WebP Express: door Bjørn Rosell – 0.17.5
    White Label CMS: door www.videousermanuals.com – 2.2.1
    WooCommerce Cart Abandonment Recovery: door CartFlows Inc – 1.2.8 – Geïnstalleerde versie niet getest met actieve versie van WooCommerce 4.4.1
    WP Sheet Editor - WooCommerce Coupons: door WP Sheet Editor – 1.3.7 – Geïnstalleerde versie niet getest met actieve versie van WooCommerce 4.4.1
    Hyyan WooCommerce Polylang Integration: door Hyyan Abo Fakher – 1.4.3 – Geïnstalleerde versie niet getest met actieve versie van WooCommerce 4.4.1
    WPC Product Bundles for WooCommerce: door WPClever.net – 4.0.4 – Geïnstalleerde versie niet getest met actieve versie van WooCommerce 4.4.1
    Variation Swatches for WooCommerce: door Emran Ahmed – 1.0.85 – Geïnstalleerde versie niet getest met actieve versie van WooCommerce 4.4.1
    Booster for WooCommerce: door Pluggabl LLC – 5.2.1 – Geïnstalleerde versie niet getest met actieve versie van WooCommerce 4.4.1
    WooCommerce: door Automattic – 4.4.1
    Wordfence Security: door Wordfence – 7.4.11
    WordPress Importer: door wordpressdotorg – 0.7
    WP Fastest Cache: door Emre Vona – 0.9.1.0
    WP-Mail-SMTP: door WPForms – 2.3.1
    WP-Optimize - Clean, Compress, Cache: door David Anderson
    Ruhani Rabin
    Team Updraft – 3.1.2
    
    WP Rollback: door Impress.org – 1.7.1
    Smush: door WPMU DEV – 3.6.3
    WPForms Lite: door WPForms – 1.6.2.2
    
    ### Inactive Plugins (1) ###
    
    Redis Object Cache: door Till Krüss – 2.0.12
    
    ### Must Use Plugins (1) ###
    
    installatron_hide_status_test.php: door  –
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: EUR (€)
    Currency Position: left
    Thousand Separator: 
    Decimal Separator: ,
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    woosb (woosb)
    
    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)
    
    Connected to WooCommerce.com: –
    
    ### WC Pages ###
    
    Winkelbasis: #1202 - /webshop/
    Winkelmand: #694 - /winkelmand/
    Afrekenen: #697 - /afrekenen/
    Mijn account: #700 - /mijn-account/
    Algemene voorwaarden: ❌ Pagina niet ingesteld
    
    ### Theme ###
    
    Name: Astra Child Theme
    Version: 1.0.0
    Author URL: http://wpastra.com/about/
    Child Theme: ✔
    Parent Theme Name: Astra
    Parent Theme Version: 2.5.4
    Parent Theme Author URL: https://wpastra.com/about/
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: –
    
    ### Action Scheduler ###
    
    Geannuleerd: 9
    Oldest: 2020-08-01 05:31:53 +0000
    Newest: 2020-08-02 13:46:21 +0000
    
    Afgerond: 358
    Oldest: 2020-08-23 00:00:01 +0000
    Newest: 2020-09-01 02:45:37 +0000
    
    In afwachting: 1
    Oldest: 2020-09-01 08:33:42 +0000
    Newest: 2020-09-01 08:33:42 +0000
    
    
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Zach W – a11n

    (@dynamiczach)

    Automattic Happiness Engineer

    Howdy Tom!

    We haven’t received other reports of this issue happening, so this kind of problem is usually caused by either a conflict with your theme or with another plugin.
     
    The best way to determine this is to:

    • Temporarily switch your theme to Storefront
    • Disable all plugins except for WooCommerce
    • Repeat the action that is causing the problem

    If you’re not seeing the same problem after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated. To figure out which plugin is causing the problem, reactivate your other plugins one by one, testing after each, until you find the one causing conflict. You can find a more detailed explanation on how to do a conflict test here.

    Ideally, you’d setup a staging site and try the conflict testing process there. If not, please at least make sure you have a full backup of your live site before testing.

    Please also keep in mind that conflict testing may not make the information show up for existing orders. You would want to place a new order each time you test to see if the missing details show up in the new orders.

    Thread Starter Tom M

    (@tominthephilippines)

    Hi Zach,

    Thanks for getting back to me! I created a copy of the website and took all the steps you listed. The missing details didn’t show up unfortunately, but new orders do have order details. On the live website that is also the case for the most recent orders, so it’s hard to tell what is wrong. I guess it would be easier to find out when all orders would have missing order details, right?

    I did have to roll back my website to an earlier backup, because Redis Cache messed something up with the translations on the webshop categories page… for now I’ll assume that was the cause of it.

    Anyway, I’ll keep tracking what happens to future orders and if anything goes wrong.

    Thanks for the help, and if the issue continues I’ll get back to you.

    Cheers,
    Tom

    Plugin Support Zach W – a11n

    (@dynamiczach)

    Automattic Happiness Engineer

    Howdy Tom!

    Glad things are working for you now.

    I’ll set this to Resolved, but if it happens again please do open up a new thread with a link to this one for reference.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Order details missing’ is closed to new replies.