Jump to content
henri

OSC-Affiliate

Recommended Posts

By the by I am the ISP :wink: I have my own Pipe yippie !! and own the servers !

anywayz I did as you requested and you where right that fixed the notice error's I tweaked the PHP.ini ! I am wondering if you would be so kind as to address my previous posts :wink: If you could post the (HOW TO )on changing the the code From (is_upload) to Tep_Copy would be very cool !!! I am new to php and learning so very much ! I am not sure where or what I need to change to get the Banners to upload .. :D

 

ALso I have the same issue as other posts in this thread and I really have not seen a fix posted .. when banner is set to 1 I can see banner and all is well except when I try to link directly to a product using the product ID the image is broken. I looked at the code it generated it looked too me as if it was getting the filename for the pic as the product name and no extension was added to that name . AKA product name brokin image but the file name for the pic = image.jpg :shock:

 

Also when banner set to 2 image broken cannot get this to work :(

This is a very cool contrib I really want this to work ! and if you have the time I can hook you up with some free music ! thank so much for this contrib it rocks!

Share this post


Link to post
Share on other sites
 I am wondering if you would be so kind as to address my previous posts  :wink:  If you could post the (HOW TO )on changing the the code From (is_upload) to Tep_Copy would be very cool !!!  

I didn't have the time too look at it yet. (It stands on the todo list now)

Look at the code (and the code of the OSC-Bannermanager and find out yourself)

Also when banner set to 2 image broken cannot get this to work  :(  

This is a very cool contrib I really want this to work ! and if you have the time I can hook you up with some free music ! thank so much for this contrib it rocks!

Should be answered a lot of time (here and the faq)

activate debug mode, open Bannerlink in a new browserwindow

you see a table with debuginfo -> Now you should know whats wrong

Fix it, deactivate debugmode

Share this post


Link to post
Share on other sites

<a href="http://www.overdog.com/product_info.php?ref=3&products_id=66&affiliate_banner_id=1" target="_blank"><img src="http://www.overdog.com/images/" border="0" alt="Saviamantra"></a>

no extension and wrong file name ....

 

this is what th url code looks like when I try too link to a product with banner set to 1 the image name for Saviamantra = estrla.jpg :shock:

not sure what's up with that also the preview image is broken ...

 

I will do as you requested and agian thanks for your time !

Share this post


Link to post
Share on other sites

Do you see anything wrong ?

 

 

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

absolute path to picture: x:/xxxx/images/testbanner.jpg

build with: DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG . DIR_WS_IMAGES . $banner

DIR_FS_DOCUMENT_ROOT x:/xxxx

DIR_WS_CATALOG /

DIR_WS_IMAGES images/

$banner testbanner.jpg

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

Try to find error:

SQL-Query: Got Result

Locating Pic x:/xxxxx/images/testbanner.jpg

success

Share this post


Link to post
Share on other sites

success

means it should work with banner set to 2

(can be a problm with your webserver, the whole thing is tested with Linux Apache only)

Share this post


Link to post
Share on other sites
I can not get this mod to build a link? Wonder what I did wrong.

I don't know ;)

Whats going wrong?

Share this post


Link to post
Share on other sites

just wondering if you have any thoughts on this I am using ISAPI.dll instead of the CGI and its PHP 4.3.1 :? dam windows anyway I must go too the dark side very soon Luke use the force 8)

 

thanks again soon to jion the dark side !

hmm

 

well I guess I could be your test subject for windows yes :D

 

 

Thanks John

Share this post


Link to post
Share on other sites

As you can imagine I am fairly new to this

 

The instruction says

MySQL ALTERATIONS

 

Insert the new tables found in the affiliate.sql file into your osCommerce catalog database.

 

Currently phpMyAdmin can:

a.. create and drop databases

b.. create, copy, drop and alter tables

c.. delete, edit and add fields

d.. execute any SQL-statement, even batch-queries

e.. manage keys on fields

f.. load text files into tables

g.. create (*) and read dumps of tables

h.. export (*) and import data to CSV values

i.. administer multiple servers and single databases

j.. communicate in more than 20 different languages

I had a look and canot figure out how to add my new

tables.

 

THe original database was copied by the OScommerce

installation

routine and there are no menu in the OS admin to add

tables to the existing

database

Could you please let me know how this can be done ?

Share this post


Link to post
Share on other sites

Hiya

 

i have found this mod to be extremely useful. Really nice work henri

 

I would like to ask, that does the cookie's lifetime have to be set in Seconds ?

Share this post


Link to post
Share on other sites

If you would look on the explanation on the right side, this would answer your question, too. Sometimes reading helps a lot :wink:

 

How long does the click count (seconds) if customer comes back.

 

HTH Stefan

Share this post


Link to post
Share on other sites

I've installed and created a tets affiliate member, but cannot login...I type in the login an dpassword and it keeps just refreshing the page when I hit continue. I have made sure that the cookies are turned on, but still no go. Any ideas? I'm sure its something simple I'm just overlooking.... :shock:

Share this post


Link to post
Share on other sites

Ive installed this module but after entering a dummy name and info and wanting to enter or view the availbe banners, no show.

 

please view this yourself for testing propuses.

 

username is info@urbachkl.ch

password is 2131010

my shop url is http://www.urbachshop.ch

 

This is were the image is stored.

https://secure.webland.ch/urbachshop/cgi-bi...ages/banner.gif

 

All I want to no if there is any info in this forum about this problem

 

Thanks

Steven

Share this post


Link to post
Share on other sites

Thanks for this great contribution, I have set it up and am testing now. Everything seems to work ok.... however I have a question, why is tax being added to Affiliate payments? Is there anyway to turn this off? In the UK I can see absolutely no reason why we should add VAT to the affiliate payment?

 

I have my shop set up to add tax to all product prices, is this the reason tax is being added to affiliate payments?

 

Thanks - Paul

Share this post


Link to post
Share on other sites

Cause you have to?

Or are you allowed to write invoices without VAT?

From amazon UK:

We will pay you referral fees (including VAT, if any, on presentation of a valid VAT invoice) on a quarterly basis.

 

But in admin/affiliate_configure:

define ('AFFILIATE_TAX_ID','1'); // Tax Rates used for billing the affiliates

// you get this from the URl (tID) when you select you Tax Rate at the admin: tax_rates.php?tID=1

 

Put this to a 0 tax rate.

Share this post


Link to post
Share on other sites
Cause you have to?

Or are you allowed to write invoices without VAT?

From amazon UK:

We will pay you referral fees (including VAT, if any, on presentation of a valid VAT invoice) on a quarterly basis.

 

But in admin/affiliate_configure:

define ('AFFILIATE_TAX_ID','1'); // Tax Rates used for billing the affiliates

// you get this from the URl (tID) when you select you Tax Rate at the admin: tax_rates.php?tID=1

 

Put this to a 0 tax rate.

 

Thanks for the reply, I have looked into this properly today, as I just cannot understand why you would pay VAT on a payment to an affiliate. I spoke to the Customs & Excise in the UK and it seems that you only have to pay VAT to an affiliate if they are registered for VAT and can prove that, hence the amazon requirement for a valid VAT invoice.

 

I believe that on my site approx 99% of future affiliates will not be VAT registered and this would probably be the case for most people.

 

So I am going to disable Tax payments with affiliate payments. In the eventuality that I have an affiliate that is VAT registered I will have to manually alter the database records for that affiliate to pay VAT to them.

 

Thanks for the solution provided, however as a suggestion I would say that the best way to implement this in the contribution would be to make the default set-up not apply Tax, and to be able to add VAT/Tax to affiliate payments on an individual basis.

Share this post


Link to post
Share on other sites

I have found a small bug in the affiliate_summary file. The conversion percentage for sales to clickthroughs shown is not right, eg: 2 sales and 4 clickthroughs shows a percentage of 0.5%, this should be 50%.

 

To correct this change the following code:

 

  if ($affiliate_clickthroughs > 0) {

$affiliate_conversions = tep_round($affiliate_transactions / $affiliate_clickthroughs, 6) . "%";

 }



TO



 if ($affiliate_clickthroughs > 0) {

$affiliate_conversions = tep_round(($affiliate_transactions / $affiliate_clickthroughs)*100, 6) . "%";

 }

Share this post


Link to post
Share on other sites
So I am going to disable Tax payments with affiliate payments. In the eventuality that I have an affiliate that is VAT registered I will have to manually alter the database records for that affiliate to pay VAT to them.  

How do I disable Tax Payments with affiliate payments? I live in New York, USA and I don't understand why we'd pay taxes to the affiliates. :shock:

 

Where does it get the tax information? How much tax would it know to add?

 

I think it's just best I disable this. How?

 

Thanks,

Priest

Share this post


Link to post
Share on other sites
So I am going to disable Tax payments with affiliate payments. In the eventuality that I have an affiliate that is VAT registered I will have to manually alter the database records for that affiliate to pay VAT to them.  

How do I disable Tax Payments with affiliate payments? I live in New York, USA and I don't understand why we'd pay taxes to the affiliates. :shock:

 

Henri just explained how to do this a couple of posts back!

 

But in admin/affiliate_configure:  

define ('AFFILIATE_TAX_ID','1'); // Tax Rates used for billing the affiliates  

// you get this from the URl (tID) when you select you Tax Rate at the admin: tax_rates.php?tID=1  

 

Put this to a 0 tax rate.

Share this post


Link to post
Share on other sites
 define ('AFFILIATE_DELETE_CLICKTHROUGHS','false');  // (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','false');  // (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)

 

How do I change this then? If I want the reports to be deleted after 30 days, would this be right:

 define ('AFFILIATE_DELETE_CLICKTHROUGHS','30 / true');  // (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 / true');  // (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)

 

?? Sorry if this seems like a stupid question. Maybe I'm just not reading this right.

 

Priest

Share this post


Link to post
Share on other sites

just did an install of OSC-Affiliate 1.01, and i am getting

 

Warning: Division by zero

/includes/functions/html_output.php on line 115

 

error. help!!!!

Share this post


Link to post
Share on other sites

i found the problem. it was a review image that was non existant. it's strange, because i never had a probelem before the install.

Share this post


Link to post
Share on other sites
 

define ('AFFILIATE_DELETE_CLICKTHROUGHS','false'); // (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','false'); // (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)

 

 

How do I change this then? If I want the reports to be deleted after 30 days, would this be right:

 

define ('AFFILIATE_DELETE_CLICKTHROUGHS','30 / true'); // (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 / true'); // (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)

 

Ok, obvisouly that didn't work. What is the correct code for wanting these reports to delete after 30 days?

Share this post


Link to post
Share on other sites

I am wondering if there is a way to turn the affliate program into a multi-level affiliate program where affiliates who signup other affiliates get a percentage of their secondary affiliates sales??

TY

Theo.


Share your knowlege and you learn even more !

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

×