Support » Plugin: WooCommerce » Products attributes are all gone

  • Resolved emreozpalamutcu

    (@emreozpalamutcu)


    Hi,
    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.
    Regards,
    Emre

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

    (@kbassart)

    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?

    Hi,
    Here is the system report:

    
    ### WordPress Environment ###
    
    Home URL: https://designerbeema.com
    Site URL: https://designerbeema.com
    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
    NSS/3.27.1
    
    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 – 1.7.1.3
    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 – 3.4.0.1
    
    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 – 3.0.5.1
    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: http://www.uxthemes.com/
    WooCommerce Support: ✔
    
    ### Templates ###
    
    Overrides: flatsome/woocommerce/archive-product.php
    flatsome/woocommerce/cart/cart-empty.php
    flatsome/woocommerce/cart/cart.php
    flatsome/woocommerce/checkout/form-checkout.php
    flatsome/woocommerce/checkout/form-coupon.php
    flatsome/woocommerce/checkout/thankyou.php
    flatsome/woocommerce/content-product.php
    flatsome/woocommerce/content-product_cat.php
    flatsome/woocommerce/content-single-product.php
    flatsome/woocommerce/global/breadcrumb.php
    flatsome/woocommerce/global/quantity-input.php
    flatsome/woocommerce/global/wrapper-end.php
    flatsome/woocommerce/global/wrapper-start.php
    flatsome/woocommerce/loop/loop-end.php
    flatsome/woocommerce/loop/loop-start.php
    flatsome/woocommerce/loop/pagination.php
    flatsome/woocommerce/loop/result-count.php
    flatsome/woocommerce/loop/sale-flash.php
    flatsome/woocommerce/myaccount/form-login.php
    flatsome/woocommerce/myaccount/navigation.php
    flatsome/woocommerce/notices/error.php
    flatsome/woocommerce/notices/notice.php
    flatsome/woocommerce/notices/success.php
    flatsome/woocommerce/product-searchform.php
    flatsome/woocommerce/single-product/photoswipe.php
    flatsome/woocommerce/single-product/price.php
    flatsome/woocommerce/single-product/product-image.php
    flatsome/woocommerce/single-product/product-thumbnails.php
    /var/www/html/wp-content/plugins/yith-woocommerce-advanced-reviews-premium/templates/ywar-rating.php
    flatsome/woocommerce/single-product/related.php
    flatsome/woocommerce/single-product/review.php
    flatsome/woocommerce/single-product/sale-flash.php
    flatsome/woocommerce/single-product/share.php
    flatsome/woocommerce/single-product/short-description.php
    flatsome/woocommerce/single-product/tabs/tabs.php
    flatsome/woocommerce/single-product/title.php
    flatsome/woocommerce/single-product/up-sells.php
    flatsome/woocommerce/single-product-reviews.php
    flatsome/woocommerce/single-product.php
    

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

    Plugin Support Hannah S.

    (@fernashes)

    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.
    Regards,
    Emre.

    Plugin Support Kenin

    (@kbassart)

    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: https://docs.woocommerce.com/document/woocommerce-self-service-guide/

    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 – https://wordpress.org/plugins/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.

    Hi,
    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.