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 |
|---|---|---|---|---|---|---|---|---|
| 232833 | 2024-03-19 | $33.74 | USPS First Class | 1 | 0.06 lbs | $5.25 | $3.96 | $1.29 |
| 232835 | 2024-03-20 | $12.64 | USPS First Class | 1 | 0.25 lbs | $5.35 | $4.43 | $0.92 |
| 232836 | 2024-03-20 | $54.75 | First-Class Package International Service | 4 | 1.80 lbs | $42.91 | $34.86 | $8.05 |
| 232837 | 2024-03-21 | $13.66 | USPS Ground Parcel or Priority Mail | 1 | 0.40 lbs | $8.18 | $5.07 | $3.11 |
| 232838 | 2024-03-21 | $8.58 | USPS First Class | 1 | 0.01 lbs | $5.25 | $3.96 | $1.29 |
| 232839 | 2024-03-22 | $18.50 | USPS Ground Parcel or Priority Mail | 1 | 0.19 lbs | $6.02 | $3.96 | $2.06 |
| 232841 | 2024-03-24 | $33.38 | Priority Mail | 10 | 1.96 lbs | $13.18 | $8.82 | $4.36 |
| 232842 | 2024-03-25 | $18.14 | USPS First Class | 1 | 0.10 lbs | $5.15 | $3.86 | $1.29 |
| 232843 | 2024-03-24 | $15.34 | USPS First Class | 1 | 0.07 lbs | $5.35 | $4.02 | $1.33 |
| 232844 | 2024-03-24 | $12.44 | USPS First Class | 1 | 0.06 lbs | $5.55 | $4.36 | $1.19 |
| 232845 | 2024-03-24 | $9.94 | USPS First Class | 1 | 0.07 lbs | $5.15 | $3.86 | $1.29 |
| 232846 | 2024-03-23 | $12.04 | USPS First Class | 1 | 0.05 lbs | $5.15 | $3.86 | $1.29 |
| 232847 | 2024-03-25 | $17.24 | USPS First Class | 1 | 0.05 lbs | $5.45 | $4.19 | $1.26 |
| 232848 | 2024-03-26 | $14.19 | Priority Mail Flat Rate Envelope | 1 | 0.10 lbs | $9.60 | $7.99 | $1.61 |
| 232849 | 2024-03-26 | $10.14 | USPS First Class | 1 | 0.41 lbs | $6.15 | $5.62 | $0.53 |
| 232850 | 2024-03-28 | $44.98 | USPS First Class | 2 | 0.12 lbs | $10.00 | $3.79 | $6.21 |
| 232851 | 2024-03-28 | $9.54 | USPS First Class | 1 | 0.02 lbs | $5.55 | $4.36 | $1.19 |
| 232852 | 2024-03-29 | $18.04 | USPS First Class | 1 | 0.30 lbs | $6.05 | $4.55 | $1.50 |
| 232853 | 2024-03-29 | $13.04 | USPS First Class | 1 | 0.06 lbs | $5.15 | $3.86 | $1.29 |
| 232855 | 2024-03-29 | $58.49 | USPS Priority Mail | 1 | 1.17 lbs | $14.50 | $8.51 | $5.99 |
| 232856 | 2024-03-30 | $7.24 | USPS First Class | 1 | 0.03 lbs | $5.25 | $3.96 | $1.29 |
| 232858 | 2024-03-31 | $12.24 | USPS First Class | 1 | 0.05 lbs | $5.55 | $4.36 | $1.19 |
| 232859 | 2024-03-30 | $65.99 | USPS First Class | 1 | 0.50 lbs | $6.00 | $5.32 | $0.68 |
| 232860 | 2024-04-01 | $19.31 | USPS Ground Parcel or Priority Mail | 1 | 0.06 lbs | $8.18 | $3.86 | $4.32 |
| 232862 | 2024-04-02 | $15.14 | USPS First Class | 1 | 0.06 lbs | $5.25 | $3.96 | $1.29 |
| 232863 | 2024-04-04 | $13.74 | USPS First Class | 1 | 0.06 lbs | $5.25 | $3.96 | $1.29 |
| 232864 | 2024-04-07 | $27.44 | Priority Mail | 6 | 1.14 lbs | $15.32 | $13.17 | $2.15 |
| 232865 | 2024-04-07 | $10.34 | USPS First Class | 1 | 0.10 lbs | $5.55 | $4.36 | $1.19 |
| 232866 | 2024-04-08 | $16.89 | USPS Ground Parcel or Priority Mail | 1 | 0.10 lbs | $8.18 | $4.19 | $3.99 |
| 232867 | 2024-04-08 | $65.89 | USPS First Class | 1 | 0.50 lbs | $5.90 | $4.38 | $1.52 |
| 232871 | 2024-04-09 | $57.49 | USPS First Class | 1 | 0.56 lbs | $7.00 | $5.62 | $1.38 |
| 232873 | 2024-04-09 | $10.29 | USPS First Class | 1 | 0.05 lbs | $5.40 | $4.11 | $1.29 |
| 232875 | 2024-04-11 | $33.15 | Priority Mail Small Flat Rate Box | 1 | 0.22 lbs | $10.15 | $6.77 | $3.38 |
| 232876 | 2024-04-12 | $14.84 | USPS First Class | 1 | 0.05 lbs | $5.55 | $4.36 | $1.19 |
| 232877 | 2024-04-12 | $28.84 | USPS Ground Parcel or Priority Mail | 2 | 0.12 lbs | $16.36 | $3.96 | $12.40 |
| 232878 | 2024-04-11 | $15.27 | USPS Ground Parcel or Priority Mail | 1 | 0.05 lbs | $8.18 | $4.19 | $3.99 |
| 232881 | 2024-04-15 | $30.54 | USPS First Class | 1 | 0.03 lbs | $5.55 | $4.36 | $1.19 |
| 232882 | 2024-04-13 | $10.74 | USPS First Class | 1 | 0.06 lbs | $5.35 | $4.02 | $1.33 |
| 232883 | 2024-04-12 | $13.34 | USPS First Class | 1 | 0.06 lbs | $5.45 | $4.19 | $1.26 |
| 232885 | 2024-04-15 | $48.30 | Priority Mail | 1 | 1.05 lbs | $10.38 | $6.82 | $3.56 |
| 232886 | 2024-04-15 | $13.40 | USPS First Class | 1 | 0.05 lbs | $5.45 | $4.19 | $1.26 |
| 232887 | 2024-04-16 | $84.98 | Priority Mail Flat Rate Envelope | 2 | 2.30 lbs | $9.60 | $8.74 | $0.86 |
| 232888 | 2024-04-16 | $8.58 | USPS First Class | 1 | 0.01 lbs | $5.25 | $3.96 | $1.29 |
| 232889 | 2024-04-18 | $38.99 | USPS First Class | 1 | 0.85 lbs | $9.00 | $10.42 | $-1.42 |
| 232890 | 2024-04-17 | $11.14 | USPS Ground Advantage | 1 | 0.10 lbs | $5.35 | $4.02 | $1.33 |
| 232891 | 2024-04-17 | $12.67 | USPS Ground Parcel or Priority Mail | 3 | 0.38 lbs | $24.54 | $5.32 | $19.22 |
| 232892 | 2024-04-18 | $13.50 | USPS First Class | 1 | 0.05 lbs | $5.55 | $4.36 | $1.19 |
| 232894 | 2024-04-20 | $32.98 | USPS First Class | 2 | 0.34 lbs | $15.70 | $9.62 | $6.08 |
| 232895 | 2024-04-21 | $14.87 | USPS Ground Parcel or Priority Mail | 1 | 0.08 lbs | $8.18 | $4.11 | $4.07 |
| 232896 | 2024-04-22 | $17.68 | USPS First Class | 2 | 0.02 lbs | $10.70 | $4.02 | $6.68 |
| 232897 | 2024-04-22 | $27.87 | Priority Mail Flat Rate Envelope | 3 | 0.34 lbs | $9.60 | $8.51 | $1.09 |
| 232898 | 2024-04-22 | $14.04 | USPS First Class | 1 | 0.05 lbs | $5.55 | $4.36 | $1.19 |
| 232899 | 2024-04-23 | $9.54 | USPS First Class | 1 | 0.07 lbs | $5.25 | $3.96 | $1.29 |
| 232900 | 2024-04-26 | $13.50 | USPS First Class | 1 | 0.05 lbs | $5.55 | $4.36 | $1.19 |
| 232901 | 2024-04-26 | $12.04 | USPS First Class | 1 | 0.10 lbs | $5.35 | $4.02 | $1.33 |
| 232905 | 2024-04-27 | $86.90 | USPS First Class | 5 | 1.11 lbs | $27.15 | $6.35 | $20.80 |
| 232906 | 2024-04-26 | $13.20 | USPS First Class | 1 | 0.05 lbs | $5.25 | $3.96 | $1.29 |
| 232909 | 2024-04-27 | $13.84 | USPS First Class | 1 | 0.06 lbs | $5.35 | $4.02 | $1.33 |
| 232910 | 2024-04-29 | $15.64 | USPS First Class | 1 | 0.15 lbs | $5.35 | $4.02 | $1.33 |
| 232911 | 2024-04-29 | $18.74 | USPS Ground Advantage | 1 | 0.27 lbs | $5.85 | $4.31 | $1.54 |
| 232912 | 2024-04-30 | $9.04 | USPS Ground Advantage | 1 | 0.07 lbs | $5.55 | $4.36 | $1.19 |
| 232913 | 2024-04-30 | $13.20 | USPS Ground Advantage | 1 | 0.05 lbs | $5.25 | $3.96 | $1.29 |
| 232914 | 2024-05-01 | $11.94 | USPS First Class | 1 | 0.05 lbs | $5.25 | $3.96 | $1.29 |
| 232915 | 2024-05-01 | $13.99 | USPS First Class | 1 | 0.28 lbs | $0.00 | $10.93 | $-10.93 |
| 232916 | 2024-05-01 | $9.24 | USPS First Class | 1 | 0.05 lbs | $5.25 | $3.96 | $1.29 |
| 232917 | 2024-05-02 | $12.62 | USPS Ground Parcel or Priority Mail | 1 | 0.06 lbs | $8.18 | $4.19 | $3.99 |
| 232918 | 2024-05-02 | $10.44 | USPS First Class | 1 | 0.05 lbs | $5.55 | $4.36 | $1.19 |
| 232919 | 2024-05-02 | $13.35 | USPS Ground Advantage | 1 | 0.05 lbs | $5.40 | $4.11 | $1.29 |
| 232920 | 2024-05-02 | $28.39 | USPS Priority Mail | 1 | 1.10 lbs | $16.40 | $11.97 | $4.43 |
| 232922 | 2024-05-04 | $19.04 | USPS First Class | 1 | 0.15 lbs | $5.45 | $4.55 | $0.90 |
| 232923 | 2024-05-04 | $13.20 | USPS Ground Advantage | 1 | 0.05 lbs | $5.25 | $3.96 | $1.29 |
| 232924 | 2024-05-06 | $10.94 | USPS Ground Advantage | 1 | 0.28 lbs | $5.95 | $4.43 | $1.52 |
| 232926 | 2024-05-06 | $13.84 | USPS First Class | 1 | 0.05 lbs | $5.35 | $4.02 | $1.33 |
| 232929 | 2024-05-08 | $9.24 | USPS First Class | 1 | 0.05 lbs | $5.25 | $3.96 | $1.29 |
| 232930 | 2024-05-08 | $14.39 | USPS First Class | 1 | 0.25 lbs | $5.40 | $5.32 | $0.08 |
| 232931 | 2024-05-10 | $52.89 | USPS Priority Mail | 1 | 3.15 lbs | $26.90 | $13.17 | $13.73 |
| 232935 | 2024-05-12 | $28.32 | USPS First Class | 3 | 0.03 lbs | $16.35 | $4.19 | $12.16 |
| 232936 | 2024-05-12 | $19.14 | USPS Ground Advantage | 1 | 0.40 lbs | $6.15 | $5.62 | $0.53 |
| 232937 | 2024-05-12 | $13.50 | USPS Ground Advantage | 1 | 0.05 lbs | $5.55 | $4.36 | $1.19 |
| 232938 | 2024-05-13 | $12.46 | USPS Ground Parcel or Priority Mail | 1 | 0.25 lbs | $6.02 | $4.13 | $1.89 |
| 232939 | 2024-05-14 | $10.04 | USPS Ground Advantage | 1 | 0.05 lbs | $5.25 | $3.96 | $1.29 |
| 232940 | 2024-05-13 | $12.24 | USPS First Class | 1 | 0.08 lbs | $5.55 | $4.36 | $1.19 |
| 232941 | 2024-05-14 | $13.24 | USPS First Class | 1 | 0.06 lbs | $5.35 | $4.02 | $1.33 |
| 232942 | 2024-05-14 | $13.30 | USPS Ground Advantage | 1 | 0.05 lbs | $5.35 | $4.02 | $1.33 |
| 232943 | 2024-05-15 | $19.04 | USPS First Class | 1 | 0.40 lbs | $6.05 | $5.45 | $0.60 |
| 232944 | 2024-05-15 | $46.89 | USPS First Class | 1 | 0.75 lbs | $6.90 | $6.23 | $0.67 |
| 232945 | 2024-05-15 | $21.79 | USPS Priority Mail | 1 | 1.00 lbs | $9.80 | $6.91 | $2.89 |
| 232946 | 2024-05-15 | $10.79 | USPS First Class | 1 | 0.06 lbs | $5.40 | $5.32 | $0.08 |
| 232947 | 2024-05-16 | $20.59 | USPS Ground Advantage | 1 | 1.00 lbs | $8.60 | $7.16 | $1.44 |
| 232948 | 2024-05-18 | $31.36 | USPS Ground Advantage | 4 | 0.67 lbs | $12.00 | $6.16 | $5.84 |
| 232949 | 2024-05-17 | $10.64 | USPS Ground Advantage | 1 | 0.06 lbs | $5.25 | $3.96 | $1.29 |
| 232956 | 2024-05-21 | $40.92 | USPS Ground Advantage | 1 | 1.27 lbs | $5.93 | $5.93 | $0.00 |
| 232957 | 2024-05-21 | $15.44 | USPS First Class | 1 | 0.06 lbs | $5.55 | $4.36 | $1.19 |
| 232958 | 2024-05-22 | $9.44 | USPS Ground Advantage | 1 | 0.05 lbs | $5.45 | $4.19 | $1.26 |
| 232959 | 2024-05-23 | $8.04 | USPS First Class | 1 | 0.27 lbs | $4.55 | $4.19 | $0.36 |
| 232960 | 2024-05-24 | $14.54 | USPS First Class | 1 | 0.05 lbs | $5.25 | $3.96 | $1.29 |
| 232961 | 2024-05-23 | $20.04 | USPS Ground Advantage | 1 | 0.70 lbs | $6.05 | $6.23 | $-0.18 |
| 232963 | 2024-05-26 | $10.35 | USPS Ground Advantage | 1 | 0.18 lbs | $4.36 | $4.68 | $-0.32 |
| 232964 | 2024-05-26 | $14.04 | USPS First Class | 1 | 0.05 lbs | $5.55 | $4.36 | $1.19 |
| 232966 | 2024-05-24 | $41.94 | USPS First Class | 1 | 0.31 lbs | $5.95 | $5.15 | $0.80 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |