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 |
|---|---|---|---|---|---|---|---|---|
| 235298 | 2026-07-24 | $13.28 | USPS Ground Advantage | 2 | 0.04 lbs | $6.72 | $5.72 | $1.00 |
| 235299 | 2026-07-24 | $10.88 | USPS Ground Advantage | 1 | 0.07 lbs | $6.48 | $5.48 | $1.00 |
| 235301 | 2026-07-25 | $64.32 | USPS Ground Advantage | 1 | 1.55 lbs | $8.90 | $7.90 | $1.00 |
| 235302 | 2026-07-25 | $16.85 | USPS Ground Advantage | 1 | 0.10 lbs | $6.72 | $5.62 | $1.10 |
| 235303 | 2026-07-25 | $15.92 | USPS Ground Advantage | 2 | 0.10 lbs | $8.46 | $7.46 | $1.00 |
| 235307 | 2026-07-24 | $27.58 | USPS Ground Advantage | 3 | 0.30 lbs | $8.97 | $5.97 | $3.00 |
| 235308 | 2026-07-26 | $10.93 | USPS Ground Advantage | 1 | 0.25 lbs | $6.62 | $5.62 | $1.00 |
| 235309 | 2026-07-25 | $16.29 | USPS Ground Advantage | 1 | 0.05 lbs | $6.62 | $5.62 | $1.00 |
| 235311 | 2026-07-28 | $19.40 | USPS Ground Parcel or Priority Mail | 1 | 0.00 lbs | $0.00 | $5.97 | $-5.97 |
| 235316 | 2026-07-27 | $36.44 | USPS Ground Advantage | 1 | 1.50 lbs | $14.01 | $18.51 | $-4.50 |
| 235317 | 2026-07-27 | $17.70 | USPS Ground Advantage | 1 | 0.50 lbs | $6.83 | $6.25 | $0.58 |
| 235318 | 2026-07-28 | $21.87 | USPS Ground Advantage | 1 | 0.30 lbs | $7.07 | $6.07 | $1.00 |
| 235319 | 2026-07-28 | $22.07 | USPS Ground Advantage | 5 | 2.25 lbs | $7.17 | $6.17 | $1.00 |
| 235320 | 2026-07-29 | $21.86 | USPS Ground Advantage | 4 | 0.32 lbs | $8.46 | $7.46 | $1.00 |
| 235321 | 2026-07-29 | $10.80 | USPS Ground Advantage | 1 | 0.07 lbs | $6.40 | $5.40 | $1.00 |
| 235323 | 2026-08-02 | $7.50 | USPS Ground Advantage | 1 | 0.05 lbs | $6.40 | $5.40 | $1.00 |
| 235324 | 2026-08-01 | $94.08 | USPS Ground Advantage | 1 | 1.45 lbs | $10.31 | $9.21 | $1.10 |
| 235326 | 2026-08-02 | $8.61 | USPS Ground Advantage | 1 | 0.20 lbs | $6.40 | $5.83 | $0.57 |
| 235327 | 2026-08-02 | $19.44 | USPS Ground Advantage | 1 | 0.60 lbs | $7.25 | $5.40 | $1.85 |
| 235334 | 2026-08-04 | $14.12 | USPS Ground Advantage | 2 | 0.18 lbs | $0.00 | $8.07 | $-8.07 |
| 235335 | 2026-08-04 | $18.43 | USPS Ground Advantage | 3 | 0.30 lbs | $7.24 | $5.97 | $1.27 |
| 235339 | 2026-08-06 | $12.99 | USPS Ground Advantage | 1 | 0.05 lbs | $6.48 | $5.48 | $1.00 |
| 235340 | 2026-08-06 | $10.44 | USPS Ground Advantage | 1 | 0.03 lbs | $6.48 | $5.48 | $1.00 |
| 235341 | 2026-08-07 | $10.13 | USPS Ground Advantage | 1 | 0.05 lbs | $6.40 | $5.40 | $1.00 |
| 235343 | 2026-08-08 | $26.42 | USPS Ground Advantage | 1 | 1.20 lbs | $8.83 | $8.14 | $0.69 |
| 235344 | 2026-08-08 | $77.35 | USPS Ground Advantage | 3 | 0.22 lbs | $26.58 | $7.86 | $18.72 |
| 235345 | 2026-08-09 | $7.44 | USPS Ground Advantage | 1 | 0.05 lbs | $6.28 | $5.28 | $1.00 |
| 235346 | 2026-08-09 | $11.96 | USPS Ground Advantage | 1 | 0.05 lbs | $6.97 | $5.97 | $1.00 |
| 235347 | 2026-08-10 | $16.71 | USPS Ground Advantage | 1 | 0.08 lbs | $6.72 | $5.72 | $1.00 |
| 235349 | 2026-08-10 | $17.21 | USPS Ground Advantage | 1 | 0.19 lbs | $6.72 | $5.72 | $1.00 |
| 235350 | 2026-08-11 | $12.06 | USPS Ground Advantage | 1 | 0.05 lbs | $6.97 | $5.97 | $1.00 |
| 235351 | 2026-08-12 | $73.52 | USPS Ground Advantage | 1 | 1.50 lbs | $10.54 | $9.54 | $1.00 |
| 235352 | 2026-08-13 | $13.66 | USPS Ground Advantage | 2 | 0.06 lbs | $6.40 | $5.40 | $1.00 |
| 235353 | 2026-08-14 | $15.16 | USPS Ground Advantage | 1 | 0.20 lbs | $6.62 | $5.62 | $1.00 |
| 235354 | 2026-08-14 | $17.10 | USPS Ground Advantage | 1 | 0.08 lbs | $6.48 | $5.48 | $1.00 |
| 235355 | 2026-08-15 | $27.03 | USPS Ground Advantage | 10 | 1.90 lbs | $6.93 | $4.59 | $2.34 |
| 235356 | 2026-08-14 | $32.11 | USPS Ground Advantage | 8 | 3.20 lbs | $9.07 | $8.07 | $1.00 |
| 235357 | 2026-08-14 | $23.59 | USPS Ground Advantage | 7 | 1.75 lbs | $6.93 | $4.59 | $2.34 |
| 235358 | 2026-08-14 | $23.16 | USPS Ground Advantage | 1 | 4.80 lbs | $6.93 | $8.56 | $-1.63 |
| 235359 | 2026-08-15 | $10.22 | USPS Ground Advantage | 1 | 0.08 lbs | $6.40 | $5.40 | $1.00 |
| 235360 | 2026-08-15 | $10.64 | USPS Ground Advantage | 1 | 0.05 lbs | $6.40 | $5.40 | $1.00 |
| 235361 | 2026-08-16 | $36.17 | USPS Ground Advantage | 2 | 0.97 lbs | $11.01 | $9.54 | $1.47 |
| 235362 | 2026-08-16 | $19.71 | USPS Ground Advantage | 1 | 0.27 lbs | $6.97 | $5.97 | $1.00 |
| 235363 | 2026-08-16 | $34.37 | UPS Ground | 1 | 1.50 lbs | $8.88 | $7.88 | $1.00 |
| 235365 | 2026-08-16 | $35.73 | USPS Ground Advantage | 10 | 4.50 lbs | $6.93 | $4.59 | $2.34 |
| 235366 | 2026-08-17 | $15.64 | USPS Ground Advantage | 1 | 0.02 lbs | $8.65 | $5.97 | $2.68 |
| 235373 | 2026-08-20 | $22.42 | USPS Ground Advantage | 3 | 0.12 lbs | $20.91 | $5.97 | $14.94 |
| 235375 | 2026-08-20 | $30.73 | USPS Ground Advantage | 10 | 2.50 lbs | $6.93 | $5.93 | $1.00 |
| 235380 | 2026-08-21 | $23.07 | USPS Ground Advantage | 5 | 1.25 lbs | $9.07 | $9.35 | $-0.28 |
| 235381 | 2026-08-21 | $25.01 | USPS Ground Advantage | 1 | 1.20 lbs | $8.02 | $7.22 | $0.80 |
| 235385 | 2026-08-21 | $14.30 | USPS Ground Advantage | 1 | 0.05 lbs | $6.40 | $5.40 | $1.00 |
| 235386 | 2026-08-22 | $11.83 | USPS Ground Advantage | 1 | 0.03 lbs | $6.40 | $5.40 | $1.00 |
| 235387 | 2026-08-23 | $63.19 | USPS Ground Advantage | 1 | 0.56 lbs | $8.46 | $7.46 | $1.00 |
| 235388 | 2026-08-23 | $11.57 | USPS Ground Advantage | 2 | 0.40 lbs | $7.07 | $6.07 | $1.00 |
| 235389 | 2026-08-22 | $15.89 | USPS Ground Advantage | 1 | 0.20 lbs | $6.40 | $5.83 | $0.57 |
| 235390 | 2026-08-23 | $19.43 | USPS Ground Advantage | 1 | 0.30 lbs | $6.97 | $5.97 | $1.00 |
| 235392 | 2026-08-24 | $21.07 | USPS Ground Advantage | 5 | 1.25 lbs | $9.17 | $8.17 | $1.00 |
| 235393 | 2026-08-24 | $16.63 | USPS Ground Advantage | 3 | 0.75 lbs | $9.07 | $9.14 | $-0.07 |
| 235394 | 2026-08-24 | $29.70 | USPS Ground Advantage | 1 | 4.75 lbs | $11.01 | $8.17 | $2.84 |
| 235395 | 2026-08-25 | $98.40 | USPS Ground Advantage | 2 | 2.50 lbs | $15.98 | $6.99 | $8.99 |
| 235396 | 2026-08-25 | $68.42 | USPS Ground Advantage | 20 | 9.00 lbs | $8.02 | $13.42 | $-5.40 |
| 235397 | 2026-08-25 | $12.92 | USPS Ground Advantage | 1 | 0.08 lbs | $6.72 | $5.72 | $1.00 |
| 235398 | 2026-08-26 | $73.01 | USPS Ground Advantage | 1 | 1.19 lbs | $7.99 | $6.99 | $1.00 |
| 235399 | 2026-08-26 | $11.55 | USPS Ground Advantage | 1 | 0.04 lbs | $6.97 | $5.97 | $1.00 |
| 235401 | 2026-08-27 | $14.70 | USPS Ground Advantage | 1 | 0.02 lbs | $7.71 | $5.40 | $2.31 |
| 235404 | 2026-08-29 | $36.91 | First-Class Package International Service | 3 | 0.57 lbs | $24.94 | $18.48 | $6.46 |
| 235405 | 2026-08-29 | $37.13 | USPS Ground Advantage | 10 | 4.00 lbs | $6.93 | $5.93 | $1.00 |
| 235406 | 2026-08-30 | $16.65 | USPS Ground Advantage | 1 | 0.06 lbs | $8.86 | $7.86 | $1.00 |
| 235407 | 2026-08-31 | $41.03 | USPS Ground Advantage | 2 | 2.38 lbs | $11.05 | $10.05 | $1.00 |
| 235408 | 2026-08-31 | $72.69 | USPS Ground Advantage | 1 | 0.55 lbs | $8.30 | $7.30 | $1.00 |
| 235409 | 2026-09-01 | $17.58 | USPS Ground Advantage | 4 | 0.78 lbs | $7.94 | $6.99 | $0.95 |
| 235410 | 2026-09-01 | $13.54 | USPS Ground Advantage | 3 | 0.15 lbs | $6.97 | $5.97 | $1.00 |
| 235411 | 2026-09-01 | $51.12 | USPS Ground Advantage | 1 | 1.30 lbs | $6.93 | $5.93 | $1.00 |
| 235412 | 2026-09-02 | $9.43 | USPS Ground Advantage | 1 | 0.04 lbs | $6.72 | $5.72 | $1.00 |
| 235413 | 2026-09-02 | $9.45 | USPS Ground Advantage | 1 | 0.03 lbs | $6.48 | $5.48 | $1.00 |
| 235414 | 2026-09-02 | $14.07 | USPS Ground Advantage | 1 | 0.10 lbs | $6.28 | $5.28 | $1.00 |
| 235415 | 2026-09-03 | $22.28 | USPS Ground Advantage | 5 | 0.15 lbs | $7.03 | $5.83 | $1.20 |
| 235416 | 2026-09-04 | $9.03 | USPS Ground Advantage | 1 | 0.20 lbs | $6.24 | $5.24 | $1.00 |
| 235417 | 2026-09-04 | $30.63 | USPS Ground Advantage | 10 | 1.90 lbs | $6.93 | $5.93 | $1.00 |
| 235418 | 2026-09-04 | $15.75 | USPS Ground Advantage | 1 | 0.05 lbs | $8.86 | $7.86 | $1.00 |
| 235422 | 2026-09-05 | $11.40 | USPS Ground Advantage | 1 | 0.04 lbs | $8.69 | $7.69 | $1.00 |
| 235423 | 2026-09-06 | $17.39 | USPS First Class | 1 | 0.10 lbs | $6.40 | $5.40 | $1.00 |
| 235424 | 2026-09-09 | $24.69 | USPS Ground Advantage | 1 | 0.40 lbs | $8.86 | $7.86 | $1.00 |
| 235425 | 2026-09-08 | $13.75 | USPS Ground Advantage | 1 | 0.05 lbs | $6.72 | $5.72 | $1.00 |
| 235426 | 2026-09-09 | $44.38 | USPS Priority Mail | 1 | 1.20 lbs | $10.73 | $9.73 | $1.00 |
| 235427 | 2026-09-09 | $17.19 | USPS Ground Advantage | 2 | 0.90 lbs | $10.53 | $11.05 | $-0.52 |
| 235428 | 2026-09-10 | $40.50 | UPS Ground | 1 | 1.60 lbs | $14.55 | $10.05 | $4.50 |
| 235429 | 2026-09-10 | $11.88 | USPS Ground Advantage | 1 | 0.03 lbs | $6.97 | $5.97 | $1.00 |
| 235430 | 2026-09-12 | $19.39 | USPS Ground Advantage | 1 | 0.08 lbs | $9.40 | $8.40 | $1.00 |
| 235431 | 2026-09-12 | $12.24 | USPS First Class | 1 | 0.03 lbs | $6.97 | $5.97 | $1.00 |
| 235432 | 2026-09-15 | $23.31 | USPS Ground Advantage | 4 | 1.80 lbs | $9.07 | $8.07 | $1.00 |
| 235433 | 2026-09-15 | $11.39 | USPS Ground Advantage | 1 | 0.05 lbs | $6.40 | $5.40 | $1.00 |
| 235434 | 2026-09-15 | $11.50 | USPS Ground Advantage | 1 | 0.05 lbs | $6.40 | $5.40 | $1.00 |
| 235435 | 2026-09-16 | $39.78 | USPS Ground Advantage | 1 | 1.20 lbs | $7.03 | $7.02 | $0.01 |
| 235438 | 2026-09-18 | $22.09 | USPS Ground Advantage | 2 | 0.03 lbs | $8.11 | $5.72 | $2.39 |
| 235439 | 2026-09-18 | $23.89 | USPS Ground Advantage | 5 | 2.00 lbs | $8.99 | $9.67 | $-0.68 |
| 235440 | 2026-09-20 | $21.49 | UPS Ground | 4 | 1.00 lbs | $11.65 | $10.65 | $1.00 |
| 235441 | 2026-09-22 | $16.65 | USPS Ground Advantage | 1 | 0.05 lbs | $6.58 | $5.58 | $1.00 |
| 235442 | 2026-09-22 | $13.56 | USPS Ground Advantage | 1 | 0.06 lbs | $6.67 | $5.72 | $0.95 |
| 235443 | 2026-09-23 | $16.48 | USPS Ground Advantage | 2 | 0.10 lbs | $6.50 | $5.50 | $1.00 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |