Facebook Woocommerce product sync

  • Unknown's avatar
    coedwigcreations · Member ·

    Hi,

    I have successfully installed a Facebook Pixel to my website but my products will not sync to my Facebook catalogue.

    Facebook states that the pixel’s microdata is incomplete or incorrectly formatted but this is not the case.

    Here is my wordpress status report: 

    
### WordPress Environment ###

WordPress address (URL): https://www.coedwigcreations.co.uk
Site address (URL): https://www.coedwigcreations.co.uk
WC Version: 5.8.0
REST API Version: ✔ 5.8.0
WC Blocks Version: ✔ 5.9.1
Action Scheduler Version: ✔ 3.3.0
WC Admin Version: ✔ 2.7.2
Log Directory Writable: ✔
WP Version: 5.8.1
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: –
Language: en_US
External object cache: –

### Server Environment ###

Server Info: LiteSpeed
PHP Version: 7.4.24
PHP Post Max Size: 64 MB
PHP Time Limit: 0
PHP Max Input Vars: 1000
cURL Version: 7.71.0
OpenSSL/1.1.1d

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.5.12-MariaDB-cll-lve
Max Upload Size: 64 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

### Database ###

WC Database Version: 5.8.0
WC Database Prefix: wpwo_
Total Database Size: 50.87MB
Database Data Size: 47.84MB
Database Index Size: 3.03MB
wpwo_woocommerce_sessions: Data: 0.50MB + Index: 0.02MB + Engine InnoDB
wpwo_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpwo_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpwo_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpwo_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpwo_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpwo_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpwo_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpwo_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpwo_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpwo_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpwo_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpwo_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpwo_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpwo_actionscheduler_actions: Data: 0.13MB + Index: 0.13MB + Engine InnoDB
wpwo_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpwo_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpwo_actionscheduler_logs: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
wpwo_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpwo_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wpwo_irecommendthis_votes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpwo_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpwo_litespeed_url: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpwo_litespeed_url_file: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpwo_masterslider_options: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
wpwo_masterslider_sliders: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpwo_options: Data: 7.47MB + Index: 0.14MB + Engine InnoDB
wpwo_postmeta: Data: 21.52MB + Index: 0.56MB + Engine InnoDB
wpwo_posts: Data: 16.52MB + Index: 0.23MB + Engine InnoDB
wpwo_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wpwo_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpwo_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpwo_revslider_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpwo_revslider_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpwo_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpwo_sg_action: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpwo_sg_config: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpwo_sg_schedule: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpwo_statistics_exclusions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpwo_statistics_historical: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpwo_statistics_pages: Data: 0.06MB + Index: 0.17MB + Engine InnoDB
wpwo_statistics_search: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpwo_statistics_useronline: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpwo_statistics_visit: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpwo_statistics_visitor: Data: 0.20MB + Index: 0.31MB + Engine InnoDB
wpwo_statistics_visitor_relationships: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpwo_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpwo_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpwo_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpwo_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpwo_usermeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wpwo_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpwo_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpwo_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpwo_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpwo_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpwo_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpwo_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpwo_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpwo_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpwo_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpwo_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wpwo_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpwo_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpwo_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpwo_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpwo_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

attachment: 327
custom_css: 1
customize_changeset: 12
nav_menu_item: 28
page: 15
portfolio: 1
post: 3
product: 54
product_variation: 32
revision: 454
shop_coupon: 2
shop_order: 8
shop-page-wp: 2
sp_wps_shortcodes: 3
wpcf7_contact_form: 1

### Security ###

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

### Active Plugins (26) ###

Advanced Product Fields for WooCommerce: by StudioWombat – 1.4.1
Advanced WordPress Reset: by Younes JFR. – 1.1.1
Backup: by BackupGuard – 1.6.8.1
BE GDPR Compliance: by Brand Exponents – 1.1.4
BE Portfolio Post: by Brandexponents – 1.1
Color Hub: by Brand Exponents – 1.0.7
Contact Form 7: by Takayuki Miyoshi – 5.5.1
Easy WP SMTP: by wpecommerce
alexanderfoxc – 1.4.7

Facebook for WooCommerce: by Facebook – 2.6.5
Facebook Chat Plugin - Live Chat Plugin for WordPress: by Facebook – 2.2
LiteSpeed Cache: by LiteSpeed Technologies – 4.4.3
Master Slider Pro: by averta – 3.2.7
Meta Box Conditional Logic: by MetaBox.io – 1.6.4
Meta Box Show Hide: by MetaBox.io – 1.1.0
Meta Box Tabs: by MetaBox.io – 1.1.1
Oshine Core: by brandexponents team – 1.5.5
Oshine Modules: by Brand Exponents – 3.2.7
Slider Revolution: by ThemePunch – 5.4.8.1
Tatsu: by Brand Exponents – 3.3.7
Type Hub: by Brand Exponents – 2.0.6
Under Construction: by WebFactory Ltd – 3.89
Product Slider for WooCommerce: by ShapedPlugin – 2.3.4
WooCommerce Google Analytics Integration: by WooCommerce – 1.5.3
WooCommerce: by Automattic – 5.8.0
WordPress Importer: by wordpressdotorg – 0.7
WP Statistics: by VeronaLabs – 13.1.1

### Inactive Plugins (2) ###

PHP Compatibility Checker: by WP Engine – 1.5.2
WooCommerce Shipping & Tax: by WooCommerce – 1.25.19

### Dropin Plugins (1) ###

maintenance.php: maintenance.php

### 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)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: ✔

### WC Pages ###

Shop base: #3079 - /shop/
Cart: #2695 - /cart-2/
Checkout: #3416 - /my-account-2-2/
My account: ❌ Page visibility should be public
Terms and conditions: ❌ Page not set

### Theme ###

Name: Oshin Child
Version: 1.0
Author URL: 
Child Theme: ✔
Parent Theme Name: Oshin | Shared By Themes24x7.com
Parent Theme Version: 6.6.2
Parent Theme Author URL: http://www.brandexponents.com/
WooCommerce Support: ✔

### Templates ###

Overrides: –

### Action Scheduler ###

Complete: 291
Oldest: 2021-09-22 16:28:12 +0000
Newest: 2021-10-19 15:10:38 +0000

Pending: 2
Oldest: 2021-10-19 15:25:38 +0000
Newest: 2021-10-25 15:05:27 +0000

### Status report information ###

Generated at: 2021-10-19 15:18:41 +00:00

    Here is the most recent log file after enabling de-bugging and updating a product:

    
10-19-2021 @ 15:17:48 - Request
Request
method: GET
uri: https://graph.facebook.com/v11.0/5228041203891210?fields=name
user-agent: Facebook-for-WooCommerce/2.6.5 (WooCommerce/5.8.0; WordPress/5.8.1)
headers: Array
(
    [Authorization] => *****************************************************************************************************************************************************************************************************************************
    [content-type] => application/json
    [accept] => application/json
)
body:
duration: 0.07684s

10-19-2021 @ 15:17:48 - Response
Response
code: 200
message: OK
headers: Array
(
    [etag] => "979240f7923d62ed4ffc6c4f28eaef0f3fc6fafa"
    [content-type] => application/json
    [vary] => Origin
    [x-business-use-case-usage] => {"5228041203891210":[{"type":"ads_management","call_count":1,"total_cputime":1,"total_time":1,"estimated_time_to_regain_access":0}]}
    [x-fb-rlafr] => 0
    [access-control-allow-origin] => *
    [facebook-api-version] => v11.0
    [strict-transport-security] => max-age=15552000; preload
    [pragma] => no-cache
    [cache-control] => private, no-cache, no-store, must-revalidate
    [expires] => Sat, 01 Jan 2000 00:00:00 GMT
    [x-fb-request-id] => AHkwvnr5kkk9aYVZs3xhCv_
    [x-fb-trace-id] => GxPzGgznTU9
    [x-fb-rev] => 1004577317
    [x-fb-debug] => ymeohbbqwfh6hw4LnsjmZcBJmYv5/tksN4iVhy6ndlRgw3dW1p8vL+vN2PW6oRIbROZCH+BJGLou2pSOwIu6zQ==
    [date] => Tue, 19 Oct 2021 15:17:48 GMT
    [alt-svc] => h3=":443"; ma=3600, h3-29=":443"; ma=3600,h3-27=":443"; ma=3600
    [content-length] => 61
)
body: {"name":"Coedwig Creations Products","id":"5228041203891210"}

