You should never change the database structure,, if you just wanna display the short description in place of description there are hooks and filters you can use alternatively you can override the plugin file that displays the single products by creating a woocommerce directory and add tha file in the same hierarchy as in the plugin templates folder.
have a look at https://docs.woocommerce.com/document/template-structure/
you’ll also going to find the hooks and filters to do the job if you dont want to add the woocommerce directory.
you need to update the yourprefix_posts table, the products are also wordpress post you can write
update yourprefix_posts set post_excerpt=post_content , post_content="" where post_type="product"
Related Posts:
- Get url of product’s images (woocommerce)
- How can i create a WooCommerce product programatically or using sql query?
- Programmatically adding product attributes to WP / Woo commerce
- Woocommerce PHP site that shows table with orders from specific category
- How to select from two different tables to display orders list with custom column from other table
- How to delete all customer user account that haven’t placed a single order?
- 600k of option_name “c_facebook_background_product_sync_job”
- DELETE WooCommerce Order data from database
- Same request Mysql/Php not same result
- Get decimal from product price with Mysql
- WooCommerce – 500k Jump in Order Number?
- Deleted products from woocommerce are still in the database
- How to merge 2 accounts with same email address after merge of 2 woocommerce databases
- Update WooCommerce stock status with SQL query if stock value is greater than 0
- Update a list of product to featured if product have meta value (Mysql not wpquery)
- MySQL error or data corruption after database migration
- Query product’s image path by category WooCommerce database?
- Update a user meta key based on WooCommerce product purchase
- Mysql query – amount spent by customer
- How Fragile Is DB if I Upload Completely Updated Files
- In woocommerce some products have empty options, but how to check this
- PHP Warning: Error while sending QUERY packet
- Export Woocomerce Image Product URL
- To many WooCommmerce related transients in WordPress options table
- How can I define a custom template for woocommerce [products] shortcode? [closed]
- Where is the “default attribute” values located in the phpMyAdmin in Woocommerce?
- Display Categories Assigned to a WooCommerce Product
- Get current WooCommerce endpoint not working
- Changing Woocommerce price display [closed]
- Which WooCommerce hook do I need to use to place the coupon field after the checkout sidebar
- WooCommerce Cart – Group Products By Category
- WooCommerce – update order item price and recalculate totals
- Set a default quantity input value for a variable product category in WooCommerce
- WooCommerce product sorting VERY slow
- WooCommerce change price in cart [closed]
- Categories not shown in admin after adding woocommerce products via wp wc cli
- Enabling autosave when plugin disabled
- WooCommerce email text based on category && shipping zone && payment method [closed]
- woocommerce – get_image_size() deprecated [closed]
- Problem with cURL and rest API
- Avada & WooCommerce Customization – Replacing product_title in woo-config.php [closed]
- WooCommerce template page for category
- How to get the webshop page in 2:nd language, with Polylang and Hyyan
- Subcategories not working when using shared base with custom taxonomy
- Auto generate user email while registration
- WooCommerce Cart Total Table chronology order change [closed]
- Woocommerce Update Order Notes Date
- Shipping Method does not inherit settings from the class
- My woocommerce checkout page and woocommerce setting page are not responding [closed]
- Woocommerce Shortcode custom orderby not working
- Show only one variaton in catalog on meta key
- Switch position of short description and variations [closed]
- What’s the fastest way to import products with variations in WooCommerce (CSV, XML, …) [closed]
- Woocommerce’s add_to_cart function returns false and doesn’t add anything to the cart [closed]
- WOOCOOMERCE: Run function before payment gateway (paying)
- Can’t filter out variable products in sale from wp_get_products loop (or shortcode) [closed]
- Send email notifications to a defined email address depending if a product in order has a specific TAG [closed]
- main menu hide woo commerce single products tittle
- What Hook/Action is performed when a field in checkout form is changed in WooCommerce
- Benefits over using object method over property from $product?
- Add to cart – button should be disabled
- WooCommerce – change child category URL structure
- Hide Add to Cart button on woocommerce Product description page of a particular product
- manage_shop_order_posts_custom_column() hook is Not working In Functions.php file in my WordPress active theme
- How to send woocommerce emails in multiple languages
- Custom WooCommerce rewrite rules with comma delimiter
- Set city as required if country is Singapore
- Woocommerce custom taxonomy filtering
- WooCommerce Simple Auctions add username to auction finished email
- Enable Gutenberg for Woocommerce
- How to change product category permalinks programmatically?
- Make e-Mail optional on Woocommerce sign up
- Missing variable options on add to cart form
- Create order actions from custom fields woocommerce
- WooCommerce , Auto cancel orders status from processing after X days
- Change WooCommerce Word “Product” to Another Word
- How does a WooCommerce site integrate with the existing real world customer members?
- How can I send information when a order is completed to my own POS?
- How to filter result set in custom metaboxes?
- How to change lost password email text using custom plugin wordpress?
- wc_mail in foreach loop is sending only the first email
- How to fix: “The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.” after malware cleaning
- How to hide / remove duplicated Woocommerce products from Shop page
- How to add product variations for large number of products in WooCommerce?
- Woocommerce Languages Files
- How to adjust Related Page Thumb Sizes on single page?
- Changing second user role while updating/downgrading membership level – s2member [closed]
- How to edit the header banner in the search page in woocommerce?
- How can I display one product using WooCommerce
- How do I change the woocommerce product gallery to show all thumbnails instead of three at a time in a carousel?
- How to add a menu page for options in wordpress for user that has the role of vendor?
- How to edit schema.org markup of WooCommerce?
- Turkish Character Problem on mailing
- WooCommerce: Order Details Table > Add Product Meta
- Override function
- How to change redirect code? [duplicate]
- How to disable schema from Wocommerce? [closed]
- Problems using WooCommerce & Qstomizer
- Remove Ok Button when popup message
- how to get the current page endpoint