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 |
|---|---|---|---|---|---|---|---|---|
| 233775 | 2025-01-24 | $15.30 | USPS Ground Advantage | 1 | 0.19 lbs | $4.98 | $4.71 | $0.27 |
| 233776 | 2025-01-25 | $10.37 | USPS Ground Advantage | 1 | 0.05 lbs | $5.28 | $4.33 | $0.95 |
| 233778 | 2025-01-26 | $15.47 | USPS Ground Advantage | 1 | 0.05 lbs | $5.28 | $4.33 | $0.95 |
| 233779 | 2025-01-26 | $139.03 | USPS Ground Advantage | 22 | 8.73 lbs | $72.75 | $14.92 | $57.83 |
| 233783 | 2025-01-26 | $32.45 | USPS Ground Advantage | 4 | 1.00 lbs | $7.17 | $6.28 | $0.89 |
| 233784 | 2025-01-26 | $11.40 | USPS Ground Advantage | 1 | 0.05 lbs | $5.46 | $4.51 | $0.95 |
| 233785 | 2025-01-25 | $35.01 | USPS Ground Advantage | 4 | 1.00 lbs | $9.73 | $10.09 | $-0.36 |
| 233786 | 2025-01-25 | $17.50 | USPS Ground Advantage | 1 | 0.40 lbs | $5.57 | $4.62 | $0.95 |
| 233787 | 2025-01-25 | $17.98 | USPS Ground Advantage | 1 | 0.30 lbs | $5.52 | $4.57 | $0.95 |
| 233789 | 2025-01-28 | $39.37 | USPS Ground Advantage | 6 | 4.98 lbs | $14.17 | $13.22 | $0.95 |
| 233790 | 2025-01-27 | $21.98 | USPS Ground Advantage | 1 | 1.00 lbs | $9.66 | $10.00 | $-0.34 |
| 233791 | 2025-01-27 | $9.59 | USPS Ground Advantage | 1 | 0.03 lbs | $5.09 | $4.14 | $0.95 |
| 233792 | 2025-01-27 | $17.55 | USPS Ground Advantage | 1 | 0.70 lbs | $5.66 | $7.16 | $-1.50 |
| 233793 | 2025-01-28 | $8.83 | USPS Ground Advantage | 1 | 0.40 lbs | $5.47 | $5.21 | $0.26 |
| 233795 | 2025-01-28 | $15.00 | USPS Ground Advantage | 2 | 0.36 lbs | $4.62 | $5.49 | $-0.87 |
| 233796 | 2025-01-28 | $22.39 | USPS Ground Advantage | 1 | 0.35 lbs | $5.57 | $4.62 | $0.95 |
| 233797 | 2025-01-28 | $23.20 | USPS Ground Advantage | 1 | 0.45 lbs | $5.19 | $4.44 | $0.75 |
| 233799 | 2025-01-30 | $15.28 | USPS Ground Advantage | 1 | 0.05 lbs | $5.09 | $4.14 | $0.95 |
| 233800 | 2025-01-29 | $14.91 | USPS Ground Advantage | 2 | 0.62 lbs | $11.14 | $5.49 | $5.65 |
| 233802 | 2025-01-29 | $13.10 | USPS Ground Advantage | 1 | 0.04 lbs | $5.46 | $4.51 | $0.95 |
| 233803 | 2025-01-29 | $45.80 | USPS Ground Advantage | 1 | 5.00 lbs | $11.61 | $10.66 | $0.95 |
| 233804 | 2025-01-31 | $71.61 | USPS Ground Advantage | 1 | 2.85 lbs | $10.42 | $9.47 | $0.95 |
| 233805 | 2025-01-31 | $12.93 | USPS Ground Advantage | 1 | 0.05 lbs | $5.03 | $4.08 | $0.95 |
| 233808 | 2025-01-31 | $11.14 | USPS Ground Advantage | 1 | 0.05 lbs | $5.28 | $4.33 | $0.95 |
| 233809 | 2025-01-31 | $11.14 | USPS Ground Advantage | 1 | 0.05 lbs | $5.20 | $4.25 | $0.95 |
| 233810 | 2025-01-31 | $16.76 | USPS Ground Advantage | 1 | 0.60 lbs | $6.57 | $4.33 | $2.24 |
| 233811 | 2025-01-31 | $14.45 | USPS Ground Advantage | 1 | 0.06 lbs | $5.28 | $4.33 | $0.95 |
| 233812 | 2025-01-31 | $15.98 | USPS Ground Advantage | 1 | 0.06 lbs | $5.28 | $4.33 | $0.95 |
| 233815 | 2025-01-31 | $49.69 | Priority Mail | 10 | 4.00 lbs | $19.69 | $18.59 | $1.10 |
| 233816 | 2025-02-01 | $20.68 | USPS Ground Advantage | 1 | 0.48 lbs | $5.79 | $7.36 | $-1.57 |
| 233817 | 2025-01-31 | $10.54 | USPS Ground Advantage | 1 | 0.03 lbs | $5.28 | $4.33 | $0.95 |
| 233818 | 2025-02-03 | $22.25 | USPS Ground Advantage | 1 | 0.15 lbs | $5.46 | $4.51 | $0.95 |
| 233819 | 2025-02-02 | $37.04 | USPS Ground Advantage | 2 | 0.97 lbs | $10.24 | $10.12 | $0.12 |
| 233820 | 2025-02-01 | $15.98 | USPS Ground Advantage | 2 | 0.10 lbs | $5.20 | $5.49 | $-0.29 |
| 233821 | 2025-02-01 | $10.25 | USPS Ground Advantage | 1 | 0.04 lbs | $5.46 | $4.51 | $0.95 |
| 233822 | 2025-02-01 | $19.55 | USPS Ground Advantage | 3 | 0.30 lbs | $5.57 | $4.62 | $0.95 |
| 233824 | 2025-02-04 | $20.41 | USPS Ground Advantage | 1 | 0.48 lbs | $5.52 | $6.25 | $-0.73 |
| 233825 | 2025-02-04 | $17.19 | USPS Ground Advantage | 1 | 0.05 lbs | $5.20 | $4.25 | $0.95 |
| 233826 | 2025-02-03 | $28.78 | USPS Ground Advantage | 1 | 0.35 lbs | $5.79 | $4.84 | $0.95 |
| 233827 | 2025-02-03 | $17.02 | USPS Ground Advantage | 1 | 0.14 lbs | $5.03 | $4.52 | $0.51 |
| 233829 | 2025-02-05 | $16.30 | USPS Ground Advantage | 4 | 0.76 lbs | $9.94 | $4.33 | $5.61 |
| 233830 | 2025-02-05 | $34.52 | USPS Ground Advantage | 1 | 0.06 lbs | $5.03 | $4.08 | $0.95 |
| 233831 | 2025-02-06 | $44.56 | USPS Ground Advantage | 1 | 1.20 lbs | $8.17 | $6.57 | $1.60 |
| 233832 | 2025-02-07 | $8.72 | USPS Ground Advantage | 1 | 0.05 lbs | $4.93 | $3.98 | $0.95 |
| 233833 | 2025-02-07 | $14.92 | USPS Ground Advantage | 1 | 0.19 lbs | $5.03 | $4.08 | $0.95 |
| 233834 | 2025-02-06 | $14.42 | USPS Ground Advantage | 1 | 0.06 lbs | $5.03 | $4.08 | $0.95 |
| 233835 | 2025-02-06 | $11.08 | USPS Ground Advantage | 1 | 0.05 lbs | $5.09 | $4.14 | $0.95 |
| 233836 | 2025-02-09 | $23.02 | USPS Ground Advantage | 1 | 0.05 lbs | $5.03 | $4.08 | $0.95 |
| 233837 | 2025-02-09 | $22.45 | USPS Ground Advantage | 1 | 1.00 lbs | $7.96 | $8.58 | $-0.62 |
| 233838 | 2025-02-08 | $11.78 | USPS Ground Advantage | 1 | 0.46 lbs | $5.79 | $4.84 | $0.95 |
| 233839 | 2025-02-08 | $18.39 | USPS Ground Advantage | 1 | 0.19 lbs | $4.90 | $4.25 | $0.65 |
| 233840 | 2025-02-08 | $12.92 | USPS Ground Advantage | 1 | 0.06 lbs | $5.03 | $4.08 | $0.95 |
| 233841 | 2025-02-08 | $11.19 | USPS Ground Advantage | 1 | 0.04 lbs | $5.20 | $4.25 | $0.95 |
| 233842 | 2025-02-10 | $34.75 | USPS Ground Advantage | 2 | 1.40 lbs | $9.57 | $8.24 | $1.33 |
| 233843 | 2025-02-10 | $23.55 | USPS Ground Advantage | 1 | 7.00 lbs | $10.15 | $8.52 | $1.63 |
| 233844 | 2025-02-11 | $13.08 | USPS Ground Advantage | 2 | 0.02 lbs | $5.46 | $4.84 | $0.62 |
| 233845 | 2025-02-11 | $91.63 | USPS Ground Advantage | 6 | 5.49 lbs | $14.17 | $10.16 | $4.01 |
| 233846 | 2025-02-12 | $10.80 | USPS Ground Advantage | 1 | 0.05 lbs | $5.28 | $5.62 | $-0.34 |
| 233847 | 2025-02-12 | $55.48 | USPS Ground Advantage | 1 | 1.25 lbs | $8.74 | $7.79 | $0.95 |
| 233848 | 2025-02-11 | $29.42 | USPS Ground Advantage | 1 | 4.54 lbs | $11.07 | $10.12 | $0.95 |
| 233849 | 2025-02-11 | $31.72 | USPS Ground Advantage | 2 | 0.66 lbs | $11.85 | $5.62 | $6.23 |
| 233850 | 2025-02-11 | $153.68 | USPS Ground Advantage | 1 | 3.38 lbs | $9.19 | $9.39 | $-0.20 |
| 233851 | 2025-02-11 | $22.08 | USPS Ground Advantage | 1 | 0.06 lbs | $5.09 | $4.14 | $0.95 |
| 233852 | 2025-02-11 | $30.40 | USPS Ground Advantage | 1 | 3.15 lbs | $8.31 | $6.88 | $1.43 |
| 233853 | 2025-02-13 | $20.74 | USPS Ground Advantage | 2 | 0.14 lbs | $5.46 | $4.84 | $0.62 |
| 233854 | 2025-02-12 | $79.06 | USPS Ground Advantage | 1 | 2.85 lbs | $11.07 | $10.12 | $0.95 |
| 233856 | 2025-02-12 | $17.57 | USPS Ground Advantage | 3 | 0.30 lbs | $5.66 | $4.71 | $0.95 |
| 233857 | 2025-02-12 | $16.08 | USPS Ground Advantage | 1 | 0.19 lbs | $4.61 | $3.96 | $0.65 |
| 233859 | 2025-02-13 | $15.56 | USPS Ground Advantage | 4 | 0.20 lbs | $5.28 | $4.71 | $0.57 |
| 233860 | 2025-02-13 | $12.09 | USPS Ground Advantage | 1 | 0.64 lbs | $6.57 | $4.71 | $1.86 |
| 233861 | 2025-02-13 | $45.28 | USPS Ground Advantage | 1 | 1.25 lbs | $8.74 | $7.79 | $0.95 |
| 233862 | 2025-02-15 | $46.08 | USPS Ground Advantage | 1 | 1.20 lbs | $8.52 | $7.57 | $0.95 |
| 233863 | 2025-02-15 | $24.68 | UPS Ground | 6 | 0.06 lbs | $7.64 | $6.37 | $1.27 |
| 233864 | 2025-02-14 | $15.39 | USPS Ground Advantage | 1 | 0.14 lbs | $5.20 | $4.25 | $0.95 |
| 233865 | 2025-02-14 | $16.37 | USPS Ground Advantage | 1 | 0.19 lbs | $4.90 | $4.25 | $0.65 |
| 233866 | 2025-02-14 | $16.63 | USPS Ground Advantage | 2 | 0.50 lbs | $5.79 | $7.36 | $-1.57 |
| 233867 | 2025-02-14 | $33.66 | USPS Ground Advantage | 1 | 1.18 lbs | $8.17 | $7.76 | $0.41 |
| 233868 | 2025-02-16 | $16.14 | USPS Ground Advantage | 2 | 0.10 lbs | $5.46 | $4.51 | $0.95 |
| 233869 | 2025-02-16 | $35.12 | USPS Ground Advantage | 4 | 0.80 lbs | $7.96 | $7.36 | $0.60 |
| 233870 | 2025-02-16 | $13.10 | USPS Ground Advantage | 1 | 0.06 lbs | $5.46 | $4.51 | $0.95 |
| 233871 | 2025-02-16 | $6.72 | USPS Ground Advantage | 1 | 0.19 lbs | $5.03 | $4.08 | $0.95 |
| 233872 | 2025-02-16 | $79.06 | USPS Ground Advantage | 1 | 2.85 lbs | $11.07 | $10.12 | $0.95 |
| 233873 | 2025-02-16 | $38.42 | USPS Ground Advantage | 1 | 0.13 lbs | $5.28 | $4.71 | $0.57 |
| 233874 | 2025-02-15 | $45.21 | USPS Ground Advantage | 8 | 3.65 lbs | $12.65 | $11.70 | $0.95 |
| 233875 | 2025-02-15 | $9.91 | USPS Ground Advantage | 1 | 0.18 lbs | $4.14 | $4.57 | $-0.43 |
| 233876 | 2025-02-17 | $20.50 | USPS Ground Advantage | 3 | 0.54 lbs | $5.80 | $5.80 | $0.00 |
| 233877 | 2025-02-17 | $153.68 | USPS Ground Advantage | 1 | 3.38 lbs | $9.19 | $9.39 | $-0.20 |
| 233878 | 2025-02-17 | $50.74 | USPS Ground Advantage | 4 | 1.94 lbs | $10.26 | $8.78 | $1.48 |
| 233879 | 2025-02-17 | $23.12 | USPS Ground Advantage | 1 | 0.40 lbs | $5.79 | $4.84 | $0.95 |
| 233880 | 2025-02-17 | $18.21 | USPS Ground Advantage | 1 | 0.30 lbs | $5.47 | $4.52 | $0.95 |
| 233881 | 2025-02-18 | $8.59 | USPS Ground Advantage | 1 | 0.02 lbs | $5.20 | $4.25 | $0.95 |
| 233882 | 2025-02-18 | $30.53 | USPS Ground Advantage | 1 | 0.06 lbs | $5.46 | $4.51 | $0.95 |
| 233883 | 2025-02-19 | $8.53 | USPS Ground Advantage | 1 | 0.03 lbs | $5.09 | $4.14 | $0.95 |
| 233884 | 2025-02-19 | $12.99 | USPS Ground Advantage | 1 | 0.05 lbs | $5.09 | $4.14 | $0.95 |
| 233885 | 2025-02-18 | $16.20 | USPS Ground Advantage | 1 | 0.19 lbs | $4.73 | $4.08 | $0.65 |
| 233886 | 2025-02-18 | $45.80 | USPS Ground Advantage | 1 | 5.00 lbs | $11.61 | $10.66 | $0.95 |
| 233887 | 2025-02-18 | $57.92 | USPS Ground Advantage | 1 | 1.81 lbs | $9.19 | $8.24 | $0.95 |
| 233888 | 2025-02-19 | $77.18 | USPS Ground Advantage | 1 | 2.85 lbs | $9.19 | $8.24 | $0.95 |
| 233889 | 2025-02-19 | $21.37 | USPS Ground Advantage | 2 | 0.38 lbs | $5.79 | $5.80 | $-0.01 |
| 233890 | 2025-02-20 | $66.31 | USPS Ground Advantage | 1 | 1.06 lbs | $8.52 | $7.57 | $0.95 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |