Sale price not showing on facebook
-
I have added sale price to my products but they do now show in Facebook.
The page I need help with: [log in to see the link]
-
Hi there @mbhebsgaard ??
I have added sale price to my products but they do now show in Facebook.
Thanks for reaching out. Happy to help you with this!
When syncing your products to Facebook, the sale price should certainly be shown, as long as it is being set through the WooCommerce default sale price field and not by another plugin.
Let’s figure out why the prices aren’t lining up.
When you are setting a sale price, are you using the default WooCommerce sale price field, or is another plugin determining this price?
If you are using the default WooCommerce sale price field, can you please try deleting/resetting the product on Facebook, and then letting it resync? You can do that using this box:
https://d.pr/i/DA9RRY/DDNBc8t85M
Failing that, you might try doing the same for *all* products, and then letting the entire catalog resync:
Let us know how that goes!
In case it won’t yield any results, could you please share a copy of your site’s System Status? You can find it via
WooCommerce > Status
. SelectGet system report
and thenCopy for support
.?Additionally, could you also provide us with the fatal error logs (if any) under
WooCommerce > Status > Logs
.Once you’ve copied each, you can either paste them in your response here, or use https://pastebin.com/ for pasting it there and sharing it with us.
Looking forward to hearing from you!
Thanks for getting back so fast.
I use the default WooCommerce sale price field. I doesn’t seem to add any ID to the varians?
Facebook ID: 5743180032408224
Variant IDs:
16572:
16573:
16574:
16575:
16576:
16577:Reset Facebook metadata
Delete product(s) on Facebook`I have the status below.
LOGS BELOW
### WordPress Environment ### WordPress address (URL): https://foto-factory.dk Site address (URL): https://foto-factory.dk WC Version: 7.0.1 REST API Version: ? 7.0.1 WC Blocks Version: ? 8.5.2 Action Scheduler Version: ? 3.5.2 Log Directory Writable: ? WP Version: 6.1 WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: – WP Cron: ? Language: da_DK External object cache: – ### Server Environment ### Server Info: Apache PHP Version: 7.4.32 PHP Post Max Size: 64 MB PHP Time Limit: 300 PHP Max Input Vars: 1000 cURL Version: 7.86.0 OpenSSL/1.1.1q SUHOSIN Installed: – MySQL Version: 5.5.5-10.3.36-MariaDB-log Max Upload Size: 64 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? ### Database ### WC Database Version: 7.0.1 WC Database Prefix: UhKt4OiO_ Total Database Size: 176.06MB Database Data Size: 122.69MB Database Index Size: 53.37MB UhKt4OiO_woocommerce_sessions: Data: 2.02MB + Index: 0.05MB + Engine InnoDB UhKt4OiO_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB UhKt4OiO_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB UhKt4OiO_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB UhKt4OiO_woocommerce_order_items: Data: 1.52MB + Index: 0.30MB + Engine InnoDB UhKt4OiO_woocommerce_order_itemmeta: Data: 7.52MB + Index: 6.03MB + Engine InnoDB UhKt4OiO_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB UhKt4OiO_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB UhKt4OiO_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM UhKt4OiO_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM UhKt4OiO_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_actionscheduler_actions: Data: 9.30MB + Index: 3.76MB + Engine MyISAM UhKt4OiO_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM UhKt4OiO_actionscheduler_logs: Data: 9.93MB + Index: 3.89MB + Engine MyISAM UhKt4OiO_adtribes_my_conversions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_blc_filters: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_blc_instances: Data: 0.09MB + Index: 0.04MB + Engine MyISAM UhKt4OiO_blc_links: Data: 0.34MB + Index: 0.07MB + Engine MyISAM UhKt4OiO_blc_synch: Data: 0.28MB + Index: 0.19MB + Engine MyISAM UhKt4OiO_commentmeta: Data: 0.08MB + Index: 0.03MB + Engine InnoDB UhKt4OiO_comments: Data: 2.52MB + Index: 1.63MB + Engine InnoDB UhKt4OiO_et_bloom_stats: Data: 5.45MB + Index: 1.30MB + Engine MyISAM UhKt4OiO_et_divi_ab_testing_clients: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_et_divi_ab_testing_stats: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_et_social_stats: Data: 0.02MB + Index: 0.01MB + Engine MyISAM UhKt4OiO_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB UhKt4OiO_mailchimp_carts: Data: 0.05MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_mailchimp_jobs: Data: 0.01MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_mclean_refs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_mclean_scan: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_options: Data: 24.39MB + Index: 5.03MB + Engine InnoDB UhKt4OiO_pakkelabel_shipping_diffrentiated: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_postmeta: Data: 41.36MB + Index: 25.89MB + Engine InnoDB UhKt4OiO_posts: Data: 12.38MB + Index: 1.33MB + Engine InnoDB UhKt4OiO_searchinsights_archive: Data: 0.01MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_searchinsights_single: Data: 0.02MB + Index: 0.01MB + Engine MyISAM UhKt4OiO_smush_dir_images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_termmeta: Data: 0.08MB + Index: 0.06MB + Engine InnoDB UhKt4OiO_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB UhKt4OiO_term_relationships: Data: 0.25MB + Index: 0.16MB + Engine InnoDB UhKt4OiO_term_taxonomy: Data: 0.08MB + Index: 0.03MB + Engine InnoDB UhKt4OiO_usermeta: Data: 0.41MB + Index: 0.44MB + Engine InnoDB UhKt4OiO_users: Data: 0.05MB + Index: 0.05MB + Engine InnoDB UhKt4OiO_wcpdf_invoice_number: Data: 0.03MB + Index: 0.03MB + Engine MyISAM UhKt4OiO_wcpdf_packing_slip_number: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_wc_admin_notes: Data: 0.04MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_wc_admin_note_actions: Data: 0.02MB + Index: 0.01MB + Engine MyISAM UhKt4OiO_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_wc_customer_lookup: Data: 0.22MB + Index: 0.21MB + Engine MyISAM UhKt4OiO_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_wc_gpf_render_cache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.05MB + Engine MyISAM UhKt4OiO_wc_order_product_lookup: Data: 0.76MB + Index: 0.63MB + Engine MyISAM UhKt4OiO_wc_order_stats: Data: 0.26MB + Index: 0.17MB + Engine MyISAM UhKt4OiO_wc_order_tax_lookup: Data: 0.14MB + Index: 0.15MB + Engine MyISAM UhKt4OiO_wc_product_attributes_lookup: Data: 0.11MB + Index: 0.14MB + Engine MyISAM UhKt4OiO_wc_product_download_directories: Data: 0.00MB + Index: 0.01MB + Engine MyISAM UhKt4OiO_wc_product_meta_lookup: Data: 0.10MB + Index: 0.16MB + Engine MyISAM UhKt4OiO_wc_rate_limits: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM UhKt4OiO_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_woocommerce_gpf_google_taxonomy: Data: 0.91MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_wpr_rucss_resources: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_wpr_rucss_used_css: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_wps_hit: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_wps_index: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_wps_key: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_wps_object_term: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_wps_object_type: Data: 0.00MB + Index: 0.01MB + Engine MyISAM UhKt4OiO_wps_query: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_wps_uri: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_wps_user_agent: Data: 0.00MB + Index: 0.00MB + Engine MyISAM UhKt4OiO_yoast_indexable: Data: 1.28MB + Index: 0.39MB + Engine MyISAM UhKt4OiO_yoast_indexable_hierarchy: Data: 0.09MB + Index: 0.26MB + Engine MyISAM UhKt4OiO_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM UhKt4OiO_yoast_primary_term: Data: 0.01MB + Index: 0.01MB + Engine MyISAM UhKt4OiO_yoast_prominent_words: Data: 0.20MB + Index: 0.42MB + Engine MyISAM UhKt4OiO_yoast_seo_links: Data: 0.17MB + Index: 0.07MB + Engine MyISAM UhKt4OiO_yoast_seo_meta: Data: 0.03MB + Index: 0.03MB + Engine MyISAM ### Post Type Counts ### attachment: 860 custom_css: 2 et_body_layout: 18 et_footer_layout: 1 et_header_layout: 17 et_pb_layout: 18 et_template: 76 et_theme_builder: 1 gift_card: 1 nav_menu_item: 113 page: 32 post: 47 product: 216 product_variation: 1275 revision: 894 shop_coupon: 101 shop_order: 3464 shop_order_refund: 93 wc_order_status: 10 wpcode: 2 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (26) ### Akismet Anti-Spam: by Automattic – 5.0.1 Anyday WooCommerce: by Anyday – 1.7.8 Bloom: by Elegant Themes – 1.3.12 Cookie Notice & Compliance for GDPR / CCPA: by Hu-manity.co – 2.4.2 Divi Mini Cart: by Milen Krastev – 2.1.1 Elegant Themes Updater: by Elegant Themes – 1.0 Facebook for WooCommerce: by Facebook – 2.6.28 WPCode - Insert Headers, Footers, and Code Snippets: by WPCode – 2.0.3 Jetpack: by Automattic – 11.5.1 Mailchimp for WooCommerce: by Mailchimp – 2.7.6 Monarch Plugin: by Elegant Themes – 1.4.14 Trustpilot-reviews: by Trustpilot – 2.5.914 Webshipper - Automated Shipping: by Webshipper – 1.4.6 WooCommerce Bulk Edit Product Variations: by matterico_themes – 2.5.3 WooCommerce Google Analytics Integration: by WooCommerce – 1.5.16 WooCommerce Order Status Manager: by SkyVerge – 1.13.4 WooCommerce QuickPay: by Perfect Solution – 6.8.2 WooCommerce: by Automattic – 7.0.1 Yoast SEO Premium: by Team Yoast – 19.4 Yoast SEO: by Team Yoast – 19.9 WP Search Insights - Privacy-Friendly Search Analytics: by Mark Wolters – 1.3.8 WP Super Cache: by Automattic – 1.9.1 Yoast SEO: Local: by Team Yoast and Arjan Snaterse – 14.6 Yoast SEO: Video: by Team Yoast – 14.6 Yoast SEO: WooCommerce: by Team Yoast – 15.2 Yoast Test Helper: by Team Yoast – 1.17 ### Inactive Plugins (6) ### Broken Link Checker: by WPMU DEV – 1.11.19 CTX Feed: by WebAppick – 4.5.7 PDF Invoices & Packing Slips for WooCommerce: by WP Overnight – 3.2.3 Pinterest for WooCommerce: by WooCommerce – 1.2.4 Product Feed PRO for WooCommerce: by AdTribes.io – 11.9.8 Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.5 ### Dropin Plugins (2) ### advanced-cache.php: advanced-cache.php maintenance.php: maintenance.php ### Settings ### API Enabled: ? Force SSL: ? Currency: DKK (kr.) Currency Position: right_space Thousand Separator: . Decimal Separator: , Number of Decimals: 2 Taxonomies: Product Types: external (external) gift-card (gift-card) 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-2 (rated-2-2) rated-3 (rated-3) rated-4 (rated-4) rated-4 (rated-4-2) rated-5 (rated-5) Connected to WooCommerce.com: ? Enforce Approved Product Download Directories: – ### WC Pages ### Shop base: #46 - /shop/ Cart: #2218 - /shopping-cart/ Checkout: #48 - /checkout/ My account: #49 - /my-account/ Terms and conditions: #5765 - /handelsbetingelser/ ### Theme ### Name: Foto Factory 3 Version: 3.0.0 Author URL: https://foto-factory.dk Child Theme: ? Parent Theme Name: Divi Parent Theme Version: 4.19.0 Parent Theme Author URL: https://www.elegantthemes.com WooCommerce Support: ? ### Templates ### Overrides: – ### Admin ### Enabled Features: activity-panels analytics coupons customer-effort-score-tracks experimental-products-task experimental-import-products-task experimental-fashion-sample-products experimental-product-tour shipping-smart-defaults shipping-setting-tour homescreen marketing multichannel-marketing mobile-app-banner navigation onboarding onboarding-tasks remote-inbox-notifications remote-free-extensions payment-gateway-suggestions shipping-label-banner subscriptions store-alerts transient-notices woo-mobile-welcome wc-pay-promotion wc-pay-welcome-page Disabled Features: minified-js new-product-management-experience settings Daily Cron: ? Next scheduled: 2022-11-04 19:37:39 +01:00 Options: ? Notes: 96 Onboarding: completed ### Action Scheduler ### Complete: 4,494 Oldest: 2022-10-04 13:25:48 +0200 Newest: 2022-11-04 11:41:04 +0100 Failed: 4,193 Oldest: 2022-04-29 12:59:41 +0200 Newest: 2022-11-04 02:25:40 +0100 Pending: 4 Oldest: 2022-11-05 02:25:40 +0100 Newest: 2022-11-10 10:00:49 +0100 ### Status report information ### Generated at: 2022-11-04 11:41:50 +01:00
Hi there @mbhebsgaard ??
I use the default WooCommerce sale price field.
That’s great, thanks for clarifying.
I doesn’t seem to add any ID to the varians?
Indeed, from what the screenshot verifies.
Reset Facebook metadata
Delete product(s) on FacebookExcellent. Could you wait for the changes to sync and subsequently verify if the sale prices are updating, or not yet?
If not, here are some further steps to take in troubleshooting this:
WPCode - Insert Headers, Footers, and Code Snippets: by WPCode – 2.0.3
1. This plugin points at custom code running on the site. Kindly make sure to try again with custom code disabled.2. Caching! If nothing worked so far, kindly disable all caches, server-side and browser cache, and try again.
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 tried disabling all plugins – except woocommerce and Facebook for Woocommerce.
Tried another theme.
I have read the official documentation and still have no idea where to look for a solution.
Any more help is appreciated.
Hello @mbhebsgaard,
Failed: 4,193
Oldest: 2022-04-29 12:59:41 +0200
Newest: 2022-11-04 02:25:40 +0100I noticed your site has a lot of failed jobs which can be a sign that something is wrong with WP-Cron.
Can you please reach out to your hosting provider and ask them if there’s something wrong with WP-Cron functionality?
Also, some hosts install a script on multi-site configurations to end tasks taking more than 60 seconds so please mentioned that to your host as well to make sure that’s not the case.
Look forward to hearing back from you.
I found this in the log -facebook_for_woocommerce-2022-11-04
11-04-2022 @ 11:34:49 - Response code: 400 message: Bad Request body: {"error":{"message":"Unsupported get request. Object with ID 'catalog:522722229153578:RkYyMTFESy9BNV8xNjU3Mg==' does not exist, cannot be loaded due to missing permissions, or does not support this operation. Please read the Graph API documentation at https:\/\/developers.facebook.com\/docs\/graph-api","type":"GraphMethodException","code":100,"error_subcode":33,"fbtrace_id":"AOw_fva9t0FSTza-jFIKUDV"}} 11-04-2022 @ 11:34:49 - 16571: No options for pa_materiale 11-04-2022 @ 11:34:49 - 16571: No options for pa_brand 11-04-2022 @ 11:34:49 - Request uri: https://graph.facebook.com/v13.0/522722229153578/product_groups body: Array ( [retailer_id] => FF211DK_16571 [variants] => Array ( [0] => Array ( [product_field] => custom_data:stoerrelse-plakater [label] => St?rrelse plakater [options] => Array ( [0] => 50 x 70cm [1] => 14,8 x 21cm (A5) [2] => 21 × 29,7cm (A4) [3] => 29,7 x 42cm (A3) [4] => 70 x 100cm [5] => 100 x 140cm ) ) ) ) timeout: 500 method: POST
Hello,
Thanks for the info.code: 400
body: {“error”:{“message”:”Unsupported get request. Object with ID… does not exist, cannot be loaded due to missing permissions, or does not support this operation…Kindly check this forum thread with similar issue, it includes an explanation about how to solve it.
Let us know how that goes for you.
Thanks. I investigated this a bit as well. Did not find a solution. I ended up creating a new catalog. Removed to old and updated my ads. The problem were in the interaction with Woocommerce and Meta.
[Not solved]
Hi there @mbhebsgaard,
Thanks. I investigated this a bit as well. Did not find a solution. I ended up creating a new catalog. Removed to old and updated my ads. The problem were in the interaction with Woocommerce and Meta.
I’m glad to hear you were able to find a workaround, but I agree it’s definitely not the ideal solution for this issue.
Reading back through the previous conversation, I’m not seeing that we ever confirmed if you were using the Facebook Price field or if you left that blank in your product settings.
Can you confirm if you have a value set there that may have been overriding the WooCommerce price settings?
Thanks.
Thanks for getting back to me. Yes price and sale price is filled for both “Regular price” and “Sale price”.
Hi @mbhebsgaard!
Thanks for confirming that! — If the problem persists, can you try to disconnect and reconnect again to make sure all is working as expected?
I did a test on my site, and the values are synced correctly. Let us know how it goes if you perform that on your end.
- The topic ‘Sale price not showing on facebook’ is closed to new replies.