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 |
|---|---|---|---|---|---|---|---|---|
| 210896 | 2020-04-05 | $14.97 | Priority Mail 3-Day Flat Rate Envelope | 3 | 0.48 lbs | $8.00 | $7.65 | $0.35 |
| 210898 | 2020-04-05 | $5.09 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $3.20 | $2.84 | $0.36 |
| 210899 | 2020-04-05 | $47.35 | Priority Mail 2-Day | 2 | 0.80 lbs | $8.97 | $8.12 | $0.85 |
| 210902 | 2020-04-05 | $80.38 | Priority Mail 2-Day | 1 | 0.90 lbs | $10.39 | $10.64 | $-0.25 |
| 210903 | 2020-04-05 | $18.36 | Priority Mail 2-Day Flat Rate Envelope | 4 | 0.27 lbs | $8.00 | $7.65 | $0.35 |
| 210905 | 2020-04-05 | $28.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.45 lbs | $8.00 | $7.65 | $0.35 |
| 210908 | 2020-04-05 | $6.24 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.05 | $0.30 |
| 210909 | 2020-04-05 | $36.93 | Priority Mail 2-Day Flat Rate Envelope | 7 | 0.28 lbs | $8.00 | $7.65 | $0.35 |
| 210910 | 2020-04-05 | $239.31 | Ground Home Delivery | 1 | 21.00 lbs | $46.12 | $56.26 | $-10.14 |
| 210919 | 2020-04-05 | $45.64 | Priority Mail 2-Day Large Flat Rate Box | 1 | 0.57 lbs | $19.15 | $7.56 | $11.59 |
| 210920 | 2020-04-05 | $12.32 | First-Class Mail Stamped Letter | 3 | 0.10 lbs | $3.35 | $2.93 | $0.42 |
| 210922 | 2020-04-05 | $254.06 | Ground | 7 | 8.65 lbs | $41.90 | $26.17 | $15.73 |
| 210923 | 2020-04-05 | $22.68 | First-Class Mail Stamped Letter | 2 | 0.12 lbs | $3.50 | $3.05 | $0.45 |
| 210924 | 2020-04-05 | $13.88 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.24 lbs | $8.00 | $7.65 | $0.35 |
| 210925 | 2020-04-06 | $27.70 | Priority Mail 3-Day | 1 | 0.60 lbs | $8.41 | $7.56 | $0.85 |
| 210926 | 2020-04-06 | $9.33 | First-Class Mail Stamped Letter | 2 | 0.06 lbs | $3.35 | $2.84 | $0.51 |
| 210927 | 2020-04-06 | $10.33 | First-Class Mail Stamped Letter | 2 | 0.10 lbs | $3.35 | $3.18 | $0.17 |
| 210929 | 2020-04-06 | $42.18 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.40 lbs | $8.00 | $7.65 | $0.35 |
| 210930 | 2020-04-06 | $56.42 | Priority Mail 2-Day | 1 | 0.80 lbs | $8.97 | $8.21 | $0.76 |
| 210932 | 2020-04-06 | $33.56 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.50 | $7.65 | $0.85 |
| 210933 | 2020-04-06 | $21.38 | Priority Mail 2-Day Flat Rate Envelope | 12 | 0.35 lbs | $8.00 | $7.65 | $0.35 |
| 210936 | 2020-04-06 | $24.66 | First-Class Package Service | 1 | 0.65 lbs | $5.37 | $5.12 | $0.25 |
| 210937 | 2020-04-06 | $9.33 | First-Class Mail Stamped Letter | 2 | 0.06 lbs | $3.35 | $3.67 | $-0.32 |
| 210938 | 2020-04-06 | $6.19 | First-Class Mail Stamped Letter | 1 | 0.03 lbs | $3.20 | $2.84 | $0.36 |
| 210939 | 2020-04-06 | $55.22 | Priority Mail 2-Day | 2 | 1.50 lbs | $10.84 | $9.99 | $0.85 |
| 210941 | 2020-04-06 | $52.73 | USPS First Class Package | 6 | 3.20 lbs | $26.40 | $12.10 | $14.30 |
| 210942 | 2020-04-06 | $9.64 | First-Class Package Service | 1 | 0.50 lbs | $5.85 | $4.18 | $1.67 |
| 210943 | 2020-04-06 | $39.74 | Priority Mail 3-Day | 10 | 1.87 lbs | $14.34 | $10.54 | $3.80 |
| 210944 | 2020-04-06 | $23.62 | First-Class Package Service | 1 | 0.60 lbs | $4.33 | $5.27 | $-0.94 |
| 210945 | 2020-04-06 | $50.82 | Priority Mail 2-Day Medium Flat Rate Box | 3 | 3.26 lbs | $14.45 | $13.20 | $1.25 |
| 210946 | 2020-04-06 | $18.61 | First-Class Mail Stamped Letter | 4 | 0.20 lbs | $3.65 | $2.78 | $0.87 |
| 210949 | 2020-04-06 | $10.99 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.05 lbs | $8.00 | $7.65 | $0.35 |
| 210951 | 2020-04-07 | $18.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 210956 | 2020-04-07 | $302.16 | Priority Mail 2-Day | 7 | 23.52 lbs | $29.73 | $28.88 | $0.85 |
| 210958 | 2020-04-07 | $139.98 | Priority Mail International Small Flat Rate Box | 2 | 2.50 lbs | $37.50 | $36.65 | $0.85 |
| 210960 | 2020-04-07 | $45.64 | Priority Mail 3-Day Large Flat Rate Box | 1 | 0.57 lbs | $19.15 | $8.15 | $11.00 |
| 210961 | 2020-04-07 | $93.64 | Priority Mail 2-Day | 3 | 2.95 lbs | $11.18 | $8.92 | $2.26 |
| 210964 | 2020-04-07 | $48.83 | Priority Mail 3-Day | 1 | 1.15 lbs | $12.04 | $11.19 | $0.85 |
| 210965 | 2020-04-07 | $29.38 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.10 lbs | $8.00 | $7.15 | $0.85 |
| 210966 | 2020-04-07 | $8.50 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.45 lbs | $8.50 | $7.65 | $0.85 |
| 210969 | 2020-04-07 | $23.24 | Priority Mail 2-Day Flat Rate Envelope | 6 | 1.14 lbs | $8.00 | $7.65 | $0.35 |
| 210970 | 2020-04-07 | $28.67 | Priority Mail 2-Day | 2 | 1.90 lbs | $8.69 | $7.64 | $1.05 |
| 210971 | 2020-04-07 | $7.48 | First-Class Mail Stamped Letter | 2 | 0.12 lbs | $3.50 | $2.78 | $0.72 |
| 210972 | 2020-04-07 | $37.32 | Priority Mail 2-Day Medium Flat Rate Box | 1 | 1.17 lbs | $7.23 | $7.65 | $-0.42 |
| 210974 | 2020-03-17 | $5.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.03 lbs | $0.00 | $2.78 | $-2.78 |
| 210975 | 2020-04-07 | $41.37 | Priority Mail 2-Day | 7 | 1.17 lbs | $10.84 | $9.99 | $0.85 |
| 210976 | 2020-04-07 | $10.49 | First-Class Package Service | 2 | 0.50 lbs | $4.71 | $4.46 | $0.25 |
| 210977 | 2020-04-07 | $9.48 | First-Class Mail Stamped Letter | 2 | 0.15 lbs | $3.50 | $3.05 | $0.45 |
| 210980 | 2020-04-07 | $14.46 | First-Class Package Service | 3 | 0.75 lbs | $5.79 | $5.54 | $0.25 |
| 210982 | 2020-04-07 | $29.10 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.05 lbs | $8.00 | $7.65 | $0.35 |
| 210983 | 2020-04-07 | $9.38 | First-Class Mail Stamped Letter | 12 | 0.12 lbs | $3.50 | $2.84 | $0.66 |
| 210989 | 2020-04-08 | $18.17 | Priority Mail 2-Day Flat Rate Envelope | 3 | 0.03 lbs | $8.00 | $7.65 | $0.35 |
| 210990 | 2020-04-08 | $13.83 | First-Class Mail Stamped Letter | 2 | 0.16 lbs | $3.65 | $3.25 | $0.40 |
| 210991 | 2020-04-08 | $47.25 | First-Class Package International Service | 1 | 0.65 lbs | $27.96 | $19.71 | $8.25 |
| 210992 | 2020-04-08 | $17.39 | Priority Mail 2-Day | 2 | 1.10 lbs | $9.61 | $8.92 | $0.69 |
| 210994 | 2020-04-08 | $38.48 | Priority Mail 1-Day Small Flat Rate Box | 2 | 1.40 lbs | $8.50 | $7.65 | $0.85 |
| 210995 | 2020-04-08 | $4.19 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $3.20 | $3.18 | $0.02 |
| 210998 | 2020-04-08 | $23.62 | First-Class Package Service | 1 | 0.60 lbs | $4.33 | $4.08 | $0.25 |
| 210999 | 2020-04-08 | $6.13 | First-Class Mail Stamped Letter | 2 | 0.16 lbs | $3.65 | $3.52 | $0.13 |
| 211001 | 2020-04-08 | $9.29 | First-Class Mail Stamped Letter | 6 | 0.06 lbs | $3.35 | $3.18 | $0.17 |
| 211002 | 2020-04-08 | $29.46 | Priority Mail 2-Day | 8 | 0.96 lbs | $10.84 | $9.98 | $0.86 |
| 211004 | 2020-04-08 | $48.09 | Priority Mail 1-Day | 1 | 1.10 lbs | $8.49 | $7.64 | $0.85 |
| 211005 | 2020-04-08 | $23.86 | First-Class Package Service | 1 | 0.60 lbs | $4.57 | $4.32 | $0.25 |
| 211006 | 2020-04-08 | $31.38 | Priority Mail 3-Day | 1 | 1.10 lbs | $11.39 | $10.53 | $0.86 |
| 211007 | 2020-04-08 | $20.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.30 lbs | $8.50 | $8.12 | $0.38 |
| 211010 | 2020-04-09 | $20.83 | Priority Mail 3-Day | 1 | 0.95 lbs | $10.84 | $9.99 | $0.85 |
| 211011 | 2020-04-09 | $11.49 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.05 lbs | $8.00 | $7.15 | $0.85 |
| 211012 | 2020-04-05 | $73.21 | First-Class Package Service | 3 | 1.47 lbs | $25.14 | $10.54 | $14.60 |
| 211013 | 2020-04-09 | $22.78 | First-Class Package Service | 1 | 0.49 lbs | $5.79 | $4.32 | $1.47 |
| 211017 | 2020-04-07 | $163.54 | Priority Mail 3-Day Large Flat Rate Box | 12 | 4.09 lbs | $27.15 | $18.30 | $8.85 |
| 211018 | 2020-04-09 | $51.48 | Priority Mail 2-Day Flat Rate Envelope | 3 | 1.51 lbs | $8.00 | $7.65 | $0.35 |
| 211019 | 2020-03-26 | $5.94 | First-Class Package Service | 6 | 0.06 lbs | $0.00 | $3.05 | $-3.05 |
| 211022 | 2020-04-09 | $12.69 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.22 lbs | $8.50 | $7.65 | $0.85 |
| 211023 | 2020-04-09 | $266.89 | Priority Mail 2-Day | 2 | 22.60 lbs | $28.01 | $28.88 | $-0.87 |
| 211025 | 2020-04-09 | $26.57 | Priority Mail 3-Day Flat Rate Envelope | 3 | 0.35 lbs | $8.00 | $7.65 | $0.35 |
| 211026 | 2020-04-09 | $13.32 | First-Class Mail Stamped Letter | 3 | 0.10 lbs | $3.35 | $2.84 | $0.51 |
| 211028 | 2020-04-09 | $28.94 | Priority Mail 2-Day Flat Rate Envelope | 6 | 0.24 lbs | $8.00 | $7.15 | $0.85 |
| 211029 | 2020-04-09 | $22.78 | First-Class Package Service | 1 | 0.49 lbs | $5.79 | $5.54 | $0.25 |
| 211030 | 2020-04-09 | $5.65 | First-Class Mail Stamped Letter | 5 | 0.05 lbs | $3.20 | $2.84 | $0.36 |
| 211031 | 2020-04-09 | $57.82 | Priority Mail 3-Day | 2 | 0.89 lbs | $10.84 | $9.99 | $0.85 |
| 211032 | 2020-04-09 | $8.34 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.93 | $0.42 |
| 211033 | 2020-04-09 | $22.66 | Priority Mail 2-Day Small Flat Rate Box | 4 | 0.25 lbs | $8.50 | $7.65 | $0.85 |
| 211034 | 2020-04-09 | $85.20 | Ground | 4 | 2.69 lbs | $22.45 | $19.23 | $3.22 |
| 211035 | 2020-04-09 | $20.83 | Priority Mail 2-Day | 1 | 0.95 lbs | $10.84 | $9.99 | $0.85 |
| 211036 | 2020-04-09 | $28.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.40 lbs | $8.00 | $7.65 | $0.35 |
| 211037 | 2020-04-09 | $47.18 | Priority Mail 2-Day | 6 | 1.80 lbs | $9.44 | $8.21 | $1.23 |
| 211039 | 2020-04-10 | $7.34 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.84 | $0.51 |
| 211041 | 2020-04-10 | $78.58 | Priority Mail 2-Day Padded Flat Rate Envelope | 2 | 4.40 lbs | $8.60 | $7.75 | $0.85 |
| 211042 | 2020-04-10 | $23.07 | Priority Mail 2-Day Flat Rate Envelope | 3 | 0.25 lbs | $8.00 | $7.65 | $0.35 |
| 211043 | 2020-04-10 | $11.18 | First-Class Mail Stamped Letter | 2 | 0.02 lbs | $3.20 | $3.18 | $0.02 |
| 211044 | 2020-04-10 | $28.45 | Priority Mail 3-Day Small Flat Rate Box | 5 | 0.37 lbs | $8.50 | $7.65 | $0.85 |
| 211046 | 2020-04-10 | $11.12 | First-Class Mail Stamped Letter | 3 | 0.16 lbs | $3.65 | $2.93 | $0.72 |
| 211051 | 2020-04-10 | $45.96 | Priority Mail International Padded Flat Rate Envelope | 4 | 0.30 lbs | $26.40 | $26.50 | $-0.10 |
| 211052 | 2020-04-07 | $42.71 | Priority Mail 2-Day Medium Flat Rate Box | 1 | 1.19 lbs | $7.22 | $7.65 | $-0.43 |
| 211053 | 2020-04-10 | $9.83 | First-Class Mail Stamped Letter | 2 | 0.07 lbs | $3.35 | $3.18 | $0.17 |
| 211054 | 2020-04-10 | $5.18 | First-Class Mail Stamped Letter | 2 | 0.02 lbs | $3.20 | $2.93 | $0.27 |
| 211055 | 2020-04-10 | $10.89 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.03 lbs | $8.00 | $7.15 | $0.85 |
| 211056 | 2020-04-10 | $21.98 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.20 lbs | $8.00 | $7.15 | $0.85 |
| 211057 | 2020-04-10 | $63.60 | Priority Mail 3-Day | 1 | 1.00 lbs | $9.61 | $8.76 | $0.85 |
| 211059 | 2020-04-10 | $39.72 | Priority Mail 3-Day Flat Rate Envelope | 8 | 0.30 lbs | $8.00 | $7.15 | $0.85 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |