jusmelmay Posted January 22, 2004 Share Posted January 22, 2004 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 ;) Quote Link to comment Share on other sites More sharing options...
Guest Posted January 23, 2004 Share Posted January 23, 2004 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? <_< Quote Link to comment Share on other sites More sharing options...
rubygirl Posted January 23, 2004 Share Posted January 23, 2004 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! Quote Link to comment Share on other sites More sharing options...
jusmelmay Posted January 23, 2004 Share Posted January 23, 2004 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: Quote Link to comment Share on other sites More sharing options...
rubygirl Posted January 23, 2004 Share Posted January 23, 2004 did you add the configuration tables when you installed the mod? Quote Link to comment Share on other sites More sharing options...
rubygirl Posted January 23, 2004 Share Posted January 23, 2004 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); Quote Link to comment Share on other sites More sharing options...
jusmelmay Posted January 23, 2004 Share Posted January 23, 2004 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! Quote Link to comment Share on other sites More sharing options...
dir Posted January 25, 2004 Share Posted January 25, 2004 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, Quote Link to comment Share on other sites More sharing options...
Guest Posted January 25, 2004 Share Posted January 25, 2004 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! Quote Link to comment Share on other sites More sharing options...
Guest Posted January 25, 2004 Share Posted January 25, 2004 PS: check your language ID! it might be different than mine... Quote Link to comment Share on other sites More sharing options...
dir Posted January 25, 2004 Share Posted January 25, 2004 thanks a lot. start billing problerm is solved. thanks Quote Link to comment Share on other sites More sharing options...
jusmelmay Posted January 25, 2004 Share Posted January 25, 2004 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted January 25, 2004 Share Posted January 25, 2004 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] Quote Link to comment Share on other sites More sharing options...
selcuk Posted January 28, 2004 Share Posted January 28, 2004 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? Quote Link to comment Share on other sites More sharing options...
selcuk Posted January 28, 2004 Share Posted January 28, 2004 ...and it's not the "$crypted_password = tep_encrypt_password($newpass);" problem. :( Quote Link to comment Share on other sites More sharing options...
selcuk Posted January 28, 2004 Share Posted January 28, 2004 ok i actually fixed the problem ;) another question, i see all settings in the config menue for affiliate twice?! is that because i use two languages? Quote Link to comment Share on other sites More sharing options...
jusmelmay Posted January 28, 2004 Share Posted January 28, 2004 I dont want to be a nusiance but has anyone figured out the solution to this payment page thing!?? thanks!! Melissa Quote Link to comment Share on other sites More sharing options...
helohelo Posted January 29, 2004 Share Posted January 29, 2004 hello, I have a very rooky question. How to modifie the tekst in affiliate info faq's etc. I cannot find this in admin, or should i modifie the php fiel itself? Quote Keesjan Link to comment Share on other sites More sharing options...
Guest Posted January 29, 2004 Share Posted January 29, 2004 selcuk, Probably because you uploaded twice your sql table.... Quote Link to comment Share on other sites More sharing options...
Guest Posted January 31, 2004 Share Posted January 31, 2004 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 Quote Link to comment Share on other sites More sharing options...
kdp Posted February 2, 2004 Share Posted February 2, 2004 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted February 3, 2004 Share Posted February 3, 2004 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? <_< Quote Link to comment Share on other sites More sharing options...
MickiCheers Posted February 4, 2004 Share Posted February 4, 2004 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. Quote Link to comment Share on other sites More sharing options...
Guest Posted February 4, 2004 Share Posted February 4, 2004 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted February 5, 2004 Share Posted February 5, 2004 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.... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.