Support » Plugin: WooCommerce » product categories duplicated after woocommerce update

  • Resolved darrenmaximo

    (@darrenmaximo)


    Hi,

    Im having this issue after woocommerce update.
    The product category are duplicated, each duplicated category has the same slug and ID of the original category, also when I try to delete the duplicate the original category also deleted.

    this is the url of the website.

    ### WordPress Environment ###
    
    Home URL: http://www.rockface.com.au
    Site URL: http://www.rockface.com.au
    WC Version: 2.6.1
    Log Directory Writable: ✔
    WP Version: 4.5.2
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_US
    
    ### Server Environment ###
    
    Server Info: LiteSpeed
    PHP Version: ❌ 5.4.44 - We recommend a minimum PHP version of 5.6. See: How to update your PHP version
    PHP Post Max Size: 8 MB
    PHP Time Limit: 30
    PHP Max Input Vars: 1000
    cURL Version: 7.38.0
    OpenSSL/1.0.1e
    
    SUHOSIN Installed: –
    MySQL Version: 5.6.30
    Max Upload Size: 8 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 2.6.1
    :
    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: ✔
    
    ### Active Plugins (23) ###
    
    Redux Framework: by Team Redux – 3.6.0.2
    LayerSlider WP: by Kreatura Media – 5.6.8
    Advanced Custom Fields: by Elliot Condon – 4.4.7
    All In One SEO Pack Pro: by Michael Torbert – 2.4.5.1
    BackWPup: by Inpsyde GmbH – 3.3.2
    Contact Form 7 Honeypot: by Nocean – 1.9
    Contact Form 7: by Takayuki Miyoshi – 4.4.2
    Disable XML-RPC: by Philip Erb – 1.0.1
    Limit Login Attempts: by Johan Eenfeldt – 1.7.1
    Max Mega Menu: by Tom Hemsley – 2.1.5
    Really Simple CAPTCHA: by Takayuki Miyoshi – 1.9
    Rename wp-login.php: by Ella Iseulde Van Dorpe – 2.5.5
    Sucuri Security - Auditing, Malware Scanner and Hardening: by Sucuri
    INC – 1.7.17
    
    WooCommerce Customizer: by SkyVerge – 2.3.1
    Securepay for WooCommerce: by SolverCircle – 1.0.0
    WooCommerce: by WooThemes – 2.6.1
    WP-Ban: by Lester 'GaMerZ' Chan – 1.68
    WP Google Map Plugin: by flippercode – 3.1.1
    WP Lightbox 2: by Syed Balkhi – 3.0.6.2
    WP-SpamShield: by Scott Allen – 1.9.8.7
    YITH WooCommerce Compare: by Yithemes – 2.0.5
    YITH WooCommerce Quick View: by YITHEMES – 1.1.2
    YITH WooCommerce Wishlist: by YITHEMES – 2.0.16
    
    ### Settings ###
    
    Force SSL: ✔
    Currency: AUD ($)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    
    ### API ###
    
    API Enabled: ✔
    
    ### WC Pages ###
    
    Shop Base: #248 - /shop/
    Cart: #249 - /cart/
    Checkout: #250 - /checkout/
    My Account: #251 - /my-account/
    
    ### Taxonomies ###
    
    Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    
    ### Theme ###
    
    Name: Fabia Child Theme
    Version: 1.4
    Author URL: https://www.magikcommerce.com/
    Child Theme: ✔
    Parent Theme Name: Fabia
    Parent Theme Version: 1.4
    Parent Theme Author URL: https://www.magikcommerce.com/
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: fabia/woocommerce/archive-product.php
    fabia/woocommerce/cart/cart-empty.php
    fabia/woocommerce/cart/cart-item-data.php
    fabia/woocommerce/cart/cart-shipping.php version 2.3.0 is out of date. The core version is 2.5.0
    fabia/woocommerce/cart/cart-totals.php
    fabia/woocommerce/cart/cart.php
    fabia/woocommerce/cart/cross-sells.php
    fabia/woocommerce/cart/mini-cart.php version 2.1.0 is out of date. The core version is 2.5.0
    fabia/woocommerce/checkout/cart-errors.php
    fabia/woocommerce/checkout/form-billing.php
    fabia/woocommerce/checkout/form-checkout.php
    fabia/woocommerce/checkout/form-coupon.php
    fabia/woocommerce/checkout/form-login.php
    fabia/woocommerce/checkout/form-pay.php version 2.4.7 is out of date. The core version is 2.5.0
    fabia/woocommerce/checkout/form-shipping.php
    fabia/woocommerce/checkout/payment-method.php
    fabia/woocommerce/checkout/payment.php version 2.4.7 is out of date. The core version is 2.5.0
    fabia/woocommerce/checkout/review-order.php
    fabia/woocommerce/checkout/thankyou.php
    fabia/woocommerce/content-product.php version 2.4.0 is out of date. The core version is 2.6.1
    fabia/woocommerce/content-product_cat.php version 2.5.2 is out of date. The core version is 2.6.1
    fabia/woocommerce/content-single-product.php
    fabia/woocommerce/content-widget-product.php version - is out of date. The core version is 2.5.0
    fabia-child/woocommerce/emails/admin-new-order.php
    fabia/woocommerce/global/breadcrumb.php
    fabia/woocommerce/global/form-login.php
    fabia/woocommerce/global/quantity-input.php version 2.1.0 is out of date. The core version is 2.5.0
    fabia/woocommerce/global/sidebar.php
    fabia/woocommerce/global/wrapper-end.php
    fabia/woocommerce/global/wrapper-start.php
    fabia/woocommerce/loop/add-to-cart.php version 2.1.0 is out of date. The core version is 2.5.0
    fabia/woocommerce/loop/loop-end.php version - is out of date. The core version is 2.0.0
    fabia/woocommerce/loop/loop-start.php version - is out of date. The core version is 2.0.0
    fabia/woocommerce/loop/no-products-found.php
    fabia/woocommerce/loop/orderby.php
    fabia/woocommerce/loop/pagination.php
    fabia/woocommerce/loop/price.php
    fabia/woocommerce/loop/rating.php
    fabia/woocommerce/loop/result-count.php
    fabia/woocommerce/loop/sale-flash.php
    fabia/woocommerce/myaccount/form-add-payment-method.php version 2.1 is out of date. The core version is 2.6.0
    fabia/woocommerce/myaccount/form-edit-account.php version 2.2.7 is out of date. The core version is 2.6.0
    fabia/woocommerce/myaccount/form-edit-address.php version 2.1.0 is out of date. The core version is 2.6.0
    fabia/woocommerce/myaccount/form-login.php version 2.2.6 is out of date. The core version is 2.6.0
    fabia/woocommerce/myaccount/form-lost-password.php version 2.3.0 is out of date. The core version is 2.6.0
    fabia/woocommerce/myaccount/my-account.php version 2.0.0 is out of date. The core version is 2.6.0
    fabia/woocommerce/myaccount/my-address.php version 2.2.0 is out of date. The core version is 2.6.0
    fabia/woocommerce/myaccount/my-downloads.php
    fabia/woocommerce/myaccount/my-orders.php
    fabia/woocommerce/myaccount/view-order.php version 2.2.0 is out of date. The core version is 2.6.0
    fabia/woocommerce/notices/error.php
    fabia/woocommerce/notices/notice.php
    fabia/woocommerce/notices/success.php
    fabia/woocommerce/product-searchform.php version - is out of date. The core version is 2.5.0
    fabia/woocommerce/single-product/add-to-cart/external.php
    fabia/woocommerce/single-product/add-to-cart/grouped.php
    fabia/woocommerce/single-product/add-to-cart/simple.php
    fabia/woocommerce/single-product/add-to-cart/variable.php version 2.4.0 is out of date. The core version is 2.5.0
    fabia/woocommerce/single-product/meta.php
    fabia/woocommerce/single-product/price.php version 1.6.4 is out of date. The core version is 2.4.9
    fabia/woocommerce/single-product/product-attributes.php
    fabia/woocommerce/single-product/product-image.php
    fabia/woocommerce/single-product/product-thumbnails.php
    fabia/woocommerce/single-product/rating.php
    fabia/woocommerce/single-product/related.php
    fabia/woocommerce/single-product/review.php version 2.1.0 is out of date. The core version is 2.6.0
    fabia/woocommerce/single-product/sale-flash.php
    fabia/woocommerce/single-product/share.php
    fabia/woocommerce/single-product/short-description.php
    fabia/woocommerce/single-product/tabs/additional-information.php
    fabia/woocommerce/single-product/tabs/description.php
    fabia/woocommerce/single-product/tabs/tabs.php
    fabia/woocommerce/single-product/title.php
    fabia/woocommerce/single-product/up-sells.php
    fabia/woocommerce/single-product-reviews.php
    fabia/woocommerce/single-product.php
    fabia/woocommerce/taxonomy-product_cat.php
    fabia/woocommerce/taxonomy-product_tag.php
    
    : Learn how to update outdated templates

    Thanks

    https://wordpress.org/plugins/woocommerce/

Viewing 15 replies - 1 through 15 (of 29 total)
  • Plugin Author Mike Jolley

    (@mikejolley)

    You’re not the first to report something similar to this, however its not affecting all sites and seems to vary between taxonomies. Product categories are entirely handled by WordPress.

    Please disable your plugins and see if the issue goes away – that will reveal any form of conflict.

    Had the same issue with the latest WooCommerce Data Update. Ended up Restoring a back-up to go back prior to update.

    Googling for a solution and stumbled on this. Will wait to see if there’s a solution before updating again.

    Plugin Author Mike Jolley

    (@mikejolley)

    christaplin any similarities between his install and yours?

    Our report below. Similarities are outdated PHP versions at a quick glance.

    ### WordPress Environment ###
    
    Home URL: http://www.dementiaworkshop.co.uk
    Site URL: http://www.dementiaworkshop.co.uk
    WC Version: 2.6.1
    Log Directory Writable: ✔
    WP Version: 4.5.2
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_US
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: ❌ 5.3.29 - We recommend a minimum PHP version of 5.6. See: How to update your PHP version
    PHP Post Max Size: 8 MB
    PHP Time Limit: 30
    PHP Max Input Vars: 1000
    cURL Version: 7.38.0
    OpenSSL/1.0.0
    
    SUHOSIN Installed: –
    MySQL Version: ❌ 5.5.50 - We recommend a minimum MySQL version of 5.6. See: WordPress Requirements
    Max Upload Size: 2 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ❌ Your server does not have the SoapClient class enabled - some gateway plugins which use SOAP may not work as expected.
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ❌ wp_remote_post() failed. PayPal IPN won't work with your server. Contact your hosting provider. Error: Unsupported SSL protocol version
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 2.5.5
    :
    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: ✔
    
    ### Active Plugins (22) ###
    
    Remove Comments Absolutely: by Frank Bültge – 1.2.0
    Akismet: by Automattic – 3.1.11
    Gecka Submenu: by Gecka Apps
    Gecka – 0.7.3
    
    Google XML Sitemaps: by Arne Brachhold – 4.0.8
    Imsanity: by Jason Hinkle – 2.3.6
    Jetpack by WordPress.com: by Automattic – 4.0.4
    MailChimp for WordPress: by ibericode – 3.1.10
    RICG Responsive Images: by The RICG – 3.1.1
    Testimonials: by WooThemes – 1.5.4
    Cookie Consent: by Catapult_Themes – 2.0.12
    White Label CMS: by www.videousermanuals.com – 1.5.7
    WooCommerce Accepted Payment Methods: by jameskoster – 0.7.0
    WooCommerce Print Invoice & Delivery Note: by Triggvy Gunderson – 4.1.5
    WooCommerce - Store Exporter: by Visser Labs – 1.8.6
    WooCommerce Sequential Order Numbers: by SkyVerge – 1.7.0
    WooCommerce: by WooThemes – 2.6.1
    WooDojo: by WooThemes – 1.5.4
    WooSidebars: by WooThemes – 1.4.3
    WooThemes Helper: by WooThemes – 1.5.2
    WordPress Ping Optimizer: by Pankaj Jha – 2.34.8.5
    WP Resized Image Quality: by Mike Bijon
    Etch Software – 2.1.2
    
    WP Smush: by WPMU DEV – 2.3.1
    
    ### Settings ###
    
    Force SSL: –
    Currency: GBP (£)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    
    ### API ###
    
    API Enabled: ✔
    
    ### WC Pages ###
    
    Shop Base: #19 - /shop/
    Cart: #20 - /cart/
    Checkout: #21 - /checkout/
    My Account: #22 - /my-account/
    
    ### Taxonomies ###
    
    Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    
    ### Theme ###
    
    Name: Superstore
    Version: 1.1.4
    Author URL: http://www.woothemes.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: superstore/woocommerce/content-product_cat.php version 1.6.4 is out of date. The core version is 2.6.1
    superstore/woocommerce/single-product/tabs/description.php
    
    : Learn how to update outdated templates

    Plugin Author Mike Jolley

    (@mikejolley)

    Just to be clear, are these shown in the backend as duplicates?

    They were displaying in under categories twice and on the front end as duplicates too. They had the same slug etc and deleting one of the entries would delete both.

    Plugin Author Mike Jolley

    (@mikejolley)

    You could look in the database itself and see if there are duplicates in any of the terms tables for whatever reason. Not occurring on any test sites I have access to.

    I’ve had the same issue also.

    To give you some more info:

    • I reverted theme back to Twenty Twelve
    • All plugins were decativated, apart from WooCommerce
    • Categories are duplicated on front-end and in the admin
    • Category page set as ‘Display type’ > ‘Subcategories’

    I’m not a developer that knows SQL properly, but looking through the database, I can only see 1 instance of each category.

    System Status Report:

    ### WordPress Environment ###
    
    Home URL: http://peddlerscycles.bfs004.bfhosting.co.uk
    Site URL: http://peddlerscycles.bfs004.bfhosting.co.uk
    WC Version: 2.6.1
    Log Directory Writable: ✔
    WP Version: 4.5.2
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: –
    Language: en_GB
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: ❌ 5.3.17 - We recommend a minimum PHP version of 5.6. See: How to update your PHP version
    PHP Post Max Size: 20 MB
    PHP Time Limit: 30
    PHP Max Input Vars: 1000
    cURL Version: 7.15.5
     OpenSSL/0.9.8b
    
    SUHOSIN Installed: –
    MySQL Version: ❌ 5.5.28 - We recommend a minimum MySQL version of 5.6. See: WordPress Requirements
    Max Upload Size: 20 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    
    ### Database ###
    
    WC Database Version: 2.6.1
    :
    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: ❌ The MaxMind GeoIP Database does not exist - Geolocation will not function. You can download and install it manually from http://dev.maxmind.com/geoip/legacy/geolite/ to the path:
    
    ### Active Plugins (1) ###
    
    WooCommerce: by WooThemes – 2.6.1
    
    ### Settings ###
    
    Force SSL: –
    Currency: GBP (£)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    
    ### API ###
    
    API Enabled: ✔
    
    ### WC Pages ###
    
    Shop Base: #3 - /shop/
    Basket: #4 - /basket/
    Checkout: #5 - /checkout/
    My Account: #6 - /my-account/
    
    ### Taxonomies ###
    
    Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    
    ### Theme ###
    
    Name: Twenty Twelve
    Version: 2.0
    Author URL: https://wordpress.org/
    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: –
    Plugin Author Mike Jolley

    (@mikejolley)

    Great – thank you!

    Had the exact same issue.
    Each duplicated category has the same slug and ID of the original category, so I’m afraid to delete them.

    I saw the github link, and copied the pasted the text into my wc-term-functions.php file, and this fixed this issue. WHEW!!

    Thanks Mike!

    Hi, i am having the same inssue in woocommerce 3.0 updtate, can you help me?
    Thank you!

    Dear Binhoscc,

    I also experienced same issue. Try going to your wc-terms-functions.php and find this $clauses[‘fields’] = ‘DISTINCT ‘ . $clauses[‘fields’]. ‘, tm.meta_value’;

    try removing this . ‘, tm.meta_value’ and save. See if this solves your duplicate product categories.

    I have 1 more issue in which if i unassigned my old product from the category that it was set, it shows out of stock even it has stock. Can you see from your side if you have this too.

    Regards

    Hello @dlareg08, unfortunately there was no ‘, tm.meta_value’ there.
    Anything more i could do?
    Thank you

    Hi, I just had the same issue after updating the database in 3.0.

Viewing 15 replies - 1 through 15 (of 29 total)
  • The topic ‘product categories duplicated after woocommerce update’ is closed to new replies.