BCSE Reward Points and Orders Export
 

Hi,

Has anyone managed to get the points used value in the default X-Cart orders export?

Thanks

Dan

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

Re: BCSE Reward Points and Orders Export
 

I need to add in the points discount to my orders export in 4.3 - I know where and how to add it in, but I have no idea what the field is called.... I have tried {$item.points_discount}, {$item.points}, {$item.points_applied}, but no luck. Can someone help?

thanks.

Re: BCSE Reward Points and Orders Export
 

Sorry for the delay in replying to this thread. We've had a lot of illness in the office this week. Please drop us an email or support ticket. That will ensure it's not only myself getting the message, then my whole team can get the message and can help out if I'm busy covering for those that are out.

Thank you,

Carrie

Re: BCSE Reward Points and Orders Export
 

I heard in the office we got your email and helped out. Hopefully it helped well! I haven't had a chance to followup on the ticket to see.

thanks,

Carrie

Re: BCSE Reward Points and Orders Export
 

Thanks Carrie - it was sorted really quickly! Great customer support!

Re: BCSE Reward Points and Orders Export
 

OK Great!

Carrie