Place order tracking information onto order completed emails

Looks for order tracking information in order notes and places into order completed emails.

add_action( 'woocommerce_email_order_details',
	function( $order, $sent_to_admin, $plain_text, $email ) {

	// Only For Order Completed Emails
	if( empty( $email->id ) || $email->id != 'customer_completed_order' ) {

	// Get ShipStation Status
	global $wpdb;
	$order_id = $order->get_id();
	$sql = "
		select comment_content
		from {$wpdb->comments}
		where comment_post_ID = %d
		and comment_content like '%% shipped %%'
		order by comment_date desc
		limit 1
	$info = $wpdb->get_var( $wpdb->prepare( $sql, $order_id ) );

	// Output Status
	if( $info ) {
		echo wpautop( $info );

}, 10, 4 );
  1. Log into a staging, development, or locally hosted clone of your site.
  2. Install and activate the Code Snippets plugin.
  3. Navigate to WP Admin > Snippets > Add New.
  4. Copy and paste the code from the Description tab above.
  5. Check to ensure formatting came over properly and no syntax errors show up in the editor.
  6. Customize the code as desired.
  7. Add a meaningful title and description.
  8. Select whether to run on front-end or back-end (or both). Some snippets require both.
  9. Click the "Save and Activate" button.
  10. Test your site to ensure it works as expected.
  11. Disable if any problems, or recover as necessary.
  12. Repeat steps two onward on your live environment.
  1. Describe the issue and what you've observed.
  2. Describe your expected outcome(s).
  3. List steps to reproduce the issue.
  4. Optionally provide screen-shot or video URLs.

We code all of our code snippets directly. Our clients provide most of the ideas and demand for the functionality provided by our code snippets.

There are several sources one can find on Google for code that has inspired or contributed to this open-source library. Here's some main ones:

All code snippets are licensed GPLv2 (or later) matching WordPress licensing.

Disclaimer of warranty:

Except when otherwise stated in writing the copyright holders and/or other parties provide the program as-is without warranty of any kind, either expressed or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose.