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 |
|---|---|---|---|---|---|---|---|---|
| 211398 | 2020-04-20 | $32.37 | Priority Mail 2-Day Small Flat Rate Box | 2 | 0.70 lbs | $8.50 | $7.65 | $0.85 |
| 211400 | 2020-04-20 | $64.18 | Priority Mail 2-Day | 1 | 2.40 lbs | $10.39 | $10.33 | $0.06 |
| 211401 | 2020-04-20 | $35.37 | Priority Mail 3-Day Small Flat Rate Box | 13 | 1.20 lbs | $8.50 | $7.65 | $0.85 |
| 211402 | 2020-04-20 | $10.34 | First-Class Mail Stamped Letter | 1 | 0.07 lbs | $3.35 | $3.18 | $0.17 |
| 211406 | 2020-04-20 | $3.69 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $3.20 | $2.93 | $0.27 |
| 211407 | 2020-04-20 | $29.90 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.08 lbs | $8.00 | $7.65 | $0.35 |
| 211409 | 2020-04-20 | $228.54 | Ground | 1 | 14.05 lbs | $35.55 | $25.21 | $10.34 |
| 211410 | 2020-04-20 | $52.33 | Priority Mail 2-Day | 3 | 1.51 lbs | $11.39 | $10.53 | $0.86 |
| 211411 | 2020-04-20 | $34.84 | First-Class Package Service | 5 | 0.79 lbs | $5.79 | $5.54 | $0.25 |
| 211413 | 2020-04-20 | $15.48 | Priority Mail 3-Day Small Flat Rate Box | 2 | 0.08 lbs | $8.50 | $7.65 | $0.85 |
| 211417 | 2020-04-20 | $28.12 | Priority Mail 2-Day | 1 | 0.60 lbs | $8.83 | $7.98 | $0.85 |
| 211418 | 2020-04-21 | $51.05 | Priority Mail 3-Day Padded Flat Rate Envelope | 1 | 0.50 lbs | $8.60 | $7.65 | $0.95 |
| 211419 | 2020-04-21 | $31.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.00 | $7.75 | $0.25 |
| 211421 | 2020-04-21 | $252.97 | Priority Mail 3-Day | 2 | 21.37 lbs | $49.19 | $48.08 | $1.11 |
| 211422 | 2020-04-21 | $6.24 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.84 | $0.51 |
| 211427 | 2020-04-21 | $48.19 | Priority Mail 2-Day | 2 | 1.20 lbs | $9.61 | $8.76 | $0.85 |
| 211430 | 2020-04-21 | $37.66 | Priority Mail 2-Day Flat Rate Envelope | 4 | 0.62 lbs | $8.00 | $7.65 | $0.35 |
| 211431 | 2020-04-21 | $9.30 | Pickup From Store | 4 | 0.40 lbs | $0.00 | $2.74 | $-2.74 |
| 211433 | 2020-04-21 | $33.21 | Priority Mail 2-Day | 2 | 1.05 lbs | $10.84 | $10.42 | $0.42 |
| 211435 | 2020-04-21 | $9.14 | First-Class Mail Stamped Letter | 1 | 0.15 lbs | $3.65 | $2.93 | $0.72 |
| 211436 | 2020-04-21 | $42.59 | Priority Mail 2-Day | 1 | 1.20 lbs | $9.61 | $8.76 | $0.85 |
| 211437 | 2020-04-21 | $25.91 | Priority Mail 2-Day Flat Rate Envelope | 9 | 0.27 lbs | $8.00 | $7.65 | $0.35 |
| 211438 | 2020-04-21 | $9.33 | First-Class Mail Stamped Letter | 2 | 0.06 lbs | $3.35 | $3.05 | $0.30 |
| 211440 | 2020-04-21 | $145.86 | Priority Mail 2-Day | 3 | 4.80 lbs | $11.49 | $8.92 | $2.57 |
| 211441 | 2020-04-21 | $34.00 | Priority Mail 2-Day | 7 | 2.08 lbs | $8.69 | $8.07 | $0.62 |
| 211442 | 2020-04-21 | $33.96 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.10 lbs | $8.50 | $7.65 | $0.85 |
| 211447 | 2020-04-22 | $13.97 | Priority Mail 2-Day Flat Rate Envelope | 3 | 0.57 lbs | $8.00 | $7.65 | $0.35 |
| 211448 | 2020-04-22 | $35.05 | Priority Mail 3-Day | 2 | 0.60 lbs | $9.27 | $8.42 | $0.85 |
| 211449 | 2020-04-22 | $143.19 | Priority Mail 2-Day Large Flat Rate Box | 2 | 13.00 lbs | $19.15 | $13.20 | $5.95 |
| 211450 | 2020-04-22 | $6.24 | First-Class Mail Stamped Letter | 1 | 0.03 lbs | $3.35 | $3.05 | $0.30 |
| 211451 | 2020-04-22 | $36.38 | Priority Mail 2-Day Small Flat Rate Box | 2 | 0.65 lbs | $8.50 | $7.65 | $0.85 |
| 211452 | 2020-04-22 | $15.26 | Priority Mail 2-Day | 1 | 0.50 lbs | $8.97 | $7.56 | $1.41 |
| 211456 | 2020-04-22 | $7.74 | First-Class Mail Stamped Letter | 1 | 0.07 lbs | $3.35 | $3.05 | $0.30 |
| 211457 | 2020-04-22 | $17.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 211458 | 2020-04-22 | $32.22 | Priority Mail 2-Day | 3 | 0.60 lbs | $7.87 | $7.65 | $0.22 |
| 211459 | 2020-04-22 | $69.01 | Priority Mail 2-Day | 2 | 2.50 lbs | $10.39 | $9.54 | $0.85 |
| 211460 | 2020-04-22 | $23.47 | Priority Mail 3-Day Small Flat Rate Box | 3 | 0.80 lbs | $8.50 | $7.65 | $0.85 |
| 211461 | 2020-04-23 | $14.30 | First-Class Mail Stamped Letter | 5 | 0.08 lbs | $3.35 | $2.93 | $0.42 |
| 211462 | 2020-04-23 | $33.96 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.10 lbs | $8.50 | $7.65 | $0.85 |
| 211463 | 2020-04-23 | $31.83 | USPSPriority | 2 | 0.74 lbs | $8.85 | $7.65 | $1.20 |
| 211464 | 2020-04-23 | $10.64 | First-Class Mail Stamped Letter | 1 | 0.19 lbs | $3.65 | $2.93 | $0.72 |
| 211465 | 2020-04-23 | $47.13 | First-Class Package Service | 4 | 0.77 lbs | $5.37 | $5.12 | $0.25 |
| 211466 | 2020-04-23 | $6.09 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.20 | $3.05 | $0.15 |
| 211467 | 2020-04-23 | $81.86 | Priority Mail 2-Day | 2 | 2.80 lbs | $11.18 | $8.92 | $2.26 |
| 211468 | 2020-04-23 | $22.93 | First-Class Package Service | 2 | 0.70 lbs | $5.65 | $5.40 | $0.25 |
| 211469 | 2020-04-23 | $13.98 | Priority Mail 3-Day Flat Rate Envelope | 2 | 0.31 lbs | $8.00 | $7.65 | $0.35 |
| 211476 | 2020-04-23 | $36.18 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.00 | $7.65 | $0.35 |
| 211477 | 2020-04-23 | $15.76 | First-Class Package Service | 1 | 0.40 lbs | $4.77 | $4.32 | $0.45 |
| 211478 | 2020-04-23 | $70.49 | Priority Mail International Padded Flat Rate Envelope | 1 | 0.90 lbs | $37.50 | $37.60 | $-0.10 |
| 211479 | 2020-04-23 | $6.34 | First-Class Mail Stamped Letter | 1 | 0.03 lbs | $3.35 | $2.93 | $0.42 |
| 211481 | 2020-04-23 | $12.24 | USPSFirstClass | 1 | 0.20 lbs | $3.80 | $3.21 | $0.59 |
| 211483 | 2020-04-23 | $31.33 | Priority Mail 2-Day | 1 | 1.30 lbs | $8.97 | $8.12 | $0.85 |
| 211484 | 2020-04-23 | $57.68 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.65 lbs | $8.00 | $7.65 | $0.35 |
| 211485 | 2020-04-23 | $8.69 | First-Class Mail Stamped Letter | 1 | 0.15 lbs | $3.50 | $2.78 | $0.72 |
| 211486 | 2020-04-24 | $7.17 | USPSFirstClass | 1 | 0.10 lbs | $4.05 | $3.05 | $1.00 |
| 211487 | 2020-04-24 | $29.08 | USPSPriority | 1 | 1.50 lbs | $13.65 | $10.54 | $3.11 |
| 211488 | 2020-04-23 | $12.80 | First-Class Package Service | 3 | 0.38 lbs | $4.43 | $4.18 | $0.25 |
| 211489 | 2020-04-23 | $6.17 | First-Class Mail Stamped Letter | 3 | 0.01 lbs | $3.20 | $3.18 | $0.02 |
| 211490 | 2020-04-24 | $18.78 | USPSFirstClass | 2 | 0.10 lbs | $3.95 | $3.31 | $0.64 |
| 211491 | 2020-04-24 | $5.67 | USPSFirstClass | 1 | 0.05 lbs | $3.90 | $2.78 | $1.12 |
| 211492 | 2020-04-24 | $9.55 | USPSFirstClass | 1 | 0.07 lbs | $4.00 | $2.93 | $1.07 |
| 211493 | 2020-04-24 | $52.97 | 2-Day | 2 | 0.90 lbs | $31.39 | $26.43 | $4.96 |
| 211494 | 2020-04-24 | $19.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 211498 | 2020-04-24 | $44.78 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.90 lbs | $8.00 | $7.75 | $0.25 |
| 211499 | 2020-04-24 | $5.95 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.84 | $0.51 |
| 211500 | 2020-04-24 | $10.17 | USPSFirstClass | 3 | 0.09 lbs | $4.20 | $3.18 | $1.02 |
| 211501 | 2020-04-24 | $28.60 | Priority Mail 2-Day | 1 | 0.60 lbs | $8.41 | $7.56 | $0.85 |
| 211503 | 2020-04-24 | $16.45 | First-Class Package Service | 5 | 0.19 lbs | $3.70 | $3.25 | $0.45 |
| 211504 | 2020-04-24 | $26.92 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.40 lbs | $8.00 | $7.65 | $0.35 |
| 211505 | 2020-04-24 | $50.44 | USPSFirstClass | 1 | 0.50 lbs | $4.70 | $4.00 | $0.70 |
| 211506 | 2020-04-24 | $61.58 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.87 lbs | $8.00 | $7.75 | $0.25 |
| 211507 | 2020-04-24 | $26.39 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.00 | $7.75 | $0.25 |
| 211510 | 2020-04-24 | $92.34 | Priority Mail 3-Day | 5 | 1.72 lbs | $11.39 | $7.65 | $3.74 |
| 211513 | 2020-04-24 | $34.61 | Priority Mail 2-Day Flat Rate Envelope | 9 | 1.10 lbs | $8.00 | $7.65 | $0.35 |
| 211516 | 2020-04-24 | $4.18 | First-Class Mail Stamped Letter | 2 | 0.02 lbs | $3.20 | $2.84 | $0.36 |
| 211518 | 2020-04-24 | $28.88 | Priority Mail 3-Day Medium Flat Rate Box | 7 | 0.16 lbs | $14.45 | $8.92 | $5.53 |
| 211519 | 2020-04-24 | $286.41 | Priority Mail 2-Day | 2 | 14.85 lbs | $21.63 | $22.75 | $-1.12 |
| 211520 | 2020-04-25 | $12.96 | USPSFirstClass | 2 | 0.67 lbs | $5.40 | $5.12 | $0.28 |
| 211521 | 2020-04-24 | $18.29 | First-Class Package Service | 4 | 0.56 lbs | $4.33 | $4.08 | $0.25 |
| 211522 | 2020-04-24 | $360.71 | Priority Mail 2-Day | 2 | 19.50 lbs | $56.73 | $55.88 | $0.85 |
| 211524 | 2020-04-24 | $43.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.40 lbs | $8.50 | $7.65 | $0.85 |
| 211525 | 2020-04-24 | $51.59 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 1.45 lbs | $8.60 | $7.65 | $0.95 |
| 211526 | 2020-04-24 | $45.76 | Priority Mail 2-Day | 1 | 1.15 lbs | $8.97 | $8.12 | $0.85 |
| 211527 | 2020-04-24 | $46.40 | Priority Mail 2-Day | 1 | 1.15 lbs | $9.61 | $8.76 | $0.85 |
| 211528 | 2020-04-25 | $66.80 | Priority Mail International Padded Flat Rate Envelope | 10 | 0.46 lbs | $37.50 | $37.60 | $-0.10 |
| 211529 | 2020-04-25 | $23.36 | USPSFirstClass | 1 | 0.40 lbs | $4.90 | $3.52 | $1.38 |
| 211530 | 2020-04-25 | $71.48 | Priority Mail 2-Day | 1 | 3.85 lbs | $11.49 | $10.64 | $0.85 |
| 211531 | 2020-04-25 | $51.64 | Direct Link International | 2 | 0.60 lbs | $21.36 | $5.12 | $16.24 |
| 211532 | 2020-04-25 | $51.49 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.50 | $7.65 | $0.85 |
| 211533 | 2020-04-25 | $30.83 | Priority Mail 2-Day | 1 | 0.95 lbs | $10.84 | $9.98 | $0.86 |
| 211534 | 2020-04-25 | $43.49 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.40 lbs | $8.50 | $7.65 | $0.85 |
| 211535 | 2020-04-25 | $32.84 | USPSFirstClass | 4 | 0.50 lbs | $8.95 | $4.32 | $4.63 |
| 211536 | 2020-04-25 | $83.88 | USPSPriority | 1 | 5.30 lbs | $15.70 | $13.20 | $2.50 |
| 211538 | 2020-04-25 | $38.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.50 | $8.76 | $-0.26 |
| 211539 | 2020-04-25 | $21.94 | USPSFirstClass | 1 | 0.15 lbs | $3.95 | $2.84 | $1.11 |
| 211541 | 2020-04-25 | $165.56 | Priority Mail International | 30 | 5.79 lbs | $70.86 | $66.36 | $4.50 |
| 211543 | 2020-04-25 | $17.76 | Priority Mail 2-Day Flat Rate Envelope | 4 | 0.50 lbs | $8.00 | $7.75 | $0.25 |
| 211544 | 2020-04-25 | $58.63 | Priority Mail 3-Day | 4 | 1.55 lbs | $8.97 | $7.65 | $1.32 |
| 211548 | 2020-04-25 | $58.02 | Priority Mail 2-Day | 4 | 1.40 lbs | $9.61 | $8.92 | $0.69 |
| 211549 | 2020-04-25 | $65.43 | Priority Mail 3-Day | 4 | 1.14 lbs | $8.97 | $8.12 | $0.85 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |