Jump to content
henri

OSC-Affiliate

Recommended Posts

Hey gang I'm having an issue that is driving me bonkers.. I'm only 62 pages into this thread looking for suggestions or ideas but thought asking while I finish reading couldn't hurt..

 

I have v2.5a + plus some bug fixes installed working like a charm my only issue is that when new affiliates sign up admin is not sent a notice via email.

 

I am using the same email address for the entire store so any where in configuration that I would need to insert an email I am using the same one. For example same email address is entered for Configuration> My Store> E-Mail Address and Send Extra Order Emails To. Then under Configuration> Affiliate Program> E-Mail Address the same email adress is listed.

 

The email address is set up on the same domain that the osc is installed on. Configured in my mail client correctly and receiving email. There are no spam traps or message rules set up on the email account.

 

Admin is sent an email when new orders are placed.

Customers are sent email when placing order and sigup for the store.

Customers are sent email when they sign up for affiliate account.

I can even send email to affiliate accounts by visiting Administration > Affiliate> Contact where the contact form appears to contact either all or one affiliate account.

 

But the Admin is never sent an email letting them know that a new person has signed up for an affiliate account. Am I missing something that I should have added for this to send the Admin an email notification?

 

I thought maybe it just doesn't notify Admin out of the box and I may need to dig deeper into the thread for any suggestions posted for others asking the question. So far I'm still reading so any ideas would be so much appreciated..

 

Many Thanks

Share this post


Link to post
Share on other sites

The Affiliate 'Create An Account" is a fair copy of the Customer "Create An Account" function - and you don't get an email whenever a new customer signs up, and you don't get an email when a new affiliate signs up (not unless you code it so that you get a copy when they do).

 

Vger

Share this post


Link to post
Share on other sites
The Affiliate 'Create An Account" is a fair copy of the Customer "Create An Account" function - and you don't get an email whenever a new customer signs up, and you don't get an email when a new affiliate signs up (not unless you code it so that you get a copy when they do).

 

Vger

 

Vger as always you are my saving grace!!

 

Thank you so very much for answering this question. Now I can work on trying to add this ability myself or get my friend to post a rentacoder job for the task. I was going out of my mind trying to figure out what I was doing wrong. Then I thought well you don't get an email when a customer just creates an account for the shopping cart maybe you don't with the affiliates either.

 

Thanks so much for the answer!! :thumbsup:

Share this post


Link to post
Share on other sites

line 265 in affiliate_signup.php needs to be edited:

---------------------------------------------------------

 

tep_mail($name, $a_email_address, MAIL_AFFILIATE_SUBJECT, $email_text, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);

 

Vger

Share this post


Link to post
Share on other sites

hey Vger, just wanted to drop in and say i havent forgotten to thank you nono.gif

 

I am just still trying to get it all working, hahahapity_1.gif

 

as soon as i have some good news, i will come back heal kicking:)

 

thnx Vger, your break down helped me understand the system much better than i did, i think maybe i will change the wording on that button though ;)

Share this post


Link to post
Share on other sites

ok, i am on a different cart (well, different site) same cart

 

i have tested the affililate sales on it, and none of the orders are showing when a purchase is made from an affiliate.

The order shows, yes, but under the affililate sales, it doesn not show anything.

 

also, how do you tell what number gos to what order status, i dont have a 'completed' status

Share this post


Link to post
Share on other sites
Strange, I never noticed this problem before because I don't use image links - only text links. When I have free time I will try to re-create the problem and see if it is down to the new updated contributions or if was hereditory.

 

I am having the same issue. When I create a banner, the banner image doesn't show in the admin section, nor in the affiliate account section. So, inorder to debug, I changed the debug function to true (in affiliate_configure.php), and then tried to load the banner in the browser

 

this is what it shows...

 

Locating Pic /xxx/xxxxx/xxx/xxx/xxxxxxx/www/testshoppingcart//catalogimages/apple.jpg

failed

 

As you can see in the above directory string, the "/" between catalog and images folders.

 

I checked the configure file, and it seems to be fine (see below), and the other pics in the admin section show up just fine...

 

define('HTTPS_COOKIE_PATH', '/testshoppingcart//catalog/');

define('DIR_WS_HTTP_CATALOG', '/testshoppingcart//catalog/');

define('DIR_WS_HTTPS_CATALOG', '/testshoppingcart//catalog/');

define('DIR_WS_IMAGES', 'images/');

 

So I am not sure why the "/" is missing between catalog folder and images folder. This I belive is the reason why the banner images are not showing up.

 

Any help is appreciated.

 

pav

Share this post


Link to post
Share on other sites

I have an older version of the affiliate program that I just use to monitor inbound links from my other sites - no affiliates I actually need to pay - just me ;-).

I am trying to pare down my 100 mb+ database and would like to 'empty' the tables for affiliate sales and affiliate clicks through phpmyadmin.

 

Is this safe to do ? I dont need any of the prior data and would just like to start clean. (very nervous - live store)

Share this post


Link to post
Share on other sites

In admin/includes/affiliate_configure.php, change these settings to this (or alter the 30 day limit to less):

 

define ('AFFILIATE_DELETE_CLICKTHROUGHS','30');  // (days / false) To keep the clickthrough report small you can set the days after which they are deleted (when calling affiliate_summary in the admin)
define ('AFFILIATE_DELETE_AFFILIATE_BANNER_HISTORY','30');  // (days / false) To keep the table AFFILIATE_BANNER_HISTORY small you can set the days after which they are deleted (when calling affiliate_summary in the admin)

 

This keeps the entries in the database down to a reasonable limit.

 

If you use it on an existing site it should still cut the entries in the db back to 30 days worth without you having to play with the database.

 

Vger

Share this post


Link to post
Share on other sites
This keeps the entries in the database down to a reasonable limit.

 

If you use it on an existing site it should still cut the entries in the db back to 30 days worth without you having to play with the database.

Thanks !, wow that cut my database down from 106mb to 40 mb - just what I needed - thank you !

Share this post


Link to post
Share on other sites

One more thing - I would like to wipe the sales clean to further cut down. Would it hurt or do any damage to anything to empty the affiliate sales and clickthrough database tables ?

Share this post


Link to post
Share on other sites

You can empty the table contents with no harm, provided you leave the table and its fields intact.

 

Vger

Share this post


Link to post
Share on other sites
You can empty the table contents with no harm, provided you leave the table and its fields intact.

 

Vger

absolutely perfect - thank you so much !

Share this post


Link to post
Share on other sites
Thanks !, wow that cut my database down from 106mb to 40 mb - just what I needed - thank you !
Would it not scale it down even more if you were to back up your database in admin in the .sql.gz format?

 

Give it a try and see how small the compressed db becomes - and it doesn't have any effect on your online store whether it's backed up in .sql or .sql.gz (just incase there were other people thinking of removing aspects of affiliates from their database using phpmyadmin when they may not really need to)


Upon receiving fixes and advice, too many people don't bother to post updates informing the forum of how it went. Until of course they need help again on other issues and they come running back!

 

Why receive the information you require in good faith for free, only to then have the attitude to ignore the people who gave it to you?

 

There's no harm in saying, 'Thanks, it worked'. On the contrary, it creates a better atmosphere.

 

CHOOCH

Share this post


Link to post
Share on other sites

Did anyone get this to work with SEO URLs?

 

I get this error on checkout:

0 -

insert into affiliate_sales (affiliate_id, affiliate_date, affiliate_browser, affiliate_ipaddress, affiliate_value, affiliate_payment, affiliate_orders_id, affiliate_clickthroughs_id, affiliate_percent, affiliate_salesman) values ('5', '2007-02-13 17:37:53', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1', '213.89.67.67', '18.69', '0.37', '0', '0', '02.0000', '5')

[TEP STOP]

If I have to choose I gonna stay with the affiliate system rather then SEO URLs.

 

PS:

Can I change some code to get the banners to work with .swf files? Flash is kinda kickass when it comes to advertising

Share this post


Link to post
Share on other sites
Did anyone get this to work with SEO URLs?

 

I get this error on checkout:

0 -

insert into affiliate_sales (affiliate_id, affiliate_date, affiliate_browser, affiliate_ipaddress, affiliate_value, affiliate_payment, affiliate_orders_id, affiliate_clickthroughs_id, affiliate_percent, affiliate_salesman) values ('5', '2007-02-13 17:37:53', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1', '213.89.67.67', '18.69', '0.37', '0', '0', '02.0000', '5')

[TEP STOP]

If I have to choose I gonna stay with the affiliate system rather then SEO URLs.

 

PS:

Can I change some code to get the banners to work with .swf files? Flash is kinda kickass when it comes to advertising

You shouldn't have any problems wth SEO URL's and affliates - I didn't have any. Even if SEO URL's are switched 'on', the affiliates pages will show as .php not .html - therefore they should work. Did you execute the SQL file?

 

I haven't used the affiliate system for a bit so can't on comment the swf stuff till I look at the code tonight but will let you know.

Edited by chooch

Upon receiving fixes and advice, too many people don't bother to post updates informing the forum of how it went. Until of course they need help again on other issues and they come running back!

 

Why receive the information you require in good faith for free, only to then have the attitude to ignore the people who gave it to you?

 

There's no harm in saying, 'Thanks, it worked'. On the contrary, it creates a better atmosphere.

 

CHOOCH

Share this post


Link to post
Share on other sites

Does anyone know what the correct file structure should be with this module as the zip file contains a catalog folder and an admin folder separate and an odd amount of pages between the english and german language files.

 

Can't find anything about this in the instructions or seem to find a post about this and I would like to install this module. Seems like the files have been put in the zip file in a 'sort'em out yourself basis'.

Share this post


Link to post
Share on other sites
You shouldn't have any problems wth SEO URL's and affliates - I didn't have any. Even if SEO URL's are switched 'on', the affiliates pages will show as .php not .html - therefore they should work. Did you execute the SQL file?

 

I haven't used the affiliate system for a bit so can't on comment the swf stuff till I look at the code tonight but will let you know.

 

 

I did input the SQL statement but maybe I did something wrong, it sure looks like that now when I think about it cause I have the "Super Download Shop" contribution installed too and after installing the SEO both the affiliate system and the download manager stopped working but it worked for other people. I will try to install SEO again tomorrow and see what happens.

Share this post


Link to post
Share on other sites
Does anyone know what the correct file structure should be with this module as the zip file contains a catalog folder and an admin folder separate and an odd amount of pages between the english and german language files.

 

Can't find anything about this in the instructions or seem to find a post about this and I would like to install this module. Seems like the files have been put in the zip file in a 'sort'em out yourself basis'.

which version are you talking about?


Upon receiving fixes and advice, too many people don't bother to post updates informing the forum of how it went. Until of course they need help again on other issues and they come running back!

 

Why receive the information you require in good faith for free, only to then have the attitude to ignore the people who gave it to you?

 

There's no harm in saying, 'Thanks, it worked'. On the contrary, it creates a better atmosphere.

 

CHOOCH

Share this post


Link to post
Share on other sites

Ultimate SEO URL's v2.1c works fine, but there are no SQL commands to be run with that.

 

Vger

Share this post


Link to post
Share on other sites
which version are you talking about?

 

 

Hi Chooch

 

Using oscommerce version 2.2ms2 060817

 

From page http://www.oscommerce.com/community/contributions,158 in the contributions section.

I downloaded version 2.6 which was dated 28 Jul 2006 and submitted by 'unbonche', which stated 'This is a full package for english'.

 

When I unzipped the files, the structure I got was----------

 

> admin folder

>> images folder

>>> categories folder + images

>> includes folder

>>> boxes folder

>>>> 1 php file

>>> functions folder

>>>> 1 php file

>>> languages folder

>>>> english folder

>>>>> images folder

>>>>>> buttons folder including image files

>>>>> modules folder

>>>>>> newsletters folder including 1 php file

>>>>> 12 php files

>>>> german folder

>>>>> 22 php files

>>> 2 php files

>>> modules folder

>>> 2 php files

>> 15 php files

 

> catalog folder

>> images folder

>>> categories folder + 1 image file

>>> 11 images

>> includes folder

>>> boxes folder including 1 php file

>>> functions folder including 1 php file

>>> languages folder

>>>> english folder including 1 php file

>>>>> images folder +

>>>>> 26 php files

>>> modules folder including 3 php files

>>> 3 php files

>> 52 php files

 

affiliate.sql

INSTALL_ENG.txt

 

Now I'm presuming from this, that the admin folder should really have been placed within the catalog folder, or is the admin folder setup outside of the catalog folder for this module, no clear instructions on this.

 

And if this is supposed to be 'The full package for english', then why are there more german files included than english files. I did also download the 2.5 and 2.5a versions, but they also seem to be the same weird setup of files.

 

Malcolm

Share this post


Link to post
Share on other sites
Now I'm presuming from this, that the admin folder should really have been placed within the catalog folder, or is the admin folder setup outside of the catalog folder for this module, no clear instructions on this.

 

And if this is supposed to be 'The full package for english', then why are there more german files included than english files. I did also download the 2.5 and 2.5a versions, but they also seem to be the same weird setup of files.

The catalog files are for the store (front end that customers see) and the admin files are for the admin (your store control area).

 

All the files that are in the 'catalog' folder need to be FTP'd to your catalog folder and all the files in the 'admin' folder need to be to be FTP'd to the admin folder - I can't really get clearer than that.

 

If you use only one language (English) then don't upload the German files.

 

You must execute the affiliates.sql file in the databse too.

 

I cannot comment what the best version of this contribution is because I used a very old one and added some patches to make it work, so you can work with the 2.5version you downlaoded and make a go of it from there.

Edited by chooch

Upon receiving fixes and advice, too many people don't bother to post updates informing the forum of how it went. Until of course they need help again on other issues and they come running back!

 

Why receive the information you require in good faith for free, only to then have the attitude to ignore the people who gave it to you?

 

There's no harm in saying, 'Thanks, it worked'. On the contrary, it creates a better atmosphere.

 

CHOOCH

Share this post


Link to post
Share on other sites

Well - seems this is asked and sort of answered, but none of the answers are working for me so here goes:

 

My host is running PHP 5 which i suspect is part of the issue based on a LOT of reading...

 

My show banners gives me great stuff in debug mode:

 

Check the pathes! (catalog/includes/configure.php)

absolute path to picture: /home/xxxxxxx/public_html/buildx/images/cameron_diaz.jpg

build with: DIR_FS_CATALOG . DIR_WS_IMAGES . $banner

DIR_FS_CATALOG /home/xxxxxxx/public_html/buildx/

DIR_WS_HTTP_CATALOG /buildx/

DIR_WS_IMAGES images/

$banner cameron_diaz.jpg

SQL-Query used: select affiliate_banners_image, affiliate_products_id from affiliate_banners where affiliate_banners_id = '3' and affiliate_status = 1

Try to find error:

SQL-Query: Got Result

Locating Pic /home/xxxxxxx/public_html/buildx/images/cameron_diaz.jpg

success

 

 

I can preview the banner in admin...

 

The problem lies in that a placed banner (link copied in to a test html page) and a banner in the affiliate section simply wont show up...

 

silly_aff.jpg

 

Anyone have any good answers on this one? Please?

Edited by MarthaD

Share this post


Link to post
Share on other sites
Anyone have any good answers on this one? Please?

In the affiliate_banners_banners.php file you have 2 lines that need amending:

 

Line 79 and Line 85

 

Both have: HTTPS_SERVER twice in each line, all four of those need the 's' removed to make it: HTTP_SERVER


Upon receiving fixes and advice, too many people don't bother to post updates informing the forum of how it went. Until of course they need help again on other issues and they come running back!

 

Why receive the information you require in good faith for free, only to then have the attitude to ignore the people who gave it to you?

 

There's no harm in saying, 'Thanks, it worked'. On the contrary, it creates a better atmosphere.

 

CHOOCH

Share this post


Link to post
Share on other sites
In the affiliate_banners_banners.php file you have 2 lines that need amending:

 

Line 79 and Line 85

 

Both have: HTTPS_SERVER twice in each line, all four of those need the 's' removed to make it: HTTP_SERVER

 

The code is correct Chooch...

  <img src="' . HTTP_SERVER . DIR_WS_HTTP_CATALOG . DIR_WS_IMAGES . $affiliate_banners['affiliate_banners_image'] . '" border="0" alt="' . $affiliate_banners['affiliate_banners_title'] . '"></a>' 

 

I even modified it to mach my config file which calls to WS_HTTP_CATALOG thinking that was the issue....

 

  define('DIR_WS_HTTP_CATALOG', '/catalog/');
 define('DIR_WS_HTTPS_CATALOG', '');
 define('DIR_WS_IMAGES', 'images/');

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×