Menu Close

WooCommerce: Display Product Grid @ Order Emails e.g. Related Products

default

Bad news first – we’ve seen how to add content to any WooCommerce order email, however I did not specify that if you use the [products] shortcode that’s not going to work unfortunately. The reason behind this, in plain English, is that… it just doesn’t work, and it outputs a weird list of “Sale!” list items (see screenshot below)!

So, I want to fix this, and find a WooCommerce email-compatible way to show a grid of products based on a list of product IDs (for example, the list of related products based on the ordered items), and make sure I can actually see product images, titles, prices and a link. Enjoy!

My attempt at using the [products] shortcode inside the Customer Processing Order email didn’t go really well. It outputs a weird list of items, and there is no sign of a product grid.
And here’s the “after”: finally, I’m able to show a grid of products inside WooCommerce Order emails. In this particular case, I’m using the list of related products, but you can use any custom list of course!

PHP Snippet: Display Related Products Grid @ WooCommerce Customer Processing Order Email

Note 1: you can target any WooCommerce email. Here, I’m adding content to the Customer Processing Order email, but you could do it on the Completed one only, or all of them. Check this guide to find out the email ID you should use in the snippet below.

Note 2: in the snippet I’m calculating the Related Products from the order items. You can use a custom list of product IDs instead if you wish – simply remove the $related calculations, and edit the foreach iterable_expression from “array_slice( $related, 0, $limit )” to “array( 123, 456, 789 )” where 123, 456 and 789 are the product IDs you want to show.

Note 3: I’m displaying 3 columns and 2 rows of products. Change $cols = 3 and $limit = 6 based on your requirements ($cols = 4 and $limit = 4 would give you 4 items in 1 row).

/**
 * @snippet       Product Grid @ WooCommerce Emails
 * @how-to        Get CustomizeWoo.com FREE
 * @author        Rodolfo Melogli
 * @compatible    WooCommerce 7
 * @donate $9     https://businessbloomer.com/bloomer-armada/
 */

add_action( 'woocommerce_email_after_order_table', 'bbloomer_add_product_grid_specific_email', 20, 4 );
  
function bbloomer_add_product_grid_specific_email( $order, $sent_to_admin, $plain_text, $email ) {
	
	if ( $email->id == 'customer_processing_order' ) {
		
		$related = array();
		foreach ( $order->get_items() as $item_id => $item ) {			
			$related = array_merge( wc_get_related_products( $item->get_product_id() ), $related );
		}
		if ( ! $related ) return;
		shuffle( $related );
		$related = array_unique( $related );
		
		echo '<h2>Related Products</h2>';
		
		$html = '';
		$col = 1;
		$cols = 3;
		$limit = 6;
		$html .= '<div><table style="table-layout:fixed;width:100%;"><tbody>';		
		foreach ( array_slice( $related, 0, $limit ) as $product_id ) {
			$product = wc_get_product( $product_id );
			$html .= ( $col + $cols - 1 ) % $cols === 0 ? '<tr>' : '';
			$html .= '<td style="text-align:center;vertical-align:bottom">';
			$html .= $product->get_image();
			$html .= '<h3 style="text-align:center">' . $product->get_title() . '</h3>';
			$html .= '<p>' . $product->get_price_html() . '</p>';
			$html .= '<p><a href="' . get_permalink( $product_id ) . '">' . __( 'Read more', 'woocommerce' ) . '</a></p></td>';
			$html .= $col % $cols === 0 ? '</tr>' : '';
			$col++;
		}
		$html .= '</tbody></table></div>';
		
		echo $html;
		
	}
}
View Source
Posted in WooCommerce Tips