It is on the pp_confirm.php page below the store cart details in database, which is the correct location, so that wasn't the issue.
It looks like the email body is coming from: webassist/email/muirhead_receipt.php
Are you sure the database is being updated properly? Does the order_details table have the correct value in the product_id column and order_id column?