Support » Plugin: WooCommerce » Error in Woocommerce: data not loading

  • Resolved huubv

    (@huubv)


    Hi all,

    Running a webshop on wordpress with the Woocommerce plugin. If I navigate to WOOCOMMERCE – HOME I get the error ‘There’s been an error retrieving your data. Try again later ‘. I translated it from Dutch to English. Nothing at ‘orders’ or ‘stock’ is visible. If I navigate to WOOCOMMERCE – CUSTOMERS I get the same error.

    I have posted this question a couple of weeks ago along with the system status and the advise was to fix all issues first. Now I have fixed all issues (updating wordpress, updating PHP version, migrating to other server). As soon as I did that, we expected all errors would be fixed as well. Sadly, they’re not. I really need this to work, because we are starting a new administration system. I need to get clear numbers directly from plugin to my accountant.

    Here’s my system status:

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://trixbasic.nl
    Site address (URL): https://trixbasic.nl
    WC Version: 5.3.0
    REST API Version: ✔ 5.3.0
    WC Blocks Version: ✔ 4.9.1
    Action Scheduler Version: ✔ 3.1.6
    WC Admin Version: ✔ 2.2.6
    Log Directory Writable: ✔
    WP Version: 5.7.2
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: nl_NL
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.4.18
    PHP Post Max Size: 16 MB
    PHP Time Limit: 600
    PHP Max Input Vars: 1000
    cURL Version: 7.29.0
    NSS/3.53.1
    
    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.5.10-MariaDB
    Max Upload Size: 16 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 5.3.0
    WC Database Prefix: wp_
    Totale databasegrootte: 74.48MB
    Database datagrootte: 61.52MB
    Database index grootte: 12.96MB
    wp_woocommerce_sessions: Data: 1.02MB + 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.17MB + Engine InnoDB
    wp_woocommerce_order_items: Data: 0.17MB + Index: 0.16MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 1.52MB + Index: 1.28MB + Engine InnoDB
    wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + 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.03MB + Engine InnoDB
    wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_actions: Data: 0.16MB + Index: 0.14MB + 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.14MB + Index: 0.13MB + Engine InnoDB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 1.52MB + Index: 0.84MB + Engine InnoDB
    wp_ee_product_sync_call: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ee_product_sync_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_elfsight_social_share_buttons_widgets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ess_social_statistics: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_ezoic_endpoints: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_failed_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_imagify_files: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_imagify_folders: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mollie_pending_payment: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_options: Data: 2.50MB + Index: 1.16MB + Engine InnoDB
    wp_postmeta: Data: 5.52MB + Index: 6.03MB + Engine InnoDB
    wp_posts: Data: 45.52MB + Index: 0.63MB + Engine InnoDB
    wp_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_usermeta: Data: 1.52MB + Index: 0.59MB + Engine InnoDB
    wp_users: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
    wp_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.05MB + 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.09MB + Index: 0.06MB + Engine InnoDB
    wp_wc_download_log: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_product_lookup: Data: 0.14MB + Index: 0.16MB + Engine InnoDB
    wp_wc_order_stats: Data: 0.11MB + Index: 0.08MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.02MB + 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.03MB + Engine InnoDB
    wp_wp_quiz_play_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_yoast_indexable: Data: 0.45MB + Index: 0.38MB + Engine InnoDB
    wp_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_yoast_seo_links: Data: 0.09MB + Index: 0.06MB + Engine InnoDB
    wp_yoast_seo_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    attachment: 333
    customize_changeset: 5
    gfw_report: 23
    nav_menu_item: 19
    oembed_cache: 1
    page: 26
    post: 26
    product: 8
    product_variation: 17
    revision: 1749
    shop_coupon: 5
    shop_order: 1003
    shop_order_refund: 10
    wpcf7_contact_form: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    
    ### Active Plugins (20) ###
    
    Contact Form 7: door Takayuki Miyoshi – 5.4.1
    Imagify: door WP Media – 1.9.14
    Salient WPBakery Page Builder: door Michael M - WPBakery.com | Modified by ThemeNectar – 6.6.0
    Kadence WooCommerce Email Designer: door Kadence WP – 1.4.7
    Mollie-betalingen voor WooCommerce: door Mollie – 6.3.0
    Post Types Order: door Nsp Code – 1.9.5.6
    Really Simple SSL: door Really Simple Plugins – 4.0.15
    Salient Core: door ThemeNectar – 1.8.2
    Salient Portfolio: door ThemeNectar – 1.7
    Salient Shortcodes: door ThemeNectar – 1.5
    Salient Widgets: door ThemeNectar – 1.2
    Sassy Social Share: door Team Heateor – 3.3.20
    WooCommerce Side Cart: door XootiX – 2.1
    User Role Editor: door Vladimir Garagulya – 4.59.1
    W3 Total Cache: door BoldGrid – 2.1.2
    Checkout Field Editor for WooCommerce: door ThemeHigh – 1.4.8
    WooCommerce Parcel Pro: door Parcel Pro – 1.5.32
    WooCommerce PDF Invoices & Packing Slips: door Ewout Fernhout – 2.8.3
    WooCommerce Shipping & Tax: door WooCommerce – 1.25.12
    WooCommerce: door Automattic – 5.3.0
    
    ### Inactive Plugins (2) ###
    
    Autoptimize: door Frank Goossens (futtta) – 2.8.3
    Insert Headers and Footers: door WPBeginner – 1.6.0
    
    ### Dropin Plugins (2) ###
    
    advanced-cache.php: advanced-cache.php
    db.php: db.php
    
    ### 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)
    
    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: ❌ Pagina niet ingesteld
    Winkelmand: #21 - /winkelmand/
    Afrekenen: #22 - /afrekenen/
    Mijn account: #23 - /mijn-account/
    Algemene voorwaarden: #259 - /algemene-voorwaarden/
    
    ### Theme ###
    
    Name: Salient
    Version: 13.0.5
    Author URL: https://themeforest.net/user/themenectar
    Child Theme: ❌ – Als je wijzigingen aanbrengt in WooCommerce of in een hoofdthema dat je niet zelf gebouwd hebt
    raden we het gebruik van een child thema aan. Zie: Hoe maak je een child thema
    
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: salient/woocommerce/cart/mini-cart.php
    salient/woocommerce/checkout/form-checkout.php
    salient/woocommerce/checkout/review-order.php
    salient/woocommerce/checkout/terms.php
    salient/woocommerce/content-product.php
    salient/woocommerce/content-single-product.php
    salient/woocommerce/loop/add-to-cart.php
    salient/woocommerce/loop/loop-start.php
    salient/woocommerce/myaccount/form-login.php
    salient/woocommerce/single-product/product-image.php
    salient/woocommerce/single-product/rating.php
    salient/woocommerce/single-product/tabs/description.php
    salient/woocommerce/single-product/tabs/tabs.php
    salient/woocommerce/single-product/title.php
    salient/woocommerce/single-product-reviews.php
    
    ### Action Scheduler ###
    
    Afgerond: 524
    Oldest: 2021-04-16 09:07:43 +0000
    Newest: 2021-05-17 08:41:52 +0000
    
    ### Status report information ###
    
    Generated at: 2021-05-17 09:41:53 +01:00
    

    I have no critical errors in my DASHBOARD- SITE DIAGNOSIS, only a few recommendations:

    – The post_max_size is smaller than upload_max_filesize
    – The REST API call gave the following unexpected result: (403) {“code”:”rest_disabled”,”message”:”REST API uitgeschakeld.”,”data”:{“status”:403}}.

    Additional info that might be important:
    I received an error for a double gtag. I tried finding it in <head>, in plugins like ‘insert headers and footers’ but I cannot find it. Upon deactivating Monster Insights Plugin the error disappeared. So…somewhere, somehow there is a gtag (or code for analytics) on my website. I CANNOT find it! Went through the steps, also with my website builder, he couldn’t find it either. I’m just telling this because it could have something to do with the initial problem of not loading data through my woocommerce plugin.

    So, any help would be GREATLY appreciated!

    Thanks, Huub

    • This topic was modified 1 year, 1 month ago by huubv.

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Sunday Ukafia (a11n)

    (@sukafia)

    Hi @huubv,

    For future reference, we highly recommend staying on the initial topic to help us know what has been done and help further.

    The REST API call gave the following unexpected result: (403) {“code”:”rest_disabled”,”message”:”REST API uitgeschakeld.”,”data”:{“status”:403}}.

    The error points to the WP REST API being disabled which can cause the issue you’re experiencing.

    We have seen a few cases where the server’s (mode_security) configuration caused an issue like this. I’d recommend reaching out to your host to confirm their server settings aren’t blocking the WordPress REST API.

    Please let me know what you find so I can help further.

    Thread Starter huubv

    (@huubv)

    Hi Sunday,

    Thanks for replying, will look into that.

    To be clear: I have 1 big issue – the woocommerce data not loading.

    The reason I mentioned the other problems is to give some more insights and because they might be related to the woocommerce data error.

    It wasn’t my intention to sum up every issue I have!

    • This reply was modified 1 year, 1 month ago by huubv.
    Plugin Support Shohan Hossain Nabil – a11n

    (@sohanhossain)

    Hello @huubv,

    Have you managed to enable WP REST API and solve the problem yet?

    Thread Starter huubv

    (@huubv)

    Hi Shohan,

    Yes I have!

    Problem: Woocommerce plugin data didn’t load – error.

    Solution: renewed the .htaccess file. Somehow, somewhere it got damaged. It seemed like the (settings of) the WP Total Cache plugin caused the problem.

    After the renewing the .htaccess file and permalinks the REST API problem was also solved.

    Thanks for the help!

    Huub

    Plugin Support Shohan Hossain Nabil – a11n

    (@sohanhossain)

    Hello @huubv,

    Great! Thanks for sharing the solution with us.

    Since the issue is solved, I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

    Thanks!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Error in Woocommerce: data not loading’ is closed to new replies.