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 |
|---|---|---|---|---|---|---|---|---|
| 235037 | 2026-03-13 | $9.04 | USPS Ground Advantage | 1 | 0.03 lbs | $6.07 | $5.07 | $1.00 |
| 235038 | 2026-03-12 | $13.40 | USPS Ground Advantage | 1 | 0.19 lbs | $6.52 | $5.52 | $1.00 |
| 235039 | 2026-03-12 | $12.15 | USPS Ground Advantage | 1 | 0.05 lbs | $6.29 | $5.29 | $1.00 |
| 235040 | 2026-03-12 | $10.92 | USPS Ground Advantage | 1 | 0.06 lbs | $6.68 | $5.68 | $1.00 |
| 235041 | 2026-03-13 | $28.61 | USPS Ground Advantage | 1 | 0.18 lbs | $6.52 | $5.52 | $1.00 |
| 235042 | 2026-03-13 | $11.41 | USPS Ground Advantage | 1 | 0.46 lbs | $6.83 | $5.92 | $0.91 |
| 235043 | 2026-03-14 | $32.81 | USPS Ground Advantage | 1 | 4.75 lbs | $14.12 | $12.41 | $1.71 |
| 235044 | 2026-03-14 | $93.97 | USPS Ground Advantage | 1 | 1.35 lbs | $9.83 | $8.83 | $1.00 |
| 235045 | 2026-03-13 | $10.48 | USPS Ground Advantage | 1 | 0.05 lbs | $6.20 | $5.20 | $1.00 |
| 235046 | 2026-03-16 | $34.26 | USPS Ground Advantage | 8 | 1.52 lbs | $18.18 | $10.71 | $7.47 |
| 235047 | 2026-03-15 | $28.13 | USPS Ground Advantage | 1 | 4.75 lbs | $9.44 | $8.16 | $1.28 |
| 235048 | 2026-03-15 | $15.58 | USPS Ground Advantage | 2 | 0.90 lbs | $8.46 | $7.52 | $0.94 |
| 235049 | 2026-03-16 | $26.29 | USPS Ground Advantage | 1 | 0.92 lbs | $7.17 | $6.18 | $0.99 |
| 235050 | 2026-03-16 | $26.35 | USPS Priority Mail | 1 | 0.40 lbs | $9.53 | $8.53 | $1.00 |
| 235051 | 2026-03-16 | $44.14 | USPS Ground Advantage | 1 | 0.75 lbs | $7.60 | $5.89 | $1.71 |
| 235052 | 2026-03-18 | $43.60 | USPS Ground Advantage | 8 | 2.60 lbs | $22.00 | $12.07 | $9.93 |
| 235053 | 2026-03-18 | $15.03 | USPS Ground Advantage | 1 | 0.50 lbs | $6.62 | $5.62 | $1.00 |
| 235054 | 2026-03-18 | $35.95 | USPS Ground Advantage | 7 | 3.15 lbs | $14.81 | $13.81 | $1.00 |
| 235055 | 2026-03-18 | $12.08 | USPS Ground Advantage | 1 | 0.05 lbs | $6.56 | $5.56 | $1.00 |
| 235056 | 2026-03-17 | $21.32 | USPS Ground Advantage | 3 | 1.35 lbs | $11.72 | $9.87 | $1.85 |
| 235057 | 2026-03-18 | $40.83 | USPS Ground Advantage | 1 | 9.25 lbs | $12.23 | $11.23 | $1.00 |
| 235058 | 2026-03-18 | $16.21 | USPS Ground Advantage | 3 | 0.75 lbs | $8.65 | $6.76 | $1.89 |
| 235059 | 2026-03-18 | $20.16 | USPS Ground Advantage | 1 | 0.15 lbs | $6.40 | $5.40 | $1.00 |
| 235060 | 2026-03-18 | $14.04 | USPS Ground Advantage | 2 | 0.06 lbs | $6.40 | $5.40 | $1.00 |
| 235061 | 2026-03-18 | $29.11 | USPS Ground Advantage | 1 | 4.80 lbs | $12.88 | $13.57 | $-0.69 |
| 235062 | 2026-03-19 | $17.70 | USPS Ground Advantage | 2 | 0.06 lbs | $6.66 | $5.56 | $1.10 |
| 235064 | 2026-03-19 | $13.82 | USPS Ground Advantage | 3 | 0.57 lbs | $7.43 | $7.52 | $-0.09 |
| 235065 | 2026-03-22 | $10.52 | USPS Ground Advantage | 1 | 0.45 lbs | $6.96 | $6.24 | $0.72 |
| 235066 | 2026-03-23 | $28.05 | USPS Ground Advantage | 1 | 1.50 lbs | $11.91 | $10.96 | $0.95 |
| 235067 | 2026-03-24 | $19.91 | USPS Ground Advantage | 4 | 1.80 lbs | $7.83 | $7.41 | $0.42 |
| 235068 | 2026-03-23 | $45.48 | USPS Ground Advantage | 2 | 9.60 lbs | $16.28 | $12.04 | $4.24 |
| 235069 | 2026-03-23 | $9.60 | USPS Ground Advantage | 1 | 0.08 lbs | $5.78 | $4.78 | $1.00 |
| 235070 | 2026-03-24 | $25.74 | USPS Ground Advantage | 1 | 0.31 lbs | $6.62 | $5.62 | $1.00 |
| 235071 | 2026-03-25 | $22.29 | USPS Ground Advantage | 4 | 1.80 lbs | $10.21 | $9.21 | $1.00 |
| 235072 | 2026-03-25 | $23.77 | USPS Ground Advantage | 1 | 1.50 lbs | $7.63 | $6.68 | $0.95 |
| 235073 | 2026-03-26 | $29.20 | USPS Ground Advantage | 1 | 0.38 lbs | $6.89 | $5.89 | $1.00 |
| 235074 | 2026-03-27 | $17.49 | USPS Ground Advantage | 1 | 0.07 lbs | $6.00 | $5.00 | $1.00 |
| 235075 | 2026-03-29 | $12.62 | USPS Ground Advantage | 1 | 0.05 lbs | $6.56 | $5.56 | $1.00 |
| 235076 | 2026-03-29 | $12.30 | USPS Ground Advantage | 1 | 0.15 lbs | $6.52 | $5.52 | $1.00 |
| 235077 | 2026-03-28 | $10.11 | USPS Ground Advantage | 1 | 0.05 lbs | $6.07 | $5.07 | $1.00 |
| 235078 | 2026-03-28 | $14.53 | USPS Ground Advantage | 3 | 1.00 lbs | $13.94 | $7.52 | $6.42 |
| 235080 | 2026-03-31 | $16.09 | USPS Ground Advantage | 2 | 0.90 lbs | $9.09 | $8.68 | $0.41 |
| 235081 | 2026-03-30 | $13.59 | USPS Ground Advantage | 1 | 0.05 lbs | $6.29 | $5.29 | $1.00 |
| 235082 | 2026-04-01 | $24.12 | USPS Ground Advantage | 6 | 1.20 lbs | $10.20 | $8.97 | $1.23 |
| 235083 | 2026-04-01 | $42.01 | USPS Ground Advantage | 10 | 2.50 lbs | $15.71 | $12.58 | $3.13 |
| 235084 | 2026-04-02 | $39.46 | USPS Ground Advantage | 8 | 2.60 lbs | $19.62 | $10.41 | $9.21 |
| 235085 | 2026-04-04 | $12.90 | USPS Ground Advantage | 1 | 0.10 lbs | $5.85 | $4.85 | $1.00 |
| 235086 | 2026-04-03 | $10.90 | USPS Ground Advantage | 1 | 0.03 lbs | $6.40 | $5.40 | $1.00 |
| 235087 | 2026-04-06 | $17.02 | USPS Ground Advantage | 1 | 0.10 lbs | $6.40 | $5.40 | $1.00 |
| 235088 | 2026-04-06 | $20.05 | USPS Ground Advantage | 1 | 0.20 lbs | $6.29 | $5.29 | $1.00 |
| 235089 | 2026-04-07 | $117.17 | USPS Ground Advantage | 3 | 1.65 lbs | $11.00 | $9.65 | $1.35 |
| 235090 | 2026-04-06 | $25.32 | USPS Ground Advantage | 1 | 0.03 lbs | $6.20 | $5.20 | $1.00 |
| 235091 | 2026-04-06 | $12.90 | USPS Ground Advantage | 1 | 0.10 lbs | $5.85 | $4.85 | $1.00 |
| 235092 | 2026-04-08 | $28.63 | USPS Ground Advantage | 6 | 2.40 lbs | $11.71 | $10.71 | $1.00 |
| 235093 | 2026-04-07 | $42.94 | USPS Ground Advantage | 1 | 0.95 lbs | $7.50 | $6.68 | $0.82 |
| 235094 | 2026-04-07 | $12.46 | USPS Ground Advantage | 1 | 0.05 lbs | $6.52 | $5.52 | $1.00 |
| 235095 | 2026-04-08 | $12.90 | USPS Ground Advantage | 1 | 0.10 lbs | $5.85 | $4.85 | $1.00 |
| 235096 | 2026-04-09 | $42.46 | USPS Ground Advantage | 1 | 0.85 lbs | $8.13 | $7.03 | $1.10 |
| 235097 | 2026-04-09 | $20.66 | USPS Ground Advantage | 1 | 0.28 lbs | $6.39 | $5.39 | $1.00 |
| 235098 | 2026-04-09 | $14.14 | USPS Ground Advantage | 1 | 0.20 lbs | $6.92 | $5.30 | $1.62 |
| 235099 | 2026-04-12 | $27.53 | USPS Ground Advantage | 1 | 0.03 lbs | $6.29 | $5.29 | $1.00 |
| 235100 | 2026-04-11 | $20.37 | USPS Ground Advantage | 4 | 1.60 lbs | $10.21 | $9.21 | $1.00 |
| 235101 | 2026-04-10 | $41.30 | USPS Ground Advantage | 1 | 1.30 lbs | $7.50 | $6.50 | $1.00 |
| 235102 | 2026-04-10 | $10.64 | USPS Ground Advantage | 1 | 0.02 lbs | $6.40 | $5.40 | $1.00 |
| 235103 | 2026-04-10 | $18.25 | USPS Ground Advantage | 3 | 1.35 lbs | $8.65 | $7.65 | $1.00 |
| 235104 | 2026-04-12 | $15.53 | USPS Ground Advantage | 2 | 0.90 lbs | $9.09 | $8.68 | $0.41 |
| 235105 | 2026-04-12 | $40.48 | USPS Ground Advantage | 9 | 4.05 lbs | $16.24 | $8.44 | $7.80 |
| 235106 | 2026-04-12 | $52.02 | USPS Ground Advantage | 1 | 5.15 lbs | $9.95 | $8.85 | $1.10 |
| 235107 | 2026-04-13 | $11.59 | USPS Ground Advantage | 1 | 0.03 lbs | $6.07 | $5.07 | $1.00 |
| 235108 | 2026-04-14 | $39.67 | USPS Ground Advantage | 1 | 0.75 lbs | $6.78 | $6.46 | $0.32 |
| 235109 | 2026-04-16 | $52.57 | USPS Ground Advantage | 1 | 1.35 lbs | $9.35 | $8.35 | $1.00 |
| 235110 | 2026-04-17 | $14.20 | USPS Ground Advantage | 1 | 0.08 lbs | $6.56 | $5.56 | $1.00 |
| 235111 | 2026-04-17 | $11.37 | USPS Ground Advantage | 1 | 0.03 lbs | $6.40 | $5.40 | $1.00 |
| 235112 | 2026-04-17 | $15.06 | USPS Ground Advantage | 1 | 0.20 lbs | $6.52 | $5.52 | $1.00 |
| 235113 | 2026-04-17 | $10.38 | USPS Ground Advantage | 1 | 0.05 lbs | $6.56 | $5.56 | $1.00 |
| 235114 | 2026-04-17 | $13.77 | USPS Ground Advantage | 1 | 0.04 lbs | $6.89 | $5.89 | $1.00 |
| 235143 | 2026-04-25 | $24.80 | Ground - Weight: 0.05lb | 3 | 0.05 lbs | $6.83 | $5.34 | $1.49 |
| 235154 | 2026-04-29 | $67.59 | USPS Ground Advantage | 1 | 5.80 lbs | $18.86 | $16.85 | $2.01 |
| 235155 | 2026-04-29 | $10.44 | USPS Ground Advantage | 1 | 0.05 lbs | $6.62 | $5.62 | $1.00 |
| 235156 | 2026-04-29 | $60.87 | USPS Ground Advantage | 2 | 0.82 lbs | $14.38 | $7.38 | $7.00 |
| 235157 | 2026-04-30 | $20.66 | USPS Ground Advantage | 2 | 0.06 lbs | $12.56 | $5.28 | $7.28 |
| 235158 | 2026-04-30 | $26.09 | USPS Ground Advantage | 1 | 0.30 lbs | $7.74 | $6.74 | $1.00 |
| 235159 | 2026-05-01 | $11.86 | USPS Ground Advantage | 1 | 0.10 lbs | $6.28 | $5.28 | $1.00 |
| 235160 | 2026-05-01 | $12.32 | USPS Ground Advantage | 1 | 0.46 lbs | $7.74 | $7.13 | $0.61 |
| 235161 | 2026-05-02 | $11.14 | USPS Ground Advantage | 1 | 0.05 lbs | $6.17 | $5.17 | $1.00 |
| 235163 | 2026-05-03 | $30.97 | USPS Ground Advantage | 1 | 0.40 lbs | $7.34 | $6.95 | $0.39 |
| 235164 | 2026-05-03 | $18.12 | USPS Ground Advantage | 1 | 0.30 lbs | $6.73 | $5.73 | $1.00 |
| 235165 | 2026-05-02 | $13.51 | USPS Ground Advantage | 1 | 0.05 lbs | $6.40 | $5.40 | $1.00 |
| 235166 | 2026-05-02 | $14.02 | USPS Ground Advantage | 2 | 0.10 lbs | $6.40 | $5.40 | $1.00 |
| 235167 | 2026-05-06 | $13.40 | USPS Ground Advantage | 1 | 0.19 lbs | $6.28 | $5.28 | $1.00 |
| 235168 | 2026-05-05 | $21.96 | USPS Ground Advantage | 2 | 0.90 lbs | $15.48 | $11.84 | $3.64 |
| 235169 | 2026-05-06 | $11.93 | USPS Ground Advantage | 1 | 0.05 lbs | $6.40 | $5.40 | $1.00 |
| 235170 | 2026-05-07 | $44.45 | USPS Ground Advantage | 1 | 0.80 lbs | $9.13 | $10.01 | $-0.88 |
| 235171 | 2026-05-08 | $9.94 | USPS Ground Advantage | 1 | 0.05 lbs | $6.62 | $5.62 | $1.00 |
| 235173 | 2026-05-08 | $82.87 | USPS Ground Advantage | 1 | 5.30 lbs | $11.60 | $10.60 | $1.00 |
| 235174 | 2026-05-09 | $34.95 | USPS Ground Advantage | 1 | 0.50 lbs | $7.24 | $8.13 | $-0.89 |
| 235175 | 2026-05-10 | $10.95 | USPS Ground Advantage | 1 | 0.05 lbs | $7.00 | $6.00 | $1.00 |
| 235176 | 2026-05-09 | $14.49 | USPS Ground Advantage | 1 | 0.05 lbs | $7.13 | $6.13 | $1.00 |
| 235177 | 2026-05-12 | $17.42 | USPS Ground Advantage | 4 | 0.76 lbs | $9.06 | $8.13 | $0.93 |
| 235178 | 2026-05-12 | $126.20 | USPS Ground Advantage | 1 | 18.13 lbs | $20.00 | $19.00 | $1.00 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |