search

google-code-export / bignoze

Automatically exported from code.google.com/p/bignoze
0 stars 0 forks source link

Order processed through PayPal not showing on FHD #319

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
BM Pet snacks reported receiveing 2 x identical PayPal payments from a repeat 
customer.  The customer claims to have had problems during the order as she 
only intended to make one order with BM Pet Snax.  Order numbers provided:

20121102940013 & 20121102410010

There is no record of either order for Lesley Dean in FHD.  Please investigate 
how this customer can be charged but no record of the order/s exist in FHD.

Producer email below:

On 5 November 2012 14:58, John and Maree Davies <bonmanna@bmanimals.com.au> 
wrote:

Good afternoon

We are producer sellers on F/House Direct and I need some assistance from you 
–

We received 2 payments of $72.60 through paypal over the weekend from a regular 
customer Lesley Dean – I clarified with her that it should have been only one 
payment and that she had a problem when ordering and I refunded her the first 
payment.

I have however not received anything re the actual order from F/H D and the 
customer cannot actually remember the exact order – are you able to assist me 
with this ASAP

John & Maree Davies
BM Animal Wellbeing & BM Pet Snax

Original issue reported on code.google.com by vane...@farmhousedirect.com.au on 5 Nov 2012 at 4:52

GoogleCodeExporter commented 9 years ago 
Hi,

Looks like the user had a paypal error.

You can check out the paypal logging here:
http://www.farmhousedirect.com.au/admin/paypallog

Error:
The%20transaction%20cannot%20complete%20successfully%2e%20%20Instruct%20the%20cu
stomer%20to%20use%20an%20alternative%20payment%20method%2e

Detailed Logging:
20121102940013  
CompletePayment Fail    
Lesley Dean BM Pet Snax 2/11/2012 7:51:04 PM    
ErrorCode:  VERSION=84.0&METHOD=DoExpressCheckoutPayment&TOKEN=EC-4R5991220U64172
2A&PAYERID=YV4NATGP4GL8E&EMAIL=l.dean%40bigpond.net.au&PAYMENTREQUEST_0_PAYMENTR
EQUESTID=20121102770011&PAYMENTREQUEST_0_AMT=58.00&PAYMENTREQUEST_0_CURRENCYCODE
=AUD&PAYMENTREQUEST_0_PAYMENTACTION=Sale&PAYMENTREQUEST_0_SELLERPAYPALACCOUNTID=
info%40barhamavocados.com.au&PAYMENTREQUEST_0_SHIPTONAME=Lesley+Dean&PAYMENTREQU
EST_0_SHIPTOSTREET=59+Broadway&PAYMENTREQUEST_0_SHIPTOCITY=Camberwell&PAYMENTREQ
UEST_0_SHIPTOSTATE=Victoria&PAYMENTREQUEST_0_SHIPTOCOUNTRYCODE=AU&PAYMENTREQUEST
_0_SHIPTOZIP=3124&PAYMENTREQUEST_0_SHIPTOPHONENUM=0412307307&PAYMENTREQUEST_1_PA
YMENTREQUESTID=20121102830012&PAYMENTREQUEST_1_AMT=289.00&PAYMENTREQUEST_1_CURRE
NCYCODE=AUD&PAYMENTREQUEST_1_PAYMENTACTION=Sale&PAYMENTREQUEST_1_SELLERPAYPALACC
OUNTID=info%40poonboon.com.au&PAYMENTREQUEST_1_SHIPTONAME=Lesley+Dean&PAYMENTREQ
UEST_1_SHIPTOSTREET=59+Broadway&PAYMENTREQUEST_1_SHIPTOCITY=Camberwell&PAYMENTRE
QUEST_1_SHIPTOSTATE=Victoria&PAYMENTREQUEST_1_SHIPTOCOUNTRYCODE=AU&PAYMENTREQUES
T_1_SHIPTOZIP=3124&PAYMENTREQUEST_1_SHIPTOPHONENUM=0412307307&PAYMENTREQUEST_2_P
AYMENTREQUESTID=20121102940013&PAYMENTREQUEST_2_AMT=72.60&PAYMENTREQUEST_2_CURRE
NCYCODE=AUD&PAYMENTREQUEST_2_PAYMENTACTION=Sale&PAYMENTREQUEST_2_SELLERPAYPALACC
OUNTID=maree%40bmanimals.com.au&PAYMENTREQUEST_2_SHIPTONAME=Lesley+Dean&PAYMENTR
EQUEST_2_SHIPTOSTREET=59+Broadway&PAYMENTREQUEST_2_SHIPTOCITY=Camberwell&PAYMENT
REQUEST_2_SHIPTOSTATE=Victoria&PAYMENTREQUEST_2_SHIPTOCOUNTRYCODE=AU&PAYMENTREQU
EST_2_SHIPTOZIP=3124&PAYMENTREQUEST_2_SHIPTOPHONENUM=0412307307&LOCALECODE=AU&HD
RIMG=https%3a%2f%2flib.farmhousedirect.com.au%2fimages%2fweb%2fFarmhousePayPalLi
nk.jpg&NOSHIPPING=1 TOKEN=EC%2d4R5991220U641722A&SUCCESSPAGEREDIRECTREQUESTED=fa
lse&TIMESTAMP=2012%2d11%2d02T08%3a51%3a42Z&CORRELATIONID=80250f7a77dc2&ACK=Parti
alSuccess&VERSION=84%2e0&BUILD=4181146&INSURANCEOPTIONSELECTED=false&SHIPPINGOPT
IONISDEFAULT=false&PAYMENTINFO_0_TRANSACTIONID=44J26802EB606562K&PAYMENTINFO_0_T
RANSACTIONTYPE=expresscheckout&PAYMENTINFO_0_PAYMENTTYPE=instant&PAYMENTINFO_0_O
RDERTIME=2012%2d11%2d02T08%3a51%3a39Z&PAYMENTINFO_0_AMT=58%2e00&PAYMENTINFO_0_FE
EAMT=1%2e69&PAYMENTINFO_0_TAXAMT=0%2e00&PAYMENTINFO_0_CURRENCYCODE=AUD&PAYMENTIN
FO_0_PAYMENTSTATUS=Completed&PAYMENTINFO_0_PENDINGREASON=None&PAYMENTINFO_0_REAS
ONCODE=None&PAYMENTINFO_0_PROTECTIONELIGIBILITY=Ineligible&PAYMENTINFO_0_PROTECT
IONELIGIBILITYTYPE=None&PAYMENTINFO_0_SELLERPAYPALACCOUNTID=orders%40barhamavoca
dos%2ecom%2eau&PAYMENTINFO_0_SECUREMERCHANTACCOUNTID=C6HDYH3DXWLMY&PAYMENTINFO_0
_PAYMENTREQUESTID=20121102770011&PAYMENTINFO_0_ERRORCODE=0&PAYMENTINFO_0_ACK=Suc
cess&PAYMENTINFO_1_PAYMENTSTATUS=Failed&PAYMENTINFO_1_SELLERPAYPALACCOUNTID=info
%40poonboon%2ecom%2eau&PAYMENTINFO_1_SECUREMERCHANTACCOUNTID=6Y4QA5GNSE7ZC&PAYME
NTINFO_1_PAYMENTREQUESTID=20121102830012&PAYMENTINFO_1_ERRORCODE=10417&PAYMENTIN
FO_1_SHORTMESSAGE=Transaction%20cannot%20complete%2e&PAYMENTINFO_1_LONGMESSAGE=T
he%20transaction%20cannot%20complete%20successfully%2e%20%20Instruct%20the%20cus
tomer%20to%20use%20an%20alternative%20payment%20method%2e&PAYMENTINFO_1_SEVERITY
CODE=Error&PAYMENTINFO_1_ACK=Failure&PAYMENTINFO_2_TRANSACTIONID=2KE073926D47260
0N&PAYMENTINFO_2_TRANSACTIONTYPE=expresscheckout&PAYMENTINFO_2_PAYMENTTYPE=insta
nt&PAYMENTINFO_2_ORDERTIME=2012%2d11%2d02T08%3a51%3a41Z&PAYMENTINFO_2_AMT=72%2e6
0&PAYMENTINFO_2_FEEAMT=2%2e04&PAYMENTINFO_2_TAXAMT=0%2e00&PAYMENTINFO_2_CURRENCY
CODE=AUD&PAYMENTINFO_2_PAYMENTSTATUS=Completed&PAYMENTINFO_2_PENDINGREASON=None&
PAYMENTINFO_2_REASONCODE=None&PAYMENTINFO_2_PROTECTIONELIGIBILITY=Ineligible&PAY
MENTINFO_2_PROTECTIONELIGIBILITYTYPE=None&PAYMENTINFO_2_SELLERPAYPALACCOUNTID=ma
ree%40bmanimals%2ecom%2eau&PAYMENTINFO_2_SECUREMERCHANTACCOUNTID=W6MYDZ4LS43PW&P
AYMENTINFO_2_PAYMENTREQUESTID=20121102940013&PAYMENTINFO_2_ERRORCODE=0&PAYMENTIN
FO_2_ACK=Success

Original comment by Hui....@gmail.com on 5 Nov 2012 at 5:02

GoogleCodeExporter commented 9 years ago 
Looking at paypal, there isn't a lot of explanation regarding this error, maybe 
you should contact paypal

https://cms.paypal.com/uk/cgi-bin/?cmd=_render-content&content_ID=developer/e_ho
wto_api_nvp_errorcodes

Original comment by Hui....@gmail.com on 5 Nov 2012 at 5:04

GoogleCodeExporter commented 9 years ago

Original comment by vane...@farmhousedirect.com.au on 5 Nov 2012 at 5:45

GoogleCodeExporter commented 9 years ago 
So it appears that PayPal has responded to inform us that this paypal payment 
was unsuccessful, the funds was still transferred

We can provide the relevant information to paypal to get a better explanation.

Original comment by Hui....@gmail.com on 5 Nov 2012 at 5:57

GoogleCodeExporter commented 9 years ago 
Roy - Are we able to get a copy of their cart so that the Producer can fulfil 
the order or should we wait for Paypal?

Original comment by v...@farmhousedirect.com.au on 5 Nov 2012 at 6:14

GoogleCodeExporter commented 9 years ago 
Hi

Here is the order
http://www.farmhousedirect.com.au/admin/order/20121102410010

and again here
http://www.farmhousedirect.com.au/admin/order/20121102940013

I will send more info to PayPal

Original comment by Hui....@gmail.com on 5 Nov 2012 at 6:39

GoogleCodeExporter commented 9 years ago 
The same user purchased two other orders in the same cart
http://www.farmhousedirect.com.au/admin/order/20121102440009
http://www.farmhousedirect.com.au/admin/order/20121102200008

you should be able to the information from this page:
http://www.farmhousedirect.com.au/admin/paypallog

Original comment by Hui....@gmail.com on 5 Nov 2012 at 6:40

GoogleCodeExporter commented 9 years ago 
OK, so here is the summary of the issue investigation (based on the spreadsheet 
attached).

The buyer submitted their basket at 19:47 on 02/11 - which contained 3 
producers (and hence 3 orders).  PayPay returned an ACK=PartialSuccess as 2 of 
the 3 orders were successful 20121102200008 ACK=Success, 20121102440009 
ACK=Failure & 20121102410010 ACK=Success.

The failure reason for 20121102440009 from PayPal was "Instruct the customer to 
use an alternate payment method".

I have assumed this would return a 'failure' order confirmation page to the 
buyer.
[ROY: Please confirm if this assumption is correct].

The buyer re-submitted their basket at 19:50 on 02/11 (same basket).  Again, 
PayPay returned an ACK=PartialSuccess as 2 of the 3 orders were successful 
20121102770011 ACK=Success, 20121102830012 ACK=Failure & 20121102940013 
ACK=Success.

From the information above (and the original email from one of the producers) I 
can confidently assume that both Barham Avocados and BM Pet Snax have both 
received double payments.  

Also, none of the orders are visible (to non-adminsitrators) as thye in a 
status of 'pending'.

So, the actions from here:

Recovery

(1) Rob: confirm with PayPal that payments were accepted for Barham Avocados 
and BM Pet Snax 
If payments processed:
(1a) Ops team: for Barham Avocados and BM Pet Snax then advise them to process 
a refund for one of the doubled-up payments.  Get them to confirm which order 
they refunded and which they kept.
(1b) Roy: For Barham Avocados and BM Pet Snax set the "kept" orders to be 
status of "paid" and then they will be come visible (and also make sure the 
producers recieve an order confirmation email)

(2) Rob: For Poon Boon Lamb I believe the order has not ben processed and no 
payment received. I will get PayPal to confirm.  
If it has not been processed
(2a) Ops Team: I would advise the buyer to re-submit for just that producer.

Suggested resolution - what needs to change to avoid this situation.
(3) Ensure FHD handles the "PartialSuccess" situation and that the user (in 
this case) gets 2 success and one fail message on the confirmation screen.  For 
this type of situation only the failed transaction/s should remain in the 
shopping basket.

Original comment by Rob...@gmail.com on 6 Nov 2012 at 11:30

Attachments:

GoogleCodeExporter commented 9 years ago 
Hi Rob,

Happy with your response

Let me know when you want the two orders to be marked as successful.

We can proceed with the suggested resolution in a future release as you see fit.

Original comment by Hui....@gmail.com on 6 Nov 2012 at 11:38

GoogleCodeExporter commented 9 years ago 
I have contacted both Barham (email) and BM Pet Snax (phone).  Rob – they 
reasonably confident that they refunded 20121102410010. Maree wanted to refund 
the oldest order.  She noted that number down but when she checked paypal while 
I was on the phone she couldn’t see the order no.  to double confirm.

Original comment by moni...@farmhousedirect.com.au on 7 Nov 2012 at 3:46

GoogleCodeExporter commented 9 years ago 
Response from this morning

TOKEN=EC%2d6Y676230400444226&SUCCESSPAGEREDIRECTREQUESTED=true&TIMESTAMP=2012%2d
11%2d07T11%3a57%3a58Z&CORRELATIONID=83f38729470d&ACK=PartialSuccess&VERSION=84%2
e0&BUILD=4181146&INSURANCEOPTIONSELECTED=false&SHIPPINGOPTIONISDEFAULT=false&PAY
MENTINFO_0_TRANSACTIONID=1VT56116WB204634A&PAYMENTINFO_0_RECEIPTID=4376%2d0035%2
d7676%2d2720&PAYMENTINFO_0_TRANSACTIONTYPE=expresscheckout&PAYMENTINFO_0_PAYMENT
TYPE=instant&PAYMENTINFO_0_ORDERTIME=2012%2d11%2d07T11%3a57%3a47Z&PAYMENTINFO_0_
AMT=18%2e30&PAYMENTINFO_0_FEEAMT=0%2e74&PAYMENTINFO_0_TAXAMT=0%2e00&PAYMENTINFO_
0_CURRENCYCODE=AUD&PAYMENTINFO_0_PAYMENTSTATUS=Completed&PAYMENTINFO_0_PENDINGRE
ASON=None&PAYMENTINFO_0_REASONCODE=None&PAYMENTINFO_0_PROTECTIONELIGIBILITY=Inel
igible&PAYMENTINFO_0_PROTECTIONELIGIBILITYTYPE=None&PAYMENTINFO_0_SELLERPAYPALAC
COUNTID=deb%40mtbaimbridgelavender%2ecom%2eau&PAYMENTINFO_0_SECUREMERCHANTACCOUN
TID=F26JE897RAGJG&PAYMENTINFO_0_PAYMENTREQUESTID=20121107700009&PAYMENTINFO_0_ER
RORCODE=0&PAYMENTINFO_0_ACK=Success&PAYMENTINFO_1_TRANSACTIONID=0HD548506X107713
0&PAYMENTINFO_1_RECEIPTID=0984%2d0213%2d4555%2d5615&PAYMENTINFO_1_TRANSACTIONTYP
E=expresscheckout&PAYMENTINFO_1_PAYMENTTYPE=instant&PAYMENTINFO_1_ORDERTIME=2012
%2d11%2d07T11%3a57%3a48Z&PAYMENTINFO_1_AMT=14%2e00&PAYMENTINFO_1_FEEAMT=0%2e64&P
AYMENTINFO_1_TAXAMT=0%2e00&PAYMENTINFO_1_CURRENCYCODE=AUD&PAYMENTINFO_1_PAYMENTS
TATUS=Completed&PAYMENTINFO_1_PENDINGREASON=None&PAYMENTINFO_1_REASONCODE=None&P
AYMENTINFO_1_PROTECTIONELIGIBILITY=Ineligible&PAYMENTINFO_1_PROTECTIONELIGIBILIT
YTYPE=None&PAYMENTINFO_1_SELLERPAYPALACCOUNTID=coffeeprincecoffeeprince%40gmail%
2ecom&PAYMENTINFO_1_SECUREMERCHANTACCOUNTID=Q5NBUFBG2LHTA&PAYMENTINFO_1_PAYMENTR
EQUESTID=20121107700010&PAYMENTINFO_1_ERRORCODE=0&PAYMENTINFO_1_ACK=Success&PAYM
ENTINFO_2_TRANSACTIONID=4BC0008568399162F&PAYMENTINFO_2_RECEIPTID=2135%2d6300%2d
4286%2d3223&PAYMENTINFO_2_TRANSACTIONTYPE=expresscheckout&PAYMENTINFO_2_PAYMENTT
YPE=instant&PAYMENTINFO_2_ORDERTIME=2012%2d11%2d07T11%3a57%3a50Z&PAYMENTINFO_2_A
MT=23%2e05&PAYMENTINFO_2_FEEAMT=0%2e85&PAYMENTINFO_2_TAXAMT=0%2e00&PAYMENTINFO_2
_CURRENCYCODE=AUD&PAYMENTINFO_2_PAYMENTSTATUS=Completed&PAYMENTINFO_2_PENDINGREA
SON=None&PAYMENTINFO_2_REASONCODE=None&PAYMENTINFO_2_PROTECTIONELIGIBILITY=Ineli
gible&PAYMENTINFO_2_PROTECTIONELIGIBILITYTYPE=None&PAYMENTINFO_2_SELLERPAYPALACC
OUNTID=goldfieldsfarmbakedgoodies%40bigpond%2ecom&PAYMENTINFO_2_SECUREMERCHANTAC
COUNTID=ZGRLSL9LJ8S86&PAYMENTINFO_2_PAYMENTREQUESTID=20121107170011&PAYMENTINFO_
2_ERRORCODE=0&PAYMENTINFO_2_ACK=Success&PAYMENTINFO_3_TRANSACTIONID=5AR682431E52
9683G&PAYMENTINFO_3_RECEIPTID=2886%2d1466%2d9316%2d4655&PAYMENTINFO_3_TRANSACTIO
NTYPE=expresscheckout&PAYMENTINFO_3_PAYMENTTYPE=instant&PAYMENTINFO_3_ORDERTIME=
2012%2d11%2d07T11%3a57%3a51Z&PAYMENTINFO_3_AMT=15%2e00&PAYMENTINFO_3_FEEAMT=0%2e
66&PAYMENTINFO_3_TAXAMT=0%2e00&PAYMENTINFO_3_CURRENCYCODE=AUD&PAYMENTINFO_3_PAYM
ENTSTATUS=Completed&PAYMENTINFO_3_PENDINGREASON=None&PAYMENTINFO_3_REASONCODE=No
ne&PAYMENTINFO_3_PROTECTIONELIGIBILITY=Ineligible&PAYMENTINFO_3_PROTECTIONELIGIB
ILITYTYPE=None&PAYMENTINFO_3_SELLERPAYPALACCOUNTID=pinnacle_berries%40skymesh%2e
com%2eau&PAYMENTINFO_3_SECUREMERCHANTACCOUNTID=6ZHVWL4LCRQYY&PAYMENTINFO_3_PAYME
NTREQUESTID=20121107850012&PAYMENTINFO_3_ERRORCODE=0&PAYMENTINFO_3_ACK=Success&P
AYMENTINFO_4_TRANSACTIONID=2VD2522006406840E&PAYMENTINFO_4_RECEIPTID=1731%2d6817
%2d6496%2d3543&PAYMENTINFO_4_TRANSACTIONTYPE=expresscheckout&PAYMENTINFO_4_PAYME
NTTYPE=instant&PAYMENTINFO_4_ORDERTIME=2012%2d11%2d07T11%3a57%3a53Z&PAYMENTINFO_
4_AMT=18%2e50&PAYMENTINFO_4_FEEAMT=0%2e74&PAYMENTINFO_4_TAXAMT=0%2e00&PAYMENTINF
O_4_CURRENCYCODE=AUD&PAYMENTINFO_4_PAYMENTSTATUS=Completed&PAYMENTINFO_4_PENDING
REASON=None&PAYMENTINFO_4_REASONCODE=None&PAYMENTINFO_4_PROTECTIONELIGIBILITY=In
eligible&PAYMENTINFO_4_PROTECTIONELIGIBILITYTYPE=None&PAYMENTINFO_4_SELLERPAYPAL
ACCOUNTID=jymtarrant%40gmail%2ecom&PAYMENTINFO_4_SECUREMERCHANTACCOUNTID=HVFNBT4
5KH8PC&PAYMENTINFO_4_PAYMENTREQUESTID=20121107230013&PAYMENTINFO_4_ERRORCODE=0&P
AYMENTINFO_4_ACK=Success&PAYMENTINFO_5_TRANSACTIONID=1DT29889621105244&PAYMENTIN
FO_5_RECEIPTID=0460%2d3670%2d7915%2d2498&PAYMENTINFO_5_TRANSACTIONTYPE=expressch
eckout&PAYMENTINFO_5_PAYMENTTYPE=instant&PAYMENTINFO_5_ORDERTIME=2012%2d11%2d07T
11%3a57%3a55Z&PAYMENTINFO_5_AMT=23%2e00&PAYMENTINFO_5_FEEAMT=0%2e85&PAYMENTINFO_
5_TAXAMT=0%2e00&PAYMENTINFO_5_CURRENCYCODE=AUD&PAYMENTINFO_5_PAYMENTSTATUS=Compl
eted&PAYMENTINFO_5_PENDINGREASON=None&PAYMENTINFO_5_REASONCODE=None&PAYMENTINFO_
5_PROTECTIONELIGIBILITY=Ineligible&PAYMENTINFO_5_PROTECTIONELIGIBILITYTYPE=None&
PAYMENTINFO_5_SELLERPAYPALACCOUNTID=info%40thebutterfactory%2ecom%2eau&PAYMENTIN
FO_5_SECUREMERCHANTACCOUNTID=NAGACKLR27DVJ&PAYMENTINFO_5_PAYMENTREQUESTID=201211
07890014&PAYMENTINFO_5_ERRORCODE=0&PAYMENTINFO_5_ACK=Success&PAYMENTINFO_6_PAYME
NTSTATUS=Failed&PAYMENTINFO_6_SELLERPAYPALACCOUNTID=deva%40aussieteahouse%2ecom%
2eau&PAYMENTINFO_6_SECUREMERCHANTACCOUNTID=CMECRCBCZ6SAN&PAYMENTINFO_6_PAYMENTRE
QUESTID=20121107300015&PAYMENTINFO_6_ERRORCODE=10417&PAYMENTINFO_6_SHORTMESSAGE=
Transaction%20cannot%20complete%2e&PAYMENTINFO_6_LONGMESSAGE=The%20transaction%2
0cannot%20complete%20successfully%2e%20%20Instruct%20the%20customer%20to%20use%2
0an%20alternative%20payment%20method%2e&PAYMENTINFO_6_SEVERITYCODE=Error&PAYMENT
INFO_6_ACK=Failure

Original comment by Hui....@gmail.com on 7 Nov 2012 at 11:13

GoogleCodeExporter commented 9 years ago 
We will proceed with a change of the following as requested by Rob

- Recognise Partial Success as a state, redirect it to Success (instead of Fail)
- Iterate the orders in the response
   - Mark successful orders as paid
   - Mark unsuccessful order as fail
- List successful orders
- List failed orders - show long message from paypal
- Update Cart - should only contain the failed order

Look at impact to other areas
- Email
- Reports
- Ref Trans
- Admin notification

Original comment by Hui....@gmail.com on 7 Nov 2012 at 11:15

GoogleCodeExporter commented 9 years ago 
Hi Roy,

Please set the following orders to a status of 'paid' please:

20121102940013

20121107700009
20121107700010
20121107170011
20121107850012
20121107230013
20121107890014

There will be one more to come (once we've spoken to the producer Barham 
Avocados).

Original comment by Rob...@gmail.com on 8 Nov 2012 at 1:13

GoogleCodeExporter commented 9 years ago 
script executed
update orders set status = 'Paid' where orderid = 20121102940013
update orders set status = 'Paid' where orderid = 20121107700009
update orders set status = 'Paid' where orderid = 20121107700010
update orders set status = 'Paid' where orderid = 20121107170011
update orders set status = 'Paid' where orderid = 20121107850012
update orders set status = 'Paid' where orderid = 20121107230013
update orders set status = 'Paid' where orderid = 20121107890014

Original comment by Hui....@gmail.com on 8 Nov 2012 at 2:20

GoogleCodeExporter commented 9 years ago 
Attached how Order success page would look like if there is a partial success, 
we would also include a paypal error message in this screen, which we are still 
working on.

Original comment by Hui....@gmail.com on 8 Nov 2012 at 4:26

Attachments:

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
Partial success change implemented.

We made the last order always fail, so please let us know when testing is done 
so we can revert it.

Make an order in test with from at least two producers and you will see a mix 
of success and fail orders.

Thanks

Original comment by Hui....@gmail.com on 9 Nov 2012 at 2:39

GoogleCodeExporter commented 9 years ago 
Roy - we would liek to vary the order success page for the partial success to 
the following: 

Thank you for shopping at Farmhouse Direct your order has been received. 

The following order numbers have been successful and a confirmation email will 
be sent to you shortly click below for details. 
[Producer] – [Order Number] (link to the order detail) 

The following could not be completed. 
[Producer] – [PayPal error message] (no need to display order number not a 
link)
Please go back to the basket and try again. 
"Proceed to basket" button 

See the mock up with this post

Original comment by daniel...@gmail.com on 9 Nov 2012 at 6:10

Attachments:

GoogleCodeExporter commented 9 years ago 
Success page modified (quite a large change)

Original comment by Hui....@gmail.com on 10 Nov 2012 at 9:37

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 

20121102200008 - changed to paid
20121102770011 - changed to pending (should be pending already)

Original comment by Hui....@gmail.com on 12 Nov 2012 at 2:00

GoogleCodeExporter commented 9 years ago 
Summary of actions required for all 4 users affected by the Partial Success 
situation:

(1) Lesley Dean - double payment.
(1a) Refunds have been processed already.
(1b) BM Pet Snax Order 20121102940013 has already been marked as 'paid'.  As 
per standard process they will need to set to 'shipped'.
(1c) No action for Poon Boon as the buyer re-order two days later.
(1d) ACTION FOR ROY: Please mark 20121102200008 as 'shipped' (as it was shipped 
last week).

(2) Padmini Dyer - single payment.
(2a) No refunds required.
(2b) ACTION FOR MON: Australian Tea House Order 20121107300015 failed.  Advise 
the buyer to re-order.
(2c) All other orders already marked as 'paid'.  As per standard process they 
will need to set to 'shipped' by the producers.

(3) Maggie Koo - double payment.
(3a) ACTION FOR MON: Myrtleford Butter Factory orders failed both times.  
Advise the buyer to re-order.
(3b) ACTION FOR MON: Hope Farm Bakery and Little Creek Cheese to process single 
refund each.
(3c) ACTION FOR ROY: please mark the following orders as 'paid':
     Hope Farm Bakery      20121110470113
     Little Creek Cheese   20121110100111

(4) Lisa Ferguson - THREE or SIX payments?
(4a) ACTION FOR MON: Australian Vegie Gourmet orders failed all times.  Advise 
the buyer to re-order.
(4b) ACTION FOR MON: Based on spreasheet provided (on the Lisa Ferguson tab) 
check with porducers what refunds are required.
(4c) ACTION FOR ROY: please mark the following orders as 'paid':
    Hidden Secret          20121110790043
    Australian Tea House   20121110650041
    Hope Farm Bakery       20121110610040
    Peninsula Fudge        20121110270039
    Frank Food & Me        20121110500038
    Louisa Morris Cakes    20121110970037
    Blossom Sweet Treats   20121110440036
    Miss Sallies Cuisine   20121110360035
    Mt Baimbridge Lavender 20121110740034

Original comment by Rob...@gmail.com on 12 Nov 2012 at 2:03

Attachments:

GoogleCodeExporter commented 9 years ago 
Hi Roy - just had a look at the changed partial success pages, just need some 
formatting changes to the page and add a link to the shipping basket.

Original comment by daniel...@gmail.com on 12 Nov 2012 at 3:01

Attachments:

GoogleCodeExporter commented 9 years ago 
Done

20121102200008 - set to Shipped
20121110470113 - set to Paid
20121110100111 - set to Paid
20121110790043 - set to Paid
20121110650041 - set to Paid
20121110610040 - set to Paid
20121110270039 - set to Paid
20121110500038 - set to Paid
20121110970037 - set to Paid
20121110440036 - set to Paid
20121110360035 - set to Paid
20121110740034 - set to Paid

Original comment by Hui....@gmail.com on 12 Nov 2012 at 3:19

GoogleCodeExporter commented 9 years ago 
All producers and customers have been contacted via email and updated.  I am 
keeping track of the communications in the updated version of Rob's spreadsheet 
please see attached.  We may need to follow up with phonecalls tomorrow.  But 
we will see who responds today, we are getting responses from producers.

Original comment by moni...@farmhousedirect.com.au on 12 Nov 2012 at 5:10

Attachments:

GoogleCodeExporter commented 9 years ago 
Complete page changes committed

1 - the font wasn't bold previously, I've reduced it from 18px to 17px, 
hopefully that does the "unbold"
2 - added bold and link to cart

cheers

Original comment by Hui....@gmail.com on 12 Nov 2012 at 7:00

GoogleCodeExporter commented 9 years ago 
If you need a URL to test:
http://test.farmhousedirect.com.au/checkout/complete?o1=20121110920001&fo1=20121
110560002&err1=The+transaction+cannot+complete+successfully.++Instruct+the+custo
mer+to+use+an+alternative+payment+method.

Original comment by Hui....@gmail.com on 12 Nov 2012 at 7:30

GoogleCodeExporter commented 9 years ago 
Thanks Roy - Looks good, can you now take the hack off for the partial success 
off so that I can proceed with the regression testing?

Original comment by daniel...@gmail.com on 12 Nov 2012 at 7:35

GoogleCodeExporter commented 9 years ago 
will commit in 10min

Original comment by Hui....@gmail.com on 12 Nov 2012 at 7:38

GoogleCodeExporter commented 9 years ago 
stub removed

all orders should behave as normal, orders should succeed in test

Original comment by Hui....@gmail.com on 12 Nov 2012 at 7:47

GoogleCodeExporter commented 9 years ago 
Regression tests completed - accepted

Original comment by daniel...@gmail.com on 12 Nov 2012 at 9:45

GoogleCodeExporter commented 9 years ago 
Implemented on 13/11/2012

Original comment by daniel...@gmail.com on 13 Nov 2012 at 11:40

GoogleCodeExporter commented 9 years ago 
Re-opened until Mon has confirmed the 'clean up' of the 4 'Partial Success' 
users.

Mon: please attach a final 'wrap up' when done (for an audit trail).

Original comment by Rob...@gmail.com on 14 Nov 2012 at 9:47

GoogleCodeExporter commented 9 years ago 
Please see attached for PayPal response explaning the root cuase of the 
failures - it is due to the card providers passing back a declined.  We assume 
it is due to farud measures from the card provider.  PayPal cannot assist any 
further.

Original comment by Rob...@gmail.com on 16 Nov 2012 at 1:06

Attachments:

GoogleCodeExporter commented 9 years ago 
Padmini - has received all orders except Myrtleford.  That is being sent today. 
 Then her order is complete.

Original comment by ad...@farmhousedirect.com.au on 19 Nov 2012 at 3:00

GoogleCodeExporter commented 9 years ago 
Lisa - Has received all orders now.  Still waiting on refunds from Hope Farm 
and FFM.  (Both producers PP accounts are frozen). HF is going to pay direct to 
her bank.  Im waiting on confirmation from FFM.  She is not going to pursue 
refunds for damaged goods from other producers due to crushed goods.  She 
blames Auspost for rough handling, and said the producers packaging was fine.

Original comment by ad...@farmhousedirect.com.au on 19 Nov 2012 at 3:51

GoogleCodeExporter commented 9 years ago 
Maggie: 
- Re-ordered Myrtleford should be sent tomorrow. 
- Hope Farm - maggie contacted PP and her bank and contested the payment.  As a 
result the payment is stuck in the dispute process in PP.  HF also has their 
account frozen at the moment.  HF have contacted PP and asked them to refund 
Maggie. 
- Little Creek Cheese - Never received either payment, have sent the cheese but 
cannot refund, as they never got the money. Need to find out from Rob what PP 
has found out about this issue?  Should we contact customer and asked if they 
were charged for Little Creek Cheese?

Original comment by moni...@farmhousedirect.com.au on 19 Nov 2012 at 4:01

GoogleCodeExporter commented 9 years ago 
Lesley - order complete

Original comment by moni...@farmhousedirect.com.au on 19 Nov 2012 at 4:04

GoogleCodeExporter commented 9 years ago 
SUMMARY - Issue to be closed.  Final summary. 

Lesley Dean - No further action

Padmini - No further action

Maggie update - No further action 
(Little Creek Cheese being managed via Issue 326.  Hope Farm is going thru a 
standard dispute process and is managing directly with PP and buyer.)

Lisa - No further action
(HF and FFM both paid refund to Lisa directly outside of PP).

Original comment by moni...@farmhousedirect.com.au on 29 Nov 2012 at 12:10