search

mozilla / donate.mozilla.org

Mozilla donation platform
https://donate.mozilla.org
Mozilla Public License 2.0
64 stars 48 forks source link

QA Stripe Dispute and Refunds vs. SFDC Data #1954

Open desiree-mofo opened 6 years ago

desiree-mofo commented 6 years ago

We need to QA refund and dispute data from Stripe to make sure all of the records getting into SFDC. There's only 1 duplicate and 1 fraudulent transaction found in SFDC, which seems low for the last few months.

@vojtechmzl - if you can pull the following transactions for the last 90 days for the following status and reason codes and FTP it over, I can compare it to what's in SFDC to determine the next steps

Donations that were disputed (Dispute reason in ('duplicate','fraudulent', 'subscription_canceled', 'product_unacceptable','product_not_received','unrecognized','credit_not_processed', 'general','incorrect_account_details','insufficient_funds','bank_cannot_process', 'debit_not_authorized','customer_initiated') AND Status in ('charge_refunded','won','lost'))

Donations that were refunded (refund code in ('duplicate','fraudulent','requested_by_customer') AND Status in ('succeeded','failed','cancelled'))

**I don't think we are pulling in bank declined codes, yet - @cadecairos can you verify? Bank declined codes in ('do_not_honor','expired_card','incorrect_number', 'insufficient_funds','pickup_card','processing_error')

vojtechsedlak commented 6 years ago

Hi Desiree, I just uploaded a file with disputed and refunded donations from the last 90 days to the SFMC FTP server (Export/180129_disputedPayments.csv). Please let me know if there is anything else I can help with. Thanks!

desiree-mofo commented 6 years ago

In the past, @stephaniemcv has had to pull this file for me b/c it's not an FTP server that I have access to (I only have access to Brick FTP). Can someone please enlighten me on the FTP servers so I can figure out how to get the file? Thank you @vojtechmzl for pulling this this file so quickly. You rock!!!

vojtechsedlak commented 6 years ago

Hi Desiree, I tried uploading the file to Brick FTP /etl/Moz SFDC Data Team Extract/ folder. I don't have access to other folders, so apologies if that is a random folder used for other things.

cadecairos commented 6 years ago

According to Stripe webhook and Sawmill logs, disputes are being set along to basket.

desiree-mofo commented 6 years ago

SFDC report indicates that there are still fewer fraudulent and disputed records. @stephaniemcv is pulling a file from Stripe, will compare this to the report and find any outliers.

cadecairos commented 5 years ago

@desiree-mofo can we close this issue or is there still outstanding work to be done here?