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 |
|---|---|---|---|---|---|---|---|---|
| 234237 | 2025-07-02 | $89.06 | USPS Ground Advantage | 1 | 2.10 lbs | $8.32 | $7.22 | $1.10 |
| 234238 | 2025-07-03 | $60.29 | USPS Ground Advantage | 1 | 1.10 lbs | $7.77 | $6.82 | $0.95 |
| 234239 | 2025-07-04 | $32.98 | USPS Ground Advantage | 4 | 0.30 lbs | $5.82 | $4.62 | $1.20 |
| 234240 | 2025-07-03 | $35.63 | USPS Ground Advantage | 1 | 0.58 lbs | $6.72 | $5.62 | $1.10 |
| 234241 | 2025-07-06 | $51.26 | USPS Ground Advantage | 1 | 1.30 lbs | $8.77 | $7.57 | $1.20 |
| 234242 | 2025-07-06 | $9.52 | USPS Ground Advantage | 1 | 0.05 lbs | $5.45 | $4.25 | $1.20 |
| 234243 | 2025-07-05 | $17.20 | USPS Ground Advantage | 3 | 0.43 lbs | $6.82 | $5.62 | $1.20 |
| 234244 | 2025-07-07 | $23.64 | USPS Ground Advantage | 3 | 0.30 lbs | $5.67 | $6.74 | $-1.07 |
| 234245 | 2025-07-07 | $39.02 | USPS Ground Advantage | 2 | 1.40 lbs | $9.82 | $8.24 | $1.58 |
| 234246 | 2025-07-07 | $41.72 | USPS Ground Advantage | 6 | 1.80 lbs | $20.36 | $9.67 | $10.69 |
| 234247 | 2025-07-08 | $10.26 | USPS Ground Advantage | 1 | 0.03 lbs | $5.53 | $4.33 | $1.20 |
| 234248 | 2025-07-08 | $9.52 | USPS Ground Advantage | 1 | 0.08 lbs | $5.28 | $4.08 | $1.20 |
| 234249 | 2025-07-10 | $67.32 | USPS Ground Advantage | 1 | 8.17 lbs | $21.68 | $20.40 | $1.28 |
| 234250 | 2025-07-09 | $11.38 | USPS Ground Advantage | 1 | 0.02 lbs | $5.61 | $4.51 | $1.10 |
| 234251 | 2025-07-09 | $11.69 | USPS Ground Advantage | 1 | 0.64 lbs | $6.72 | $5.62 | $1.10 |
| 234252 | 2025-07-09 | $13.82 | USPS Ground Parcel or Priority Mail | 1 | 0.07 lbs | $8.63 | $4.51 | $4.12 |
| 234253 | 2025-07-10 | $41.13 | USPS Ground Advantage | 9 | 0.89 lbs | $22.88 | $5.62 | $17.26 |
| 234254 | 2025-07-10 | $31.80 | USPS Ground Advantage | 10 | 2.50 lbs | $9.40 | $7.16 | $2.24 |
| 234255 | 2025-07-11 | $10.95 | USPS Ground Advantage | 1 | 0.02 lbs | $5.18 | $4.08 | $1.10 |
| 234256 | 2025-07-11 | $9.27 | USPS Ground Advantage | 1 | 0.03 lbs | $5.45 | $4.25 | $1.20 |
| 234257 | 2025-07-11 | $19.28 | USPS Ground Advantage | 1 | 0.35 lbs | $5.77 | $4.74 | $1.03 |
| 234258 | 2025-07-13 | $13.67 | USPS Ground Advantage | 1 | 0.05 lbs | $5.77 | $4.57 | $1.20 |
| 234259 | 2025-07-12 | $20.16 | USPS Ground Advantage | 2 | 0.12 lbs | $5.18 | $4.24 | $0.94 |
| 234260 | 2025-07-15 | $14.39 | USPS Ground Advantage | 2 | 0.10 lbs | $5.85 | $4.65 | $1.20 |
| 234261 | 2025-07-15 | $29.61 | USPS Ground Advantage | 1 | 3.15 lbs | $9.73 | $6.72 | $3.01 |
| 234262 | 2025-07-15 | $44.80 | USPS Ground Advantage | 1 | 0.75 lbs | $6.90 | $8.98 | $-2.08 |
| 234263 | 2025-07-15 | $8.26 | USPS Ground Advantage | 1 | 0.02 lbs | $5.80 | $4.60 | $1.20 |
| 234264 | 2025-07-14 | $18.75 | USPS Ground Advantage | 1 | 0.30 lbs | $6.09 | $4.89 | $1.20 |
| 234265 | 2025-07-12 | $7.00 | USPS Ground Parcel or Priority Mail | 1 | 0.10 lbs | $0.61 | $4.60 | $-3.99 |
| 234266 | 2025-07-16 | $11.95 | USPS Ground Advantage | 4 | 0.12 lbs | $5.19 | $4.24 | $0.95 |
| 234267 | 2025-07-16 | $12.66 | USPS Ground Advantage | 1 | 0.09 lbs | $5.61 | $4.41 | $1.20 |
| 234268 | 2025-07-16 | $16.59 | USPS Ground Advantage | 1 | 0.15 lbs | $5.72 | $4.52 | $1.20 |
| 234269 | 2025-07-17 | $15.22 | USPS Ground Advantage | 1 | 0.30 lbs | $6.22 | $6.02 | $0.20 |
| 234270 | 2025-07-17 | $16.87 | USPS Ground Advantage | 1 | 0.15 lbs | $6.00 | $4.80 | $1.20 |
| 234271 | 2025-07-18 | $18.55 | USPS Ground Advantage | 1 | 0.23 lbs | $5.55 | $4.35 | $1.20 |
| 234272 | 2025-07-18 | $38.63 | USPS Ground Advantage | 4 | 0.94 lbs | $22.20 | $4.47 | $17.73 |
| 234273 | 2025-07-18 | $52.61 | USPS Ground Advantage | 1 | 0.50 lbs | $6.09 | $5.83 | $0.26 |
| 234274 | 2025-07-18 | $12.09 | USPS Ground Advantage | 1 | 0.05 lbs | $5.72 | $4.52 | $1.20 |
| 234275 | 2025-07-19 | $11.83 | USPS Ground Advantage | 1 | 0.36 lbs | $5.89 | $4.69 | $1.20 |
| 234276 | 2025-07-20 | $192.18 | USPS Ground Advantage | 1 | 17.00 lbs | $23.04 | $24.12 | $-1.08 |
| 234277 | 2025-07-20 | $29.81 | USPS Ground Advantage | 3 | 0.13 lbs | $16.83 | $4.41 | $12.42 |
| 234278 | 2025-07-19 | $35.96 | USPS Ground Advantage | 10 | 2.50 lbs | $13.56 | $10.67 | $2.89 |
| 234279 | 2025-07-19 | $14.17 | USPS Ground Advantage | 1 | 0.06 lbs | $5.85 | $4.65 | $1.20 |
| 234280 | 2025-07-21 | $31.70 | USPS Ground Advantage | 3 | 0.15 lbs | $5.72 | $5.70 | $0.02 |
| 234281 | 2025-07-21 | $39.51 | USPS Ground Advantage | 1 | 1.15 lbs | $7.39 | $6.29 | $1.10 |
| 234282 | 2025-07-21 | $38.86 | USPS Ground Advantage | 1 | 0.13 lbs | $5.72 | $4.80 | $0.92 |
| 234284 | 2025-07-21 | $19.93 | USPS Ground Advantage | 1 | 0.45 lbs | $6.17 | $4.97 | $1.20 |
| 234285 | 2025-07-23 | $10.58 | USPS Ground Advantage | 1 | 0.25 lbs | $6.00 | $4.47 | $1.53 |
| 234287 | 2025-07-23 | $10.05 | USPS Ground Advantage | 1 | 0.03 lbs | $6.00 | $4.80 | $1.20 |
| 234291 | 2025-07-25 | $23.70 | USPS Ground Advantage | 1 | 0.40 lbs | $6.11 | $5.71 | $0.40 |
| 234292 | 2025-07-24 | $9.73 | USPS Ground Advantage | 1 | 0.23 lbs | $5.61 | $4.74 | $0.87 |
| 234293 | 2025-07-26 | $28.09 | USPS Ground Advantage | 1 | 4.75 lbs | $9.40 | $7.16 | $2.24 |
| 234294 | 2025-07-25 | $14.16 | USPS Ground Advantage | 5 | 0.31 lbs | $6.06 | $4.86 | $1.20 |
| 234295 | 2025-07-25 | $58.09 | USPS Ground Advantage | 1 | 0.55 lbs | $7.10 | $5.90 | $1.20 |
| 234296 | 2025-07-25 | $9.96 | USPS Ground Advantage | 1 | 0.08 lbs | $5.72 | $4.52 | $1.20 |
| 234297 | 2025-07-25 | $25.66 | USPS Ground Advantage | 3 | 1.09 lbs | $10.51 | $4.89 | $5.62 |
| 234298 | 2025-07-25 | $11.28 | USPS Ground Advantage | 1 | 0.05 lbs | $5.59 | $4.39 | $1.20 |
| 234299 | 2025-07-27 | $32.64 | USPS Ground Advantage | 1 | 0.39 lbs | $6.30 | $5.20 | $1.10 |
| 234300 | 2025-07-27 | $13.70 | USPS Ground Advantage | 2 | 0.10 lbs | $5.30 | $4.35 | $0.95 |
| 234301 | 2025-07-27 | $64.09 | USPS Ground Advantage | 1 | 1.38 lbs | $10.55 | $9.35 | $1.20 |
| 234302 | 2025-07-26 | $13.17 | USPS Ground Advantage | 2 | 0.06 lbs | $5.55 | $4.35 | $1.20 |
| 234303 | 2025-07-26 | $20.73 | USPS Ground Advantage | 1 | 0.06 lbs | $5.44 | $4.24 | $1.20 |
| 234304 | 2025-07-27 | $12.34 | USPS Ground Advantage | 1 | 0.05 lbs | $5.55 | $4.35 | $1.20 |
| 234305 | 2025-07-29 | $21.43 | USPS Ground Advantage | 1 | 0.55 lbs | $6.65 | $6.64 | $0.01 |
| 234306 | 2025-07-29 | $25.01 | USPS Ground Advantage | 1 | 1.20 lbs | $8.02 | $7.36 | $0.66 |
| 234307 | 2025-07-30 | $27.24 | USPS Ground Advantage | 1 | 0.03 lbs | $6.00 | $4.80 | $1.20 |
| 234308 | 2025-07-30 | $175.27 | USPS Ground Advantage | 1 | 17.00 lbs | $23.04 | $22.14 | $0.90 |
| 234309 | 2025-07-30 | $16.14 | USPS Ground Advantage | 1 | 1.69 lbs | $7.65 | $4.69 | $2.96 |
| 234310 | 2025-07-31 | $14.30 | USPS Ground Advantage | 1 | 0.20 lbs | $5.72 | $4.80 | $0.92 |
| 234312 | 2025-08-01 | $20.59 | USPS Ground Advantage | 3 | 0.15 lbs | $6.10 | $6.02 | $0.08 |
| 234313 | 2025-08-01 | $30.37 | USPS Ground Advantage | 1 | 0.90 lbs | $0.00 | $7.79 | $-7.79 |
| 234314 | 2025-07-31 | $22.76 | USPS Ground Advantage | 1 | 0.45 lbs | $6.32 | $6.02 | $0.30 |
| 234315 | 2025-07-31 | $13.23 | USPS Ground Advantage | 2 | 0.16 lbs | $5.61 | $4.41 | $1.20 |
| 234316 | 2025-08-03 | $11.44 | USPS Ground Advantage | 1 | 0.05 lbs | $5.75 | $4.45 | $1.30 |
| 234317 | 2025-08-03 | $11.27 | USPS Ground Advantage | 1 | 0.03 lbs | $5.75 | $4.45 | $1.30 |
| 234318 | 2025-08-02 | $13.43 | USPS Ground Advantage | 2 | 0.24 lbs | $5.95 | $5.06 | $0.89 |
| 234320 | 2025-08-04 | $25.87 | USPS Ground Advantage | 1 | 1.50 lbs | $9.73 | $8.78 | $0.95 |
| 234321 | 2025-08-05 | $197.92 | USPS Ground Advantage | 1 | 18.90 lbs | $14.33 | $26.50 | $-12.17 |
| 234322 | 2025-08-04 | $101.10 | USPS Ground Advantage | 12 | 5.82 lbs | $11.40 | $10.74 | $0.66 |
| 234323 | 2025-08-04 | $10.42 | USPS Ground Advantage | 1 | 0.05 lbs | $5.75 | $4.80 | $0.95 |
| 234325 | 2025-08-06 | $23.54 | USPS Ground Advantage | 1 | 0.33 lbs | $6.21 | $4.91 | $1.30 |
| 234326 | 2025-08-05 | $15.48 | USPS Ground Advantage | 4 | 1.60 lbs | $15.88 | $8.98 | $6.90 |
| 234327 | 2025-08-06 | $9.99 | USPS Ground Advantage | 1 | 1.69 lbs | $0.00 | $4.69 | $-4.69 |
| 234328 | 2025-08-07 | $36.38 | USPS Ground Advantage | 2 | 0.88 lbs | $7.60 | $6.45 | $1.15 |
| 234329 | 2025-08-06 | $10.83 | USPS Ground Advantage | 1 | 0.05 lbs | $5.71 | $4.41 | $1.30 |
| 234331 | 2025-08-09 | $45.15 | USPS Ground Advantage | 1 | 1.30 lbs | $7.59 | $6.29 | $1.30 |
| 234332 | 2025-08-09 | $35.13 | USPS Ground Advantage | 3 | 5.06 lbs | $13.50 | $7.57 | $5.93 |
| 234333 | 2025-08-08 | $9.07 | USPS Ground Advantage | 1 | 0.03 lbs | $6.10 | $4.80 | $1.30 |
| 234334 | 2025-08-11 | $19.74 | USPS Ground Advantage | 1 | 0.20 lbs | $6.15 | $5.20 | $0.95 |
| 234335 | 2025-08-11 | $140.10 | USPS Ground Advantage | 3 | 3.58 lbs | $20.76 | $11.79 | $8.97 |
| 234336 | 2025-08-10 | $8.90 | USPS Ground Advantage | 1 | 0.20 lbs | $6.10 | $4.80 | $1.30 |
| 234337 | 2025-08-11 | $19.33 | USPS Ground Advantage | 1 | 0.58 lbs | $7.32 | $6.02 | $1.30 |
| 234338 | 2025-08-11 | $10.40 | USPS Ground Advantage | 1 | 0.03 lbs | $5.90 | $4.60 | $1.30 |
| 234339 | 2025-08-13 | $13.16 | USPS Ground Advantage | 2 | 0.10 lbs | $5.54 | $4.24 | $1.30 |
| 234340 | 2025-08-13 | $13.74 | USPS Ground Advantage | 1 | 0.19 lbs | $6.10 | $4.80 | $1.30 |
| 234341 | 2025-08-13 | $12.10 | USPS Ground Advantage | 1 | 0.10 lbs | $5.90 | $4.60 | $1.30 |
| 234342 | 2025-08-13 | $12.70 | USPS Ground Advantage | 1 | 0.06 lbs | $5.65 | $4.35 | $1.30 |
| 234343 | 2025-08-15 | $263.82 | USPS Ground Advantage | 1 | 21.00 lbs | $34.33 | $42.08 | $-7.75 |
| 234344 | 2025-08-14 | $11.19 | USPS Ground Advantage | 1 | 0.03 lbs | $6.10 | $4.80 | $1.30 |
| 234345 | 2025-08-14 | $10.88 | USPS Ground Advantage | 1 | 0.10 lbs | $5.45 | $4.35 | $1.10 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |