rubygirl Posted February 14, 2003 Posted February 14, 2003 Just finished up with a new system - Dec 2002 snapshot - everything is going well except the orders are not showing in the admin area! The order can be completed as a customer - email is sent to customer as confirmation - but admin still shows 0 orders.... where do I start to fix this?
rubygirl Posted February 14, 2003 Author Posted February 14, 2003 by they way - the orders are posting in the database - just not showing in the admin....
agtlewis Posted February 14, 2003 Posted February 14, 2003 Download the newest admin snapshot and just overwrite your existing one. (don't forget to NOT overwrite your configuration file)
rubygirl Posted February 14, 2003 Author Posted February 14, 2003 well i did just that and still no luck - still no orders show in the admin area
XtremeCarAudio Posted February 15, 2003 Posted February 15, 2003 well i did just that and still no luck - still no orders show in the admin area check the Config file for the Admin, and the Catalog, make sure they are pointing to the same dbase... other than that it should work.. Michael
Guest Posted February 18, 2003 Posted February 18, 2003 Both configure.php files point to the same database....but the one in the catalog has pconnect set to true, and the one in the admin has pconnect set to false. Would that cause this problem? Should they both be set to the same value?
Guest Posted February 18, 2003 Posted February 18, 2003 Is this happening with Paypal for you? I have since found, that if the customer does NOT click the "Continue" link on the paypal confirmation screen, thereby returning to your site, (for example, if they just close the paypal window after making payment), then the order process is not deemed "complete". It is necessary for the customer to return to your site for their order information to show up in your admin/customers/orders. I have added a LARGE red warning to the bottom of the checkout_confirmation.php page warning customers that they must do this. Perhaps the dev team could look at doing something to have the order information passed to the orders file when checkout has been completed, rather than relying on the customer to click the continue link from Paypal...which they are not even aware they are required to do.
Guest Posted February 18, 2003 Posted February 18, 2003 Rex, The PayPal IPN takes care of the non-completed order problem.
Ajeh Posted February 18, 2003 Posted February 18, 2003 by they way - the orders are posting in the database - just not showing in the admin.... Make sure you did not delete your orders_status table and that all orders have a status to them.
rubygirl Posted March 30, 2003 Author Posted March 30, 2003 Linda, I just checked the database and I do have the order_status table but there aren't any status entries - the orders show in the orders table still nothing showing in the store admin area - why wouldn't the status be entered and how do I fix that?
rubygirl Posted March 30, 2003 Author Posted March 30, 2003 PS - in the actual orders table there is an orders_status but it isn't showing in the orders_status table....
Ajeh Posted March 30, 2003 Posted March 30, 2003 orders_status table hold the values for Pending, Processing and Delivered ... If they do not exist in your orders_status table when the look up is done referencing this value there is nothing there so you see nothing. You can look carefully in the original oscommerce.sql file and see where this table is created and what is put into it. Be sure to backup your MySQL database before fixing anything.
rubygirl Posted March 30, 2003 Author Posted March 30, 2003 WOW - brain stump again - fixed it - I somehow dumbed the orders_status - just re-inserted and now everything is fine.... :oops: Gotta get some sleep....
Ajeh Posted March 30, 2003 Posted March 30, 2003 That is actually the most common way that area gets broken ... Sleep tight! :D
rubygirl Posted March 30, 2003 Author Posted March 30, 2003 Thank you so much again Linda for your prompt responses and helpfullness! These boards wouldn't be the same without you!!!
ptrau Posted April 5, 2003 Posted April 5, 2003 I use the latest snap and PayPal IPN. If the customer does not click continue, we get the money...just not the order. While that may sound like a "class A" headache, it really pi**es the customers off when we take their money but don't ship their orders. I would love to see a hack to fix this. "Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"
Guest Posted April 5, 2003 Posted April 5, 2003 http://www.www.oscommerce.com/forums/viewtopic.php?t=39217 Paul, give the thread above a shot.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.