Re: BCSE Reward Points and Orders Export
Dan
If you look in the points table, you will want to key off of orderid and type.
So if the type contents are "P" that stands for payment. So look for:
where orderid=$orderid and type='P'
In your query to include the info into the orders export.
Hope that helps.
Thanks,
Carrie
|