Jump to content

acartright

Members
  • Content count

    9
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    ac
  • Gender
    Male
  1. acartright

    PayPal_Shopping_Cart_IPN

    Greg, THANK YOU VERY MUCH! Somehow I didn't upload the catalog\ipn.php to my server. Must have been more of that wonderful late night mind mush. Back to testing, improving images (thumb nails), and so much more. Once again, thank you. Allen
  2. acartright

    PayPal_Shopping_Cart_IPN

    Greg, Yes, my paypal_ipn table remains empty. I've cleaned out all orders from the system then initiated a single order paying by paypal. I see the order but no entries in the paypal_ipn table. Debugging is set at 2. Here is a list of the emails I receive: 1) Debug (contents previously submitted) 2) Verified 3) Email Config 4) Web Accept Then I go into PayPal and accept the payment. From here the series of emails repeat. The only difference is in the debug email where the payment status is trying to be updated to complete. I've obviously missed something late last night. Sorry to be a pain. I'm going back thru the install steps to try to validate I haven't missed a step. S, @
  3. acartright

    PayPal_Shopping_Cart_IPN

    Greg, A little more information. The failed address verification at this point is intentional. The debug I included was from the original payment submission. I receive a similar debug (web_accept) after I go into PayPal and accept the payment. But never see any updates inside osCommerce. In fact, if I look at the contents of the paypal_ipn and paypal_orders tables from within phpMyAdmin I never see any entries (not from the original order nor from the subsequent web accept). S, @
  4. acartright

    PayPal_Shopping_Cart_IPN

    Greg, Awake and refreshed. I'm sorry, I shouldn't have written last night. You are right in that the problem was in the catalog/includes/database_tables.php. I did a cut and paste from your very nicely assembled (PayPal_Shopping_Cart_IPN.html) directions. After reviewing today with a fresh set of eyes I noticed an extra space in the declare before 'orders_session_info'. Once I removed it everything started functioning. Time to test. catalog/includes/database_tables.php From the PayPal_Shopping_Cart_IPN.html directions: As updated: FYI, I am now seeing the same error as 35thSLP in that I never get a payment confirmation back into my cart (PayPal_IPN table). I need to look at it more. I'm attaching the a one of my debugs for review. Fields modified to protect data are enclosed in single quotes. These fields matched exactly with the exception of the email fields that had %40 substituted for the @ symcol. The only real difference that I see is PayPal is converting characters (space, @, :, etc) in the 'PayPal Reconstructed Post' response. Thanks for your help and hardwork. Allen
  5. acartright

    PayPal_Shopping_Cart_IPN

    Greg, Just installed 2.0 on my MS2 cart. GREAT DOCS!!! I have run into one problem. When I add something to the cart and go thru the checkout process I get the following error when 'checkout_process.php' prepares to run me over to PayPal: On the surface this looks like I simply missed that table when I ran the sql. I've checked thru PHPmyAdmin and the table does exist and appears to be fine. If you have any ideas they would be greatly appreciated. Forgive me if I've pulled the trigger too early. It is rather late and the code is starting to run together. Thanks again. Allen
  6. acartright

    PayPal_Shopping_Cart_IPN

    Greg, Thank you for all the hard work you have put into this contribution. I've run into a couple of problems that appear to be lockstep with part of the conversations that you and Patrick are having. Any advice you can offer would be greatly appreciated: SCENARIO 1: Configuration: System: osCommerce: MS2 PayPal IPN: 1.7 Other Mods: UPSXML, UPSXML Tracking (these mods aren't being used during the test) PayPal setup: IPN - On (no address) Auto Return - Off Prompt for unverified addess OsCommerce PayPal set up: Include Note - No Shopping Cart Method - Itemized Enable PayPal Shipping Address - False (want the user to use the osCommerce address book) PayPal Auto-Return - No Email Notifications - 1 Test Mode - Off (tried with it turned on too) Notification Address - an independent address Return URL Behavior - Post Test: Run a purchase of an item ($.01) using an unverified address and flat rate shipping of $0.00. Results/Problem: Transaction initially processes properly. Order shows up in Admin/Customers/Orders with notes that the order is pending due to address verification. Admin/Customers/IPN notes the order pending due to address verification. The problem comes in when I log into PayPal and approve the payment. I get an email (as the purchaser) that the payment has been accepted. Unfortunately nothing else happens in IPN. It never updates. I can live with this but if order volume picks up it could present a problem. SCENARIO 2: Configuration: System: osCommerce: MS2 PayPal IPN: 1.7 Other Mods: UPSXML, UPSXML Tracking (these mods aren't being used during the test) PayPal setup: IPN - On (no address) Auto Return - On Auto Return Address - (the secure url to my success page) Prompt for unverified addess OsCommerce PayPal set up: Include Note - No Shopping Cart Method - Itemized Enable PayPal Shipping Address - False (want the user to use the osCommerce address book) PayPal Auto-Return - Yes Email Notifications - 1 Test Mode - Off (tried with it turned on too) Notification Address - an independent address Return URL Behavior - Post Test: Run a purchase of an item ($.01) using an unverified address and flat rate shipping of $0.00. Results/Problem: Transaction returns to the success screen. Nothing shows up under Admin/Customers/Orders. This bothers me because I don't have anything inside the store that acknowledges that a purchase has been made and needs attention in PayPal. Once I go to PayPal and accept the payment I receive the notification emails and entries show up in Admin/Customers/Orders - Admin/Customers/PayPal IPN but they are all missing the purchaser information and item(s) purchased. GENERAL COMMENTS: If possible I would prefer to not use PayPals autoreturn feature. With it turned off the user is promptly returned the success page without ever seeing the PayPal redirect page. Also, I really like having the order show up in osC admin with comments as to why the order is pending. That way I have a single point to start with when processing orders. Once again, thank you for the contribution and any assistance you can offer. Sincerely, Allen
  7. acartright

    UPSXLM Mod Request

    Hello all, I have been able to successfully install UPSXML 1.01 on my 2.2MS2 website. Took a little playing around but everything seems to be working very well and we are very happy with it. Thank you to all who have put so much time in creating it. So far in my testing it has worked perfectly every test. Pretty good given each of our products will ship OS1 or OS2 boxes. I did notice 2 things that would be nice if it could be included. 1) Add the option to allowing a handling charge for each item ordered rather than one fee for the total order. Given our items are large it would be nice to charge for packing each item individually. 2) It would be FANTASTIC if the module provided the ability to print UPS shipping labels. Right now I either have to go to the UPS or PayPal website. Both require me to input all of information for the transaction. Sorta seems silly when all the information is right there in my OSCommerce system. Thanks
×