options & sku not passing to database

Hey Ray

As per chat on Friday, been trying to get the options and the sku to pass to the database on a successful order but unable to. I have set the columns as per http://prntscr.com/8ldrc7 - not sure what else I need to do?

Cheers

Jamie

Attach a copy of the confirm and pp_confirm pages so I can check if you have updated the store card details in database server behaviors properly.

have managed to get the SKU and options adding now, just not getting the 'OrderCoupon' value being added to the 'orders' table so that I can display it on the orders_detail.php page

I don't see the binding to store "OrderCoupon" on the pp_confirm page Store Cart Summary in database server behavior. You would need to add that and set it to the Session variable you use to store the coupon.

It would also have to be added on the checkout _success page, which you didn't attach.

ok thanks Ray have got it working now.

as an extension to this, what are the steps I would need to do to get the £ value of the coupon code stored in the order table?

You can use the binding for eCart total discount.

is that totalDiscount?

Yes

ok

have tried adding $ConditionalQuery->bindColumn("OrderCouponValue", "d", "".$FrithsCart->TotalDiscount() ."", "WA_DEFAULT"); to the pp_confirm page and it isnt working..

I'll contact you in Skype for a screen sharing session to debug this today.