Incorrect Content ID

Howdy @darrenn123

To help you further, I’d like to understand more about your setup.

Could you please send me 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 the text in https://gist.github.com/ and feel free to change/remove your site URL in the report for privacy reasons.

You can paste the Gist link here in your reply, once you have that.

this does seem to be the same cut and paste request to every issue, are you saying that a setup can concatenate ID & SKU, I dont see how that is possible as only what you request will get returned?

https://gist.github.com/Millby-furniture/16a32b1f75400cda7fd91e4e46fe6b96

Hi @darrenn123

Thanks for sharing the System Status Report.

the shop items are showing errors in facebook due to the contend ID being shown as contents “:”[{\”id\”:\”22537_38371\”,

Can you please share with us a clear screenshot of what you see on your end so that we could address you more effectively?

If you don’t already have a screenshot service installed, you can try https://snipboard.io or https://skitch.com/. You can share the direct link to the image as a response to this topic.

Additionally, if you could also provide the fatal error logs (if any) under WooCommerce > Status > Logs.

Thanks!

https://snipboard.io/BgQkA5.jpg

no fatal error logs, the screen shot is from our facebook commerce manager as retargeting cant match to products on the site due to the ID_SKU issue

Howdy @darrenn123

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

Can you manually delete the older copy of the product in?Facebook Business > Commerce > Catalogue?

Furthermore, the plugin now includes debug tools. Know more about them in the related documentation section, directly linked here.

Are you still experiencing this problem, after opting for Facebook: Reset all products, under Debug Tools? If so, could you provide more details about how to reproduce this? Thank you ??

there is no ‘older copy’ on facebook, all products are being synced from woocommer to facebook with the incorrect content ID as I have shown above.

woocommerce logs are showing a status of 200 OK which I would expect, its just the data that it is sending to facebook is incorrect!!!

Had reset products previous to contacting you

1. can you point me in the direction of where the code is that grabs the data to build the query that is sent to Facebook

2. also where the data is stored in the database so I can check there as well.

Hello,

https://snipboard.io/BgQkA5.jpg

Sorry for asking, I could not see the screenshot, ?? can you please upload it again? And keep it alive for some days while we check.

the shop items are showing errors in facebook…

And can you provide the error message that is shown on Facebook?

Thanks.

after doing some searching this is the issue I am experiencing in facebook erors

https://github.com/woocommerce/facebook-for-woocommerce/issues/1777

from a search this appears to be ongoing for around 2 years with no updates since November 2022

Hi there @darrenn123

Just to note, feel free to join in at the GitHub issue. Participation/feedback there is communicated directly to the development team, plus you’ll be simultaneously subscribed to receive updates on it.

I trust that points you in the right direction, but if you have more questions, let us know. We’re happy to help.

I have done a complete delete of database data relating to facebook, deleted all facebook products, done a complete resetup of the plugin and it is still not working.

I have had a look at the feed that is being sent to Facebook and it appears that somewhere within the building of the feed the data is being compiled with array_merge and this is joining the sku & product ID hence the underscore between the two values. can your developers look into this.

“content_ids”:”[\”21785_40291\”]”

I have also emailed facebook and the have confirmed that it is the feed coming to facebook and not anything their end.

The PHP array_merge function doesn’t join the SKU & product ID. Here’s the documentation on that function: https://www.php.net/manual/en/function.array-merge.php
 

I don’t have an estimated timeframe for how long it may be before a fix for this is released. As Facebook for WooCommerce is open-source you can view the bug report here: https://github.com/woocommerce/facebook-for-woocommerce/issues/1777

If you subscribe to the issue you will be notified by email directly whenever discussion or progress is made on the issue.

Please note that you will need to be logged into a GitHub account in order to subscribe. If you do not have an account you can create one for free.

Hi

I have sent a support request to woocommerce and had a generic response which summarises as we dont know when it will be fixed!

I have altered the code in fbutils.php around line 92 and the products are now showing up In facebook without the joined SKU_ID

This code is your original file fbutils.php

$fb_retailer_id = $woo_product->get_sku() ?

                                                       $woo_product->get_sku() . ‘_’ . $woo_id :

                                                       self::FB_RETAILER_ID_PREFIX . $woo_id;

and was showing as the link – https://snipboard.io/c4Xylm.jpg

I have ?changed to

$fb_retailer_id = $woo_product->get_sku() ?

                                                       $woo_product->get_sku() :

???????????????????????????????????????? ????????????? self::FB_RETAILER_ID_PREFIX . $woo_id;

it is now showing as required – https://snipboard.io/xKDAw0.jpg

Products are syncing to facebook and no errors showing in status logs, can this be investigated and if working correctly from your testing be published

That was copy/pasted here: https://github.com/woocommerce/facebook-for-woocommerce/issues/1777#issuecomment-1401137397