Difference between Woocommerce total and Analytics
-
Hi guys, there is an huge difference between the two platforms and I can’t find a logic in the missing orders.
The total of woocommerce is almost always greater, but in some rare cases the opposite happens.
This happens with different payments methods and at different hours, too.
I yet tried excluding from chaching checkout and cart pages.### WordPress Environment ### WordPress address (URL): https://vandem.it Site address (URL): https://vandem.it WC Version: 4.8.0 REST API Version: ? 4.8.0 WC Blocks Version: ? 3.8.1 Action Scheduler Version: ? 3.1.6 WC Admin Version: ? 1.7.3 Log Directory Writable: ? WP Version: 5.7.2 WP Multisite: – WP Memory Limit: 768 MB WP Debug Mode: – WP Cron: – Language: it_IT External object cache: ? ### Server Environment ### Server Info: Apache PHP Version: 7.4.20 PHP Post Max Size: 256 MB PHP Time Limit: 120 PHP Max Input Vars: 3000 cURL Version: 7.66.0 OpenSSL/1.1.1k-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: 4.8.0 WC Database Prefix: wpgu_ Dimensione totale database: 308.73MB Dimensione dati database: 162.67MB Dimensione indice database: 146.06MB wpgu_woocommerce_sessions: Dati: 2.02MB + indice: 0.02MB + motore InnoDB wpgu_woocommerce_api_keys: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpgu_woocommerce_attribute_taxonomies: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpgu_woocommerce_downloadable_product_permissions: Dati: 0.02MB + indice: 0.06MB + motore InnoDB wpgu_woocommerce_order_items: Dati: 3.52MB + indice: 1.52MB + motore InnoDB wpgu_woocommerce_order_itemmeta: Dati: 26.56MB + indice: 24.09MB + motore InnoDB wpgu_woocommerce_tax_rates: Dati: 0.02MB + indice: 0.06MB + motore InnoDB wpgu_woocommerce_tax_rate_locations: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpgu_woocommerce_shipping_zones: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_woocommerce_shipping_zone_locations: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpgu_woocommerce_shipping_zone_methods: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_woocommerce_payment_tokens: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpgu_woocommerce_payment_tokenmeta: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpgu_woocommerce_log: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpgu_actionscheduler_actions: Dati: 1.08MB + indice: 0.75MB + motore InnoDB wpgu_actionscheduler_claims: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpgu_actionscheduler_groups: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpgu_actionscheduler_logs: Dati: 1.52MB + indice: 0.45MB + motore InnoDB wpgu_aws_cache: Dati: 2.52MB + indice: 0.00MB + motore InnoDB wpgu_aws_index: Dati: 3.47MB + indice: 2.72MB + motore InnoDB wpgu_commentmeta: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpgu_comments: Dati: 8.52MB + indice: 10.09MB + motore InnoDB wpgu_dynamic_widgets: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpgu_ee_product_sync_call: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_ee_product_sync_data: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_failed_jobs: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_links: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpgu_loginizer_logs: Dati: 0.00MB + indice: 0.01MB + motore MyISAM wpgu_mailchimp_carts: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_mailchimp_jobs: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_ms_snippets: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_newsletter: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpgu_newsletter_emails: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_newsletter_sent: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpgu_newsletter_stats: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpgu_newsletter_user_logs: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_options: Dati: 2.52MB + indice: 1.66MB + motore InnoDB wpgu_postmeta: Dati: 46.58MB + indice: 51.16MB + motore InnoDB wpgu_posts: Dati: 6.52MB + indice: 3.70MB + motore InnoDB wpgu_pum_subscribers: Dati: 0.02MB + indice: 0.06MB + motore InnoDB wpgu_queue: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_sbi_instagram_feeds_posts: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpgu_sbi_instagram_feed_locator: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpgu_sbi_instagram_posts: Dati: 0.08MB + indice: 0.00MB + motore InnoDB wpgu_sib_model_contact: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_sib_model_country: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_snippets: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_social_users: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpgu_termmeta: Dati: 0.06MB + indice: 0.06MB + motore InnoDB wpgu_terms: Dati: 0.05MB + indice: 0.03MB + motore InnoDB wpgu_term_relationships: Dati: 0.23MB + indice: 0.20MB + motore InnoDB wpgu_term_taxonomy: Dati: 0.06MB + indice: 0.03MB + motore InnoDB wpgu_trp_dictionary_it_it_en_us: Dati: 0.02MB + indice: 0.06MB + motore InnoDB wpgu_trp_gettext_en_us: Dati: 0.02MB + indice: 0.06MB + motore InnoDB wpgu_trp_gettext_it_it: Dati: 0.02MB + indice: 0.06MB + motore InnoDB wpgu_trp_original_meta: Dati: 0.02MB + indice: 0.05MB + motore InnoDB wpgu_trp_original_strings: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpgu_usermeta: Dati: 31.56MB + indice: 27.09MB + motore InnoDB wpgu_users: Dati: 2.52MB + indice: 2.52MB + motore InnoDB wpgu_wc_admin_notes: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_wc_admin_note_actions: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpgu_wc_category_lookup: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_wc_customer_lookup: Dati: 1.52MB + indice: 0.89MB + motore InnoDB wpgu_wc_download_log: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpgu_wc_order_coupon_lookup: Dati: 0.23MB + indice: 0.31MB + motore InnoDB wpgu_wc_order_product_lookup: Dati: 3.52MB + indice: 6.06MB + motore InnoDB wpgu_wc_order_stats: Dati: 1.52MB + indice: 0.72MB + motore InnoDB wpgu_wc_order_tax_lookup: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpgu_wc_product_meta_lookup: Dati: 0.33MB + indice: 0.72MB + motore InnoDB wpgu_wc_reserved_stock: Dati: 0.06MB + indice: 0.00MB + motore InnoDB wpgu_wc_tax_rate_classes: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpgu_wc_webhooks: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpgu_wdi_feeds: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpgu_wdi_themes: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpgu_wfblockediplog: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_wfblocks7: Dati: 0.02MB + indice: 0.05MB + motore InnoDB wpgu_wfconfig: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_wfcrawlers: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_wffilechanges: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_wffilemods: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_wfhits: Dati: 0.02MB + indice: 0.05MB + motore InnoDB wpgu_wfhoover: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpgu_wfissues: Dati: 0.02MB + indice: 0.06MB + motore InnoDB wpgu_wfknownfilelist: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_wflivetraffichuman: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpgu_wflocs: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_wflogins: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpgu_wfls_2fa_secrets: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpgu_wfls_settings: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_wfnotifications: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_wfpendingissues: Dati: 0.02MB + indice: 0.06MB + motore InnoDB wpgu_wfreversecache: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_wfsnipcache: Dati: 0.02MB + indice: 0.05MB + motore InnoDB wpgu_wfstatus: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpgu_wftrafficrates: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_wpvivid_scan_result: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_wpvivid_unused_uploads_files: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_wsal_metadata: Dati: 0.05MB + indice: 0.03MB + motore InnoDB wpgu_wsal_occurrences: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpgu_wt_iew_action_history: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_wt_iew_cron: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_wt_iew_ftp: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_wt_iew_mapping_template: Dati: 0.02MB + indice: 0.00MB + motore InnoDB wpgu_yith_wcwl: Dati: 6.52MB + indice: 2.42MB + motore InnoDB wpgu_yith_wcwl_lists: Dati: 3.31MB + indice: 5.86MB + motore InnoDB wpgu_yoast_indexable: Dati: 4.48MB + indice: 1.19MB + motore InnoDB wpgu_yoast_indexable_hierarchy: Dati: 0.14MB + indice: 0.20MB + motore InnoDB wpgu_yoast_migrations: Dati: 0.02MB + indice: 0.02MB + motore InnoDB wpgu_yoast_primary_term: Dati: 0.02MB + indice: 0.03MB + motore InnoDB wpgu_yoast_seo_links: Dati: 0.02MB + indice: 0.03MB + motore InnoDB ### Post Type Counts ### attachment: 2726 blocks: 1 custom_css: 1 jetpack_migration: 2 jp_img_sitemap: 1 jp_sitemap: 1 jp_sitemap_master: 1 jp_vid_sitemap: 1 language_switcher: 3 nav_menu_item: 26 page: 14 popup: 2 popup_theme: 17 post: 3 product: 1058 product_variation: 495 revision: 1 shop_coupon: 124 shop_order: 12365 shop_order_refund: 20 wpcf7_contact_form: 2 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (23) ### Advanced Woo Search: by ILLID – 2.30 Code Snippets: by Code Snippets Pro – 2.14.1 Contact Form 7: by Takayuki Miyoshi – 5.4.1 GDPR Cookie Consent: by WebToffee – 2.0.3 Hide Categories Or Products On Shop Page: by Kaushik Nakrani – 1.0.3 – Versione installata non testata con versione attiva di WooCommerce 4.0 Insert Headers and Footers: by WPBeginner – 1.6.0 Smash Balloon Instagram Feed: by Smash Balloon – 2.9.1 Loginizer: by Softaculous – 1.6.7 Popup Maker: by Popup Maker – 1.16.1 SiteGround Optimizer: by SiteGround – 5.8.2 WooCommerce Order Test: by WP Fix It – 1.6 – Versione installata non testata con versione attiva di WooCommerce 4.0 WooCommerce PayPal Checkout Gateway: by WooCommerce – 2.1.1 (aggiornamento alla versione 2.1.2 disponibile) WooCommerce Stripe Gateway: by WooCommerce – 5.2.3 Woocommerce Gift Wrapper: by Little Package – 4.4.6 WooCommerce Google Analytics Integration: by WooCommerce – 1.5.1 Sendinblue - WooCommerce Email Marketing: by Sendinblue – 2.0.24 WooCommerce Shipping & Tax: by WooCommerce – 1.25.14 (aggiornamento alla versione 1.25.16 disponibile) WooCommerce: by Automattic – 4.8.0 (aggiornamento alla versione 5.4.1 disponibile) Importatore WordPress: by wordpressdotorg – 0.7 Yoast SEO: by Team Yoast – 16.5 WP Rollback: by Impress.org – 1.7.1 WPS Hide Login: by WPServeur NicolasKulka wpformation – 1.8.5 YITH WooCommerce Wishlist: by YITH – 3.0.23 ### Inactive Plugins (4) ### Google Tag Manager for WordPress: by Thomas Geiger – 1.13.1 Query Monitor: by John Blackbourn – 3.7.1 WP Activity Log: by WP White Security – 4.3.1 WP Activity Log for WooCommerce: by WP White Security – 1.2.2 ### Dropin Plugins (1) ### object-cache.php: Memcached ### Settings ### API Enabled: – Force SSL: – Currency: EUR (€) Currency Position: right 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 ### Shop base: #65 - /shop/ Carrello: #64 - /cart/ Pagamento: #63 - /checkout/ Il mio account: #62 - /my-account/ Termini e condizioni: #389 - /privacy-policy/ ### Theme ### Name: Flatsome Version: 3.13.3 Author URL: https://www.uxthemes.com/ Child Theme: ? – Se stai modificando WooCommerce o un tema genitore che non hai costruito personalmente ti consigliamo di utilizzare un tema child. Vedi: Come creare un tema child WooCommerce Support: ? ### Templates ### Overrides: flatsome/woocommerce/archive-product.php flatsome/woocommerce/cart/cart-empty.php flatsome/woocommerce/cart/cart-shipping.php flatsome/woocommerce/cart/cart.php flatsome/woocommerce/checkout/form-checkout.php flatsome/woocommerce/checkout/form-coupon.php flatsome/woocommerce/checkout/terms.php flatsome/woocommerce/checkout/thankyou.php flatsome/woocommerce/content-product-cat.php flatsome/woocommerce/content-product.php flatsome/woocommerce/content-single-product.php flatsome/woocommerce/content-widget-product.php flatsome/woocommerce/global/breadcrumb.php flatsome/woocommerce/global/quantity-input.php flatsome/woocommerce/global/wrapper-end.php flatsome/woocommerce/global/wrapper-start.php flatsome/woocommerce/loop/loop-end.php flatsome/woocommerce/loop/loop-start.php flatsome/woocommerce/loop/pagination.php flatsome/woocommerce/loop/result-count.php flatsome/woocommerce/loop/sale-flash.php flatsome/woocommerce/myaccount/form-login.php flatsome/woocommerce/myaccount/navigation.php flatsome/woocommerce/notices/error.php flatsome/woocommerce/notices/notice.php flatsome/woocommerce/notices/success.php flatsome/woocommerce/product-searchform.php flatsome/woocommerce/single-product/photoswipe.php flatsome/woocommerce/single-product/price.php flatsome/woocommerce/single-product/product-image.php flatsome/woocommerce/single-product/product-thumbnails.php flatsome/woocommerce/single-product/rating.php flatsome/woocommerce/single-product/related.php flatsome/woocommerce/single-product/review.php flatsome/woocommerce/single-product/sale-flash.php flatsome/woocommerce/single-product/share.php flatsome/woocommerce/single-product/short-description.php flatsome/woocommerce/single-product/tabs/tabs.php flatsome/woocommerce/single-product/title.php flatsome/woocommerce/single-product/up-sells.php flatsome/woocommerce/single-product-reviews.php flatsome/woocommerce/single-product.php flatsome/woocommerce/content-product_cat.php ### Action Scheduler ### Completato: 1.200 Oldest: 2021-06-11 12:28:11 +0000 Newest: 2021-07-12 06:22:04 +0000 In attesa: 1 Oldest: 2021-07-14 12:48:54 +0000 Newest: 2021-07-14 12:48:54 +0000Thanks!
Viewing 6 replies - 1 through 6 (of 6 total)
-
My settings:
https://ibb.co/L0xxfhz
https://ibb.co/pKzYWKwHi @dcka,
sorry for the delay in my answer, I just updated today Woocommerce to the latest version (5.5.1). I Will let you known in a couple of days if this update will solve our issue.
What I meant in my previous message was that I yet excluded all the services pages from caching.
Following my setup for the analytics section:
https://ibb.co/2d9Tbb9
Sorry if this section is displayed in Italian, if you will explain to me what is the best setting here I will apply it.Thanks again!
Sorry for the delayed response here, @callaghan22!
Can you let me know, have you already tried using the Google Tag Assistant to help with troubleshooting the numbers on Google Analytics? If you haven’t, I would highly recommend it as it should give you more detailed information on what may be going on. If you’re interested, we have more on that in this guide: Testing Analytics.
I’m also no longer able to view the screenshot you shared of your WooCommerce Analytics settings, but if you are using the default settings, that should be okay. For reference, the default settings look like this:
Link to image: https://d.pr/i/B6LDJ7Finally, for caching, again, please make sure that your Cart, Checkout and My Account pages are excluded.
Viewing 6 replies - 1 through 6 (of 6 total)
- The topic ‘Difference between Woocommerce total and Analytics’ is closed to new replies.
