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 |
|---|---|---|---|---|---|---|---|---|
| 234006 | 2025-03-20 | $52.42 | USPS Ground Advantage | 3 | 2.75 lbs | $7.09 | $10.16 | $-3.07 |
| 234008 | 2025-03-20 | $52.41 | USPS Ground Advantage | 3 | 2.75 lbs | $7.08 | $10.16 | $-3.08 |
| 234009 | 2025-03-20 | $12.92 | USPS Ground Advantage | 1 | 0.15 lbs | $5.46 | $4.51 | $0.95 |
| 234010 | 2025-03-21 | $153.81 | USPS Ground Advantage | 17 | 0.87 lbs | $92.82 | $5.80 | $87.02 |
| 234011 | 2025-03-21 | $30.02 | USPS Ground Advantage | 4 | 0.72 lbs | $10.50 | $8.24 | $2.26 |
| 234012 | 2025-03-21 | $30.18 | USPS Ground Advantage | 4 | 1.76 lbs | $8.62 | $7.36 | $1.26 |
| 234013 | 2025-03-21 | $162.27 | USPS Ground Advantage | 1 | 3.38 lbs | $9.28 | $11.65 | $-2.37 |
| 234014 | 2025-03-24 | $13.67 | USPS Ground Advantage | 1 | 0.04 lbs | $4.86 | $3.91 | $0.95 |
| 234015 | 2025-03-24 | $17.72 | USPS Ground Advantage | 1 | 0.30 lbs | $5.66 | $4.71 | $0.95 |
| 234016 | 2025-03-24 | $15.45 | USPS Ground Advantage | 1 | 0.05 lbs | $5.09 | $4.14 | $0.95 |
| 234017 | 2025-03-23 | $107.56 | USPS Priority Mail | 1 | 1.45 lbs | $8.57 | $7.62 | $0.95 |
| 234018 | 2025-03-23 | $23.08 | USPS Ground Advantage | 2 | 0.10 lbs | $5.28 | $4.33 | $0.95 |
| 234019 | 2025-03-23 | $48.08 | USPS Ground Advantage | 1 | 13.50 lbs | $12.99 | $12.62 | $0.37 |
| 234020 | 2025-03-23 | $18.97 | USPS Ground Advantage | 1 | 0.35 lbs | $5.57 | $4.62 | $0.95 |
| 234021 | 2025-03-22 | $11.23 | USPS Ground Advantage | 1 | 0.18 lbs | $5.12 | $4.62 | $0.50 |
| 234022 | 2025-03-25 | $9.37 | USPS Ground Advantage | 1 | 0.03 lbs | $5.09 | $4.14 | $0.95 |
| 234023 | 2025-03-24 | $13.87 | USPS Ground Advantage | 1 | 1.51 lbs | $7.48 | $6.45 | $1.03 |
| 234024 | 2025-03-25 | $17.95 | USPS Ground Advantage | 4 | 0.12 lbs | $5.03 | $4.08 | $0.95 |
| 234025 | 2025-03-25 | $20.51 | USPS Ground Advantage | 2 | 0.50 lbs | $5.47 | $5.21 | $0.26 |
| 234026 | 2025-03-26 | $38.99 | USPS Ground Advantage | 1 | 0.27 lbs | $5.52 | $4.57 | $0.95 |
| 234028 | 2025-03-26 | $12.55 | USPS Ground Advantage | 1 | 0.15 lbs | $5.09 | $4.14 | $0.95 |
| 234029 | 2025-03-28 | $22.39 | USPS Ground Advantage | 1 | 0.40 lbs | $5.66 | $4.71 | $0.95 |
| 234032 | 2025-03-28 | $18.26 | USPS Ground Advantage | 1 | 0.62 lbs | $6.57 | $5.62 | $0.95 |
| 234033 | 2025-03-29 | $36.70 | USPS Ground Advantage | 1 | 0.40 lbs | $5.66 | $4.71 | $0.95 |
| 234034 | 2025-03-29 | $65.69 | USPS Ground Advantage | 1 | 1.84 lbs | $9.45 | $8.50 | $0.95 |
| 234035 | 2025-03-30 | $14.79 | USPS Ground Advantage | 2 | 0.08 lbs | $5.09 | $4.14 | $0.95 |
| 234036 | 2025-03-29 | $64.86 | USPS Ground Advantage | 1 | 1.38 lbs | $8.17 | $7.22 | $0.95 |
| 234037 | 2025-03-31 | $48.03 | USPS Ground Advantage | 3 | 0.48 lbs | $6.75 | $6.84 | $-0.09 |
| 234038 | 2025-04-01 | $19.52 | USPS Ground Parcel or Priority Mail | 1 | 0.19 lbs | $7.63 | $4.08 | $3.55 |
| 234040 | 2025-04-01 | $10.40 | USPS Ground Advantage | 1 | 0.05 lbs | $5.46 | $4.51 | $0.95 |
| 234041 | 2025-04-01 | $8.08 | USPS Ground Advantage | 1 | 0.06 lbs | $5.03 | $4.08 | $0.95 |
| 234042 | 2025-04-02 | $55.65 | USPS Ground Advantage | 1 | 0.73 lbs | $6.16 | $6.07 | $0.09 |
| 234044 | 2025-04-03 | $10.85 | USPS Ground Advantage | 1 | 0.06 lbs | $5.28 | $4.33 | $0.95 |
| 234045 | 2025-04-02 | $40.39 | USPS Ground Advantage | 7 | 3.19 lbs | $10.22 | $9.27 | $0.95 |
| 234046 | 2025-04-05 | $9.77 | USPS Ground Advantage | 1 | 0.05 lbs | $5.28 | $4.33 | $0.95 |
| 234047 | 2025-04-04 | $13.37 | USPS Ground Advantage | 1 | 0.06 lbs | $5.28 | $4.33 | $0.95 |
| 234048 | 2025-04-06 | $13.92 | USPS Ground Advantage | 1 | 0.05 lbs | $5.20 | $4.25 | $0.95 |
| 234049 | 2025-04-06 | $36.47 | USPS Ground Advantage | 1 | 1.18 lbs | $9.48 | $8.53 | $0.95 |
| 234050 | 2025-04-06 | $10.85 | USPS Ground Advantage | 1 | 0.06 lbs | $5.28 | $4.33 | $0.95 |
| 234051 | 2025-04-06 | $11.29 | USPS Ground Advantage | 1 | 0.35 lbs | $5.47 | $4.52 | $0.95 |
| 234052 | 2025-04-08 | $39.05 | USPS Ground Advantage | 4 | 1.10 lbs | $9.93 | $8.50 | $1.43 |
| 234053 | 2025-04-08 | $24.55 | USPS Ground Advantage | 2 | 0.62 lbs | $6.75 | $5.80 | $0.95 |
| 234054 | 2025-04-09 | $16.78 | USPS Ground Advantage | 2 | 0.25 lbs | $5.46 | $4.84 | $0.62 |
| 234055 | 2025-04-09 | $66.61 | USPS Ground Advantage | 1 | 0.56 lbs | $6.44 | $5.49 | $0.95 |
| 234056 | 2025-04-11 | $11.96 | USPS Ground Advantage | 1 | 0.05 lbs | $4.91 | $3.96 | $0.95 |
| 234057 | 2025-04-11 | $17.59 | USPS Ground Advantage | 1 | 1.10 lbs | $7.40 | $6.29 | $1.11 |
| 234058 | 2025-04-11 | $9.53 | USPS Ground Advantage | 1 | 0.06 lbs | $5.46 | $4.51 | $0.95 |
| 234059 | 2025-04-10 | $14.37 | USPS Ground Advantage | 1 | 0.30 lbs | $5.47 | $4.52 | $0.95 |
| 234061 | 2025-04-12 | $18.02 | USPS Ground Advantage | 1 | 0.22 lbs | $5.28 | $4.71 | $0.57 |
| 234062 | 2025-04-12 | $12.67 | USPS Ground Advantage | 1 | 0.05 lbs | $5.03 | $4.08 | $0.95 |
| 234063 | 2025-04-11 | $13.69 | USPS Ground Advantage | 1 | 0.03 lbs | $5.28 | $4.33 | $0.95 |
| 234064 | 2025-04-11 | $17.09 | USPS Ground Advantage | 1 | 0.20 lbs | $5.20 | $4.62 | $0.58 |
| 234065 | 2025-04-11 | $9.52 | USPS Ground Advantage | 1 | 0.05 lbs | $5.28 | $4.33 | $0.95 |
| 234066 | 2025-04-11 | $10.89 | USPS Ground Advantage | 1 | 0.18 lbs | $5.12 | $4.62 | $0.50 |
| 234067 | 2025-04-11 | $16.07 | USPS Ground Advantage | 1 | 0.15 lbs | $5.20 | $4.25 | $0.95 |
| 234068 | 2025-04-14 | $9.25 | USPS Ground Advantage | 1 | 0.03 lbs | $5.20 | $4.25 | $0.95 |
| 234069 | 2025-04-13 | $11.63 | USPS Ground Advantage | 1 | 0.35 lbs | $5.52 | $4.57 | $0.95 |
| 234070 | 2025-04-13 | $16.45 | USPS Ground Advantage | 1 | 0.60 lbs | $6.26 | $5.31 | $0.95 |
| 234080 | 2025-04-14 | $10.45 | USPS Ground Advantage | 1 | 0.05 lbs | $4.93 | $3.98 | $0.95 |
| 234081 | 2025-04-15 | $74.06 | USPS Ground Advantage | 1 | 5.30 lbs | $12.02 | $11.07 | $0.95 |
| 234082 | 2025-04-15 | $30.13 | USPS Ground Advantage | 1 | 4.75 lbs | $13.31 | $11.70 | $1.61 |
| 234083 | 2025-04-14 | $20.95 | USPS Ground Advantage | 1 | 0.45 lbs | $5.66 | $5.62 | $0.04 |
| 234084 | 2025-04-16 | $12.03 | USPS Ground Advantage | 5 | 0.10 lbs | $5.28 | $3.91 | $1.37 |
| 234085 | 2025-04-16 | $42.71 | USPS Ground Advantage | 4 | 2.50 lbs | $7.39 | $6.33 | $1.06 |
| 234086 | 2025-04-17 | $11.91 | USPS Ground Advantage | 1 | 0.06 lbs | $5.20 | $4.25 | $0.95 |
| 234087 | 2025-04-17 | $23.12 | USPS Ground Advantage | 5 | 1.37 lbs | $9.57 | $4.57 | $5.00 |
| 234088 | 2025-04-16 | $11.82 | USPS Ground Advantage | 1 | 0.10 lbs | $5.28 | $4.33 | $0.95 |
| 234089 | 2025-04-16 | $9.27 | USPS Ground Advantage | 1 | 0.05 lbs | $5.03 | $4.08 | $0.95 |
| 234090 | 2025-04-18 | $18.31 | USPS Ground Advantage | 1 | 0.30 lbs | $5.57 | $4.62 | $0.95 |
| 234091 | 2025-04-18 | $34.95 | USPS Ground Advantage | 3 | 0.81 lbs | $7.02 | $6.29 | $0.73 |
| 234092 | 2025-04-18 | $13.52 | USPS Ground Advantage | 1 | 0.20 lbs | $5.03 | $4.52 | $0.51 |
| 234093 | 2025-04-18 | $7.91 | USPS Ground Advantage | 1 | 0.05 lbs | $4.86 | $3.91 | $0.95 |
| 234094 | 2025-04-19 | $55.93 | USPS Ground Advantage | 1 | 1.25 lbs | $9.19 | $8.24 | $0.95 |
| 234095 | 2025-04-18 | $9.10 | USPS Ground Advantage | 1 | 0.03 lbs | $5.28 | $4.33 | $0.95 |
| 234096 | 2025-04-19 | $10.37 | USPS Ground Advantage | 1 | 0.10 lbs | $5.28 | $4.33 | $0.95 |
| 234097 | 2025-04-20 | $13.10 | USPS Ground Advantage | 1 | 0.06 lbs | $5.46 | $4.51 | $0.95 |
| 234098 | 2025-04-20 | $18.76 | USPS Ground Advantage | 4 | 0.25 lbs | $5.20 | $4.25 | $0.95 |
| 234099 | 2025-04-22 | $14.09 | USPS Ground Advantage | 1 | 0.21 lbs | $5.09 | $4.14 | $0.95 |
| 234100 | 2025-04-23 | $10.71 | USPS Ground Advantage | 1 | 0.18 lbs | $4.94 | $3.98 | $0.96 |
| 234101 | 2025-04-22 | $11.88 | USPS Ground Advantage | 1 | 0.05 lbs | $5.09 | $4.14 | $0.95 |
| 234102 | 2025-04-22 | $11.32 | USPS Ground Advantage | 1 | 0.06 lbs | $5.28 | $4.33 | $0.95 |
| 234103 | 2025-04-25 | $10.43 | USPS Ground Advantage | 3 | 0.03 lbs | $5.03 | $4.08 | $0.95 |
| 234104 | 2025-04-25 | $8.73 | USPS Ground Advantage | 2 | 0.02 lbs | $4.91 | $3.96 | $0.95 |
| 234105 | 2025-04-28 | $9.44 | USPS Ground Advantage | 1 | 0.06 lbs | $5.20 | $4.25 | $0.95 |
| 234106 | 2025-04-27 | $28.68 | USPS Ground Advantage | 1 | 0.30 lbs | $5.57 | $4.62 | $0.95 |
| 234107 | 2025-04-26 | $33.64 | USPS Ground Advantage | 3 | 2.07 lbs | $8.11 | $6.45 | $1.66 |
| 234108 | 2025-04-26 | $40.15 | USPS Ground Advantage | 4 | 2.76 lbs | $8.11 | $6.45 | $1.66 |
| 234110 | 2025-04-25 | $31.03 | USPS Ground Advantage | 4 | 3.32 lbs | $14.23 | $13.28 | $0.95 |
| 234111 | 2025-04-25 | $11.88 | USPS Ground Advantage | 1 | 0.05 lbs | $5.09 | $4.14 | $0.95 |
| 234112 | 2025-04-30 | $29.96 | USPS Ground Advantage | 2 | 2.20 lbs | $11.62 | $7.79 | $3.83 |
| 234113 | 2025-04-30 | $12.51 | USPS Ground Advantage | 1 | 0.15 lbs | $5.46 | $4.51 | $0.95 |
| 234114 | 2025-04-29 | $55.17 | USPS Ground Advantage | 1 | 0.13 lbs | $5.03 | $4.08 | $0.95 |
| 234115 | 2025-05-01 | $16.08 | USPS Ground Advantage | 3 | 0.06 lbs | $5.28 | $4.33 | $0.95 |
| 234116 | 2025-05-01 | $10.45 | USPS Ground Advantage | 1 | 0.22 lbs | $4.93 | $4.63 | $0.30 |
| 234117 | 2025-04-30 | $35.25 | USPS Ground Advantage | 1 | 1.10 lbs | $8.74 | $7.79 | $0.95 |
| 234118 | 2025-05-02 | $49.14 | USPS Ground Advantage | 1 | 1.20 lbs | $8.52 | $7.57 | $0.95 |
| 234119 | 2025-05-02 | $12.25 | USPS Ground Advantage | 1 | 0.10 lbs | $5.20 | $4.25 | $0.95 |
| 234120 | 2025-05-01 | $27.60 | USPS Ground Advantage | 1 | 0.92 lbs | $9.76 | $10.12 | $-0.36 |
| 234121 | 2025-05-02 | $16.15 | USPS Ground Advantage | 1 | 0.15 lbs | $5.28 | $4.33 | $0.95 |
| 234122 | 2025-05-02 | $10.64 | USPS Ground Advantage | 2 | 0.06 lbs | $5.46 | $4.51 | $0.95 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |