Custom checkout form info not flowing into order table
We are trying to add unique form data from our checkout page to our success and email pages (UE), and store in the database (orders table). For some reason, the info does not show on the success page and email, and new orders do not store the unique data.
We created unique columns in the orders table to capture this unique data. On the confirm.php page, I have modified the "Store Cart Summary in Database" to bind the unique values to the new columns in the orders table.
I added "form data" from checkout.php page to the bindings panel and selected it for the new column value when storing the cart summary - but when I create a new order that field remains blank.
I followed the solution recipe for "ecart coupons" to set session values for the new fields (on checkout.php) that will carry to checkout_success.php and populate the email sent by UE. I changed the binding in "store cart summary in database" to the new session value, but when I generate a new order, the unique field still remains empty in the order table. Strange!
It seems like flowing this data on the pages and recording in the database should be simple, but there's something I'm missing.
Thank you in advance!!!