Google Analytics do not match with WooCommerce orders

Hi there!

Could you please send a copy of your site’s System Status? You can find it via WooCommerce > Status.

Select “Get system report” and then “Copy for support”. Once you’ve done that, you can paste it here.

Can you also take a screenshot of your settings under WooCommerce > Settings > Integration (you can blur out your “Google Analytics ID”).

### WordPress Environment ###

Home URL: https://www.xxxxxxxxxx.com
Site URL: https://www.xxxxxxxxxx.com
WC Version: 3.4.2
Log Directory Writable: ?
WP Version: 4.9.7
WP Multisite: –
WP Memory Limit: 768 MB
WP Debug Mode: –
WP Cron: ?
Language: en_GB
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 5.6.22 - We recommend using PHP version 7.2 or above for greater performance and security. How to update your PHP version
PHP Post Max Size: 100 MB
PHP Time Limit: 60
PHP Max Input Vars: 1000
cURL Version: 7.41.0
OpenSSL/1.0.2a

SUHOSIN Installed: –
MySQL Version: 5.7.14
Max Upload Size: 100 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 3.4.2
WC Database Prefix: ft14_
Total Database Size: 422.45MB
Database Data Size: 246.73MB
Database Index Size: 175.72MB
XXXX_woocommerce_sessions: Data: 1.02MB + Index: 0.02MB
XXXX_woocommerce_api_keys: Data: 0.02MB + Index: 0.00MB
XXXX_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB
XXXX_woocommerce_downloadable_product_permissions: Data: 0.19MB + Index: 0.28MB
XXXX_woocommerce_order_items: Data: 5.52MB + Index: 3.52MB
XXXX_woocommerce_order_itemmeta: Data: 25.56MB + Index: 23.06MB
XXXX_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB
XXXX_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB
XXXX_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB
XXXX_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB
XXXX_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB
XXXX_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB
XXXX_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB
XXXX_woocommerce_log: Data: 0.02MB + Index: 0.02MB
XXXX_ac_abandoned_cart_history_lite: Data: 0.11MB + Index: 0.00MB
XXXX_ac_email_templates_lite: Data: 0.02MB + Index: 0.00MB
XXXX_ac_guest_abandoned_cart_history_lite: Data: 0.02MB + Index: 0.00MB
XXXX_ac_sent_history_lite: Data: 0.02MB + Index: 0.00MB
XXXX_adtribes_my_conversions: Data: 0.02MB + Index: 0.02MB
XXXX_commentmeta: Data: 3.52MB + Index: 4.03MB
XXXX_comments: Data: 40.55MB + Index: 16.58MB
XXXX_cp_feeds: Data: 0.00MB + Index: 0.00MB
XXXX_itsec_distributed_storage: Data: 0.02MB + Index: 0.02MB
XXXX_itsec_lockouts: Data: 0.02MB + Index: 0.08MB
XXXX_itsec_log: Data: 1.02MB + Index: 0.03MB
XXXX_itsec_logs: Data: 2.02MB + Index: 0.09MB
XXXX_itsec_temp: Data: 0.02MB + Index: 0.06MB
XXXX_links: Data: 0.02MB + Index: 0.02MB
XXXX_options: Data: 5.08MB + Index: 2.02MB
XXXX_postmeta: Data: 113.64MB + Index: 89.20MB
XXXX_posts: Data: 10.52MB + Index: 9.06MB
XXXX_rg_form: Data: 0.02MB + Index: 0.00MB
XXXX_rg_form_meta: Data: 0.02MB + Index: 0.00MB
XXXX_rg_form_view: Data: 0.38MB + Index: 0.27MB
XXXX_rg_incomplete_submissions: Data: 0.00MB + Index: 0.00MB
XXXX_rg_lead: Data: 0.08MB + Index: 0.03MB
XXXX_rg_lead_detail: Data: 0.16MB + Index: 0.19MB
XXXX_rg_lead_detail_long: Data: 1.52MB + Index: 0.00MB
XXXX_rg_lead_meta: Data: 0.02MB + Index: 0.05MB
XXXX_rg_lead_notes: Data: 0.02MB + Index: 0.03MB
XXXX_termmeta: Data: 0.02MB + Index: 0.03MB
XXXX_terms: Data: 0.02MB + Index: 0.03MB
XXXX_term_relationships: Data: 0.14MB + Index: 0.08MB
XXXX_term_taxonomy: Data: 0.02MB + Index: 0.03MB
XXXX_usermeta: Data: 32.56MB + Index: 25.06MB
XXXX_users: Data: 2.52MB + Index: 1.55MB
XXXX_wc_download_log: Data: 0.06MB + Index: 0.03MB
XXXX_wc_webhooks: Data: 0.02MB + Index: 0.02MB
XXXX_woocommerce_shipping_table_rates: Data: 0.02MB + Index: 0.00MB
XXXX_woocommerce_shipping_zone_shipping_methods: Data: 0.02MB + Index: 0.00MB

### Post Type Counts ###

acf: 5
acf-field: 23
acf-field-group: 8
attachment: 143
mc4wp-form: 2
nav_menu_item: 9
page: 20
post: 47
product: 9
revision: 453
shop_coupon: 118
shop_order: 38157
shop_order_refund: 243

### Security ###

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

### Active Plugins (26) ###

Gravity Forms: by rocketgenius – 2.1.1
Advanced Custom Fields PRO: by Elliot Condon – 5.6.10
All In One SEO Pack: by Michael Torbert – 2.6.1
BackWPup: by Inpsyde GmbH – 3.6.0
iThemes Security: by iThemes – 7.0.2
Export User Data: by Q Studio – 1.3.1
Force Regenerate Thumbnails: by Pedro Elsner – 2.0.6
Google XML Sitemaps: by Arne Brachhold – 4.0.9
Instagram Feed: by Smash Balloon – 1.8.3
LeadDyno WordPress Plugin: by LeadDyno – 1.7
MailChimp for WordPress: by ibericode – 4.2.3
Mailgun: by Mailgun – 1.5.11
Cookie Consent: by Catapult_Themes – 2.3.11
Advanced Order Export For WooCommerce: by AlgolPlus – 1.5.5
WooCommerce Product Feed PRO: by AdTribes.io – 3.3.7
Abandoned Cart Lite for WooCommerce: by Tyche Softwares – 4.4 – Not tested with the active version of WooCommerce
WooCommerce Print Address Labels: by Ewout Fernhout – 1.3.4 – Not tested with the active version of WooCommerce
WooCommerce Checkout Field Editor: by WooCommerce – 1.5.13
WooCommerce Colors: by WooThemes – 1.0.7 – Not tested with the active version of WooCommerce
WooCommerce Currency Converter: by WooCommerce – 1.6.9 – 1.6.10 is available
WooCommerce PayPal Pro Hosted: by WooCommerce – 1.0.17
WooCommerce Google Analytics Integration: by WooCommerce – 1.4.4 – Not tested with the active version of WooCommerce
WooCommerce Table Rate Shipping: by WooCommerce – 3.0.9
WooCommerce: by Automattic – 3.4.2 – 3.4.3 is available
WooMobile: by Bowdie Mercieca – 1.2.4 – Not tested with the active version of WooCommerce
WP-Optimize: by David Anderson
Ruhani Rabin
Team Updraft – 2.2.4

### Settings ###

API Enabled: ?
Force SSL: ?
Currency: GBP (￡)
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)
featured (featured-2)
outofstock (outofstock)
outofstock (outofstock-2)
rated-1 (rated-1)
rated-2 (rated-2)
rated-2 (rated-2-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-4 (rated-4-2)
rated-5 (rated-5)
rated-5 (rated-5-2)

### WC Pages ###

Shop base: #6 - /shop/
Basket: #7 - /basket/
Checkout: #8 - /checkout/
My account: #9 - /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: 
Version: – 0 is available
Author URL: 
Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build
personally we recommend using a child theme. See: How to create a child theme

WooCommerce Support: ?

### Templates ###

Archive Template: Your theme has a woocommerce.php file. You will not be able to override the woocommerce/archive-product.php custom template since woocommerce.php has priority over archive-product.php. This is intended to prevent display issues.
Overrides: xxxxxxxxxx/woocommerce/emails/customer-completed-order.php
xxxxxxxxxx/woocommerce/emails/email-footer.php

Thanks Zach, unfortunately I don’t know how to attach a jpeg of the settings for you take a look at.

The options that are ticked are:
Enable Standard Tracking
Enable Universal Analytics
Purchase Transactions
Add to Cart Events

None of the other options are ticked. The tracking code looks fine and in set domain name its www.xxxxxxxx.com

• This reply was modified 6 years, 4 months ago by cannon303.

Thanks for that info!

Can you also send the System Status report? More info on that here: https://docs.woocommerce.com/document/understanding-the-woocommerce-system-status-report/

None of the other options are ticked. The tracking code looks fine and in set domain name its https://www.xxxxxxxx.com

Unless that’s the site domain, and/or you only have one site connected to your Google Analytics account, you should have your domain name set there (more info here: https://developers.google.com/analytics/devguides/collection/gajs/gaTrackingSite#multipleDomains).

sorry yes the domain is set in there

I did post a status report but it is being held for moderation:

“This post has been held for moderation by our automated system and will be manually reviewed by a moderator.”

ok I think the status report is now showing in this thread.

Thanks!

When I try to visit https://www.xxxxxxxxxx.com it redirects me to a twitter page and specific tweet. Can you remove that redirect then test to see if things work the way they should (may take a day or two to verify).

I’d also make sure you update WooCommerce to version 3.4.3, and any other plugins that need updating (make sure you have a full backup before attempting).

flip, nooo, that’s not the actual web address, i didn’t put the real address here as I didn’t want to show the full status of my clients website for security purposes. Blimey sorry, that’s quite a dodgy tweet. Just seen it. I didn’t realise you actually needed to view the site.

Oh, what a strange coincidence! I was wondering why in the world that re-direct showed up and why a legitimate domain would be specified as such. ??

Some days GA will report more or less purchases than there are in Woo

Do you only use PayPal Pro Hosted for your Payment Gateway, or do you have other options setup?

I ask because if you’re using a few optios it’s possible that some of the purchases are missing depending on the payment type/method used.

and more purchases of product A than there should be and less purchases of product B than there should be.

Have you checked this against refunds, etc?

At this point, I’d suggest opening a ticket here: https://www.woocommerce.com/my-account/tickets/ so we can ask for a bit more information and dig into what’s happening here. You can reference this thread link in the ticket you open. Thanks!

We use the standard PayPal set up with Woo and we use PayPal Pro Hosted for payment gateways. Apparently overall the discrepancy between the number of orders can possibly be explained away, there seems to be a difference in timezones between our wordpress settings and GA. WordPress is set correctly to BST or GMT+1 while GA is set to GMT. Over the course of a month we are only seeing a difference of one order between Woo (654) and GA(655). Possibly a refund as you mentioned could also be a contributing factor. The number of products bought are way out though, so in Woo we have 1032 products bought while GA we only have 994 products bought. I doubt a difference in timezones and / or refunds could cause that much difference between the two sets of data.

• This reply was modified 6 years, 4 months ago by cannon303.

Thanks for that info!

The timezone difference would absolutely explain the difference of one order. Did the previous month’s orders have one more (or the following month’s)?

As for the products, do you sell only simple products on the site, or variable products and other types of products? Can you give us a breakdown of the types of products you sell if they’re not all either simple and variable? From the plugin list, it looks like you should only be selling simple and/or variable products, without other more complex products (bundles, composites, bookings, etc.), but if you can confirm that for us, that’d be great!

It’s hard to tell regarding timezones because GA could on one day subtract say 2 orders and list those as the day before while including 6 orders that should have been recorded for the day after and then on the next day do something completely different that’s makes it hard to track down. I sampled 4 days and going by what products we sold it did give me cause to consider the timezones as a possibility but remained inconclusive.

As for types of products, there are just 5 simple products, no variations, no bundles and nothing complex.

Thanks for that info!

The number of products bought are way out though, so in Woo we have 1032 products bought while GA we only have 994 products bought.

Did you check that against what had been refunded? The difference is only 38 products, so that may be the case.

Otherwise, do you know the breakdown of products purchased in orders paid with the PayPal Standard option, and ones purchased in orders paid with the PayPal Pro Hosted option?

Without getting a good look at the info, it’s hard for us to diagnose the issue.

Howdy @cannon303! Wondering if there is any update on this?