Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

OSC-Affiliate


henri

Recommended Posts

OK i got my previous issues fixed however i now have an issue which was discussed in some older posts but seriously i cant pick through them to get an answer so I'll ask again at risk of being stoned,lol. OOps by rocks that is..LMAO

 

I added a test affiliate, made a sale, changed its status to delivered. Now i go to the payment page in admin (where that infamous 'start billing' button is) and it shows nothing for pending or paid. From what i gathered so far in my reading somewhere there is a place where the amount of days before the commission can be paid is set. Someone had said it is set at 30 days someone else said 3 either way i dont know where i should change this setting to suit my needs. I do not accept returns due to the nature of my product so I'd like to change it to no wait time. Can someone explain where I do this and how to set it to a "no wait time". I need to make sure EVERY last part is functioning before i roll out the program.

 

Thanks!!

Melissa ;)

Link to comment
Share on other sites

Hi guys... As Greg I also have the same problem I cannot bill my affiliates...

 

In fact, when I bill, The affiliate receive the mail saying he got new sales been added to his affiliate sales but I can't see any history on what I have billed...

 

Any clue? <_<

Link to comment
Share on other sites

If you go into the admin area of your store, under configuration you will see an Affiliate area there as well. This is where you can make the needed changes requested such as how long to hold cookies, billing threshold amount, length of time, etc.

 

hope that helps!

Link to comment
Share on other sites

Ruby-

Thanks I hadnt noticed that. I still seem to have a problem though. When I go to

configuration-->affiliate program I get a screen which says affiliate program with a title bar saying title ---value----action across the top but nothing else displays on the page. Apparently my "options" arent showing.Something must be wrong , what that is I have no clue. Any advice??

 

Thanks!!!!

Melissa :huh:

Link to comment
Share on other sites

here are the table adjustments

 

 

INSERT INTO configuration_group VALUES (900, 'Affiliate Program', 'Options for the Affiliate Program', 50, 1);

INSERT INTO configuration VALUES ('','E-Mail Address', 'AFFILIATE_EMAIL_ADDRESS', '<[email protected]>', 'The E Mail Address for the Affiliate Program', 900, 1, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES ('','Affiliate Pay Per Sale Payment % Rate', 'AFFILIATE_PERCENT', '10.0000', 'Percentage Rate for the Affiliate Program', 900, 2, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES ('','Payment Threshold', 'AFFILIATE_THRESHOLD', '50.00', 'Payment Threshold for paying affiliates', 900, 3, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES ('','Cookie Lifetime', 'AFFILIATE_COOKIE_LIFETIME', '7200', 'How long does the click count (seconds) if customer comes back', 900, 4, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES ('','Billing Time', 'AFFILIATE_BILLING_TIME', '30', 'Orders billed must be at least "30" days old.<br>This is needed if a order is refunded', 900, 5, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES ('','Order Min Status', 'AFFILIATE_PAYMENT_ORDER_MIN_STATUS', '3', 'The status an order must have at least, to be billed', 900, 6, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES ('','Pay Affiliates with check', 'AFFILIATE_USE_CHECK', 'true', 'Pay Affiliates with check', 900, 7, NULL, now(), NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ');

INSERT INTO configuration VALUES ('','Pay Affiliates with PayPal', 'AFFILIATE_USE_PAYPAL', 'true', 'Pay Affiliates with PayPal', 900, 8, NULL, now(), NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ');

INSERT INTO configuration VALUES ('','Pay Affiliates by Bank', 'AFFILIATE_USE_BANK', 'true', 'Pay Affiliates by Bank', 900, 9, NULL, now(), NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ');

INSERT INTO configuration VALUES ('','Individual Affiliate Percentage', 'AFFILATE_INDIVIDUAL_PERCENTAGE', 'true', 'Allow per Affiliate provision', 900, 10, NULL, now(), NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ');

INSERT INTO configuration VALUES ('','Use Affiliate-tier' , 'AFFILATE_USE_TIER', 'false', 'Multilevel Affiliate provisions', 900, 11, NULL, now(), NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ');

INSERT INTO configuration VALUES ('','Number of Tierlevels', 'AFFILIATE_TIER_LEVELS', '0', 'Number of Tierlevels', 900, 12, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES ('','Percentage Rate for the Tierlevels', 'AFFILIATE_TIER_PERCENTAGE', '8.00;5.00;1.00', 'Percent Rates for the tierlevels<br>Example: 8.00;5.00;1.00', 900, 13, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES ('','Affiliate News', 'MAX_DISPLAY_AFFILIATE_NEWS', '3', 'Maximum number of items to display on the Affiliate News page', 900, 14, NULL, now(), NULL, NULL);

Link to comment
Share on other sites

Im having an airhead day...do you mean in the database or is there a file I couldve missed. I got this as part of another pkg (it upgraded the affiliate program supposedly,along with some other mods) i didnt d/l this contrib individually. Perhaps something was missed or I just messed up my whole database.UGH i hope not!

Link to comment
Share on other sites

did you add the configuration tables when you installed the mod?

Year i have the same problem, i added the configuration tables

but again i don't get a a list with affiliates who get money from me,so i can not change the status to paid

 

I guess it's something wrong with affiliate_payment.php or my tables in datebase

 

Could anyone help me? Thanks a lot,

Link to comment
Share on other sites

Hi greg and dir,

 

I found where the bug is "thank's dir for the direction to take"

 

In fact the billing is correct but in your table "affiliate_payement_statut" only english language is set.

 

In order to see your affiliate billing you have to set the language you are using in your admin and it will work here the values for french, german and italian:

 

INSERT INTO affiliate_payment_status (affiliate_payment_status_id, affiliate_language_id, affiliate_payment_status_name) VALUES("0", "2", "schwebend");

INSERT INTO affiliate_payment_status (affiliate_payment_status_id, affiliate_language_id, affiliate_payment_status_name) VALUES("1", "2", "zahlend");

INSERT INTO affiliate_payment_status (affiliate_payment_status_id, affiliate_language_id, affiliate_payment_status_name) VALUES("0", "4", "en attente");

INSERT INTO affiliate_payment_status (affiliate_payment_status_id, affiliate_language_id, affiliate_payment_status_name) VALUES("1", "4", "pay?");

INSERT INTO affiliate_payment_status (affiliate_payment_status_id, affiliate_language_id, affiliate_payment_status_name) VALUES("0", "6", "in corso");

INSERT INTO affiliate_payment_status (affiliate_payment_status_id, affiliate_language_id, affiliate_payment_status_name) VALUES("1", "6", "pagare");

 

Have fun!

Link to comment
Share on other sites

I STILL get nothing when I open my "payment" page. I just don't understand. I set my threshold to $10 and the billing time to -1 and nothing. On my summary page the one test sale i made is now gone yet i never had anything on the payment page etc. This is obviously a big problem how is it being solved?

 

MElissa

Link to comment
Share on other sites

how do you change the banner code? well actually how to you add two different types of baner codes? one for web sites and one for forum signatures?

 

<a href="http://www.arresnowboards.com/index.php?ref=1&affiliate_banner_id=2" target="_blank"><img src="http://www.arresnowboards.com/images/2848848_l.gif" border="0" alt="simple"></a>

above is the code for web sites.. but i want to have two feilds one for the above and one that looks like...

 

[url=http://www.arresnowboards.com/index.php?ref=1&affiliate_banner_id=2 target="_blank"][img=http://www.arresnowboards.com/images/2848848_l.gif][/url]

Link to comment
Share on other sites

hi,

 

this conti works great for me but i just found a hughe bug and i don't know if someone else expirienced this.

 

if a user forgets his password and uses the "password forgotten option" it send the user a password but it clears the password table in the database completely!!! this happens on my ms2.1 and ms2.2 store... anyone know what's wrong?

Link to comment
Share on other sites

Problem with edit affiliate tax_Id!

 

In Admin -> Affiliates -> Affiliates -> Edit

Im writing the affiliate Tax_Id information and press "update"

 

Then im click on "edit" again and looking to the Tax_Id field and its empty.

 

The only way for me to insert/edit info is by using the "Built in phpMyAdmin control panel"

 

Am i doing things the wrong way or is it a "bug"??

 

/Bosse

Link to comment
Share on other sites

Are there any plans to allow different commision rates on a per product basis?

 

I have some products where I want to offer 'x'% and others where the margin isn't so high and need to offer 'y'%

 

Thanks

 

Kev Polley

Link to comment
Share on other sites

A quick question...

 

If you are using gift vouchers this gift vouchers are in the list of products that an affiliate can add to his website.

 

How can I ban products from this list if I don't want the affiliate to be able to sale some product? <_<

Link to comment
Share on other sites

I really really hope that no one has asked this before.

 

I am currently using OSCAffiliate on a live store. I have quite a few affiliates and everything is working well so far.

 

I stumbled upon the thread for the old affiliate branding contrib and I really like the concept -> I can create a storefront for my affiliates that matches the color scheme and layout of their site. There may be a different subset of products shown on each affiliate storefront. Affiliates get commission when a customer purchases from their storefront.

 

I've seen a virtual mall discussion thread (more like a wishlist) and also an active Shopping Mall contrib thread, but I'm not sure if they do what I want. Does anyone have any idea which contrib(s) I should be using?

 

Please take pity on me. I'm flooded with information and have no way to sort it all out. I have no problem with installing a clean oscommerce and putting a contrib over it, as long as i can port my customer information and products over to the clean version.

Link to comment
Share on other sites

Well

 

i am taking a lok at this contribution for the first time and can't get by the Install.txt file. Boy am I green. cgi seems much easier than PHP.

 

Anyway, can someone tell me how this works or means (plain english)

 

MySQL ALTERATIONS

 

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

 

Alos, is this a banner mod or can I sell other people's products in my store (which is what i am after)

 

Sorry for being stupid. First time PHP user here.

 

mic

Link to comment
Share on other sites

You're kinding mic!?

 

If you installed oscommerce you should understand this.

 

anyway this means you have to install new table in your database...

 

PS: if you'ar looking for banner system I suggest you to install PHPadsNew that you can find in sourceforge.net

 

This mod is to create affiliate programm like amazon....

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...