Add Variations Creates unnessary duplicates
-
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.PNGhere is screenshot for issue 2a (all variations showing ANY, ANY)
https://wpdev.mainstreethost.com/bushidotactical.com/issue2a.PNGand 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.PNGhere 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
- The topic ‘Add Variations Creates unnessary duplicates’ is closed to new replies.