• Resolved digikal117

    (@digikal117)


    Occasionally, after a customer completes an order for several products, on the confirmation page after checkout we see 0 (ZERO) instead of the actual value of the order.

    When this happens, the payment is not completed, and on the backoffice, we also see zero instead of the actual value. This is happening with different options of payment and shipping.

    Has anyone experienced this error? This is happening for months now and I can’t seem to find the cause for this. Do you have any guess on how to solve or to find the origin of the bug?

    Here’s a screenshot of the issue: https://ibb.co/V3fDX5J

    Thank you in advance.

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

Viewing 6 replies - 1 through 6 (of 6 total)
  • Mirko P.

    (@rainfallnixfig)

    Hi @digikal117,

    Let’s see if there is an error on the WooCommerce Logs. Kindly provide us the following:

    • System Status: You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.
    • Fatal Error Log: Share a copy of any fatal error log found under WooCommerce > Status > Logs (if available).

    Thanks!

    Thread Starter digikal117

    (@digikal117)

    Hi @rainfallnixfig,

    Thank you for your reply!

    Here it goes:

    SYSTEM STATUS

    ### WordPress Environment ###

    WordPress address (URL): https://releaf.pt
    Site address (URL): https://releaf.pt
    WC Version: 6.1.0
    REST API Version: ? 6.1.0
    WC Blocks Version: ? 6.5.1
    Action Scheduler Version: ? 3.4.0
    WC Admin Version: ? 3.0.3
    Log Directory Writable: ?
    WP Version: 5.8.3
    WP Multisite: –
    WP Memory Limit: 768 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US
    External object cache: –

    ### Server Environment ###

    Server Info: Apache
    PHP Version: 7.4.27
    PHP Post Max Size: 256 MB
    PHP Time Limit: 120
    PHP Max Input Vars: 3000
    cURL Version: 7.66.0
    OpenSSL/1.1.1l-fips

    SUHOSIN Installed: –
    MySQL Version: 5.7.32-35-log
    Max Upload Size: 256 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?

    ### Database ###

    WC Database Version: 6.1.0
    WC Database Prefix: sln_
    Total Database Size: 53.37MB
    Database Data Size: 46.81MB
    Database Index Size: 6.56MB
    sln_woocommerce_sessions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    sln_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    sln_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    sln_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    sln_woocommerce_order_items: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
    sln_woocommerce_order_itemmeta: Data: 0.19MB + Index: 0.17MB + Engine InnoDB
    sln_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    sln_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    sln_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    sln_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    sln_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    sln_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    sln_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    sln_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    sln_actionscheduler_actions: Data: 0.34MB + Index: 0.47MB + Engine InnoDB
    sln_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    sln_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    sln_actionscheduler_logs: Data: 0.17MB + Index: 0.13MB + Engine InnoDB
    sln_cartflows_ca_cart_abandonment: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
    sln_cartflows_ca_email_history: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    sln_cartflows_ca_email_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    sln_cartflows_ca_email_templates_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    sln_cmplz_cookiebanners: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    sln_cmplz_cookies: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    sln_cmplz_services: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    sln_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    sln_comments: Data: 0.11MB + Index: 0.09MB + Engine InnoDB
    sln_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    sln_lws_wr_achieved_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    sln_lws_wr_historic: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    sln_mailchimp_carts: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
    sln_mailchimp_jobs: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    sln_moloni_api: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    sln_moloni_api_config: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    sln_myCRED_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    sln_nx_entries: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    sln_nx_posts: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    sln_nx_stats: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    sln_options: Data: 11.48MB + Index: 3.38MB + Engine InnoDB
    sln_pieregister_code: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    sln_pieregister_custom_user_roles: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    sln_pieregister_invite_code_emails: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    sln_pieregister_lockdowns: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    sln_pieregister_redirect_settings: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    sln_pimwick_gift_card: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    sln_pimwick_gift_card_activity: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    sln_postmeta: Data: 1.52MB + Index: 0.42MB + Engine InnoDB
    sln_posts: Data: 26.52MB + Index: 0.22MB + Engine InnoDB
    sln_signups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    sln_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    sln_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    sln_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    sln_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    sln_usermeta: Data: 0.13MB + Index: 0.11MB + Engine InnoDB
    sln_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    sln_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    sln_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    sln_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    sln_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    sln_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    sln_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    sln_wc_order_product_lookup: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
    sln_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    sln_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    sln_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    sln_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    sln_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    sln_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    sln_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    sln_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    sln_wdr_order_item_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    sln_wdr_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    sln_wof_lite_optins: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    sln_woo_shippment_provider: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    sln_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    sln_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    sln_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    sln_wpml_mails: Data: 4.52MB + Index: 0.00MB + Engine InnoDB
    sln_yith_ywpar_points_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    sln_yoast_indexable: Data: 0.19MB + Index: 0.13MB + Engine InnoDB
    sln_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    sln_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    sln_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    sln_yoast_seo_links: Data: 0.06MB + Index: 0.03MB + Engine InnoDB

    ### Post Type Counts ###

    attachment: 234
    custom_css: 2
    et_body_layout: 3
    et_footer_layout: 1
    et_header_layout: 1
    et_pb_layout: 33
    et_template: 5
    et_theme_builder: 1
    lws-wre-event: 4
    lws-wre-pool: 1
    lws-wre-unlockable: 1
    mycred_rank: 1
    nav_menu_item: 16
    page: 20
    polylang_mo: 5
    popup: 1
    popup_theme: 8
    post: 9
    product: 27
    product_variation: 22
    revision: 660
    shop_coupon: 19
    shop_order: 123
    shop_order_refund: 3
    wof_lite_wheel: 1

    ### Security ###

    Secure connection (HTTPS): ?
    Hide errors from visitors: ?

    ### Active Plugins (28) ###

    Complianz | GDPR/CCPA Cookie Consent: by Really Simple Plugins – 6.0.1
    Contribuinte Checkout: by moloni.pt – 1.0.42
    Customer Reviews for WooCommerce: by CusRev – 4.35
    Decorator – WooCommerce Email Customizer: by WebToffee – 1.1.2
    Age Verification: by Devio Digital – 2.6
    Email Verification for WooCommerce: by WPFactory – 2.2.5
    GTranslate: by Translate AI Multilingual Solutions – 2.9.7
    Jetpack: by Automattic – 10.5
    Mailchimp for WooCommerce: by Mailchimp – 2.5.4
    Moloni: by moloni.pt – 3.0.67
    Multibanco, MB WAY, Credit card and Payshop (IfthenPay) for WooCommerce: by Webdados – 5.1.3
    Popup Maker: by Popup Maker – 1.16.3
    Portugal States (Distritos) for WooCommerce: by Webdados – 3.0.3
    Really Simple SSL: by Really Simple Plugins – 5.2.2
    SiteGround Optimizer: by SiteGround – 6.0.5
    SiteGround Migrator: by SiteGround – 1.0.28
    Advanced Shipment Tracking for WooCommerce: by zorem – 3.3.1
    WooCommerce Cart Abandonment Recovery: by CartFlows Inc – 1.2.13
    WPC Product Bundles for WooCommerce (Premium): by WPClever – 6.0.4
    Variation Swatches for WooCommerce: by Emran Ahmed – 1.1.19
    WooCommerce: by Automattic – 6.1.0
    MyRewards: by Long Watch Studio – 4.6.3
    Yoast SEO: by Team Yoast – 17.9
    WP Mail Logging: by Wysija – 1.10.2
    WP Mail SMTP: by WPForms – 3.2.1
    WP-Members: by Chad Butler – 3.4.1.1
    WPForms Lite: by WPForms – 1.7.2
    Custom Product Tabs for WooCommerce: by YIKES
    Inc. – 1.7.7

    ### Inactive Plugins (1) ###

    WP Optin Wheel: by StudioWombat – 1.3.4

    ### 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)
    pw gift card (pw-gift-card)
    simple (simple)
    variable (variable)
    woosb (woosb)
    yith_bundle (yith_bundle)

    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 ###

    Shop base: #300 – /loja/
    Cart: #6 – /carrinho/
    Checkout: #7 – /checkout/
    My account: #8 – /minha-conta/
    Terms and conditions: #1302 – /termos-e-condicoes/

    ### Theme ###

    Name: Divi Child
    Version: 4.9.2.1616687487
    Author URL: https://www.elegantthemes.com
    Child Theme: ?
    Parent Theme Name: Divi
    Parent Theme Version: 4.14.5
    Parent Theme Author URL: https://www.elegantthemes.com
    WooCommerce Support: ?

    ### Templates ###

    Overrides: –

    ### Action Scheduler ###

    Complete: 715
    Oldest: 2021-12-16 12:57:41 +0000
    Newest: 2022-01-14 11:42:50 +0000

    Pending: 4
    Oldest: 2022-01-14 17:10:09 +0000
    Newest: 2022-01-14 22:17:49 +0000

    ### Status report information ###

    Generated at: 2022-01-14 13:25:06 +00:00

    _______

    FATAL ERROR LOG

    (I have several but here’s the last one)

    2022-01-10T14:31:04+00:00 CRITICAL Uncaught Error: Call to a member function get_sku() on null in /home/customer/www/releaf.pt/public_html/wp-content/plugins/woocommerce/templates/single-product/meta.php:28
    Stack trace:
    #0 /home/customer/www/releaf.pt/public_html/wp-content/plugins/woocommerce/includes/wc-core-functions.php(345): include()
    #1 /home/customer/www/releaf.pt/public_html/wp-content/plugins/woocommerce/includes/wc-template-functions.php(1638): wc_get_template(‘single-product/…’)
    #2 /home/customer/www/releaf.pt/public_html/wp-content/themes/Divi/includes/builder/feature/woocommerce-modules.php(1104): woocommerce_template_single_meta()
    #3 /home/customer/www/releaf.pt/public_html/wp-content/themes/Divi/includes/builder/module/woocommerce/Meta.php(292): et_builder_wc_render_module_template(‘woocommerce_tem…’, Array)
    #4 /home/customer/www/releaf.pt/public_html/wp-content/themes/Divi/includes/builder/module/woocommerce/Meta.php(391): ET_Builder_Module_Woocommerce_Meta::get_meta(Array)
    #5 /home/customer/www/releaf.pt/public_html/wp-con em /home/customer/www/releaf.pt/public_html/wp-content/plugins/woocommerce/templates/single-product/meta.php na linha 28

    Mirko P.

    (@rainfallnixfig)

    Hi @digikal117,

    Thanks for sharing your system status and error logs.

    It sounds like the issue here somehow is related to one or more of your third-party plugins not being written to work well with persistent object caching like Memcached enabled on your Siteground host.

    Can you disable Memcached? If you need help with this I’d recommend reaching out to your host’s support.

    Feel free to read these threads that have more details on why this is happening:

    https://www.ads-software.com/support/topic/customer-order-data-does-not-get-saved-and-total-price-is-zero/
    https://www.ads-software.com/support/topic/sg-optimizer-5-0-7-problem-with-woocommerce/

    Let us know if you have any questions.

    Thread Starter digikal117

    (@digikal117)

    @rainfallnixfig ,

    I actually already read those topic while doing my research. I went to confirm and I never really had the Memcached activated, only the Dynamic Caching of SG Optimizer Plugin. Should I turn it off as well? Or is there anything else I should try?

    Mirko P.

    (@rainfallnixfig)

    Hi @digikal117,

    Yes, it is best to disable caching from your SiteGround Optimizer plugin and make sure no caching is enabled on the server. SiteGround host’s support should be able to confirm this.

    Thanks.

    Mirko P.

    (@rainfallnixfig)

    Hi there,

    We’ve not heard back from you in a while so I’ll go ahead and mark this thread as resolved. Hopefully, you were able to find a solution to this issue.

    If you have further questions, please feel free to open a new topic.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Total Order Value is 0 (Zero)’ is closed to new replies.