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 |
|---|---|---|---|---|---|---|---|---|
| 234687 | 2025-12-02 | $25.99 | USPS Ground Advantage | 1 | 0.25 lbs | $6.02 | $5.32 | $0.70 |
| 234688 | 2025-12-02 | $34.49 | Priority Mail Flat Rate Envelope | 1 | 0.35 lbs | $11.50 | $10.40 | $1.10 |
| 234689 | 2025-12-03 | $46.35 | USPS Ground Advantage | 1 | 13.50 lbs | $15.55 | $14.60 | $0.95 |
| 234690 | 2025-12-02 | $31.52 | USPS Ground Advantage | 1 | 0.08 lbs | $6.06 | $4.76 | $1.30 |
| 234691 | 2025-12-02 | $11.16 | USPS Ground Advantage | 1 | 0.05 lbs | $5.95 | $4.65 | $1.30 |
| 234692 | 2025-12-08 | $19.69 | USPS Ground Advantage | 1 | 0.31 lbs | $6.10 | $5.15 | $0.95 |
| 234693 | 2025-12-07 | $32.35 | USPS Ground Advantage | 1 | 0.40 lbs | $6.09 | $5.71 | $0.38 |
| 234694 | 2025-12-07 | $14.59 | USPS Ground Advantage | 1 | 0.07 lbs | $6.10 | $4.80 | $1.30 |
| 234695 | 2025-12-07 | $17.30 | USPS Ground Advantage | 2 | 0.10 lbs | $6.50 | $5.55 | $0.95 |
| 234696 | 2025-12-07 | $10.23 | USPS Ground Advantage | 1 | 0.45 lbs | $6.67 | $5.37 | $1.30 |
| 234697 | 2025-12-09 | $10.87 | USPS Ground Advantage | 1 | 0.05 lbs | $5.95 | $4.65 | $1.30 |
| 234698 | 2025-12-12 | $15.26 | USPS Ground Advantage | 1 | 0.05 lbs | $5.92 | $4.92 | $1.00 |
| 234699 | 2025-12-13 | $27.69 | Priority Mail Flat Rate Envelope | 1 | 0.10 lbs | $11.50 | $10.86 | $0.64 |
| 234700 | 2025-12-15 | $44.79 | USPS Ground Advantage | 4 | 2.50 lbs | $11.67 | $10.67 | $1.00 |
| 234701 | 2025-12-14 | $38.90 | USPS Ground Advantage | 1 | 0.13 lbs | $5.76 | $5.09 | $0.67 |
| 234702 | 2025-12-14 | $10.48 | USPS Ground Advantage | 9 | 0.27 lbs | $53.38 | $5.32 | $48.06 |
| 234704 | 2025-12-13 | $12.27 | USPS Ground Advantage | 1 | 0.03 lbs | $5.65 | $4.65 | $1.00 |
| 234705 | 2025-12-13 | $15.50 | USPS Ground Advantage | 1 | 0.50 lbs | $6.16 | $6.83 | $-0.67 |
| 234706 | 2025-12-13 | $14.41 | USPS Ground Advantage | 1 | 0.07 lbs | $5.92 | $4.92 | $1.00 |
| 234707 | 2025-12-13 | $10.44 | USPS Ground Advantage | 1 | 0.05 lbs | $6.20 | $5.20 | $1.00 |
| 234708 | 2025-12-13 | $19.60 | USPS Ground Advantage | 1 | 0.35 lbs | $6.09 | $5.09 | $1.00 |
| 234709 | 2025-12-12 | $41.58 | USPS Ground Advantage | 1 | 1.30 lbs | $7.59 | $6.59 | $1.00 |
| 234710 | 2025-12-12 | $19.15 | USPS Ground Advantage | 1 | 0.35 lbs | $6.15 | $5.37 | $0.78 |
| 234711 | 2025-12-15 | $12.83 | USPS Ground Advantage | 3 | 0.09 lbs | $6.20 | $5.20 | $1.00 |
| 234712 | 2025-12-15 | $17.02 | USPS Ground Advantage | 1 | 0.10 lbs | $6.15 | $5.15 | $1.00 |
| 234713 | 2025-12-15 | $87.77 | USPS Ground Advantage | 1 | 5.69 lbs | $11.28 | $10.85 | $0.43 |
| 234714 | 2025-12-15 | $18.69 | USPS Ground Advantage | 1 | 0.20 lbs | $5.95 | $5.24 | $0.71 |
| 234716 | 2025-12-17 | $46.48 | USPS Ground Advantage | 1 | 1.40 lbs | $8.92 | $7.92 | $1.00 |
| 234718 | 2025-12-19 | $57.58 | USPS Ground Advantage | 1 | 1.60 lbs | $7.59 | $6.59 | $1.00 |
| 234719 | 2025-12-19 | $9.82 | USPS Ground Advantage | 1 | 0.05 lbs | $6.00 | $5.00 | $1.00 |
| 234720 | 2025-12-18 | $66.40 | USPS Ground Advantage | 1 | 1.75 lbs | $7.59 | $6.59 | $1.00 |
| 234721 | 2025-12-18 | $23.63 | USPS Ground Advantage | 1 | 1.50 lbs | $7.49 | $6.54 | $0.95 |
| 234722 | 2025-12-18 | $29.52 | USPS Ground Advantage | 1 | 0.35 lbs | $6.41 | $5.41 | $1.00 |
| 234723 | 2025-12-18 | $12.70 | USPS Ground Advantage | 1 | 0.10 lbs | $5.65 | $4.65 | $1.00 |
| 234724 | 2025-12-18 | $10.04 | USPS Ground Advantage | 1 | 0.05 lbs | $5.80 | $4.80 | $1.00 |
| 234727 | 2025-12-19 | $15.12 | USPS Ground Advantage | 1 | 0.19 lbs | $6.20 | $5.20 | $1.00 |
| 234728 | 2025-12-20 | $33.20 | USPS Ground Advantage | 1 | 0.74 lbs | $6.86 | $6.84 | $0.02 |
| 234729 | 2025-12-19 | $64.84 | USPS Ground Advantage | 1 | 1.81 lbs | $10.70 | $9.70 | $1.00 |
| 234730 | 2025-12-19 | $24.62 | USPS Ground Advantage | 4 | 0.20 lbs | $11.90 | $4.95 | $6.95 |
| 234731 | 2025-12-19 | $11.55 | USPS Ground Advantage | 1 | 0.05 lbs | $5.69 | $4.69 | $1.00 |
| 234732 | 2025-12-19 | $52.62 | USPS Ground Advantage | 1 | 1.25 lbs | $8.17 | $7.17 | $1.00 |
| 234733 | 2025-12-19 | $10.17 | USPS Ground Advantage | 1 | 0.05 lbs | $5.76 | $4.76 | $1.00 |
| 234734 | 2025-12-19 | $178.07 | USPS Ground Advantage | 1 | 2.19 lbs | $9.58 | $10.76 | $-1.18 |
| 234737 | 2025-12-21 | $13.05 | USPS Ground Advantage | 1 | 0.15 lbs | $6.00 | $5.00 | $1.00 |
| 234738 | 2025-12-21 | $80.14 | USPS Ground Advantage | 1 | 5.69 lbs | $11.30 | $10.88 | $0.42 |
| 234739 | 2025-12-20 | $12.20 | USPS Ground Advantage | 1 | 0.36 lbs | $6.26 | $5.26 | $1.00 |
| 234740 | 2025-12-20 | $75.07 | USPS Ground Advantage | 1 | 9.24 lbs | $13.88 | $13.25 | $0.63 |
| 234741 | 2025-12-22 | $13.05 | USPS Ground Advantage | 1 | 0.05 lbs | $6.00 | $5.00 | $1.00 |
| 234742 | 2025-12-22 | $22.10 | USPS Ground Advantage | 1 | 0.55 lbs | $7.32 | $7.45 | $-0.13 |
| 234743 | 2025-12-22 | $15.61 | USPS Ground Advantage | 3 | 0.15 lbs | $5.95 | $4.95 | $1.00 |
| 234744 | 2025-12-22 | $11.66 | USPS Ground Advantage | 1 | 0.05 lbs | $5.80 | $4.80 | $1.00 |
| 234745 | 2025-12-23 | $11.81 | USPS Ground Advantage | 1 | 0.10 lbs | $5.87 | $4.87 | $1.00 |
| 234746 | 2025-12-24 | $24.58 | USPS Ground Advantage | 1 | 0.18 lbs | $5.80 | $4.80 | $1.00 |
| 234747 | 2025-12-23 | $10.92 | USPS Ground Advantage | 1 | 0.10 lbs | $5.65 | $4.65 | $1.00 |
| 234748 | 2025-12-23 | $107.47 | USPS Ground Advantage | 1 | 1.35 lbs | $8.17 | $7.17 | $1.00 |
| 234749 | 2025-12-23 | $27.04 | USPS Ground Advantage | 1 | 0.30 lbs | $6.65 | $5.55 | $1.10 |
| 234750 | 2025-12-26 | $45.52 | USPS Ground Advantage | 1 | 0.50 lbs | $5.58 | $5.83 | $-0.25 |
| 234751 | 2025-12-26 | $56.72 | USPS Ground Advantage | 1 | 2.25 lbs | $9.98 | $10.08 | $-0.10 |
| 234752 | 2025-12-24 | $12.05 | USPS Ground Advantage | 2 | 0.30 lbs | $6.37 | $5.37 | $1.00 |
| 234754 | 2025-12-27 | $23.74 | USPS Ground Advantage | 1 | 0.90 lbs | $7.83 | $6.83 | $1.00 |
| 234755 | 2025-12-27 | $11.73 | USPS Ground Advantage | 1 | 0.05 lbs | $5.87 | $4.87 | $1.00 |
| 234756 | 2025-12-26 | $63.40 | USPS Ground Advantage | 1 | 1.20 lbs | $10.03 | $8.93 | $1.10 |
| 234757 | 2025-12-29 | $19.35 | USPS Ground Advantage | 4 | 1.80 lbs | $8.67 | $7.67 | $1.00 |
| 234758 | 2025-12-29 | $13.59 | USPS Ground Advantage | 1 | 0.05 lbs | $5.95 | $4.95 | $1.00 |
| 234759 | 2025-12-28 | $9.95 | USPS Ground Advantage | 1 | 0.05 lbs | $5.54 | $4.54 | $1.00 |
| 234760 | 2025-12-28 | $54.91 | USPS Ground Advantage | 1 | 1.40 lbs | $8.17 | $7.67 | $0.50 |
| 234761 | 2025-12-28 | $45.14 | USPS Ground Advantage | 2 | 0.62 lbs | $6.90 | $6.83 | $0.07 |
| 234762 | 2025-12-28 | $55.88 | USPS Ground Advantage | 1 | 1.40 lbs | $9.14 | $8.14 | $1.00 |
| 234763 | 2025-12-27 | $9.55 | USPS Ground Advantage | 1 | 0.40 lbs | $6.16 | $5.90 | $0.26 |
| 234764 | 2025-12-27 | $28.09 | USPS Ground Advantage | 1 | 0.18 lbs | $6.00 | $5.41 | $0.59 |
| 234765 | 2025-12-27 | $220.04 | USPS Ground Advantage | 1 | 14.05 lbs | $23.74 | $24.82 | $-1.08 |
| 234766 | 2025-12-31 | $45.10 | USPS Ground Advantage | 2 | 0.62 lbs | $6.86 | $5.86 | $1.00 |
| 234767 | 2025-12-30 | $11.96 | USPS Ground Advantage | 1 | 0.25 lbs | $5.76 | $5.09 | $0.67 |
| 234768 | 2025-12-30 | $12.42 | USPS Ground Advantage | 1 | 0.05 lbs | $5.80 | $4.80 | $1.00 |
| 234769 | 2025-12-30 | $19.63 | USPS Ground Advantage | 1 | 0.20 lbs | $5.87 | $5.15 | $0.72 |
| 234770 | 2025-12-30 | $19.40 | USPS Ground Advantage | 4 | 0.80 lbs | $11.00 | $9.74 | $1.26 |
| 234771 | 2025-12-29 | $24.70 | USPS Ground Advantage | 1 | 0.18 lbs | $5.92 | $4.92 | $1.00 |
| 234772 | 2025-12-31 | $55.82 | USPS Ground Advantage | 1 | 1.27 lbs | $9.08 | $8.08 | $1.00 |
| 234773 | 2026-01-01 | $23.80 | USPS Ground Advantage | 1 | 1.50 lbs | $10.08 | $9.13 | $0.95 |
| 234774 | 2025-12-31 | $16.63 | USPS Ground Advantage | 1 | 0.05 lbs | $5.76 | $4.76 | $1.00 |
| 234775 | 2026-01-01 | $11.24 | USPS Ground Advantage | 2 | 0.06 lbs | $12.30 | $5.15 | $7.15 |
| 234777 | 2026-01-01 | $12.70 | USPS Ground Advantage | 1 | 0.15 lbs | $5.65 | $4.65 | $1.00 |
| 234778 | 2026-01-02 | $10.48 | USPS Ground Advantage | 1 | 0.05 lbs | $6.15 | $5.15 | $1.00 |
| 234779 | 2026-01-01 | $14.03 | USPS Ground Advantage | 1 | 0.08 lbs | $5.54 | $4.54 | $1.00 |
| 234780 | 2026-01-01 | $10.68 | USPS Ground Advantage | 1 | 0.05 lbs | $5.76 | $4.76 | $1.00 |
| 234781 | 2026-01-02 | $20.51 | USPS Ground Advantage | 1 | 0.28 lbs | $6.07 | $5.07 | $1.00 |
| 234782 | 2026-01-02 | $14.58 | USPS Ground Advantage | 1 | 0.05 lbs | $5.92 | $4.92 | $1.00 |
| 234783 | 2026-01-02 | $13.17 | USPS Ground Advantage | 8 | 0.58 lbs | $47.60 | $6.18 | $41.42 |
| 234791 | 2026-01-03 | $10.39 | USPS Ground Advantage | 1 | 0.05 lbs | $6.15 | $5.15 | $1.00 |
| 234793 | 2026-01-04 | $8.96 | USPS Ground Advantage | 1 | 0.25 lbs | $6.16 | $4.69 | $1.47 |
| 234794 | 2026-01-04 | $20.31 | USPS Ground Advantage | 1 | 0.25 lbs | $5.87 | $5.15 | $0.72 |
| 234795 | 2026-01-04 | $26.22 | USPS Ground Advantage | 1 | 1.50 lbs | $10.08 | $9.31 | $0.77 |
| 234796 | 2026-01-03 | $27.42 | USPS Ground Advantage | 2 | 0.15 lbs | $11.90 | $4.95 | $6.95 |
| 234798 | 2026-01-05 | $32.86 | USPS Ground Advantage | 6 | 2.40 lbs | $12.94 | $11.94 | $1.00 |
| 234799 | 2026-01-06 | $9.71 | USPS Ground Advantage | 1 | 0.05 lbs | $6.15 | $5.15 | $1.00 |
| 234800 | 2026-01-07 | $27.98 | USPS Ground Advantage | 1 | 0.18 lbs | $6.15 | $5.37 | $0.78 |
| 234801 | 2026-01-08 | $15.47 | USPS Ground Advantage | 1 | 0.30 lbs | $6.24 | $5.24 | $1.00 |
| 234802 | 2026-01-09 | $9.17 | USPS Ground Advantage | 1 | 0.03 lbs | $6.15 | $4.95 | $1.20 |
| 234803 | 2026-01-09 | $212.38 | USPS Ground Advantage | 1 | 14.05 lbs | $16.08 | $17.37 | $-1.29 |
| 234804 | 2026-01-12 | $16.61 | USPS Ground Advantage | 1 | 0.10 lbs | $5.87 | $4.87 | $1.00 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |