Recently we upgraded our whole website to a new design and also to the latest updater stability releas v7.6.2 (ASP).

We have a custom adition to our site to create PDF documents (invoice, packingslip etc.). As we have an e-mail payment option for logged in customers to order on account, we need to be able to determin wether an order was paid online to be able to show this on the invoice.

We are checking ordPayProvider to be equal to 1 (Paypal) or 23 (Stripe) and ordTransID not to be empty. But we notice ordTransID can be empty even when a Stripe payment was received. So which field(s) should we (also) check. Maybe ordTransSession?

With orders on account it is easier as we import our bankstatements and then change the orderStatus to Paid.

Love to hear your advice?

Greetings,

Jaap


jaapg@promanent.com
Promanent b.v.
www.promanent.com | www.vaarwinkel.nl

Hi Jaap
I would check that the ordStatus column is greater than or equal to 3 and that the ordAuthNumber is not empty.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Hi Vince,

Thanks.

We now check as follows: select order with ordStatus>3 and ordAutNumber not empty
when
payprovider = Stripe or Paypal
then we also check ordTransSession not empty

or when
payprovider = Email (order on account)
then if ordStatus = paid (in our orderStatus list this is 13)

This way we can determin wether an order was paid online or via banktransfer. This works for the way we have setup the order status table and use the E-mail for orders on account for regular (logged in) clients.

Greetings,

Jaap



jaapg@promanent.com
Promanent b.v.
www.promanent.com | www.vaarwinkel.nl