Analyzes shipped OpenCart orders to compare customer shipping charges against actual
carrier costs recorded in oc_order_shipping_cost. Profit is calculated as
shipping charged minus shipping paid. Only orders with a non-zero recorded shipping
paid value are included. Shipping method labels are normalized by trimming suffixes
at an opening parenthesis, matching legacy grouping behavior.
Profit Status Row Legend (Section 3.4)
table-success)
table-warning)
table-danger)
oc_order.date_added.21021 matching order(s)
| Order ID ▲ | Date | Order Total | Shipping Method | # Products | Total Weight | Shipping Charged | Shipping Paid | Profit |
|---|---|---|---|---|---|---|---|---|
| 233668 | 2025-01-07 | $13.12 | USPS Ground Advantage | 1 | 0.05 lbs | $5.21 | $4.26 | $0.95 |
| 233669 | 2025-01-07 | $14.19 | USPS Ground Advantage | 3 | 0.15 lbs | $5.49 | $4.54 | $0.95 |
| 233673 | 2025-01-08 | $11.73 | USPS Ground Advantage | 1 | 0.05 lbs | $5.53 | $4.58 | $0.95 |
| 233674 | 2025-01-07 | $149.00 | USPS Ground Advantage | 1 | 6.50 lbs | $14.01 | $13.06 | $0.95 |
| 233675 | 2025-01-07 | $16.20 | USPS Ground Advantage | 1 | 0.06 lbs | $5.41 | $4.46 | $0.95 |
| 233676 | 2025-01-07 | $53.55 | USPS Ground Advantage | 2 | 0.06 lbs | $10.82 | $4.46 | $6.36 |
| 233677 | 2025-01-07 | $8.24 | USPS Ground Advantage | 1 | 0.04 lbs | $5.41 | $4.46 | $0.95 |
| 233678 | 2025-01-08 | $9.70 | USPS Ground Advantage | 1 | 0.05 lbs | $5.66 | $4.71 | $0.95 |
| 233679 | 2025-01-08 | $10.29 | USPS Ground Advantage | 1 | 0.03 lbs | $5.53 | $4.58 | $0.95 |
| 233680 | 2025-01-08 | $10.69 | USPS Ground Advantage | 1 | 0.18 lbs | $4.58 | $4.62 | $-0.04 |
| 233681 | 2025-01-09 | $15.37 | USPS Ground Advantage | 1 | 0.20 lbs | $5.32 | $4.37 | $0.95 |
| 233682 | 2025-01-08 | $12.85 | USPS Ground Advantage | 1 | 0.19 lbs | $5.21 | $4.38 | $0.83 |
| 233683 | 2025-01-08 | $26.98 | USPS Ground Advantage | 1 | 0.45 lbs | $5.57 | $5.56 | $0.01 |
| 233684 | 2025-01-10 | $27.39 | USPS Ground Advantage | 1 | 0.45 lbs | $5.98 | $5.03 | $0.95 |
| 233685 | 2025-01-10 | $29.33 | USPS Ground Advantage | 1 | 0.03 lbs | $5.04 | $4.09 | $0.95 |
| 233686 | 2025-01-10 | $10.37 | USPS Ground Advantage | 1 | 0.18 lbs | $4.26 | $4.26 | $0.00 |
| 233687 | 2025-01-11 | $11.45 | USPS Ground Advantage | 1 | 0.05 lbs | $5.11 | $4.16 | $0.95 |
| 233688 | 2025-01-11 | $9.72 | USPS Ground Advantage | 1 | 0.03 lbs | $5.21 | $4.26 | $0.95 |
| 233689 | 2025-01-11 | $121.67 | USPS Ground Advantage | 1 | 3.38 lbs | $6.93 | $6.20 | $0.73 |
| 233690 | 2025-01-11 | $33.02 | USPS Ground Advantage | 2 | 0.47 lbs | $5.50 | $5.39 | $0.11 |
| 233691 | 2025-01-11 | $32.70 | USPS Ground Advantage | 2 | 0.10 lbs | $5.66 | $5.03 | $0.63 |
| 233692 | 2025-01-10 | $30.45 | USPS Ground Advantage | 1 | 0.80 lbs | $6.88 | $5.01 | $1.87 |
| 233693 | 2025-01-10 | $60.36 | USPS Ground Advantage | 1 | 7.00 lbs | $13.21 | $12.46 | $0.75 |
| 233694 | 2025-01-10 | $36.29 | USPS Ground Advantage | 1 | 1.18 lbs | $9.30 | $8.35 | $0.95 |
| 233695 | 2025-01-10 | $44.73 | USPS Ground Advantage | 1 | 0.56 lbs | $6.04 | $5.09 | $0.95 |
| 233696 | 2025-01-12 | $28.87 | USPS Ground Advantage | 2 | 2.20 lbs | $10.53 | $8.30 | $2.23 |
| 233697 | 2025-01-12 | $66.34 | USPS Ground Advantage | 7 | 6.21 lbs | $31.17 | $14.40 | $16.77 |
| 233698 | 2025-01-12 | $55.40 | USPS Ground Advantage | 1 | 2.10 lbs | $9.51 | $8.56 | $0.95 |
| 233699 | 2025-01-12 | $17.45 | USPS Ground Advantage | 2 | 0.70 lbs | $6.45 | $7.61 | $-1.16 |
| 233700 | 2025-01-12 | $16.70 | UPS Ground | 1 | 0.05 lbs | $9.59 | $8.07 | $1.52 |
| 233701 | 2025-01-11 | $24.54 | USPS Ground Advantage | 1 | 0.40 lbs | $5.42 | $4.47 | $0.95 |
| 233702 | 2025-01-11 | $9.56 | USPS Ground Advantage | 1 | 0.18 lbs | $4.37 | $4.43 | $-0.06 |
| 233703 | 2025-01-13 | $122.75 | USPS Ground Advantage | 1 | 4.85 lbs | $8.01 | $6.56 | $1.45 |
| 233705 | 2025-01-14 | $11.99 | USPS Ground Advantage | 1 | 0.05 lbs | $5.49 | $4.54 | $0.95 |
| 233706 | 2025-01-13 | $51.69 | USPS Ground Advantage | 3 | 2.75 lbs | $10.53 | $9.30 | $1.23 |
| 233707 | 2025-01-13 | $18.53 | USPS Ground Advantage | 1 | 0.20 lbs | $5.53 | $4.62 | $0.91 |
| 233708 | 2025-01-13 | $60.65 | USPS Ground Advantage | 1 | 1.06 lbs | $8.64 | $7.69 | $0.95 |
| 233709 | 2025-01-14 | $16.40 | USPS Ground Advantage | 1 | 0.15 lbs | $5.01 | $4.68 | $0.33 |
| 233710 | 2025-01-14 | $34.94 | USPS Ground Advantage | 1 | 0.13 lbs | $5.11 | $4.16 | $0.95 |
| 233711 | 2025-01-14 | $21.74 | USPS Ground Advantage | 1 | 0.45 lbs | $5.53 | $4.78 | $0.75 |
| 233712 | 2025-01-15 | $11.35 | USPS Ground Advantage | 1 | 0.35 lbs | $5.85 | $4.90 | $0.95 |
| 233713 | 2025-01-15 | $24.32 | USPS Ground Advantage | 1 | 1.50 lbs | $9.87 | $9.37 | $0.50 |
| 233714 | 2025-01-14 | $343.92 | USPS Ground Advantage | 9 | 8.85 lbs | $25.74 | $11.21 | $14.53 |
| 233715 | 2025-01-14 | $16.72 | USPS Ground Advantage | 1 | 0.15 lbs | $5.33 | $4.58 | $0.75 |
| 233716 | 2025-01-14 | $11.57 | USPS Ground Advantage | 1 | 0.50 lbs | $5.23 | $4.14 | $1.09 |
| 233717 | 2025-01-14 | $61.52 | USPS Ground Advantage | 1 | 1.06 lbs | $9.51 | $8.56 | $0.95 |
| 233718 | 2025-01-15 | $29.07 | USPS Ground Parcel or Priority Mail | 1 | 3.10 lbs | $8.98 | $6.88 | $2.10 |
| 233719 | 2025-01-05 | $11.07 | USPS First Class | 1 | 0.10 lbs | $4.58 | $4.58 | $0.00 |
| 233720 | 2025-01-15 | $14.91 | Priority Mail Flat Rate Envelope | 1 | 0.20 lbs | $10.10 | $8.68 | $1.42 |
| 233721 | 2025-01-16 | $12.75 | USPS Ground Advantage | 1 | 0.05 lbs | $5.49 | $4.54 | $0.95 |
| 233722 | 2025-01-16 | $19.33 | USPS Ground Advantage | 1 | 0.40 lbs | $5.57 | $5.56 | $0.01 |
| 233724 | 2025-01-15 | $52.64 | USPS Ground Advantage | 1 | 0.55 lbs | $6.75 | $5.80 | $0.95 |
| 233725 | 2025-01-16 | $13.09 | USPS Ground Advantage | 3 | 0.09 lbs | $5.53 | $4.58 | $0.95 |
| 233726 | 2025-01-16 | $30.14 | USPS Ground Advantage | 1 | 1.60 lbs | $7.58 | $6.53 | $1.05 |
| 233727 | 2025-01-16 | $9.38 | USPS Ground Advantage | 1 | 0.18 lbs | $5.41 | $4.47 | $0.94 |
| 233728 | 2025-01-17 | $9.37 | USPS Ground Advantage | 1 | 0.03 lbs | $5.32 | $4.37 | $0.95 |
| 233729 | 2025-01-17 | $125.84 | USPS Ground Advantage | 1 | 6.50 lbs | $11.10 | $9.04 | $2.06 |
| 233730 | 2025-01-16 | $12.41 | USPS Ground Advantage | 1 | 0.06 lbs | $5.53 | $4.58 | $0.95 |
| 233731 | 2025-01-16 | $34.87 | USPS Ground Advantage | 1 | 0.58 lbs | $5.96 | $5.21 | $0.75 |
| 233732 | 2025-01-16 | $9.73 | USPS Ground Advantage | 1 | 0.18 lbs | $4.54 | $4.71 | $-0.17 |
| 233733 | 2025-01-17 | $8.47 | USPS Ground Advantage | 1 | 0.02 lbs | $5.49 | $4.33 | $1.16 |
| 233734 | 2025-01-17 | $9.14 | USPS Ground Advantage | 1 | 0.05 lbs | $5.32 | $4.14 | $1.18 |
| 233735 | 2025-01-18 | $30.22 | USPS Ground Advantage | 1 | 0.74 lbs | $6.51 | $8.71 | $-2.20 |
| 233736 | 2025-01-18 | $10.80 | USPS Ground Advantage | 1 | 0.05 lbs | $5.53 | $4.51 | $1.02 |
| 233737 | 2025-01-18 | $14.07 | USPS Ground Advantage | 1 | 0.20 lbs | $5.53 | $4.51 | $1.02 |
| 233738 | 2025-01-20 | $60.53 | USPS Ground Advantage | 1 | 1.06 lbs | $8.52 | $7.57 | $0.95 |
| 233739 | 2025-01-19 | $23.76 | USPS Ground Advantage | 4 | 1.82 lbs | $7.48 | $6.93 | $0.55 |
| 233740 | 2025-01-19 | $19.88 | USPS Ground Advantage | 2 | 0.50 lbs | $5.66 | $6.57 | $-0.91 |
| 233741 | 2025-01-19 | $38.25 | USPS Ground Advantage | 1 | 0.90 lbs | $7.35 | $7.57 | $-0.22 |
| 233742 | 2025-01-19 | $8.90 | USPS Ground Advantage | 1 | 0.03 lbs | $5.46 | $4.51 | $0.95 |
| 233743 | 2025-01-18 | $52.52 | USPS Ground Advantage | 1 | 1.35 lbs | $9.30 | $8.24 | $1.06 |
| 233744 | 2025-01-18 | $15.23 | USPS Ground Advantage | 1 | 0.10 lbs | $5.29 | $4.33 | $0.96 |
| 233746 | 2025-01-20 | $122.51 | USPS Ground Advantage | 1 | 3.38 lbs | $7.77 | $7.36 | $0.41 |
| 233747 | 2025-01-20 | $16.17 | USPS Ground Advantage | 1 | 0.70 lbs | $5.47 | $4.52 | $0.95 |
| 233749 | 2025-01-21 | $17.95 | USPS Ground Advantage | 1 | 0.30 lbs | $5.79 | $4.84 | $0.95 |
| 233750 | 2025-01-20 | $9.51 | USPS Ground Advantage | 1 | 0.05 lbs | $4.93 | $3.98 | $0.95 |
| 233751 | 2025-01-20 | $54.34 | USPS Ground Advantage | 2 | 1.25 lbs | $14.65 | $8.24 | $6.41 |
| 233752 | 2025-01-20 | $9.52 | USPS Ground Advantage | 1 | 0.18 lbs | $4.33 | $4.71 | $-0.38 |
| 233753 | 2025-01-20 | $142.68 | USPS Ground Advantage | 2 | 2.30 lbs | $12.66 | $9.39 | $3.27 |
| 233754 | 2025-01-21 | $45.27 | USPS Ground Advantage | 1 | 1.45 lbs | $7.10 | $6.15 | $0.95 |
| 233755 | 2025-01-21 | $51.49 | USPS Ground Advantage | 1 | 7.00 lbs | $11.41 | $11.35 | $0.06 |
| 233756 | 2025-01-21 | $10.09 | USPS Ground Advantage | 1 | 0.03 lbs | $5.20 | $4.25 | $0.95 |
| 233757 | 2025-01-21 | $7.72 | USPS Ground Advantage | 1 | 0.04 lbs | $5.28 | $4.33 | $0.95 |
| 233758 | 2025-01-22 | $21.67 | USPS Ground Advantage | 1 | 0.45 lbs | $5.46 | $4.71 | $0.75 |
| 233759 | 2025-01-23 | $27.34 | USPS Ground Advantage | 2 | 1.25 lbs | $7.48 | $6.45 | $1.03 |
| 233760 | 2025-01-23 | $47.36 | USPS Ground Advantage | 1 | 1.45 lbs | $9.19 | $8.24 | $0.95 |
| 233761 | 2025-01-22 | $8.86 | USPS Ground Advantage | 1 | 0.05 lbs | $5.20 | $4.25 | $0.95 |
| 233762 | 2025-01-23 | $14.59 | USPS Ground Advantage | 1 | 0.12 lbs | $5.03 | $4.08 | $0.95 |
| 233763 | 2025-01-23 | $7.11 | USPS Ground Advantage | 1 | 0.01 lbs | $5.20 | $4.25 | $0.95 |
| 233764 | 2025-01-23 | $20.60 | USPS Ground Advantage | 2 | 0.12 lbs | $5.46 | $4.51 | $0.95 |
| 233765 | 2025-01-23 | $128.98 | USPS Ground Advantage | 1 | 6.50 lbs | $14.24 | $12.75 | $1.49 |
| 233766 | 2025-01-24 | $35.11 | USPS Ground Advantage | 1 | 0.13 lbs | $5.28 | $4.71 | $0.57 |
| 233767 | 2025-01-24 | $12.92 | USPS Ground Advantage | 1 | 0.07 lbs | $5.28 | $4.33 | $0.95 |
| 233768 | 2025-01-25 | $47.47 | USPS Ground Advantage | 4 | 4.40 lbs | $14.87 | $9.39 | $5.48 |
| 233769 | 2025-01-24 | $8.37 | USPS Ground Advantage | 1 | 0.03 lbs | $4.93 | $3.98 | $0.95 |
| 233770 | 2025-01-24 | $9.67 | USPS Ground Advantage | 1 | 0.05 lbs | $5.09 | $4.14 | $0.95 |
| 233771 | 2025-01-24 | $20.01 | USPS Ground Advantage | 2 | 0.45 lbs | $10.92 | $5.80 | $5.12 |
| 233772 | 2025-01-24 | $8.51 | USPS Ground Advantage | 1 | 0.05 lbs | $5.46 | $4.51 | $0.95 |
| 233773 | 2025-01-24 | $14.94 | USPS Ground Advantage | 1 | 0.10 lbs | $5.00 | $4.25 | $0.75 |
| 233774 | 2025-01-24 | $49.84 | USPS Ground Advantage | 1 | 1.25 lbs | $7.77 | $6.82 | $0.95 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |