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 |
|---|---|---|---|---|---|---|---|---|
| 212383 | 2020-05-22 | $67.60 | Priority Mail 2-Day | 4 | 1.57 lbs | $12.04 | $11.19 | $0.85 |
| 212384 | 2020-05-23 | $5.00 | USPSFirstClass | 1 | 0.01 lbs | $3.95 | $2.78 | $1.17 |
| 212386 | 2020-05-23 | $28.17 | USPSFirstClass | 6 | 0.59 lbs | $13.03 | $5.27 | $7.76 |
| 212387 | 2020-05-23 | $23.76 | USPSFirstClass | 2 | 0.16 lbs | $4.39 | $2.84 | $1.55 |
| 212390 | 2020-05-23 | $16.22 | USPSFirstClass | 1 | 0.05 lbs | $4.58 | $3.05 | $1.53 |
| 212391 | 2020-05-23 | $17.77 | USPSFirstClass | 1 | 0.29 lbs | $5.29 | $2.78 | $2.51 |
| 212392 | 2020-05-23 | $13.77 | USPSFirstClass | 2 | 0.67 lbs | $5.92 | $5.70 | $0.22 |
| 212393 | 2020-05-23 | $19.09 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.37 lbs | $8.50 | $7.65 | $0.85 |
| 212394 | 2020-05-23 | $19.09 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.37 lbs | $8.50 | $7.65 | $0.85 |
| 212397 | 2020-05-23 | $46.19 | Priority Mail 1-Day Small Flat Rate Box | 1 | 1.40 lbs | $8.50 | $7.65 | $0.85 |
| 212398 | 2020-05-23 | $5.34 | First-Class Mail Stamped Letter | 1 | 0.08 lbs | $3.35 | $2.84 | $0.51 |
| 212400 | 2020-05-23 | $24.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.45 lbs | $8.00 | $7.65 | $0.35 |
| 212401 | 2020-05-23 | $61.67 | Priority Mail 2-Day | 2 | 1.75 lbs | $10.39 | $8.92 | $1.47 |
| 212403 | 2020-05-23 | $6.19 | First-Class Mail Stamped Letter | 1 | 0.02 lbs | $3.20 | $3.05 | $0.15 |
| 212404 | 2020-05-23 | $17.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.56 | $0.44 |
| 212405 | 2020-05-24 | $7.19 | USPSFirstClass | 1 | 0.05 lbs | $4.04 | $2.78 | $1.26 |
| 212406 | 2020-05-23 | $7.70 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.05 | $0.30 |
| 212407 | 2020-05-23 | $8.54 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.84 | $0.51 |
| 212408 | 2020-05-24 | $8.14 | USPSFirstClass | 1 | 0.03 lbs | $4.15 | $2.84 | $1.31 |
| 212409 | 2020-05-24 | $10.45 | USPSFirstClass | 1 | 0.05 lbs | $4.19 | $3.25 | $0.94 |
| 212411 | 2020-05-24 | $26.57 | First-Class Package Service | 4 | 0.40 lbs | $4.91 | $3.67 | $1.24 |
| 212412 | 2020-05-24 | $6.15 | First-Class Package Service | 1 | 0.17 lbs | $3.76 | $3.31 | $0.45 |
| 212413 | 2020-05-24 | $46.48 | InternationalPriorityShipping | 4 | 1.00 lbs | $16.56 | $9.98 | $6.58 |
| 212414 | 2020-05-24 | $195.54 | Ground | 3 | 14.15 lbs | $29.98 | $24.33 | $5.65 |
| 212415 | 2020-05-24 | $7.88 | USPSFirstClass | 1 | 0.20 lbs | $4.34 | $3.18 | $1.16 |
| 212417 | 2020-05-24 | $47.36 | Priority Mail 3-Day | 3 | 1.05 lbs | $11.39 | $10.53 | $0.86 |
| 212418 | 2020-05-24 | $20.83 | Priority Mail 3-Day | 1 | 0.95 lbs | $10.84 | $9.99 | $0.85 |
| 212419 | 2020-05-24 | $6.39 | USPSFirstClass | 1 | 0.20 lbs | $4.14 | $3.52 | $0.62 |
| 212420 | 2020-05-24 | $28.34 | Priority Mail 3-Day | 10 | 2.00 lbs | $9.44 | $8.21 | $1.23 |
| 212421 | 2020-05-24 | $15.96 | Priority Mail 3-Day Small Flat Rate Box | 4 | 0.07 lbs | $8.50 | $7.65 | $0.85 |
| 212422 | 2020-05-24 | $67.97 | Priority Mail 2-Day Flat Rate Envelope | 3 | 6.00 lbs | $8.00 | $7.65 | $0.35 |
| 212423 | 2020-05-24 | $35.05 | First-Class Package Service | 7 | 0.75 lbs | $5.72 | $5.27 | $0.45 |
| 212424 | 2020-05-24 | $40.96 | Priority Mail 2-Day | 1 | 0.70 lbs | $8.97 | $8.12 | $0.85 |
| 212425 | 2020-05-24 | $170.69 | Priority Mail 2-Day | 5 | 8.25 lbs | $13.01 | $11.97 | $1.04 |
| 212426 | 2020-05-24 | $13.10 | First-Class Mail Stamped Letter | 2 | 0.10 lbs | $3.50 | $3.52 | $-0.02 |
| 212428 | 2020-05-24 | $4.19 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $3.20 | $3.05 | $0.15 |
| 212429 | 2020-05-25 | $10.08 | USPSFirstClass | 1 | 0.05 lbs | $4.29 | $3.39 | $0.90 |
| 212430 | 2020-05-24 | $24.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.45 lbs | $8.00 | $7.65 | $0.35 |
| 212431 | 2020-05-25 | $10.79 | USPSFirstClass | 1 | 0.05 lbs | $4.24 | $3.31 | $0.93 |
| 212432 | 2020-05-24 | $119.41 | Priority Mail 3-Day | 7 | 2.87 lbs | $11.18 | $10.33 | $0.85 |
| 212434 | 2020-05-25 | $52.06 | Priority Mail 2-Day | 2 | 1.60 lbs | $10.84 | $9.98 | $0.86 |
| 212435 | 2020-05-25 | $43.58 | Priority Mail 3-Day | 11 | 2.35 lbs | $10.39 | $9.54 | $0.85 |
| 212437 | 2020-05-25 | $61.82 | Priority Mail 3-Day | 2 | 1.30 lbs | $10.84 | $9.99 | $0.85 |
| 212438 | 2020-05-25 | $5.83 | First-Class Mail Stamped Letter | 2 | 0.08 lbs | $3.35 | $2.78 | $0.57 |
| 212441 | 2020-05-25 | $8.34 | USPSFirstClass | 1 | 0.03 lbs | $4.37 | $3.18 | $1.19 |
| 212442 | 2020-05-25 | $29.92 | Priority Mail 2-Day Flat Rate Envelope | 8 | 0.96 lbs | $8.00 | $7.65 | $0.35 |
| 212443 | 2020-05-25 | $10.64 | First-Class Mail Stamped Letter | 1 | 0.19 lbs | $3.65 | $2.93 | $0.72 |
| 212446 | 2020-05-25 | $24.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.00 | $7.65 | $0.35 |
| 212447 | 2020-05-25 | $32.94 | Ground | 4 | 0.44 lbs | $21.48 | $18.04 | $3.44 |
| 212448 | 2020-05-25 | $59.31 | Priority Mail 2-Day Small Flat Rate Box | 4 | 1.97 lbs | $8.50 | $7.65 | $0.85 |
| 212449 | 2020-05-25 | $76.98 | Priority Mail 3-Day | 1 | 3.85 lbs | $16.99 | $18.47 | $-1.48 |
| 212450 | 2020-05-25 | $24.89 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.25 lbs | $8.00 | $7.65 | $0.35 |
| 212451 | 2020-05-25 | $7.34 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.93 | $0.42 |
| 212452 | 2020-05-25 | $12.89 | USPSFirstClass | 3 | 0.18 lbs | $4.04 | $3.25 | $0.79 |
| 212454 | 2020-05-25 | $8.17 | USPSFirstClass | 1 | 0.05 lbs | $4.19 | $2.93 | $1.26 |
| 212455 | 2020-05-25 | $11.60 | First-Class Package Service | 2 | 0.18 lbs | $4.12 | $3.67 | $0.45 |
| 212456 | 2020-05-26 | $33.14 | Priority Mail 2-Day | 7 | 1.16 lbs | $9.61 | $8.76 | $0.85 |
| 212458 | 2020-05-26 | $35.31 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.25 lbs | $8.50 | $7.65 | $0.85 |
| 212459 | 2020-05-26 | $22.38 | USPSFirstClass | 1 | 0.45 lbs | $5.59 | $7.65 | $-2.06 |
| 212460 | 2020-05-26 | $13.10 | First-Class Package Service | 2 | 0.14 lbs | $4.12 | $3.67 | $0.45 |
| 212462 | 2020-05-26 | $107.78 | Priority Mail 3-Day | 6 | 2.30 lbs | $13.00 | $9.98 | $3.02 |
| 212463 | 2020-05-26 | $30.79 | USPSFirstClass | 3 | 0.17 lbs | $12.64 | $7.65 | $4.99 |
| 212464 | 2020-05-26 | $32.35 | Priority Mail 3-Day | 16 | 1.92 lbs | $10.39 | $8.92 | $1.47 |
| 212466 | 2020-05-26 | $8.34 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.05 | $0.30 |
| 212467 | 2020-05-26 | $18.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.10 lbs | $8.00 | $7.65 | $0.35 |
| 212468 | 2020-05-27 | $6.46 | USPSFirstClass | 1 | 0.20 lbs | $4.14 | $3.52 | $0.62 |
| 212470 | 2020-05-26 | $60.47 | Priority Mail 2-Day Flat Rate Envelope | 3 | 1.00 lbs | $8.00 | $7.65 | $0.35 |
| 212471 | 2020-05-26 | $31.08 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.45 lbs | $8.00 | $7.65 | $0.35 |
| 212472 | 2020-05-27 | $6.78 | USPSFirstClass | 1 | 0.45 lbs | $4.89 | $4.18 | $0.71 |
| 212475 | 2020-05-26 | $51.05 | Priority Mail 2-Day Padded Flat Rate Envelope | 5 | 0.90 lbs | $8.60 | $7.65 | $0.95 |
| 212477 | 2020-05-27 | $22.92 | USPSFirstClass | 1 | 0.40 lbs | $5.69 | $3.52 | $2.17 |
| 212478 | 2020-05-26 | $20.29 | Priority Mail 3-Day Small Flat Rate Box | 1 | 0.30 lbs | $8.50 | $7.65 | $0.85 |
| 212479 | 2020-05-26 | $230.45 | Priority Mail 2-Day Medium Flat Rate Box | 6 | 8.04 lbs | $14.45 | $13.20 | $1.25 |
| 212480 | 2020-05-27 | $12.84 | USPSFirstClass | 1 | 0.15 lbs | $4.47 | $3.52 | $0.95 |
| 212481 | 2020-05-27 | $31.97 | Priority Mail 2-Day Flat Rate Envelope | 3 | 1.45 lbs | $8.00 | $7.65 | $0.35 |
| 212482 | 2020-05-27 | $24.40 | USPSFirstClass | 1 | 0.45 lbs | $5.74 | $4.32 | $1.42 |
| 212483 | 2020-05-27 | $22.50 | USPSFirstClass | 3 | 0.97 lbs | $11.13 | $11.18 | $-0.05 |
| 212484 | 2020-05-27 | $6.18 | USPSFirstClass | 1 | 0.01 lbs | $4.29 | $3.18 | $1.11 |
| 212485 | 2020-05-27 | $26.39 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.00 | $7.75 | $0.25 |
| 212486 | 2020-05-27 | $54.29 | Priority Mail 3-Day Padded Flat Rate Envelope | 1 | 1.60 lbs | $8.60 | $7.65 | $0.95 |
| 212487 | 2020-05-27 | $15.61 | First-Class Mail Stamped Letter | 4 | 0.15 lbs | $3.65 | $2.78 | $0.87 |
| 212488 | 2020-05-27 | $8.31 | USPSFirstClass | 1 | 0.03 lbs | $4.17 | $2.93 | $1.24 |
| 212489 | 2020-05-27 | $26.39 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.00 | $7.75 | $0.25 |
| 212490 | 2020-05-27 | $33.36 | Priority Mail 2-Day | 3 | 0.80 lbs | $11.39 | $10.53 | $0.86 |
| 212491 | 2020-05-27 | $92.43 | Priority Mail 3-Day Flat Rate Envelope | 2 | 3.30 lbs | $8.00 | $7.75 | $0.25 |
| 212493 | 2020-05-27 | $46.40 | Priority Mail 2-Day | 1 | 1.10 lbs | $9.61 | $8.76 | $0.85 |
| 212494 | 2020-05-27 | $35.88 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.00 lbs | $8.00 | $7.75 | $0.25 |
| 212495 | 2020-05-28 | $15.06 | USPSFirstClass | 1 | 0.10 lbs | $4.42 | $2.84 | $1.58 |
| 212496 | 2020-05-28 | $63.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 5.30 lbs | $8.50 | $7.65 | $0.85 |
| 212497 | 2020-05-28 | $9.49 | USPSFirstClass | 2 | 0.32 lbs | $5.11 | $3.67 | $1.44 |
| 212498 | 2020-05-28 | $5.16 | First-Class Mail Stamped Letter | 4 | 0.04 lbs | $3.20 | $2.93 | $0.27 |
| 212499 | 2020-05-28 | $13.74 | USPSFirstClass | 1 | 0.15 lbs | $4.47 | $3.52 | $0.95 |
| 212500 | 2020-05-28 | $11.92 | USPSFirstClass | 1 | 0.06 lbs | $4.25 | $2.78 | $1.47 |
| 212502 | 2020-05-28 | $21.60 | USPSFirstClass | 2 | 0.20 lbs | $4.34 | $3.31 | $1.03 |
| 212503 | 2020-05-28 | $99.02 | Priority Mail 2-Day Medium Flat Rate Box | 3 | 3.05 lbs | $14.45 | $11.18 | $3.27 |
| 212504 | 2020-05-28 | $12.99 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.50 | $2.93 | $0.57 |
| 212506 | 2020-05-28 | $164.98 | Priority Mail 3-Day | 1 | 9.60 lbs | $34.99 | $29.15 | $5.84 |
| 212507 | 2020-05-28 | $108.89 | Priority Mail 2-Day | 5 | 3.55 lbs | $8.89 | $7.94 | $0.95 |
| 212508 | 2020-05-28 | $10.49 | USPSFirstClass | 2 | 0.12 lbs | $4.19 | $3.05 | $1.14 |
| 212510 | 2020-05-28 | $25.15 | First-Class Package Service | 8 | 0.20 lbs | $3.84 | $3.39 | $0.45 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |