Facebook for Woocommerce keeps trying to connect to the wrong page

Hi @cleftune ,

It seems that on your site, some entries of the Facebook extension are being left over in the database which is why you’re getting connected to the old account/page.

I’d recommend the following:

– Take a backup of your site
– Go to the database of the site (you can do so through your hosting’s control panel, or you can use plugins like WP PhpMyAdmin)
– Go to wp_options table in the database
– Search for “facebook”
– Delete all Facebook related entries that you see in search
– Re-install the Facebook for WooCommerce extension and connect it with the new page.

Do let us know how that goes and if you need any further help from us.

Hi,

I deleted all instances in that table, but still not successful. I uninstall the plugin and reinstalled the plugin again after the database deletion, but I am still getting the same error.

Thanks

Hi @cleftune,

Try to do it from the /options.php area of your site (ex: https://yoursite.com/wp-admin/options.php).

The fields that need to be cleared are the following:

wc_facebook_external_business_id?
wc_facebook_system_user_id?
wc_facebook_business_manager_id
?wc_facebook_merchant_access_token?
wc_facebook_page_access_token
?wc_facebook_page_id?
wc_facebook_pixel_id

After this is done, disable Facebook under Plugins > All Plugins, then re-enable and try to reconnect from scratch. Let us know if this works!

Hi,

Now I am getting the following error when trying to connect the store:

Something went wrong.
This may be because of a technical error that we’re working to get fixed. Try reloading this page.

Hi there @cleftune

Now I am getting the following error when trying to connect the store:

Something went wrong.
This may be because of a technical error that we’re working to get fixed. Try reloading this page.

That’s not good ??

I think we need to remove the old data completely from WordPress database and initiate a new fresh connection.

Next Steps: Remove FB for WooCommerce from Database

What we want to do next is to completely remove the Facebook for WooCommerce data stored in your WordPress database.

– First of all, please backup your database [Important]

– Deactivate Facebook for WooCommerce

– Please navigate to your phpMyAdmin page, you might want to ask your host if you’re not sure, and then navigate to the SQL section and paste the code below into the white box, lastly please click Go:

Link to image: https://d.pr/3iYHSw

Click for the code to paste.

Sidenote: Sometimes some WordPress database has a unique table prefix, the most common prefix is wp, so the table will start like wp_options, but if your database has a different prefix, please ensure to adjust accordingly the above code.

Once, the above data removal is completed, please reactivate Facebook for WooCommerce and then go back to Marketing > Facebook, and click Get Started.

I hope that helps!

It worked! Thanks