Add a Column to Show Order Item Price Excl. Tax in Woocommerce Email Notifications

Step 1: Create a Custom Function to Add the Column

To add the column, we’ll create a custom function using PHP. Don’t worry if you’re not familiar with coding; we’ll walk you through it step-by-step.

// Add a new column to the order items table
function add_order_item_price_excl_tax_column($columns) {
    $columns['price_excl_tax'] = __('Price excl. Tax', 'woocommerce');
    return $columns;
}
add_filter('woocommerce_email_order_items_table_columns', 'add_order_item_price_excl_tax_column');

// Add the data for the new column
function add_order_item_price_excl_tax_data($item, $order) {
    $price_excl_tax = wc_get_order_item_meta($item['item_id'], '_line_subtotal', true);
    $tax_amount = wc_get_order_item_meta($item['item_id'], '_line_tax', true);
    $price_excl_tax = $price_excl_tax - $tax_amount;
    echo '' . wc_price($price_excl_tax) . '';
}
add_action('woocommerce_email_order_items_table_item_meta', 'add_order_item_price_excl_tax_data', 10, 2);

Copy and paste the above code into your theme’s functions.php file. This code creates a new column called “Price excl. Tax” and adds the data for each order item.

Step 2: Modify the Email Template

Now that we’ve created the custom function, we need to modify the email template to display the new column.

Locate the email-order-items.php file in your theme’s woocommerce directory. If the file doesn’t exist, you can create a new one or copy it from the Woocommerce plugin directory.

<table>
    <thead>
        <tr>
            <th><?php _e('Product', 'woocommerce'); ?>></th>
            <th><?php _e('Quantity', 'woocommerce'); ?>></th>
            <th><?php _e('Price', 'woocommerce'); ?>></th>
            <th><?php _e('Price excl. Tax', 'woocommerce'); ?>></th> 
            <th><?php _e('Subtotal', 'woocommerce'); ?>></th>
        </tr>
    </thead>
    <tbody>
        <?php
        foreach ($order_items as $item) :
            &$lt;tr>
                <td><?php echo $item['name']; ?>></td>
                <td><?php echo $item['qty']; ?>></td>
                <td><?php echo $order->format_line_subtotal($item); ?>></td>
                <td><?php add_order_item_price_excl_tax_data($item, $order); ?>></td> 
                <td><?php echo $order->format_line_subtotal($item); ?>></td>
            </tr>
        endforeach;
        ?>
    </tbody>
</table>

Update the email-order-items.php file with the above code. This will add the new column to the email template.

Step 3: Style the New Column

Let’s add some basic styling to our new column.

<style>
    .price-excl-tax {
        text-align: right;
        width: 15%;
    }
</style>

Add the above CSS code to your theme’s stylesheet (style.css) or use a CSS plugin to add custom styles.

Final Result

After adding the custom function, modifying the email template, and styling the new column, your Woocommerce email notifications should now display the order item price excluding tax.

Now you and your customers can easily view the order item price excluding tax in the email notifications.

Tips and Variations

If you want to take it a step further, here are some tips and variations to consider:

• Display the tax rate**: You can modify the code to display the tax rate alongside the price excluding tax.
• Format the prices**: Use Woocommerce’s built-in price formatting functions to display the prices in your preferred format.
• Conditional logic**: Add conditional logic to hide or display the new column based on specific conditions, such as order type or customer group.