tctcfavors Posted March 14, 2007 Share Posted March 14, 2007 Hi, I can't for the life of me figure out who to contact about this. I am having a few problems with my orders. Here is the problem: When I log into my oscommerce admin area it says that I have orders pending... I have recieved notifications of payment from paypal, but when I click on the orders, it says 0 orders pending! I tried to do a test order and the same thing happened... It says that my order has been confirmed (as the customer), a notification of payment is sent by paypal, it shows that I have a pending order, but the order is not emailed to me and it soes not show up when I click to view orders. I really have no idea what to do about this and I can't seem to find help. If anyone knows what to do or who to contact, could you please contact me at tctcfavors@usa.net . Thank you all so much in advance... this is really doing some damage to my business. Thank you! Link to comment Share on other sites More sharing options...
justsmitten Posted March 14, 2007 Share Posted March 14, 2007 well i have the same problem. payment goes thru just fine thru 2checkout.com, but they do not show in oscommerce AT ALL. arrggh... Link to comment Share on other sites More sharing options...
tctcfavors Posted March 14, 2007 Author Share Posted March 14, 2007 well i have the same problem. payment goes thru just fine thru 2checkout.com, but they do not show in oscommerce AT ALL. arrggh... I don't know what to do... Without it showing up in oscommerce, I don't even have their email address to notify the customers! Thank you! Link to comment Share on other sites More sharing options...
justsmitten Posted March 14, 2007 Share Posted March 14, 2007 Hmmm well if everything goes to 2CO ok, and payment is rec'd fine, 2CO has their name, email, addy, everything. All it doesn't have is the product(s) ordered (which a 2CO rep said they wouldn't, b/c oscommerce is a 3rd party cart, etc etc). All I want is my real orders, and test orders, to show in oscommerce. Link to comment Share on other sites More sharing options...
justsmitten Posted March 14, 2007 Share Posted March 14, 2007 Hmmm well if everything goes to 2CO ok, and payment is rec'd fine, 2CO has their name, email, addy, everything. All it doesn't have is the product(s) ordered (which a 2CO rep said they wouldn't, b/c oscommerce is a 3rd party cart, etc etc). All I want is my real orders, and test orders, to show in oscommerce. Link to comment Share on other sites More sharing options...
OldTimeSchool Posted March 14, 2007 Share Posted March 14, 2007 Hmmm well if everything goes to 2CO ok, and payment is rec'd fine, 2CO has their name, email, addy, everything. All it doesn't have is the product(s) ordered (which a 2CO rep said they wouldn't, b/c oscommerce is a 3rd party cart, etc etc). All I want is my real orders, and test orders, to show in oscommerce. If it's any comfort, I'm having the same issue. Payment received (for me it's eWay) ... no details in osCommerce. I do see Pending Orders 1 in the Main Admin. Console ... and sometimes (not sure under what circumstances) a row in the orders list where I can see only Customer Name and Amount ... but often not... and when I do I see no Edit or Invoice buttons. I have looked into mySQL with phpMySQL and the data seems to be all there ?!??! - so I can see who ordered what etc etc. In an attempt to solve this I've installed 2 oder list contributions ... Still no further. Investigation goes on ... Roger Link to comment Share on other sites More sharing options...
tctcfavors Posted March 14, 2007 Author Share Posted March 14, 2007 If it's any comfort, I'm having the same issue.Payment received (for me it's eWay) ... no details in osCommerce. I do see Pending Orders 1 in the Main Admin. Console ... and sometimes (not sure under what circumstances) a row in the orders list where I can see only Customer Name and Amount ... but often not... and when I do I see no Edit or Invoice buttons. I have looked into mySQL with phpMySQL and the data seems to be all there ?!??! - so I can see who ordered what etc etc. In an attempt to solve this I've installed 2 oder list contributions ... Still no further. Investigation goes on ... Roger Same here... I do see pending orders, but when I click on them, there's nothing there. Thank you! Link to comment Share on other sites More sharing options...
OldTimeSchool Posted March 14, 2007 Share Posted March 14, 2007 Same here... I do see pending orders, but when I click on them, there's nothing there. I just found the solution... (at lest to my problem !!) Hope this sorts yours out too. http://www.oscommerce.com/community/contri...190/mirror,pair Downloaded the post by Mazzel 18 May 2004 ALl good !!! :D Link to comment Share on other sites More sharing options...
Guest Posted March 14, 2007 Share Posted March 14, 2007 I just posted this in another string. Here is your problem with paypal.com I would recommend using the paypal.com ipn. See if your customer doesn't hit continue on the last page of paypal.com to return to your site. You site is not notified an order has been placed. If people don't get to the check_success.php page it doesn't know because the checkout_process.php file tracks the order through the cookies or sessions within the cart. For example one of you can post your website for me and I will make your cart look like an order has come through when it really has not been paid for. But use paypal.com IPN contribution and your problems will be resolved. It is an easy install takes 2 minutes. But remember to add the ipn url in your paypal.com account under account setting merchant tools 3rd column Instant Payment Notification. http://www.oscommerce.com/community/contri...arch,paypal+ipn Link to comment Share on other sites More sharing options...
tctcfavors Posted March 14, 2007 Author Share Posted March 14, 2007 OH NO!!! I did that, now I can't even access the orders at all!!! It won't allow me to use the backed up file either! Thank you! Link to comment Share on other sites More sharing options...
tctcfavors Posted March 14, 2007 Author Share Posted March 14, 2007 OH NO!!! I did that, now I can't even access the orders at all!!! It won't allow me to use the backed up file either! I know about the paypal and return path, but wha was happening is different... it wasn't only with paypal.. it was happening even if a ersona paid by selecting to send a money order. But now I can't access the orders at all!!! This is what the page returns when I click on orders: Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ',' or ';' in /home/tctc/public_html/admin/orders.php on line 387 Thank you! Link to comment Share on other sites More sharing options...
Guest Posted March 14, 2007 Share Posted March 14, 2007 Please post line 387 line of code. post about 10 lines for me and highlight 387 and I will tell you what is wrote but it says its missing a , or a ; I know about the paypal and return path, but wha was happening is different... it wasn't only with paypal.. it was happening even if a ersona paid by selecting to send a money order. But now I can't access the orders at all!!! This is what the page returns when I click on orders: Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ',' or ';' in /home/tctc/public_html/admin/orders.php on line 387 Link to comment Share on other sites More sharing options...
tctcfavors Posted March 14, 2007 Author Share Posted March 14, 2007 Please post line 387 line of code. post about 10 lines for me and highlight 387 and I will tell you what is wrote but it says its missing a , or a ; from " . TABLE_ORDERS_STATUS_HISTORY . " where orders_id = '" . tep_db_input($oID) . "' order by date_added"); if (tep_db_num_rows($orders_history_query)) { while ($orders_history = tep_db_fetch_array($orders_history_query)) { echo ' <tr>' . "n" . ' <td class="smallText" align="center">' . tep_datetime_short($orders_history['date_added']) . '</td>' . "n" . ' <td class="smallText" align="center">'; if ($orders_history['customer_notified'] == '1') { echo tep_image(DIR_WS_ICONS . 'tick.gif', ICON_TICK) . "</td>n"; } else { echo tep_image(DIR_WS_ICONS . 'cross.gif', ICON_CROSS) . "</td>n"; } echo ' <td class="smallText">' . $orders_status_array[$orders_history['orders_status_id']] . '</td>' . "n" . ' <td class="smallText">' . nl2br(tep_db_output($orders_history Thank you! Link to comment Share on other sites More sharing options...
tctcfavors Posted March 14, 2007 Author Share Posted March 14, 2007 Thank you Kevin, So so very much for trying to help me with this! You have no idea how much it is appreciated. Thank you! Link to comment Share on other sites More sharing options...
Guest Posted March 14, 2007 Share Posted March 14, 2007 In bold add that and you should be good. if ($orders_history['customer_notified'] == '1'); { Thank you Kevin, So so very much for trying to help me with this! You have no idea how much it is appreciated. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.