Product variations missed for some products

Hi @parallaxmaster

Thanks for providing all of the details.

Could you please share 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, paste it here in your response.

Nice to meet you, Amanda )
Sure, please:`

### WordPress Environment ###

WordPress address (URL): https://www.ullagarn.no
Site address (URL): https://www.ullagarn.no
WC Version: 4.7.0
REST API Version: ? 4.7.0
WC Blocks Version: ? 3.6.0
Action Scheduler Version: ? 3.1.6
WC Admin Version: ? 1.6.3
Log Directory Writable: ?
WP Version: 5.6
WP Multisite: –
WP Memory Limit: 768 MB
WP Debug Mode: –
WP Cron: ?
Language: nb_NO
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.3.26
PHP Post Max Size: 256 MB
PHP Time Limit: 120
PHP Max Input Vars: 3000
cURL Version: 7.66.0
OpenSSL/1.1.1g-fips

SUHOSIN Installed: –
MySQL Version: 5.7.26-29-log
Max Upload Size: 256 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 4.3.3
WC Database Prefix: wp_
Total Database Size: 383.61MB
Database Data Size: 299.27MB
Database Index Size: 84.34MB
wp_woocommerce_sessions: Data: 87.63MB + Index: 1.50MB + Engine InnoDB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.20MB + Index: 0.09MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 2.52MB + Index: 3.00MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 3.52MB + Index: 4.38MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 1.52MB + Index: 1.89MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.50MB + Index: 0.58MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailchimp_carts: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
wp_mailchimp_jobs: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
wp_mclean_refs: Data: 0.20MB + Index: 0.00MB + Engine InnoDB
wp_mclean_scan: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 35.08MB + Index: 2.44MB + Engine InnoDB
wp_pmxe_exports: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_hash: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_images: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_imports: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_posts: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_templates: Data: 0.30MB + Index: 0.00MB + Engine InnoDB
wp_postmeta: Data: 83.66MB + Index: 37.09MB + Engine InnoDB
wp_posts: Data: 38.50MB + Index: 6.95MB + Engine InnoDB
wp_relevanssi: Data: 8.19MB + Index: 10.98MB + Engine InnoDB
wp_relevanssi_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_relevanssi_stopwords: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wp_revslider_css_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_sliders: Data: 0.41MB + Index: 0.00MB + Engine InnoDB
wp_revslider_sliders_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_slides: Data: 5.52MB + Index: 0.00MB + Engine InnoDB
wp_revslider_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_termmeta: Data: 0.36MB + Index: 0.39MB + Engine InnoDB
wp_terms: Data: 0.23MB + Index: 0.28MB + Engine InnoDB
wp_term_relationships: Data: 1.31MB + Index: 1.39MB + Engine InnoDB
wp_term_taxonomy: Data: 0.27MB + Index: 0.28MB + Engine InnoDB
wp_usermeta: Data: 0.34MB + Index: 0.22MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 1.52MB + Index: 2.38MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woodmart_wishlists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woodmart_wishlist_products: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmelon_advbedit_temp: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
wp_yoast_indexable: Data: 15.52MB + Index: 8.11MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 1.25MB + Index: 0.53MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.09MB + Index: 0.09MB + Engine InnoDB
wp_yoast_prominent_words: Data: 0.14MB + Index: 0.16MB + Engine InnoDB
wp_yoast_seo_links: Data: 2.50MB + Index: 0.80MB + Engine InnoDB
wp_yoast_seo_meta: Data: 0.50MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

acf-field: 1
acf-field-group: 1
attachment: 13625
cms_block: 44
custom_css: 2
custom-css-js: 2
customize_changeset: 13
mc4wp-form: 1
nav_menu_item: 115
oembed_cache: 17
page: 134
portfolio: 9
post: 27
product: 1660
product_variation: 7291
revision: 1576
shop_coupon: 1
shop_order: 791
shop_order_refund: 9
vc_grid_item: 1
vc_settings_preset: 1
woodmart_sidebar: 2
woodmart_slide: 35
wpcf7_contact_form: 4

### Security ###

Secure connection (HTTPS): ?
Your store is not using HTTPS. Learn more about HTTPS and SSL Certificates.
Hide errors from visitors: ?

### Active Plugins (34) ###

Advanced Custom Fields PRO: by Elliot Condon – 5.8.12
ARI Fancy Lightbox: by ARI Soft – 1.3.7
Better Search Replace: by Delicious Brains – 1.3.3
Contact Form 7: by Takayuki Miyoshi – 5.3.2
Simple Custom CSS and JS: by SilkyPress.com – 3.33
Duplicate Page: by mndpsingh287 – 4.3
Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 3.2.6
Easy WP SMTP: by wpecommerce
alexanderfoxc – 1.4.1

Enhanced E-commerce for Woocommerce store: by Tatvic – 2.3.6.1 – Installed version not tested with active version of WooCommerce 4.7.0
Facebook for WooCommerce: by Facebook – 2.2.0
The Official Facebook Chat Plugin: by Facebook – 1.8
Insert Headers and Footers: by WPBeginner – 1.4.6
WPBakery Page Builder: by Michael M – WPBakery.com – 6.2.0
Klarna Checkout for WooCommerce: by Krokedil – 2.4.0
Loco Translate: by Tim Whitlock – 2.4.4
Mailchimp for WooCommerce: by Mailchimp – 2.4.7 – Installed version not tested with active version of WooCommerce 4.7.0
MC4WP: Mailchimp for WordPress: by ibericode – 4.8.1
Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.4
Relevanssi: by Mikko Saari – 4.8.3
Slider Revolution: by ThemePunch – 6.3.5
Safe SVG: by Daryll Doyle – 1.9.9
Additional Variation Images Gallery for WooCommerce – Pro: by Emran Ahmed – 1.1.28 – Installed version not tested with active version of WooCommerce 4.7.0
Additional Variation Images Gallery for WooCommerce: by Emran Ahmed – 1.1.42 – Installed version not tested with active version of WooCommerce 4.7.0
Variation Swatches for WooCommerce – Pro: by Emran Ahmed – 1.0.55 – Installed version not tested with active version of WooCommerce 4.7.0
Variation Swatches for WooCommerce: by Emran Ahmed – 1.1.1
WooCommerce Advanced Bulk Edit: by George Iron – 4.4.4 – Installed version not tested with active version of WooCommerce 4.7.0
WooCommerce: by Automattic – 4.7.0 (update to version 4.9.1 is available)
Woodmart Core: by – 1.0.27
WordPress Importer: by wordpressdotorg – 0.7
Yoast SEO Premium: by Team Yoast – 14.9
WP All Import Pro: by Soflyy – 4.6.3
WP Mail SMTP: by WPForms – 2.5.1
WP All Import – WooCommerce Add-On Pro: by Soflyy – 3.2.4 – Installed version not tested with active version of WooCommerce 4.7.0
WPForms Lite: by WPForms – 1.6.3.1

### Inactive Plugins (5) ###

Media Cleaner: by Jordy Meow – 6.0.8
SG Optimizer: by SiteGround – 5.7.6
WooCommerce Admin: by WooCommerce – 1.5.0 – Installed version not tested with active version of WooCommerce 4.7.0
WordPress Starter: by SiteGround – 1.1.1
WP All Export Pro: by Soflyy – 1.6.2

### Settings ###

API Enabled: ?
Force SSL: –
Currency: NOK (kr)
Currency Position: right
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 0
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: #8 – /butikk/
Cart: #9 – /handlekurv/
Checkout: #10 – /checkout/
My account: #27 – /min-konto/
Terms and conditions: #658 – /kjopsbetingelser/

### Theme ###

Name: Woodmart Child
Version: 1.0.0
Author URL: https://xtemos.com
Child Theme: ?
Parent Theme Name: Woodmart
Parent Theme Version: 5.3.6
Parent Theme Author URL: https://themeforest.net/user/xtemos
WooCommerce Support: ?

### Templates ###

Overrides: woodmart/woocommerce/archive-product.php
woodmart/woocommerce/cart/cart-item-data.php
woodmart/woocommerce/cart/cart.php
woodmart/woocommerce/cart/cross-sells.php
woodmart/woocommerce/cart/mini-cart.php
woodmart/woocommerce/checkout/form-checkout.php
woodmart/woocommerce/checkout/thankyou.php
woodmart/woocommerce/content-product-cat.php
woodmart/woocommerce/content-product.php
woodmart/woocommerce/content-single-product.php
woodmart/woocommerce/content-widget-product.php
woodmart/woocommerce/global/breadcrumb.php
woodmart/woocommerce/global/form-login.php
woodmart/woocommerce/global/quantity-input.php
woodmart/woocommerce/loop/add-to-cart.php
woodmart/woocommerce/loop/loop-end.php
woodmart/woocommerce/loop/loop-start.php
woodmart/woocommerce/loop/no-products-found.php
woodmart/woocommerce/loop/orderby.php
woodmart/woocommerce/loop/pagination.php
woodmart/woocommerce/loop/sale-flash.php
woodmart/woocommerce/myaccount/form-login.php
woodmart/woocommerce/product-searchform.php
woodmart-child/woocommerce/single-product/add-to-cart/grouped.php
woodmart-child/woocommerce/single-product/add-to-cart/variable.php
woodmart/woocommerce/single-product/meta.php
/home/customer/www/ullagarn.no/public_html/wp-content/plugins/woo-variation-gallery/templates/product-images.php
/home/customer/www/ullagarn.no/public_html/wp-content/plugins/woo-variation-gallery/templates/product-thumbnails.php
woodmart/woocommerce/single-product/rating.php
woodmart/woocommerce/single-product/related.php
woodmart/woocommerce/single-product/sale-flash.php
woodmart/woocommerce/single-product/tabs/tabs.php
woodmart/woocommerce/single-product/title.php
woodmart/woocommerce/single-product/up-sells.php
woodmart/woocommerce/single-product.php

### Action Scheduler ###

Complete: 1,725
Oldest: 2020-08-12 11:32:35 +0200
Newest: 2020-09-11 19:48:50 +0200

Pending: 3,540
Oldest: -0001-11-30 00:43:00 +0043
Newest: 2021-01-21 14:40:52 +0100

Canceled: 5,507
Oldest: -0001-11-30 00:43:00 +0043
Newest: -0001-11-30 00:43:00 +0043

`

