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 |
|---|---|---|---|---|---|---|---|---|
| 211950 | 2020-05-06 | $8.59 | First-Class Mail Stamped Letter | 1 | 0.02 lbs | $3.20 | $3.05 | $0.15 |
| 211951 | 2020-05-06 | $7.63 | First-Class Mail Stamped Letter | 2 | 0.16 lbs | $3.65 | $3.52 | $0.13 |
| 211952 | 2020-05-06 | $19.42 | USPSFirstClass | 2 | 0.68 lbs | $5.84 | $5.40 | $0.44 |
| 211954 | 2020-05-06 | $22.92 | First-Class Package Service | 1 | 0.40 lbs | $4.53 | $4.08 | $0.45 |
| 211955 | 2020-05-06 | $8.20 | USPSFirstClass | 1 | 0.03 lbs | $4.07 | $2.78 | $1.29 |
| 211956 | 2020-05-06 | $43.17 | Priority Mail 3-Day | 12 | 3.45 lbs | $11.49 | $10.64 | $0.85 |
| 211957 | 2020-05-06 | $69.27 | First-Class Package International Service | 1 | 1.15 lbs | $32.48 | $24.23 | $8.25 |
| 211958 | 2020-05-06 | $26.64 | USPSFirstClass | 5 | 1.00 lbs | $14.00 | $11.18 | $2.82 |
| 211963 | 2020-05-06 | $6.24 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.93 | $0.42 |
| 211967 | 2020-05-06 | $16.24 | First-Class Package Service | 1 | 0.55 lbs | $4.45 | $4.00 | $0.45 |
| 211969 | 2020-05-06 | $19.44 | First-Class Mail Stamped Letter | 6 | 0.17 lbs | $3.50 | $3.31 | $0.19 |
| 211970 | 2020-05-07 | $58.13 | USPSFirstClass | 10 | 2.59 lbs | $32.23 | $34.30 | $-2.07 |
| 211971 | 2020-05-06 | $6.32 | First-Class Mail Stamped Letter | 3 | 0.03 lbs | $3.35 | $2.78 | $0.57 |
| 211972 | 2020-05-06 | $8.45 | First-Class Mail Stamped Letter | 5 | 0.09 lbs | $3.50 | $2.84 | $0.66 |
| 211973 | 2020-05-07 | $52.59 | First-Class Package International Service | 2 | 0.58 lbs | $34.61 | $26.36 | $8.25 |
| 211974 | 2020-05-07 | $13.88 | First-Class Mail Stamped Letter | 2 | 0.15 lbs | $3.50 | $2.93 | $0.57 |
| 211975 | 2020-05-07 | $12.82 | USPSFirstClass | 2 | 0.14 lbs | $4.15 | $3.31 | $0.84 |
| 211977 | 2020-05-07 | $21.02 | USPSFirstClass | 1 | 0.04 lbs | $4.75 | $2.93 | $1.82 |
| 211978 | 2020-05-07 | $34.47 | Priority Mail 2-Day Small Flat Rate Box | 3 | 0.42 lbs | $8.50 | $7.65 | $0.85 |
| 211979 | 2020-05-08 | $5.46 | USPSFirstClass | 1 | 0.05 lbs | $3.87 | $2.74 | $1.13 |
| 211982 | 2020-05-07 | $40.06 | Priority Mail 3-Day Padded Flat Rate Envelope | 1 | 2.65 lbs | $8.60 | $7.75 | $0.85 |
| 211984 | 2020-05-07 | $232.97 | Ground | 1 | 14.05 lbs | $39.98 | $36.91 | $3.07 |
| 211988 | 2020-05-07 | $16.48 | First-Class Package Service | 2 | 0.35 lbs | $3.70 | $3.25 | $0.45 |
| 211989 | 2020-05-07 | $64.62 | Priority Mail 3-Day | 2 | 1.70 lbs | $9.44 | $8.12 | $1.32 |
| 211990 | 2020-05-08 | $26.79 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.30 lbs | $8.50 | $7.65 | $0.85 |
| 211991 | 2020-05-08 | $47.63 | Priority Mail 2-Day | 1 | 1.40 lbs | $10.84 | $9.99 | $0.85 |
| 211993 | 2020-05-08 | $21.58 | USPSFirstClass | 1 | 0.30 lbs | $5.50 | $4.08 | $1.42 |
| 211994 | 2020-05-08 | $8.81 | USPSFirstClass | 1 | 0.10 lbs | $4.15 | $2.84 | $1.31 |
| 211995 | 2020-05-08 | $19.79 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 211996 | 2020-05-08 | $31.87 | USPSFirstClass | 2 | 0.80 lbs | $10.42 | $5.12 | $5.30 |
| 211997 | 2020-05-08 | $8.21 | USPSFirstClass | 1 | 0.40 lbs | $5.14 | $4.46 | $0.68 |
| 211998 | 2020-05-08 | $10.95 | Priority Mail 2-Day Small Flat Rate Box | 5 | 0.05 lbs | $8.50 | $7.15 | $1.35 |
| 211999 | 2020-05-08 | $27.98 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.20 lbs | $8.00 | $7.65 | $0.35 |
| 212001 | 2020-05-08 | $10.34 | First-Class Mail Stamped Letter | 1 | 0.06 lbs | $3.35 | $3.18 | $0.17 |
| 212002 | 2020-05-08 | $24.29 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.41 lbs | $8.00 | $7.65 | $0.35 |
| 212003 | 2020-05-08 | $12.26 | USPSFirstClass | 1 | 0.06 lbs | $4.55 | $3.18 | $1.37 |
| 212006 | 2020-05-08 | $9.86 | USPSFirstClass | 1 | 0.05 lbs | $4.29 | $3.05 | $1.24 |
| 212007 | 2020-05-08 | $112.06 | Priority Mail 3-Day | 3 | 3.10 lbs | $18.99 | $17.42 | $1.57 |
| 212008 | 2020-05-08 | $9.09 | First-Class Mail Stamped Letter | 1 | 0.15 lbs | $3.50 | $3.18 | $0.32 |
| 212009 | 2020-05-08 | $5.82 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.05 | $0.30 |
| 212010 | 2020-05-08 | $10.64 | First-Class Mail Stamped Letter | 1 | 0.19 lbs | $3.65 | $2.93 | $0.72 |
| 212013 | 2020-05-09 | $8.31 | USPSFirstClass | 1 | 0.40 lbs | $4.92 | $3.31 | $1.61 |
| 212014 | 2020-05-08 | $117.21 | Priority Mail 2-Day Large Flat Rate Box | 4 | 11.71 lbs | $19.15 | $18.30 | $0.85 |
| 212019 | 2020-05-08 | $36.42 | Priority Mail 2-Day | 7 | 0.89 lbs | $11.39 | $8.15 | $3.24 |
| 212021 | 2020-05-09 | $31.65 | USPSFirstClass | 1 | 0.15 lbs | $5.20 | $3.39 | $1.81 |
| 212023 | 2020-05-08 | $16.53 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 212024 | 2020-05-08 | $27.97 | Priority Mail 2-Day Flat Rate Envelope | 3 | 0.37 lbs | $8.00 | $7.65 | $0.35 |
| 212025 | 2020-05-09 | $7.27 | First-Class Mail Stamped Letter | 8 | 0.08 lbs | $3.35 | $2.84 | $0.51 |
| 212026 | 2020-05-09 | $6.33 | First-Class Mail Stamped Letter | 2 | 0.05 lbs | $3.35 | $3.05 | $0.30 |
| 212027 | 2020-05-09 | $30.39 | USPSFirstClass | 1 | 0.15 lbs | $5.00 | $3.21 | $1.79 |
| 212028 | 2020-05-09 | $48.83 | Priority Mail 3-Day | 1 | 1.15 lbs | $12.04 | $12.10 | $-0.06 |
| 212030 | 2020-05-09 | $28.70 | USPSFirstClass | 1 | 0.40 lbs | $5.95 | $4.32 | $1.63 |
| 212032 | 2020-05-09 | $21.38 | Priority Mail 3-Day | 1 | 0.95 lbs | $11.39 | $10.54 | $0.85 |
| 212033 | 2020-05-09 | $10.64 | First-Class Mail Stamped Letter | 1 | 0.07 lbs | $3.65 | $3.18 | $0.47 |
| 212035 | 2020-05-09 | $7.34 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.18 | $0.17 |
| 212036 | 2020-05-09 | $6.96 | First-Class Mail Stamped Letter | 4 | 0.14 lbs | $3.50 | $3.18 | $0.32 |
| 212037 | 2020-05-09 | $57.48 | Priority Mail 2-Day | 3 | 1.86 lbs | $8.89 | $7.68 | $1.21 |
| 212038 | 2020-05-09 | $21.98 | Priority Mail 3-Day Flat Rate Envelope | 2 | 0.15 lbs | $8.00 | $7.15 | $0.85 |
| 212041 | 2020-05-09 | $71.05 | Priority Mail 3-Day Padded Flat Rate Envelope | 5 | 4.29 lbs | $8.60 | $7.65 | $0.95 |
| 212044 | 2020-05-10 | $6.66 | USPSFirstClass | 1 | 0.01 lbs | $4.17 | $3.05 | $1.12 |
| 212045 | 2020-05-10 | $10.49 | USPSFirstClass | 2 | 0.10 lbs | $4.19 | $3.52 | $0.67 |
| 212046 | 2020-05-10 | $17.68 | USPSFirstClass | 1 | 0.05 lbs | $4.65 | $3.05 | $1.60 |
| 212048 | 2020-05-09 | $11.78 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.02 lbs | $8.00 | $3.05 | $4.95 |
| 212049 | 2020-05-09 | $9.96 | First-Class Package Service | 1 | 0.25 lbs | $3.97 | $3.52 | $0.45 |
| 212050 | 2020-05-09 | $28.12 | Priority Mail 2-Day | 1 | 0.65 lbs | $8.83 | $7.98 | $0.85 |
| 212053 | 2020-05-09 | $12.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.07 lbs | $8.00 | $7.65 | $0.35 |
| 212054 | 2020-05-09 | $7.70 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.84 | $0.51 |
| 212058 | 2020-05-10 | $14.49 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.50 | $3.25 | $0.25 |
| 212059 | 2020-05-10 | $20.17 | USPSFirstClass | 1 | 0.05 lbs | $4.72 | $3.39 | $1.33 |
| 212060 | 2020-05-10 | $8.44 | USPSFirstClass | 1 | 0.03 lbs | $4.24 | $3.05 | $1.19 |
| 212062 | 2020-05-10 | $58.64 | Priority Mail 2-Day | 5 | 1.84 lbs | $8.97 | $7.65 | $1.32 |
| 212064 | 2020-05-10 | $38.34 | Priority Mail 3-Day | 10 | 2.50 lbs | $9.44 | $8.59 | $0.85 |
| 212065 | 2020-05-10 | $5.65 | First-Class Mail Stamped Letter | 5 | 0.05 lbs | $3.20 | $2.84 | $0.36 |
| 212066 | 2020-05-10 | $48.00 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.70 lbs | $8.00 | $7.65 | $0.35 |
| 212067 | 2020-05-10 | $17.08 | First-Class Mail Stamped Letter | 7 | 0.17 lbs | $3.65 | $3.52 | $0.13 |
| 212068 | 2020-05-10 | $18.38 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 212069 | 2020-05-10 | $11.98 | USPSFirstClass | 1 | 0.05 lbs | $4.35 | $2.93 | $1.42 |
| 212070 | 2020-05-10 | $10.33 | First-Class Mail Stamped Letter | 2 | 0.06 lbs | $3.35 | $3.05 | $0.30 |
| 212071 | 2020-05-10 | $10.60 | USPSFirstClass | 1 | 0.05 lbs | $4.24 | $3.31 | $0.93 |
| 212072 | 2020-05-10 | $49.58 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.35 lbs | $8.00 | $7.65 | $0.35 |
| 212073 | 2020-05-10 | $31.60 | USPSFirstClass | 1 | 0.15 lbs | $5.15 | $2.84 | $2.31 |
| 212074 | 2020-05-10 | $82.42 | Priority Mail 2-Day | 15 | 1.20 lbs | $8.97 | $8.12 | $0.85 |
| 212076 | 2020-05-10 | $6.40 | USPSFirstClass | 1 | 0.01 lbs | $4.14 | $3.05 | $1.09 |
| 212078 | 2020-05-10 | $7.74 | First-Class Mail Stamped Letter | 1 | 0.04 lbs | $3.35 | $2.93 | $0.42 |
| 212079 | 2020-05-10 | $59.91 | Priority Mail 3-Day Flat Rate Envelope | 9 | 1.59 lbs | $8.00 | $7.65 | $0.35 |
| 212080 | 2020-05-10 | $22.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 212081 | 2020-05-10 | $83.46 | Ground | 3 | 2.35 lbs | $20.49 | $20.33 | $0.16 |
| 212083 | 2020-05-10 | $16.80 | First-Class Mail Stamped Letter | 5 | 0.07 lbs | $3.35 | $2.78 | $0.57 |
| 212084 | 2020-05-11 | $8.60 | USPSFirstClass | 1 | 0.05 lbs | $4.39 | $3.18 | $1.21 |
| 212085 | 2020-05-11 | $6.18 | USPSFirstClass | 1 | 0.20 lbs | $4.29 | $3.67 | $0.62 |
| 212086 | 2020-05-11 | $29.66 | Priority Mail 2-Day Small Flat Rate Box | 4 | 0.42 lbs | $8.50 | $7.65 | $0.85 |
| 212087 | 2020-05-11 | $9.33 | First-Class Mail Stamped Letter | 2 | 0.06 lbs | $3.35 | $2.93 | $0.42 |
| 212088 | 2020-05-11 | $11.22 | Priority Mail 2-Day | 1 | 0.17 lbs | $8.83 | $7.65 | $1.18 |
| 212089 | 2020-05-11 | $26.03 | First-Class Package Service | 2 | 0.46 lbs | $4.45 | $3.25 | $1.20 |
| 212092 | 2020-05-11 | $29.42 | Priority Mail 2-Day | 2 | 1.90 lbs | $9.44 | $8.59 | $0.85 |
| 212093 | 2020-05-11 | $7.09 | First-Class Mail Stamped Letter | 1 | 0.09 lbs | $3.50 | $2.78 | $0.72 |
| 212094 | 2020-05-11 | $13.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.19 lbs | $8.00 | $3.05 | $4.95 |
| 212096 | 2020-05-11 | $19.97 | First-Class Package Service | 2 | 0.40 lbs | $4.43 | $5.40 | $-0.97 |
| 212097 | 2020-05-11 | $13.05 | First-Class Package Service | 1 | 0.05 lbs | $3.97 | $3.52 | $0.45 |
| 212098 | 2020-05-11 | $8.49 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.50 | $3.05 | $0.45 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |