Support » Plugin: WooCommerce » Products attributes are all gone

  • Resolved emreozpalamutcu


    All of my product attributes disappeared, they seem to exist in the database, however on the backend, if I go to attributes there is nothing.

    How can I fix this?

    Thank you.

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Support Kenin


    Automattic Happiness Engineer

    Hi there,

    Can you please provide a bit more information here? What changes were made to the site prior to this occurring? Also, can you please paste a copy of the System Status Report under WooCommerce>Status here so we can take a look?

    Did WooCommerce update and a database update is pending?

    Here is the system report:

    ### WordPress Environment ###
    Home URL:
    Site URL:
    WC Version: 3.4.2
    Log Directory Writable: ✔
    WP Version: 4.9.6
    WP Multisite: –
    WP Memory Limit: 2 GB
    WP Debug Mode: –
    WP Cron: ✔
    Language: en_GB
    External object cache: –
    ### Server Environment ###
    Server Info: nginx/1.14.0
    PHP Version: 7.2.6
    PHP Post Max Size: 128 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 6000
    cURL Version: 7.19.7
    SUHOSIN Installed: –
    MySQL Version: 5.7.21-log
    Max Upload Size: 128 MB
    Default Timezone is UTC: ✔
    fsockopen/cURL: ✔
    SoapClient: ✔
    DOMDocument: ✔
    GZip: ✔
    Multibyte String: ✔
    Remote Post: ✔
    Remote Get: ✔
    ### Database ###
    WC Database Version: 3.4.2
    WC Database Prefix: mvmnvu_
    MaxMind GeoIP Database: ✔
    Total Database Size: 478.88MB
    Database Data Size: 465.85MB
    Database Index Size: 13.03MB
    mvmnvu_woocommerce_sessions: Data: 0.37MB + Index: 0.02MB
    mvmnvu_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB
    mvmnvu_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.01MB
    mvmnvu_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB
    mvmnvu_woocommerce_order_items: Data: 0.00MB + Index: 0.01MB
    mvmnvu_woocommerce_order_itemmeta: Data: 0.03MB + Index: 0.03MB
    mvmnvu_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB
    mvmnvu_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB
    mvmnvu_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB
    mvmnvu_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.01MB
    mvmnvu_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB
    mvmnvu_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB
    mvmnvu_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB
    mvmnvu_woocommerce_log: Data: 0.00MB + Index: 0.00MB
    mvmnvu_aiowps_events: Data: 0.00MB + Index: 0.00MB
    mvmnvu_aiowps_failed_logins: Data: 0.00MB + Index: 0.00MB
    mvmnvu_aiowps_global_meta: Data: 5.96MB + Index: 0.00MB
    mvmnvu_aiowps_login_activity: Data: 0.00MB + Index: 0.00MB
    mvmnvu_aiowps_login_lockdown: Data: 0.00MB + Index: 0.00MB
    mvmnvu_aiowps_permanent_block: Data: 0.00MB + Index: 0.00MB
    mvmnvu_commentmeta: Data: 0.00MB + Index: 0.00MB
    mvmnvu_comments: Data: 0.02MB + Index: 0.02MB
    mvmnvu_duplicator_pro_entities: Data: 0.00MB + Index: 0.01MB
    mvmnvu_duplicator_pro_packages: Data: 0.04MB + Index: 0.00MB
    mvmnvu_ebay_accounts: Data: 0.02MB + Index: 0.00MB
    mvmnvu_ebay_auctions: Data: 19.92MB + Index: 0.14MB
    mvmnvu_ebay_categories: Data: 2.81MB + Index: 0.45MB
    mvmnvu_ebay_jobs: Data: 0.04MB + Index: 0.00MB
    mvmnvu_ebay_log: Data: 254.57MB + Index: 0.62MB
    mvmnvu_ebay_messages: Data: 19.76MB + Index: 0.14MB
    mvmnvu_ebay_orders: Data: 4.00MB + Index: 0.03MB
    mvmnvu_ebay_payment: Data: 0.00MB + Index: 0.00MB
    mvmnvu_ebay_profiles: Data: 0.01MB + Index: 0.00MB
    mvmnvu_ebay_shipping: Data: 0.01MB + Index: 0.00MB
    mvmnvu_ebay_sites: Data: 0.01MB + Index: 0.00MB
    mvmnvu_ebay_store_categories: Data: 0.01MB + Index: 0.01MB
    mvmnvu_ebay_transactions: Data: 121.99MB + Index: 0.65MB
    mvmnvu_failed_jobs: Data: 0.00MB + Index: 0.00MB
    mvmnvu_hook_list: Data: 0.00MB + Index: 0.00MB
    mvmnvu_imagify_files: Data: 0.02MB + Index: 0.08MB
    mvmnvu_imagify_folders: Data: 0.02MB + Index: 0.03MB
    mvmnvu_itsec_distributed_storage: Data: 0.02MB + Index: 0.02MB
    mvmnvu_itsec_lockouts: Data: 0.00MB + Index: 0.00MB
    mvmnvu_itsec_log: Data: 0.90MB + Index: 0.08MB
    mvmnvu_itsec_logs: Data: 6.02MB + Index: 0.39MB
    mvmnvu_itsec_temp: Data: 0.02MB + Index: 0.03MB
    mvmnvu_links: Data: 0.00MB + Index: 0.00MB
    mvmnvu_mailchimp_carts: Data: 0.00MB + Index: 0.00MB
    mvmnvu_options: Data: 2.40MB + Index: 0.15MB
    mvmnvu_postmeta: Data: 18.65MB + Index: 3.88MB
    mvmnvu_posts: Data: 2.46MB + Index: 0.55MB
    mvmnvu_queue: Data: 0.00MB + Index: 0.00MB
    mvmnvu_social_users: Data: 0.00MB + Index: 0.00MB
    mvmnvu_termmeta: Data: 0.14MB + Index: 0.10MB
    mvmnvu_terms: Data: 0.53MB + Index: 0.53MB
    mvmnvu_term_relationships: Data: 1.91MB + Index: 3.53MB
    mvmnvu_term_taxonomy: Data: 0.29MB + Index: 0.26MB
    mvmnvu_toolset_post_guid_id: Data: 0.00MB + Index: 0.00MB
    mvmnvu_usermeta: Data: 0.06MB + Index: 0.04MB
    mvmnvu_users: Data: 0.00MB + Index: 0.01MB
    mvmnvu_wc_download_log: Data: 0.00MB + Index: 0.00MB
    mvmnvu_wc_webhooks: Data: 0.00MB + Index: 0.00MB
    mvmnvu_wfBadLeechers: Data: 0.00MB + Index: 0.00MB
    mvmnvu_wfBlockedIPLog: Data: 0.00MB + Index: 0.00MB
    mvmnvu_wfBlocks: Data: 0.00MB + Index: 0.00MB
    mvmnvu_wfBlocksAdv: Data: 0.00MB + Index: 0.00MB
    mvmnvu_wfConfig: Data: 0.01MB + Index: 0.01MB
    mvmnvu_wfCrawlers: Data: 0.00MB + Index: 0.00MB
    mvmnvu_wfFileMods: Data: 0.96MB + Index: 0.18MB
    mvmnvu_wfHits: Data: 0.00MB + Index: 0.00MB
    mvmnvu_wfHoover: Data: 0.00MB + Index: 0.00MB
    mvmnvu_wfIssues: Data: 0.00MB + Index: 0.00MB
    mvmnvu_wfKnownFileList: Data: 0.80MB + Index: 0.10MB
    mvmnvu_wfLeechers: Data: 0.00MB + Index: 0.00MB
    mvmnvu_wfLockedOut: Data: 0.00MB + Index: 0.00MB
    mvmnvu_wfLocs: Data: 0.00MB + Index: 0.00MB
    mvmnvu_wfLogins: Data: 0.00MB + Index: 0.00MB
    mvmnvu_wfNet404s: Data: 0.00MB + Index: 0.00MB
    mvmnvu_wfReverseCache: Data: 0.00MB + Index: 0.00MB
    mvmnvu_wfScanners: Data: 0.00MB + Index: 0.00MB
    mvmnvu_wfSNIPCache: Data: 0.00MB + Index: 0.00MB
    mvmnvu_wfStatus: Data: 0.02MB + Index: 0.02MB
    mvmnvu_wfThrottleLog: Data: 0.00MB + Index: 0.00MB
    mvmnvu_wfVulnScanners: Data: 0.00MB + Index: 0.00MB
    mvmnvu_woocommerce_pickup_locations_geodata: Data: 0.00MB + Index: 0.01MB
    mvmnvu_woocommerce_shipping_table_rates: Data: 0.00MB + Index: 0.00MB
    mvmnvu_yith_wcbk_booking_notes: Data: 0.00MB + Index: 0.00MB
    mvmnvu_yith_wcch_emails: Data: 0.00MB + Index: 0.00MB
    mvmnvu_yith_wcch_sessions: Data: 0.04MB + Index: 0.01MB
    mvmnvu_yith_wcdn_desktop_notification: Data: 0.00MB + Index: 0.00MB
    mvmnvu_yith_wcwl: Data: 0.00MB + Index: 0.00MB
    mvmnvu_yith_wcwl_lists: Data: 0.00MB + Index: 0.01MB
    mvmnvu_ylc_chat_rows: Data: 0.00MB + Index: 0.00MB
    mvmnvu_ylc_chat_sessions: Data: 0.00MB + Index: 0.00MB
    mvmnvu_ylc_chat_visitors: Data: 0.00MB + Index: 0.00MB
    mvmnvu_ylc_offline_messages: Data: 0.01MB + Index: 0.00MB
    mvmnvu_ywcars_messagemeta: Data: 0.00MB + Index: 0.00MB
    mvmnvu_ywcars_messages: Data: 0.00MB + Index: 0.00MB
    mvmnvu_ywrr_email_blocklist: Data: 0.00MB + Index: 0.00MB
    mvmnvu_ywrr_email_schedule: Data: 0.01MB + Index: 0.01MB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB
    wp_comments: Data: 0.02MB + Index: 0.08MB
    wp_links: Data: 0.02MB + Index: 0.02MB
    wp_options: Data: 0.45MB + Index: 0.02MB
    wp_postmeta: Data: 0.02MB + Index: 0.03MB
    wp_posts: Data: 0.02MB + Index: 0.06MB
    wp_termmeta: Data: 0.02MB + Index: 0.03MB
    wp_terms: Data: 0.02MB + Index: 0.03MB
    wp_term_relationships: Data: 0.02MB + Index: 0.02MB
    wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB
    wp_usermeta: Data: 0.02MB + Index: 0.03MB
    wp_users: Data: 0.02MB + Index: 0.05MB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB
    wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB
    wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB
    wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB
    wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.05MB
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB
    wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB
    wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB
    wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB
    wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB
    wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB
    wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB
    wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB
    wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB
    wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB
    wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB
    ### Post Type Counts ###
    acf: 1
    attachment: 4913
    blocks: 4
    custom_css: 1
    featured_item: 8
    flamingo_contact: 146
    flamingo_inbound: 3
    mc4wp-form: 2
    nav_menu_item: 134
    page: 32
    post: 1
    product: 1188
    question_answer: 4
    revision: 1
    shop_coupon: 4
    shop_order: 25
    wc_pickup_location: 1
    wp-types-group: 1
    wpcf7_contact_form: 3
    ywdpd_discount: 1
    ### Security ###
    Secure connection (HTTPS): ✔
    Hide errors from visitors: ✔
    ### Active Plugins (30) ###
    Contact Form 7: by Takayuki Miyoshi – 5.0.2
    Easy Theme and Plugin Upgrades: by Chris Jean – 2.0.0
    Flamingo: by Takayuki Miyoshi – 1.8
    Image Watermark: by dFactory – 1.6.4
    Imagify: by WP Media –
    iThemes Security Pro: by iThemes – 5.2.2
    MailChimp for WordPress: by ibericode – 4.2.2
    Members: by Justin Tadlock – 2.1.0
    Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.0.2
    Search By SKU - for Woocommerce: by Matthew Lawson – 0.6.1 – Not tested with the active version of WooCommerce
    Toolset Types: by OnTheGoSystems – 2.3.1
    UberMenu 3 - The Ultimate WordPress Mega Menu: by Chris Mavricos
    SevenSpark –
    WooCommerce Vehicle Parts Finder - Make/Model/Year/Engine/Category/Keyword: by The WP Instinct Team – 2.8 – Not tested with the active version of WooCommerce
    WooCommerce Conditional Shipping and Payments: by SomewhereWarm – 1.3.4
    WooCommerce EU VAT Number: by WooCommerce – 2.3.7
    WooCommerce Local Pickup Plus: by SkyVerge – 2.3.12
    WooCommerce Table Rate Shipping: by WooCommerce – 3.0.9
    WooCommerce: by Automattic – 3.4.2
    WP-Lister Pro for eBay: by WP Lab – 2.0.39 – Not tested with the active version of WooCommerce
    WP Rocket: by WP Media –
    YITH Live Chat Premium: by YITHEMES – 1.2.7
    YITH WooCommerce Advanced Reviews Premium: by YITHEMES – 1.5.3 – Not tested with the active version of WooCommerce
    YITH WooCommerce Bulk Product Editing Premium: by YITHEMES – 1.2.8 – Not tested with the active version of WooCommerce
    YITH WooCommerce Checkout Manager: by YITHEMES – 1.2.0
    YITH WooCommerce Dynamic Pricing and Discounts Premium: by YITHEMES – 1.4.5
    YITH WooCommerce Order Tracking Premium: by YITHEMES – 1.4.4 – Not tested with the active version of WooCommerce
    YITH WooCommerce PDF Invoice and Shipping List Premium: by YITHEMES – 1.7.1 – Not tested with the active version of WooCommerce
    YITH WooCommerce Questions and Answers Premium: by YITHEMES – 1.2.2 – Not tested with the active version of WooCommerce
    YITH WooCommerce SMS Notifications Premium: by YITHEMES – 1.2.0
    YITH WooCommerce Wishlist Premium: by YITHEMES – 2.2.1 – Not tested with the active version of WooCommerce
    ### Settings ###
    API Enabled: ✔
    Force SSL: ✔
    Currency: GBP (£)
    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: #8 - /shop/
    Basket: #9 - /cart/
    Checkout: #10 - /checkout/
    My account: #11 - /my-account/
    Terms and conditions: ❌ Page not set
    ### Theme ###
    Name: Flatsome Child
    Version: 3.0
    Author URL: 
    Child Theme: ✔
    Parent Theme Name: Flatsome
    Parent Theme Version: 3.6.0
    Parent Theme Author URL:
    WooCommerce Support: ✔
    ### Templates ###
    Overrides: flatsome/woocommerce/archive-product.php

    And I haven’t done anything really, just upgraded to latest woocommerce and updated PHP 7.2

    Plugin Support Hannah S.


    Automattic Happiness Engineer

    As requested above, can you please share the system status report? The more information we have, the better we’ll be able to help you.

    i did share it but it says:

    This post has been held for moderation by our automated system and will be manually reviewed by a moderator.

    Thank you.

    Plugin Support Kenin


    Automattic Happiness Engineer

    Hi there Emre,

    Thanks for the status report. I’m not seeing anything specific that points to a cause for your issue. Issues like this may be caused by either a conflict with your theme or with another plugin. You can read more about plugin and theme conflicts in the documentation here:

    The best way to determine if the issue is being caused by a theme and/or plugin is to do the following:

    1. Temporarily switch your theme to the Twenty Seventeen Theme
    2. Disable all plugins except for WooCommerce. You can do this manually or by using a plugin to help.
    3. Test to see if the issue has been resolved.

    To help troubleshoot:

    * Meks Quick Plugin Disabler – is a tool that will remember what plugins you had active when you switch it back on.

    If that resolves the issue, then one-by-one you can switch back your theme and re-enable your plugins, testing in between, until you find the one causing the conflict.

    • This reply was modified 1 year, 6 months ago by Kenin.

    I tested with all plugins disabled and switched to different theme but still no luck 🙁

    What do i do :(((((

    I just added one of the attributes now and all came back by itself 🙂

    I have just seen the exact same issue here.

    Several Hundred Colours and Sizes have disappeared from the Products > Attributes section.

    The Tables however seem fine, heaps of records in there.

    Also I am unable to do any Price updates, presumably due to the system thinking there are no Sizes and Colours.

    Is there a fix for this apart from just trying to add a random attribute ?

    Upgraded to / running 3.4.5

    • This reply was modified 1 year, 1 month ago by Krammig.
Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Products attributes are all gone’ is closed to new replies.