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 |
|---|---|---|---|---|---|---|---|---|
| 231970 | 2023-07-17 | $12.18 | USPS Shipping | 1 | 0.23 lbs | $5.75 | $4.09 | $1.66 |
| 231971 | 2023-07-17 | $34.72 | Priority Mail Flat Rate Envelope | 2 | 0.40 lbs | $9.15 | $8.10 | $1.05 |
| 231972 | 2023-07-17 | $26.33 | Priority Mail Flat Rate Envelope | 2 | 0.90 lbs | $9.15 | $8.10 | $1.05 |
| 231973 | 2023-07-17 | $15.59 | USPS Ground Advantage | 1 | 0.48 lbs | $5.60 | $6.07 | $-0.47 |
| 231974 | 2023-07-19 | $14.69 | USPS First Class | 1 | 0.30 lbs | $5.70 | $4.24 | $1.46 |
| 231975 | 2023-07-19 | $17.33 | USPS Shipping | 2 | 0.10 lbs | $10.30 | $4.13 | $6.17 |
| 231976 | 2023-07-18 | $8.44 | USPS Shipping | 1 | 0.06 lbs | $5.15 | $4.13 | $1.02 |
| 231977 | 2023-07-19 | $37.84 | Priority Mail | 4 | 2.02 lbs | $11.88 | $8.82 | $3.06 |
| 231978 | 2023-07-20 | $48.25 | Priority Mail Padded Flat Rate Envelope | 1 | 10.00 lbs | $9.90 | $8.30 | $1.60 |
| 231983 | 2023-07-23 | $14.74 | USPS First Class | 1 | 0.55 lbs | $6.45 | $6.44 | $0.01 |
| 231984 | 2023-07-24 | $11.09 | USPS First Class | 1 | 0.07 lbs | $5.10 | $3.90 | $1.20 |
| 231988 | 2023-07-25 | $21.30 | Priority Mail Small Flat Rate Box | 4 | 0.20 lbs | $9.65 | $7.60 | $2.05 |
| 231989 | 2023-07-25 | $21.64 | Priority Mail Small Flat Rate Box | 1 | 0.30 lbs | $9.65 | $8.55 | $1.10 |
| 231990 | 2023-07-25 | $8.94 | USPS First Class | 1 | 0.05 lbs | $5.05 | $3.81 | $1.24 |
| 231994 | 2023-07-26 | $14.74 | USPS First Class | 1 | 0.55 lbs | $6.45 | $6.44 | $0.01 |
| 231995 | 2023-07-26 | $19.08 | USPS First Class | 2 | 0.15 lbs | $10.30 | $3.97 | $6.33 |
| 231996 | 2023-07-26 | $16.94 | Priority Mail Flat Rate Envelope | 6 | 0.06 lbs | $9.15 | $7.60 | $1.55 |
| 231998 | 2023-07-26 | $24.60 | Priority Mail Medium Flat Rate Box | 6 | 1.14 lbs | $15.85 | $13.17 | $2.68 |
| 232006 | 2023-07-28 | $11.94 | USPS First Class | 1 | 0.07 lbs | $5.25 | $4.13 | $1.12 |
| 232007 | 2023-07-29 | $54.01 | Priority Mail | 2 | 0.38 lbs | $9.57 | $8.10 | $1.47 |
| 232010 | 2023-07-30 | $14.69 | USPS First Class | 1 | 0.55 lbs | $6.40 | $4.88 | $1.52 |
| 232011 | 2023-07-28 | $15.64 | USPS Ground Advantage | 1 | 0.30 lbs | $5.65 | $4.20 | $1.45 |
| 232012 | 2023-07-31 | $49.64 | Priority Mail Small Flat Rate Box | 1 | 1.15 lbs | $9.65 | $8.10 | $1.55 |
| 232019 | 2023-08-01 | $48.81 | Priority Mail | 18 | 4.47 lbs | $25.59 | $21.43 | $4.16 |
| 232023 | 2023-08-02 | $12.99 | USPS First Class | 1 | 0.06 lbs | $5.10 | $3.90 | $1.20 |
| 232024 | 2023-08-01 | $14.74 | USPS First Class | 1 | 0.06 lbs | $5.25 | $4.13 | $1.12 |
| 232025 | 2023-08-01 | $15.74 | USPS Ground Advantage | 1 | 0.30 lbs | $5.75 | $4.31 | $1.44 |
| 232026 | 2023-08-02 | $34.37 | Priority Mail Flat Rate Envelope | 3 | 1.21 lbs | $9.15 | $8.30 | $0.85 |
| 232027 | 2023-08-03 | $17.13 | Priority Mail Flat Rate Envelope | 2 | 0.16 lbs | $9.15 | $7.60 | $1.55 |
| 232028 | 2023-08-02 | $15.04 | USPS First Class | 1 | 0.05 lbs | $5.05 | $3.81 | $1.24 |
| 232029 | 2023-08-03 | $11.14 | USPS Ground Parcel or Priority Mail | 1 | 0.06 lbs | $5.15 | $3.81 | $1.34 |
| 232030 | 2023-08-03 | $19.95 | Priority Mail Flat Rate Envelope | 1 | 0.30 lbs | $9.15 | $8.10 | $1.05 |
| 232031 | 2023-08-03 | $22.86 | Priority Mail | 1 | 1.19 lbs | $14.27 | $13.17 | $1.10 |
| 232032 | 2023-08-03 | $15.88 | Priority Mail Flat Rate Envelope | 2 | 0.07 lbs | $9.15 | $7.60 | $1.55 |
| 232033 | 2023-08-03 | $31.44 | USPS Priority Mail | 1 | 1.06 lbs | $11.45 | $7.05 | $4.40 |
| 232034 | 2023-08-04 | $9.96 | USPS Ground Parcel or Priority Mail | 1 | 0.05 lbs | $5.15 | $3.97 | $1.18 |
| 232036 | 2023-08-04 | $10.94 | USPS First Class | 1 | 0.03 lbs | $5.05 | $3.81 | $1.24 |
| 232037 | 2023-08-04 | $15.64 | USPS Ground Advantage | 1 | 0.30 lbs | $5.65 | $4.20 | $1.45 |
| 232041 | 2023-08-05 | $37.06 | Priority Mail | 10 | 3.35 lbs | $22.53 | $18.57 | $3.96 |
| 232046 | 2023-08-06 | $69.34 | Priority Mail | 40 | 10.00 lbs | $17.74 | $14.41 | $3.33 |
| 232048 | 2023-08-06 | $17.57 | Priority Mail Flat Rate Envelope | 3 | 0.09 lbs | $9.15 | $8.10 | $1.05 |
| 232049 | 2023-08-07 | $20.13 | Priority Mail Flat Rate Envelope | 2 | 0.20 lbs | $9.15 | $3.90 | $5.25 |
| 232050 | 2023-08-06 | $12.94 | USPS First Class | 1 | 0.06 lbs | $5.05 | $3.81 | $1.24 |
| 232051 | 2023-08-06 | $54.57 | USPS Ground Parcel or Priority Mail | 1 | 2.30 lbs | $18.58 | $16.17 | $2.41 |
| 232052 | 2023-08-07 | $25.17 | USPS Ground Parcel or Priority Mail | 1 | 0.06 lbs | $8.18 | $3.90 | $4.28 |
| 232054 | 2023-08-07 | $9.84 | USPS First Class | 1 | 0.05 lbs | $5.05 | $3.81 | $1.24 |
| 232055 | 2023-08-08 | $7.71 | USPS Ground Parcel or Priority Mail | 1 | 0.19 lbs | $5.15 | $4.13 | $1.02 |
| 232065 | 2023-08-08 | $15.19 | Priority Mail Flat Rate Envelope | 1 | 0.10 lbs | $9.15 | $7.60 | $1.55 |
| 232073 | 2023-08-11 | $18.54 | Priority Mail Padded Flat Rate Envelope | 1 | 0.10 lbs | $9.90 | $8.10 | $1.80 |
| 232075 | 2023-08-12 | $94.47 | Priority Mail | 2 | 1.52 lbs | $20.58 | $15.48 | $5.10 |
| 232079 | 2023-08-13 | $19.63 | Priority Mail | 1 | 0.20 lbs | $9.34 | $8.10 | $1.24 |
| 232083 | 2023-08-13 | $20.09 | USPS First Class | 1 | 0.40 lbs | $5.70 | $4.24 | $1.46 |
| 232084 | 2023-08-13 | $24.58 | USPS First Class | 2 | 0.26 lbs | $10.30 | $4.31 | $5.99 |
| 232085 | 2023-08-13 | $9.04 | USPS First Class | 1 | 0.18 lbs | $5.25 | $4.13 | $1.12 |
| 232086 | 2023-08-12 | $11.74 | USPS First Class | 1 | 0.15 lbs | $5.05 | $3.81 | $1.24 |
| 232087 | 2023-08-12 | $9.89 | USPS First Class | 1 | 0.05 lbs | $5.10 | $3.90 | $1.20 |
| 232088 | 2023-08-12 | $23.44 | USPS Ground Parcel or Priority Mail | 1 | 1.15 lbs | $9.15 | $8.10 | $1.05 |
| 232092 | 2023-08-14 | $14.87 | Priority Mail | 2 | 0.08 lbs | $10.06 | $7.60 | $2.46 |
| 232093 | 2023-08-14 | $30.28 | USPS First Class | 2 | 0.14 lbs | $10.30 | $3.97 | $6.33 |
| 232094 | 2023-08-15 | $31.11 | Priority Mail Flat Rate Envelope | 4 | 0.40 lbs | $9.15 | $8.10 | $1.05 |
| 232099 | 2023-08-16 | $17.91 | Priority Mail Flat Rate Envelope | 6 | 0.24 lbs | $9.15 | $7.60 | $1.55 |
| 232101 | 2023-08-16 | $13.14 | USPS First Class | 1 | 0.04 lbs | $5.15 | $3.97 | $1.18 |
| 232102 | 2023-08-16 | $54.57 | USPS Ground Parcel or Priority Mail | 1 | 2.30 lbs | $18.58 | $17.03 | $1.55 |
| 232103 | 2023-08-17 | $85.92 | Priority Mail | 4 | 15.82 lbs | $20.48 | $7.13 | $13.35 |
| 232105 | 2023-08-17 | $50.44 | First-Class Package International Service | 7 | 0.22 lbs | $23.01 | $14.96 | $8.05 |
| 232107 | 2023-08-18 | $15.14 | USPS First Class | 1 | 0.07 lbs | $5.15 | $3.97 | $1.18 |
| 232108 | 2023-08-19 | $30.43 | First-Class Package International Service | 1 | 0.02 lbs | $27.38 | $19.33 | $8.05 |
| 232113 | 2023-08-20 | $13.14 | USPS First Class | 1 | 0.03 lbs | $5.25 | $4.13 | $1.12 |
| 232114 | 2023-08-20 | $14.64 | USPS First Class | 1 | 0.30 lbs | $5.65 | $4.20 | $1.45 |
| 232115 | 2023-08-19 | $12.74 | USPS First Class | 1 | 0.07 lbs | $5.25 | $4.13 | $1.12 |
| 232117 | 2023-08-21 | $14.29 | USPS First Class | 1 | 0.05 lbs | $5.00 | $3.75 | $1.25 |
| 232118 | 2023-08-21 | $64.06 | Priority Mail | 9 | 0.67 lbs | $10.06 | $8.41 | $1.65 |
| 232119 | 2023-08-21 | $17.75 | Priority Mail Flat Rate Envelope | 2 | 0.06 lbs | $9.15 | $7.60 | $1.55 |
| 232121 | 2023-08-22 | $52.00 | Priority Mail Padded Flat Rate Envelope | 1 | 2.56 lbs | $9.90 | $8.10 | $1.80 |
| 232122 | 2023-08-22 | $8.57 | USPS Ground Parcel or Priority Mail | 1 | 0.01 lbs | $8.18 | $3.81 | $4.37 |
| 232123 | 2023-08-23 | $17.39 | Priority Mail Flat Rate Envelope | 1 | 0.07 lbs | $9.15 | $7.60 | $1.55 |
| 232124 | 2023-08-23 | $9.94 | USPS Ground Advantage | 1 | 0.15 lbs | $5.25 | $4.44 | $0.81 |
| 232125 | 2023-08-23 | $15.24 | USPS First Class | 1 | 0.19 lbs | $5.05 | $3.81 | $1.24 |
| 232126 | 2023-08-24 | $16.60 | Priority Mail Flat Rate Envelope | 5 | 0.23 lbs | $9.15 | $7.60 | $1.55 |
| 232129 | 2023-08-25 | $55.03 | Priority Mail | 15 | 3.80 lbs | $26.07 | $24.97 | $1.10 |
| 232131 | 2023-08-25 | $14.15 | Priority Mail Flat Rate Envelope | 1 | 0.05 lbs | $9.15 | $7.60 | $1.55 |
| 232132 | 2023-08-25 | $12.89 | USPS First Class | 1 | 0.04 lbs | $5.00 | $3.75 | $1.25 |
| 232133 | 2023-08-25 | $22.19 | USPS Priority Mail | 1 | 1.00 lbs | $10.20 | $7.05 | $3.15 |
| 232134 | 2023-08-25 | $16.17 | USPS Ground Parcel or Priority Mail | 1 | 0.83 lbs | $8.18 | $7.54 | $0.64 |
| 232135 | 2023-08-26 | $16.76 | Priority Mail Flat Rate Envelope | 3 | 0.04 lbs | $9.15 | $7.60 | $1.55 |
| 232139 | 2023-08-27 | $26.41 | Priority Mail Flat Rate Envelope | 3 | 0.15 lbs | $9.15 | $7.60 | $1.55 |
| 232140 | 2023-08-27 | $10.89 | USPS Ground Advantage | 1 | 0.10 lbs | $5.10 | $3.90 | $1.20 |
| 232141 | 2023-08-27 | $15.24 | USPS First Class | 1 | 0.05 lbs | $5.25 | $4.13 | $1.12 |
| 232144 | 2023-08-29 | $126.03 | Priority Mail Medium Flat Rate Box | 6 | 3.70 lbs | $16.40 | $8.30 | $8.10 |
| 232145 | 2023-08-29 | $8.64 | USPS First Class | 1 | 0.06 lbs | $5.25 | $4.13 | $1.12 |
| 232147 | 2023-08-30 | $12.94 | USPS First Class | 1 | 0.06 lbs | $5.05 | $3.81 | $1.24 |
| 232148 | 2023-08-31 | $16.17 | USPS Ground Parcel or Priority Mail | 1 | 0.07 lbs | $8.18 | $4.13 | $4.05 |
| 232150 | 2023-09-02 | $8.74 | USPS First Class | 1 | 0.05 lbs | $5.25 | $4.13 | $1.12 |
| 232151 | 2023-09-01 | $13.49 | USPS First Class | 1 | 0.05 lbs | $5.00 | $3.75 | $1.25 |
| 232152 | 2023-09-01 | $12.89 | USPS First Class | 1 | 0.06 lbs | $5.10 | $3.90 | $1.20 |
| 232155 | 2023-09-02 | $111.86 | Priority Mail | 41 | 9.16 lbs | $30.96 | $24.17 | $6.79 |
| 232156 | 2023-09-02 | $13.00 | Priority Mail Small Flat Rate Box | 3 | 0.06 lbs | $9.65 | $8.10 | $1.55 |
| 232157 | 2023-09-02 | $45.88 | Priority Mail | 10 | 1.69 lbs | $10.90 | $7.02 | $3.88 |
| 232159 | 2023-09-03 | $7.79 | USPS First Class | 1 | 0.03 lbs | $5.00 | $3.75 | $1.25 |
| 232160 | 2023-09-04 | $10.79 | USPS Ground Advantage | 1 | 0.10 lbs | $5.00 | $3.75 | $1.25 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |