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. What actions affect files, DB, or both?
  48. Set a specific default stock quantity on all WooCommerce new products
  49. Shipping Location based on IP (Geolocation)
  50. How to search Woo Commerce products with punctuation in title?
  51. Can’t create term for product attribute
  52. Emojis getting converted to “?”
  53. woocommerce “publish “”product”” webhook
  54. Search and replace special characters (å,ä,ö) for image attachments only in database
  55. Accidentally deleted active_plugins portion of the wp_options DB table
  56. Users table association with users_metadata table appears broken
  57. WooCommerce Display Digital Download Files Type and Size
  58. woo commerce get all orders item given category
  59. Add Stripe Connect data to wc_stripe_payment_request
  60. WooCommerce – Stock in Decimals, Using Quantity Intervals with Unique Prices [closed]
  61. Additional fields on Woocommerce’s rating system
  62. Woocommerce product image [closed]
  63. Question on WooCommerce Syntax
  64. woocommerce_new_product action doesn’t fire
  65. Change The Woocommerce Product Categories Dropdown Widget Placeholder Text
  66. minimum order item for certain products exempting 2 other products (in bulk)
  67. Is it possible to checkout with 2 different shipping options on a single order? [closed]
  68. Woocommerce Advanced Shipping (WAS) condition is not being called when selecting “Ship to different address” [closed]
  69. Add table to WordPress database
  70. Strip string from $_product->get_title() to get a cleaner mini-cart
  71. Product page attributes dropdown show price
  72. Smart Design for Blog + Woocommerce + LearnDash + Forum/Bodyboss
  73. Ajax add to cart not updating Elementor mini cart totals
  74. WooCommerce – 500k Jump in Order Number?
  75. Need help with woocommerce roles
  76. Change WooCommerce product and variation prices programatically without affecting performance
  77. Help to locate a woocommerce hook method
  78. Is there any defects for using same database prefix in WordPress for multiple sites?
  79. Can I use taxonomies to make a multistore with woocommerce?
  80. Why does wc_get_products($arg) return no products when $arg = ‘average_rating’ => 5.0
  81. Query product’s image path by category WooCommerce database?
  82. How update price for variable product
  83. Related products based on keywords
  84. Add button linked to single product page on order detail page
  85. Send default WooCommerce email when switching from custom order status
  86. syntax error – woocommerce
  87. How to on/off woocommerce filter with redux framework [closed]
  88. How to set up a single product shop with woocommerce? Skipping the product archive
  89. I’m trying to display product categories on each product in the list
  90. Cross-sells on WooCommerce product page
  91. Admin Order adding an extra product on add_line_item
  92. Woocommerce update cart
  93. Get WP All Export row ID
  94. WooCommerce – missing products when viewed by tag
  95. Pull Data from DB for Admin Page Display as Relates to Admin Page Class by BA Internet
  96. Hiding all products except for one in wordpress admin panel
  97. cannot create product attribute (taxonomy) and add terms on the same execution
  98. Copy and Modified WooCommerce function is_coupon_valid [closed]
  99. How do I get my image for my product to not be blurry
  100. Product Variation Auto Select when only one 1 and mark the option [closed]

Leave a Comment