SKU not saving
-
Hi.
I’m trying to create variabel product from a single products. There are several sizes that should variants, and I have created the right attributes for them.
But when I enter the right SKU for each product, it’s not saved when I update. All variants SKU return to the one that was earlier. I get the notice that “the SKU is double”
Regards Peter
The page I need help with: [log in to see the link]
-
Hi @peter0013
The invalid or duplicated SKU warning in WooCommerce usually happens when the user enters a product with the same SKU as one that is already added.
Kindly note SKUs must be unique, be sure to check on your dashboard the setting “Woocommerce > Status > Tools” click on Delete orphaned variations.
Hope this helps.
Hi and thanks. I don’t want to delete any products, just make them as variations (different sizes). But as said – the SKU for the variants don’t change when I try to insert the right SKU. Are you sure nothing is deleted from Woo?
Hi @peter0013
I understand that when updating the correct SKU for the variations, it is not being updated, correct?
Can you please share with us the step-by-step procedure you did in converting your simple products to variable products for us to check if there are any pain points along the way?
If a screenshot would be helpful, I’d recommend using https://snipboard.io. You can share the direct link to the image as a response to this topic.
Thanks!
Hi.
I have taken images of each step. You can find them here:
https://drive.google.com/drive/folders/18t2agiNDh_PZw5OSMOzju3RXVdO-mAbr?usp=share_link
Hi @peter0013
Thanks for sharing the requested information above.
Image 3 is where you created/added the attributes. Then, comes Image 4 where variations were already created with the same
SKU number
of01-001
.Can you please share how did you created variations on your site after Image 3? This procedure was not added on your steps.
I tried to replicate the scenario on my end, after creating attributes, I am now creating variations where the only options are:
Add variation
andCreate variations from all attributes
. Regardless of what I choose, the SKU field is empty as you can see below:On your case in Images 4 and 5, the SKU fields are already filled up with the same value.
Once we have more information about how variations were created after Image 3, we’ll be able to check this further.
If a screenshot would be helpful, I’d recommend using https://snipboard.io. You can share the direct link to the image as a response to this topic.
Thanks!
Hi. The SKUs came automatically after I had chosen “Create variations from all attributes”. They were filled automatically with the same SKU as the first product. I can change them, but they are not saved. Instead they return to the first number and the warning text comes up.
Should you prefer that I made a movie of the process or do you want a login to check yourself?
Peter
- This reply was modified 1 year ago by peter0013.
I created the variations by choosing ” Create variations from all attributes”
- This reply was modified 1 year ago by peter0013.
I found an advise on internet about activating Manage stock for each produkt, but that don’t work either.
Hi
In the product list the SKUs are right. These are the ones that should be able to insert under Variables for the product. See my attached images.
Peter
https://drive.google.com/file/d/1Lmx_YLhieOZiPtIEx2KobrLkKr5j3jCb/view?usp=share_link
https://drive.google.com/file/d/19thM9iKCjs3ttoww9bctN6QIOBt2w3vk/view?usp=share_link
I tried to add a new product (a real one) but the SKU is not saved, nor in admin for each product, nor in the product list view.
Hi @peter0013
Thanks for sharing further information about your issue here.
Should you prefer that I made a movie of the process or do you want a login to check yourself?
Just a reminder to please refrain from sharing credentials here as this is a public forum. Furthermore, this is against the Forum Guidelines.
Hi. The SKUs came automatically after I had chosen “Create variations from all attributes”. They were filled automatically with the same SKU as the first product
This is quite odd and this is not the default behavior when creating variations from all attributes.
For us to investigate this further, can you please try to switch to the default Storefront theme and only WooCommerce plugin is enabled, create a new variable product and see if the
SKU
field is empty?If so, then this kind of problem is usually caused by your theme or a third-party plugin present on your site. We can run a conflict test to verify this. I’d recommend cloning your site to a staging environment and performing the tests described on this guide without modifying your live site or impacting customers. Many hosts provide staging facilities, so it’s worth checking in with them. It’s also possible to do it using the free WP Staging plugin.
If this was caused by a third-party plugin present on your site, it would be best to reach out to the developers for further assistance here.
If this did not resolve the issue, please share your System Status Report, that will help us further troubleshoot.
You can find it via
WooCommerce > Status
. SelectGet system report
and thenCopy for support
. Once you’ve done that, you can paste it into your reply here.If you could also provide the fatal error logs (if any) under
WooCommerce > Status > Logs
.You could copy and paste your reply here or paste it via https://gist.github.com/ and send the link here.
Let us know how it goes!
Hi. I have done as you said, but the problem remains. Here is the status report:
WordPress Environment WordPress address (URL): https://mandelgren.site
Site address (URL): https://mandelgren.site
WC Version: 7.6.0
REST API Version: ✔ 7.6.0
WC Blocks Version: ✔ 9.8.4
Action Scheduler Version: ✔ 3.5.4
Log Directory Writable: ✔
WP Version: 6.2
WP Multisite: –
WP Memory Limit: 3 GB
WP Debug Mode: –
WP Cron: ✔
Language: sv_SE
External object cache: – Server Environment Server Info: Apache
PHP Version: 7.4.33
PHP Post Max Size: 256 MB
PHP Time Limit: 3000
PHP Max Input Vars: 3000
cURL Version: 7.84.0
OpenSSL/1.1.1p SUHOSIN Installed: –
MySQL Version: 5.5.5-10.3.38-MariaDB-log-cll-lve
Max Upload Size: 256 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔ Database WC Database Version: 7.2.0
WC Database Prefix: wpmw_
Total databasstorlek: 42.41MB
Datastorlek för databas: 37.23MB
Indexstorlek för databas: 5.18MB
wpmw_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wpmw_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wpmw_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wpmw_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Motor InnoDB
wpmw_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wpmw_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wpmw_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Motor InnoDB
wpmw_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wpmw_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
wpmw_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wpmw_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
wpmw_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wpmw_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wpmw_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wpmw_actionscheduler_actions: Data: 0.16MB + Index: 0.14MB + Motor InnoDB
wpmw_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wpmw_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wpmw_actionscheduler_logs: Data: 0.13MB + Index: 0.09MB + Motor InnoDB
wpmw_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
wpmw_commentmeta: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wpmw_comments: Data: 0.02MB + Index: 0.09MB + Motor InnoDB
wpmw_e_events: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wpmw_layerslider: Data: 0.14MB + Index: 0.00MB + Motor InnoDB
wpmw_layerslider_drafts: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wpmw_layerslider_revisions: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
wpmw_links: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wpmw_options: Data: 7.28MB + Index: 0.08MB + Motor InnoDB
wpmw_postmeta: Data: 16.52MB + Index: 3.03MB + Motor InnoDB
wpmw_posts: Data: 11.52MB + Index: 0.38MB + Motor InnoDB
wpmw_revslider_css: Data: 0.13MB + Index: 0.02MB + Motor InnoDB
wpmw_revslider_css_bkp: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wpmw_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
wpmw_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
wpmw_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
wpmw_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
wpmw_revslider_sliders: Data: 0.03MB + Index: 0.02MB + Motor InnoDB
wpmw_revslider_sliders_bkp: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wpmw_revslider_slides: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wpmw_revslider_slides_bkp: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wpmw_revslider_static_slides: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wpmw_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wpmw_termmeta: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wpmw_terms: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wpmw_term_relationships: Data: 0.08MB + Index: 0.05MB + Motor InnoDB
wpmw_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wpmw_usermeta: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wpmw_users: Data: 0.02MB + Index: 0.05MB + Motor InnoDB
wpmw_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Motor InnoDB
wpmw_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Motor InnoDB
wpmw_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
wpmw_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wpmw_wc_download_log: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wpmw_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wpmw_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Motor InnoDB
wpmw_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Motor InnoDB
wpmw_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
wpmw_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wpmw_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wpmw_wc_product_meta_lookup: Data: 0.05MB + Index: 0.09MB + Motor InnoDB
wpmw_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wpmw_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
wpmw_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wpmw_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wpmw_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
wpmw_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
wpmw_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Motor InnoDB Post Type Counts attachment: 229
customize_changeset: 4
custom_css: 2
elementor_library: 1
nav_menu_item: 479
page: 100
portfolio: 8
post: 21
product: 163
product_variation: 49
revision: 1001
team: 4
testimonial: 3
wpcf7_contact_form: 5
wpforms: 3 Security Secure connection (HTTPS): ✔
Hide errors from visitors: ✔ Active Plugins (1) WooCommerce: av Automattic – 7.6.0 Inactive Plugins (30) Advanced Custom Fields PRO: av Delicious Brains – 5.12.3
Advanced Sidebar Menu: av OnPoint Plugins – 9.0.6
Antispam Bee: av pluginkollektiv – 2.11.3
Backuply: av Softaculous – 1.1.2
Checkout Field Editor for WooCommerce: av ThemeHigh – 1.8.2
Child Theme Configurator: av Lilaea Media – 2.6.2
Classic Editor: av WordPress Contributors – 1.6.3
Contact Form 7: av Takayuki Miyoshi – 5.7.5.1
Elementor: av Elementor.com – 3.12.1
Envato Market: av Envato – 2.0.7
FiboSearch - AJAX Search for WooCommerce: av FiboSearch Team – 1.23.0
Fonts Plugin | Google Fonts Typography: av Fonts Plugin – 3.3.7
GDPR Cookie Compliance: av Moove Agency – 4.11.0
LayerSlider: av Kreatura Media – 7.3.0
Really Simple SSL: av Really Simple Plugins – 6.2.4
Regenerate Thumbnails: av Alex Mills (Viper007Bond) – 3.1.5
Resize Image After Upload: av ShortPixel – 1.8.6
Savoy Theme - Content Elements: av NordicMade – 1.6.0
Savoy Theme - Portfolio: av NordicMade – 1.2.8
Savoy Theme - Settings Panel: av NordicMade – 1.2.1
Savoy Theme - Team Members: av NordicMade – 1.0.8
Savoy Theme - Wishlist: av NordicMade – 2.4.2
Slider Revolution: av ThemePunch – 6.5.31
String Locator: av InstaWP – 2.6.1
Under Construction: av WebFactory Ltd – 3.97
W3 Total Cache: av BoldGrid – 2.3.1
WooCommerce Invoice Gateway: av Stuart Duff – 2.0.0
WPForms Lite: av WPForms – 1.8.1.2
WP Sheet Editor - WooCommerce Products (Premium): av WP Sheet Editor – 1.8.1
Yoast Duplicate Post: av Enrico Battocchi & Team Yoast – 4.5 Settings API Enabled: –
Force SSL: –
Currency: SEK (kr)
Currency Position: right_space
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: –
Enforce Approved Product Download Directories: ✔
Order datastore: WC_Order_Data_Store_CPT WC Pages Butikbas: #6 - /butik/
Varukorg: #7 - /varukorg/
Kassan: #8 - /kassan/
Mitt konto: #9 - /mitt-konto/
Villkor: ❌ Sida har inte valts Theme Name: Storefront
Version: 4.2.0
Author URL: https://woocommerce.com/
Child Theme: ❌ – Om du modifierar WooCommerce på ett modertema som du själv inte byggt
så rekommenderar vi att du använder ett barntema istället. Läs: Hur du skapar ett barntema WooCommerce Support: ✔ Templates Overrides: – Admin Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
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: block-editor-feature-enabled
minified-js
new-product-management-experience
product-variation-management
settings Daily Cron: ✔ Next scheduled: 2023-04-20 10:44:56 +00:00
Options: ✔
Notes: 85
Onboarding: completed Action Scheduler Färdigbehandlad: 378
Oldest: 2023-03-19 19:34:42 +0000
Newest: 2023-04-19 16:07:59 +0000 Misslyckades: 17
Oldest: 2023-02-15 00:18:27 +0000
Newest: 2023-04-19 16:04:24 +0000 Väntar: 1
Oldest: 2023-04-20 12:07:44 +0000
Newest: 2023-04-20 12:07:44 +0000 Status report information Generated at: 2023-04-19 16:09:43 +00:00
`Here is the error log:
2023-03-31T08:47:04+00:00 CRITICAL require(): Failed opening required '/home/metaoyct/public_html/wp-content/plugins/woocommerce/includes/rest-api/Controllers/Version1/class-wc-rest-customers-v1-controller.php' (include_path='.:/opt/alt/php74/usr/share/pear') i /home/metaoyct/public_html/wp-content/plugins/woocommerce/vendor/jetpack-autoloader/class-php-autoloader.php på rad 87 2023-03-31T08:47:04+00:00 CRITICAL require(): Failed opening required '/home/metaoyct/public_html/wp-content/plugins/elementor/core/wp-api.php' (include_path='.:/opt/alt/php74/usr/share/pear') i /home/metaoyct/public_html/wp-content/plugins/elementor/includes/autoloader.php på rad 294 2023-03-31T08:47:05+00:00 CRITICAL require(): Failed opening required '/home/metaoyct/public_html/wp-content/plugins/elementor/core/wp-api.php' (include_path='.:/opt/alt/php74/usr/share/pear') i /home/metaoyct/public_html/wp-content/plugins/elementor/includes/autoloader.php på rad 294 2023-03-31T08:47:05+00:00 CRITICAL require(): Failed opening required '/home/metaoyct/public_html/wp-content/plugins/elementor/core/wp-api.php' (include_path='.:/opt/alt/php74/usr/share/pear') i /home/metaoyct/public_html/wp-content/plugins/elementor/includes/autoloader.php på rad 294 2023-03-31T11:18:40+00:00 CRITICAL require(): Failed opening required '/home/metaoyct/public_html/wp-content/plugins/woocommerce/src/Admin/API/OnboardingThemes.php' (include_path='.:/opt/alt/php74/usr/share/pear') i /home/metaoyct/public_html/wp-content/plugins/woocommerce/vendor/jetpack-autoloader/class-php-autoloader.php på rad 87 2023-03-31T11:18:40+00:00 CRITICAL require(): Failed opening required '/home/metaoyct/public_html/wp-content/plugins/woocommerce/includes/rest-api/Controllers/Telemetry/class-wc-rest-telemetry-controller.php' (include_path='.:/opt/alt/php74/usr/share/pear') i /home/metaoyct/public_html/wp-content/plugins/woocommerce/vendor/jetpack-autoloader/class-php-autoloader.php på rad 87 2023-03-31T11:18:46+00:00 CRITICAL Uncaught Error: Class 'WC_Order_Refund' not found in /home/metaoyct/public_html/wp-content/plugins/woocommerce/src/Admin/Overrides/OrderRefund.php:17
Stack trace: 0 /home/metaoyct/public_html/wp-content/plugins/woocommerce/vendor/jetpack-autoloader/class-php-autoloader.php(87): require() 1 [internal function]: Automattic\Jetpack\Autoloader\jp9630bcd590188630cdfedae109fd5064\PHP_Autoloader::load_class('Automattic\WooC…') 2 /home/metaoyct/public_html/wp-content/plugins/woocommerce/src/Internal/Admin/Schedulers/OrdersScheduler.php(39): spl_autoload_call('Automattic\WooC…') 3 /home/metaoyct/public_html/wp-content/plugins/woocommerce/src/Admin/ReportsSync.php(24): Automattic\WooCommerce\Internal\Admin\Schedulers\OrdersScheduler::init() 4 /home/metaoyct/public_html/wp-content/plugins/woocommerce/src/Internal/Admin/FeaturePlugin.php(166): Automattic\WooCommerce\Admin\ReportsSync::init() 5 /home/metaoyct/public_html/wp-content/plugins/woocommerce/src/Internal/Admin/FeaturePlugin.php(99): Automattic\WooCom i /home/metaoyct/public_html/wp-content/plugins/woocommerce/src/Admin/Overrides/OrderRefund.php på rad 17I also tried to delete a product, erasing it from garbage bin, and then installing the product again. But the problem remains. It was not even possible to give the new product a SKU.
Hi @peter0013
Thanks for sharing the requested information above.
I understand that even after disabling all plugins except WooCommerce and switching to the default Storefront theme, newly created products are being generated an SKU, correct?
WC Version: 7.6.0 WC Database Version: 7.2.0
Checking the SSR, I can see that your database does not match your WooCommerce core version. Please update your WooCommerce database by going to
WooCommerce > Status > Tools > Update Database
Once the database is updated, can you please try again to create a new variable product and see if the SKU field is empty for the newly created variations?
If not, this could be due to caching. Please have your host purge the site cache and see if this resolves the issue here?
Let us know how that goes!
- The topic ‘SKU not saving’ is closed to new replies.