Can’t update/edit variation’s attributes

  • Resolved cecowe

    (@cecowe)


    3 years, 5 months ago

    Hello,
    As always I’m trying to import new product into my shop.
    Variable and variations are created successfully. No problem for now.

    I’ve tried to edit the export and import it after correction but it seems the following columns of the variations are not importing.

    Attribute 1 name Attribute 1 value(s) Attribute 1 visible Attribute 1 global

    The import is done but no changes appeared (https://prnt.sc/1u2lgu9). As you can see at the image there are two options but nothing is visible to choose from as here (https://prnt.sc/1u2lold)

    I deactivated all the plugins except woocommerce, tried to upload the file once again, nothing happened.

    Here is the table in xlsx format to see what I’m talking about.
    https://easyupload.io/d89v2j

    The first two lines are the already uploaded product with working Sizes, I mean visible in the front end.

    The second two lines are the lines I’m importing successfully but nothing changes in the Attributes columns. They are empty now, forth of them.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Thu P. a11n

    (@thup90)

    Hi there,

    What tool are you exporting/ importing the xlsx file with?

    Could you share your System Status Report, it would help us to understand your site setup a bit better. 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 reply.

    Thread Starter cecowe

    (@cecowe)

    
### WordPress Environment ###

WordPress address (URL): https://www.sportfaster.com
Site address (URL): https://www.sportfaster.com
WC Version: 5.7.1
REST API Version: ? 5.7.1
WC Blocks Version: ? 5.7.2
Action Scheduler Version: ? 3.2.1
WC Admin Version: ? 2.6.5
Log Directory Writable: ?
WP Version: 5.8.1
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: bg_BG
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.4.23
PHP Post Max Size: 150 MB
PHP Time Limit: 300
PHP Max Input Vars: 5000
cURL Version: 7.77.0
OpenSSL/1.1.1l

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

### Database ###

WC Database Version: 5.7.1
WC Database Prefix: wp_
Total Database Size: 257.99MB
Database Data Size: 184.23MB
Database Index Size: 73.76MB
wp_woocommerce_sessions: Data: 1.02MB + 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.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 0.06MB + Index: 0.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: 3.42MB + Index: 2.44MB + 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: 2.48MB + Index: 2.00MB + Engine InnoDB
wp_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_cli_cookie_scan: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_cli_cookie_scan_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_cli_cookie_scan_cookies: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_cli_cookie_scan_url: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_cli_scripts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_coderun_oneclickwoo_orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_enjoy_instagram_hashtags: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_enjoy_instagram_media: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ewwwio_images: Data: 10.52MB + Index: 12.11MB + Engine InnoDB
wp_ewwwio_queue: Data: 0.41MB + Index: 0.23MB + Engine InnoDB
wp_gglcptch_allowlist: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ig_actions: Data: 1.52MB + Index: 2.44MB + Engine InnoDB
wp_ig_blocked_emails: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ig_campaigns: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_ig_contactmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ig_contacts: Data: 0.08MB + Index: 0.06MB + Engine InnoDB
wp_ig_contacts_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_ig_contact_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_ig_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ig_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_ig_lists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ig_lists_contacts: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wp_ig_mailing_queue: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
wp_ig_queue: Data: 0.02MB + Index: 0.13MB + Engine InnoDB
wp_ig_sending_queue: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wp_ig_temp_import: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ig_unsubscribe_feedback: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ig_wc_cart: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wp_ig_wc_guests: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_ig_workflows: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ig_workflows_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_imagify_files: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
wp_imagify_folders: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 15.47MB + Index: 6.66MB + Engine InnoDB
wp_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_hash: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_images: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_postmeta: Data: 80.59MB + Index: 28.09MB + Engine InnoDB
wp_posts: Data: 40.52MB + Index: 6.97MB + Engine InnoDB
wp_redirection_404: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_redirection_items: Data: 0.06MB + Index: 0.09MB + Engine InnoDB
wp_redirection_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_revslider_css: Data: 0.13MB + Index: 0.02MB + Engine InnoDB
wp_revslider_css_bkp: Data: 0.02MB + Index: 0.02MB + 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.06MB + Index: 0.00MB + Engine InnoDB
wp_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_sliders: Data: 0.17MB + Index: 0.02MB + Engine InnoDB
wp_revslider_sliders_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_revslider_slides: Data: 1.52MB + Index: 0.02MB + Engine InnoDB
wp_revslider_slides_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_revslider_static_slides: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_termmeta: Data: 0.16MB + Index: 0.22MB + Engine InnoDB
wp_terms: Data: 0.11MB + Index: 0.13MB + Engine InnoDB
wp_term_relationships: Data: 2.52MB + Index: 1.50MB + Engine InnoDB
wp_term_taxonomy: Data: 0.33MB + Index: 0.11MB + Engine InnoDB
wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_trp_gettext_bg_bg: Data: 0.08MB + Index: 0.08MB + Engine InnoDB
wp_usermeta: Data: 1.52MB + Index: 0.03MB + 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: 1.02MB + 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_wdp_orders: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wdp_order_items: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wdp_rules: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wdr_order_item_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wdr_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woof_query_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woof_stat_buffer: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woof_stat_tmp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_yoast_indexable: Data: 15.55MB + Index: 6.47MB + Engine InnoDB
wp_yoast_indexable_hierarchy: Data: 0.39MB + Index: 0.53MB + Engine InnoDB
wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_yoast_primary_term: Data: 0.25MB + Index: 0.36MB + Engine InnoDB
wp_yoast_seo_links: Data: 0.27MB + Index: 0.19MB + Engine InnoDB

### Post Type Counts ###

attachment: 12391
br_labels: 10
cookielawinfo: 6
custom_css: 2
customize_changeset: 10
elementor_library: 10
es_template: 2
fmtpl_blocks: 9
mc4wp-form: 1
nav_menu_item: 176
oembed_cache: 11
page: 27
post: 24
product: 3066
product_variation: 2591
pscw-size-chart: 7
revision: 2003
rvp: 2
shop_coupon: 1
shop_order: 51
wpcf7_contact_form: 1
wpforms: 1

### Security ###

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

### Active Plugins (36) ###

Buy one click WooCommerce: by Djo – 1.17.1
Classic Widgets: by WordPress Contributors – 0.2
Contact Form 7: by Takayuki Miyoshi – 5.4.2
GDPR Cookie Consent: by WebToffee – 2.0.5
Elementor: by Elementor.com – 3.4.4
Email Subscribers & Newsletters: by Icegram – 4.8.2
Enjoy Instagram: by Mediabeta Srl – 6.2.1
Facebook for WooCommerce: by Facebook – 2.6.5
Fami Framework: by Familab – 1.0.7
Fami Template Kits: by Familab – 1.0.7
Featured Image by URL: by Knawat – 1.1.7
Header and Footer Scripts: by Digital Liberation – 2.2.1
Imagify: by WP Media – 1.10
Kirki Customizer Framework: by David Vongries – 3.1.9
Loco Translate: by Tim Whitlock – 2.5.4
MC4WP: Mailchimp for WordPress: by ibericode – 4.8.6
Meta Box: by MetaBox.io – 5.4.7
Perfect Brands for WooCommerce: by QuadLayers – 1.9.6
Premium Addons for Elementor: by Leap13 – 4.5.5
Product Size Chart for WooCommerce: by VillaTheme – 1.0.6
Recently viewed and most viewed products: by CedCommerce – 1.0.12
Redirection: by John Godley – 5.1.3
Remove Category URL: by Valerio Souza
Сreativemotion – 1.1.6

WP Version Remover: by SuperHosting.BG – 1.0
W3 Total Cache: by BoldGrid – 2.1.8
Woo Image SEO: by Danail Emandiev – 1.2.5
Premmerce Permalink Manager for WooCommerce: by premmerce – 2.3.3
Woocommerce Single Product Page Customizer: by Geek Code Lab – 1.8
Variation Swatches for WooCommerce - Pro: by Emran Ahmed – 1.1.18
Variation Swatches for WooCommerce: by Emran Ahmed – 1.1.19
WOOCS - WooCommerce Currency Switcher: by realmag777 – 1.3.7
WOOF - WooCommerce Products Filter: by realmag777 – 2.2.5.6
WooCommerce: by Automattic – 5.7.1
Yoast SEO: by Team Yoast – 17.2.1
WPForms Lite: by WPForms – 1.6.9
YITH WooCommerce Quick View: by YITH – 1.7.0

### Inactive Plugins (5) ###

Autoptimize: by Frank Goossens (futtta) – 2.9.2
EWWW Image Optimizer: by Exactly WWW – 6.2.5
Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 8.0.1
Slider Revolution: by ThemePunch – 6.5.8
WooCommerce Advanced Product Labels: by BeRocket – 1.2.3.2

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

### Settings ###

API Enabled: –
Force SSL: –
Currency: BGN (лв.)
Currency Position: left
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: #8 - /%d1%81%d0%bf%d0%be%d1%80%d1%82%d0%bd%d0%b8-%d0%bf%d1%80%d0%be%d0%b4%d1%83%d0%ba%d1%82%d0%b8/
Cart: #9 - /cart/
Checkout: #10 - /%d0%bf%d1%80%d0%b8%d0%ba%d0%bb%d1%8e%d1%87%d0%b2%d0%b0%d0%bd%d0%b5-%d0%bd%d0%b0-%d0%bf%d0%be%d1%80%d1%8a%d1%87%d0%ba%d0%b0%d1%82%d0%b0/
My account: #11 - /%d0%bc%d0%be%d1%8f%d1%82-%d0%bf%d1%80%d0%be%d1%84%d0%b8%d0%bb/
Terms and conditions: #3 - /%d0%bf%d1%80%d0%b0%d0%b2%d0%b8%d0%bb%d0%b0-%d0%b7%d0%b0-%d0%bf%d0%be%d0%bb%d0%b7%d0%b2%d0%b0%d0%bd%d0%b5/

### Theme ###

Name: Fisino Child Theme
Version: 1.0.0
Author URL: 
Child Theme: ?
Parent Theme Name: Fisino
Parent Theme Version: 1.0.9
Parent Theme Author URL: https://familab.net/
WooCommerce Support: ?

### Templates ###

Overrides: fisino/woocommerce/cart/cart-shipping.php
fisino/woocommerce/cart/cart.php
fisino/woocommerce/cart/mini-cart.php
fisino/woocommerce/checkout/form-checkout.php
fisino/woocommerce/checkout/form-coupon.php
fisino/woocommerce/checkout/payment-method.php
fisino/woocommerce/checkout/review-order.php
fisino/woocommerce/content-product.php
fisino/woocommerce/content-single-product.php
fisino/woocommerce/global/form-login.php
fisino/woocommerce/global/quantity-input.php
fisino/woocommerce/global/wrapper-end.php
fisino/woocommerce/global/wrapper-start.php
fisino/woocommerce/loop/add-to-cart.php
fisino/woocommerce/loop/loop-start.php
fisino/woocommerce/loop/pagination.php
fisino/woocommerce/myaccount/form-login.php
fisino/woocommerce/myaccount/form-lost-password.php
fisino/woocommerce/myaccount/form-reset-password.php
fisino/woocommerce/myaccount/my-address.php
fisino/woocommerce/product-searchform.php
fisino/woocommerce/single-product/add-to-cart/external.php
fisino/woocommerce/single-product/add-to-cart/grouped.php
fisino/woocommerce/single-product/add-to-cart/simple.php
fisino/woocommerce/single-product/add-to-cart/variation-add-to-cart-button.php
fisino/woocommerce/single-product/meta.php
fisino/woocommerce/single-product/product-image.php
fisino/woocommerce/single-product/product-thumbnails.php
fisino/woocommerce/single-product/rating.php
fisino/woocommerce/single-product/related.php
fisino/woocommerce/single-product/short-description.php
fisino/woocommerce/single-product/tabs/tabs.php
fisino/woocommerce/single-product/up-sells.php
fisino/woocommerce/single-product-reviews.php

### Action Scheduler ###

Canceled: 1
Oldest: 2021-09-11 11:38:30 +0000
Newest: 2021-09-11 11:38:30 +0000

Complete: 8,930
Oldest: 2021-09-04 13:08:38 +0000
Newest: 2021-10-04 16:00:00 +0000

Failed: 666
Oldest: 2021-06-17 00:28:26 +0000
Newest: 2021-10-04 15:45:49 +0000

Pending: 6
Oldest: 2021-10-05 00:01:38 +0000
Newest: 2021-10-06 09:50:53 +0000

### Status report information ###

Generated at: 2021-10-04 16:22:10 +00:00
    Thread Starter cecowe

    (@cecowe)

    Woocommerce -> Products -> Import

    Mirko P.

    (@rainfallnixfig)

    Hi @cecowe,

    Just to check if there is an update here. Did you solve the issue? If not, kindly make sure all your software is updated and share once again a sample import file to check this further.

    Thanks.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Can’t update/edit variation’s attributes’ is closed to new replies.