Where is the “default attribute” values located in the phpMyAdmin in Woocommerce?

Default attributes of WooCommerce variable products are stored as post meta in the database.
You can find them in the wp_postmeta table, where the post_id column is the post ID of the parent product (Variable product), and the meta_key column is _default_attributes.

You can clear and remove default attributes of all products by replacing all non-empty arrays.

To do so, open phpMyAdmin and select the database of your WordPress installation from the left panel and click on SQL tab. Then write the below SQL commands and press Go:

Don’t forget to backing up your database before executing any command
on phpMyAdmin

UPDATE `wp_postmeta` SET `meta_value`= 'a:0:{}' WHERE meta_key = '_default_attributes'

Related Posts:

  1. Deleted products from woocommerce are still in the database
  2. Get url of product’s images (woocommerce)
  3. Display single product attribute value on Shop page (Woocommerce)
  4. Share users and WooCommerce memberships between two installations
  5. Is it safe to delete from db orphaned posts i.e. whose post_parent no longer exists?
  6. Get product details by url key in WordPress woocommerce
  7. Extend Woocommerce rest api routes fails
  8. woocommerce_before_calculate_totals in woocommerce 3.0
  9. How to get all attributes with their terms related to specific Woocommerce product category [closed]
  10. Remove “Choose An Option” on Product Variation & Auto Select Instead
  11. why featured product not updated in postmeta table in woocommerce?
  12. Programmatically adding product attributes to WP / Woo commerce
  13. Delete All Product Images in phpmyadmin
  14. How to select from two different tables to display orders list with custom column from other table
  15. Woocommerce custom search
  16. Get product variation attribute titles – WooCommerce
  17. How to change Attribute Type
  18. WooCommerce – buying as well as selling
  19. Is it possible to merge Woocommerce attributes? [closed]
  20. Best Practice – Customise a WooCommerce+WordPress Templates
  21. Is it safe to have 2 mysql users?
  22. WooCommerce: One term for Many Product Attributes
  23. Should I use docker in wordpress production?
  24. How to remove product attribute row woocommerce using code
  25. Help me to intergrate product database to WordPress
  26. Undo WooCommerce CSV import
  27. WooCommerce Simple Product Options List
  28. Clients with empty username are not receiving request new password email
  29. Woocommerce: Any way to list all products *without* a specific attribute?
  30. WordPress Development Workflow
  31. Update WooCommerce stock status with SQL query if stock value is greater than 0
  32. Does WP-WooC support filters at database?
  33. How to add product variations for large number of products in WooCommerce?
  34. WooCommerce database upgrade behaviour
  35. WooCommerce: how to set stock per attribute on variable product
  36. Alter the cost of products using phpmyadmin sql query
  37. Importing Attributes in to Woocommerce
  38. Woocommerce: Some action hooks not firing inside class [closed]
  39. Is it possible Different templates of products for specific category in WooCommerce?
  40. WooCommerce – Adding Product Attributes to CSV Export
  41. PHP Warning: Error while sending QUERY packet
  42. WordPress and WooCommerce How to Assign Attribute Based Pricing
  43. Create templates from attributes for categories
  44. Woocommerce permalink URL change in DB
  45. Woocommerce plugin increasing Database size
  46. Converting longtext to mediumtext in WordPress wp_postmeta table
  47. Product reviews in my sql database
  48. How to move WooCommerce Product Data Box below Title Box in Edit
  49. Give auto discount to upsells products
  50. WooCommerce and Theme templates
  51. Woocommerce woocommerce_breadcrumb_defaults filter [closed]
  52. WooCommerce Hook after Billing form completed, but before payment Gateway
  53. Change woocommerce one category image size
  54. Remove Span Class From Woocommerce Price
  55. WooCommerce shop, my account, cart every page redirect to home page [closed]
  56. Some Admin disappeared
  57. How to edit woocommerce checkout fields
  58. WooCommerce Table Rates not splitting up
  59. Custom access given to Admin dashboard
  60. Sort by promo code used woocommerce admin panel [closed]
  61. Add category description on product page (Woocommerce)
  62. How can I let the user choose size of a shoe in the store? [closed]
  63. WooCommerce – item added to order not actually saved? [closed]
  64. Hide/show specific products for backend users in woocommerce
  65. show payment receipt in woocommerce thankyou page with custom payment gateway?
  66. Restrict the shop_manager role to the WooCommerce Orders Page
  67. WooCommerce, after moving reviews tab to under product description. If pagination link is clicked description is hidden
  68. How to disable click thumbnail product on archives product [closed]
  69. Hide .woocommerce-price-suffix on the product list page
  70. I’d like to add a button under the “Add to Cart” button which says “Buy on Amazon” and links to my Amazon product page [closed]
  71. Woocommerce shows empty columns [closed]
  72. If YITH Wishlist page is set to the WooCommerce my-account endpoint, the endpoints stop working all together. Any solution?
  73. WooCommerce pay per photo upload [closed]
  74. Product atributes in title of order (not in description)
  75. How to create custome pdf file of my invioice in wordpress
  76. Need help saving input fields for Security Deposit plugin in WC Vendors page
  77. Is it possible to hide certain products from displaying in the search results
  78. How to edit schema.org markup of WooCommerce?
  79. Display product variations on same row [closed]
  80. Override woocommerce template from parent theme
  81. How to get sub items of parent menu item?
  82. WordPress Woocommerce product-category info on one line [closed]
  83. Manual Woocommerce Complete order Emails
  84. Search box missing Woocommerce Product Bundle Extension
  85. Is it possible to customize username field from the registration page in woocommerce? [closed]
  86. Woocommerce cart displays outdated prices [closed]
  87. Woocommerce display price without formatting [closed]
  88. Own WooCommerce theme showing text boxes instead of slider for price filter widget
  89. woocommerce shop page Redirect Help
  90. Woocommerce custom taxonomy order
  91. Turkish Character Problem on mailing
  92. WooCommerce: Order Details Table > Add Product Meta
  93. Create custom add to cart in WordPress
  94. woocommerce: get product detail form sku [closed]
  95. Adding Extra Customer Email In Woocommerce Checkout
  96. How to override email text New Customer Order?
  97. Woo-Commerce new order email no style attached
  98. Woocommerce 404 after chang default language
  99. My WordPress site hacked with unwanted popups [closed]
  100. Override function

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)