“Invalid site URL” during “Set up your account”

Hello @muckaveli,

Thank you for reaching out!

Have you tried reinitializing the connection?

Here’s how:

1. Go to https://mysite.com/wp-admin/admin.php?page=connection-test-admin-page
2. Under Merchant Center, click MC Disconnect
3. Under Google Account, click Disconnect Google Account
4. Under Jetpack, click Disconnect Jetpack

Next, go to Marketing > Google Listings & Ads and set up the connection again. :?)

Let us know how it goes!

Hey @babylon1999, thank you for your reply.

I didn’t know the connection-test admin site nor that jetpack was of any significance in all of this. However, I’ve found out that – due to me copying my WordPress installation into a dev-enviroment – Jetpack thought my domain was https://dev.domain.com instead of https://domain.com. I’ve spent quite some time to correct that and Jetpack is now configured with the correct domain, but it DID NOT change the “Invalid Site URL” problem for me.

The whole process included dis- and reconnecting everything as you suggest, without any success.

If I hit “Or, create a new Merchant Center account” I get a prompt “You already have another verified account,?Name, which is connected to this store’s URL,?https://domain.com.” – this make’s it even harder to understand why the URL should be invalid.

What shall I do next? Thanks.

• This reply was modified 1 year, 3 months ago by muckaveli.

What shall I do next? Thanks.

Could you please attach a copy of your site’s System Status report? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support” (after you scroll down a bit)”. Once done, please paste it here in your reply or via a text-sharing service like https://gist.github.com/.

Also, please check if there are any fatal/plugin-related error logs.?

Here’s a quick guide on how to do that:

• Go to WooCommerce > Status > Logs.
• In the upper right corner, you’ll find a drop-down menu.
• Search for the keywords “fatal” and “Google”.
• This should display the relevant logs we’re looking for. If you find any, please select each log one by one and click view.
• You can then copy & paste them here, or use a text-sharing app like GitHub Gist or Pastebin.

Link to image: https://d.pr/i/Rhd6La

Look forward to hearing back from you.

@babylon1999 thank you for your reply.

Status Report
I’ve created a gist. Can I somehow send it to you without posting it in public? Thanks.

Fatal Logs:
* Changed my actual domain to “domain.com“

2023-09-06T19:17:26+00:00 CRITICAL Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.wp_post_id' in 'field list' in /var/www/vhosts/domain.com/httpdocs/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:59
Stack trace:
#0 /var/www/vhosts/domain.com/httpdocs/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(59): PDOStatement->execute()
#1 /var/www/vhosts/domain.com/httpdocs/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(495): MailPoetVendor\Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/vhosts/domain.com/httpdocs/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(375): MailPoetVendor\Doctrine\DBAL\Connection->executeQuery()
#3 /var/www/vhosts/domain.com/httpdocs/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(386): MailPoetVe in /var/www/vhosts/domain.com/httpdocs/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 59



2023-09-01T06:46:37+00:00 CRITICAL Uncaught Error: Call to a member function getStaticEvents() on null in /var/www/vhosts/domain.com/httpdocs/wp-content/plugins/pixelyoursite/modules/facebook/facebook.php:428
Stack trace:
#0 /var/www/vhosts/domain.com/httpdocs/wp-content/plugins/pixelyoursite/includes/class-events-manager.php(152): PixelYourSite\Facebook->outputNoScriptEvents()
#1 /var/www/vhosts/domain.com/httpdocs/wp-includes/class-wp-hook.php(308): PixelYourSite\EventsManager->outputNoScriptData()
#2 /var/www/vhosts/domain.com/httpdocs/wp-includes/class-wp-hook.php(332): WP_Hook->apply_filters()
#3 /var/www/vhosts/domain.com/httpdocs/wp-includes/plugin.php(517): WP_Hook->do_action()
#4 /var/www/vhosts/domain.com/httpdocs/wp-includes/general-template.php(3065): do_action()
#5 /var/www/vhosts/domain.com/httpdocs/wp-includes/template-canvas.php(25): wp_footer()
#6 /var/www/vhosts/domain.com/httpdocs/wp-includes/template-loader.php(106): include('/var/www/vhosts...')
#7 /var/www/vhosts/domain.com/httpdocs/wp-blog-header.php(19): requir in /var/www/vhosts/domain.com/httpdocs/wp-content/plugins/pixelyoursite/modules/facebook/facebook.php on line 428

Google Logs:

2023-09-05T19:46:18+00:00 ERROR Automattic\WooCommerce\GoogleListingsAndAds\Notes\NoteInitializer::add_notes Merchant Center account is not set up.

2023-08-08T16:08:24+00:00 ERROR Automattic\WooCommerce\GoogleListingsAndAds\Notes\NoteInitializer::add_notes Google account is not connected.

Hi there @muckaveli ??

Thank you for reaching back, with further information on this.

The Google logs reveal that Merchant Center account is not set up, as of September 5.

Could you go ahead with reinitializing the connection, per my colleague’s instructions above, and see how that goes, please?

While the fatal logs point to issues with the pixelyoursite and mailpoet plugins.

Status Report
I’ve created a gist. Can I somehow send it to you without posting it in public? Thanks.

Feel free to redact the site’s URL, then paste it into our https://Quickforget.com service and send that secret link here.

Once I hear back from you, I will be happy to investigate this further.

Thanks @anastas10s , here is the quicktoforget-link containing the lo.

I’m not sure if you are aware that I already did follow your colleague’s instructions above?

Disconnecting all these accounts

