• We recently upgraded to the most recent version of woocommerce right before getting ready to launch a site and i noticed that all of the variations in the backend of the site were all defaulted to the “Any ______” values. something got messed up with the variations. so i decided to delete and add them in again, and noticed that the system unnecessarily created duplicate variations, which makes the website run slow on the front end because its querying more options than it needs to.

    all of the products that pre-existed before the update work on the front end, but the backend does not correlate. for example, a certain color warrants a $5 upcharge to the total. when i select the option for that color on the front end, it calculates – when i go to the backend (if i ever wanted to change the price) it just shows all of the variants as “Any Color.” the only way to see the actual variant with the price, is to expand all of the options and see which variant has the upcharge of $5. upon finding this variant – it shows as “Any Color” where it should be showing the actual name of the color that has the extra fee. this is super confusing.

    so there are basically two issues here:
    1. all products calculate properly on the front end after update, but the backend does not correlate any of this data to be edited. the AMOUNT of variants are there, but unfortunately, there is no way to distinguish them, as they all show the same exact attributes.
    2. when clearing out all variations and adding them anew from the attributes, there is a crazy amount of duplicate or unnecessary variations being created for no reason.

    basically, this fried my whole cart after update and im kinda not happy about it. i cant even clean up the mess because of the number of variations being created for no reason.

    here is the system info

    
    ### WordPress Environment ###
    
    Home URL: https://wpdev.mainstreethost.com/bushidotactical.com
    Site URL: https://wpdev.mainstreethost.com/bushidotactical.com
    WC Version: 3.0.5
    Log Directory Writable: ?
    WP Version: 4.7.4
    WP Multisite: –
    WP Memory Limit: ? 40 MB - We recommend setting memory to at least 64MB. See: Increasing memory allocated to PHP
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.0.17
    PHP Post Max Size: 32 MB
    PHP Time Limit: 90
    PHP Max Input Vars: 1000
    cURL Version: 7.29.0
    NSS/3.21 Basic ECC
    
    SUHOSIN Installed: –
    Max Upload Size: 32 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 3.0.5
    WC Database Prefix: msh_wp_
    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 (25) ###
    
    Gravity Forms: by rocketgenius – 2.2.1.2
    MSH Custom h1: by Matthew Backlas for Mainstreethost – 4.1
    Admin Post Navigation: by Scott Reilly – 2.0
    Advanced Custom Fields PRO: by Elliot Condon – 5.5.12
    Akismet Anti-Spam: by Automattic – 3.3
    All In One SEO Pack Pro: by Michael Torbert – 2.4.12.1
    Black Studio TinyMCE Widget: by Black Studio – 2.3.2
    Custom Post Type UI: by WebDevStudios – 1.5.3
    Display widgets: by Strategy11 – 9000.1
    Event Tickets Plus: by Modern Tribe
    Inc. – 4.4.6
    
    Event Tickets: by Modern Tribe
    Inc. – 4.4.6
    
    Gravity Forms Placeholder Add-On: by Able Engine
    William Wilkerson – 1.1.0
    
    Gravity Forms Signature Add-On: by Rocketgenius – 3.3.1
    InfiniteWP - Client: by Revmakx – 1.6.4
    Page-list: by webvitaly – 5.1
    ShiftNav - Responsive Mobile Menu: by Chris Mavricos
    SevenSpark – 1.5.1.2
    
    Simple 301 Redirects: by Scott Nellé – 1.07
    Soliloquy: by Thomas Griffin – 2.4.3.7
    The Events Calendar: by Modern Tribe
    Inc. – 4.5.0.2
    
    WooCommerce First Data Payeezy Gateway: by SkyVerge – 4.2.0 – 4.2.1 is available
    Woocommerce Products Slider: by pickplugins – 1.12.7
    WooCommerce Table Rate Shipping: by Automattic – 3.0.2 – 3.0.3 is available
    WooCommerce: by Automattic – 3.0.5
    Wordfence Security: by Wordfence – 6.3.7
    WordPress Importer: by wordpressdotorg – 0.6.3
    
    ### 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)
    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)
    
    ### WC Pages ###
    
    Shop base: #4 - /shop/
    Cart: #5 - /cart/
    Checkout: #6 - /checkout/
    My account: #7 - /my-account/
    
    ### Theme ###
    
    Name: MSH Responsive (SASS) Theme
    Version: 1.7
    Author URL: https://www.mainstreethost.com
    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: bones/archive-product.php
    bones/woocommerce/emails/admin-new-order.php
    bones/woocommerce/emails/customer-completed-order.php
    bones/woocommerce/emails/customer-on-hold-order.php
    bones/single-product.php
    
    ### Payeezy Gateway TeleCheck ###
    
    Environment: Production
    Debug Mode: Off
    

    here is the screenshot of issue 1.
    https://wpdev.mainstreethost.com/bushidotactical.com/issue1.PNG

    here is screenshot for issue 2a (all variations showing ANY, ANY)
    https://wpdev.mainstreethost.com/bushidotactical.com/issue2a.PNG

    and here is 2b (proof that there are 2 variations with the same properties, but 2 different prices – this indicates that its somehow still calculating the info)
    https://wpdev.mainstreethost.com/bushidotactical.com/issue2b.PNG

    here is the product in question (this is affecting all products)
    https://wpdev.mainstreethost.com/bushidotactical.com/product/halo-retro-fit-cummerbund/

    on the front end – kryptek typhon is +$5 and XXL size is +$3
    youll see its calculating, but the variations make no sense….

    PLEASE HELP

Viewing 1 replies (of 1 total)
  • Thread Starter bmsinc

    (@bmsinc)

    if this happened to anyone else – i finally got a response from woocommerce support. they mentioned they have several other tickets with this issue.

    you can apparently rename the attribute to something else, and then put the name back to what it was and it will somehow update.

    heres the official response:

    We’ve had several reports of this issue with Variations and attributes. Here’s what we’re seeing:

    When you have Global Attributes, the products will go to “Any” for the variations, which causes issues.

    Here’s what I would suggest:
    1. You can RENAME the global attribute to something different, and re-save your products
    2. You can roll-back to 3.0.4 and wait for a fix in WooCommerce

    If you need 3.0.4 you can get it here: https://a.mikey.link/7i1PU/3KTAgaFv

    Let me know how that goes!

    Best,

    Mikey A. – Happiness Engineer

    I hope this helps someone. we just redid the whole cart because the response took too long.

Viewing 1 replies (of 1 total)
  • The topic ‘Add Variations Creates unnessary duplicates’ is closed to new replies.