snap-affiliates?

[ShockRaver]

anyone?

Hi,

in the account page i want to add a column to show the latest order status of the order.

in includes/modulespages/refferer_main/header_php.php i changed the sql statement to this:

select o.date_purchased, o.order_total, c.commission_paid, c.commission_rate, t.value, s.orders_status_id from zen_orders as o, zen_orders_total as t, zen_commission as c, zen_orders_status_history as s where c.commission_referrer_key = '**********' and o.orders_id = t.orders_id and o.orders_id = c.commission_orders_id and t.class = 'ot_shipping' and o.orders_id = s.orders_id GROUP BY s.orders_id order by s.orders_status_history_id ASC

But i think i didn't GROUP it well, because it always shows the order status of the latest order...

can someone help me with this?

Eelco

[stephenmccann]

Hi did you get it working on Zencart 1.3.9??

[juggernautsei]

I have just finished setting up this module and first I want to thank you for all the hard work that went into developing this module.

I just have a suggestion or two. The registration process should be blended into the signup page meaning since the system makes them register. In the system, when someone goes to mysite.com/index.php?main_page=referrer_signup page they should be presented with the registration form. Not have to click to get to it. And make the site link optional. The reason being is that we are going to use it for a offline referrals program so the majority of the people do not have a website. Our field agents will be signing people up. Then we will email them a link to share with their clients via text or twitter.

The terms and conditions should be a check box on the registration page as well. This should be a mandatory check box.

Great work!

[dclopez]

Hello,

I have added snap affiliates, but I was wondering, is there a delete button to remove affiliates?

[lat9]

Hello,

I have added snap affiliates, but I was wondering, is there a delete button to remove affiliates?

Not per se, but there is a "Ban" button in your admin's Customers->Referrers tool that disables their account (and sends them an email indicating as such).

[dclopez]

I could delete the account via myphp admin though correct?

[lat9]

I could delete the account via myphp admin though correct?

Yes, let me look at the plugin to see what all would need to be removed (I think it's more than just the referrer's record).

[BrianWI]

I am looking at installing Snap Affiliates. But in orders.php, I don't see what change 3 of 6 in the file is doing. Anyone? Seems like just a misplaced comment.

[lat9]

I am looking at installing Snap Affiliates. But in orders.php, I don't see what change 3 of 6 in the file is doing. Anyone? Seems like just a misplaced comment.

That change is adding the "updated_by" field for the display.

[BrianWI]

I installed it. I see the cookie in the browser. No credit for the sale to the affiliate. What gives?