Kryptronic Software Support Forum

Anyone??

nav,

Thanks for the reply.  I didn't change any file or dir permissions during the installation process.  I used the default install of Apache 2.0 (latest stable version), and placed the CCP 5.1 files into the recommended directories under htdocs and cgi-bin.  I just double checked the permissions on all of the CSV files and they are indeed rw (this is a Windows server).  I'm using the .htaccess files as configured by Kryptronic.

Regarding this being a permission issue, if CCP could update commissions for two of the levels wouldn't that indicate that it had sufficient access rights to update all of the levels?

Also, this problem is 100% reproducible.

To determine if this is related to any of my mods, I'll install CCP on another machine  right now and try to reproduce the problem there with no modifications to CCP.  Should have thought of that.

Regards,
Eric

nav,

On a brand new install of CCP 5.1 and Apache 2.0, with no mods the problem occurs.

I added the order manually instead of using the CCP real-time commission updating and I noticed something I didn't expect in the in the "Update Online Order" screen: CCP automatically placed the primary affiliate into the "Primary Affiliate Account" field on the order, but it also had a single affiliate listed in the "Related Affiliate Accounts" field.  Could this be the problem?  I'm assuming that when the CCP docs state that the affiliate commissions can be as many levels deep as desired, that when a tree of affiliates is set up, that CCP automatically credits all affiliates in the tree WITHOUT me having to manually put in all related affiliates into the "Related Affiliate Accounts" field?  I looked at the source code and it seems as though that's the intent of the affiliate commissions logic.

Additional info: This is for a site that expects to have thousands of affiliates. 

nav,

More info, this problem definitely seems related to the "Related Affiliate Accounts" field in the order.  I manually changed it to include multiple upline affiliates, and the this time the upline affiliates were credited with the order.  So, at this point, I've confirmed on two different machines that CCP is only crediting the first two levels in an affiliate lineage.  I need it to credit all levels (or a max of 10 to be exact) with no manual processing on each order.

This is the only software I have running on this Apache server, and the error log is clean.

nav,

There is no error message.  CCP just silently fails by only crediting commissions to two out of 10 or so upstream accounts.

nav,06/17/2004 02:43:53 PM wrote:

Check your affiliate config file (CSV) and see if there are commission lines set to 10. If so, change those 10s to your specific value.

nav,

Sorry, I'm dense. I don't understand what you mean when you say: "see if there are commission lines set to 10".

I checked my file affacct.csv (is that the file you were suggesting I check?).  Below are the settings for my test accounts.  Note that S1 has a single affiliate under it called S2, etc.  Also please note that this data is not confidential since I will erase it once the testing is complete:

S1,LA==,Y,100.00,1.00,0.00,PCT,1.000,PCT,1.000,S2,1,1,,1,,1,Utah,United States,1,R,1,,C2,N,11111

S2,LA==,Y,75.00,0.75,0.00,PCT,1.000,PCT,1.000,S3,1,1,,1,,1,Utah,United States,1,R,1,,1,N,11111

S3,LA==,Y,50.00,0.50,0.00,PCT,1.000,PCT,1.000,S4,1,1,,1,,1,Utah,United States,1,R,1,,1,N,1111

S4,LA==,Y,25.00,0.25,0.00,PCT,1.000,PCT,1.000,S5,1,1,1,1,,1,Utah,United States,1,R,1,,1,N,11111

S5,LA==,Y,25.00,0.25,0.00,PCT,1.000,PCT,1.000,S6,1,1,,1,,1,Utah,United States,1,R,1,,1,N,1111

S6,LA==,Y,25.00,0.25,0.00,PCT,1.000,PCT,1.000,S7,1,1,,1,,1,Utah,United States,1,R,1,,1,N,1111

S7,LA==,Y,0.00,0.00,0.00,PCT,1.000,PCT,1.000,S8,1,1,,1,,1,Utah,United States,1,R,1,,1,N,1111

S8,LA==,Y,0.00,0.00,0.00,PCT,1.000,PCT,1.000,S9,1,1,,1,,1,Utah,United States,1,R,1,,1,N,1111

S9,LA==,Y,3348.44,33.48,0.00,PCT,1.000,PCT,1.000,S10,1,1,,1,,1,Utah,United States,1,R,1,,1,N,1111

S10,LA==,Y,3373.44,33.73,0.00,PCT,1.000,PCT,1.000,S11,afffirst1,Aafflast1,,1,,1,Utah,United States,1,R,1,,1,N,1111

S11,LA==,Y,25.00,0.25,0.00,PCT,1.000,PCT,1.000,S12,1,1,,1,,1,Utah,United States,1,R,1,1,1,N,11111

S12,LA==,Y,450.00,4.50,0.00,PCT,1.000,PCT,1.000,S13,1,1,,1,,1,Utah,United States,1,R,1,,1,N,1111

S13,LA==,Y,450.00,4.50,0.00,PCT,1.000,PCT,1.000,S12,1,1,,1,,1,Utah,United States,1,R,1,,1,N,

nav,

First of all, I just want to say "thanks"... I appreciate your help on this.  Hope I can return the favor someday.

Secondly, I didn't understand what you are reffering to as far as the ",10" results in my config_affacct.csv file.  So I included it below.  Again, this is non confidential as this is test data:

config_id,config_column_creator,config_description,config_varchar,config_not_null,config_display_type,config_display_value,config_default_value,config_disp_inlist

affacct_id,SYSTEM,Affiliate Code (Reference String),100,Y,TEXTBOX-REG,,,Y

