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 |
|---|---|---|---|---|---|---|---|---|
| 231803 | 2023-06-07 | $26.14 | USPS Shipping | 1 | 0.25 lbs | $5.15 | $4.24 | $0.91 |
| 231804 | 2023-06-08 | $29.94 | USPS First Class | 1 | 0.80 lbs | $7.95 | $6.22 | $1.73 |
| 231805 | 2023-06-08 | $12.54 | USPS First Class | 1 | 0.03 lbs | $5.25 | $4.13 | $1.12 |
| 231806 | 2023-06-08 | $15.94 | USPS Shipping | 1 | 0.05 lbs | $5.15 | $3.97 | $1.18 |
| 231807 | 2023-06-09 | $36.85 | First-Class Package Service | 2 | 0.70 lbs | $7.17 | $6.22 | $0.95 |
| 231808 | 2023-06-09 | $9.65 | First-Class Package Service | 1 | 0.05 lbs | $5.17 | $3.97 | $1.20 |
| 231809 | 2023-06-11 | $54.87 | Priority Mail | 1 | 0.95 lbs | $17.07 | $9.43 | $7.64 |
| 231810 | 2023-06-11 | $14.84 | USPS First Class | 1 | 0.55 lbs | $6.55 | $5.17 | $1.38 |
| 231811 | 2023-06-11 | $7.94 | USPS First Class | 1 | 0.03 lbs | $5.05 | $3.81 | $1.24 |
| 231812 | 2023-06-11 | $98.99 | USPS Priority Mail | 1 | 2.85 lbs | $14.50 | $8.82 | $5.68 |
| 231813 | 2023-06-12 | $11.39 | USPS Shipping | 1 | 0.10 lbs | $5.15 | $4.13 | $1.02 |
| 231814 | 2023-06-11 | $71.39 | USPS Shipping | 1 | 1.20 lbs | $16.40 | $8.30 | $8.10 |
| 231815 | 2023-06-11 | $25.10 | USPS Shipping | 1 | 0.91 lbs | $8.61 | $6.71 | $1.90 |
| 231816 | 2023-06-12 | $12.84 | First-Class Package Service | 1 | 0.06 lbs | $5.10 | $3.90 | $1.20 |
| 231817 | 2023-06-13 | $13.04 | USPS First Class | 1 | 0.06 lbs | $5.15 | $3.97 | $1.18 |
| 231818 | 2023-06-14 | $12.24 | USPS First Class | 1 | 0.03 lbs | $5.25 | $4.13 | $1.12 |
| 231819 | 2023-06-14 | $55.25 | Ground | 1 | 5.30 lbs | $29.81 | $25.11 | $4.70 |
| 231820 | 2023-06-14 | $23.31 | First-Class Package Service | 11 | 0.60 lbs | $6.24 | $5.04 | $1.20 |
| 231821 | 2023-06-15 | $16.60 | USPS Shipping | 1 | 0.83 lbs | $8.61 | $9.57 | $-0.96 |
| 231825 | 2023-06-16 | $51.77 | Priority Mail Small Flat Rate Box | 1 | 1.50 lbs | $9.65 | $8.10 | $1.55 |
| 231826 | 2023-06-15 | $32.69 | USPS First Class | 1 | 0.39 lbs | $5.70 | $4.24 | $1.46 |
| 231827 | 2023-06-15 | $13.94 | USPS First Class | 1 | 0.06 lbs | $5.15 | $3.97 | $1.18 |
| 231831 | 2023-06-16 | $21.01 | First-Class Package Service | 2 | 0.38 lbs | $5.35 | $4.15 | $1.20 |
| 231832 | 2023-06-16 | $31.24 | First-Class Package Service | 3 | 0.18 lbs | $5.35 | $4.15 | $1.20 |
| 231833 | 2023-06-16 | $16.04 | First-Class Package Service | 5 | 0.53 lbs | $6.08 | $4.20 | $1.88 |
| 231834 | 2023-06-17 | $28.26 | First-Class Package Service | 3 | 0.42 lbs | $6.24 | $5.04 | $1.20 |
| 231835 | 2023-06-17 | $13.74 | First-Class Package Service | 1 | 0.19 lbs | $5.35 | $3.75 | $1.60 |
| 231836 | 2023-06-17 | $25.39 | First-Class Package Service | 1 | 0.30 lbs | $5.40 | $4.20 | $1.20 |
| 231837 | 2023-06-18 | $20.93 | First-Class Package Service | 2 | 0.35 lbs | $5.35 | $4.15 | $1.20 |
| 231839 | 2023-06-18 | $20.48 | USPS First Class | 2 | 0.10 lbs | $10.50 | $4.13 | $6.37 |
| 231840 | 2023-06-18 | $12.94 | USPS First Class | 1 | 0.06 lbs | $5.05 | $3.81 | $1.24 |
| 231841 | 2023-06-19 | $14.85 | USPS First-Class Mail or Priority Mail | 1 | 0.25 lbs | $8.61 | $4.44 | $4.17 |
| 231842 | 2023-06-19 | $12.67 | USPS Shipping | 1 | 0.10 lbs | $5.15 | $4.13 | $1.02 |
| 231845 | 2023-06-19 | $26.41 | First-Class Package Service | 2 | 0.40 lbs | $5.83 | $4.88 | $0.95 |
| 231848 | 2023-06-19 | $128.93 | Priority Mail Flat Rate Envelope | 2 | 1.41 lbs | $9.15 | $8.30 | $0.85 |
| 231852 | 2023-06-19 | $33.57 | Priority Mail Small Flat Rate Box | 4 | 0.40 lbs | $9.65 | $8.10 | $1.55 |
| 231855 | 2023-06-20 | $9.69 | USPS First Class | 1 | 0.41 lbs | $5.70 | $5.04 | $0.66 |
| 231859 | 2023-06-21 | $101.43 | Ground | 2 | 5.42 lbs | $37.75 | $25.19 | $12.56 |
| 231860 | 2023-06-21 | $67.01 | Priority Mail Small Flat Rate Box | 25 | 1.14 lbs | $9.65 | $8.10 | $1.55 |
| 231861 | 2023-06-21 | $8.69 | First-Class Package Service | 1 | 0.02 lbs | $4.95 | $3.75 | $1.20 |
| 231864 | 2023-06-21 | $15.14 | USPS First Class | 1 | 0.05 lbs | $5.15 | $3.97 | $1.18 |
| 231869 | 2023-06-24 | $6.89 | USPS First Class | 1 | 0.04 lbs | $4.90 | $3.66 | $1.24 |
| 231872 | 2023-06-25 | $11.88 | First-Class Package Service | 1 | 0.20 lbs | $5.64 | $4.44 | $1.20 |
| 231874 | 2023-06-26 | $16.16 | First-Class Package Service | 1 | 0.07 lbs | $5.17 | $3.97 | $1.20 |
| 231875 | 2023-06-26 | $14.91 | First-Class Package Service | 2 | 0.06 lbs | $5.33 | $4.13 | $1.20 |
| 231877 | 2023-06-26 | $8.14 | USPS First Class | 1 | 0.06 lbs | $4.85 | $3.64 | $1.21 |
| 231879 | 2023-06-26 | $44.80 | Priority Mail | 8 | 1.64 lbs | $14.27 | $13.17 | $1.10 |
| 231885 | 2023-06-26 | $64.06 | UPS Ground | 1 | 2.54 lbs | $14.07 | $6.86 | $7.21 |
| 231888 | 2023-06-27 | $16.23 | USPS Shipping | 1 | 0.04 lbs | $5.15 | $3.66 | $1.49 |
| 231889 | 2023-06-27 | $15.62 | First-Class Package Service | 1 | 0.07 lbs | $5.33 | $4.13 | $1.20 |
| 231890 | 2023-06-28 | $71.39 | USPS Shipping | 1 | 1.20 lbs | $16.40 | $8.30 | $8.10 |
| 231891 | 2023-06-28 | $10.64 | USPS First Class | 1 | 0.23 lbs | $5.25 | $3.65 | $1.60 |
| 231894 | 2023-06-29 | $24.99 | USPS First Class | 1 | 0.15 lbs | $5.00 | $3.75 | $1.25 |
| 231895 | 2023-06-29 | $12.99 | USPS First Class | 1 | 0.07 lbs | $5.00 | $3.75 | $1.25 |
| 231900 | 2023-06-29 | $95.42 | Priority Mail | 3 | 2.90 lbs | $17.11 | $14.00 | $3.11 |
| 231901 | 2023-06-30 | $15.09 | USPS First Class | 1 | 0.08 lbs | $5.10 | $3.90 | $1.20 |
| 231902 | 2023-06-29 | $12.89 | USPS First Class | 1 | 0.06 lbs | $5.00 | $3.75 | $1.25 |
| 231903 | 2023-06-30 | $77.23 | Priority Mail | 7 | 5.65 lbs | $18.47 | $15.16 | $3.31 |
| 231904 | 2023-06-30 | $42.89 | USPS Priority Mail | 1 | 1.60 lbs | $13.40 | $9.94 | $3.46 |
| 231906 | 2023-06-30 | $34.32 | Priority Mail Flat Rate Envelope | 3 | 2.85 lbs | $9.15 | $8.10 | $1.05 |
| 231907 | 2023-06-30 | $27.92 | Priority Mail | 16 | 2.15 lbs | $10.35 | $7.20 | $3.15 |
| 231908 | 2023-07-01 | $35.02 | Priority Mail Small Flat Rate Box | 1 | 1.20 lbs | $9.65 | $8.10 | $1.55 |
| 231910 | 2023-07-01 | $92.52 | Priority Mail | 1 | 3.62 lbs | $22.53 | $15.48 | $7.05 |
| 231913 | 2023-07-02 | $30.67 | Priority Mail | 2 | 1.20 lbs | $14.49 | $8.82 | $5.67 |
| 231916 | 2023-07-02 | $9.29 | USPS First Class | 1 | 0.07 lbs | $5.00 | $3.75 | $1.25 |
| 231917 | 2023-07-02 | $18.64 | USPS First Class | 1 | 0.60 lbs | $6.65 | $5.33 | $1.32 |
| 231918 | 2023-06-30 | $15.24 | USPS First Class | 1 | 0.05 lbs | $5.25 | $4.13 | $1.12 |
| 231919 | 2023-07-02 | $23.44 | USPS Shipping | 1 | 1.15 lbs | $9.15 | $8.10 | $1.05 |
| 231924 | 2023-07-05 | $47.83 | Priority Mail Medium Flat Rate Box | 7 | 2.45 lbs | $16.40 | $14.00 | $2.40 |
| 231926 | 2023-07-05 | $14.09 | First-Class Package Service | 4 | 0.24 lbs | $5.64 | $4.13 | $1.51 |
| 231927 | 2023-07-05 | $17.14 | USPS Shipping | 1 | 0.50 lbs | $8.61 | $8.56 | $0.05 |
| 231928 | 2023-07-05 | $8.73 | USPS Shipping | 1 | 0.04 lbs | $5.15 | $3.81 | $1.34 |
| 231929 | 2023-07-05 | $139.88 | Priority Mail Padded Flat Rate Envelope | 2 | 3.80 lbs | $9.90 | $8.18 | $1.72 |
| 231932 | 2023-07-05 | $16.69 | First-Class Package Service | 2 | 0.28 lbs | $5.44 | $4.24 | $1.20 |
| 231934 | 2023-07-06 | $67.04 | Priority Mail Small Flat Rate Box | 1 | 1.55 lbs | $9.65 | $8.10 | $1.55 |
| 231935 | 2023-07-06 | $78.24 | Priority Mail | 2 | 3.00 lbs | $10.26 | $8.30 | $1.96 |
| 231937 | 2023-07-06 | $17.62 | Priority Mail Flat Rate Envelope | 2 | 0.07 lbs | $9.15 | $8.10 | $1.05 |
| 231938 | 2023-07-06 | $9.55 | First-Class Package Service | 1 | 0.05 lbs | $5.01 | $3.81 | $1.20 |
| 231939 | 2023-07-06 | $43.28 | Priority Mail | 6 | 0.65 lbs | $9.34 | $8.10 | $1.24 |
| 231940 | 2023-07-07 | $24.92 | USPS Shipping | 3 | 0.60 lbs | $15.45 | $4.74 | $10.71 |
| 231941 | 2023-07-07 | $13.84 | USPS First Class | 1 | 0.30 lbs | $5.85 | $4.44 | $1.41 |
| 231942 | 2023-07-07 | $11.14 | USPS First Class | 1 | 0.03 lbs | $5.25 | $4.13 | $1.12 |
| 231944 | 2023-07-07 | $9.24 | USPS First Class | 1 | 0.05 lbs | $5.25 | $4.13 | $1.12 |
| 231946 | 2023-07-08 | $16.74 | Priority Mail Small Flat Rate Box | 6 | 0.18 lbs | $9.65 | $8.10 | $1.55 |
| 231947 | 2023-07-09 | $16.99 | Priority Mail Flat Rate Envelope | 2 | 0.38 lbs | $9.15 | $8.10 | $1.05 |
| 231948 | 2023-07-10 | $17.63 | Priority Mail Padded Flat Rate Envelope | 1 | 0.05 lbs | $9.90 | $8.10 | $1.80 |
| 231949 | 2023-07-09 | $16.84 | USPS First Class | 1 | 0.14 lbs | $5.15 | $2.07 | $3.08 |
| 231950 | 2023-07-09 | $17.74 | USPS First Class | 1 | 0.40 lbs | $5.75 | $5.17 | $0.58 |
| 231951 | 2023-07-08 | $12.64 | USPS First Class | 1 | 0.03 lbs | $5.15 | $3.97 | $1.18 |
| 231954 | 2023-07-11 | $14.69 | USPS First Class | 1 | 0.55 lbs | $6.40 | $4.88 | $1.52 |
| 231955 | 2023-07-11 | $9.49 | USPS First Class | 1 | 0.06 lbs | $5.00 | $3.75 | $1.25 |
| 231956 | 2023-07-11 | $11.69 | USPS First Class | 1 | 0.10 lbs | $5.00 | $3.75 | $1.25 |
| 231957 | 2023-07-12 | $18.67 | USPS Shipping | 1 | 0.30 lbs | $5.75 | $4.24 | $1.51 |
| 231959 | 2023-07-13 | $13.04 | USPS First Class | 1 | 0.03 lbs | $5.15 | $3.97 | $1.18 |
| 231960 | 2023-07-12 | $9.79 | USPS First Class | 1 | 0.12 lbs | $4.90 | $3.66 | $1.24 |
| 231962 | 2023-07-13 | $35.87 | Ground | 5 | 0.17 lbs | $27.56 | $7.14 | $20.42 |
| 231963 | 2023-07-14 | $16.25 | Priority Mail | 6 | 0.06 lbs | $9.34 | $7.60 | $1.74 |
| 231964 | 2023-07-14 | $28.59 | USPS First Class | 1 | 0.35 lbs | $5.60 | $4.15 | $1.45 |
| 231965 | 2023-07-14 | $23.68 | Priority Mail | 2 | 2.00 lbs | $9.68 | $8.30 | $1.38 |
| 231969 | 2023-07-14 | $11.04 | USPS First Class | 1 | 0.03 lbs | $5.15 | $3.97 | $1.18 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |