Show Jrox affiliate ID in Orders

[84xads]

I am successfully using Jrox JAM with my Zen Cart 1.3.8a to pay affiliates. I am using the template footer override Zen Cart intergration.

I would like to pull in the JAM affiliate ID after checkout success so it appears in Admin/Customers/Orders or so I can run a report which links customers to their referring affiliate.

This reporting feature is for brick n' mortar store manager's which have limited admin access to Zen Cart, but no access to JAM admin...

Thank you for any guidance!

[schoolboy]

The two programs work on separate databases (or if you use prefixes in a single database, they operate on independent table structures.)

The challenge will be reading data off one database (JROX), then parsing the contents into the other (ZENCART).

It probably can be done, and I would imagine that the majority of the work would need to be done on the JROX side.

Have you put up a note on the JROX user forum?

[84xads]

I did post at the JAM forum, but no response yet...

I have been studying the JAM tables and have yet to see where the affiliate ID is stored during checkout success...

I was hoping that someone here had a similar desire and found a solution or has the expertise to help me link the tables.