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. WooCommerce: Can’t use wc_get_products for custom REST API endpoints
  43. How to disable Woocommerce password recovery and use the default WordPress password reset page?
  44. Display WooCommerce size product attribute on shop page
  45. WooCommerce add_to_cart() with custom price [closed]
  46. Declaring custom woocommerce product type as virtual / downloadable only [closed]
  47. How to remove_action inside class [duplicate]
  48. Redirect if current user is logged out and current page is /my-account
  49. Display a list subcategories under the main product category thumbnails?
  50. WooCommerce Apply Coupon to order AFTER taxes
  51. Rewriting Woocommerce Product Filters To URL Segments
  52. How to Change WooCommerce Variable product pricing by SKU or visible children id
  53. Is it possible to cache ?wc-ajax=get_variation
  54. echo product id and product_item_key in cart [closed]
  55. Redirect the single product page link to the shop page
  56. Is WooCommerce updates for WordPress necessary? [closed]
  57. How can I display *only* the child category of a product?
  58. How to display empty stars on products with woocommerce?
  59. WooCommerce limited role
  60. Skip WooCommerce 4.5.x onboarding with WP-CLI [closed]
  61. Automatically making a newly saved payment method default in WooCommerce
  62. WooCommerce update_shipping_method ajax call wipes shipping method set on non-checkout page [closed]
  63. Product variation attributes does not appear as it should in the cart – woocommerce [closed]
  64. Shipping methods in dropdown instead of radio buttons [closed]
  65. Adding Buy Button to Blog Post (Woocommerce) [closed]
  66. How to replace WooCommerce Product Gallery Trigger icon using PHP/CSS? [closed]
  67. woocommerce_order_status_completed not working
  68. Synchronise Renewals on existing subscriptions [closed]
  69. How to show the urls inside the simple product when the customer buys it?
  70. Custom template – query issues
  71. Sort downloads by most recently purchased first in my account WooCommerce [closed]
  72. Hide shipping method in woocommerce if custom checkbox field is selected
  73. how to change add to cart button to call for price button in one of product variation?
  74. apply_filter and add_filter conflict
  75. Migrating WordPress + WooCommerce from server to Local
  76. wp-cron and woocommerce subscriptions killing performance
  77. How can I change the background color of divs dynamically (depending on an order-status in woocommerce)?
  78. How to make wocommerce shop products same heigt
  79. Woocommerce Variation product added twice to cart
  80. Woocommerce product query not working in other WPML languages
  81. Woocommerce Ajax add to cart redirect to homepage
  82. How to merge 2 accounts with same email address after merge of 2 woocommerce databases
  83. Get $order in wp_head
  84. How to save a Woocomerce metabox input as a metadata field
  85. Adding order details in woocommerce all booking dashboard
  86. woocommerce sort by dropdown styling
  87. Mysql query – amount spent by customer
  88. Integration widget Mondial Relay Js
  89. some products free and some product is not free for shipping
  90. Importing Attributes in to Woocommerce
  91. Save Woocomerce discount as percentage to database
  92. Woocommerce Shipping based on condition and cart value
  93. How to bypass Woocommerce checkout validation from the plugin? [closed]
  94. Category with description and thumbnail
  95. Woocommerce – Remove ‘Buy Product’ Button + Make Product Thumbnails Clickable
  96. Issue with Woocommerce and extra field in orders data
  97. Give auto discount to upsells products
  98. WooCommerce Table Rates not splitting up
  99. Woocommerce checkout column total too small can not get it wider [closed]
  100. Conflict between Woocommerce Booking + Woocommerce Product Options [closed]
techhipbettruvabetnorabahisbahis forumutaraftarium24edueduedusedusedusedusedusedueduedus