Jump to content

stevennickelby

Members
  • Content count

    165
  • Joined

  • Last visited

1 Follower

Profile Information

  1. stevennickelby

    OSC-Affiliate

    Uh huh! I think I can answer my own question...the date on the affiliate commission sales need to be at least 30 days old (as a minimum) in order for the billing to work. I wonder is that such a good idea (to make them wait for 30 days)?
  2. stevennickelby

    OSC-Affiliate

    Hope all is well, I'm baffled.... Everything on the affiliate module works except the affiliate payments side. I don't understand how the affiliate member can request a payment....there are no buttons? Also the payment report has no figures...it's not working....does it actually work? or is it incomplete and so it is up to us the ones that use the module to fix that up our selves or is there a solution that someone has done to make this side of the module work? I've insatlled 2.5a Osc affiliate Apart from that the comissions, links and every other aspect are sound Any information or help would be really appreciated Please :'(
  3. stevennickelby

    Official PayPal IPN Support Thread

    Hello all, I've installed the Variable Product Commission http://www.oscommerce.com/community/contri...ducts+Commision It allows you to group your products and use different %s form affiliates.... It works fine with all the other payment modules but for some reason with Paypal IPN it comes up with the following... Fatal error: Call to a member function on a non-object in D:\Apache2\webroot\oscommerce\catalog\includes\affiliate_checkout_process.php on line 34 on the checkout_confirmation.php page...i'm stumped! and have no idea what to do, i've looking everywhere on the internet for what it might mean but still don't know how to fix this. affiliate_checkout_process.php on line 34 // LE commision script on - BR $affiliate_payment = tep_round(($cart->le_commission()), 2); // LE commision script off - BR I'm desperate to find out(it's driving me nuts!)...please help This is the paypal_ipn.php This is the Shopping cart
  4. stevennickelby

    OSC-Affiliate

    Oh ok thank you...once again I've just tried, the Variable_Product_Commision (added 25 Apr 2006)- http://www.oscommerce.com/community/contributions,1580/category,all/search,affiliate+product when the customer picks paypal(which is the ipn module) the following error comes up Fatal error: Call to a member function on a non-object in Apache2\webroot\oscommerce\catalog\includes\affiliate_checkout_process.php on line 34 on the checkout_confirmation.php page, so i took a look at the line in that file... // LE commision script on - BR $affiliate_payment = tep_round(($cart->le_commission()), 2); // LE commision script off - BR:huh: it's only is a problem when the customer pays by paypal(ipn) Is there a fix for it? The Variable_Product_Commision module with (corrections file) only alters and adds to the affiliate_checkout_process.php and shopping_cart.php, yet the Fatal doesn't show if the customer selcets another payment module (like Check/Money Order for instance).... I gather something needs to be added to paypal_ipn.php even if someone could can tell me what it meant by "non-object"...that would help!
  5. stevennickelby

    OSC-Affiliate

    Hello there, I now have Oscommerce Affiliate working!...wooo hooo! 2.5a seems to work fine...there is a bug I have found, I'm using "Paypal IPN" module (version 1.2) and have added the fix in "paypal_ipn.php" I have found that if a customer clicks on the confirm button (on the checkout confirmation page), then once the paypal page loads up, presses the BACK button in their browser(they will be sent back to the checkout_confirmation.php page) It generates a duplicate affiliate entry in affiliate sales. Here is what the affiliate member will see in the affiliate sales section. 09/03/2006 $100.00 10.00 % $10.00 Deleted (Admin) 09/03/2006 $100.00 10.00 % $10.00 Pending Here is what I see in the admin side in affiliate sales.php 09/03/2006 0 $58.90 10.00% $5.89 Deleted (Admin) 09/03/2006 220 $58.90 10.00% $5.89 Pending 220 is the invoice number. How do you stop in this situation a duplicate? the other thing is once that entry has happend in tables "affiliate_sales", if the customer does it again or - maybe by a another customer then on the checkout_confirmation.php it comes up wih a MYSQL error on the page which says... How do you fix it? :o ...thanks if you can help
  6. stevennickelby

    OSC-Affiliate

    Thanks for that...terriffic!, I'll try 2.5a. I'm currrently using the PayPal IPN module, but at this stage the site is only in english... do you know the link to the fix?... if not I'll search for the fix anyway and take a look. Thanks again for your help...sometimes it can be hard to get a response Cheers! :lol:
  7. stevennickelby

    OSC-Affiliate

    Hello I have installed the contribution OSC Affiliate 2.6 28 Jul 2006 and I have found that the.... Conversion: 0% Sales Amount: $0.00 Clickthrough Rate: $0.00 Commission: $0.00 Pay Per Sale Rate: $0.00 Sales Average: $0.00 stay the same.... the only thing that updates are the "Visits:" Is 2.6 a dudd? Can you guys let me know which of the contributions work? I'm really down at the moment because I put alot of elbow work into the contribution to make it look nice (without seeing that it works first) :( The other question I have is when a customer purchases through paypal, is the affiliate meant to generate the commission...when the customer presses the "confirm order" button(which takes him/her to paypal for payment)....or when the checkout_success appears (after the order has been payed for) and paypal sends the customer back to the website? Thanks for help :)
  8. stevennickelby

    help with syntax error

    I'm getting the following error 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''affiliate_affiliate where affiliate_email_address = ''' at line select customers_id, customers_firstname, customers_lastname, customers_password, customers_email_address, customers_default_address_id, affiliate_id, affiliate_firstname, affiliate_password, affiliate_email_address from customers where customers_email_address = 'affiliate_affiliate where affiliate_email_address = '' [TEP STOP] the script that it realtes to is... $check_customer_query = tep_db_query("select customers_id, customers_firstname, customers_lastname, customers_password, customers_email_address, customers_default_address_id, affiliate_id, affiliate_firstname, affiliate_password, affiliate_email_address from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . TABLE_AFFILIATE . " where affiliate_email_address = '" . tep_db_input($email_address) . "'"); if (!tep_db_num_rows($check_customer_query)) { $error = true; } else { $check_customer = tep_db_fetch_array($check_customer_query); can customers_email_address, and affiliate_email_address be used for ($email_address) ???
  9. stevennickelby

    Having slighte syntax error with writing this simple php

    The red script sorts the products by the furthest in the future first, Instead i would like the script to sort by the the least furthest in the future first (not the furthest). I think this script can do that, but i don't know where to place him? pd where to_days(products_date_available) >= to_days(now()) I tried placing just after TABLE_PRODUCTS_TO_CATEGORIES . " but i came up with an error, I'm not to sure how to put this into the script??
  10. sorry about the mispelling of slight. hello everyone, for this part of query script $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . $new_products_category_id . "' and p.products_status = '1' order by p.products_date_available desc limit " . MAX_DISPLAY_NEW_PRODUCTS); I've been trying to add this in... pd where to_days(products_date_available) >= to_days(now()) but I keep getting syntax errors... how can it fit in to the top script? (idealy i want p.products_date_available desc limit to be p.products_date_available asc limit and have pd where to_days(products_date_available) >= to_days(now()) in there so it takes the earliest dates only from today's date onwards similar to the script below.... can someone help me?thanks for yor time! $upcoming_products_query = tep_db_query(" select p.products_id, pd.products_name, products_date_available as date_expected from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = ' " . (int)$languages_id . " ' order by " . EXPECTED_PRODUCTS_FIELD . " asc limit " . MAX_DISPLAY_UPCOMING_PRODUCTS);
  11. stevennickelby

    Easy Populate 3.0 problem

    use 2.76 i think it is, that one works
  12. stevennickelby

    Affiliate SignUp error

    register globals is off.... http://forums.oscommerce.com/index.php?sho...975&st=1760
  13. stevennickelby

    OSC-Affiliate

    WHEN AFFILITE SIGNS UP I tested it with register globals on and found that, If a customer fills out the form but he forgets to fill in an email address for example all the other information he had enterd will be saved in the form Including the password. but when register globals is off the password is not saved at all!. Secondly the form won't process with register globals off. Does anyone know of a work around register globals for this contribution? Come on guys, there are some experts out there please shed some light on this dead soil. :)
  14. stevennickelby

    OSC-Affiliate

    hello!, I've installed the oscAffiliate 2.5a in testing it out, Customers can't create an affiliate account. After a customer fills out the form... then when they click on the Continue Button.... the same page reloads but nothing else??? Is this a common problem with the contribution, so is there an easy way to fix this up?, and is anyone having a similar problem. please help if you can, thanks! :blink: >_< :(
  15. Does anyone know how to install "gd lib" on a windows server. A dummies guide, I'm not very bright! :huh:
×