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 |
|---|---|---|---|---|---|---|---|---|
| 233891 | 2025-02-20 | $27.42 | USPS Ground Advantage | 3 | 0.21 lbs | $5.79 | $4.84 | $0.95 |
| 233892 | 2025-02-19 | $12.99 | USPS Ground Advantage | 1 | 0.05 lbs | $5.09 | $4.14 | $0.95 |
| 233893 | 2025-02-20 | $8.86 | USPS Ground Advantage | 1 | 0.45 lbs | $5.66 | $5.62 | $0.04 |
| 233895 | 2025-02-20 | $62.06 | USPS Ground Advantage | 1 | 1.39 lbs | $8.52 | $7.57 | $0.95 |
| 233896 | 2025-02-20 | $11.97 | USPS Ground Advantage | 1 | 0.05 lbs | $5.09 | $4.14 | $0.95 |
| 233897 | 2025-02-21 | $20.20 | USPS Ground Advantage | 1 | 0.70 lbs | $8.31 | $7.36 | $0.95 |
| 233898 | 2025-02-21 | $11.90 | USPS Ground Advantage | 1 | 0.03 lbs | $5.28 | $4.33 | $0.95 |
| 233899 | 2025-02-21 | $28.18 | USPS Ground Advantage | 1 | 0.91 lbs | $7.79 | $8.24 | $-0.45 |
| 233900 | 2025-02-20 | $57.11 | USPS Ground Advantage | 13 | 2.47 lbs | $32.46 | $12.78 | $19.68 |
| 233901 | 2025-02-20 | $39.76 | USPS Ground Advantage | 3 | 1.46 lbs | $7.48 | $6.45 | $1.03 |
| 233902 | 2025-02-20 | $30.12 | USPS Ground Advantage | 2 | 1.25 lbs | $10.26 | $8.78 | $1.48 |
| 233903 | 2025-02-20 | $12.92 | USPS Ground Advantage | 1 | 0.08 lbs | $5.28 | $4.33 | $0.95 |
| 233904 | 2025-02-21 | $12.83 | USPS Ground Advantage | 1 | 0.05 lbs | $4.93 | $3.98 | $0.95 |
| 233905 | 2025-02-22 | $16.56 | USPS Ground Advantage | 4 | 0.05 lbs | $5.20 | $4.25 | $0.95 |
| 233906 | 2025-02-21 | $11.23 | USPS Ground Advantage | 1 | 0.10 lbs | $5.03 | $4.52 | $0.51 |
| 233907 | 2025-02-23 | $56.62 | USPS Ground Parcel or Priority Mail | 1 | 0.75 lbs | $8.63 | $8.50 | $0.13 |
| 233908 | 2025-02-24 | $53.98 | USPS Ground Advantage | 1 | 1.25 lbs | $7.24 | $6.29 | $0.95 |
| 233909 | 2025-02-23 | $12.17 | USPS Ground Advantage | 1 | 0.06 lbs | $5.46 | $4.51 | $0.95 |
| 233910 | 2025-02-23 | $11.14 | USPS Ground Advantage | 1 | 0.05 lbs | $5.20 | $4.25 | $0.95 |
| 233911 | 2025-02-23 | $51.15 | USPS Ground Advantage | 1 | 1.45 lbs | $8.74 | $7.79 | $0.95 |
| 233912 | 2025-02-23 | $11.04 | USPS Ground Advantage | 1 | 0.25 lbs | $5.46 | $4.84 | $0.62 |
| 233913 | 2025-02-23 | $37.98 | USPS Ground Advantage | 4 | 0.25 lbs | $15.09 | $8.05 | $7.04 |
| 233914 | 2025-02-23 | $23.80 | USPS Ground Advantage | 2 | 0.11 lbs | $5.46 | $4.84 | $0.62 |
| 233915 | 2025-02-22 | $27.78 | USPS Ground Advantage | 1 | 0.20 lbs | $5.09 | $4.57 | $0.52 |
| 233916 | 2025-02-22 | $68.59 | USPS Ground Advantage | 1 | 2.85 lbs | $7.40 | $6.45 | $0.95 |
| 233917 | 2025-02-22 | $9.91 | USPS Ground Advantage | 1 | 0.18 lbs | $4.14 | $4.14 | $0.00 |
| 233918 | 2025-02-22 | $20.20 | USPS Ground Advantage | 1 | 0.70 lbs | $8.31 | $7.36 | $0.95 |
| 233919 | 2025-02-24 | $39.67 | USPS Ground Advantage | 1 | 1.00 lbs | $8.74 | $7.79 | $0.95 |
| 233920 | 2025-02-24 | $55.33 | USPS Ground Advantage | 4 | 2.32 lbs | $12.65 | $11.22 | $1.43 |
| 233921 | 2025-02-24 | $7.04 | USPS Ground Advantage | 1 | 0.02 lbs | $4.83 | $4.08 | $0.75 |
| 233922 | 2025-02-25 | $34.26 | USPS Ground Advantage | 2 | 1.16 lbs | $10.26 | $8.78 | $1.48 |
| 233924 | 2025-02-26 | $17.14 | USPS Ground Advantage | 1 | 0.20 lbs | $4.91 | $4.41 | $0.50 |
| 233925 | 2025-02-26 | $15.96 | USPS Ground Advantage | 1 | 0.05 lbs | $5.09 | $4.14 | $0.95 |
| 233927 | 2025-02-27 | $8.02 | USPS Ground Advantage | 2 | 0.04 lbs | $5.28 | $4.71 | $0.57 |
| 233928 | 2025-02-27 | $10.10 | USPS Ground Advantage | 1 | 0.18 lbs | $4.33 | $4.71 | $-0.38 |
| 233929 | 2025-02-28 | $31.01 | USPS Ground Advantage | 2 | 0.97 lbs | $8.23 | $7.58 | $0.65 |
| 233934 | 2025-03-01 | $8.48 | USPS Ground Advantage | 1 | 0.05 lbs | $5.28 | $4.33 | $0.95 |
| 233935 | 2025-03-01 | $8.85 | USPS Ground Advantage | 2 | 0.06 lbs | $5.03 | $4.08 | $0.95 |
| 233937 | 2025-02-28 | $9.75 | USPS Ground Advantage | 4 | 0.08 lbs | $4.91 | $4.41 | $0.50 |
| 233938 | 2025-02-28 | $15.84 | USPS Ground Advantage | 4 | 0.12 lbs | $5.28 | $4.71 | $0.57 |
| 233939 | 2025-02-28 | $11.96 | USPS Ground Advantage | 1 | 0.64 lbs | $6.44 | $4.62 | $1.82 |
| 233940 | 2025-03-03 | $56.22 | USPS Ground Advantage | 1 | 1.25 lbs | $9.48 | $8.53 | $0.95 |
| 233941 | 2025-03-02 | $25.00 | USPS Ground Advantage | 1 | 0.25 lbs | $5.03 | $4.08 | $0.95 |
| 233942 | 2025-03-02 | $25.46 | USPS Ground Advantage | 1 | 0.65 lbs | $6.57 | $6.57 | $0.00 |
| 233943 | 2025-03-02 | $13.33 | USPS Ground Advantage | 1 | 0.20 lbs | $5.09 | $4.14 | $0.95 |
| 233944 | 2025-03-02 | $31.90 | USPS Ground Advantage | 1 | 0.85 lbs | $8.11 | $7.16 | $0.95 |
| 233945 | 2025-03-02 | $26.29 | USPS Ground Advantage | 2 | 0.54 lbs | $6.57 | $7.16 | $-0.59 |
| 233946 | 2025-03-01 | $31.08 | USPS Ground Advantage | 1 | 2.12 lbs | $10.69 | $9.74 | $0.95 |
| 233947 | 2025-03-01 | $30.27 | USPS Ground Advantage | 1 | 0.06 lbs | $5.20 | $4.25 | $0.95 |
| 233948 | 2025-03-03 | $34.89 | USPS Ground Advantage | 1 | 0.40 lbs | $5.57 | $4.62 | $0.95 |
| 233949 | 2025-03-03 | $38.56 | USPS Ground Advantage | 1 | 0.58 lbs | $6.44 | $5.49 | $0.95 |
| 233950 | 2025-03-03 | $52.46 | USPS Ground Advantage | 6 | 0.94 lbs | $22.41 | $6.57 | $15.84 |
| 233952 | 2025-03-03 | $15.00 | USPS Ground Advantage | 2 | 0.36 lbs | $4.62 | $5.49 | $-0.87 |
| 233956 | 2025-03-05 | $10.97 | USPS Ground Advantage | 1 | 0.05 lbs | $5.03 | $4.08 | $0.95 |
| 233957 | 2025-03-05 | $8.08 | USPS Ground Advantage | 1 | 0.05 lbs | $5.03 | $4.52 | $0.51 |
| 233958 | 2025-03-05 | $30.96 | USPS Ground Advantage | 5 | 0.61 lbs | $6.16 | $4.52 | $1.64 |
| 233959 | 2025-03-05 | $47.35 | USPS Ground Advantage | 1 | 1.30 lbs | $7.24 | $6.29 | $0.95 |
| 233960 | 2025-03-06 | $30.61 | USPS Ground Advantage | 3 | 0.14 lbs | $15.60 | $4.62 | $10.98 |
| 233961 | 2025-03-06 | $18.32 | USPS Ground Advantage | 1 | 0.30 lbs | $5.66 | $4.71 | $0.95 |
| 233962 | 2025-03-06 | $45.03 | USPS Ground Advantage | 1 | 1.25 lbs | $8.49 | $7.54 | $0.95 |
| 233963 | 2025-03-07 | $45.55 | USPS Priority Mail | 1 | 0.17 lbs | $8.96 | $4.71 | $4.25 |
| 233964 | 2025-03-07 | $12.78 | USPS Ground Advantage | 3 | 0.57 lbs | $6.75 | $6.84 | $-0.09 |
| 233965 | 2025-03-07 | $22.74 | USPS Ground Advantage | 2 | 0.40 lbs | $5.66 | $8.71 | $-3.05 |
| 233966 | 2025-03-10 | $75.39 | USPS Ground Advantage | 1 | 2.85 lbs | $7.40 | $6.45 | $0.95 |
| 233967 | 2025-03-09 | $76.70 | USPS Ground Advantage | 9 | 1.08 lbs | $16.56 | $9.74 | $6.82 |
| 233968 | 2025-03-09 | $16.30 | USPS Ground Advantage | 1 | 0.10 lbs | $5.26 | $4.51 | $0.75 |
| 233969 | 2025-03-09 | $10.72 | USPS Ground Advantage | 1 | 0.06 lbs | $5.46 | $4.51 | $0.95 |
| 233970 | 2025-03-09 | $60.52 | USPS Ground Advantage | 1 | 1.84 lbs | $7.40 | $8.22 | $-0.82 |
| 233971 | 2025-03-08 | $16.62 | USPS Ground Advantage | 1 | 0.27 lbs | $5.66 | $4.71 | $0.95 |
| 233972 | 2025-03-08 | $32.23 | USPS Ground Advantage | 1 | 0.13 lbs | $5.46 | $4.84 | $0.62 |
| 233973 | 2025-03-08 | $16.30 | USPS Ground Advantage | 1 | 0.10 lbs | $5.26 | $4.51 | $0.75 |
| 233974 | 2025-03-10 | $27.87 | USPS Ground Advantage | 2 | 2.20 lbs | $9.53 | $7.36 | $2.17 |
| 233975 | 2025-03-10 | $40.81 | USPS Ground Advantage | 1 | 2.00 lbs | $11.07 | $7.36 | $3.71 |
| 233976 | 2025-03-10 | $11.74 | USPS Ground Advantage | 1 | 0.06 lbs | $5.03 | $4.08 | $0.95 |
| 233978 | 2025-03-12 | $11.97 | USPS Ground Advantage | 1 | 0.06 lbs | $5.09 | $4.14 | $0.95 |
| 233979 | 2025-03-11 | $15.22 | USPS Ground Advantage | 1 | 0.19 lbs | $5.03 | $4.08 | $0.95 |
| 233980 | 2025-03-11 | $15.65 | USPS Ground Advantage | 1 | 0.14 lbs | $5.46 | $4.51 | $0.95 |
| 233981 | 2025-03-11 | $8.85 | USPS Ground Advantage | 1 | 0.03 lbs | $5.03 | $4.08 | $0.95 |
| 233982 | 2025-03-12 | $19.91 | USPS Ground Advantage | 3 | 0.54 lbs | $5.21 | $6.07 | $-0.86 |
| 233983 | 2025-03-13 | $46.21 | USPS Ground Advantage | 1 | 5.00 lbs | $12.02 | $12.78 | $-0.76 |
| 233984 | 2025-03-14 | $72.53 | USPS Ground Advantage | 1 | 9.24 lbs | $14.74 | $15.59 | $-0.85 |
| 233985 | 2025-03-13 | $18.16 | USPS Ground Advantage | 3 | 0.15 lbs | $5.20 | $4.62 | $0.58 |
| 233986 | 2025-03-14 | $12.49 | USPS Ground Advantage | 1 | 0.10 lbs | $5.20 | $4.25 | $0.95 |
| 233987 | 2025-03-16 | $58.48 | Priority Mail Medium Flat Rate Box | 2 | 6.20 lbs | $18.30 | $16.65 | $1.65 |
| 233988 | 2025-03-16 | $12.20 | USPS Ground Advantage | 1 | 0.07 lbs | $5.46 | $4.51 | $0.95 |
| 233989 | 2025-03-16 | $19.45 | USPS Ground Advantage | 4 | 0.25 lbs | $5.09 | $4.14 | $0.95 |
| 233990 | 2025-03-15 | $10.62 | USPS Ground Advantage | 1 | 0.18 lbs | $4.51 | $4.84 | $-0.33 |
| 233992 | 2025-03-15 | $30.54 | USPS Ground Advantage | 1 | 0.69 lbs | $5.80 | $6.84 | $-1.04 |
| 233993 | 2025-03-14 | $15.99 | USPS Ground Advantage | 1 | 0.14 lbs | $5.20 | $4.25 | $0.95 |
| 233994 | 2025-03-14 | $28.95 | USPS Ground Advantage | 1 | 0.20 lbs | $4.93 | $3.98 | $0.95 |
| 233995 | 2025-03-14 | $29.48 | USPS Ground Advantage | 1 | 0.20 lbs | $5.46 | $4.84 | $0.62 |
| 233996 | 2025-03-14 | $8.32 | USPS Ground Advantage | 1 | 0.05 lbs | $5.09 | $4.14 | $0.95 |
| 233997 | 2025-03-15 | $16.62 | USPS Ground Parcel or Priority Mail | 1 | 0.07 lbs | $8.63 | $4.51 | $4.12 |
| 233998 | 2025-03-17 | $12.49 | USPS Ground Advantage | 1 | 0.08 lbs | $5.03 | $4.08 | $0.95 |
| 233999 | 2025-03-17 | $39.86 | USPS Ground Advantage | 2 | 1.25 lbs | $7.48 | $6.53 | $0.95 |
| 234000 | 2025-03-18 | $127.14 | USPS Ground Advantage | 15 | 0.73 lbs | $81.90 | $6.84 | $75.06 |
| 234001 | 2025-03-18 | $14.01 | USPS Ground Advantage | 1 | 0.05 lbs | $5.20 | $4.25 | $0.95 |
| 234002 | 2025-03-19 | $14.09 | USPS Ground Advantage | 1 | 0.04 lbs | $5.28 | $4.33 | $0.95 |
| 234003 | 2025-03-20 | $101.74 | USPS Ground Advantage | 2 | 2.50 lbs | $12.66 | $8.24 | $4.42 |
| 234005 | 2025-03-19 | $65.19 | USPS Ground Advantage | 1 | 1.30 lbs | $7.24 | $6.29 | $0.95 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |