Variable products not yncing

  • Resolved pierremare

    (@pierremare)


    3 years, 1 month ago

    Good morning, previously I had a similar problem with variable products not syncing, see thread: https://www.ads-software.com/support/topic/variable-products-not-syncing/

    At the time it was resolved by increasing the PHP memory to 512M. 

    1. Each variation is set to “sync and show in catalogue” in each of the variant’s Facebook sync drop down. The main box is also ticket at Marketing -> Facebook -> Product sync.

2. Products are marked as in stock

3. It is happening with all 20 or so new variable products added in the last few days. On the right hand side panel, within the product screen, where you have the individual Variant ID’s they are blank with no values. There is a main Facebook ID only.

I have re-synced all products and tried to “Reset Facebook meta data” with no luck.

    I have also run the snippet to delete all products from Facebook catalogue: https://docs.woocommerce.com/document/facebook-for-woocommerce/facebook-for-woocommerce-delete-or-reset-all-facebook-products/

    Here is a new system report – please let me know if there is a private way to give you an admin username and password to the installation I would really appreciate if you could take a look for me :

    
### WordPress Environment ###

WordPress address (URL): https://www.hildealetmalan.co.za
Site address (URL): https://www.hildealetmalan.co.za
WC Version: 5.5.1
REST API Version: ? 5.5.1
WC Blocks Version: ? 5.3.2
Action Scheduler Version: ? 3.2.1
WC Admin Version: ? 2.4.1
Log Directory Writable: ?
WP Version: ? 5.7.3 - There is a newer version of WordPress available (5.8.1)
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ?
Language: en_ZA
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.2.34
PHP Post Max Size: 8 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.71.0
OpenSSL/1.1.1d

SUHOSIN Installed: –
MySQL Version: 10.2.34-MariaDB
Max Upload Size: 8 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 5.5.1
WC Database Prefix: wp_
Total Database Size: 48.91MB
Database Data Size: 37.14MB
Database Index Size: 11.77MB
wp_woocommerce_sessions: Data: 0.10MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_attribute_taxonomies: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_order_items: Data: 0.05MB + Index: 0.03MB + Engine MyISAM
wp_woocommerce_order_itemmeta: Data: 0.92MB + Index: 0.23MB + Engine MyISAM
wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_actionscheduler_actions: Data: 0.41MB + Index: 0.18MB + Engine MyISAM
wp_actionscheduler_claims: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_actionscheduler_logs: Data: 0.30MB + Index: 0.22MB + Engine MyISAM
wp_bobsi_tradefeed_audit: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_bobsi_tradefeed_product: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_bobsi_tradefeed_product_base: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_booking: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_bookingdates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_cli_cookie_scan: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_cli_cookie_scan_categories: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_cli_cookie_scan_cookies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_cli_cookie_scan_url: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_cli_scripts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.25MB + Index: 0.28MB + Engine InnoDB
wp_db7_forms: Data: 0.10MB + Index: 0.01MB + Engine MyISAM
wp_duplicator_packages: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_layerslider: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_layerslider_revisions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_login_redirects: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ms_snippets: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_options: Data: 3.50MB + Index: 0.33MB + Engine InnoDB
wp_postmeta: Data: 14.52MB + Index: 8.03MB + Engine InnoDB
wp_posts: Data: 12.52MB + Index: 0.83MB + Engine InnoDB
wp_ps_groups: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_ps_group_relationships: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_ps_security: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_sbi_instagram_feeds_posts: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_sbi_instagram_feed_locator: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_sbi_instagram_posts: Data: 0.16MB + Index: 0.00MB + Engine MyISAM
wp_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_termmeta: Data: 0.11MB + Index: 0.13MB + Engine InnoDB
wp_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.13MB + Index: 0.09MB + Engine InnoDB
wp_term_taxonomy: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Data: 0.27MB + Index: 0.27MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_vtprd_purchase_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_vtprd_purchase_log_product: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_vtprd_purchase_log_product_rule: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_vtprd_transient_cart_data: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
wp_wc_admin_note_actions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine MyISAM
wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_mewz_wcas_match_rows: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wp_wc_mewz_wcas_match_sets: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wp_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_product_lookup: Data: 0.04MB + Index: 0.04MB + Engine MyISAM
wp_wc_order_stats: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
wp_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_product_meta_lookup: Data: 0.10MB + Index: 0.17MB + Engine MyISAM
wp_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_woo_shippment_provider: Data: 0.06MB + Index: 0.01MB + Engine MyISAM
wp_wpmailsmtp_tasks_meta: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_yoast_indexable: Data: 1.36MB + Index: 0.36MB + Engine MyISAM
wp_yoast_indexable_hierarchy: Data: 0.05MB + Index: 0.13MB + Engine MyISAM
wp_yoast_migrations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_yoast_primary_term: Data: 0.03MB + Index: 0.03MB + Engine MyISAM
wp_yoast_seo_links: Data: 0.12MB + Index: 0.03MB + Engine MyISAM
wp_yoast_seo_meta: Data: 0.02MB + Index: 0.02MB + Engine MyISAM

### Post Type Counts ###

amn_exact-metrics: 1
attachment: 898
avia_framework_post: 42
boxzilla-box: 7
cookielawinfo: 6
gift_card: 16
mewz_attribute_stock: 336
nav_menu_item: 39
oembed_cache: 4
page: 40
product: 505
product_variation: 1156
revision: 1188
shop_coupon: 13
shop_order: 307
wc_afrsm: 1
woo_discount: 2
woo_discount_cart: 1
wpcf7_contact_form: 3

### Security ###

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

### Active Plugins (34) ###

Advanced Access Manager: by Vasyl Martyniuk <[email protected]> – 6.7.7
WooCommerce Attribute Stock (Lite): by Mewz – 1.6.5
bidorbuy Store Integrator: by bidorbuy – 2.12.0
Boxzilla: by ibericode – 3.2.25
Classic Editor: by WordPress Contributors – 1.6.2
Code Snippets: by Code Snippets Pro – 2.14.1
Contact Form 7: by Takayuki Miyoshi – 5.4.2
Contact Form CFDB7: by Arshid – 1.2.5.9
Page Security & Membership: by Veraxus
Contexture – 1.5.15

GDPR Cookie Consent: by WebToffee – 2.0.5
Currency Exchange for WooCommerce: by BeRocket – 3.5.7
Duplicate Page: by mndpsingh287 – 4.4.1
Duplicator: by Snap Creek – 1.4.2
Facebook for WooCommerce: by Facebook – 2.6.1
Smash Balloon Instagram Feed: by Smash Balloon – 2.9.2
Custom Login Page Customizer: by Hardeep Asrani – 2.1.5
Peter's Login Redirect: by Peter Keung – 2.9.9
Really Simple SSL: by Really Simple Plugins – 5.0.6
Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.5
Shortcode in Menus: by Gagan Deep Singh – 3.5.1
Hide SEO Bloat: by SO WP – 3.14.7
WooCommerce Dynamic Pricing & Discounts: by RightPress – 2.3.9
Advanced Flat Rate Shipping For WooCommerce: by theDotstore – 3.9.5
WooCommerce Free Shipping Per Product: by WPRuby – 1.2.0
Advanced Order Export For WooCommerce: by AlgolPlus – 3.1.9
Preview E-mails for WooCommerce: by Digamber Pradhan – 1.6.8
WooCommerce Menu Extension: by August Infotech – 1.6.2
WooCommerce PayFast Gateway: by WooCommerce – 1.4.19
WooCommerce: by Automattic – 5.5.1 (update to version 5.8.0 is available)
Yoast SEO: by Team Yoast – 16.7
WP Mail SMTP: by WPForms – 2.9.0
Smart Coupons for WooCommerce: by WebToffee – 1.3.2
Sequential Order Numbers for WooCommerce: by WebToffee – 1.3.8
YITH WooCommerce Gift Cards: by YITH – 2.0.16

### Inactive Plugins (10) ###

Extension Works Framework: by Extension Works – 2.1.16
Google Analytics Dashboard for WP (GADWP): by ExactMetrics – 6.8.0
Hide Shipping Method For WooCommerce Pro: by theDotstore – 1.1.0
Insert Headers and Footers: by WPBeginner – 1.6.0
Kadence WooCommerce Email Designer: by Kadence WP – 1.4.7
Open Graph and Twitter Card Tags: by Webdados – 3.1.1
Redirection: by John Godley – 5.1.1
Social Media and Share Icons (Ultimate Social Media): by UltimatelySocial – 2.6.7
WooCommerce FastWay(ZA): by Extension Works – 1.4.9
Woo Discount Rules: by Flycart – 2.3.8

### Settings ###

API Enabled: ?
Force SSL: –
Currency: ZAR (R)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: booking (booking)
downloadable (downloadable)
external (external)
gift-card (gift-card)
grouped (grouped)
simple (simple)
variable (variable)
virtual (virtual)

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: #1339 - /shop/
Basket: #1340 - /basket/
Checkout: #1341 - /checkout/
My account: #1342 - /my-account/
Terms and conditions: #1667 - /terms-and-conditions/

### Theme ###

Name: Enfold
Version: 4.7.3
Author URL: https://kriesi.at
Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build
personally we recommend using a child theme. See: How to create a child theme

WooCommerce Support: ?

### Templates ###

Overrides: –

### Action Scheduler ###

Complete: 1,343
Oldest: 2021-10-20 12:02:30 +0200
Newest: 2021-10-21 09:30:59 +0200

Failed: 179
Oldest: 2021-03-02 12:11:11 +0200
Newest: 2021-06-15 00:09:21 +0200

Pending: 1
Oldest: 2021-10-21 10:52:23 +0200
Newest: 2021-10-21 10:52:23 +0200

### Status report information ###

Generated at: 2021-10-21 10:07:44 +02:00

    The page I need help with: [log in to see the link]

Viewing 10 replies - 1 through 10 (of 10 total)

  • I also cannot sync my variable products… having another thread open.

    Plugin Support B C. a11n

    (@battouly)

    Hi @pierremare,

    Let’s give the PHP memory_limit another increase and see if that helps. It could be that your server doesn’t have enough memory allocated to the PHP process, which is causing the process to fail midway.

    Let us know how that goes.

    @dgttm we will be looking at your request too.

    Thanks!

    thanks for your reply.

    ok, 2gb ok? I’ll let you know.

    you’ve seen this thread?

    https://www.ads-software.com/support/topic/variable-products-not-getting-sync-on-facebook/#post-15002464

    Thread Starter pierremare

    (@pierremare)

    Hi, increased php memory to 1024 with no luck. Simple products sync. Variable products do not. Tried to resync and all steps above. Any other suggestions? thank you!

    • This reply was modified 3 years, 1 month ago by pierremare.

    @pierremare do you use WMPL / multilanguage?

    Thread Starter pierremare

    (@pierremare)

    Hi dgttm, nope, Have the same problem with another website on the same server, but this one has a really small shop (93 products in total) – mostly simple products (all synced fine) but the variable products are just not syncing there are just a few. Memory 1000mb and even increased the timeout from 30 seconds to 300 still not working….

    Thread Starter pierremare

    (@pierremare)

    Hi guys, any other ideas. Would you be willing to take a look? Memory was upped to a gig, how much would the plugin need? Please help, thanks!

    Plugin Support nicw.a11n

    (@nicw)

    Hi @pierremare

    It seems this may not be a memory issue. There are a number of outstanding issues with syncing variable products to Facebook

    However, to investigate further would mean digging into your logs, therefore, 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.

    Thread Starter pierremare

    (@pierremare)

    Hi everyone!

    All is well with the syncing again. In case this helps someone else here is what I did.

    1. Updated WordPress to latest version
    2. Updated all Woocommerce plugins and Woocommerce extention plugins
    3. Increased PHP memory to 1024M and Timeout to 600

    To do number 3, add the following 2 lines to the .access file in the root directory of your website if you have access

    php_value memory_limit 1024M
    php_value max_execution_time 600

    4. Go to Marketing -> Facebook – > Product Sync -> Sync Products.

    Allow it to do it’s thing and tahdah! (Well hopefully to whoever is reading this).

    Regards all!

    That seemed to do the trick

    Plugin Support B C. a11n

    (@battouly)

    Thanks for sharing what worked for you with the community @pierremare.

    If you have any further questions, don’t hesitate to start a new thread.

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Variable products not yncing’ is closed to new replies.