Support » Plugin: WooCommerce » Variations missing after update, also not able to delete

  • I’m using WooCommerce and the Subscriptions extension to create variable subscription products. The client was previously using an older 2.x version of WooCommerce and after the recent 3.x updates, all of the Variations for this product disappeared.

    I manually added the variations back, which seemed to work ok at first, then I noticed a couple issues:

    First, the actual Product page is loading extremely slowly now and shows a spinner for around 5 seconds. We have around 40 variations for this product but I’m assuming that shouldn’t be enough to slow the page to this extent.

    The second issue is the variations can’t be deleted now. When I click the “remove” link and save the page, all of the same variations are shown in the editor again.

    There seems to be some sort of data bug that’s happening. I can confirm that we’re running all of the latest versions of WordPress and the plugins. The previous developer did modify quite a few of the WooCommerce files, including the variable-subscriptions.php file (the edited versions are in the theme’s folder). However, I’m not sure these would be related to the issue with not being able to remove variations in the admin editor.

    One other additional clue: occasionally, the Product page itself will show an “internal 500” error in the console and mentions something about ?wc-ajax=get_variation. Unfortunately, I can’t reproduce this error consistently but I have seen it a few times during testing after the 3.x updates.

    I realize this is difficult to troubleshoot but any advice on where I should look to find the problem would be greatly appreciated. Thank you for your time.

    System status report below:

    
    ### WordPress Environment ###
    
    Home URL: redacted
    Site URL: redacted
    WC Version: 3.0.6
    Log Directory Writable: ✔
    WP Version: 4.7.4
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_US
    
    ### Server Environment ###
    
    Server Info: Apache/2.4
    PHP Version: 5.6.29-0+deb8u1
    PHP Post Max Size: 8 MB
    PHP Time Limit: 30
    PHP Max Input Vars: 1000
    cURL Version: 7.38.0
    OpenSSL/1.0.1t
    
    SUHOSIN Installed: –
    Max Upload Size: 8 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 3.0.6
    WC Database Prefix: redacted
    woocommerce_sessions: ✔
    woocommerce_api_keys: ✔
    woocommerce_attribute_taxonomies: ✔
    woocommerce_downloadable_product_permissions: ✔
    woocommerce_order_items: ✔
    woocommerce_order_itemmeta: ✔
    woocommerce_tax_rates: ✔
    woocommerce_tax_rate_locations: ✔
    woocommerce_shipping_zones: ✔
    woocommerce_shipping_zone_locations: ✔
    woocommerce_shipping_zone_methods: ✔
    woocommerce_payment_tokens: ✔
    woocommerce_payment_tokenmeta: ✔
    MaxMind GeoIP Database: ✔
    
    ### Security ###
    
    Secure connection (HTTPS): ❌Your store is not using HTTPS. Learn more about HTTPS and SSL Certificates.
    Hide errors from visitors: ✔
    
    ### Active Plugins (28) ###
    
    Add Logo to Admin: by c.bavota – 1.6.2
    Advanced Custom Fields: Nav Menu Field: by Faison Zutavern – 2.0.0
    Advanced Custom Fields PRO: by Elliot Condon – 5.5.13
    All In One WP Security: by Tips and Tricks HQ
    Peter
    Ruhul
    Ivy – 4.2.7
    
    Breadcrumb NavXT: by John Havlik – 5.7.0
    Eggplant 301 Redirects: by Shawn Wernig http://www.eggplantstudios.ca – 2.3.0
    MailChimp for WordPress Lite: by ibericode – 2.3.16
    New User Approve: by Josh Harrison – 1.7.4
    Password Protected: by Ben Huson – 2.0.3
    Simple Custom Post Order: by Colorlib – 2.3.2
    UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
    DavidAnderson – 2.13.1.1
    
    User Role Editor Pro: by Vladimir Garagulya – 4.32.3
    Visual Form Builder: by Matthew Muro – 2.9.2
    WC Variations Radio Buttons: by 8manos – 2.0.0
    Webgility: by Webgility – v331
    Widget CSS Classes: by C.M. Kendrick – 1.4.0
    WooCommerce Dynamic Pricing: by Lucas Stark – 3.0.7
    WooCommerce Intuit Payments Gateway: by SkyVerge – 2.0.1
    WooCommerce Packages Mapping: by Bartek Makowski – 1.0.0
    WooCommerce Quick View: by WooCommerce – 1.1.8
    WooCommerce FedEx Shipping: by WooCommerce – 3.4.5 – 3.4.6 is available
    WooCommerce Shipping Per Product v2: by WooThemes – 2.2.8
    WooCommerce - ShipStation Integration: by WooCommerce – 4.1.14 – 4.1.15 is available
    WooCommerce Subscriptions Gifting: by Prospress Inc. – 1.0
    WooCommerce Subscriptions: by Prospress Inc. – 2.2.6
    WooCommerce: by Automattic – 3.0.6
    WooCommerce Helper: by WooCommerce – 1.7.2 – Network enabled
    wpMandrill: by Mandrill – 1.33
    
    ### Settings ###
    
    API Enabled: ✔
    Force SSL: –
    Currency: USD ($)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    subscription (subscription)
    variable (variable)
    variable subscription (variable-subscription)
    
    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)
    
    ### WC Pages ###
    
    Shop base: #6 - /shop/
    Cart: #7 - /cart/
    Checkout: #8 - /checkout/
    My account: #9 - /my-account/
    
    ### Theme ###
    
    Name: redacted
    Version: 1
    Author URL: 
    Child Theme: ❌ – If you're modifying WooCommerce on a parent theme you didn't build personally
    then we recommend using a child theme. See: How to create a child theme
    
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: redacted/woocommerce/archive-product.php
    redacted/woocommerce/cart/cart-empty.php
    redacted/woocommerce/cart/cart-item-data.php version 2.1.0 is out of date. The core version is 2.4.0
    redacted/woocommerce/cart/cart-shipping.php version 2.3.0 is out of date. The core version is 2.5.0
    redacted/woocommerce/cart/cart-totals.php
    redacted/woocommerce/cart/cart.php version 2.3.8 is out of date. The core version is 3.0.3
    redacted/woocommerce/cart/cross-sells.php version 1.6.4 is out of date. The core version is 3.0.0
    redacted/woocommerce/cart/mini-cart.php version 2.1.0 is out of date. The core version is 2.5.0
    redacted/woocommerce/cart/shipping-calculator.php
    redacted/woocommerce/checkout/cart-errors.php version 1.6.4 is out of date. The core version is 2.4.0
    redacted/woocommerce/checkout/form-billing.php version 2.1.2 is out of date. The core version is 3.0.0
    redacted/woocommerce/checkout/form-checkout.php
    redacted/woocommerce/checkout/form-coupon.php
    redacted/woocommerce/checkout/form-login.php
    redacted/woocommerce/checkout/form-pay.php
    redacted/woocommerce/checkout/form-shipping.php version 2.2.0 is out of date. The core version is 3.0.0
    redacted/woocommerce/checkout/payment-method.php
    redacted/woocommerce/checkout/payment.php
    redacted/woocommerce/checkout/review-order.php
    redacted/woocommerce/checkout/thankyou.php version 2.2.0 is out of date. The core version is 3.0.0
    redacted/woocommerce/content-product.php version 2.6.1 is out of date. The core version is 3.0.0
    redacted/woocommerce/content-product_cat.php version 1.6.4 is out of date. The core version is 2.6.1
    redacted/woocommerce/content-single-product.php version 1.6.4 is out of date. The core version is 3.0.0
    redacted/woocommerce/content-widget-product.php version - is out of date. The core version is 2.5.0
    redacted/woocommerce/emails/admin-cancelled-order.php version 2.3.0 is out of date. The core version is 2.5.0
    redacted/woocommerce/emails/admin-new-order.php version 2.0.0 is out of date. The core version is 2.5.0
    redacted/woocommerce/emails/customer-completed-order.php version 1.6.4 is out of date. The core version is 2.5.0
    redacted/woocommerce/emails/customer-invoice.php version 2.2.0 is out of date. The core version is 2.5.0
    redacted/woocommerce/emails/customer-new-account.php
    redacted/woocommerce/emails/customer-note.php version 1.6.4 is out of date. The core version is 2.5.0
    redacted/woocommerce/emails/customer-processing-order.php version 1.6.4 is out of date. The core version is 2.5.0
    redacted/woocommerce/emails/customer-reset-password.php
    redacted/woocommerce/emails/email-addresses.php version 2.2.0 is out of date. The core version is 3.0.0
    redacted/woocommerce/emails/email-footer.php
    redacted/woocommerce/emails/email-header.php version 2.3.0 is out of date. The core version is 2.4.0
    redacted/woocommerce/emails/email-order-items.php version 2.1.2 is out of date. The core version is 3.0.0
    redacted/woocommerce/emails/email-styles.php
    redacted/woocommerce/emails/plain/admin-cancelled-order.php version 2.3.0 is out of date. The core version is 2.5.0
    redacted/woocommerce/emails/plain/admin-new-order.php version 2.0.0 is out of date. The core version is 2.5.0
    redacted/woocommerce/emails/plain/customer-completed-order.php version 2.0.0 is out of date. The core version is 2.5.0
    redacted/woocommerce/emails/plain/customer-invoice.php version 2.2.0 is out of date. The core version is 2.5.0
    redacted/woocommerce/emails/plain/customer-new-account.php
    redacted/woocommerce/emails/plain/customer-note.php version 2.0.0 is out of date. The core version is 2.5.0
    redacted/woocommerce/emails/plain/customer-processing-order.php version 2.2.0 is out of date. The core version is 2.5.0
    redacted/woocommerce/emails/plain/customer-reset-password.php
    redacted/woocommerce/emails/plain/email-addresses.php
    redacted/woocommerce/emails/plain/email-order-items.php version 2.1.2 is out of date. The core version is 3.0.0
    redacted/woocommerce/global/breadcrumb.php
    redacted/woocommerce/global/form-login.php
    redacted/woocommerce/global/quantity-input.php version 2.1.0 is out of date. The core version is 2.5.0
    redacted/woocommerce/global/sidebar.php
    redacted/woocommerce/global/wrapper-end.php
    redacted/woocommerce/global/wrapper-start.php
    redacted/woocommerce/loop/add-to-cart.php version 2.1.0 is out of date. The core version is 3.0.0
    redacted/woocommerce/loop/loop-end.php
    redacted/woocommerce/loop/loop-start.php
    redacted/woocommerce/loop/no-products-found.php
    redacted/woocommerce/loop/orderby.php
    redacted/woocommerce/loop/pagination.php
    redacted/woocommerce/loop/price.php
    redacted/woocommerce/loop/rating.php version 2.0.0 is out of date. The core version is 3.0.0
    redacted/woocommerce/loop/result-count.php version 2.0.0 is out of date. The core version is 3.0.0
    redacted/woocommerce/loop/sale-flash.php
    redacted/woocommerce/myaccount/form-add-payment-method.php version 2.1 is out of date. The core version is 3.0.0
    redacted/woocommerce/myaccount/form-edit-account.php version 2.2.7 is out of date. The core version is 2.6.0
    redacted/woocommerce/myaccount/form-edit-address.php version 2.1.0 is out of date. The core version is 3.0.0
    redacted/woocommerce/myaccount/form-login.php version 2.2.6 is out of date. The core version is 2.6.0
    redacted/woocommerce/myaccount/form-lost-password.php version 2.3.0 is out of date. The core version is 3.0.0
    redacted/woocommerce/myaccount/my-account.php version 2.0.0 is out of date. The core version is 2.6.0
    redacted/woocommerce/myaccount/my-address.php version 2.2.0 is out of date. The core version is 2.6.0
    redacted/woocommerce/myaccount/my-downloads.php
    redacted/woocommerce/myaccount/my-orders.php
    redacted/woocommerce/myaccount/view-order.php version 2.2.0 is out of date. The core version is 3.0.0
    redacted/woocommerce/notices/error.php
    redacted/woocommerce/notices/notice.php
    redacted/woocommerce/notices/success.php
    redacted/woocommerce/order/form-tracking.php
    redacted/woocommerce/order/order-again.php
    redacted/woocommerce/order/order-details-customer.php version 2.4.0 is out of date. The core version is 3.0.0
    redacted/woocommerce/order/order-details.php version 2.5.3 is out of date. The core version is 3.0.0
    redacted/woocommerce/order/tracking.php
    redacted/woocommerce/product-searchform.php version - is out of date. The core version is 2.5.0
    redacted/woocommerce/single-product/add-to-cart/external.php
    redacted/woocommerce/single-product/add-to-cart/grouped.php version 2.1.7 is out of date. The core version is 3.0.6
    redacted/woocommerce/single-product/add-to-cart/simple.php version 2.1.0 is out of date. The core version is 3.0.0
    redacted/woocommerce/single-product/add-to-cart/variable.php version 2.5.0 is out of date. The core version is 3.0.0
    redacted/woocommerce/single-product/meta.php version 1.6.4 is out of date. The core version is 3.0.0
    redacted/woocommerce/single-product/price.php version 1.6.4 is out of date. The core version is 3.0.0
    redacted/woocommerce/single-product/product-attributes.php version 2.1.3 is out of date. The core version is 3.0.0
    redacted/woocommerce/single-product/related.php version 1.6.4 is out of date. The core version is 3.0.0
    redacted/woocommerce/single-product/short-description.php
    redacted/woocommerce/single-product/tabs/additional-information.php version 2.0.0 is out of date. The core version is 3.0.0
    redacted/woocommerce/single-product/tabs/description.php
    redacted/woocommerce/single-product/tabs/tabs.php version 2.0.0 is out of date. The core version is 2.4.0
    redacted/woocommerce/single-product/title.php
    redacted/woocommerce/single-product/up-sells.php version 1.6.4 is out of date. The core version is 3.0.0
    redacted/woocommerce/single-product-reviews.php
    redacted/woocommerce/single-product.php
    redacted/woocommerce/taxonomy-product_cat.php
    redacted/woocommerce/taxonomy-product_tag.php
    
    Outdated Templates: ❌Learn how to update
    
    ### subscriptions ###
    
    WCS_DEBUG: ✔ No
    Subscriptions Mode: ❌ Staging
    
    ### Intuit QBMS ###
    
    Environment: Production
    Tokenization Enabled: ✔
    Debug Mode: Off
    
Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter RecoilDesign

    (@recoildesign)

    More details: this morning I attempted to use the “delete all variations” option, then the admin page showed the loading spinner graphic and seems stuck there now. In viewing console, I see this error:

    Failed to load resource: the server responded with status of 500 (Internal Server Error)
    WEBSITE-URL/wp-admin/admin-ajax.php

    However, after manually reloading the product page in admin, I can confirm the variations were deleted.

    I proceeded to create 1 new variation with “any attributes”, saved the product again, and now the product page is very fast again and does not have a spinner graphic.

    In my opinion, this means that the 40+ variations I had before were causing the delay but I’d still like feedback on if that sounds correct or now.

    • This reply was modified 4 years, 8 months ago by RecoilDesign.
    Thread Starter RecoilDesign

    (@recoildesign)

    Ok, went to modify the shipping details for one of my Subscription Variables today, saved the page, now one of my old DELETED variations is back in this product and cannot be deleted no matter what I do.

    There’s a serious problem somewhere, either with WooCommerce 3.0.8 or the latest version of the Subscriptions extension.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Variations missing after update, also not able to delete’ is closed to new replies.