Thanks @parallaxmaster

To start, I’d recommend running the DB update for WooCommerce core, as it does not currently match the version of WooCommerce on the site.

### WordPress Environment ###
WC Version: 4.7.0

### Database ###
WC Database Version: 4.3.3

You can do this by going to WooCommerce> Status> Tools and select the option to update the WooCommerce Database.

Occasionally, deleting or resetting all products from the Facebook catalog and then letting things sync again is the only way to fix strange issues. This requires a code snippet, which you can read more about here:

https://docs.woocommerce.com/document/facebook-for-woocommerce/facebook-for-woocommerce-delete-or-reset-all-facebook-products/

You see, the problem is not that I cant do it in batch, but I`m not able to do this (sync) even for one single product.
So, I have just deleted + Updated the page–> Regenerated and still cant create the IDs for the variations
https://prnt.sc/xdnc8x

Hi @parallaxmaster

Have you been able to update WooCommerce fully as Amanda mentioned?

If you have and this is still not working after deleting and resetting all products, AND your Facebook connection is correct, then I’d recommend the next step would be a conflict test – https://docs.woocommerce.com/document/how-to-test-for-conflicts/

https://docs.woocommerce.com/document/facebook-for-woocommerce/

Let me know how you get on!

Thanks,

@dougaitken Hi

Wrote you the long message but got an error for some reason.
So in 2 words. Database/Woo – 4.9.1
No conflicts even through the WP_DEBUG
Any other way to test these products?

Best regards,
Constantine.

Hi @parallaxmaster

As Doug mentioned, this kind of problem can be caused by a conflict with your theme or with another plugin.
?
The best way to determine this is to:

• Temporarily switch your theme to Storefront
• Disable all plugins except for WooCommerce
• Repeat the action that is causing the problem

If you’re not seeing the same problem after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated. To figure out which plugin is causing the problem, reactivate your other plugins one by one, testing after each, until you find the one causing conflict. You can find a more detailed explanation on how to do a conflict test here.

Hi Amanda.

Sorry, but non of these actions had no effect.
Theme was switched to the Storefront and 2020
All the plugins except the Woo and FBFWC were disabled.
Deleting and updating the VARIABLE products still doesn’t create the VARIATIONS IDs, only the ID for the MAIN PRODUCT.

Hi @parallaxmaster

Can you try increasing the memory limit on the site? We have had a few site owners who, after increasing the limit, had this same issue resolved.

https://docs.woocommerce.com/document/increasing-the-wordpress-memory-limit/

Hello Amanda.

It is already
— WP Memory Limit: 768 MB
and there is no possibility to increase more at our hosting. But I`m pretty sure it is more than enough…

Hi @parallaxmaster. As a next step, please try reconnecting the store to Facebook. Then reset the product metadata and do another sync. Then share the latest debug log with us if the issue persists.

Hi @parallaxmaster. We haven’t heard from you in a while so I’m going to go ahead and mark this thread as resolved. If you still need help with this issue or have any other questions about this plugin, please start a new thread.

How can I bulk DELETE all the products from the FB catalog to make a clean sync?

I find this snippet, but it doesn’t work:
https://docs.woocommerce.com/document/facebook-for-woocommerce/facebook-for-woocommerce-delete-or-reset-all-facebook-products/
pasted in functions.php with no effect.

• This reply was modified 3 years, 8 months ago by parallaxmaster.

I don’t see any reason that code snippet wouldn’t have any effect. Do you see any error messages?

Hi, no errors, no “white screens” to wait until the Dashboard appears as described. Just nothing.
First I tried it as a single PHP file and after as a part of the functions.php