RE: Affilate Reporting

["Russ" <russ@khouse.org>]

******    message to minivend-users from "Russ" <russ@khouse.org>     ******

I'm working on it!!!!

I'm using MV 3.12.  I have a userdb with a some key fields:  username
affiliate.

I have 2 other databases: affiliatesdb.asc and affiliates.txt.  When an
order is placed, affiliates.txt is tagged with the order number, subtotal,
and Affiliate Code. (Which i pass from a hidden form field on the last page
of the checkout from the [data session source].)

The affiliatesdb.asc file has the username, affiliate code, and percentage.

userdb::affiliate must be set to '1' for the link to the affiliate program
to come up.  when they get the link, here's the main part of the code:

[set affsearch]
mv_search_file=affiliates.txt
mv_search_field=sourceid
mv_searchspec=[data base="affiliatesdb" field="affiliatecode" key="[data
session username]"]
mv_max_matches=1000
[/set]
[loop search="affsearch"]
<!-- [calc]$affiliatesubtotal += [loop-data affiliates subtotal][/calc] -->
<!-- [calc]$affiliateorders++[/calc] -->
[/loop]
Hello [data session username]!  Your affiliate code is [data
base="affiliatesdb" field="affiliatecode" key="[data session username]"]
<p>
You have had [calc]$affiliateorders[/calc] orders that came through your
account!<br>
At this percentage: <big>[data base="affiliatesdb" field="percentage"
key="[data session username]"]%</big><br>
You Get: <big><big>$[currency][calc]($affiliatesubtotal*[data
base="affiliatesdb" field="percentage" key="[data session
username]"])/100[/calc][/currency]</big></big>

Does that make sense?

This allows for different percentages for different clients (nice feature).

I'd like to not use the userdb::affiliate field to setup the link, because
its a pain to export the userdb, change the code for one client, then import
it again. (I havn't figured out a better way yet!)

If anyone has any other code or ideas, I'd love to get my hands on 'em and
optimize this and make it more automatic and spiffier!!!

Russ

P.S.

I'm trying to make a page that will display ALL the affiliates and their
rewards, for the purpose of distributing dough.  I'm trying nested loop
searches but no beans.   Does anyone know how to set a looping file search
based on results of another looping file search?



-----Original Message-----
From: owner-minivend-users@minivend.com
[mailto:owner-minivend-users@minivend.com]On Behalf Of Chris Daniel
Sent: Monday, May 17, 1999 4:30 PM
To: minivend
Subject: Affilate Reporting


******    message to minivend-users from Chris Daniel
<krskrem@speedfactory.net>     ******

Anyone done a real time affilate reporting program?
Something that allows webmasters with sales accounts to view their sales
online.
In looking at the flycat config I see there is something simular.
Although I dont want them to be able to edit the site or add or remove
products.
Just view the sales.

Anybody gotta start on this?
Chris Daniel
http://www.phuckvideo.com


-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to
Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list