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 |
|---|---|---|---|---|---|---|---|---|
| 213921 | 2020-07-27 | $13.33 | USPSFirstClass | 1 | 0.20 lbs | $4.39 | $3.39 | $1.00 |
| 213922 | 2020-07-26 | $64.41 | Priority Mail International Flat Rate Envelope | 4 | 0.76 lbs | $36.45 | $36.65 | $-0.20 |
| 213924 | 2020-07-27 | $32.55 | Priority Mail 3-Day | 2 | 1.10 lbs | $8.97 | $8.12 | $0.85 |
| 213925 | 2020-07-27 | $33.90 | Priority Mail 2-Day | 10 | 2.00 lbs | $13.00 | $9.98 | $3.02 |
| 213926 | 2020-07-27 | $10.01 | USPSFirstClass | 1 | 0.05 lbs | $4.30 | $3.05 | $1.25 |
| 213927 | 2020-07-27 | $45.02 | Priority Mail 3-Day | 1 | 1.20 lbs | $12.04 | $11.19 | $0.85 |
| 213928 | 2020-07-27 | $29.13 | First-Class Package Service | 2 | 0.52 lbs | $5.65 | $5.40 | $0.25 |
| 213929 | 2020-07-27 | $37.24 | First-Class Package Service | 3 | 0.51 lbs | $5.57 | $4.00 | $1.57 |
| 213931 | 2020-07-27 | $46.43 | Priority Mail 2-Day | 1 | 2.20 lbs | $9.44 | $8.21 | $1.23 |
| 213934 | 2020-07-27 | $63.19 | Priority Mail 3-Day Medium Flat Rate Box | 4 | 5.36 lbs | $14.45 | $10.53 | $3.92 |
| 213935 | 2020-07-27 | $13.36 | First-Class Package Service | 2 | 0.10 lbs | $3.38 | $2.93 | $0.45 |
| 213937 | 2020-07-27 | $6.14 | USPSFirstClass | 1 | 0.05 lbs | $4.04 | $2.84 | $1.20 |
| 213938 | 2020-07-27 | $46.80 | Priority Mail 3-Day | 9 | 3.35 lbs | $16.99 | $14.16 | $2.83 |
| 213939 | 2020-07-27 | $51.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.50 | $7.65 | $0.85 |
| 213940 | 2020-07-27 | $12.29 | First-Class Mail Stamped Letter | 1 | 0.08 lbs | $3.50 | $2.78 | $0.72 |
| 213941 | 2020-07-28 | $13.53 | USPSFirstClass | 1 | 0.15 lbs | $4.32 | $2.78 | $1.54 |
| 213944 | 2020-07-28 | $5.69 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $3.20 | $2.84 | $0.36 |
| 213945 | 2020-07-28 | $10.99 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 213946 | 2020-07-28 | $125.57 | Priority Mail 3-Day Padded Flat Rate Envelope | 3 | 4.80 lbs | $8.60 | $7.75 | $0.85 |
| 213947 | 2020-07-28 | $8.41 | USPSFirstClass | 1 | 0.19 lbs | $4.10 | $2.78 | $1.32 |
| 213948 | 2020-07-28 | $42.97 | USPSFirstClass | 10 | 0.50 lbs | $5.47 | $3.21 | $2.26 |
| 213950 | 2020-07-28 | $8.63 | First-Class Package Service | 1 | 0.27 lbs | $3.64 | $4.18 | $-0.54 |
| 213951 | 2020-07-28 | $22.50 | Priority Mail 1-Day Flat Rate Envelope | 1 | 0.80 lbs | $8.00 | $7.75 | $0.25 |
| 213952 | 2020-07-28 | $36.57 | Priority Mail 2-Day | 2 | 1.90 lbs | $16.59 | $15.74 | $0.85 |
| 213953 | 2020-07-28 | $70.46 | Priority Mail 3-Day Padded Flat Rate Envelope | 2 | 2.52 lbs | $8.60 | $7.75 | $0.85 |
| 213954 | 2020-07-29 | $9.86 | USPSFirstClass | 1 | 0.07 lbs | $4.30 | $3.05 | $1.25 |
| 213957 | 2020-07-29 | $23.01 | USPSFirstClass | 2 | 0.80 lbs | $8.34 | $7.75 | $0.59 |
| 213958 | 2020-07-28 | $9.99 | First-Class Mail Stamped Letter | 1 | 0.02 lbs | $3.20 | $3.18 | $0.02 |
| 213960 | 2020-07-29 | $13.90 | USPSFirstClass | 1 | 0.15 lbs | $4.47 | $3.52 | $0.95 |
| 213961 | 2020-07-28 | $27.39 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.22 lbs | $8.00 | $7.80 | $0.20 |
| 213964 | 2020-07-28 | $42.37 | First-Class Package Service - Retail | 6 | 0.46 lbs | $6.50 | $4.32 | $2.18 |
| 213965 | 2020-07-29 | $13.89 | USPSFirstClass | 1 | 0.55 lbs | $5.90 | $5.40 | $0.50 |
| 213969 | 2020-07-29 | $24.85 | First-Class Mail Stamped Letter | 8 | 0.41 lbs | $4.53 | $3.52 | $1.01 |
| 213971 | 2020-07-29 | $19.53 | First-Class Package Service | 3 | 0.28 lbs | $3.56 | $3.31 | $0.25 |
| 213973 | 2021-04-26 | $31.09 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 1.33 lbs | $8.60 | $8.00 | $0.60 |
| 213975 | 2020-07-29 | $25.48 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.32 lbs | $8.00 | $7.65 | $0.35 |
| 213977 | 2020-07-29 | $10.27 | USPSFirstClass | 2 | 0.10 lbs | $4.04 | $2.78 | $1.26 |
| 213979 | 2020-07-29 | $8.22 | First-Class Mail Stamped Letter | 1 | 0.07 lbs | $3.35 | $2.74 | $0.61 |
| 213989 | 2020-07-29 | $36.79 | Priority Mail 3-Day Flat Rate Envelope | 1 | 1.05 lbs | $8.00 | $7.65 | $0.35 |
| 213990 | 2020-07-29 | $7.89 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.50 | $2.78 | $0.72 |
| 213991 | 2020-07-29 | $42.75 | Priority Mail 2-Day Flat Rate Envelope | 5 | 1.16 lbs | $8.00 | $7.65 | $0.35 |
| 213994 | 2020-07-29 | $229.14 | Ground | 1 | 14.90 lbs | $39.15 | $31.25 | $7.90 |
| 213996 | 2020-07-29 | $25.03 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.00 | $7.75 | $0.25 |
| 213997 | 2020-07-29 | $12.08 | First-Class Package Service | 3 | 0.42 lbs | $4.71 | $3.67 | $1.04 |
| 214000 | 2020-07-29 | $14.97 | Priority Mail 2-Day Flat Rate Envelope | 3 | 0.04 lbs | $8.00 | $8.42 | $-0.42 |
| 214001 | 2020-07-29 | $61.09 | Priority Mail 3-Day | 2 | 4.26 lbs | $11.49 | $9.53 | $1.96 |
| 214004 | 2020-07-29 | $23.89 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.40 lbs | $8.00 | $7.65 | $0.35 |
| 214005 | 2020-07-29 | $96.68 | Ground | 2 | 4.80 lbs | $22.40 | $19.28 | $3.12 |
| 214006 | 2020-07-29 | $68.01 | Priority Mail 2-Day | 3 | 1.29 lbs | $12.04 | $11.19 | $0.85 |
| 214007 | 2020-07-30 | $62.85 | Priority Mail 3-Day Padded Flat Rate Envelope | 2 | 2.10 lbs | $8.60 | $7.75 | $0.85 |
| 214008 | 2020-07-30 | $137.80 | Priority Mail 2-Day | 1 | 12.90 lbs | $27.81 | $15.39 | $12.42 |
| 214011 | 2020-07-30 | $15.28 | First-Class Mail Stamped Letter | 2 | 0.10 lbs | $3.50 | $3.52 | $-0.02 |
| 214014 | 2020-07-30 | $46.89 | Priority Mail 3-Day Flat Rate Envelope | 3 | 1.66 lbs | $8.00 | $7.65 | $0.35 |
| 214015 | 2020-07-30 | $65.85 | Priority Mail 3-Day Flat Rate Envelope | 5 | 1.89 lbs | $8.00 | $7.65 | $0.35 |
| 214016 | 2020-07-30 | $19.59 | Priority Mail 2-Day | 4 | 1.30 lbs | $11.39 | $10.54 | $0.85 |
| 214018 | 2020-07-30 | $8.54 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.84 | $0.51 |
| 214020 | 2020-07-30 | $10.81 | First-Class Mail Stamped Letter | 4 | 0.08 lbs | $3.35 | $3.05 | $0.30 |
| 214021 | 2020-07-30 | $31.87 | InternationalPriorityShipping | 1 | 0.20 lbs | $4.44 | $3.52 | $0.92 |
| 214024 | 2020-07-30 | $24.48 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.00 | $7.75 | $0.25 |
| 214027 | 2020-07-30 | $30.29 | Priority Mail 2-Day | 5 | 1.04 lbs | $12.04 | $11.18 | $0.86 |
| 214029 | 2020-07-30 | $19.82 | Priority Mail 1-Day | 3 | 1.20 lbs | $8.49 | $7.64 | $0.85 |
| 214030 | 2020-07-30 | $44.59 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 1.44 lbs | $8.60 | $7.75 | $0.85 |
| 214031 | 2020-07-30 | $35.12 | Priority Mail 2-Day Flat Rate Envelope | 1 | 1.10 lbs | $8.00 | $7.75 | $0.25 |
| 214032 | 2020-07-30 | $7.19 | First-Class Mail Stamped Letter | 1 | 0.02 lbs | $3.20 | $3.18 | $0.02 |
| 214033 | 2020-07-31 | $45.55 | USPSFirstClass | 3 | 1.11 lbs | $11.81 | $7.75 | $4.06 |
| 214034 | 2020-07-30 | $65.71 | Priority Mail 3-Day | 2 | 2.05 lbs | $14.34 | $13.49 | $0.85 |
| 214035 | 2020-07-31 | $61.42 | USPSPriority | 1 | 4.90 lbs | $16.64 | $8.92 | $7.72 |
| 214036 | 2020-07-31 | $176.86 | Priority Mail 2-Day | 3 | 11.67 lbs | $24.59 | $20.78 | $3.81 |
| 214038 | 2020-07-31 | $68.33 | Priority Mail 2-Day | 2 | 6.15 lbs | $10.59 | $9.74 | $0.85 |
| 214041 | 2020-07-31 | $10.82 | First-Class Mail Stamped Letter | 3 | 0.08 lbs | $3.35 | $3.18 | $0.17 |
| 214042 | 2020-07-31 | $60.31 | Priority Mail 2-Day | 3 | 0.96 lbs | $10.84 | $9.99 | $0.85 |
| 214043 | 2020-07-31 | $52.33 | Priority Mail 2-Day | 1 | 2.20 lbs | $14.34 | $11.13 | $3.21 |
| 214044 | 2020-07-31 | $49.97 | Priority Mail 2-Day | 2 | 1.20 lbs | $11.39 | $10.53 | $0.86 |
| 214045 | 2020-07-31 | $52.51 | Priority Mail 2-Day | 3 | 1.53 lbs | $10.84 | $12.15 | $-1.31 |
| 214050 | 2020-07-31 | $44.52 | Priority Mail 3-Day Small Flat Rate Box | 2 | 1.65 lbs | $8.50 | $7.65 | $0.85 |
| 214052 | 2020-07-31 | $14.65 | Priority Mail 2-Day | 1 | 0.25 lbs | $9.27 | $11.19 | $-1.92 |
| 214055 | 2020-07-31 | $29.50 | USPSFirstClass | 2 | 0.74 lbs | $6.03 | $5.40 | $0.63 |
| 214058 | 2020-07-31 | $32.65 | USPSPriority | 1 | 2.14 lbs | $11.87 | $8.21 | $3.66 |
| 214063 | 2020-07-31 | $35.56 | Priority Mail 1-Day Small Flat Rate Box | 2 | 0.37 lbs | $8.50 | $7.65 | $0.85 |
| 214065 | 2020-07-31 | $18.19 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 214066 | 2020-07-31 | $7.14 | USPSFirstClass | 1 | 0.20 lbs | $4.15 | $3.39 | $0.76 |
| 214067 | 2020-07-31 | $6.69 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.20 | $3.05 | $0.15 |
| 214076 | 2020-07-31 | $75.00 | Priority Mail 2-Day | 1 | 3.50 lbs | $15.01 | $16.14 | $-1.13 |
| 214077 | 2020-07-31 | $8.71 | USPSFirstClass | 1 | 0.05 lbs | $4.20 | $2.93 | $1.27 |
| 214079 | 2020-07-31 | $7.17 | USPSFirstClass | 1 | 0.10 lbs | $4.04 | $2.78 | $1.26 |
| 214080 | 2020-07-31 | $44.61 | Priority Mail 2-Day Flat Rate Envelope | 9 | 0.83 lbs | $8.00 | $7.65 | $0.35 |
| 214082 | 2020-07-31 | $82.58 | Priority Mail 3-Day Padded Flat Rate Envelope | 2 | 5.30 lbs | $8.60 | $7.75 | $0.85 |
| 214085 | 2020-07-31 | $62.26 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.70 lbs | $8.50 | $7.65 | $0.85 |
| 214087 | 2020-07-31 | $21.38 | Priority Mail 3-Day Flat Rate Envelope | 2 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 214090 | 2020-07-31 | $36.57 | Priority Mail 3-Day | 2 | 1.90 lbs | $16.59 | $15.74 | $0.85 |
| 214091 | 2020-07-31 | $73.21 | Priority Mail 2-Day Medium Flat Rate Box | 4 | 2.60 lbs | $14.45 | $7.75 | $6.70 |
| 214092 | 2020-07-31 | $27.96 | Priority Mail 3-Day Flat Rate Envelope | 4 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 214093 | 2020-07-31 | $22.75 | Priority Mail 2-Day | 6 | 1.14 lbs | $9.61 | $8.92 | $0.69 |
| 214094 | 2020-07-31 | $15.82 | First-Class Mail Stamped Letter | 3 | 0.05 lbs | $3.35 | $2.84 | $0.51 |
| 214095 | 2020-07-31 | $7.49 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.50 | $2.78 | $0.72 |
| 214096 | 2020-07-31 | $6.19 | First-Class Mail Stamped Letter | 1 | 0.02 lbs | $3.20 | $2.93 | $0.27 |
| 214098 | 2020-08-01 | $33.69 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.50 | $7.65 | $0.85 |
| 214100 | 2020-08-01 | $13.88 | USPSFirstClass | 3 | 0.10 lbs | $4.35 | $3.18 | $1.17 |
| 214101 | 2020-08-01 | $83.60 | Priority Mail 2-Day | 4 | 1.40 lbs | $14.34 | $13.49 | $0.85 |
| 214103 | 2020-08-01 | $154.45 | Ground | 2 | 12.40 lbs | $29.84 | $21.45 | $8.39 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |