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 |
|---|---|---|---|---|---|---|---|---|
| 210560 | 2020-03-25 | $5.18 | First-Class Mail Stamped Letter | 2 | 0.02 lbs | $3.20 | $3.18 | $0.02 |
| 210561 | 2020-03-25 | $65.48 | Priority Mail 3-Day | 1 | 3.95 lbs | $11.49 | $10.64 | $0.85 |
| 210564 | 2020-03-25 | $5.69 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.50 | $2.84 | $0.66 |
| 210566 | 2020-03-25 | $16.98 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.22 lbs | $8.00 | $7.65 | $0.35 |
| 210568 | 2020-03-25 | $20.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 210570 | 2020-03-25 | $51.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.50 lbs | $8.50 | $7.65 | $0.85 |
| 210573 | 2020-03-25 | $51.66 | First-Class Package Service | 2 | 0.30 lbs | $3.76 | $3.31 | $0.45 |
| 210575 | 2020-03-25 | $52.92 | Priority Mail 2-Day | 2 | 2.35 lbs | $9.44 | $8.59 | $0.85 |
| 210579 | 2020-03-26 | $36.79 | Priority Mail 3-Day Flat Rate Envelope | 1 | 1.10 lbs | $8.00 | $7.65 | $0.35 |
| 210581 | 2020-03-26 | $13.19 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.10 lbs | $8.00 | $7.15 | $0.85 |
| 210582 | 2020-03-26 | $68.49 | Priority Mail 3-Day Small Flat Rate Box | 1 | 0.70 lbs | $8.50 | $7.65 | $0.85 |
| 210583 | 2020-03-26 | $106.97 | Priority Mail 3-Day | 4 | 3.30 lbs | $15.01 | $13.20 | $1.81 |
| 210584 | 2020-03-26 | $13.22 | First-Class Mail Stamped Letter | 5 | 0.18 lbs | $3.50 | $3.21 | $0.29 |
| 210585 | 2020-03-26 | $79.19 | Priority Mail 3-Day | 3 | 2.65 lbs | $9.92 | $8.59 | $1.33 |
| 210586 | 2020-03-26 | $24.99 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.35 lbs | $8.50 | $7.65 | $0.85 |
| 210589 | 2020-03-26 | $541.93 | Priority Mail 2-Day Large Flat Rate Box | 14 | 19.90 lbs | $19.15 | $18.30 | $0.85 |
| 210592 | 2020-03-26 | $34.56 | First-Class Package Service | 3 | 0.66 lbs | $5.79 | $5.54 | $0.25 |
| 210593 | 2020-03-26 | $47.63 | Priority Mail 2-Day | 1 | 1.15 lbs | $10.84 | $9.99 | $0.85 |
| 210595 | 2020-03-26 | $8.99 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.50 | $3.25 | $0.25 |
| 210596 | 2020-03-26 | $19.79 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 210597 | 2020-03-26 | $61.24 | Priority Mail 3-Day | 2 | 5.19 lbs | $10.54 | $16.90 | $-6.36 |
| 210599 | 2020-03-26 | $35.46 | Priority Mail 2-Day Small Flat Rate Box | 4 | 0.14 lbs | $8.50 | $7.65 | $0.85 |
| 210601 | 2020-03-27 | $75.61 | Priority Mail 3-Day | 3 | 2.65 lbs | $14.34 | $10.53 | $3.81 |
| 210603 | 2020-03-27 | $114.41 | Priority Mail 3-Day Medium Flat Rate Box | 4 | 3.90 lbs | $14.45 | $13.20 | $1.25 |
| 210604 | 2020-03-27 | $29.01 | First-Class Package Service | 2 | 0.41 lbs | $4.63 | $4.18 | $0.45 |
| 210607 | 2020-03-27 | $53.07 | Priority Mail 2-Day | 16 | 0.36 lbs | $9.61 | $7.80 | $1.81 |
| 210608 | 2020-03-27 | $17.48 | First-Class Mail Stamped Letter | 2 | 0.13 lbs | $3.50 | $2.84 | $0.66 |
| 210609 | 2020-03-27 | $92.48 | Priority Mail 2-Day | 3 | 3.40 lbs | $16.91 | $18.46 | $-1.55 |
| 210618 | 2020-03-27 | $36.49 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.50 | $7.65 | $0.85 |
| 210619 | 2020-03-27 | $44.59 | Priority Mail 3-Day | 2 | 1.48 lbs | $9.61 | $7.65 | $1.96 |
| 210623 | 2020-03-27 | $51.33 | Priority Mail 3-Day | 1 | 2.20 lbs | $14.34 | $11.13 | $3.21 |
| 210624 | 2020-03-28 | $44.37 | Priority Mail 3-Day | 4 | 1.19 lbs | $9.61 | $8.76 | $0.85 |
| 210625 | 2020-03-28 | $13.18 | First-Class Package Service | 3 | 0.40 lbs | $4.71 | $3.67 | $1.04 |
| 210629 | 2020-03-28 | $23.15 | Priority Mail 3-Day | 2 | 1.15 lbs | $8.97 | $8.59 | $0.38 |
| 210630 | 2020-03-28 | $31.37 | First-Class Package Service | 15 | 0.68 lbs | $5.52 | $5.27 | $0.25 |
| 210631 | 2020-03-28 | $44.79 | Priority Mail International Flat Rate Envelope | 1 | 0.90 lbs | $26.40 | $25.55 | $0.85 |
| 210633 | 2020-03-28 | $4.34 | First-Class Mail Stamped Letter | 1 | 0.03 lbs | $3.35 | $3.31 | $0.04 |
| 210634 | 2020-03-28 | $175.59 | Priority Mail 2-Day | 4 | 10.69 lbs | $18.53 | $17.68 | $0.85 |
| 210635 | 2020-03-28 | $37.49 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.51 lbs | $8.00 | $7.65 | $0.35 |
| 210636 | 2020-03-28 | $8.49 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.50 | $3.05 | $0.45 |
| 210637 | 2020-03-28 | $92.12 | Ground | 3 | 4.00 lbs | $22.75 | $18.78 | $3.97 |
| 210638 | 2020-03-28 | $20.23 | First-Class Package Service | 2 | 0.60 lbs | $5.65 | $5.40 | $0.25 |
| 210640 | 2020-03-28 | $13.97 | Priority Mail 2-Day Flat Rate Envelope | 3 | 0.12 lbs | $8.00 | $7.15 | $0.85 |
| 210641 | 2020-03-28 | $82.23 | Priority Mail 2-Day Medium Flat Rate Box | 2 | 2.70 lbs | $14.45 | $13.20 | $1.25 |
| 210642 | 2020-03-28 | $10.34 | First-Class Mail Stamped Letter | 1 | 0.07 lbs | $3.35 | $3.05 | $0.30 |
| 210643 | 2020-03-28 | $23.57 | Priority Mail 2-Day Flat Rate Envelope | 3 | 0.20 lbs | $8.00 | $7.15 | $0.85 |
| 210644 | 2020-03-28 | $80.97 | Priority Mail 2-Day | 22 | 2.38 lbs | $18.99 | $18.14 | $0.85 |
| 210645 | 2020-03-28 | $157.15 | Ground | 1 | 11.40 lbs | $29.96 | $24.31 | $5.65 |
| 210646 | 2020-03-28 | $31.53 | First-Class Package Service | 2 | 0.60 lbs | $4.25 | $5.12 | $-0.87 |
| 210648 | 2020-03-28 | $34.48 | First-Class Package Service | 4 | 0.28 lbs | $3.92 | $3.67 | $0.25 |
| 210649 | 2020-03-28 | $61.01 | Priority Mail 2-Day | 3 | 1.29 lbs | $12.04 | $11.19 | $0.85 |
| 210650 | 2020-03-28 | $8.08 | First-Class Mail Stamped Letter | 2 | 0.10 lbs | $3.50 | $2.78 | $0.72 |
| 210651 | 2020-03-28 | $37.18 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.57 lbs | $8.00 | $7.65 | $0.35 |
| 210652 | 2020-03-28 | $38.83 | Priority Mail 2-Day | 1 | 0.95 lbs | $10.84 | $10.42 | $0.42 |
| 210656 | 2020-03-28 | $14.99 | First-Class Package Service | 7 | 0.27 lbs | $3.56 | $3.31 | $0.25 |
| 210657 | 2020-03-29 | $23.96 | Priority Mail 3-Day | 3 | 1.13 lbs | $11.39 | $10.53 | $0.86 |
| 210659 | 2020-03-29 | $84.30 | Priority Mail 3-Day | 1 | 3.60 lbs | $19.31 | $18.46 | $0.85 |
| 210660 | 2020-03-29 | $209.08 | Priority Mail 2-Day | 5 | 14.81 lbs | $21.63 | $21.77 | $-0.14 |
| 210661 | 2020-03-29 | $50.29 | Priority Mail 2-Day | 2 | 1.35 lbs | $10.84 | $9.99 | $0.85 |
| 210662 | 2020-03-29 | $20.09 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 1.15 lbs | $8.60 | $7.65 | $0.95 |
| 210663 | 2020-03-29 | $14.48 | Priority Mail 2-Day Small Flat Rate Box | 2 | 0.06 lbs | $8.50 | $7.65 | $0.85 |
| 210664 | 2020-03-29 | $6.19 | First-Class Mail Stamped Letter | 1 | 0.03 lbs | $3.20 | $2.84 | $0.36 |
| 210665 | 2020-03-29 | $20.68 | Priority Mail 3-Day | 1 | 0.95 lbs | $11.39 | $10.54 | $0.85 |
| 210666 | 2020-03-29 | $8.54 | First-Class Mail Stamped Letter | 1 | 0.08 lbs | $3.35 | $2.84 | $0.51 |
| 210667 | 2020-03-29 | $194.43 | Priority Mail 2-Day Medium Flat Rate Box | 2 | 18.20 lbs | $14.45 | $13.20 | $1.25 |
| 210669 | 2020-03-29 | $7.83 | First-Class Mail Stamped Letter | 2 | 0.06 lbs | $3.35 | $3.05 | $0.30 |
| 210672 | 2020-03-29 | $23.80 | Priority Mail 2-Day | 3 | 0.47 lbs | $8.83 | $7.98 | $0.85 |
| 210673 | 2020-03-29 | $13.89 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.50 | $3.25 | $0.25 |
| 210674 | 2020-03-29 | $9.08 | First-Class Mail Stamped Letter | 2 | 0.12 lbs | $3.50 | $2.78 | $0.72 |
| 210675 | 2020-03-29 | $8.54 | First-Class Mail Stamped Letter | 1 | 0.07 lbs | $3.35 | $2.78 | $0.57 |
| 210676 | 2020-03-29 | $23.72 | First-Class Package Service | 1 | 0.60 lbs | $4.43 | $5.40 | $-0.97 |
| 210677 | 2020-03-29 | $8.69 | First-Class Mail Stamped Letter | 1 | 0.15 lbs | $3.50 | $2.84 | $0.66 |
| 210678 | 2020-03-29 | $58.82 | Priority Mail 2-Day | 8 | 2.01 lbs | $13.00 | $12.15 | $0.85 |
| 210681 | 2020-03-29 | $30.17 | 2-Day | 2 | 0.38 lbs | $25.99 | $22.60 | $3.39 |
| 210682 | 2020-03-29 | $26.29 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 210684 | 2020-03-30 | $20.53 | Priority Mail 2-Day | 4 | 1.60 lbs | $8.97 | $8.12 | $0.85 |
| 210686 | 2020-03-30 | $68.88 | Priority Mail 2-Day | 1 | 3.85 lbs | $8.89 | $9.39 | $-0.50 |
| 210687 | 2020-03-30 | $28.96 | Priority Mail 2-Day Flat Rate Envelope | 4 | 0.33 lbs | $8.00 | $7.65 | $0.35 |
| 210689 | 2020-03-30 | $48.83 | Priority Mail 2-Day | 1 | 1.20 lbs | $12.04 | $11.19 | $0.85 |
| 210690 | 2020-03-30 | $6.34 | First-Class Mail Stamped Letter | 1 | 0.03 lbs | $3.35 | $2.84 | $0.51 |
| 210691 | 2020-03-30 | $128.43 | Priority Mail 3-Day Medium Flat Rate Box | 2 | 11.80 lbs | $14.45 | $8.92 | $5.53 |
| 210692 | 2020-03-30 | $14.03 | First-Class Mail Stamped Letter | 2 | 0.17 lbs | $3.65 | $2.84 | $0.81 |
| 210694 | 2020-03-30 | $107.68 | First-Class Package International Service | 8 | 1.62 lbs | $27.96 | $19.71 | $8.25 |
| 210695 | 2020-03-30 | $7.34 | First-Class Mail Stamped Letter | 1 | 0.07 lbs | $3.35 | $2.78 | $0.57 |
| 210699 | 2020-03-30 | $9.64 | First-Class Mail Stamped Letter | 1 | 0.18 lbs | $3.65 | $3.25 | $0.40 |
| 210700 | 2020-03-30 | $14.67 | Priority Mail 3-Day Small Flat Rate Box | 3 | 0.25 lbs | $8.50 | $7.65 | $0.85 |
| 210701 | 2020-03-30 | $13.82 | First-Class Mail Stamped Letter | 3 | 0.09 lbs | $3.35 | $2.93 | $0.42 |
| 210702 | 2020-03-30 | $10.99 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.50 | $3.25 | $0.25 |
| 210704 | 2020-03-30 | $41.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.40 lbs | $8.50 | $7.65 | $0.85 |
| 210707 | 2020-03-30 | $73.16 | Ground | 2 | 9.20 lbs | $23.38 | $24.20 | $-0.82 |
| 210709 | 2020-03-30 | $67.43 | Priority Mail 2-Day | 7 | 2.04 lbs | $9.44 | $8.59 | $0.85 |
| 210710 | 2020-03-31 | $275.62 | Priority Mail 3-Day | 1 | 14.95 lbs | $21.63 | $22.75 | $-1.12 |
| 210712 | 2020-03-31 | $31.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 1.00 lbs | $8.00 | $7.75 | $0.25 |
| 210713 | 2020-03-31 | $8.30 | First-Class Mail Stamped Letter | 5 | 0.06 lbs | $3.35 | $3.05 | $0.30 |
| 210714 | 2020-03-31 | $275.62 | Priority Mail 2-Day | 1 | 14.40 lbs | $21.63 | $21.77 | $-0.14 |
| 210715 | 2020-03-31 | $18.38 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.20 lbs | $8.00 | $7.15 | $0.85 |
| 210717 | 2020-03-31 | $4.67 | First-Class Mail Stamped Letter | 3 | 0.03 lbs | $3.20 | $2.78 | $0.42 |
| 210720 | 2020-03-31 | $43.49 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.40 lbs | $8.50 | $7.65 | $0.85 |
| 210721 | 2020-03-31 | $43.65 | Priority Mail 2-Day Flat Rate Envelope | 15 | 0.67 lbs | $8.00 | $7.65 | $0.35 |
| 210722 | 2020-03-31 | $7.82 | First-Class Mail Stamped Letter | 3 | 0.15 lbs | $3.35 | $2.84 | $0.51 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |