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 |
|---|---|---|---|---|---|---|---|---|
| 230922 | 2023-01-20 | $16.92 | USPS Shipping | 1 | 0.79 lbs | $7.93 | $5.38 | $2.55 |
| 230924 | 2023-01-20 | $186.08 | Priority Mail | 1 | 10.30 lbs | $29.44 | $28.34 | $1.10 |
| 230926 | 2023-01-21 | $29.41 | First-Class Package Service | 2 | 0.40 lbs | $6.28 | $5.33 | $0.95 |
| 230927 | 2023-01-21 | $24.66 | First-Class Package Service | 1 | 0.45 lbs | $6.53 | $5.33 | $1.20 |
| 230928 | 2023-01-21 | $10.22 | First-Class Package Service | 4 | 0.04 lbs | $5.01 | $3.81 | $1.20 |
| 230929 | 2023-01-21 | $16.50 | USPS Shipping | 1 | 0.20 lbs | $5.51 | $4.44 | $1.07 |
| 230932 | 2023-01-21 | $21.75 | First-Class Package Service | 15 | 0.21 lbs | $5.40 | $4.20 | $1.20 |
| 230934 | 2023-01-21 | $17.74 | First-Class Package Service | 1 | 0.30 lbs | $5.64 | $4.44 | $1.20 |
| 230937 | 2023-01-22 | $25.98 | Priority Mail Small Flat Rate Box | 1 | 0.15 lbs | $9.65 | $8.10 | $1.55 |
| 230938 | 2023-01-22 | $15.64 | First-Class Package Service | 3 | 0.09 lbs | $5.17 | $3.97 | $1.20 |
| 230942 | 2023-01-22 | $13.64 | USPS First Class | 1 | 0.21 lbs | $5.15 | $3.97 | $1.18 |
| 230949 | 2023-01-24 | $11.40 | First-Class Package Service | 2 | 0.06 lbs | $5.17 | $3.97 | $1.20 |
| 230950 | 2023-01-24 | $15.44 | USPS First Class | 1 | 0.07 lbs | $5.15 | $3.97 | $1.18 |
| 230951 | 2023-01-23 | $13.54 | USPS First Class | 1 | 0.06 lbs | $5.05 | $3.81 | $1.24 |
| 230953 | 2023-01-25 | $11.42 | First-Class Package Service | 1 | 0.10 lbs | $5.33 | $4.13 | $1.20 |
| 230954 | 2023-01-25 | $196.72 | Priority Mail Medium Flat Rate Box | 1 | 12.88 lbs | $16.40 | $12.38 | $4.02 |
| 230955 | 2023-01-25 | $14.99 | USPS First Class | 1 | 0.05 lbs | $5.00 | $3.75 | $1.25 |
| 230957 | 2023-01-26 | $36.15 | Priority Mail | 1 | 3.20 lbs | $17.11 | $13.74 | $3.37 |
| 230958 | 2023-01-26 | $36.93 | Priority Mail | 14 | 0.77 lbs | $13.07 | $8.30 | $4.77 |
| 230959 | 2023-01-27 | $13.74 | USPS First Class | 1 | 0.21 lbs | $5.25 | $4.13 | $1.12 |
| 230960 | 2023-01-26 | $14.99 | USPS First Class | 1 | 0.07 lbs | $5.00 | $3.75 | $1.25 |
| 230966 | 2023-01-27 | $11.39 | USPS First Class | 1 | 0.06 lbs | $5.25 | $4.13 | $1.12 |
| 230967 | 2023-01-28 | $13.56 | First-Class Package Service | 1 | 0.06 lbs | $5.10 | $3.90 | $1.20 |
| 230972 | 2023-01-28 | $38.06 | Priority Mail Small Flat Rate Box | 1 | 1.40 lbs | $9.65 | $8.10 | $1.55 |
| 230973 | 2023-01-28 | $13.67 | First-Class Package Service | 3 | 0.32 lbs | $5.44 | $4.24 | $1.20 |
| 230974 | 2023-01-28 | $11.16 | First-Class Package Service | 4 | 0.04 lbs | $4.95 | $3.75 | $1.20 |
| 230975 | 2023-01-29 | $9.41 | First-Class Package Service | 1 | 0.05 lbs | $5.17 | $3.97 | $1.20 |
| 230976 | 2023-01-29 | $13.34 | First-Class Package Service | 1 | 0.05 lbs | $5.10 | $3.90 | $1.20 |
| 230987 | 2023-01-30 | $12.95 | First-Class Package Service | 2 | 0.10 lbs | $5.17 | $3.97 | $1.20 |
| 230988 | 2023-01-29 | $27.02 | USPS Parcel Select Ground | 1 | 0.92 lbs | $9.03 | $10.12 | $-1.09 |
| 230989 | 2023-01-29 | $15.04 | USPS First Class | 1 | 0.05 lbs | $5.05 | $4.20 | $0.85 |
| 230990 | 2023-01-29 | $10.44 | USPS First Class | 1 | 0.23 lbs | $5.05 | $4.20 | $0.85 |
| 230991 | 2023-01-29 | $10.39 | USPS First Class | 1 | 0.03 lbs | $5.10 | $3.90 | $1.20 |
| 230992 | 2023-01-29 | $15.14 | USPS First Class | 1 | 0.10 lbs | $5.15 | $4.31 | $0.84 |
| 230993 | 2023-01-29 | $17.59 | USPS First Class | 1 | 0.30 lbs | $5.60 | $4.15 | $1.45 |
| 230994 | 2023-01-28 | $8.34 | USPS First Class | 1 | 0.06 lbs | $5.05 | $3.81 | $1.24 |
| 230995 | 2023-01-28 | $13.14 | USPS First Class | 1 | 0.06 lbs | $5.25 | $4.13 | $1.12 |
| 230996 | 2023-01-30 | $12.54 | USPS Shipping | 1 | 0.12 lbs | $1.65 | $4.13 | $-2.48 |
| 230997 | 2023-01-30 | $13.80 | First-Class Package Service | 2 | 0.10 lbs | $5.17 | $3.97 | $1.20 |
| 230998 | 2023-01-30 | $12.25 | First-Class Package Service | 1 | 0.03 lbs | $5.01 | $3.81 | $1.20 |
| 230999 | 2023-01-28 | $23.42 | Standard Shipping | 1 | 0.45 lbs | $5.53 | $4.24 | $1.29 |
| 231002 | 2023-01-31 | $8.71 | USPS Shipping | 1 | 0.10 lbs | $5.23 | $3.81 | $1.42 |
| 231003 | 2023-01-30 | $51.57 | USPS Shipping | 1 | 2.20 lbs | $16.58 | $17.21 | $-0.63 |
| 231004 | 2023-01-31 | $15.24 | First-Class Package Service | 7 | 0.32 lbs | $5.51 | $5.17 | $0.34 |
| 231005 | 2023-01-31 | $10.84 | USPS Shipping | 1 | 0.06 lbs | $1.65 | $3.75 | $-2.10 |
| 231009 | 2023-02-01 | $12.93 | USPS Shipping | 1 | 0.10 lbs | $5.23 | $3.75 | $1.48 |
| 231012 | 2023-02-01 | $15.04 | USPS First Class | 1 | 0.10 lbs | $5.05 | $3.81 | $1.24 |
| 231013 | 2023-02-01 | $26.84 | USPS First Class | 1 | 0.20 lbs | $5.25 | $4.44 | $0.81 |
| 231014 | 2023-02-01 | $40.16 | USPS First Class | 4 | 0.30 lbs | $21.00 | $4.44 | $16.56 |
| 231016 | 2023-02-02 | $13.04 | First-Class Package Service | 1 | 0.08 lbs | $5.10 | $3.90 | $1.20 |
| 231018 | 2023-02-02 | $28.58 | Priority Mail Small Flat Rate Box | 7 | 0.89 lbs | $9.65 | $8.10 | $1.55 |
| 231020 | 2023-02-03 | $15.48 | First-Class Package Service | 3 | 0.12 lbs | $5.01 | $4.20 | $0.81 |
| 231021 | 2023-02-03 | $12.84 | USPS First Class | 1 | 0.06 lbs | $5.05 | $4.20 | $0.85 |
| 231024 | 2023-02-04 | $15.32 | First-Class Package Service | 1 | 0.05 lbs | $5.33 | $4.13 | $1.20 |
| 231025 | 2023-02-05 | $14.34 | First-Class Package Service | 1 | 0.20 lbs | $5.35 | $3.75 | $1.60 |
| 231026 | 2023-02-05 | $9.79 | USPS First Class | 1 | 0.10 lbs | $5.00 | $3.75 | $1.25 |
| 231027 | 2023-02-05 | $14.14 | USPS First Class | 1 | 0.04 lbs | $5.15 | $3.97 | $1.18 |
| 231028 | 2023-02-06 | $9.84 | First-Class Package Service | 1 | 0.03 lbs | $5.10 | $3.90 | $1.20 |
| 231033 | 2023-02-06 | $9.94 | USPS First Class | 1 | 0.05 lbs | $5.15 | $3.97 | $1.18 |
| 231042 | 2023-02-07 | $23.58 | First-Class Package Service | 2 | 0.03 lbs | $5.10 | $3.90 | $1.20 |
| 231043 | 2023-02-07 | $19.88 | USPS First Class | 2 | 0.10 lbs | $10.10 | $3.81 | $6.29 |
| 231044 | 2023-02-07 | $10.14 | USPS First Class | 1 | 0.05 lbs | $5.15 | $3.97 | $1.18 |
| 231049 | 2023-02-10 | $34.03 | Priority Mail | 4 | 0.80 lbs | $13.07 | $8.30 | $4.77 |
| 231050 | 2023-02-09 | $14.04 | USPS First Class | 1 | 0.20 lbs | $5.05 | $4.20 | $0.85 |
| 231051 | 2023-02-10 | $11.09 | USPS First Class | 1 | 0.10 lbs | $4.90 | $3.66 | $1.24 |
| 231053 | 2023-02-10 | $9.34 | USPS First Class | 1 | 0.05 lbs | $5.05 | $3.81 | $1.24 |
| 231054 | 2023-02-10 | $9.14 | First-Class Package Service | 1 | 0.07 lbs | $5.10 | $3.90 | $1.20 |
| 231055 | 2023-02-10 | $29.32 | First-Class Package Service | 4 | 0.43 lbs | $6.01 | $4.81 | $1.20 |
| 231056 | 2023-02-10 | $44.22 | Priority Mail Flat Rate Envelope | 2 | 1.30 lbs | $9.15 | $8.10 | $1.05 |
| 231059 | 2023-02-10 | $41.15 | Priority Mail Padded Flat Rate Envelope | 1 | 1.81 lbs | $9.90 | $8.30 | $1.60 |
| 231060 | 2023-02-10 | $37.80 | First-Class Package Service | 3 | 0.61 lbs | $5.99 | $5.04 | $0.95 |
| 231061 | 2023-02-11 | $19.40 | First-Class Package Service | 4 | 0.20 lbs | $5.44 | $3.90 | $1.54 |
| 231062 | 2023-02-11 | $16.14 | USPS Shipping | 1 | 0.20 lbs | $5.15 | $4.44 | $0.71 |
| 231063 | 2023-02-11 | $102.97 | Ground | 23 | 12.14 lbs | $36.12 | $28.97 | $7.15 |
| 231064 | 2023-02-11 | $91.78 | Priority Mail | 20 | 2.83 lbs | $13.11 | $9.59 | $3.52 |
| 231067 | 2023-02-11 | $45.44 | Priority Mail | 18 | 7.20 lbs | $17.00 | $18.83 | $-1.83 |
| 231069 | 2023-02-11 | $14.71 | First-Class Package Service | 6 | 0.50 lbs | $5.89 | $4.06 | $1.83 |
| 231071 | 2023-02-12 | $104.63 | Priority Mail Small Flat Rate Box | 2 | 4.12 lbs | $9.65 | $8.10 | $1.55 |
| 231072 | 2023-02-12 | $34.53 | First-Class Package Service | 7 | 0.58 lbs | $5.94 | $4.74 | $1.20 |
| 231075 | 2023-02-12 | $7.34 | First-Class Package Service | 1 | 0.00 lbs | $5.10 | $3.90 | $1.20 |
| 231076 | 2023-02-12 | $54.76 | First-Class Package Service | 1 | 0.56 lbs | $6.01 | $4.81 | $1.20 |
| 231078 | 2023-02-12 | $18.00 | First-Class Package Service | 1 | 0.35 lbs | $6.01 | $4.15 | $1.86 |
| 231081 | 2023-02-13 | $14.30 | First-Class Package Service | 3 | 0.15 lbs | $5.33 | $4.13 | $1.20 |
| 231082 | 2023-02-11 | $12.94 | USPS First Class | 1 | 0.03 lbs | $5.05 | $3.81 | $1.24 |
| 231083 | 2023-02-12 | $7.04 | USPS Shipping | 2 | 0.12 lbs | $5.15 | $3.90 | $1.25 |
| 231086 | 2023-02-13 | $9.40 | First-Class Package Service | 2 | 0.08 lbs | $5.17 | $3.97 | $1.20 |
| 231087 | 2023-02-14 | $20.15 | First-Class Package Service | 1 | 0.45 lbs | $6.24 | $5.04 | $1.20 |
| 231088 | 2023-02-13 | $14.24 | USPS First Class | 1 | 0.20 lbs | $5.25 | $4.44 | $0.81 |
| 231089 | 2023-02-14 | $31.85 | USPS Shipping | 3 | 1.20 lbs | $16.59 | $11.97 | $4.62 |
| 231091 | 2023-02-14 | $27.02 | USPS Parcel Select Ground | 1 | 0.92 lbs | $9.03 | $9.03 | $0.00 |
| 231092 | 2023-02-14 | $29.63 | Priority Mail Small Flat Rate Box | 2 | 2.00 lbs | $9.65 | $8.10 | $1.55 |
| 231093 | 2023-02-15 | $10.86 | First-Class Package Service | 3 | 0.14 lbs | $5.44 | $3.90 | $1.54 |
| 231094 | 2023-02-15 | $10.44 | USPS First Class | 1 | 0.03 lbs | $5.15 | $3.97 | $1.18 |
| 231095 | 2023-02-15 | $57.11 | Priority Mail | 2 | 2.34 lbs | $11.33 | $8.10 | $3.23 |
| 231096 | 2023-02-15 | $44.11 | Priority Mail Small Flat Rate Box | 1 | 1.15 lbs | $9.65 | $8.10 | $1.55 |
| 231098 | 2023-02-15 | $21.28 | First-Class Package Service | 1 | 0.15 lbs | $4.95 | $4.15 | $0.80 |
| 231100 | 2023-02-15 | $22.92 | First-Class Package Service | 3 | 0.05 lbs | $4.95 | $3.75 | $1.20 |
| 231102 | 2023-02-16 | $13.59 | USPS First Class | 1 | 0.21 lbs | $5.10 | $3.90 | $1.20 |
| 231103 | 2023-02-15 | $15.89 | USPS First Class | 1 | 0.05 lbs | $5.10 | $3.90 | $1.20 |
| 231104 | 2023-02-15 | $9.64 | USPS First Class | 1 | 0.06 lbs | $5.15 | $3.97 | $1.18 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |