More info about coupons
I'm using NaviCat to look at the tables in the PS4 system.
The last field in the ps4_orders table is OrderCoupon and it's the same as CouponID in the ps4_coupons table. I'm assuming that's the link. From there I can get the CouponCode and the CouponName from the ps4_coupons table.
Any idea where in the PS4 code I can find what's creating the order email sent to the purchaser and the code in PS4 that generating the order detail view in storemanager? If you can point me at the pieces of code at least I can take a look and see if I can figure out how to link the two tables to provide the missing information. This is getting a bit heady for my abilities but it looks like it could be accomplished with a little work.
In the meantime I'll try to figure out what you were talking about in your previous post.
Thanks for the help!