@Jonathan,
Is there a way to check the chosen shipping option and return a note depending on that
The WooCommerce Orders are stored in the woocommerce_orders table in WordPress.
I would start by placing an example order, and searching for the order number and post_id in the database to find the correct fields.
The post_id can be seen in the url field.