Right now I am trying to tie the affiliate information into the order form that I have currently created with the API. Here is what is happening...

I use the redirect, first of all, to take me to the order form (which gives me the affiliate variable ID). That is all good.

(http://nwvllc.infusionsoft.com/aff.html?to=https://www.easysecurepay.com/ssl_tsg/order_form.php)

From here, I go through the process of creating a user, a blank invoice and adding the item. At that point, I either process a credit card or redirect to paypal.

So a couple of things are happening in the point of view of the affiliate stats...

As soon as the blank order is created, I see in there stats that the "Product Sold" column increases by one (before I perform any charge).

And second, when I do perform a charge (for the credit card it is an InvoiceService.chargeInvoice call...for the PayPal, it is an InvoiceService.addManualPayment), nothing seems to happen (other than the charge is registered with my Infusionsoft CRM). The affiliate stats show no "Orders" under the Link Tracking stats.

The Commission earnings do show pending, though.

Also, I don't quite know what the bypassCommissions - (boolean) variable for both calls is really doing (since toggling it doesn't seem to do much for me). I assume that if I want the charge credited, I would set the variable to FALSE.

Man, I am SO CLOSE with the order form, and this is really the last thing to make it work for me. Please help me understand the difference between the "Products Sold" and the "Orders" and what I might be doing wrong here.

Cheers...matt

Having programmed our ordering system with the API... to my knowledge you cannot run an affiliate program using your own ordering forms.

Why? Because to credit the commission on a sale you would have to "get the affiliate id" of the affiliate who brought in the contact/prospect that you are applying the order to...(after finding the customer already in your database and assigned to an affiliate) You have to put that affiliate id in the invoice before you charge it and if you don't NO COMMISSIONS ARE LOGGED even though the affiliate may be assigned to a contact/prospect in the database!!! Dumb huh?

So why not just get that id and put it in? Because the API does not have a way to retrieve the "affiliate id" of the affiliate associated with a contact (i.e. the person or website that brought you the customer).

I have been told on occasion by Justin, the API guy, that the API would be changed to allow that... but so far I have heard nothing more about it... and it's been since last summer 2008 that we discovered the problem....

You should bug Infusion about it for sure...

-Tim

Tim,

Access to the "Referral" table via the API is rolling out the current release. Many apps already have it. You can look at your version number in the lower left hand corner of your Infusionsoft app. If it sales 1.14.1.40, then your app has the change. If, not, I think it'll be rolling out the the remaining apps in the next few days.

Its fairly easy to use the DataServiceFind call to get the AffiliateId from the Referral table.

Let me know if you need more details on how to do that.

Tyler,

Has the field-access API doc ever been updated with such changes? If so, where is it now?

Thx, Greg

Also, you can currently get the affiliate id through this url: http://yourapp.infusionsoft.com/aff.html?to=what-ever-url-you-want.com

This will actually return to the url after the to parameter with the affiliate id as a parameter in the query string. This will automatically check for affiliate cookies that may have been set and return the appropriate affiliate id.

The only issue we're having is when adding new leads through the API. There is no way to set the referral

I don't think the API docs have been updated. I'll check and make sure they get posted to the fusebox.

I know you can read the referral table, but I don't think you can add to it.

Yes I need to know how to do that.... Have the API docs been updated yet?

I need just the definition of the referral table api...

The latest API docs can be found here: https://infusionsoft.helpstream.biz/View.jsp?procId=c0cb840a1cff125f011d0c4bfc3a71e6

We changed our order system to pull the affiliate id and then enter it on the blank invoice before charging it... BUT IT STILL DOES NOT SET THE AFFILIATE ON THE ORDER... so no commission is credited and it does not show up on the affiliate ledger...

Has anyone tested that this actually works?