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 |
|---|---|---|---|---|---|---|---|---|
| 211551 | 2020-04-25 | $48.75 | Priority Mail 2-Day | 1 | 1.10 lbs | $8.97 | $8.12 | $0.85 |
| 211552 | 2020-04-25 | $38.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.50 | $7.65 | $0.85 |
| 211555 | 2020-04-25 | $82.42 | Priority Mail 2-Day Medium Flat Rate Box | 2 | 2.55 lbs | $14.45 | $13.20 | $1.25 |
| 211556 | 2020-04-25 | $38.31 | Priority Mail 2-Day | 3 | 2.06 lbs | $14.34 | $13.49 | $0.85 |
| 211557 | 2020-04-25 | $11.79 | USPSFirstClass | 1 | 0.10 lbs | $4.00 | $2.93 | $1.07 |
| 211559 | 2020-04-25 | $117.97 | Priority Mail 2-Day | 4 | 3.35 lbs | $9.92 | $7.65 | $2.27 |
| 211560 | 2020-04-25 | $7.01 | USPSFirstClass | 1 | 0.10 lbs | $3.90 | $2.78 | $1.12 |
| 211561 | 2020-04-26 | $27.64 | USPSFirstClass | 1 | 0.45 lbs | $4.90 | $4.32 | $0.58 |
| 211562 | 2020-04-25 | $43.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.40 lbs | $8.50 | $7.65 | $0.85 |
| 211563 | 2020-04-25 | $49.97 | Priority Mail 3-Day | 2 | 1.20 lbs | $11.39 | $10.53 | $0.86 |
| 211564 | 2020-04-25 | $58.96 | Priority Mail 3-Day | 3 | 1.25 lbs | $10.84 | $9.98 | $0.86 |
| 211565 | 2020-04-25 | $24.29 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.41 lbs | $8.00 | $7.65 | $0.35 |
| 211567 | 2020-04-26 | $21.83 | USPSFirstClass | 1 | 0.40 lbs | $4.70 | $4.00 | $0.70 |
| 211568 | 2020-04-25 | $36.10 | Priority Mail 2-Day | 1 | 0.57 lbs | $9.61 | $7.80 | $1.81 |
| 211569 | 2020-04-26 | $7.20 | USPSFirstClass | 1 | 0.07 lbs | $4.00 | $2.93 | $1.07 |
| 211570 | 2020-04-26 | $25.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 3.50 lbs | $8.00 | $7.65 | $0.35 |
| 211572 | 2020-04-26 | $41.51 | First-Class Package Service | 4 | 0.81 lbs | $5.65 | $5.40 | $0.25 |
| 211573 | 2020-04-26 | $44.52 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.75 lbs | $8.00 | $7.75 | $0.25 |
| 211574 | 2020-04-26 | $50.71 | USPSFirstClass | 1 | 0.50 lbs | $4.70 | $4.00 | $0.70 |
| 211575 | 2020-04-26 | $39.38 | USPSFirstClass | 9 | 0.09 lbs | $5.65 | $3.05 | $2.60 |
| 211576 | 2020-04-26 | $23.86 | First-Class Package Service | 1 | 0.60 lbs | $4.57 | $5.54 | $-0.97 |
| 211578 | 2020-04-26 | $9.59 | USPSFirstClass | 1 | 0.25 lbs | $3.90 | $3.25 | $0.65 |
| 211579 | 2020-04-26 | $51.33 | Priority Mail 3-Day | 1 | 2.20 lbs | $14.34 | $11.13 | $3.21 |
| 211580 | 2020-04-26 | $33.41 | Priority Mail 3-Day Flat Rate Envelope | 9 | 0.21 lbs | $8.00 | $7.65 | $0.35 |
| 211581 | 2020-04-26 | $33.96 | Priority Mail 3-Day | 1 | 1.05 lbs | $8.97 | $7.75 | $1.22 |
| 211585 | 2020-04-26 | $56.69 | Priority Mail 3-Day Medium Flat Rate Box | 3 | 2.60 lbs | $14.45 | $13.20 | $1.25 |
| 211586 | 2020-04-26 | $8.34 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.05 | $0.30 |
| 211587 | 2020-04-26 | $56.13 | Priority Mail 2-Day | 4 | 1.15 lbs | $8.97 | $7.65 | $1.32 |
| 211588 | 2020-04-26 | $60.62 | Priority Mail 2-Day Medium Flat Rate Box | 2 | 1.95 lbs | $14.45 | $12.10 | $2.35 |
| 211589 | 2020-04-26 | $29.57 | Priority Mail 3-Day Flat Rate Envelope | 3 | 0.45 lbs | $8.00 | $7.65 | $0.35 |
| 211590 | 2020-04-26 | $23.86 | First-Class Package Service | 1 | 0.60 lbs | $4.57 | $5.54 | $-0.97 |
| 211591 | 2020-04-26 | $9.54 | USPSFirstClass | 1 | 0.05 lbs | $4.05 | $3.05 | $1.00 |
| 211592 | 2020-04-26 | $18.37 | USPSFirstClass | 1 | 0.40 lbs | $4.80 | $4.18 | $0.62 |
| 211593 | 2020-04-26 | $9.83 | First-Class Mail Stamped Letter | 2 | 0.03 lbs | $3.35 | $3.05 | $0.30 |
| 211594 | 2020-04-26 | $13.98 | Priority Mail 3-Day Flat Rate Envelope | 2 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 211595 | 2020-04-26 | $117.29 | Priority Mail 3-Day | 9 | 2.55 lbs | $14.34 | $10.53 | $3.81 |
| 211596 | 2020-04-26 | $18.55 | USPSFirstClass | 1 | 0.95 lbs | $8.00 | $8.12 | $-0.12 |
| 211597 | 2020-04-26 | $44.92 | Priority Mail 3-Day | 2 | 1.20 lbs | $8.97 | $8.12 | $0.85 |
| 211599 | 2020-04-26 | $16.13 | USPSFirstClass | 1 | 0.05 lbs | $4.05 | $3.05 | $1.00 |
| 211600 | 2020-04-26 | $12.40 | USPSFirstClass | 1 | 0.30 lbs | $4.90 | $4.32 | $0.58 |
| 211601 | 2020-04-26 | $27.89 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.00 lbs | $8.50 | $7.65 | $0.85 |
| 211603 | 2020-04-26 | $10.47 | USPSFirstClass | 3 | 0.09 lbs | $4.00 | $2.93 | $1.07 |
| 211604 | 2020-04-26 | $19.09 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.37 lbs | $8.50 | $7.65 | $0.85 |
| 211605 | 2020-04-27 | $29.38 | USPSFirstClass | 3 | 1.82 lbs | $16.95 | $13.20 | $3.75 |
| 211606 | 2020-04-27 | $18.07 | USPSFirstClass | 1 | 0.40 lbs | $4.70 | $4.00 | $0.70 |
| 211607 | 2020-04-26 | $48.77 | Priority Mail 3-Day | 2 | 1.70 lbs | $13.00 | $9.99 | $3.01 |
| 211608 | 2020-04-26 | $22.94 | First-Class Package Service | 1 | 0.45 lbs | $4.45 | $4.00 | $0.45 |
| 211612 | 2020-04-26 | $18.96 | Priority Mail 3-Day | 1 | 0.95 lbs | $8.97 | $8.12 | $0.85 |
| 211615 | 2020-04-26 | $342.71 | Priority Mail 2-Day | 2 | 15.65 lbs | $56.73 | $54.93 | $1.80 |
| 211616 | 2020-04-27 | $19.73 | USPSFirstClass | 1 | 0.95 lbs | $8.45 | $9.99 | $-1.54 |
| 211617 | 2020-04-27 | $39.00 | USPSFirstClass | 2 | 0.32 lbs | $4.70 | $3.25 | $1.45 |
| 211618 | 2020-04-27 | $7.10 | USPSFirstClass | 1 | 0.20 lbs | $3.95 | $2.84 | $1.11 |
| 211621 | 2020-04-27 | $76.94 | Priority Mail 3-Day Flat Rate Envelope | 6 | 1.58 lbs | $8.00 | $8.12 | $-0.12 |
| 211622 | 2020-04-27 | $42.80 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 1.35 lbs | $8.60 | $7.75 | $0.85 |
| 211623 | 2020-04-27 | $29.60 | Priority Mail 2-Day | 1 | 1.10 lbs | $9.61 | $8.76 | $0.85 |
| 211624 | 2020-04-27 | $7.14 | USPSFirstClass | 1 | 0.05 lbs | $3.90 | $2.78 | $1.12 |
| 211625 | 2020-04-27 | $81.18 | Priority Mail 2-Day | 2 | 2.10 lbs | $13.00 | $10.42 | $2.58 |
| 211626 | 2020-04-27 | $37.48 | USPSFirstClass | 1 | 0.58 lbs | $5.45 | $4.08 | $1.37 |
| 211627 | 2020-04-27 | $20.79 | USPSFirstClass | 4 | 0.20 lbs | $4.05 | $3.52 | $0.53 |
| 211628 | 2020-04-27 | $5.89 | USPSFirstClass | 1 | 0.05 lbs | $3.95 | $2.84 | $1.11 |
| 211629 | 2020-04-27 | $23.42 | Priority Mail 2-Day | 2 | 1.45 lbs | $9.44 | $8.59 | $0.85 |
| 211630 | 2020-04-27 | $24.16 | USPSFirstClass | 1 | 0.15 lbs | $4.20 | $3.18 | $1.02 |
| 211631 | 2020-04-27 | $43.62 | InternationalPriorityShipping | 1 | 0.04 lbs | $4.00 | $2.93 | $1.07 |
| 211632 | 2020-04-27 | $28.88 | Ground | 1 | 0.16 lbs | $14.89 | $15.87 | $-0.98 |
| 211635 | 2020-04-27 | $5.16 | First-Class Mail Stamped Letter | 4 | 0.04 lbs | $3.20 | $3.18 | $0.02 |
| 211636 | 2020-04-27 | $22.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.35 lbs | $8.00 | $7.65 | $0.35 |
| 211637 | 2020-04-27 | $127.70 | Priority Mail 2-Day | 4 | 3.80 lbs | $10.24 | $9.39 | $0.85 |
| 211638 | 2020-04-27 | $37.43 | First-Class Package Service | 3 | 0.25 lbs | $3.70 | $3.25 | $0.45 |
| 211640 | 2020-04-27 | $21.09 | USPSFirstClass | 1 | 0.40 lbs | $4.75 | $4.08 | $0.67 |
| 211641 | 2020-04-27 | $46.40 | Priority Mail 2-Day | 1 | 1.40 lbs | $9.61 | $8.76 | $0.85 |
| 211642 | 2020-04-28 | $246.29 | USPSPriority | 1 | 9.20 lbs | $32.30 | $26.67 | $5.63 |
| 211643 | 2020-04-28 | $22.78 | USPSFirstClass | 1 | 0.40 lbs | $4.90 | $3.52 | $1.38 |
| 211644 | 2020-04-28 | $7.34 | USPSFirstClass | 1 | 0.05 lbs | $3.95 | $2.84 | $1.11 |
| 211645 | 2020-04-27 | $49.42 | Priority Mail 3-Day | 2 | 1.30 lbs | $10.84 | $9.98 | $0.86 |
| 211646 | 2020-04-28 | $9.76 | USPSFirstClass | 1 | 0.07 lbs | $4.05 | $3.05 | $1.00 |
| 211647 | 2020-04-27 | $18.98 | Priority Mail 3-Day Flat Rate Envelope | 2 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 211648 | 2020-04-27 | $45.67 | Priority Mail 2-Day | 2 | 1.00 lbs | $11.39 | $10.53 | $0.86 |
| 211649 | 2020-04-28 | $15.17 | USPSFirstClass | 3 | 0.59 lbs | $9.20 | $8.42 | $0.78 |
| 211650 | 2020-04-28 | $9.55 | USPSFirstClass | 1 | 0.07 lbs | $4.00 | $2.93 | $1.07 |
| 211651 | 2020-04-28 | $42.72 | USPSFirstClass | 2 | 0.30 lbs | $3.95 | $3.31 | $0.64 |
| 211654 | 2020-04-27 | $15.89 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.20 lbs | $8.00 | $7.75 | $0.25 |
| 211655 | 2020-04-28 | $22.97 | USPSFirstClass | 1 | 0.40 lbs | $4.80 | $3.39 | $1.41 |
| 211656 | 2020-04-28 | $9.19 | USPSFirstClass | 1 | 0.06 lbs | $3.90 | $2.78 | $1.12 |
| 211658 | 2020-04-28 | $23.97 | USPSFirstClass | 1 | 0.15 lbs | $4.00 | $2.93 | $1.07 |
| 211659 | 2020-04-28 | $14.43 | Priority Mail 2-Day Flat Rate Envelope | 7 | 0.18 lbs | $8.00 | $7.75 | $0.25 |
| 211661 | 2020-04-28 | $11.34 | First-Class Mail Stamped Letter | 16 | 0.16 lbs | $3.50 | $3.05 | $0.45 |
| 211662 | 2020-04-28 | $42.52 | USPSFirstClass | 3 | 1.11 lbs | $10.75 | $7.75 | $3.00 |
| 211663 | 2020-04-28 | $294.60 | Ground | 1 | 14.40 lbs | $40.61 | $33.93 | $6.68 |
| 211664 | 2020-04-28 | $24.96 | USPSFirstClass | 1 | 0.13 lbs | $3.95 | $2.84 | $1.11 |
| 211666 | 2020-04-28 | $93.29 | USPSFirstClass | 6 | 2.70 lbs | $24.00 | $8.59 | $15.41 |
| 211667 | 2020-04-28 | $9.41 | USPSFirstClass | 2 | 0.40 lbs | $5.00 | $3.67 | $1.33 |
| 211669 | 2020-04-28 | $18.94 | USPSFirstClass | 1 | 0.95 lbs | $8.00 | $8.12 | $-0.12 |
| 211671 | 2020-04-28 | $7.22 | USPSFirstClass | 1 | 0.10 lbs | $3.95 | $2.84 | $1.11 |
| 211672 | 2020-04-28 | $11.79 | First-Class Mail Stamped Letter | 6 | 0.07 lbs | $3.35 | $3.05 | $0.30 |
| 211673 | 2020-04-28 | $7.01 | USPSFirstClass | 1 | 0.10 lbs | $3.90 | $2.78 | $1.12 |
| 211674 | 2020-04-28 | $23.28 | USPSFirstClass | 1 | 0.40 lbs | $4.75 | $3.31 | $1.44 |
| 211675 | 2020-04-28 | $3.69 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $3.20 | $3.18 | $0.02 |
| 211676 | 2020-04-28 | $37.12 | Priority Mail 2-Day | 3 | 5.30 lbs | $10.35 | $7.56 | $2.79 |
| 211677 | 2020-04-28 | $27.96 | USPSFirstClass | 2 | 1.45 lbs | $13.00 | $9.54 | $3.46 |
| 211678 | 2020-04-28 | $26.39 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.00 | $7.75 | $0.25 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |