Re: Oscommerce and PayPal | |
Bev
In your main cpanel go to mysql, scroll to the bottom go phpmyadmin, on the far left choose the database you want to browse. Down the left should be a list of TABLES in that database. You should have one called orders or Incart or something close to that, click on that and it should open in the window on the right, Somewhere in there should be a substructure of order id's which should also list your order numbers. Hilight that row, and then up at the top of that window click browse. You should see the order details there.
There should also be a way of configuring OSC attributes to also display this table when you query it. It should give you a list of all orders in a date range rather they were completed or not.
I wish I could help you more, but I honestly dont have the time to go play in osc. Also your paypal notifications and reciepts should also carry what was ordered if the payment was made. You should be able to view the details there as well as that should have transferred from the store with the payment options to bill the customer.
One of the headaches attatching paypal to OSC or any catalog builder is that they customer can actually GO to paypal and NOT pay, but hit the back button and return to store and show up as an order, or as in your situation, pay and not return to the store to complete the order. MAKE SURE YOU HAVE THE MONEY!! If you dont have the money, and you cant find the payment details, then, the order NEVER HAPPENED. This is one of the BIGGEST reasons you should 1.) have a merchant account, and 2.) have an ssl or be able to use SIM integration methods with your processor.
Anyway.. check those places for your order. If you HAVE money, just ask the customer so you can process it.
Karen
|