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 |
|---|---|---|---|---|---|---|---|---|
| 210723 | 2020-03-31 | $6.19 | First-Class Mail Stamped Letter | 1 | 0.02 lbs | $3.20 | $2.84 | $0.36 |
| 210724 | 2020-03-31 | $16.49 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.18 lbs | $8.00 | $7.65 | $0.35 |
| 210725 | 2020-03-31 | $27.78 | Priority Mail 2-Day Small Flat Rate Box | 2 | 0.55 lbs | $8.50 | $7.65 | $0.85 |
| 210726 | 2020-03-31 | $18.26 | Priority Mail 3-Day | 1 | 0.95 lbs | $8.97 | $8.12 | $0.85 |
| 210728 | 2020-03-31 | $14.95 | First-Class Package Service | 4 | 0.68 lbs | $5.79 | $5.54 | $0.25 |
| 210729 | 2020-03-31 | $44.59 | Priority Mail 3-Day Padded Flat Rate Envelope | 1 | 1.44 lbs | $8.60 | $7.75 | $0.85 |
| 210732 | 2020-03-31 | $32.55 | Priority Mail 2-Day Flat Rate Envelope | 5 | 0.47 lbs | $8.00 | $7.65 | $0.35 |
| 210735 | 2020-03-31 | $30.19 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.45 lbs | $8.00 | $7.65 | $0.35 |
| 210737 | 2020-03-31 | $8.31 | First-Class Mail Stamped Letter | 4 | 0.08 lbs | $3.35 | $3.05 | $0.30 |
| 210738 | 2020-03-31 | $26.39 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.00 | $7.75 | $0.25 |
| 210739 | 2020-03-31 | $28.85 | Priority Mail 3-Day Small Flat Rate Box | 2 | 0.20 lbs | $8.50 | $7.65 | $0.85 |
| 210744 | 2020-03-31 | $49.97 | Priority Mail 3-Day | 2 | 1.30 lbs | $11.39 | $10.53 | $0.86 |
| 210745 | 2020-03-31 | $19.44 | First-Class Package Service | 1 | 0.42 lbs | $4.45 | $4.00 | $0.45 |
| 210748 | 2020-03-16 | $206.82 | Priority Mail 2-Day | 8 | 6.50 lbs | $0.00 | $17.35 | $-17.35 |
| 210750 | 2020-03-31 | $27.36 | Priority Mail 2-Day Flat Rate Envelope | 14 | 0.31 lbs | $8.00 | $7.65 | $0.35 |
| 210753 | 2020-03-31 | $36.79 | Priority Mail 3-Day Flat Rate Envelope | 1 | 1.15 lbs | $8.00 | $7.65 | $0.35 |
| 210754 | 2020-03-31 | $83.02 | Priority Mail 2-Day | 2 | 2.40 lbs | $9.44 | $8.59 | $0.85 |
| 210756 | 2020-03-31 | $14.12 | First-Class Package Service | 1 | 0.45 lbs | $4.77 | $4.32 | $0.45 |
| 210757 | 2020-03-31 | $22.25 | Ground | 1 | 0.35 lbs | $12.26 | $13.51 | $-1.25 |
| 210758 | 2020-04-01 | $32.01 | Priority Mail 3-Day | 3 | 2.06 lbs | $9.44 | $9.07 | $0.37 |
| 210759 | 2020-04-01 | $17.98 | Priority Mail 3-Day Flat Rate Envelope | 2 | 0.90 lbs | $8.00 | $7.65 | $0.35 |
| 210761 | 2020-04-01 | $124.91 | Priority Mail 2-Day | 2 | 10.88 lbs | $25.03 | $24.18 | $0.85 |
| 210764 | 2020-04-01 | $38.96 | Ground | 1 | 0.45 lbs | $22.17 | $19.62 | $2.55 |
| 210765 | 2020-04-01 | $9.47 | First-Class Mail Stamped Letter | 3 | 0.12 lbs | $3.50 | $2.78 | $0.72 |
| 210766 | 2020-04-01 | $50.13 | Ground | 3 | 1.50 lbs | $19.96 | $17.46 | $2.50 |
| 210767 | 2020-04-01 | $20.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.19 lbs | $8.00 | $7.15 | $0.85 |
| 210768 | 2020-04-01 | $24.06 | Priority Mail 2-Day | 5 | 1.25 lbs | $9.61 | $8.76 | $0.85 |
| 210769 | 2020-04-01 | $324.55 | Priority Mail 2-Day | 2 | 15.55 lbs | $49.07 | $52.95 | $-3.88 |
| 210772 | 2020-04-01 | $8.15 | First-Class Mail Stamped Letter | 5 | 0.02 lbs | $3.20 | $3.05 | $0.15 |
| 210773 | 2020-04-01 | $23.95 | Priority Mail 2-Day Medium Flat Rate Box | 10 | 1.90 lbs | $14.05 | $10.53 | $3.52 |
| 210776 | 2020-04-01 | $48.78 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.85 lbs | $8.00 | $7.75 | $0.25 |
| 210784 | 2020-04-02 | $132.42 | Priority Mail 3-Day Large Flat Rate Box | 1 | 12.88 lbs | $19.15 | $13.20 | $5.95 |
| 210785 | 2020-04-02 | $62.43 | Priority Mail 2-Day Medium Flat Rate Box | 2 | 7.10 lbs | $14.45 | $10.42 | $4.03 |
| 210786 | 2020-04-02 | $292.82 | Priority Mail 3-Day | 1 | 15.55 lbs | $42.83 | $44.20 | $-1.37 |
| 210790 | 2020-04-02 | $45.64 | Priority Mail 3-Day Large Flat Rate Box | 1 | 0.57 lbs | $19.15 | $8.76 | $10.39 |
| 210791 | 2020-04-02 | $51.49 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.50 | $7.65 | $0.85 |
| 210795 | 2020-04-02 | $26.29 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 210796 | 2020-04-02 | $56.15 | Priority Mail 2-Day | 5 | 1.63 lbs | $13.00 | $12.15 | $0.85 |
| 210797 | 2020-04-02 | $283.61 | Priority Mail 2-Day | 9 | 7.20 lbs | $38.30 | $31.81 | $6.49 |
| 210798 | 2020-04-02 | $69.53 | Priority Mail 2-Day Flat Rate Envelope | 7 | 0.56 lbs | $8.00 | $7.65 | $0.35 |
| 210799 | 2020-04-02 | $19.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.45 lbs | $8.50 | $7.65 | $0.85 |
| 210800 | 2020-04-02 | $13.82 | First-Class Mail Stamped Letter | 3 | 0.09 lbs | $3.35 | $2.78 | $0.57 |
| 210801 | 2020-04-02 | $71.58 | Priority Mail 2-Day Padded Flat Rate Envelope | 2 | 1.78 lbs | $8.60 | $7.65 | $0.95 |
| 210803 | 2020-04-02 | $4.19 | First-Class Mail Stamped Letter | 1 | 0.02 lbs | $3.20 | $3.25 | $-0.05 |
| 210804 | 2020-04-02 | $71.48 | Priority Mail 2-Day | 1 | 3.85 lbs | $11.49 | $10.64 | $0.85 |
| 210805 | 2020-04-02 | $15.85 | First-Class Mail Stamped Letter | 15 | 0.15 lbs | $3.50 | $3.05 | $0.45 |
| 210806 | 2020-04-02 | $272.94 | Ground Home Delivery | 2 | 22.55 lbs | $36.76 | $31.38 | $5.38 |
| 210807 | 2020-04-02 | $35.87 | Priority Mail 1-Day | 1 | 3.15 lbs | $8.79 | $7.68 | $1.11 |
| 210808 | 2020-04-02 | $10.64 | First-Class Mail Stamped Letter | 1 | 0.19 lbs | $3.65 | $2.84 | $0.81 |
| 210809 | 2020-04-03 | $47.82 | Priority Mail 2-Day | 2 | 1.15 lbs | $10.84 | $9.99 | $0.85 |
| 210811 | 2020-04-03 | $27.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.25 lbs | $8.50 | $7.65 | $0.85 |
| 210812 | 2020-04-03 | $27.70 | Priority Mail 3-Day | 1 | 0.65 lbs | $8.41 | $5.12 | $3.29 |
| 210815 | 2020-04-03 | $78.51 | Priority Mail 2-Day | 21 | 6.75 lbs | $23.32 | $22.47 | $0.85 |
| 210816 | 2020-04-03 | $31.52 | Priority Mail 2-Day | 6 | 2.75 lbs | $11.18 | $8.92 | $2.26 |
| 210818 | 2020-04-03 | $35.77 | Priority Mail 2-Day | 7 | 1.03 lbs | $10.84 | $9.98 | $0.86 |
| 210819 | 2020-04-03 | $37.47 | Priority Mail 3-Day | 1 | 3.10 lbs | $11.18 | $9.53 | $1.65 |
| 210821 | 2020-04-03 | $18.26 | Priority Mail 3-Day | 1 | 0.95 lbs | $8.97 | $8.12 | $0.85 |
| 210822 | 2020-04-03 | $45.64 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.25 lbs | $8.00 | $7.65 | $0.35 |
| 210825 | 2020-04-03 | $41.28 | Priority Mail 2-Day Padded Flat Rate Envelope | 2 | 1.15 lbs | $8.60 | $7.65 | $0.95 |
| 210826 | 2020-04-03 | $19.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 210830 | 2020-04-03 | $38.10 | Priority Mail 2-Day Flat Rate Envelope | 1 | 1.05 lbs | $8.00 | $7.65 | $0.35 |
| 210831 | 2020-04-03 | $73.47 | First-Class Package Service | 6 | 0.52 lbs | $4.57 | $4.32 | $0.25 |
| 210833 | 2020-04-03 | $8.25 | First-Class Mail Stamped Letter | 10 | 0.10 lbs | $3.35 | $3.18 | $0.17 |
| 210834 | 2020-04-03 | $6.69 | First-Class Mail Stamped Letter | 1 | 0.03 lbs | $3.20 | $3.18 | $0.02 |
| 210837 | 2020-04-03 | $6.33 | First-Class Mail Stamped Letter | 2 | 0.10 lbs | $3.35 | $2.93 | $0.42 |
| 210839 | 2020-04-03 | $67.43 | First-Class Package Service | 2 | 0.40 lbs | $4.45 | $4.00 | $0.45 |
| 210842 | 2020-04-03 | $37.90 | Priority Mail 2-Day Flat Rate Envelope | 10 | 0.34 lbs | $8.00 | $7.80 | $0.20 |
| 210845 | 2020-04-03 | $41.49 | Priority Mail 3-Day Small Flat Rate Box | 1 | 0.30 lbs | $8.50 | $7.65 | $0.85 |
| 210846 | 2020-04-04 | $34.49 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.40 lbs | $8.00 | $7.65 | $0.35 |
| 210848 | 2020-04-04 | $50.50 | Ground | 3 | 1.20 lbs | $19.43 | $15.81 | $3.62 |
| 210849 | 2020-04-04 | $23.33 | Priority Mail 2-Day Flat Rate Envelope | 7 | 0.68 lbs | $8.00 | $7.65 | $0.35 |
| 210850 | 2020-04-04 | $41.78 | Priority Mail 3-Day Flat Rate Envelope | 2 | 0.50 lbs | $8.00 | $7.65 | $0.35 |
| 210851 | 2020-04-04 | $68.49 | Priority Mail 3-Day Small Flat Rate Box | 1 | 0.70 lbs | $8.50 | $7.65 | $0.85 |
| 210854 | 2020-04-04 | $9.49 | First-Class Package Service | 1 | 0.13 lbs | $3.50 | $3.52 | $-0.02 |
| 210858 | 2020-04-04 | $4.69 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $3.20 | $2.84 | $0.36 |
| 210861 | 2020-04-04 | $19.95 | First-Class Mail Stamped Letter | 5 | 0.16 lbs | $3.50 | $3.05 | $0.45 |
| 210862 | 2020-04-04 | $26.39 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.00 | $7.75 | $0.25 |
| 210864 | 2020-04-04 | $12.38 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 210865 | 2020-04-04 | $5.18 | First-Class Mail Stamped Letter | 2 | 0.02 lbs | $3.20 | $2.84 | $0.36 |
| 210866 | 2020-04-04 | $16.58 | First-Class Package Service - Retail | 2 | 0.18 lbs | $5.60 | $3.31 | $2.29 |
| 210867 | 2020-04-04 | $135.80 | Direct Link International | 1 | 3.00 lbs | $35.81 | $43.86 | $-8.05 |
| 210870 | 2020-04-04 | $28.58 | Priority Mail 2-Day | 3 | 1.45 lbs | $9.61 | $8.76 | $0.85 |
| 210872 | 2020-04-04 | $71.60 | First-Class Package International Service | 8 | 0.38 lbs | $32.48 | $14.49 | $17.99 |
| 210873 | 2020-04-04 | $26.29 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 210874 | 2020-04-04 | $28.68 | Priority Mail 2-Day | 6 | 1.50 lbs | $14.34 | $10.54 | $3.80 |
| 210876 | 2020-04-04 | $124.11 | Priority Mail 2-Day | 1 | 12.90 lbs | $14.12 | $13.79 | $0.33 |
| 210878 | 2020-04-04 | $35.01 | First-Class Package Service | 4 | 0.86 lbs | $5.72 | $5.27 | $0.45 |
| 210879 | 2020-04-04 | $12.22 | First-Class Mail Stamped Letter | 3 | 0.14 lbs | $3.65 | $2.84 | $0.81 |
| 210881 | 2020-04-04 | $49.01 | Priority Mail 3-Day | 3 | 2.40 lbs | $9.44 | $8.21 | $1.23 |
| 210882 | 2020-04-04 | $6.29 | First-Class Mail Stamped Letter | 6 | 0.06 lbs | $3.35 | $3.18 | $0.17 |
| 210884 | 2020-04-04 | $4.71 | First-Class Mail Stamped Letter | 1 | 0.03 lbs | $3.20 | $3.05 | $0.15 |
| 210885 | 2020-04-04 | $27.89 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.35 lbs | $8.00 | $7.65 | $0.35 |
| 210887 | 2020-04-04 | $18.49 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.50 | $3.52 | $-0.02 |
| 210888 | 2020-04-04 | $32.08 | Priority Mail 3-Day Small Flat Rate Box | 2 | 0.60 lbs | $8.50 | $7.65 | $0.85 |
| 210889 | 2020-04-04 | $44.60 | Priority Mail 2-Day | 1 | 1.35 lbs | $9.61 | $8.92 | $0.69 |
| 210891 | 2020-04-05 | $13.82 | First-Class Mail Stamped Letter | 3 | 0.09 lbs | $3.35 | $2.78 | $0.57 |
| 210892 | 2020-04-05 | $107.37 | Ground | 1 | 8.55 lbs | $23.38 | $20.88 | $2.50 |
| 210893 | 2020-04-05 | $68.49 | Priority Mail 3-Day Small Flat Rate Box | 1 | 0.70 lbs | $8.50 | $7.65 | $0.85 |
| 210894 | 2020-04-05 | $4.67 | First-Class Mail Stamped Letter | 3 | 0.03 lbs | $3.20 | $3.05 | $0.15 |
| 210895 | 2020-04-05 | $42.83 | Priority Mail 3-Day | 1 | 0.75 lbs | $10.84 | $9.99 | $0.85 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |