Zach H

Hi @bbqbrian

Thanks for the update! Do let us know if you find a solution.

I’ll mark this thread as resolved now.

Hi @bbqbrian

Thanks for reaching out to the Forums for support on this error message.
>“Specified key was too long; max key length is 767 bytes

I’ve searched for any other reports of this and do find some instances of this error, but not specific the the Google Listings and Ads plugin.

This article: https://stackoverflow.com/questions/1814532/mysql-error-1071-specified-key-was-too-long-max-key-length-is-767-bytes
indicates that the problem is with the database schema that doesn’t support InnoDB MySQL 5.6.

If that isn’t helpful, Please contact us at WooCommerce.com > My Account > Support. You may need to create an account before you can access that page.

Please include a link to this forum thread, so that we can keep track of what’s already been done.

We will be able to help you further there.

Hi @purewhitetail

Thanks for reaching out for WooCommerce Payments support. I’m sorry you are having a frustrating experience. I’ve tracked down your ticket and WooCommerce Payments account and will respond to you there for security purposes.

Hi @pallavichanodia

Thanks for your reply to this Facebook for WooCommerce support thread.

I am facing similar issue. “Same event ID received for many event instances"
I have only facebook for WooCommerce plugin and WP Rocket plugin. Have excluded below file from javascript minification and delay
https://connect.facebook.net/en_US/fbevents.js
Can you please suggest some solution?

Please contact us at WooCommerce.com > My Account > Support. You may need to create an account before you can access that page.

Please include a link to this forum thread, so that we can keep track of what’s already been done.

We will be able to help you further there.

Hi @colyz93

Thanks for the reply!

>Yes it seems to be the problem Wp-Rocket is affecting it
Now events manager in counting orders Purchase Event but it is not counted by Ads for some reason i believe the problem is with something called External ID and is not syncing Value for some reason

Okay, it sounds like you are on the troubleshooting track with WP-Rocket.

If you need further assistance, please contact us at WooCommerce.com > My Account > Support. You may need to create an account before you can access that page.

Please include a link to this forum thread, so that we can keep track of what’s already been done.

We will be able to help you further there.

Hi @harakiro

Thanks for reaching out for Facebook for WooCommerce support!

>I had installed this plugin and later removed it. But Facebook still shows that it is connected to woocommerce and now has orders I’m unable to process due to this.

I’m sorry this is happening on your site. Let’s get this resolved ASAP!

To clear the Facebook details from your site, navigate to your WordPress options page https://YOURSITE.com/wp-admin/options.php (be sure to have a backup of the site, and only edit the following fields)

In here please clear the value for the following fields:

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

If it does not show these fields, or if the fields are blank, that will be fine.

If you need further assistance, Please contact us at WooCommerce.com > My Account > Support. You may need to create an account before you can access that page.

Please include a link to this forum thread, so that we can keep track of what’s already been done.

We will be able to help you further there.

Hi @dadisk8

I’m sorry you are having problems with the Facebook for WooCommerce extension.

Please contact us at WooCommerce.com > My Account > Support. You may need to create an account before you can access that page.

Please include a link to this forum thread, so that we can keep track of what’s already been done.

We will be able to help you further there.

Hi @kirstensmitcreative

Thanks for reaching out about the multi currency error with WooCommerce Payments.

We’ve recently released a new multi-currency switching feature as part of WooCommerce Payments! I can see there have been reports of this is error and it is currently being fixed by our developers.

The current version of WooCommerce Payments is v2.8.2. The fix multi-currency fix should be included in the next WooCommerce Payments release, likely v2.8.3.

Hi @clicksajjad

Thanks for reaching out for Facebook for WooCommerce support!

>We are using WooCommerce Currency Switcher. We have PKR and USD as currencies.
Our default currency is PKR but when products are transferred to Facebook catalog. The currency is USD. I can’t find any solution. Do you have any fix for this problem?

We’ve found that sometimes, because the sync is called from the server-side as a background task, the multi-currency plugin can choose the wrong currency. I’ve confirmed that PKR is an accepted currency on the Facebook platform, so that’s not a problem.

I can suggest a workaround to force the currency for all Facebook products with the following gist:
https://gist.github.com/simonporter007/ef6b08b71dbc4432b6af469aefc557b3#file-sv_fb_for_woocommerce_hardcode_currency_for_all_products-php

In that example, the currency is ZAR so you’ll want to modify it to use PKR.

Add the snippet to your theme’s functions.php file. Please let us know the results!

Let us know if you have any questions!

Hi @tniron

Thanks for reaching out for Facebook for WooCommerce support.

>Facebook perceives this as an error as prices are not set for some variants. I identify these products and mark them as out of stock on my own system. Do I need to do anything else? does your plugin automatically send these new settings?

There should be an product sync feature that can be enabled/disabled
>Enable product sync – Use this to disable product syncing entirely.

You can manually trigger the product sync via the Marketing > Facebook > Product Sync tab by clicking the Sync products button.

Please let us know if you have any questions!

Hi @sagraphics

Please contact us at WooCommerce.com > My Account > Support. You may need to create an account before you can access that page.

Please include a link to this forum thread, so that we can keep track of what’s already been done.

We will be able to help you further there.

Hi @dyslexicdrakness

Thanks for reaching out with your Facebook for WooCommerce Question.

Currently, the “PageView” still only be sent via browser (navigator). And based on the Facebook development doc, it’s fine to send an event only from one of browser and server sides, even it can send different events separately from the browser or server according to scenario.

Please let us know if you have any questions!

Hi @tniron

It really helps out the community that you’ve followed up with the cause of the error. Thanks for the update!

Hi @bugun,

>So the product must stay at the discounted price for 30 days?

I believe what my colleague is saying is that NEW products take time to propagate through the system. The product needs to be available in Google Listings for 30 days before a sale badge can be applied.

>So you need to wait 30 days in normal and discounted price?

The ad framework can take a few days to a couple of weeks to reflect product changes. You can apply a sale update and you don’t have to leave the sale price for 30 days if the product has been in the system for 30 days, but it can take time to reflect the changes in the Google Listings/Ads.

Please let us know if you have any questions!

Hi @juliusglusakovas

Thanks for reaching out about the conditional tags problem with the customized success.php template.

This is a fairly complex development topic. I’m going to leave it open for a bit to see if anyone is able to chime in to help you out. I can also recommend the WooCommerce Developer Resources Portal for resources on developing for WooCommerce. You can also visit the WooCommerce Facebook group or the #developers channel of the WooCommerce Community Slack. We’re lucky to have a great community of open-source developers for WooCommerce, and many of our developers hang out there, as well.