How get order Meta data in Spark Editor
Learn how to fetch order meta in your email templates using the Spark Editor
Last updated
Learn how to fetch order meta in your email templates using the Spark Editor
Last updated
WooCommerce stores extra order details in the Post Meta table using a key-value format.
Although Spark Editor supports all default order values, you might have additional data from plugins or custom fields. For instance, the Shipment Tracking ID could be a custom field.
Below is a screenshot of such a custom field.
WooCommerce allows adding additional values to every order using the "Custom Fields" section.
This custom field usually gets saved in the wp_postmeta table as a meta_key and meta_value
In the above example,
meta_key = tracking_id (it is always good to use an underscore instead of spaces) meta_value = 123456
Similarly, most shipment tracking id plugins save the data to the order (post) meta table. You can easily cross-check with the developer of the plugin to know where they save the data. It would most probably in the order meta (post meta) table.
Step 1: Make sure you created the custom field or get the existing field's key
Go to your WordPress dashboard -> WooCommerce -> Orders
Open an order and scroll to the bottom of the record.
You will see both existing Meta Name/Key and their values for the order.
You can also create new value for the order by click "Enter New" link
NOTE: Once created, this Meta Name / Key will be available in the "Select list" in all other orders. So you can simply select and just enter the values. Save.
Step 2: How to fetch this order meta in email template
Just go to your WooCommerce -> Spark Editor -> Edit the Email Template where you wanted to include the order meta
Add a short code in the following format: {{order_meta.your_meta_key}}
In our example, it will be: {{order_meta.tracking_id}}