Facebook for Woocommerce rewrites Product SKU

Hi @effiekyr

If I understand correctly, the Facebook for WooCommerce plugin is changing SKUs on products on your site?

Possibly you could explain in more detail. Is the SKU on all variable products changing, or only on some? What is it changing from and what is it changing to?

If you would like to share screenshots or a video, that would be great, but I would suggest you 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.

After a product is published, an irrelevant SKU which belongs to another product appears in the Inventory tab in the SKU field. The correct SKU appears in the variations. If we try to delete that SKU in the Inventory tab or change it, the change is not successful and that same SKU appears in the field again.

Hi @effiekyr

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.

Alternatively, 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.`

### WordPress Environment ###

WordPress address (URL): https://storyclubwear.gr
Site address (URL): https://storyclubwear.gr
WC Version: 5.9.0
REST API Version: ? 5.9.0
WC Blocks Version: ? 6.1.0
Action Scheduler Version: ? 3.3.0
WC Admin Version: ? 2.8.0
Log Directory Writable: ?
WP Version: 5.8.2
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ?
Language: el
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.26
PHP Post Max Size: 128 MB
PHP Time Limit: 600
PHP Max Input Vars: 4000
cURL Version: 7.58.0
OpenSSL/1.1.1

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.1.48-MariaDB-0ubuntu0.18.04.1
Max Upload Size: 128 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 5.9.0
WC Database Prefix: wp_
Total Database Size: 423.89MB
Database Data Size: 368.09MB
Database Index Size: 55.80MB
wp_woocommerce_sessions: Data: 0.33MB + Index: 0.02MB + 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.42MB + Index: 0.13MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 2.52MB + Index: 3.03MB + 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: 1.52MB + Index: 1.28MB + 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: 0.63MB + Engine InnoDB
wp_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_chaty_contact_form_leads: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_chaty_widget_analysis: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 2.52MB + Index: 0.83MB + Engine InnoDB
wp_ee_products_sync_list: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ee_product_sync_call: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ee_product_sync_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ewwwio_images: Data: 1.52MB + Index: 1.73MB + Engine InnoDB
wp_gglcptch_whitelist: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_hustle_entries: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_hustle_entries_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_hustle_modules: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_hustle_modules_meta: Data: 0.09MB + Index: 0.03MB + Engine InnoDB
wp_hustle_tracking: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mailchimp_carts: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mo_campaign_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mo_campaign_logmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mo_conversions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mo_email_campaignmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mo_email_campaigns: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_mo_optin_campaignmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_mo_optin_campaigns: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_options: Data: 6.38MB + Index: 2.86MB + Engine InnoDB
wp_piraeusbank_transactions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxe_exports: Data: 0.02MB + 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_postmeta: Data: 45.58MB + Index: 28.11MB + Engine InnoDB
wp_posts: Data: 268.52MB + Index: 6.02MB + Engine InnoDB
wp_sbi_instagram_feeds_posts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_sbi_instagram_feed_locator: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_sbi_instagram_posts: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wp_sgpb_subscribers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_sgpb_subscription_error_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_smush_dir_images: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_social_users: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_termmeta: Data: 0.11MB + Index: 0.16MB + Engine InnoDB
wp_terms: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
wp_term_relationships: Data: 1.52MB + Index: 1.52MB + Engine InnoDB
wp_term_taxonomy: Data: 0.08MB + Index: 0.09MB + Engine InnoDB
wp_um_metadata: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_usermeta: Data: 0.48MB + Index: 0.55MB + Engine InnoDB
wp_users: Data: 0.06MB + 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.11MB + Index: 0.06MB + 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.11MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.09MB + Index: 0.08MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 1.52MB + Index: 1.39MB + 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_wfblockediplog: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wp_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wfconfig: Data: 0.47MB + Index: 0.00MB + Engine InnoDB
wp_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wffilemods: Data: 5.52MB + Index: 0.00MB + Engine InnoDB
wp_wfhits: Data: 1.47MB + Index: 0.23MB + Engine InnoDB
wp_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wfknownfilelist: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
wp_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wflogins: Data: 0.48MB + Index: 0.17MB + Engine InnoDB
wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wfstatus: Data: 0.13MB + Index: 0.09MB + Engine InnoDB
wp_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woof_query_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wpforms_tasks_meta: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpmailsmtp_tasks_meta: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wp_wpr_rucss_resources: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wpr_rucss_used_css: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wt_iew_action_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wt_iew_cron: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wt_iew_ftp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wusers_inputs: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_wzen_time_table: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yith_wcwl_lists: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_yoast_indexable: Data: 8.52MB + Index: 4.42MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 0.36MB + Index: 0.53MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.13MB + Index: 0.13MB + Engine InnoDB
wp_yoast_seo_links: Data: 0.11MB + Index: 0.03MB + Engine InnoDB
wp_yoast_seo_meta: Data: 0.44MB + Index: 0.00MB + Engine InnoDB
wtf: Data: 10.52MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

amn_mi-lite: 1
attachment: 8768
blocks: 8
br_product_filter: 1
customize_changeset: 2
custom_css: 1
efbl_skins: 4
featured_item: 8
mif_skins: 2
nav_menu_item: 129
oembed_cache: 9
page: 25
popup: 1
popupbuilder: 1
popup_theme: 8
post: 3000
product: 1851
product_variation: 3499
revision: 256
shop_coupon: 8
shop_order: 1543
shop_order_refund: 13
um_directory: 1
um_form: 3
wafs: 1
woo_discount: 1
wpcf7_contact_form: 1
wpforms: 1
yith-wcbm-badge: 1
yith_popup: 1

### Security ###

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

### Active Plugins (38) ###

NETSTAR-GR Ltd - NetStar Utils: by Konstantinos Efeoglou – 1.1.7
HTML in Category Descriptions: by Arno Esterhuizen – 1.2.3
NETSTAR-GR Ltd - WooCommerce Alpha Bank Payment Gateway: by NETSTAR-GR Ltd – 4.2.8
Booster Plus for WooCommerce: by Pluggabl LLC – 5.4.9
Classic Editor: by WordPress Contributors – 1.6.2
Contact Form 7: by Takayuki Miyoshi – 5.5.3
Cookie Notice & Compliance for GDPR / CCPA: by Hu-manity.co – 2.2.1
WooCommerce Custom Availability: by @anttiviljami – 1.2.0
Easy Facebook Like Box: by shehryar – 4.1.2
Enable Media Replace: by ShortPixel – 3.6.3
Conversios.io - Google Analytics and Google Shopping plugin for WooCommerce: by Tatvic – 4.5.0
Social Shop for WooCommerce: by StoreYa – 2.6
Head, Footer and Post Injections: by Stefano Lissa – 3.2.2
Smash Balloon Instagram Feed: by Smash Balloon – 2.9.5
Loco Translate: by Tim Whitlock – 2.5.5
Mailchimp for WooCommerce: by Mailchimp – 2.5.4
MailChimp Forms by MailMunch: by MailMunch – 3.1.4
MailOptin - Lite: by MailOptin Team – 1.2.42.0
My Custom Functions: by Space X-Chimp – 4.51
Really Simple SSL: by Really Simple Plugins – 5.2.0
Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.5
Remove Uppercase Accents: by Giorgos Sarigiannidis – 1.1.1
reSmush.it Image Optimizer: by reSmush.it – 0.4.1
Skroutz Analytics for WooCommerce: by Skroutz – 1.6.8
NETSTAR-GR Ltd - Woo to XML: by NETSTAR-GR Ltd – 5.0.4
Variation Swatches for WooCommerce: by Emran Ahmed – 1.1.19
Checkout Fields Manager for WooCommerce: by QuadLayers – 5.5.2
WooCommerce PayPal Checkout Gateway: by WooCommerce – 2.1.3
Booster for WooCommerce: by Pluggabl LLC – 5.4.9
WOOF - WooCommerce Products Filter: by realmag777 – 2.2.3
WooCommerce: by Automattic – 5.9.0
WooSidebars: by WooCommerce – 1.4.5
Wordfence Security: by Wordfence – 7.5.7
WP Mail SMTP: by WPForms – 3.2.0
WP Rocket: by WP Media – 3.10.4
WP Sitemap Page: by Tony Archambeau – 1.9.1
WPForms Lite: by WPForms – 1.7.1.1
YITH WooCommerce Wishlist: by YITH – 3.3.0

### Inactive Plugins (1) ###

Facebook for WooCommerce: by Facebook – 2.6.7

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

### Settings ###

API Enabled: ?
Force SSL: ?
Currency: EUR (€)
Currency Position: right_space
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: #65 - /shop/
Cart: #64 - /cart/
Checkout: #63 - /checkout/
My account: #62 - /my-account/
Terms and conditions: #711 - /oroi-xrisis/

### Theme ###

Name: Flatsome
Version: 3.14.3
Author URL: https://www.uxthemes.com/
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: flatsome/woocommerce/archive-product.php
flatsome/woocommerce/cart/cart-empty.php
flatsome/woocommerce/cart/cart-shipping.php
flatsome/woocommerce/cart/cart.php
flatsome/woocommerce/checkout/form-checkout.php
flatsome/woocommerce/checkout/form-coupon.php
flatsome/woocommerce/checkout/terms.php
flatsome/woocommerce/checkout/thankyou.php
flatsome/woocommerce/content-product-cat.php
flatsome/woocommerce/content-product.php
flatsome/woocommerce/content-single-product.php
flatsome/woocommerce/content-widget-product.php
flatsome/woocommerce/global/breadcrumb.php
flatsome/woocommerce/global/quantity-input.php
flatsome/woocommerce/global/wrapper-end.php
flatsome/woocommerce/global/wrapper-start.php
flatsome/woocommerce/loop/loop-end.php
flatsome/woocommerce/loop/loop-start.php
flatsome/woocommerce/loop/pagination.php
flatsome/woocommerce/loop/result-count.php
flatsome/woocommerce/loop/sale-flash.php
flatsome/woocommerce/myaccount/form-login.php
flatsome/woocommerce/myaccount/navigation.php
flatsome/woocommerce/notices/error.php
flatsome/woocommerce/notices/notice.php
flatsome/woocommerce/notices/success.php
flatsome/woocommerce/product-searchform.php
flatsome/woocommerce/single-product/photoswipe.php
flatsome/woocommerce/single-product/price.php
flatsome/woocommerce/single-product/product-image.php
flatsome/woocommerce/single-product/product-thumbnails.php
flatsome/woocommerce/single-product/rating.php
flatsome/woocommerce/single-product/related.php
flatsome/woocommerce/single-product/review.php
flatsome/woocommerce/single-product/sale-flash.php
flatsome/woocommerce/single-product/share.php
flatsome/woocommerce/single-product/short-description.php
flatsome/woocommerce/single-product/tabs/tabs.php
flatsome/woocommerce/single-product/title.php
flatsome/woocommerce/single-product/up-sells.php
flatsome/woocommerce/single-product-reviews.php
flatsome/woocommerce/single-product.php
flatsome/woocommerce/content-product_cat.php

### Action Scheduler ###

Complete: 2,055
Oldest: 2021-11-08 13:05:39 +0200
Newest: 2021-12-08 21:29:00 +0200

Failed: 1,193
Oldest: 2021-03-09 05:36:58 +0200
Newest: 2021-11-19 10:30:37 +0200

Pending: 5
Oldest: 2021-12-09 19:29:45 +0200
Newest: 2021-12-14 18:13:55 +0200

### Status report information ###

Generated at: 2021-12-09 00:59:08 +02:00

Hi @effiekyr

Thank you for this. We have seen some conflicts with the Flatsome theme, particularly where shortcodes from Flatsome are being used. Could you take a look at the shortcodes in your product?

Does the SKU which is appearing in the product match the SKU of the last product ID in the last shortcode in the product description/Flatsome UX Builder?

One way to test this would be to switch to the Storefront Theme temporarily, and check to see if the SKU changes.

Does the SKU which is appearing in the product match the SKU of the last product ID in the last shortcode in the product description/Flatsome UX Builder?
There’s a products slider shortcode and YES it does! The last product’s SKU is the SKU showing in the Inventory tab.

– I’m sorry your support request got lost in our backlog. Do you happen to still need assistance here?

Hi again,
We changed the theme and now everything works properly.
Thank you though.

Hi @effiekyr,

Perfect. We are so glad to hear everything is working now.

I’ll go ahead and mark this thread as solved.

Please feel free to open another one if anything else arises.