Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.


  • Content count

  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
  1. slofly

    [Contribution]Paypal IPN - Devosc

    Customer already has a credit card set up with Pay-Pal, but it's automatically taking him to the add credit card to your Pay-Pal account to complete payment, and even if he adds a credit card it says this credit card already registered to his Pay-Pal account. Please advise what should be done?
  2. slofly

    [Contribution]Paypal IPN - Devosc

    maybe the code from the product image 'click here for larger image' code will allow you to pop it up. That code is in product_info.php :)
  3. slofly

    free shipping has a glitch

    maybe it is based on tax? The error could be calculating it before or after tax
  4. slofly

    [Contribution]Paypal IPN - Devosc

    Alright got it to work under specific settings. If you get 'On Hold' sometimes or have some cart errors try these settings: In admin payment module for paypal: Aggregate cart not itemized In paypal under profile: Make sure no tax setting are in Do not have auto return on or with a url in it Do not have ipn turned on or have a url in it It does not work right when itemized cart is set. Paypal adds the shipping values if any are set Paypal ignores the tax sent by osc. Does anyone else have this problem?
  5. slofly

    [Contribution]Paypal IPN - Devosc

    Paypal appears to not adding right! We know computers add correctly so what is going on? Here it is right from paypal- Amount: $0.10 USD Shipping & Handling: $0.01 USD Total Amount: $0.12 USD What the heck? That is why I am getting 'on hold' The ipn is working perfect. When you get to paypal the first total is right then then after you login you get a total that is off by a penny???
  6. slofly

    [Contribution]Paypal IPN - Devosc

    Why can't we edit our posts after a few minutes? There is an error in the post above: Delete the line above with 'orders_status' If you did it already execute this SQL: INSERT INTO `orders_status` VALUES (1, 1, 'Pending'); INSERT INTO `orders_status` VALUES (2, 1, 'Processing'); INSERT INTO `orders_status` VALUES (3, 1, 'Delivered'); INSERT INTO `orders_status` VALUES (4, 1, 'On Hold'); INSERT INTO `orders_status` VALUES (5, 1, 'Refunded'); INSERT INTO `orders_status` VALUES (6, 1, 'Canceled');
  7. slofly

    [Contribution]Paypal IPN - Devosc

    If you are debugging your IPN and need to look at tables, orders in admin and orders in paypal cleaning up the info from previous transactions can be helpful. To clear all of your order history but not the customers execute this SQL: truncate customers_basket; truncate customers_basket_attributes; truncate orders_products; truncate orders_products_attributes; truncate orders_products_download; truncate orders_session_info; truncate orders_status; truncate orders_status_history; truncate orders_total; truncate paypal; truncate paypal_payment_status_history; This does not clear your paypal settings they are stored in the configuration table. And it does not interfere with your ipn installation because that is files besides the config table. If I am wrong anywhere here pls correct!
  8. slofly

    [Contribution]Paypal IPN - Devosc

    ok I cleared a bunch of tables if you want me to make a list just say and I'll post. In admin paypal was set to no synchronize invoice number. A small order gets put on hold and is off by a penny or so what to do?
  9. slofly

    [Contribution]Paypal IPN - Devosc

    Which tables are cleared to get a fresh start on testing orders, looking at paypal tables etc...? If I just clear the orders paypal will say the invoice # has already been used. Without turning off the option to have paypals invoice #'s match the osc invoice #'s how would this be resolved?
  10. slofly

    [Contribution]Paypal IPN - Devosc

    Is there a way to search just this thread for 'wrong order total' Problem: Some items/groups of items give the wrong total when viewing the 'on hold' order in the admin section. Need to get the total right and for it to go into processing so that the inventory is removed when they order.
  11. slofly

    [Contribution]Paypal IPN - Devosc

    IPN DEBUG GUIDE GET YOUR DATABASE TABLES SETUP RIGHT I chatted with Greg and he said your 'orders_status' table should have this orders_status_id, language_id, orders_status_name 1 1 Pending 2 1 Processing 3 1 Delivered 4 1 On Hold 5 1 Refunded 6 1 Canceled GET YOUR PAYMENT MODULE SETUP RIGHT In admin under module, payment, paypal Enable PayPal Module True E-Mail Address your primary paypal email Business ID your primary paypal email Default Currency USD Transaction Currency Only USD Payment Zone --none-- Set Pending Notification Status Pending Set Order Status Processing Set On Hold Order Status On Hold Set Refunded Order Status Refunded Set Canceled Order Status Canceled Synchronize Invoice True Sort order of display. 0 Background Color White Processing logo oscommerce.gif Store logo PayPal Page Style Name default Include a note with payment No Shopping Cart Method Aggregate Enable PayPal Shipping Address No Digest Key PayPal_Shopping_Cart_IPN Test Mode Off Cart Test On Debug Email Notifications Yes Debug Email Notification Address your email PayPal Domain www.paypal.com Return URL behavior 1 PROBLEM: It says pending when a payment is made when it should say processing. Inventory is not removed. SOLUTION: After you update the DB with 'On Hold' you may see that the order is going 'On Hold' I am having this problem when ordering around 6 or more items. Any help? Greg? :)
  12. slofly

    PayPal IPN

    I'm working on the same problem. When you get a payment do the items show up in Paypal? Do you go to osc admin panel to pull up an invoice? Do you have 'On hold' set as an option?
  13. slofly

    Fancier Invoice & Packingslip v1.0

    Does this contribution allow you to pull up an invoice by invoice number? With the paypal IPN all I get is the customer name and invoice number. The customer could put a diferent name in OSC than paypal and I would not be able to find the invoice with the customer name alone. Is this the basic flow for an order? Order placed, email comes from paypal and osc owner, owner looks up name in orders, print invoice??
  14. slofly

    [Contribution]Paypal IPN - Devosc

    $contents[] = array('text' => '<a href="' . tep_href_link(FILENAME_CUSTOMERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CUSTOMERS_CUSTOMERS . '</a><br>' . '<a href="' . tep_href_link(FILENAME_ORDERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_CUSTOMERS_ORDERS . '</a><br>'. '<a href="' . tep_href_link(FILENAME_PAYPAL, '', 'NONSSL') . '" class="menuBoxContentLink">'. BOX_CUSTOMERS_PAYPAL .'</a>'; // should the ; above be a . ? tep_admin_files_boxes(FILENAME_CUSTOMERS, BOX_CUSTOMERS_CUSTOMERS) . tep_admin_files_boxes(FILENAME_ORDERS, BOX_CUSTOMERS_ORDERS)); //Admin end } What are we trying to make the array 'text' equal? All those lines combined together in one string?
  15. slofly

    [Contribution]Paypal IPN - Devosc

    Try adding // before these lines- BOX_CUSTOMERS_CUSTOMERS . '</a><br>' . The // makes php ignore the lines.