dashCommerce

Hi,

Hopefully someone can help with this......

In my "dashCommerce_Store_Order" table in the database there are 16 orders, but on admin/orders.aspx the order list is only showing 10 orders....the most recent orders are not there!!

If I search for the specific order numbers that aren't in that list, they are found.....so it's pulling the info from the database, but it's almost like the dgOrders datagrid is only set to show a certain number!

Anyone have any ideas??

Thank you

The order table also serves as the cart, so you'll want to check the status of the order. If it's 9999, then it's basically an unprocessed order / cart - meaning they haven't actually purchased anything, they've just added stuff to their cart. 

Right, ok....so the order status is showing 9999, but they completed the transaction through PayPal and my client has beem paid the money.

Why do you think the order status isn't being updated?

Thanks

Is is PayPal Standard or Pro? If standard, do you have the IPN and PDT handlers setup in paypal correctly? Are they setup on the site correctly?

It's PayPal standard.....ah, ok so the PDT is all set up ok, but I've found that the IPN is empty.

Should this just be the domain? (ie http://www.mydomain.com/) or does this need to point to a specific page?

No, it needs to point to the ipnhandler.aspx page that is in the paypal directory with the pdthandler.aspx. Should be www.mydomain.com/paypal/ipnhandler.aspx. If people pay in PayPal standard and don't get "auto-navigated" back (or don't click the "Take me back to the 'mydomain' website") - they go off and do something else - then the only way your site will know the transaction occurred is via the ipnhandler.aspx page, which PayPal pings once the transaction is done. Most often this is pretty instantaneous.

Got it!

Thanks for your help...I'm off to do some more testing!

Ok.....so I still have a couple of issues....

Now the orders are showing in the orders list as they are placed, which is great.

But, when viewing the order, clicking the transaction tab shows nothing and on clicking the actions tab it displays: "A critical error has occurred: Object reference not set to an instance of an object."

Checking the store_transaction table doesn't show the relavent order ID....which would explain the page error and why the transaction tab is blank, but I can't figure out why it's not getting the info put into the table??

Please help

The PayPal IPN will only ping for a certain period and then it stops pinging. So, in effect, you may have lost the relevant transaction information that would tie the transaction back the to the order. You may be able to contact PayPal in order to get the information you need so that you can build it up manually.

Ok, would this have any difference with using a credit card through paypal, instead of a paypal account?

It seems that making a payment through a paypal account works ok, but using a card creates this issue.

It shouldn't - an order is an order. The only thing I can think that might "drive" this is the PayPal UI - meaning, their checkout process could be different based on the payment method - I don't know this to be the case, but it's possible. But, with the IPN configured, the payment notification should hit the ipnhandler regardless of their payment method.

Ok, I was expecting you to say something along the lines of "an order is an order".

I'll just have to keep my eye on things...unless there's anything alse you can think I should double check at my end?

Thanks for all your help