• MC diconnected
• Google disconnected
• Jetpack didn’t work on that page but via MyJetpack. Jetpack disconnected

Not being able to re-connect Jetpack or WordPress

When I went directly back to Google Listings & Ads “Set Up Your Account”, I wasn’t able to connect WordPress.com due to “Unable to connect your WordPress.com account. Please try again later.”.

I went back trying to re-connect Jetpack in MyJetpack and it stated “An error occured. Please try again.”

Going to https://domain.com/wp-admin/admin.php?page=connection-test-admin-page&action=connect&_wpnonce=52f029a046 leads to a “502 Bad Gateway”

“Testing WCS Connection” resulted in Jetpack User: “Connected with another user account”. With a GET response “{“statusCode”:401,”error”:”Unauthorized”,”message”:”Invalid credentials”,”attributes”:{“error”:”Invalid credentials”}}”.

MyJetpack then stated “site connected, user account NOT connected”. Clicking “connect” resulted in “Unfortunately, an unexpected error has occurred”.

I was able to finally reconnect Jetpack with WordPress using https://wordpress.com/jetpack/connect and entering my domain there.

Trying to re-connect Google Listings & Ads (“Set up your accounts”)

• WordPress.com : connected
• Google : connected
• Merchant Center (select an existing account) : Invalid Site URL ??

• This reply was modified 1 year, 2 months ago by muckaveli.
• This reply was modified 1 year, 2 months ago by muckaveli.
• This reply was modified 1 year, 2 months ago by muckaveli.
• This reply was modified 1 year, 2 months ago by muckaveli.
• This reply was modified 1 year, 2 months ago by muckaveli.

Hello @muckaveli,

I tried to ping your site’s Jetpack connection, but something is blocking the request.

Could you please perform a full conflict test to make sure this is not caused by another plugin/theme?
 
Here’s a quick guide on how to do this:

• Temporarily switch your theme to Storefront
• Disable all plugins except for WooCommerce / Google Listings & Ads
• Repeat the action that is causing the problem

If you’re not seeing the same problem after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated. To figure out which plugin is causing the problem, reactivate your other plugins one by one, testing after each, until you find the one causing conflict. You can find a more detailed explanation on how to do a conflict test here.

Let us know how it goes!

@babylon1999

• I’ve installed the plugin “WP Staging” to create another staging version.
• In that staging version (mydomain.com/staging_version), I deactivated all plugins except for WooCommerce / Google Listings & Ads.
• In “Set up your accounts” WordPress.com and Google were already marked connected.
• Trying to connect Google Merchant Center resulted in “This Merchant Center account already has a verified and claim URL, mydomain.com”.

How that possible if mydomain.com states “Invalid site URL.”?

Did I do the conflict test right, or do I have to really use the live version to do it effectively? Thank you.

@babylon1999 I did the whole conflict test to my live version:

• WordPress: Connected
• Google: Connected
• Merchant Center hitting “connect” resulted in: “Unable to insert site verification: The necessary verification token could not be found on your site.”
• /wp-admin/admin.php?page=connection-test-admin-page > MC Connection Status:

Response: {
    "id": xxxxxxxx,
    "status": "incomplete",
    "step": "verify"
}

MC Account Setup:

Request:  POST /wc/gla/mc/accounts
Status:   400
Response: {
    "message": "Unable to insert site verification: The necessary verification token could not be found on your site.",
    "errors": {
        "badRequest": "The necessary verification token could not be found on your site."
    }
}

Hi @muckaveli

From the test connection tab (“domain.com”/wp-admin/admin.php?page=connection-test-admin-page) could you please try clicking on the “Reclaim URL” button and try connecting once more? Let us know how that goes.

@theabhig

Please see the attachment and let me know which one exactly you mean (since “reclaim URL” isn’t listed): https://imgur.com/a/XYsvmvY

• This reply was modified 1 year, 2 months ago by muckaveli.
• This reply was modified 1 year, 2 months ago by muckaveli.
• This reply was modified 1 year, 2 months ago by muckaveli.

Hi @muckaveli

Thanks for the screenshot, and apologies about the confusion. It should have been “Claim overwrite”. If you could try that please and then reconnecting, let us know how that goes.

@theabhig this is the response of “claim overwrite”

Response
Request:  POST /wc/gla/mc/accounts/claim-overwrite
Status:   400
Response: {
    "message": "Attempting invalid claim overwrite.",
    "id": xxxxxxxxx
}

What should I try next?

3 weeks later, I was finally able to solve this whole problem by accident.

My WordPress installation is finally connected to Google Merchant Center and this thread can be closed!

Troubleshooting

• /wp-admin/site-health.php kept telling me that there was a connection error with Jetpack (code 200), even though My-Jetpack stated that it was connected. Weird.
• I decided to deactivate all of my 44 plugins, refreshed site-health.php and the connection-error-message was gone
• Next I re-activated all of my plugins one at a time, while refreshing my site-health.php until the error came up again
• This way I’ve found out that it was caused by Make Paths Relative, a plugin I used to do just that. Somehow it seems to block Jetpacks connection and apparently also Google’s.
• Once Jetpack could connect successfully, I went over to Marketing > Google Listings & Ads and could establish the connection to the Merchant Center immediately without further trouble!

Lesson of the day

Whenever installing a new plugin, head immediately over to /wp-admin/site-health.php to see if it does anything to your WordPress installation that is resulting in errors that haven’t been there before.

I am glad to hear you were able to resolve this @muckaveli – great work with your own troubleshooting.

I’ll mark this as resolved but do let us know if we can help with anything else.