10-19-2021 @ 15:18:20 - Request
Request
uri: https://graph.facebook.com/v11.0/catalog:5228041203891210:d2NfcG9zdF9pZF80MjA0/?fields=id,product_group{id}
headers: Array
(
    [Authorization] => *****************************************************************************************************************************************************************************************************************************
)
timeout: 500

10-19-2021 @ 15:18:20 - Response
Response
code: 400
message: Bad Request
headers: Array
(
    [vary] => Origin
    [cross-origin-resource-policy] => cross-origin
    [x-app-usage] => {"call_count":32,"total_cputime":0,"total_time":5}
    [x-fb-rlafr] => 0
    [content-type] => application/json; charset=UTF-8
    [www-authenticate] => OAuth "Facebook Platform" "invalid_request" "(#100) Could not find Product Item for catalog id 5228041203891210, retailer id wc_post_id_4204"
    [access-control-allow-origin] => *
    [facebook-api-version] => v11.0
    [strict-transport-security] => max-age=15552000; preload
    [pragma] => no-cache
    [cache-control] => no-store
    [expires] => Sat, 01 Jan 2000 00:00:00 GMT
    [x-fb-request-id] => ALjdiKZ9Gyrg8mWOOsnw__V
    [x-fb-trace-id] => H4D4te8qiE3
    [x-fb-rev] => 1004577317
    [x-fb-debug] => hklgPZc3zdOF28jCPhw3+HJARInA4CWTbGGiTPonpDkzoGCkkiwDXbobKXzW4cJFz5KleJXsuqqaqeN3cVA4Wg==
    [date] => Tue, 19 Oct 2021 15:18:20 GMT
    [alt-svc] => h3=":443"; ma=3600, h3-29=":443"; ma=3600,h3-27=":443"; ma=3600
    [content-length] => 193
)
body: {"error":{"message":"(#100) Could not find Product Item for catalog id 5228041203891210, retailer id wc_post_id_4204","type":"OAuthException","code":100,"fbtrace_id":"ALjdiKZ9Gyrg8mWOOsnw__V"}}

10-19-2021 @ 15:18:20 - Request
Request
uri: https://graph.facebook.com/v11.0/5228041203891210/product_groups
body: Array
(
    [retailer_id] => wc_post_id_4204
)
headers: Array
(
    [Authorization] => *****************************************************************************************************************************************************************************************************************************
)
timeout: 500
method: POST

10-19-2021 @ 15:18:20 - Response
Response
code: 400
message: Bad Request
headers: Array
(
    [vary] => Origin
    [access-control-allow-origin] => *
    [cross-origin-resource-policy] => cross-origin
    [x-app-usage] => {"call_count":32,"total_cputime":0,"total_time":5}
    [x-fb-rlafr] => 0
    [content-type] => application/json; charset=UTF-8
    [www-authenticate] => OAuth "Facebook Platform" "invalid_request" "(#10800) Duplicate retailer_id when attempting to create a product group."
    [facebook-api-version] => v11.0
    [strict-transport-security] => max-age=15552000; preload
    [pragma] => no-cache
    [cache-control] => no-store
    [expires] => Sat, 01 Jan 2000 00:00:00 GMT
    [x-fb-request-id] => Akl-t_pvW-slTOmdxqpwgJj
    [x-fb-trace-id] => CIeZo/cdRAl
    [x-fb-rev] => 1004577317
    [x-fb-debug] => D+RKigTcdYPnoYc2d4m0Ec5mevRTbODRmCTD6e020GWtl//fwkh2l1C4DkaNw4TvtfoIXNmUwMEWwaY8v2NTnQ==
    [date] => Tue, 19 Oct 2021 15:18:20 GMT
    [priority] => u=3,i
    [alt-svc] => h3=":443"; ma=3600, h3-29=":443"; ma=3600,h3-27=":443"; ma=3600
    [content-length] => 224
)
body: {"error":{"message":"(#10800) Duplicate retailer_id when attempting to create a product group.","type":"OAuthException","code":10800,"error_data":{"product_group_id":6355941927812284},"fbtrace_id":"Akl-t_pvW-slTOmdxqpwgJj"}}

10-19-2021 @ 15:18:21 - Request
Request
uri: https://graph.facebook.com/v11.0/6355941927812284/products
body: Array
(
    [name] => Olivewood Platter
    [description] => THIS BEAUTIFUL HAND CRAFTED CHEESE BOARD IS MADE FROM LOCALLY SOURCED WELSH WOOD AND INFUSED WITH A DEEP GREEN RESIN. THIS CHEESE BOARD IS THE PERFECT ADDITION TO THE HOME OR TO GIVE AS A GIFT. FINISHED WITH FOOD SAFE OIL AND BEES WAX FOR ADDITIONAL PROTECTION AND A LONG LIFE. ADDITIONAL CUSTOM ENGRAVING AVAILABLE UPON REQUEST. MEASUREMENTS: 17.5CM SQUARE
    [image_url] => https://www.coedwigcreations.co.uk/wp-content/uploads/2021/10/IMG_7157-scaled.jpg
    [additional_image_urls] => Array
        (
        )

    [url] => https://www.coedwigcreations.co.uk/product/olivewood-platter/
    [category] => Pre-made
    [brand] => Coedwig Creations
    [retailer_id] => wc_post_id_4204
    [price] => 2500
    [currency] => GBP
    [availability] => in stock
    [visibility] => published
    [sale_price_start_date] => 1970-01-29T00:00+00:00
    [sale_price_end_date] => 1970-01-30T23:59+00:00
    [sale_price] => 2500
)
headers: Array
(
    [Authorization] => *****************************************************************************************************************************************************************************************************************************
)
timeout: 500
method: POST

10-19-2021 @ 15:18:21 - Response
Response
code: 400
message: Bad Request
headers: Array
(
    [content-encoding] => gzip
    [vary] => Array
        (
            [0] => Origin
            [1] => Accept-Encoding
        )

    [cross-origin-resource-policy] => cross-origin
    [x-app-usage] => {"call_count":32,"total_cputime":0,"total_time":5}
    [x-fb-rlafr] => 0
    [content-type] => application/json; charset=UTF-8
    [www-authenticate] => OAuth "Facebook Platform" "invalid_request" "Invalid parameter"
    [access-control-allow-origin] => *
    [facebook-api-version] => v11.0
    [strict-transport-security] => max-age=15552000; preload
    [pragma] => no-cache
    [cache-control] => no-store
    [expires] => Sat, 01 Jan 2000 00:00:00 GMT
    [x-fb-request-id] => A5hxAResaNBGh91evH5rgPN
    [x-fb-trace-id] => A0fT6+Wd6WL
    [x-fb-rev] => 1004577317
    [x-fb-debug] => 2Kg9s0MOoUhrjygARnWJf5zEKhzPDS0ometNG9atoiWNl1sNpDZnR0jJQFa9ShpDvA+80Pe0lYClqhFjCIo6gg==
    [date] => Tue, 19 Oct 2021 15:18:21 GMT
    [alt-svc] => h3=":443"; ma=3600, h3-29=":443"; ma=3600,h3-27=":443"; ma=3600
    [content-length] => 236
)
body: {"error":{"message":"Invalid parameter","type":"OAuthException","code":100,"error_subcode":1803063,"is_transient":false,"error_user_title":"These fields contain all uppercase letters","error_user_msg":"Consider reformatting the item description to avoid all uppercase letters.","fbtrace_id":"A5hxAResaNBGh91evH5rgPN"}}

10-19-2021 @ 15:18:21 - 
10-19-2021 @ 15:18:21 - {"headers":{},"body":"{"error":{"message":"Invalid parameter","type":"OAuthException","code":100,"error_subcode":1803063,"is_transient":false,"error_user_title":"These fields contain all uppercase letters","error_user_msg":"Consider reformatting the item description to avoid all uppercase letters.","fbtrace_id":"A5hxAResaNBGh91evH5rgPN"}}","response":{"code":400,"message":"Bad Request"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}

    I feel like I’ve tried everything, I cannot get it to work, any help would be appreciated.

  • staff-blorbo · Staff ·

    Hi there,

    Please contact WooCommerce support directly for help with their plugin. The forum you’re posting in now is for the hosting provider, WordPress.com, and we can only help with sites that are hosted on our servers.

    If you’re using the free version of WooCommerce you can post in their community forum, here:

    https://wordpress.org/support/plugin/woocommerce/

    Or if you’re using any premium or payment gateway add-on downloaded from WooCommerce.com you can reach live chat and email support here:

    https://woocommerce.com/my-account/create-a-ticket/

  • The topic ‘Facebook Woocommerce product sync’ is closed to new replies.