affacct_pass,SYSTEM,Password,20,Y,PASSWORD,,,N

affacct_active,SYSTEM,Active Status,10,Y,SELECT-CUSTOM,Active:Y|Inactive:N,N,Y

affacct_salestd,SYSTEM,Sales Total (To Date),50,Y,TEXTBOX-REG,,0.00,Y

affacct_commearntd,SYSTEM,Commission Earned (To Date),50,Y,TEXTBOX-REG,,0.00,N

affacct_commpaidtd,SYSTEM,Commission Paid (To Date),50,Y,TEXTBOX-REG,,0.00,N

affacct_typemain,SYSTEM,Commission Currency/Percent Type (Sales As Primary Affiliate),4,Y,SELECT-CUSTOM,Currency:CUR|Percent:PCT,PCT,N

affacct_valuemain,SYSTEM,Commission Currency/Percent Value (Sales As Primary Affiliate),10,Y,TEXTBOX-REG,,5.000,N

affacct_typesub,SYSTEM,Commission Currency/Percent Type (Sales From Sub Affiliates),4,Y,SELECT-CUSTOM,Currency:CUR|Percent:PCT,PCT,N

affacct_valuesub,SYSTEM,Commission Currency/Percent Value (Sales From Sub Affiliates),10,Y,TEXTBOX-REG,,2.500,N

affacct_xaff,SYSTEM,Related Affiliates (Sub Affiliates of this Affiliate),255,N,TEXTAREA-RELATE,affacct|Affiliate|Affiliate,,N

affacct_firstname,SYSTEM,First Name,50,Y,TEXTBOX-REG,,,Y

affacct_lastname,SYSTEM,Last Name,50,Y,TEXTBOX-REG,,,Y

affacct_company,SYSTEM,Company Name,50,N,TEXTBOX-REG,,,N

affacct_addressone,SYSTEM,Address Line 1,50,Y,TEXTBOX-REG,,,N

affacct_addresstwo,SYSTEM,Address Line 2,50,N,TEXTBOX-REG,,,N

affacct_city,SYSTEM,City,50,Y,TEXTBOX-REG,,,N

affacct_stateprov,SYSTEM,State/Province,50,Y,SELECT-TABLE,stateprov,,N

affacct_country,SYSTEM,Country,50,Y,SELECT-TABLE,country,,N

affacct_zip,SYSTEM,Zip/Postal Code,10,Y,TEXTBOX-REG,,,N

affacct_rescom,SYSTEM,Residential/Commercial,5,Y,SELECT-TABLE,rescom,,N

affacct_phone,SYSTEM,Telephone Number,15,Y,TEXTBOX-REG,,,N

affacct_fax,SYSTEM,Fax Number,15,N,TEXTBOX-REG,,,N

affacct_email,SYSTEM,Email Address,150,Y,TEXTBOX-REG,,,N

affacct_emailsent,SYSTEM,Welcome Message Generated,4,Y,SELECT-CUSTOM,Yes:Y|No:N,N,N

nav,06/17/2004 06:05:02 PM wrote:

Exacly what I thought :

Code:

affacct_valuemain,SYSTEM,Commission Currency/Percent Value (Sales As Primary Affiliate),10,Y,TEXTBOX-REG,,5.000,N

and

Code:

affacct_valuesub,SYSTEM,Commission Currency/Percent Value (Sales From Sub Affiliates),10,Y,TEXTBOX-REG,,2.500,N

Two results where it says : ,10,Y (leave the commas and the 'Y' as it is though).

Additional info : It mentions the Commission Currency for primary and sub affiliates. Exacly what you needed to know.

nav,

I'm not following you at all.  The records you quoted above, I believe, specify the database schema for the accumulated sales per affiliate.  They are both 10 byte wide varchar fields (which is enough to represent a very large number).  I'm not seeing the relationship between this and the problem I'm experiencing.

nav,06/17/2004 07:15:47 PM wrote:

Oh ! ... I must of missed understood somewhere then. That is all I could find about affiliate commissions (for now). I thought this is what you needed to modify.

Sorry.

Update : I just found out that your topic was about shipping regarding realtime modifications, is it the case ?

If so, it would require modifications somewhere in the routine. Nck should be able to provide the info on this one.

Sorry for the flood.

nav,

I greatly appreciate your help.  The problem I'm having is that the commissions are only being credited for the first two levels of a 15 level chain of affiliates and subaffiliates.  I'm implementing a site for a MLM company and they want to pay 1% commissions for up to 10 levels deep in the affiliate/subaffiliate chain.  I have set up a 10% max payout cap on commissions.  Right now, CCP is only crediting 1% commissions for the primary and the first subaffiliate.

Regards,
Eric

:-)

nav,06/17/2004 09:08:26 PM wrote:

I think I understand what you mean now. To avoid further floodings in the topic, let's do this over PM.

nav,

Ok.

Eric

From a PM:

Clarification: I'm not requesting a custom feature... I'm just trying to get an out-of-the-box feature of the program to work as per the documentation and the sales literature. They both state that CCP handles an unlimited number of subaffiliates with commissions. Right now, that doesn't seem to be working.

If anyone from CCP (Kryptronic) is there, I've sent an e-mail to support at 10:27PM on the 16th.  A reply would be greatly appreciated.

Eric

 

nav,

As I mentioned above, I have already looked at the source code that deals with affiliate commissions.  Since no one from Kryptronic has gotten back to me, I'm teaching myself how to debug Perl scripts when called from Apache.