Total Order Value is 0 (Zero)
-
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]
-
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!
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-fipsSUHOSIN 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 +0000Pending: 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 28Hi @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.
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?
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.
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.
- The topic ‘Total Order Value is 0 (Zero)’ is closed to new replies.