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 |
|---|---|---|---|---|---|---|---|---|
| 211680 | 2020-04-28 | $51.33 | Priority Mail 2-Day | 1 | 2.20 lbs | $14.34 | $11.13 | $3.21 |
| 211681 | 2020-04-29 | $17.89 | USPSFirstClass | 1 | 0.40 lbs | $4.70 | $3.25 | $1.45 |
| 211682 | 2020-04-29 | $6.90 | USPSFirstClass | 1 | 0.10 lbs | $3.80 | $2.74 | $1.06 |
| 211683 | 2020-04-29 | $21.99 | USPSFirstClass | 1 | 0.15 lbs | $4.00 | $2.93 | $1.07 |
| 211684 | 2020-04-29 | $11.31 | USPSFirstClass | 1 | 0.07 lbs | $3.90 | $2.78 | $1.12 |
| 211685 | 2020-04-29 | $16.24 | USPSFirstClass | 1 | 0.37 lbs | $4.80 | $3.39 | $1.41 |
| 211686 | 2020-04-29 | $16.24 | USPSFirstClass | 1 | 0.37 lbs | $4.80 | $3.39 | $1.41 |
| 211688 | 2020-04-28 | $80.20 | Priority Mail 3-Day | 6 | 2.55 lbs | $18.99 | $12.10 | $6.89 |
| 211689 | 2020-04-29 | $19.14 | USPSFirstClass | 1 | 0.95 lbs | $8.45 | $9.99 | $-1.54 |
| 211691 | 2020-04-28 | $27.98 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.39 lbs | $8.00 | $7.65 | $0.35 |
| 211692 | 2020-04-29 | $7.10 | USPSFirstClass | 1 | 0.10 lbs | $3.95 | $2.84 | $1.11 |
| 211693 | 2020-04-29 | $22.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 211694 | 2020-04-29 | $86.05 | USPSPriority | 1 | 21.45 lbs | $48.80 | $35.71 | $13.09 |
| 211695 | 2020-04-29 | $19.99 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.35 lbs | $8.00 | $7.65 | $0.35 |
| 211696 | 2020-04-29 | $147.73 | Priority Mail 2-Day | 1 | 10.30 lbs | $17.74 | $16.89 | $0.85 |
| 211702 | 2020-04-29 | $9.14 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.93 | $0.42 |
| 211704 | 2020-04-29 | $9.27 | USPSFirstClass | 2 | 0.40 lbs | $4.90 | $3.52 | $1.38 |
| 211705 | 2020-04-29 | $21.99 | First-Class Package Service | 4 | 0.56 lbs | $4.33 | $4.08 | $0.25 |
| 211706 | 2020-04-29 | $44.02 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.60 lbs | $8.00 | $7.65 | $0.35 |
| 211707 | 2020-04-29 | $35.15 | Priority Mail 3-Day | 3 | 2.40 lbs | $11.18 | $10.33 | $0.85 |
| 211708 | 2020-04-29 | $13.99 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.19 lbs | $8.00 | $7.65 | $0.35 |
| 211710 | 2020-04-29 | $14.99 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.19 lbs | $8.00 | $7.65 | $0.35 |
| 211711 | 2020-04-28 | $40.73 | First-Class Mail Stamped Letter | 2 | 0.95 lbs | $11.35 | $7.75 | $3.60 |
| 211712 | 2020-04-29 | $16.37 | Priority Mail 2-Day Flat Rate Envelope | 3 | 0.18 lbs | $8.00 | $7.15 | $0.85 |
| 211713 | 2020-04-29 | $12.36 | USPSFirstClass | 1 | 0.20 lbs | $3.90 | $2.78 | $1.12 |
| 211714 | 2020-04-29 | $411.50 | Ground | 11 | 17.20 lbs | $30.69 | $32.36 | $-1.67 |
| 211715 | 2020-04-29 | $214.43 | Priority Mail 2-Day Medium Flat Rate Box | 2 | 21.40 lbs | $14.45 | $13.20 | $1.25 |
| 211716 | 2020-04-29 | $76.48 | Priority Mail 3-Day | 1 | 3.60 lbs | $11.49 | $10.64 | $0.85 |
| 211718 | 2020-04-30 | $23.84 | USPSFirstClass | 1 | 0.06 lbs | $4.00 | $2.93 | $1.07 |
| 211719 | 2020-04-29 | $16.42 | First-Class Package Service | 1 | 0.55 lbs | $4.63 | $4.18 | $0.45 |
| 211721 | 2020-04-29 | $26.39 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.00 | $7.75 | $0.25 |
| 211722 | 2020-04-29 | $4.67 | First-Class Mail Stamped Letter | 3 | 0.03 lbs | $3.20 | $3.05 | $0.15 |
| 211725 | 2020-04-29 | $52.19 | Priority Mail 2-Day | 5 | 1.15 lbs | $10.84 | $9.98 | $0.86 |
| 211726 | 2020-04-29 | $29.75 | Priority Mail 2-Day | 3 | 0.70 lbs | $8.97 | $8.12 | $0.85 |
| 211727 | 2020-04-30 | $5.94 | USPSFirstClass | 1 | 0.03 lbs | $3.95 | $2.84 | $1.11 |
| 211729 | 2020-04-30 | $18.53 | USPSFirstClass | 4 | 0.14 lbs | $7.80 | $7.65 | $0.15 |
| 211732 | 2020-04-30 | $125.38 | Priority Mail 3-Day | 10 | 3.35 lbs | $9.92 | $8.21 | $1.71 |
| 211735 | 2020-04-30 | $19.14 | USPSFirstClass | 1 | 0.95 lbs | $8.45 | $9.99 | $-1.54 |
| 211737 | 2020-04-30 | $34.77 | USPSFirstClass | 1 | 0.50 lbs | $5.00 | $17.07 | $-12.07 |
| 211739 | 2020-04-30 | $5.29 | USPSFirstClass | 1 | 0.03 lbs | $4.00 | $2.93 | $1.07 |
| 211740 | 2020-04-30 | $13.28 | First-Class Mail Stamped Letter | 2 | 0.10 lbs | $3.50 | $3.18 | $0.32 |
| 211743 | 2020-04-30 | $36.66 | USPSFirstClass | 4 | 1.20 lbs | $13.75 | $11.13 | $2.62 |
| 211744 | 2020-04-30 | $36.45 | Priority Mail 2-Day Small Flat Rate Box | 5 | 0.25 lbs | $8.50 | $7.65 | $0.85 |
| 211745 | 2020-04-30 | $32.08 | Priority Mail 3-Day Small Flat Rate Box | 2 | 0.60 lbs | $8.50 | $7.65 | $0.85 |
| 211747 | 2020-04-30 | $81.07 | Priority Mail 2-Day Flat Rate Envelope | 2 | 2.45 lbs | $8.00 | $7.75 | $0.25 |
| 211748 | 2020-04-30 | $7.99 | USPSFirstClass | 2 | 0.10 lbs | $4.05 | $3.05 | $1.00 |
| 211749 | 2020-04-30 | $17.88 | USPSFirstClass | 2 | 0.10 lbs | $8.10 | $7.65 | $0.45 |
| 211751 | 2020-04-30 | $59.92 | Priority Mail 3-Day | 2 | 1.90 lbs | $14.34 | $13.49 | $0.85 |
| 211752 | 2020-04-30 | $38.29 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.00 lbs | $8.50 | $7.65 | $0.85 |
| 211753 | 2020-04-30 | $24.66 | First-Class Package Service | 1 | 0.65 lbs | $5.37 | $5.12 | $0.25 |
| 211755 | 2020-04-30 | $51.07 | Priority Mail 2-Day | 12 | 1.26 lbs | $11.39 | $10.54 | $0.85 |
| 211756 | 2020-04-30 | $12.59 | USPSFirstClass | 2 | 0.10 lbs | $3.95 | $2.84 | $1.11 |
| 211758 | 2020-04-30 | $22.58 | USPSFirstClass | 2 | 0.40 lbs | $4.75 | $4.08 | $0.67 |
| 211759 | 2020-04-30 | $3.69 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $3.20 | $2.84 | $0.36 |
| 211760 | 2020-04-30 | $19.11 | USPSFirstClass | 1 | 0.19 lbs | $4.00 | $3.39 | $0.61 |
| 211761 | 2020-04-30 | $47.48 | First-Class Package Service | 4 | 0.79 lbs | $5.72 | $5.12 | $0.60 |
| 211762 | 2020-04-30 | $9.69 | USPSFirstClass | 1 | 0.05 lbs | $4.20 | $3.18 | $1.02 |
| 211763 | 2020-04-30 | $19.06 | USPSFirstClass | 2 | 0.10 lbs | $4.00 | $2.93 | $1.07 |
| 211764 | 2020-04-30 | $52.42 | Priority Mail 2-Day | 2 | 1.73 lbs | $9.44 | $8.59 | $0.85 |
| 211766 | 2020-04-30 | $7.27 | First-Class Mail Stamped Letter | 8 | 0.08 lbs | $3.35 | $3.18 | $0.17 |
| 211767 | 2020-04-30 | $17.78 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.90 lbs | $8.00 | $7.65 | $0.35 |
| 211768 | 2020-04-30 | $20.98 | Priority Mail 2-Day Small Flat Rate Box | 2 | 0.40 lbs | $8.50 | $7.65 | $0.85 |
| 211769 | 2020-04-30 | $65.24 | USPSFirstClass | 10 | 2.16 lbs | $25.70 | $10.42 | $15.28 |
| 211772 | 2020-04-30 | $34.28 | First-Class Package Service | 7 | 0.71 lbs | $5.65 | $5.40 | $0.25 |
| 211773 | 2020-04-30 | $23.45 | Priority Mail 3-Day Flat Rate Envelope | 5 | 0.25 lbs | $8.00 | $7.65 | $0.35 |
| 211774 | 2020-05-01 | $9.34 | USPSFirstClass | 1 | 0.25 lbs | $3.95 | $3.31 | $0.64 |
| 211775 | 2020-04-30 | $21.93 | Priority Mail 2-Day Small Flat Rate Box | 7 | 0.18 lbs | $8.50 | $7.65 | $0.85 |
| 211776 | 2020-05-01 | $13.33 | USPSFirstClass | 2 | 0.07 lbs | $8.00 | $7.65 | $0.35 |
| 211777 | 2020-05-01 | $6.00 | USPSFirstClass | 1 | 0.10 lbs | $0.70 | $3.18 | $-2.48 |
| 211779 | 2020-04-30 | $36.79 | Priority Mail 3-Day Flat Rate Envelope | 1 | 1.10 lbs | $8.00 | $7.65 | $0.35 |
| 211780 | 2020-04-30 | $34.18 | Priority Mail 2-Day | 1 | 0.95 lbs | $11.39 | $10.54 | $0.85 |
| 211782 | 2020-04-30 | $41.48 | Priority Mail International Flat Rate Envelope | 2 | 0.25 lbs | $37.50 | $36.65 | $0.85 |
| 211783 | 2020-04-30 | $131.58 | Priority Mail 2-Day | 6 | 4.43 lbs | $10.24 | $9.39 | $0.85 |
| 211784 | 2020-05-01 | $11.76 | USPSFirstClass | 1 | 0.20 lbs | $4.20 | $4.46 | $-0.26 |
| 211785 | 2020-05-01 | $28.71 | USPSFirstClass | 3 | 0.15 lbs | $11.85 | $2.84 | $9.01 |
| 211786 | 2020-05-01 | $8.91 | USPSFirstClass | 1 | 0.07 lbs | $4.00 | $2.93 | $1.07 |
| 211787 | 2020-04-30 | $50.57 | Priority Mail 3-Day | 2 | 1.47 lbs | $11.39 | $10.53 | $0.86 |
| 211788 | 2020-05-01 | $20.35 | USPSFirstClass | 1 | 0.95 lbs | $8.85 | $10.54 | $-1.69 |
| 211789 | 2020-05-01 | $103.84 | Priority Mail 3-Day | 4 | 3.10 lbs | $11.18 | $10.33 | $0.85 |
| 211790 | 2020-05-01 | $21.28 | First-Class Package Service | 1 | 0.60 lbs | $5.99 | $4.32 | $1.67 |
| 211791 | 2020-05-01 | $20.38 | USPSFirstClass | 2 | 0.60 lbs | $5.65 | $5.54 | $0.11 |
| 211793 | 2020-05-01 | $122.49 | Priority Mail 2-Day | 3 | 3.25 lbs | $9.92 | $9.39 | $0.53 |
| 211795 | 2020-05-01 | $67.58 | Priority Mail 2-Day Flat Rate Envelope | 2 | 2.70 lbs | $8.00 | $7.75 | $0.25 |
| 211796 | 2020-05-01 | $33.74 | Priority Mail 3-Day Medium Flat Rate Box | 1 | 0.65 lbs | $14.45 | $7.56 | $6.89 |
| 211797 | 2020-05-01 | $29.42 | Priority Mail 3-Day | 2 | 1.90 lbs | $9.44 | $8.59 | $0.85 |
| 211798 | 2020-05-01 | $9.17 | USPSFirstClass | 1 | 0.05 lbs | $3.90 | $2.78 | $1.12 |
| 211799 | 2020-04-29 | $57.57 | Priority Mail 2-Day Small Flat Rate Box | 3 | 1.74 lbs | $17.00 | $7.75 | $9.25 |
| 211800 | 2020-05-01 | $37.58 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.00 lbs | $8.50 | $7.65 | $0.85 |
| 211802 | 2020-05-01 | $6.04 | First-Class Mail Stamped Letter | 1 | 0.03 lbs | $3.35 | $2.93 | $0.42 |
| 211803 | 2020-05-01 | $39.49 | USPSPriority | 3 | 6.90 lbs | $15.40 | $8.12 | $7.28 |
| 211805 | 2020-05-01 | $20.76 | Priority Mail 2-Day | 1 | 0.55 lbs | $8.97 | $7.65 | $1.32 |
| 211806 | 2020-05-01 | $8.71 | USPSFirstClass | 1 | 0.10 lbs | $3.90 | $2.78 | $1.12 |
| 211808 | 2020-05-01 | $12.23 | USPSFirstClass | 1 | 0.20 lbs | $3.90 | $3.25 | $0.65 |
| 211809 | 2020-05-01 | $7.21 | USPSFirstClass | 1 | 0.07 lbs | $4.00 | $2.93 | $1.07 |
| 211810 | 2020-05-01 | $5.53 | USPSFirstClass | 1 | 0.05 lbs | $3.90 | $2.78 | $1.12 |
| 211811 | 2020-05-01 | $28.50 | Priority Mail 1-Day Flat Rate Envelope | 1 | 0.35 lbs | $8.00 | $7.65 | $0.35 |
| 211813 | 2020-05-01 | $37.19 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.45 lbs | $8.00 | $7.65 | $0.35 |
| 211814 | 2020-05-01 | $29.68 | Priority Mail 2-Day Small Flat Rate Box | 2 | 0.74 lbs | $8.50 | $7.65 | $0.85 |
| 211815 | 2020-05-02 | $83.24 | USPSPriority | 1 | 2.85 lbs | $13.25 | $10.42 | $2.83 |
| 211816 | 2020-05-01 | $29.88 | Priority Mail 2-Day | 1 | 2.14 lbs | $10.39 | $8.92 | $1.47 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |