X-Cart forums

[DanUK]

Hi,

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

Thanks

Dan

[BCSE]

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

[awpvicki]

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.

[BCSE]

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

[BCSE]

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

[awpvicki]

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

[BCSE]

Originally Posted by awpvicki

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

OK Great!

Carrie