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 |
|---|---|---|---|---|---|---|---|---|
| 234123 | 2025-05-02 | $8.14 | USPS Ground Advantage | 1 | 0.05 lbs | $5.09 | $4.14 | $0.95 |
| 234128 | 2025-05-04 | $8.85 | USPS Ground Advantage | 1 | 0.01 lbs | $5.46 | $4.51 | $0.95 |
| 234129 | 2025-05-04 | $9.27 | USPS Ground Advantage | 1 | 0.05 lbs | $5.03 | $4.08 | $0.95 |
| 234130 | 2025-05-04 | $32.10 | USPS Ground Advantage | 1 | 0.85 lbs | $8.31 | $7.36 | $0.95 |
| 234131 | 2025-05-04 | $14.62 | USPS Ground Advantage | 1 | 0.04 lbs | $5.28 | $4.33 | $0.95 |
| 234132 | 2025-05-03 | $10.97 | USPS Ground Advantage | 1 | 0.05 lbs | $5.28 | $4.33 | $0.95 |
| 234133 | 2025-05-03 | $12.42 | USPS Ground Advantage | 1 | 0.05 lbs | $5.20 | $4.25 | $0.95 |
| 234134 | 2025-05-03 | $15.90 | USPS Ground Advantage | 1 | 0.10 lbs | $5.03 | $4.08 | $0.95 |
| 234135 | 2025-05-07 | $12.57 | USPS Ground Advantage | 1 | 0.06 lbs | $4.93 | $3.98 | $0.95 |
| 234136 | 2025-05-06 | $29.20 | USPS Ground Advantage | 1 | 0.85 lbs | $7.79 | $6.84 | $0.95 |
| 234137 | 2025-05-07 | $134.97 | USPS Ground Advantage | 1 | 4.85 lbs | $7.48 | $8.46 | $-0.98 |
| 234138 | 2025-05-09 | $88.84 | USPS Ground Advantage | 1 | 13.50 lbs | $8.52 | $7.57 | $0.95 |
| 234139 | 2025-05-08 | $30.81 | USPS Ground Advantage | 1 | 0.85 lbs | $7.02 | $6.07 | $0.95 |
| 234140 | 2025-05-09 | $59.74 | USPS Priority Mail | 1 | 1.25 lbs | $13.00 | $15.43 | $-2.43 |
| 234141 | 2025-05-10 | $13.71 | USPS Ground Advantage | 3 | 0.19 lbs | $5.28 | $4.33 | $0.95 |
| 234142 | 2025-05-09 | $12.61 | USPS Ground Advantage | 1 | 0.83 lbs | $7.35 | $8.50 | $-1.15 |
| 234143 | 2025-05-12 | $42.03 | USPS Ground Advantage | 2 | 1.83 lbs | $9.93 | $8.50 | $1.43 |
| 234144 | 2025-05-13 | $33.09 | USPS Ground Advantage | 1 | 0.74 lbs | $6.75 | $6.84 | $-0.09 |
| 234145 | 2025-05-13 | $53.35 | USPS Ground Advantage | 8 | 2.40 lbs | $11.03 | $10.66 | $0.37 |
| 234146 | 2025-05-14 | $14.99 | USPS Ground Parcel or Priority Mail | 1 | 1.19 lbs | $0.00 | $10.00 | $-10.00 |
| 234147 | 2025-05-16 | $43.81 | USPS Ground Advantage | 1 | 0.44 lbs | $5.57 | $4.62 | $0.95 |
| 234148 | 2025-05-16 | $13.52 | USPS Ground Advantage | 1 | 0.05 lbs | $5.28 | $4.33 | $0.95 |
| 234149 | 2025-05-15 | $152.26 | USPS Ground Advantage | 1 | 3.38 lbs | $7.77 | $7.36 | $0.41 |
| 234150 | 2025-05-17 | $9.52 | USPS Ground Advantage | 1 | 0.05 lbs | $5.28 | $4.33 | $0.95 |
| 234151 | 2025-05-17 | $31.48 | USPS Ground Advantage | 1 | 0.85 lbs | $7.69 | $6.74 | $0.95 |
| 234152 | 2025-05-16 | $12.92 | USPS Ground Advantage | 1 | 0.06 lbs | $5.28 | $4.33 | $0.95 |
| 234153 | 2025-05-20 | $43.46 | USPS Ground Advantage | 1 | 1.10 lbs | $7.77 | $6.82 | $0.95 |
| 234154 | 2025-05-20 | $9.50 | USPS Ground Advantage | 1 | 0.18 lbs | $5.09 | $4.14 | $0.95 |
| 234155 | 2025-05-20 | $11.57 | USPS Ground Advantage | 1 | 0.05 lbs | $5.20 | $4.25 | $0.95 |
| 234156 | 2025-05-20 | $9.33 | USPS Ground Advantage | 1 | 0.05 lbs | $5.09 | $4.14 | $0.95 |
| 234157 | 2025-05-22 | $9.95 | USPS Ground Advantage | 1 | 0.08 lbs | $5.46 | $4.51 | $0.95 |
| 234158 | 2025-05-26 | $8.35 | USPS Ground Advantage | 1 | 0.02 lbs | $5.46 | $4.51 | $0.95 |
| 234159 | 2025-05-25 | $10.81 | USPS Ground Advantage | 2 | 0.38 lbs | $5.79 | $5.80 | $-0.01 |
| 234160 | 2025-05-25 | $8.15 | USPS Ground Advantage | 1 | 0.10 lbs | $5.46 | $4.51 | $0.95 |
| 234161 | 2025-05-24 | $13.49 | USPS Ground Advantage | 1 | 0.09 lbs | $5.20 | $4.25 | $0.95 |
| 234162 | 2025-05-24 | $11.98 | USPS Ground Advantage | 1 | 0.05 lbs | $5.09 | $4.14 | $0.95 |
| 234163 | 2025-05-24 | $11.36 | USPS Ground Advantage | 3 | 0.03 lbs | $5.03 | $4.08 | $0.95 |
| 234164 | 2025-05-23 | $11.98 | USPS Ground Advantage | 1 | 0.05 lbs | $5.09 | $4.14 | $0.95 |
| 234165 | 2025-05-28 | $7.72 | USPS Ground Advantage | 1 | 0.02 lbs | $4.83 | $4.08 | $0.75 |
| 234166 | 2025-05-28 | $9.65 | USPS Ground Advantage | 1 | 0.05 lbs | $5.46 | $4.51 | $0.95 |
| 234167 | 2025-05-29 | $22.27 | USPS Ground Advantage | 1 | 0.20 lbs | $5.28 | $4.71 | $0.57 |
| 234169 | 2025-05-29 | $16.71 | USPS Ground Advantage | 2 | 0.10 lbs | $5.03 | $4.52 | $0.51 |
| 234170 | 2025-05-31 | $11.12 | USPS Ground Advantage | 2 | 0.06 lbs | $5.20 | $4.25 | $0.95 |
| 234171 | 2025-05-31 | $7.52 | USPS Ground Advantage | 1 | 0.01 lbs | $5.03 | $4.08 | $0.95 |
| 234172 | 2025-05-31 | $9.69 | USPS Ground Advantage | 1 | 0.03 lbs | $5.20 | $4.25 | $0.95 |
| 234173 | 2025-06-03 | $11.95 | USPS Ground Advantage | 1 | 0.22 lbs | $5.46 | $4.63 | $0.83 |
| 234174 | 2025-06-03 | $52.71 | USPS Ground Advantage | 1 | 1.30 lbs | $8.52 | $7.57 | $0.95 |
| 234175 | 2025-06-05 | $12.74 | USPS Ground Advantage | 1 | 0.05 lbs | $5.09 | $4.14 | $0.95 |
| 234176 | 2025-06-05 | $21.16 | USPS Ground Advantage | 1 | 0.30 lbs | $5.57 | $4.62 | $0.95 |
| 234178 | 2025-06-06 | $34.30 | USPS Ground Advantage | 1 | 3.15 lbs | $8.31 | $6.88 | $1.43 |
| 234179 | 2025-06-07 | $15.29 | USPS Ground Parcel or Priority Mail | 1 | 0.10 lbs | $8.63 | $4.14 | $4.49 |
| 234180 | 2025-06-07 | $16.17 | USPS Ground Advantage | 2 | 0.10 lbs | $5.03 | $4.08 | $0.95 |
| 234181 | 2025-06-09 | $10.45 | USPS Ground Advantage | 1 | 0.05 lbs | $5.46 | $4.51 | $0.95 |
| 234182 | 2025-06-09 | $7.95 | USPS Ground Advantage | 1 | 0.03 lbs | $5.46 | $4.51 | $0.95 |
| 234183 | 2025-06-10 | $19.83 | Priority Mail Flat Rate Envelope | 2 | 0.02 lbs | $9.85 | $4.33 | $5.52 |
| 234184 | 2025-06-11 | $18.62 | USPS Ground Advantage | 3 | 0.38 lbs | $5.66 | $5.62 | $0.04 |
| 234185 | 2025-06-11 | $72.17 | USPS Ground Advantage | 1 | 1.06 lbs | $9.28 | $8.33 | $0.95 |
| 234186 | 2025-06-11 | $53.49 | USPS Ground Advantage | 1 | 0.73 lbs | $6.75 | $6.84 | $-0.09 |
| 234189 | 2025-06-12 | $11.57 | USPS Ground Advantage | 1 | 0.05 lbs | $5.20 | $4.62 | $0.58 |
| 234190 | 2025-06-12 | $23.21 | USPS Ground Advantage | 1 | 0.25 lbs | $5.20 | $4.25 | $0.95 |
| 234191 | 2025-06-13 | $24.62 | USPS Ground Advantage | 4 | 1.17 lbs | $13.50 | $9.39 | $4.11 |
| 234192 | 2025-06-15 | $34.51 | USPS Ground Advantage | 2 | 0.55 lbs | $11.58 | $5.80 | $5.78 |
| 234193 | 2025-06-16 | $15.33 | USPS Ground Advantage | 1 | 1.51 lbs | $8.62 | $7.67 | $0.95 |
| 234195 | 2025-06-17 | $46.98 | USPS Ground Advantage | 1 | 1.20 lbs | $8.74 | $7.79 | $0.95 |
| 234196 | 2025-06-19 | $31.33 | USPS Ground Advantage | 1 | 0.70 lbs | $6.26 | $6.25 | $0.01 |
| 234198 | 2025-06-23 | $12.40 | USPS Ground Advantage | 1 | 0.05 lbs | $5.18 | $4.08 | $1.10 |
| 234200 | 2025-06-22 | $17.88 | USPS Ground Advantage | 1 | 0.40 lbs | $5.72 | $4.62 | $1.10 |
| 234201 | 2025-06-22 | $57.18 | USPS Ground Advantage | 1 | 0.55 lbs | $6.19 | $5.09 | $1.10 |
| 234202 | 2025-06-22 | $21.12 | USPS Ground Advantage | 1 | 1.50 lbs | $7.40 | $6.45 | $0.95 |
| 234203 | 2025-06-22 | $13.88 | USPS Ground Advantage | 3 | 0.03 lbs | $5.24 | $4.14 | $1.10 |
| 234204 | 2025-06-22 | $25.58 | USPS Ground Advantage | 1 | 0.25 lbs | $5.61 | $4.84 | $0.77 |
| 234205 | 2025-06-21 | $11.63 | USPS Ground Advantage | 1 | 0.10 lbs | $5.09 | $4.14 | $0.95 |
| 234207 | 2025-06-23 | $13.23 | USPS Ground Advantage | 2 | 0.06 lbs | $5.61 | $4.51 | $1.10 |
| 234210 | 2025-06-24 | $9.48 | USPS Ground Advantage | 1 | 0.05 lbs | $5.24 | $4.14 | $1.10 |
| 234211 | 2025-06-25 | $19.87 | USPS Ground Advantage | 1 | 0.03 lbs | $5.43 | $4.33 | $1.10 |
| 234212 | 2025-06-25 | $40.89 | USPS Ground Advantage | 1 | 0.75 lbs | $6.90 | $6.84 | $0.06 |
| 234213 | 2025-06-24 | $57.55 | USPS Ground Advantage | 3 | 2.75 lbs | $9.91 | $8.52 | $1.39 |
| 234214 | 2025-06-24 | $9.85 | USPS Ground Advantage | 1 | 0.03 lbs | $5.35 | $4.25 | $1.10 |
| 234215 | 2025-06-24 | $9.08 | USPS Ground Advantage | 1 | 0.06 lbs | $5.43 | $4.33 | $1.10 |
| 234216 | 2025-06-26 | $139.66 | USPS Ground Advantage | 1 | 4.85 lbs | $12.17 | $9.39 | $2.78 |
| 234217 | 2025-06-26 | $2.71 | USPS Ground Advantage | 1 | 0.04 lbs | $0.00 | $4.51 | $-4.51 |
| 234218 | 2025-06-26 | $6.71 | USPS Ground Advantage | 1 | 0.06 lbs | $0.00 | $4.08 | $-4.08 |
| 234219 | 2025-06-27 | $14.97 | USPS Ground Advantage | 2 | 0.38 lbs | $10.70 | $5.49 | $5.21 |
| 234220 | 2025-06-28 | $8.26 | USPS Ground Advantage | 1 | 0.06 lbs | $5.43 | $4.33 | $1.10 |
| 234221 | 2025-06-28 | $535.49 | USPS Ground Advantage | 1 | 32.42 lbs | $0.00 | $31.71 | $-31.71 |
| 234222 | 2025-06-29 | $21.75 | USPS Ground Advantage | 1 | 0.12 lbs | $5.18 | $4.52 | $0.66 |
| 234223 | 2025-06-29 | $44.74 | USPS Ground Advantage | 2 | 1.83 lbs | $11.10 | $9.39 | $1.71 |
| 234224 | 2025-06-29 | $12.80 | USPS Ground Advantage | 2 | 0.06 lbs | $5.18 | $4.08 | $1.10 |
| 234225 | 2025-06-29 | $12.93 | USPS Ground Advantage | 3 | 0.57 lbs | $6.90 | $6.84 | $0.06 |
| 234226 | 2025-06-29 | $9.43 | USPS Ground Advantage | 1 | 0.03 lbs | $5.61 | $4.51 | $1.10 |
| 234227 | 2025-06-29 | $13.07 | USPS Ground Advantage | 1 | 0.06 lbs | $5.43 | $4.33 | $1.10 |
| 234228 | 2025-06-29 | $16.93 | USPS Ground Advantage | 1 | 0.19 lbs | $5.46 | $4.84 | $0.62 |
| 234229 | 2025-06-28 | $11.78 | USPS Ground Advantage | 1 | 0.10 lbs | $5.24 | $4.14 | $1.10 |
| 234230 | 2025-06-30 | $45.66 | USPS Ground Advantage | 1 | 9.25 lbs | $13.88 | $12.78 | $1.10 |
| 234231 | 2025-06-30 | $13.97 | USPS Ground Advantage | 2 | 0.10 lbs | $5.43 | $4.33 | $1.10 |
| 234232 | 2025-07-01 | $45.76 | USPS Ground Advantage | 1 | 9.25 lbs | $13.98 | $12.78 | $1.20 |
| 234233 | 2025-06-30 | $13.97 | USPS Ground Advantage | 5 | 0.15 lbs | $5.52 | $4.14 | $1.38 |
| 234234 | 2025-06-30 | $11.49 | USPS Ground Advantage | 1 | 0.25 lbs | $5.46 | $4.84 | $0.62 |
| 234235 | 2025-07-02 | $1.10 | USPS Ground Advantage | 1 | 0.01 lbs | $0.00 | $4.51 | $-4.51 |
| 234236 | 2025-07-02 | $27.34 | USPS Ground Advantage | 1 | 0.35 lbs | $5.62 | $4.52 | $1.10 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |