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 |
|---|---|---|---|---|---|---|---|---|
| 232967 | 2024-05-24 | $10.34 | USPS First Class | 1 | 0.05 lbs | $5.55 | $4.36 | $1.19 |
| 232969 | 2024-05-27 | $14.01 | USPS First Class | 1 | 0.10 lbs | $4.02 | $4.02 | $0.00 |
| 232970 | 2024-05-28 | $14.91 | USPS First Class | 1 | 0.05 lbs | $4.02 | $4.02 | $0.00 |
| 232971 | 2024-05-28 | $42.04 | USPS Ground Advantage | 1 | 0.31 lbs | $6.05 | $4.55 | $1.50 |
| 232972 | 2024-05-28 | $36.88 | USPS Priority Mail | 1 | 1.18 lbs | $6.89 | $6.91 | $-0.02 |
| 232973 | 2024-05-30 | $46.15 | USPS Ground Advantage | 1 | 1.20 lbs | $6.16 | $6.16 | $0.00 |
| 232974 | 2024-05-29 | $20.04 | USPS Ground Advantage | 1 | 0.70 lbs | $6.05 | $6.23 | $-0.18 |
| 232975 | 2024-05-29 | $41.89 | USPS Ground Advantage | 1 | 0.31 lbs | $5.90 | $4.38 | $1.52 |
| 232976 | 2024-05-31 | $8.24 | USPS First Class | 1 | 0.03 lbs | $5.45 | $4.19 | $1.26 |
| 232977 | 2024-05-30 | $10.44 | USPS Ground Advantage | 1 | 0.15 lbs | $5.15 | $4.31 | $0.84 |
| 232979 | 2024-06-01 | $12.34 | USPS First Class | 1 | 0.05 lbs | $5.45 | $4.19 | $1.26 |
| 232980 | 2024-06-03 | $10.34 | USPS First Class | 1 | 0.05 lbs | $5.45 | $4.19 | $1.26 |
| 232981 | 2024-06-04 | $20.71 | USPS Ground Parcel or Priority Mail | 1 | 0.10 lbs | $8.18 | $4.19 | $3.99 |
| 232982 | 2024-06-04 | $41.94 | USPS First Class | 1 | 0.31 lbs | $5.95 | $4.43 | $1.52 |
| 232983 | 2024-06-04 | $16.18 | USPS First Class | 1 | 0.06 lbs | $4.19 | $4.19 | $0.00 |
| 232986 | 2024-06-05 | $10.18 | USPS First Class | 1 | 0.05 lbs | $4.19 | $4.19 | $0.00 |
| 232988 | 2024-06-06 | $33.27 | USPS Ground Parcel or Priority Mail | 1 | 0.35 lbs | $8.18 | $4.55 | $3.63 |
| 232989 | 2024-06-06 | $30.07 | USPS Ground Parcel or Priority Mail | 1 | 0.35 lbs | $8.18 | $5.45 | $2.73 |
| 232990 | 2024-06-07 | $42.04 | USPS Ground Advantage | 1 | 0.31 lbs | $6.05 | $4.55 | $1.50 |
| 232991 | 2024-06-06 | $12.35 | USPS Ground Advantage | 1 | 0.10 lbs | $3.96 | $3.96 | $0.00 |
| 232992 | 2024-06-07 | $10.71 | USPS First Class | 1 | 0.15 lbs | $4.02 | $4.02 | $0.00 |
| 232993 | 2024-06-09 | $22.95 | USPS First Class | 1 | 0.12 lbs | $3.96 | $3.96 | $0.00 |
| 232994 | 2024-06-09 | $13.35 | USPS First Class | 1 | 0.06 lbs | $3.96 | $3.96 | $0.00 |
| 232995 | 2024-06-08 | $15.01 | USPS First Class | 1 | 0.10 lbs | $4.02 | $4.02 | $0.00 |
| 232996 | 2024-06-08 | $16.66 | USPS Ground Advantage | 2 | 0.36 lbs | $4.68 | $5.62 | $-0.94 |
| 232997 | 2024-06-07 | $10.84 | USPS First Class | 1 | 0.06 lbs | $5.45 | $4.19 | $1.26 |
| 232998 | 2024-06-11 | $40.46 | USPS Ground Advantage | 1 | 0.31 lbs | $4.47 | $4.47 | $0.00 |
| 232999 | 2024-06-11 | $7.25 | USPS First Class | 1 | 0.03 lbs | $4.36 | $4.36 | $0.00 |
| 233000 | 2024-06-11 | $32.45 | USPS First Class | 1 | 0.06 lbs | $3.96 | $3.96 | $0.00 |
| 233001 | 2024-06-11 | $40.46 | USPS Ground Advantage | 1 | 0.31 lbs | $4.47 | $4.47 | $0.00 |
| 233002 | 2024-06-12 | $40.54 | USPS Ground Advantage | 1 | 0.31 lbs | $4.55 | $4.55 | $0.00 |
| 233003 | 2024-06-13 | $40.67 | USPS Ground Advantage | 1 | 0.31 lbs | $4.68 | $4.68 | $0.00 |
| 233004 | 2024-06-13 | $10.00 | USPS First Class | 1 | 0.06 lbs | $4.11 | $4.11 | $0.00 |
| 233005 | 2024-06-15 | $56.52 | UPS Ground | 1 | 2.54 lbs | $6.53 | $6.00 | $0.53 |
| 233006 | 2024-06-14 | $16.53 | USPS Ground Advantage | 2 | 0.36 lbs | $4.55 | $5.45 | $-0.90 |
| 233007 | 2024-06-14 | $160.84 | USPS Priority Mail | 1 | 3.38 lbs | $10.85 | $14.22 | $-3.37 |
| 233008 | 2024-06-14 | $10.80 | USPS First Class | 1 | 0.09 lbs | $4.11 | $4.11 | $0.00 |
| 233009 | 2024-06-16 | $14.48 | USPS First Class | 1 | 0.10 lbs | $4.19 | $4.19 | $0.00 |
| 233010 | 2024-06-16 | $10.71 | USPS First Class | 1 | 0.05 lbs | $4.02 | $4.02 | $0.00 |
| 233011 | 2024-06-17 | $13.94 | USPS Ground Parcel or Priority Mail | 1 | 0.05 lbs | $8.18 | $4.02 | $4.16 |
| 233012 | 2024-06-17 | $9.75 | USPS Ground Advantage | 1 | 0.06 lbs | $4.36 | $4.36 | $0.00 |
| 233013 | 2024-06-17 | $25.22 | USPS Ground Advantage | 1 | 0.92 lbs | $6.23 | $6.23 | $0.00 |
| 233014 | 2024-06-17 | $14.00 | USPS First Class | 1 | 0.06 lbs | $4.11 | $4.11 | $0.00 |
| 233015 | 2024-06-18 | $12.37 | USPS Ground Parcel or Priority Mail | 1 | 0.04 lbs | $8.18 | $4.36 | $3.82 |
| 233016 | 2024-06-19 | $19.18 | USPS Ground Advantage | 1 | 0.19 lbs | $4.19 | $4.55 | $-0.36 |
| 233017 | 2024-06-18 | $18.54 | USPS Ground Advantage | 1 | 0.70 lbs | $4.55 | $4.55 | $0.00 |
| 233019 | 2024-06-19 | $12.86 | USPS Ground Advantage | 1 | 0.10 lbs | $3.96 | $3.96 | $0.00 |
| 233021 | 2024-06-19 | $20.81 | USPS Priority Mail | 1 | 1.10 lbs | $8.82 | $8.18 | $0.64 |
| 233022 | 2024-06-21 | $23.04 | USPS Ground Advantage | 3 | 0.54 lbs | $5.07 | $5.07 | $0.00 |
| 233023 | 2024-06-20 | $15.90 | USPS First Class | 1 | 0.05 lbs | $4.11 | $4.11 | $0.00 |
| 233024 | 2024-06-21 | $6.08 | USPS First Class | 1 | 0.06 lbs | $4.19 | $4.19 | $0.00 |
| 233025 | 2024-06-21 | $18.85 | USPS First Class | 1 | 0.19 lbs | $3.86 | $4.31 | $-0.45 |
| 233026 | 2024-06-21 | $57.73 | USPS Priority Mail | 1 | 5.15 lbs | $7.74 | $7.74 | $0.00 |
| 233027 | 2024-06-22 | $9.81 | USPS Ground Advantage | 1 | 0.10 lbs | $4.02 | $4.43 | $-0.41 |
| 233028 | 2024-06-21 | $23.01 | USPS First Class | 1 | 0.12 lbs | $4.02 | $4.43 | $-0.41 |
| 233029 | 2024-06-22 | $14.08 | USPS First Class | 1 | 0.06 lbs | $4.19 | $4.19 | $0.00 |
| 233030 | 2024-06-22 | $25.22 | USPS Ground Advantage | 1 | 0.92 lbs | $6.23 | $7.57 | $-1.34 |
| 233031 | 2024-06-22 | $9.15 | USPS First Class | 1 | 0.05 lbs | $4.36 | $4.36 | $0.00 |
| 233032 | 2024-06-23 | $10.01 | USPS First Class | 1 | 0.07 lbs | $4.02 | $4.02 | $0.00 |
| 233033 | 2024-06-23 | $10.65 | USPS First Class | 1 | 0.08 lbs | $3.96 | $3.96 | $0.00 |
| 233034 | 2024-06-23 | $14.34 | USPS Ground Parcel or Priority Mail | 1 | 0.09 lbs | $8.85 | $4.36 | $4.49 |
| 233035 | 2024-06-25 | $10.80 | USPS First Class | 1 | 0.09 lbs | $4.11 | $4.11 | $0.00 |
| 233036 | 2024-06-24 | $9.50 | USPS First Class | 1 | 0.06 lbs | $4.11 | $4.11 | $0.00 |
| 233037 | 2024-06-24 | $40.37 | USPS First Class | 1 | 0.31 lbs | $4.38 | $4.38 | $0.00 |
| 233038 | 2024-06-26 | $40.67 | USPS Ground Advantage | 1 | 0.31 lbs | $4.68 | $4.68 | $0.00 |
| 233039 | 2024-06-26 | $9.95 | USPS Ground Advantage | 1 | 0.18 lbs | $3.96 | $4.38 | $-0.42 |
| 233041 | 2024-06-26 | $20.42 | USPS First Class | 1 | 0.35 lbs | $4.43 | $4.43 | $0.00 |
| 233042 | 2024-06-27 | $16.17 | USPS Ground Advantage | 1 | 0.25 lbs | $4.68 | $4.68 | $0.00 |
| 233043 | 2024-06-27 | $13.18 | USPS First Class | 1 | 0.20 lbs | $4.19 | $4.55 | $-0.36 |
| 233044 | 2024-06-30 | $7.19 | USPS First Class | 1 | 0.01 lbs | $3.86 | $3.86 | $0.00 |
| 233045 | 2024-06-30 | $18.42 | USPS Ground Advantage | 1 | 0.70 lbs | $4.43 | $6.09 | $-1.66 |
| 233046 | 2024-07-01 | $10.55 | USPS Ground Advantage | 1 | 0.08 lbs | $3.86 | $3.86 | $0.00 |
| 233047 | 2024-07-03 | $13.25 | USPS First Class | 1 | 0.05 lbs | $3.96 | $3.96 | $0.00 |
| 233048 | 2024-07-02 | $23.18 | USPS Ground Advantage | 1 | 0.12 lbs | $4.19 | $4.19 | $0.00 |
| 233049 | 2024-07-02 | $40.37 | USPS Ground Advantage | 1 | 0.31 lbs | $4.38 | $4.38 | $0.00 |
| 233050 | 2024-07-04 | $22.57 | Priority Mail Flat Rate Envelope | 3 | 0.03 lbs | $9.60 | $8.18 | $1.42 |
| 233053 | 2024-07-05 | $17.35 | USPS First Class | 1 | 0.06 lbs | $4.36 | $4.36 | $0.00 |
| 233054 | 2024-07-05 | $10.35 | USPS Ground Advantage | 1 | 0.18 lbs | $4.36 | $4.68 | $-0.32 |
| 233055 | 2024-07-05 | $9.15 | USPS First Class | 1 | 0.05 lbs | $4.36 | $4.36 | $0.00 |
| 233056 | 2024-07-04 | $10.01 | USPS First Class | 1 | 0.05 lbs | $4.02 | $4.02 | $0.00 |
| 233057 | 2024-07-04 | $9.15 | USPS First Class | 1 | 0.03 lbs | $4.36 | $4.36 | $0.00 |
| 233058 | 2024-07-04 | $13.54 | USPS First Class | 1 | 0.30 lbs | $4.55 | $4.55 | $0.00 |
| 233059 | 2024-07-04 | $19.44 | USPS Ground Advantage | 1 | 0.48 lbs | $4.55 | $6.40 | $-1.85 |
| 233060 | 2024-07-04 | $9.75 | USPS Ground Advantage | 1 | 0.06 lbs | $4.36 | $4.36 | $0.00 |
| 233061 | 2024-07-03 | $29.46 | USPS First Class | 1 | 0.40 lbs | $4.47 | $5.32 | $-0.85 |
| 233062 | 2024-07-05 | $10.65 | USPS Ground Advantage | 1 | 0.08 lbs | $3.96 | $3.96 | $0.00 |
| 233063 | 2024-07-07 | $15.37 | USPS First Class | 1 | 0.31 lbs | $4.38 | $4.38 | $0.00 |
| 233064 | 2024-07-07 | $8.82 | USPS First Class | 1 | 0.40 lbs | $4.43 | $5.15 | $-0.72 |
| 233065 | 2024-07-07 | $40.54 | USPS Ground Advantage | 1 | 0.31 lbs | $4.55 | $4.55 | $0.00 |
| 233066 | 2024-07-07 | $21.75 | USPS Ground Advantage | 1 | 7.60 lbs | $6.76 | $6.76 | $0.00 |
| 233067 | 2024-07-07 | $9.40 | USPS Ground Advantage | 1 | 0.05 lbs | $4.11 | $4.11 | $0.00 |
| 233068 | 2024-07-06 | $36.56 | USPS Priority Mail | 1 | 3.15 lbs | $10.57 | $9.18 | $1.39 |
| 233069 | 2024-07-06 | $40.42 | USPS Ground Advantage | 1 | 0.31 lbs | $4.43 | $4.43 | $0.00 |
| 233070 | 2024-07-09 | $10.30 | USPS First Class | 1 | 0.10 lbs | $4.11 | $4.11 | $0.00 |
| 233071 | 2024-07-11 | $6.10 | USPS First Class | 1 | 0.03 lbs | $4.11 | $4.11 | $0.00 |
| 233072 | 2024-07-11 | $22.10 | USPS First Class | 1 | 0.16 lbs | $4.11 | $4.47 | $-0.36 |
| 233073 | 2024-07-10 | $40.54 | USPS Ground Advantage | 1 | 0.31 lbs | $4.55 | $4.55 | $0.00 |
| 233074 | 2024-07-12 | $16.54 | USPS First Class | 1 | 0.30 lbs | $4.55 | $4.55 | $0.00 |
| 233075 | 2024-07-11 | $16.18 | USPS First Class | 1 | 0.20 lbs | $4.19 | $4.19 | $0.00 |
| 233077 | 2024-07-14 | $19.10 | USPS First Class | 1 | 0.19 lbs | $4.11 | $4.47 | $-0.36 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |