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. What actions affect files, DB, or both?
  46. WooCommerce Description and Short Description tags removal
  47. Shipping Location based on IP (Geolocation)
  48. woocommerce “publish “”product”” webhook
  49. Image is not displayed in overridden woocommerce email
  50. woo commerce get all orders item given category
  51. Add Stripe Connect data to wc_stripe_payment_request
  52. WooCommerce get default shipping rate & conditions
  53. Using WooCommerce for payments only?
  54. WooCommerce Cart Link based on Cookie Values
  55. Woocommerce is_shop not on page slug? [closed]
  56. Debugging why featured images have stopped showing in WooCommerce on the homepage [closed]
  57. WooCommerce minimum order amount for specific country excluding local pickup [closed]
  58. woocommerce list product by id
  59. Show Content On below single product with specific category
  60. How to change a WooCommerce Subscription Deposit and Monthly Payment? [closed]
  61. how to scrolling image on single product page
  62. How to display WooCommerce product tag names on home and category pages
  63. Specifically Link To the “Leave a review” part of product page? [closed]
  64. Woocommerce pre_get_posts query variation meta data not working
  65. Can’t hide product attributes with css on WooCommerce Product Page
  66. Updating product image
  67. Split in 2 columns add to cart button and variable forms
  68. Woocommerce to get restaurant table numbers in the checkout fields from the url
  69. UX Builder not loading for product description edits
  70. I need help with storefront theme shop page
  71. Woocommerce shop page not showing all products
  72. Sending billing details via POST request to an API
  73. Tax exclusive if coupon applied else tax inclusive in items
  74. WooCommerce Registration, Sync User, Billing and Shipping info
  75. How to check which shortcode is using my template?
  76. woocommerce: when adding or removing items to cart , it takes cart a few seconds to read changes?
  77. How to get woocommerce integration instance?
  78. Product atributes in title of order (not in description)
  79. How to create custome pdf file of my invioice in wordpress
  80. How to get sub items of parent menu item?
  81. Storefront Child Theme show product attribute [closed]
  82. How to Manage Multiple WordPress Websites from one dashboard (WooCommerce)
  83. Setting stock levels to “0” for all products in store using WP CLI
  84. Change the User/ Author of the Products
  85. Custom e-commerce display for specific users [closed]
  86. How to get the attributes based on dependency in woocommerce?
  87. Woocommerce composite and bundle products
  88. Can I log the searches that are returning 404 in the DB?
  89. WooCommerce Review ID Block
  90. custom status in Woocommerce with database results
  91. Question about WooCommerce Subscription
  92. WooCommerce: Redirect to an item’s product page after item is removed from cart
  93. Blurry product card image – rendered is 486×452 vs 300×279 in real image. Smaller versions being autocreated and served using srcset
  94. how to show itemized shipping cost|? [closed]
  95. GET woocommerce order request is not showing meta data [closed]
  96. Add a custom meta column to a built-in import CSV file
  97. Hide/show button for the password field in the Woocommerce My Account page
  98. I need help with CPT for a food delivery business
  99. Woocommerce admin order email customize – remove product short description
  100. Which php files, in a WordPress setup, do not need direct web access?

Leave a Comment

techhipbettruvabetnorabahisbahis forumutaraftarium24eduseduedusedueduedueduseduseduedus