This page identifies eBay orders where shipping profit exceeds $2.00 and calculates the refund amount as Diff − $2.00, where Diff = Shipping Charged − Shipping Paid − eBay Fees.
Operational Purpose
- Scan shipped eBay orders (`store_id = 5`, `order_status_id = 3`) from the last 90 days (or filtered date range).
- Compare buyer shipping charged (`oc_order_total`) against actual outbound cost (`oc_order_shipping_cost`) and eBay fee allocation (`pd_ebay_payouts`).
- Display orders where Diff ≥ $2.00 and suggested refund ≥ $1.00.
- Auto-record sub-threshold orders in `pd_ebay_refund_shipping` with a $0 refund so they do not reappear.
- Allow operators to save refund amounts, enter eBay Refund IDs, and optionally email the customer.
eBay Seller Hub Steps
- Search eBay Orders and match the Subtotal with eBay's Sold For amount.
- Under Actions, select Send Refund.
- Select reason Shipping Discount.
- Enter the refund amount in Other Level Refund, select Review Refund, then press Send Refund.
- Enter the Refund ID in this program and click Send Email or Update Refund.
Database Targets
pd_ebay_refund_shipping — insert/update refund amount, transaction ID, and processing flags.oc_order_history — insert-only audit comment when refund amount > $0.oc_order, oc_order_total, oc_order_shipping_cost, pd_ebay_payouts — read-only sources for calculations.
Helper Dependencies
mysql_tools.php — prepared statements, `InsertRecord()`, `UpdateTable()`.sendOrderEmail.php — `SendOrderEmail()` template 39 for customer notification.refundEbayUpdate.php — downstream reconciliation when refunds post to the merchant account.