Guest Posted November 13, 2006 Share Posted November 13, 2006 You excuse me for my English When the customer concludes the order I have 2 orders in admin. Is normal ? grazie mille Quote Link to comment Share on other sites More sharing options...
Guest Posted November 13, 2006 Share Posted November 13, 2006 I can help you with the Sandbox. It's pretty simple actually. You create free account at https://developer.paypal.com Then with the free account you use the sandbox tool to make your own little paypal. There you will make a business account that is exactly like your real paypal business account and a personal account to test the site with. Keep in mind all the e-mails for those fake sandbox accounts will just go to the e-mail section of your https://developer.paypal.com. To run the sandbox account for testing make sure your admin for Paypal IPN of your store is set to 'testing' and the e-mail address is the same and the fake business e-mail address in your sandbox. and that you are logged in to https://developer.paypal.com. Then it should test fine. If you have any questions feel free to PM me. Vance PS - I still also have the same problem of the status not updating from 'processing IPN' after payment, so if you (or anyone else) figure that out let me know! Quote Link to comment Share on other sites More sharing options...
chooch Posted November 14, 2006 Share Posted November 14, 2006 (edited) I uploaded a complete file package of V1.4 . http://www.oscommerce.com/community/contributions,2679 The install_guide of V1.4 is the same as V1.3. I had installed v1.3 which was simple enough to use but hadn't noticed the orders accumulating from the same customer if they returned to the store from paypal without completing the checkout. After a client I installed it for told me I was about to attempt to find a solution when I saw widfjf's 1.4 update. After a brief test of this update I noticed straight away that the multiple orders in admin issues (which was created by to-ing and fro-ing between the checkout and paypal's site while having contents still in the cart) has been resolved.... ... now adding and minusing items from the cart actually auto updates in admin/orders and there are no phantom or multiple orders - thanks for sorting that out windfjf Edited November 14, 2006 by chooch Quote Upon receiving fixes and advice, too many people don't bother to post updates informing the forum of how it went. Until of course they need help again on other issues and they come running back! Why receive the information you require in good faith for free, only to then have the attitude to ignore the people who gave it to you? There's no harm in saying, 'Thanks, it worked'. On the contrary, it creates a better atmosphere. CHOOCH Link to comment Share on other sites More sharing options...
j0s3 Posted November 14, 2006 Share Posted November 14, 2006 Hi all, i installed the paypal ipn module and in my admin/modules/payments area i get the following error: Fatal error: Cannot redeclare class paypal_ipn in ...[path.. /includes/mudules/payments/paypal ipn line 14 where the class is declared i'm very new to php so it doen't mean much to me any help is greatly appreciated thanks jose Quote Link to comment Share on other sites More sharing options...
chooch Posted November 14, 2006 Share Posted November 14, 2006 Fatal error: Cannot redeclare class paypal_ipn in ...[path.. /includes/mudules/payments/paypal ipn line 14 have you added the ext folder where it is supposed to go? Quote Upon receiving fixes and advice, too many people don't bother to post updates informing the forum of how it went. Until of course they need help again on other issues and they come running back! Why receive the information you require in good faith for free, only to then have the attitude to ignore the people who gave it to you? There's no harm in saying, 'Thanks, it worked'. On the contrary, it creates a better atmosphere. CHOOCH Link to comment Share on other sites More sharing options...
ygrouk Posted November 14, 2006 Share Posted November 14, 2006 Hi i have installed this contribution. i have no idea why but it doesnt show on the payment list. all i have is: "This is currently the only payment method available to use on this order. Credit Card" the paypal ipn doesnt even show. im am a bit worried about this. any help would be much appreciated thank you. Quote Link to comment Share on other sites More sharing options...
j0s3 Posted November 14, 2006 Share Posted November 14, 2006 have you added the ext folder where it is supposed to go? yes, te ext dir is there i noticed that one of the files (i think the one in modules/payments/... didn't have any permissions set, si i gave it the same persmissions as paypal.php still get the same error though Quote Link to comment Share on other sites More sharing options...
j0s3 Posted November 14, 2006 Share Posted November 14, 2006 i removed the files and re-uploaded them and that seems to have sorted out the issue (maybe dreamweaver didn't upload one of the files fully) thanks! jg Quote Link to comment Share on other sites More sharing options...
chooch Posted November 14, 2006 Share Posted November 14, 2006 Hi i have installed this contribution. i have no idea why but it doesnt show on the payment list. all i have is: "This is currently the only payment method available to use on this order. Credit Card" the paypal ipn doesnt even show. im am a bit worried about this. any help would be much appreciated thank you. have you been to admin/modules and payment?? have you then installed the paypal ipn or other payment modules?? Quote Upon receiving fixes and advice, too many people don't bother to post updates informing the forum of how it went. Until of course they need help again on other issues and they come running back! Why receive the information you require in good faith for free, only to then have the attitude to ignore the people who gave it to you? There's no harm in saying, 'Thanks, it worked'. On the contrary, it creates a better atmosphere. CHOOCH Link to comment Share on other sites More sharing options...
Cruelo Posted November 14, 2006 Share Posted November 14, 2006 Hello, Is what a charitable heart would be able to make a function in order to recover all the fees of paypal and being able to resortir them by ?year, month, week?. I test hopelessly of me helps of ?stats_sales_report2.php? but I cannot make! Quote Link to comment Share on other sites More sharing options...
Guest Posted November 14, 2006 Share Posted November 14, 2006 I'm still working on this Zero price being sent to PayPal for a customer. What I have found is that the IPN script is looking for the value in orders_products final_price which is sends off to PayPal. Fair enough. The database here has stopped writing to that field a long time ago - - I'm wondering if I can just substitue orders_totals final_price as that value is still being written?? If anybody can comment on that fo rme I'll go looking and see what contribution may have killed off the value (or is there a setting in Admin??) Graeme Quote Link to comment Share on other sites More sharing options...
Guest Posted November 15, 2006 Share Posted November 15, 2006 I'm still working on this Zero price being sent to PayPal for a customer.What I have found is that the IPN script is looking for the value in orders_products final_price which is sends off to PayPal. Wrong again - that field gets updated AFTER a checkout is completed e.g. if I buy by cheque then it works. So that's not my problem Graeme Quote Link to comment Share on other sites More sharing options...
Guest Posted November 15, 2006 Share Posted November 15, 2006 (edited) Hello, Is what a charitable heart would be able to make a function in order to recover all the fees of paypal and being able to resortir them by ?year, month, week?. I test hopelessly of me helps of ?stats_sales_report2.php? but I cannot make! very easy to do: in a new browser window, type: paypal.com, and login :-) then click on the tab "my account" then the link "history", then - in the left navigation "Download my History" you will then download a tab/delimited file with all paypal data, including the fees. Having this in Oscommerce would be liek reinventing the wheel to me ... Edited November 15, 2006 by pixclinic Quote Link to comment Share on other sites More sharing options...
nudylady Posted November 15, 2006 Share Posted November 15, 2006 It stoped sending order confirmation emails I installed ot_discount_coupon_codes_2.1 Change catalog/checkout_process.php as this line 166 after $sql_data_array = array('orders_id' => $insert_id, 'orders_status_id' => $order->info['order_status'], 'date_added' => 'now()', 'customer_notified' => $customer_notification, 'comments' => $order->info['comments']); tep_db_perform(TABLE_ORDERS_STATUS_HISTORY, $sql_data_array); add //kgt - discount coupons if( tep_session_is_registered( 'coupon' ) && $order->info['coupon'] != '' ) { $sql_data_array = array( 'coupons_id' => $order->info['coupon'], 'orders_id' => $insert_id ); tep_db_perform( TABLE_DISCOUNT_COUPONS_TO_ORDERS, $sql_data_array ); } //end kgt - discount coupons line 276 after // unregister session variables used during checkout tep_session_unregister('sendto'); tep_session_unregister('billto'); tep_session_unregister('shipping'); tep_session_unregister('payment'); tep_session_unregister('comments'); add //kgt - discount coupons tep_session_unregister('coupon'); //end kgt - discount coupons Quote Link to comment Share on other sites More sharing options...
chooch Posted November 16, 2006 Share Posted November 16, 2006 (edited) It stoped sending order confirmation emails my understanding is that your store will only send the order confirmation emails once checkout process>>success is achieved. So, even though order is updated to default status in admin via the IPN and the paypal emails are sent to the sender/receiver from paypal - the order email to the customer isn't. Edited November 16, 2006 by chooch Quote Upon receiving fixes and advice, too many people don't bother to post updates informing the forum of how it went. Until of course they need help again on other issues and they come running back! Why receive the information you require in good faith for free, only to then have the attitude to ignore the people who gave it to you? There's no harm in saying, 'Thanks, it worked'. On the contrary, it creates a better atmosphere. CHOOCH Link to comment Share on other sites More sharing options...
nudylady Posted November 16, 2006 Share Posted November 16, 2006 my understanding is that your store will only send the order confirmation emails once checkout process>>success is achieved. So, even though order is updated to default status in admin via the IPN and the paypal emails are sent to the sender/receiver from paypal - the order email to the customer isn't. thank you for your help. before it send order emails. now it totally stoped. and also my stock level does not subtract anymore. what files should I look at? Quote Link to comment Share on other sites More sharing options...
chooch Posted November 16, 2006 Share Posted November 16, 2006 (edited) thank you for your help.before it send order emails. now it totally stoped. and also my stock level does not subtract anymore. what files should I look at? i don't know what stock level contributions you have added to your store? for peace of mind, use paypal (not ipn) to make a test transaction and keep an eye on your stock levels to see if they reduce per transaction first, then post back here. Edited November 16, 2006 by chooch Quote Upon receiving fixes and advice, too many people don't bother to post updates informing the forum of how it went. Until of course they need help again on other issues and they come running back! Why receive the information you require in good faith for free, only to then have the attitude to ignore the people who gave it to you? There's no harm in saying, 'Thanks, it worked'. On the contrary, it creates a better atmosphere. CHOOCH Link to comment Share on other sites More sharing options...
Besnell Posted November 16, 2006 Share Posted November 16, 2006 I'm still working on this Zero price being sent to PayPal for a customer.What I have found is that the IPN script is looking for the value in orders_products final_price which is sends off to PayPal. I am currently working on my first oscommerce install. I am currently using the paypal_ipn module. I am also currently running into this exact same issue. When my customer gets redirected to paypal there is one item which is being "purchased" for a total of $0. It makes me glad to hear that I am not the very first person to run into this issue. As a result I am curious to know if you have come across a resolution or if anyone else has for that matter. Quote Link to comment Share on other sites More sharing options...
olsonsp4c Posted November 16, 2006 Share Posted November 16, 2006 (edited) Hello, I'm getting an error and I'm just plain stumped... any ideas? 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 'where date_format(store_history_date, '%Y%m%d') = date_format( update store_history set amount_orders = amount_orders + 1, amount_products = amount_products+1, orders_price=orders_price+ where date_format(store_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') [TEP STOP] Thanks! Scott Edited November 16, 2006 by olsonsp4c Quote Addons I've crafted: osC reCaptcha | Live Support phpOnline | Store Mode | Simple Categories Header | Authorize.Net Infobox Package Tracking Plus | USPS Flat Rate Shipping | USPS Shipping Insurance | RapidSSL Infobox Link to comment Share on other sites More sharing options...
pingpongrob Posted November 16, 2006 Share Posted November 16, 2006 Hi All. I have just installed the new release of the Paypal ipn module "osCommerce_PayPal_IPN_v1.4" have this problem, when you click to pay with paypal the cart amount is not transferred to paypal, its just $0. Has anyone a solution to this please. :'( Quote Link to comment Share on other sites More sharing options...
pingpongrob Posted November 16, 2006 Share Posted November 16, 2006 Hi All. I have just installed the new release of the Paypal ipn module "osCommerce_PayPal_IPN_v1.4" have this problem, when you click to pay with paypal the cart amount is not transferred to paypal, its just $0. Has anyone a solution to this please. :'( Quote Link to comment Share on other sites More sharing options...
pingpongrob Posted November 16, 2006 Share Posted November 16, 2006 Hi All. I have just installed the new release of the Paypal ipn module "osCommerce_PayPal_IPN_v1.4" have this problem, when you click to pay with paypal the cart amount is not transferred to paypal, its just $0. Has anyone a solution to this please. :'( Quote Link to comment Share on other sites More sharing options...
chooch Posted November 16, 2006 Share Posted November 16, 2006 Hello, I'm getting an error and I'm just plain stumped... any ideas? 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 'where date_format(store_history_date, '%Y%m%d') = date_format( update store_history set amount_orders = amount_orders + 1, amount_products = amount_products+1, orders_price=orders_price+ where date_format(store_history_date, '%Y%m%d') = date_format(now(), '%Y%m%d') [TEP STOP] Thanks! Scott I can't see what that has to do with paypal IPN? What other contributions did you add around the same time as IPN? Quote Upon receiving fixes and advice, too many people don't bother to post updates informing the forum of how it went. Until of course they need help again on other issues and they come running back! Why receive the information you require in good faith for free, only to then have the attitude to ignore the people who gave it to you? There's no harm in saying, 'Thanks, it worked'. On the contrary, it creates a better atmosphere. CHOOCH Link to comment Share on other sites More sharing options...
olsonsp4c Posted November 16, 2006 Share Posted November 16, 2006 (edited) I can't see what that has to do with paypal IPN? What other contributions did you add around the same time as IPN? I added QTPro and then Time Zone adjuster; however, then I completely removed the Time Zone adjuster. I though it might be the Time Zone adjuster, but since I removed it, it doesn't seem likely. Also, this (the error) happens after paypal payment is completed and then it is autoreturning back to checkout_process.php... However, it ONLY happens when customers pay with Paypal, not by cash or check/money order. thanks! Scott Edited November 16, 2006 by olsonsp4c Quote Addons I've crafted: osC reCaptcha | Live Support phpOnline | Store Mode | Simple Categories Header | Authorize.Net Infobox Package Tracking Plus | USPS Flat Rate Shipping | USPS Shipping Insurance | RapidSSL Infobox Link to comment Share on other sites More sharing options...
chooch Posted November 16, 2006 Share Posted November 16, 2006 I added QTPro and then Time Zone adjuster; however, then I completely removed the Time Zone adjuster. I though it might be the Time Zone adjuster, but since I removed it, it doesn't seem likely. Also, this (the error) happens after paypal payment is completed and then it is autoreturning back to checkout_process.php... However, it ONLY happens when customers pay with Paypal, not by cash or check/money order. thanks! Scott and everything was working fine before then? Quote Upon receiving fixes and advice, too many people don't bother to post updates informing the forum of how it went. Until of course they need help again on other issues and they come running back! Why receive the information you require in good faith for free, only to then have the attitude to ignore the people who gave it to you? There's no harm in saying, 'Thanks, it worked'. On the contrary, it creates a better atmosphere. CHOOCH 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.