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.21025 matching order(s)
| Order ID ▲ | Date | Order Total | Shipping Method | # Products | Total Weight | Shipping Charged | Shipping Paid | Profit |
|---|---|---|---|---|---|---|---|---|
| 217854 | 2020-11-22 | $21.79 | USPSFirstClass | 1 | 0.40 lbs | $5.80 | $4.71 | $1.09 |
| 217855 | 2020-11-22 | $36.89 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.90 | $8.05 | $0.85 |
| 217857 | 2020-11-22 | $26.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.40 | $8.15 | $0.25 |
| 217858 | 2020-11-22 | $186.81 | Priority Mail 3-Day Medium Flat Rate Box | 4 | 6.00 lbs | $14.85 | $10.89 | $3.96 |
| 217859 | 2020-11-22 | $11.72 | USPSFirstClass | 3 | 0.57 lbs | $5.75 | $3.30 | $2.45 |
| 217860 | 2020-11-22 | $14.89 | First-Class Package Service | 1 | 0.50 lbs | $5.90 | $4.43 | $1.47 |
| 217861 | 2020-11-22 | $13.46 | USPSFirstClass | 4 | 0.60 lbs | $5.50 | $5.37 | $0.13 |
| 217864 | 2020-11-22 | $10.60 | First-Class Package Service | 3 | 0.04 lbs | $3.63 | $3.18 | $0.45 |
| 217867 | 2020-11-22 | $5.43 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.18 | $0.17 |
| 217869 | 2020-11-22 | $99.58 | Priority Mail 3-Day | 30 | 6.60 lbs | $27.88 | $24.58 | $3.30 |
| 217870 | 2020-11-23 | $9.18 | USPSFirstClass | 1 | 0.04 lbs | $4.29 | $3.30 | $0.99 |
| 217871 | 2020-11-23 | $53.36 | USPSFirstClass | 4 | 2.00 lbs | $17.40 | $10.73 | $6.67 |
| 217872 | 2020-11-22 | $26.01 | First-Class Package Service | 1 | 0.40 lbs | $5.02 | $4.57 | $0.45 |
| 217873 | 2020-11-23 | $12.50 | USPSFirstClass | 2 | 0.02 lbs | $4.40 | $3.43 | $0.97 |
| 217874 | 2020-11-23 | $26.41 | USPSFirstClass | 3 | 0.60 lbs | $5.74 | $5.37 | $0.37 |
| 217875 | 2020-11-23 | $16.29 | First-Class Mail Stamped Letter | 1 | 0.15 lbs | $3.50 | $3.43 | $0.07 |
| 217877 | 2020-11-23 | $94.38 | Priority Mail 2-Day Flat Rate Envelope | 2 | 3.05 lbs | $8.40 | $8.00 | $0.40 |
| 217879 | 2020-11-23 | $21.67 | First-Class Package Service | 1 | 0.45 lbs | $4.88 | $4.38 | $0.50 |
| 217882 | 2020-11-23 | $23.79 | First-Class Package Service | 1 | 0.60 lbs | $4.50 | $5.37 | $-0.87 |
| 217883 | 2020-11-23 | $26.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.40 | $8.15 | $0.25 |
| 217885 | 2020-11-23 | $5.99 | USPSFirstClass | 1 | 0.19 lbs | $4.00 | $3.03 | $0.97 |
| 217887 | 2020-11-23 | $8.08 | First-Class Package Service | 1 | 0.18 lbs | $4.09 | $3.64 | $0.45 |
| 217888 | 2020-11-23 | $32.07 | Priority Mail 3-Day | 2 | 0.57 lbs | $11.79 | $11.13 | $0.66 |
| 217889 | 2020-11-23 | $124.90 | Priority Mail 2-Day Medium Flat Rate Box | 5 | 3.48 lbs | $14.85 | $11.58 | $3.27 |
| 217890 | 2020-11-23 | $56.24 | First-Class Package International Service | 14 | 0.65 lbs | $31.53 | $23.28 | $8.25 |
| 217891 | 2020-11-23 | $59.08 | First-Class Package Service | 2 | 0.80 lbs | $6.10 | $5.65 | $0.45 |
| 217892 | 2020-11-23 | $4.94 | USPSFirstClass | 1 | 0.01 lbs | $3.95 | $3.03 | $0.92 |
| 217893 | 2020-11-23 | $53.26 | First-Class Package Service | 10 | 0.80 lbs | $6.24 | $5.79 | $0.45 |
| 217895 | 2020-11-23 | $36.76 | Priority Mail 3-Day | 6 | 4.05 lbs | $10.64 | $9.79 | $0.85 |
| 217896 | 2020-08-29 | $32.72 | Priority Mail 2-Day | 2 | 1.55 lbs | $9.44 | $8.52 | $0.92 |
| 217897 | 2020-11-23 | $3.48 | First-Class Package Service | 3 | 0.15 lbs | $3.48 | $3.03 | $0.45 |
| 217898 | 2020-11-23 | $26.87 | Priority Mail 2-Day Small Flat Rate Box | 3 | 0.06 lbs | $8.90 | $8.05 | $0.85 |
| 217899 | 2020-11-23 | $334.10 | Ground | 7 | 24.87 lbs | $41.97 | $32.29 | $9.68 |
| 217900 | 2020-11-23 | $28.16 | First-Class Package Service | 2 | 0.42 lbs | $4.70 | $4.25 | $0.45 |
| 217901 | 2020-11-23 | $237.58 | Ground Home Delivery | 1 | 21.00 lbs | $44.39 | $38.85 | $5.54 |
| 217902 | 2020-11-23 | $65.83 | Ground Home Delivery | 1 | 1.25 lbs | $20.84 | $15.83 | $5.01 |
| 217903 | 2020-11-23 | $48.58 | Priority Mail 2-Day | 1 | 1.15 lbs | $11.79 | $11.62 | $0.17 |
| 217905 | 2020-11-23 | $7.42 | First-Class Package Service | 3 | 0.21 lbs | $3.95 | $3.03 | $0.92 |
| 217906 | 2020-11-23 | $26.79 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.40 | $8.00 | $0.40 |
| 217907 | 2020-11-23 | $193.63 | Ground | 5 | 11.09 lbs | $22.58 | $38.02 | $-15.44 |
| 217909 | 2020-11-23 | $17.47 | First-Class Mail Stamped Letter | 8 | 0.17 lbs | $3.65 | $3.09 | $0.56 |
| 217911 | 2020-11-24 | $48.38 | Priority Mail 2-Day | 1 | 1.05 lbs | $8.89 | $8.04 | $0.85 |
| 217915 | 2020-11-24 | $94.38 | Priority Mail 2-Day Flat Rate Envelope | 2 | 3.00 lbs | $8.40 | $9.01 | $-0.61 |
| 217917 | 2020-11-24 | $16.54 | USPSFirstClass | 1 | 0.40 lbs | $5.55 | $3.92 | $1.63 |
| 217920 | 2020-11-24 | $8.98 | USPSFirstClass | 1 | 0.10 lbs | $4.19 | $3.09 | $1.10 |
| 217921 | 2020-11-24 | $14.97 | First-Class Mail Stamped Letter | 3 | 0.15 lbs | $3.50 | $3.30 | $0.20 |
| 217925 | 2020-11-24 | $15.79 | First-Class Mail Stamped Letter | 6 | 0.06 lbs | $3.35 | $3.09 | $0.26 |
| 217927 | 2020-11-24 | $23.94 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.00 lbs | $8.90 | $7.90 | $1.00 |
| 217928 | 2020-11-24 | $38.69 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.90 | $8.05 | $0.85 |
| 217929 | 2020-11-24 | $44.63 | Priority Mail 2-Day | 1 | 1.05 lbs | $11.24 | $8.05 | $3.19 |
| 217930 | 2020-11-24 | $20.46 | First-Class Package Service | 2 | 0.40 lbs | $4.68 | $3.64 | $1.04 |
| 217933 | 2020-11-24 | $62.05 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.78 lbs | $7.50 | $7.90 | $-0.40 |
| 217935 | 2020-11-24 | $15.74 | First-Class Package Service | 1 | 0.25 lbs | $3.95 | $3.50 | $0.45 |
| 217936 | 2020-11-25 | $9.03 | USPSFirstClass | 1 | 0.03 lbs | $4.14 | $3.03 | $1.11 |
| 217937 | 2020-11-24 | $11.59 | First-Class Package Service | 4 | 0.04 lbs | $3.63 | $3.18 | $0.45 |
| 217938 | 2020-11-24 | $38.69 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.00 lbs | $8.90 | $8.05 | $0.85 |
| 217939 | 2020-11-24 | $232.37 | Ground | 1 | 21.00 lbs | $39.18 | $33.74 | $5.44 |
| 217942 | 2020-11-25 | $31.78 | Direct Link International | 1 | 0.23 lbs | $18.41 | $9.28 | $9.13 |
| 217943 | 2020-11-25 | $64.74 | Priority Mail 2-Day | 5 | 1.85 lbs | $11.79 | $10.48 | $1.31 |
| 217945 | 2020-11-25 | $28.36 | First-Class Package Service | 2 | 0.60 lbs | $4.78 | $4.33 | $0.45 |
| 217948 | 2020-11-25 | $206.68 | Ground | 4 | 4.25 lbs | $12.72 | $15.94 | $-3.22 |
| 217949 | 2020-11-25 | $16.16 | First-Class Package Service | 1 | 0.30 lbs | $4.37 | $3.92 | $0.45 |
| 217950 | 2020-11-25 | $12.54 | First-Class Mail Stamped Letter | 1 | 0.06 lbs | $3.35 | $3.18 | $0.17 |
| 217951 | 2020-11-25 | $15.80 | USPSFirstClass | 2 | 0.80 lbs | $9.02 | $5.79 | $3.23 |
| 217952 | 2020-11-25 | $29.36 | Priority Mail 2-Day | 1 | 1.10 lbs | $9.37 | $8.34 | $1.03 |
| 217953 | 2020-11-25 | $51.89 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.90 | $7.90 | $1.00 |
| 217954 | 2020-11-25 | $30.78 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.90 lbs | $8.40 | $8.05 | $0.35 |
| 217955 | 2020-11-25 | $43.46 | First-Class Package Service | 5 | 0.29 lbs | $4.01 | $4.33 | $-0.32 |
| 217956 | 2020-11-25 | $26.79 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.40 | $8.00 | $0.40 |
| 217959 | 2020-11-25 | $51.89 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.90 | $7.90 | $1.00 |
| 217963 | 2020-11-25 | $237.88 | Ground | 1 | 14.05 lbs | $44.89 | $30.75 | $14.14 |
| 217965 | 2020-11-25 | $14.28 | First-Class Package Service | 3 | 0.14 lbs | $3.95 | $3.03 | $0.92 |
| 217966 | 2020-11-25 | $8.96 | First-Class Package Service | 2 | 0.38 lbs | $4.78 | $3.56 | $1.22 |
| 217967 | 2020-11-26 | $17.92 | USPSFirstClass | 3 | 0.57 lbs | $5.95 | $3.43 | $2.52 |
| 217968 | 2020-11-26 | $8.66 | USPSFirstClass | 1 | 0.34 lbs | $5.17 | $3.92 | $1.25 |
| 217969 | 2020-11-15 | $9.98 | First-Class Package Service | 2 | 0.20 lbs | $0.00 | $3.18 | $-3.18 |
| 217970 | 2020-11-25 | $87.38 | Priority Mail 3-Day Flat Rate Envelope | 2 | 2.10 lbs | $8.40 | $8.15 | $0.25 |
| 217972 | 2020-11-25 | $11.90 | First-Class Package Service | 1 | 0.20 lbs | $4.01 | $3.56 | $0.45 |
| 217973 | 2020-11-25 | $91.37 | Priority Mail 3-Day Small Flat Rate Box | 3 | 1.30 lbs | $8.90 | $8.05 | $0.85 |
| 217975 | 2020-11-25 | $65.97 | Priority Mail 2-Day | 3 | 8.00 lbs | $13.22 | $9.46 | $3.76 |
| 217976 | 2020-11-26 | $8.61 | USPSFirstClass | 1 | 0.05 lbs | $4.22 | $3.18 | $1.04 |
| 217977 | 2020-11-26 | $26.68 | USPSFirstClass | 2 | 1.00 lbs | $8.70 | $8.15 | $0.55 |
| 217978 | 2020-11-25 | $15.69 | First-Class Package Service | 1 | 0.40 lbs | $4.70 | $4.25 | $0.45 |
| 217980 | 2020-11-25 | $98.11 | Priority Mail 3-Day | 3 | 4.05 lbs | $10.64 | $8.61 | $2.03 |
| 217982 | 2020-11-25 | $24.88 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.40 | $8.15 | $0.25 |
| 217983 | 2020-11-26 | $22.76 | USPSFirstClass | 1 | 0.90 lbs | $8.70 | $8.15 | $0.55 |
| 217984 | 2020-11-26 | $13.09 | USPSFirstClass | 1 | 0.05 lbs | $4.34 | $3.03 | $1.31 |
| 217985 | 2020-11-26 | $32.49 | First-Class Package Service | 1 | 0.41 lbs | $6.20 | $4.71 | $1.49 |
| 217986 | 2020-11-26 | $7.91 | First-Class Mail Stamped Letter | 9 | 0.09 lbs | $3.50 | $3.30 | $0.20 |
| 217987 | 2020-11-26 | $13.39 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.05 lbs | $8.40 | $8.05 | $0.35 |
| 217989 | 2020-11-26 | $15.74 | First-Class Package Service | 1 | 0.30 lbs | $3.95 | $3.50 | $0.45 |
| 217990 | 2020-11-26 | $14.39 | First-Class Mail Stamped Letter | 11 | 0.12 lbs | $3.50 | $3.18 | $0.32 |
| 217992 | 2020-11-26 | $37.98 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.90 | $8.05 | $0.85 |
| 217993 | 2020-11-26 | $49.38 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.45 lbs | $8.40 | $8.05 | $0.35 |
| 217994 | 2020-11-26 | $38.69 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.90 | $8.05 | $0.85 |
| 217995 | 2020-11-26 | $56.58 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.60 lbs | $8.40 | $7.90 | $0.50 |
| 217997 | 2020-11-26 | $13.82 | First-Class Mail Stamped Letter | 3 | 0.09 lbs | $3.35 | $3.43 | $-0.08 |
| 218000 | 2020-11-26 | $205.40 | Ground | 4 | 11.68 lbs | $36.54 | $27.41 | $9.13 |
| 218001 | 2020-11-26 | $26.88 | USPSFirstClass | 2 | 1.00 lbs | $8.90 | $8.15 | $0.75 |
| 218002 | 2020-11-26 | $12.44 | First-Class Package Service | 4 | 0.12 lbs | $3.48 | $3.03 | $0.45 |
| Total | 21025 order(s) | 59971 | 29292.14 lbs | $193562.51 | $270247.54 | $-76685.03 |