Order Detail

Order, class registration, and linked PayPal/payment import rows.

Back

Order Fields

Old order ID28477 DateMay 30, 2024 ParentLori Harlan Emailharlanlori@gmail.com Payment modepaypal Payment status
Transaction ID

Items

StudentCourseProductAmountStatus
Jess HarlanMock ACT Testing (for June 8, 2024 test)Mock ACT Testing (for June 8, 2024 test)$40.00enrolled

Payment Rows

ProviderTransaction / Payment IDAmountStatusDateOld Payment ID
paypal4PU9524701259761Y$40.002024-05-30 15:24:1328986

Raw Old Order Fields

Old FieldImported Value
comment_date
courseid932
created_at2024-05-30 22:23:24
date1717107804
finish0
id28477
is_deleted0
is_new_order1
live0
onlineclass
ord_comments
order_type0
paid1
paid_resp
paid_status0
parent_id48284
payment_mode4
paypal_post_request{\"CURLOPT_URL\":\"https:\/\/api-m.paypal.com\/v2\/checkout\/orders\",\"CURLOPT_RETURNTRANSFER\":1,\"CURLOPT_POST\":1,\"CURLOPT_POSTFIELDS\":\"{\\"intent\\":\\"CAPTURE\\",\\"application_context\\":{\\"return_url\\":\\"https:\\\/\\\/www.allpencilsdown.com\\\/api\\\/doPayment\\",\\"cancel_url\\":\\"https:\\\/\\\/www.allpencilsdown.com\\\/api\\\/cancelPayment\\"},\\"purchase_units\\":[{\\"reference_id\\":45748006,\\"payee\\":{\\"email_address\\":\\"george@allpencilsdown.com\\"},\\"amount\\":{\\"currency_code\\":\\"USD\\",\\"value\\":40},\\"platform_fees\\":{\\"payee\\":{\\"email_address\\":\\"george@allpencilsdown.com\\"},\\"amount\\":{\\"currency_code\\":\\"USD\\",\\"value\\":2.020000000000000017763568394002504646778106689453125}},\\"payment_instruction\\":{\\"disbursement_mode\\":\\"INSTANT\\"}}]}\",\"headers\":\"[\\"Content-Type: application\\\/json\\",\\"Authorization: Bearer A21AAOkWGzon4h8d-8_ccPAdwN-QysrHdnDh7s3rMVfkKwLCwpHyWwFie2mVlyffH312QN7D_Ll2ki5mYHuNPAXS4KeCWvC_Q\\",\\"Content-Length: 540\\"]\"}
paypal_response{\"id\":\"4PU9524701259761Y\",\"status\":\"COMPLETED\",\"payment_source\":{\"paypal\":{\"email_address\":\"harlanlori@gmail.com\",\"account_id\":\"W2KBC69YLJHBG\",\"account_status\":\"VERIFIED\",\"name\":{\"given_name\":\"Lori\",\"surname\":\"Harlan\"},\"address\":{\"country_code\":\"US\"}}},\"purchase_units\":[{\"reference_id\":\"45748006\",\"shipping\":{\"name\":{\"full_name\":\"Lori Harlan\"},\"address\":{\"address_line_1\":\"112 Tall Timber Rd.\",\"admin_area_2\":\"Alabaster\",\"admin_area_1\":\"AL\",\"postal_code\":\"35007\",\"country_code\":\"US\"}},\"payments\":{\"captures\":[{\"id\":\"29M10753V6927204A\",\"status\":\"COMPLETED\",\"amount\":{\"currency_code\":\"USD\",\"value\":\"40.00\"},\"final_capture\":true,\"seller_protection\":{\"status\":\"ELIGIBLE\",\"dispute_categories\":[\"ITEM_NOT_RECEIVED\",\"UNAUTHORIZED_TRANSACTION\"]},\"seller_receivable_breakdown\":{\"gross_amount\":{\"currency_code\":\"USD\",\"value\":\"40.00\"},\"paypal_fee\":{\"currency_code\":\"USD\",\"value\":\"1.89\"},\"net_amount\":{\"currency_code\":\"USD\",\"value\":\"38.11\"}},\"links\":[{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/29M10753V6927204A\",\"rel\":\"self\",\"method\":\"GET\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/29M10753V6927204A\/refund\",\"rel\":\"refund\",\"method\":\"POST\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/4PU9524701259761Y\",\"rel\":\"up\",\"method\":\"GET\"}],\"create_time\":\"2024-05-30T22:24:13Z\",\"update_time\":\"2024-05-30T22:24:13Z\"}]}}],\"payer\":{\"name\":{\"given_name\":\"Lori\",\"surname\":\"Harlan\"},\"email_address\":\"harlanlori@gmail.com\",\"payer_id\":\"W2KBC69YLJHBG\",\"address\":{\"country_code\":\"US\"}},\"links\":[{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/4PU9524701259761Y\",\"rel\":\"self\",\"method\":\"GET\"}]}
paypal_token[redacted]
pu_date
sent1
start0
transid
updated_at2024-05-30 22:23:24
userid19082
video_access_date0000-00-00