Title: API – date_completed is Null/Missing
Last modified: January 4, 2024

---

# API – date_completed is Null/Missing

 *  Resolved [mbladecki](https://wordpress.org/support/users/mbladecki/)
 * (@mbladecki)
 * [2 years, 5 months ago](https://wordpress.org/support/topic/api-date_completed-is-null-missing/)
 * Anyone ever see where date_completed is Null in the API? The date_completed record
   is also missing the Postmeta table for those orders. One site I have 11 out of
   24,000 orders that are completed with no date_completed and another I have 5 
   out of over 100k orders. One site is Hosted on Pressable. The other is Self hosted.
 * WP: 6.4.2
   WC: 8.4DB: 8.4

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Support [Shameem – a11n](https://wordpress.org/support/users/shameemreza/)
 * (@shameemreza)
 * [2 years, 5 months ago](https://wordpress.org/support/topic/api-date_completed-is-null-missing/#post-17318237)
 * Hi [@mbladecki](https://wordpress.org/support/users/mbladecki/),
 * The `date_completed` field in the API may be null if the order has been created
   but not yet completed. It’s not common, but occasionally this can happen if there’s
   an interruption in the order process, such as a lost internet connection or a
   server issue.
 * As for the missing `date_completed` in the postmeta table, it’s possible that
   the metadata for those orders was not properly saved due to similar interruptions
   or conflicts with other plugins.
 * Given the small number of affected orders relative to your total, these seem 
   like isolated incidents. However, if you’re noticing a pattern or if it’s causing
   significant issues, it might be worth investigating further.
 * Please ensure all your plugins and themes are up to date, and try disabling plugins
   except WooCommerce one by one to see if there’s a conflict causing this issue.
 * If the problem persists, please reach back out to us. Looking forward to hearing
   from you soon.
 *  Thread Starter [mbladecki](https://wordpress.org/support/users/mbladecki/)
 * (@mbladecki)
 * [2 years, 5 months ago](https://wordpress.org/support/topic/api-date_completed-is-null-missing/#post-17318321)
 * The Order status of all the orders missing date_completed are flagged as completed
   and the meta key is missing. All plugins are up to date. The issues is across
   different versions, different plugins and different hosts. It becomes an issue
   when you are downloading financial data into an accounting system and the data
   does not match the reports. The question from the accountant becomes “If that
   data is incorrect, What else is incorrect? Which one is correct? The reports 
   or API?”
 * I agree it is a small issue with only a few orders affected. It is difficult 
   to track down what happened, but it leads to many hours wasted trying to figure
   it out.
 *  [anastas10s](https://wordpress.org/support/users/anastas10s/)
 * (@anastas10s)
 * [2 years, 5 months ago](https://wordpress.org/support/topic/api-date_completed-is-null-missing/#post-17318417)
 * Hi there [@mbladecki](https://wordpress.org/support/users/mbladecki/) 👋
 * > One site I have 11 out of 24,000 orders that are completed with no date_completed
   > and another I have 5 out of over 100k orders
   > […]I agree it is a small issue
   > with only a few orders affected. It is difficult to track down what happened
 * Order statuses can be altered by payment gateways, and plugins with functionality
   to alter or appoint custom order statuses — apart from manually edited.
 * Therefore, I am curious if these possibilities have already been explored, or
   otherwise. As in, the few orders have a payment gateway plugin in common? Or,
   is there a plugin status update workflow in place, other than the default that
   comes with WooCommerce, perhaps?
 * I hope that helps!

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘API – date_completed is Null/Missing’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

## Tags

 * [api](https://wordpress.org/support/topic-tag/api/)

 * 3 replies
 * 3 participants
 * Last reply from: [anastas10s](https://wordpress.org/support/users/anastas10s/)
 * Last activity: [2 years, 5 months ago](https://wordpress.org/support/topic/api-date_completed-is-null-missing/#post-17318417)
 * Status: resolved