Woocommerce order_complete email dont send after changing order status via sql

If you make the changes directly through SQL you won’t trigger the order change event and that’s why the email is not being sent.

Instead of changing order via SQL you need to use some predefined function like update_status :

$ord = new WC_Order($ID); //ID of the order
$ord->update_status('completed')

Related Posts:

  1. Get WooCommerce product attribute taxonomies in a SQL query on WordPress database
  2. How to get all products from an order including variations via SQL query?
  3. Woocommerce change tax rate programmaticly
  4. How do I get the latest note on the order at woocommerce? [closed]
  5. Create WooCommerce new order with specific ID
  6. How to Order by random on a SQL query
  7. Woocommerce: Prevent sending of email when order is “Completed”
  8. how to do a processing Orders into Complete after x Minutes or x hour in WooCommerce [closed]
  9. WooCommerce quick checkout form? [closed]
  10. WooCommerce order complete email logic
  11. WooCommerce orderby template disappears and not longer works on search page
  12. How to get woocommerce selected variation from order object
  13. Send email notifications to a defined email address depending if a product in order has a specific TAG [closed]
  14. get woocommerce product image url and price from database [closed]
  15. Cancelled orders move to Trash automatically in Woocommerce – how to disable?
  16. how can i add an additional action into woocommerce admin order page through my plugin?
  17. Create a regular post for every WooCommerce order
  18. How to alter taxes amounts when updating an order
  19. WordPress woocommerce new order email not working
  20. Custom Email via Hook only for completed order
  21. Access custom meta_data in processing order email
  22. Sort products by Sale price and stock status
  23. Create order actions from custom fields woocommerce
  24. How to sort products by price ASC and place all no price products to the end? (Woocommerce)
  25. Update WooCommerce stock status with SQL query if stock value is greater than 0
  26. How to get products without tag?
  27. how can my customers view their purchased products history like an invoice in a specific page on WordPress
  28. Change the customer’s name to a link on an order management page
  29. Woocommerce change the price of products in the database
  30. How to save one API response to WooCommerce order meta data
  31. Query product’s image path by category WooCommerce database?
  32. How to speed up “My Account > Orders Page” on Site with More than 200,000 orders?
  33. Alter the cost of products using phpmyadmin sql query
  34. Add button linked to single product page on order detail page
  35. Multiple sorting criteries (order by)
  36. Conditional email recipient based off Shipping Method [closed]
  37. Product atributes in title of order (not in description)
  38. WooCommerce: Order Details Table > Add Product Meta
  39. Use a woocommerce hook to create a table and populate it with a query
  40. Woocommerce admin order email customize – remove product short description
  41. Critical error on woocommerce checkout page
  42. Is it possible to extract all product columns except for one?
  43. Get the product list of a given Category ID
  44. Correct function to get the user’s latest Woocommerce Subscription?
  45. Move payment options at checkout in WooCommerce [closed]
  46. WooCommerce – Hook after Loading Variation in Admin Edit page?
  47. WooCommerce conditional meta query
  48. Updating WooCommerce variable product stock issue
  49. Redirect woocommerce single-product page
  50. Username field is not shown in Woocommerce’s registration contact form
  51. Woocommerce Membership Expiry Date
  52. Woocommerce SKU on ALL products page [closed]
  53. Redirect user to cart page when add to cart button is clicked
  54. Woo API REST : product variation price is read-only?
  55. Problems with varibel price [closed]
  56. Custom Admin Email Subject for Woocommerce (3.8.0) Orders
  57. Woocommerce custom endpoints
  58. Add Custom Slug Tags Per Page
  59. How to override Woocommerce functionality in Reports section?
  60. how can use woocommerce add to cart popup?
  61. Do I need a different product type for WooCommerce [closed]
  62. How to increase execution time out limit in WordPress dashboard?
  63. Setting an attribute as variation in woo commerce via php [duplicate]
  64. WooCommerce – Conditionally enable shipping for virtual products
  65. Add to Cart button displaying twice on Shop Page Woocommerce
  66. How to exclude a taxonomy from shop & search page wooCommerce?
  67. How to remove unwanted text bug in wordpress site
  68. Trying to style Woocommerce sidebar Cart Widget [closed]
  69. WooCommerce how to checkout a product without adding it to the cart
  70. How can i access woocommerce order variables inside shortcode?
  71. Conditional logic – if product has a parent category, echo this
  72. How to add a “buy now” button below “add to cart” button [closed]
  73. Cart page displays the price and amount as zero regardless of price entered [closed]
  74. Get usermeta info from sql query
  75. Custom action not working in Woocommerce
  76. Woocommerce variable product’s total amount by javascript
  77. Prices showed without decimals separator on BACKEND. Weight/price not working on Wocommerce
  78. Save product short description in order (without updating in order details if it is updated in product)
  79. Combine one action and one filter
  80. woocommerce add button underneath order details
  81. Where do I remove admin order fields (unset doesn’t work)
  82. How to Get WooCommerce Product Price
  83. How to trace errors in debug.log for WooCommerce 3.0?
  84. Auto set Woocommerce product ID as SKU on save
  85. I want to show always 4 category boxes everytime in woocommerce
  86. Applying pre-production modifications
  87. WooCommerce – Remove automaticly added membership product if user remove regular product from cart
  88. Possible to have multiple Authorize.net accounts on the same site?
  89. Allow HTML in product attributes for WooCommerce
  90. Use woocomerce shop filters on other pages
  91. Woocommerce – change image issue
  92. Woocommerce: relevancy based related products
  93. How to allow registration only from a certain location?
  94. Add confirmation popup on place order button
  95. Change WooCommerce Checkout Button – Reverts to normal
  96. Can’t display product categories on woocommerce getting Invalid taxonomy?
  97. Send form data to functions.php
  98. Conflict between Woocommerce Booking + Woocommerce Product Options [closed]
  99. Searching in categories AND custom fields
  100. How to detect changes in WooCommerce store (react)?