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 |
|---|---|---|---|---|---|---|---|---|
| 233078 | 2024-07-14 | $50.56 | USPS Ground Advantage | 2 | 0.36 lbs | $8.58 | $6.23 | $2.35 |
| 233079 | 2024-07-13 | $40.37 | USPS Ground Advantage | 1 | 0.31 lbs | $4.38 | $4.38 | $0.00 |
| 233080 | 2024-07-13 | $11.91 | USPS First Class | 1 | 0.06 lbs | $4.02 | $4.02 | $0.00 |
| 233081 | 2024-07-13 | $18.95 | USPS First Class | 1 | 0.19 lbs | $3.96 | $4.38 | $-0.42 |
| 233082 | 2024-07-13 | $9.85 | USPS Ground Advantage | 1 | 0.18 lbs | $3.86 | $3.86 | $0.00 |
| 233083 | 2024-07-13 | $11.25 | USPS First Class | 1 | 0.05 lbs | $4.36 | $4.36 | $0.00 |
| 233084 | 2024-07-13 | $159.17 | USPS Priority Mail | 1 | 3.38 lbs | $9.18 | $10.57 | $-1.39 |
| 233085 | 2024-07-13 | $19.54 | USPS Ground Advantage | 1 | 0.30 lbs | $4.55 | $4.55 | $0.00 |
| 233086 | 2024-07-12 | $10.88 | USPS First Class | 1 | 0.05 lbs | $4.19 | $4.19 | $0.00 |
| 233087 | 2024-07-15 | $19.54 | USPS Ground Advantage | 1 | 0.30 lbs | $4.55 | $4.55 | $0.00 |
| 233088 | 2024-07-15 | $10.91 | USPS First Class | 1 | 0.05 lbs | $4.02 | $4.02 | $0.00 |
| 233089 | 2024-07-15 | $9.15 | USPS Ground Advantage | 1 | 0.05 lbs | $4.36 | $4.36 | $0.00 |
| 233090 | 2024-07-16 | $33.85 | USPS First Class | 1 | 0.06 lbs | $4.36 | $4.36 | $0.00 |
| 233091 | 2024-07-16 | $12.14 | USPS Ground Advantage | 1 | 0.05 lbs | $4.19 | $4.19 | $0.00 |
| 233092 | 2024-07-17 | $23.01 | USPS Ground Advantage | 1 | 0.12 lbs | $4.02 | $4.02 | $0.00 |
| 233093 | 2024-07-17 | $22.53 | USPS Ground Advantage | 2 | 0.40 lbs | $4.55 | $5.45 | $-0.90 |
| 233094 | 2024-07-18 | $10.18 | USPS First Class | 1 | 0.05 lbs | $4.19 | $4.19 | $0.00 |
| 233095 | 2024-07-18 | $47.75 | USPS Ground Advantage | 2 | 1.83 lbs | $9.77 | $8.29 | $1.48 |
| 233096 | 2024-07-21 | $27.51 | Priority Mail Flat Rate Envelope | 9 | 0.37 lbs | $9.60 | $8.18 | $1.42 |
| 233097 | 2024-07-20 | $13.18 | USPS First Class | 1 | 0.05 lbs | $4.19 | $4.19 | $0.00 |
| 233098 | 2024-07-20 | $23.52 | FedEx Ground or FedEx Home Delivery | 1 | 0.69 lbs | $11.73 | $6.66 | $5.07 |
| 233099 | 2024-07-19 | $15.87 | USPS Ground Advantage | 1 | 0.25 lbs | $4.38 | $4.38 | $0.00 |
| 233100 | 2024-07-19 | $17.95 | USPS First Class | 1 | 0.15 lbs | $4.36 | $4.36 | $0.00 |
| 233101 | 2024-07-22 | $14.46 | USPS Ground Advantage | 1 | 0.30 lbs | $4.47 | $4.47 | $0.00 |
| 233102 | 2024-07-22 | $17.33 | Priority Mail | 3 | 0.52 lbs | $9.35 | $6.90 | $2.45 |
| 233103 | 2024-07-23 | $19.58 | USPS Ground Parcel or Priority Mail | 1 | 0.09 lbs | $8.18 | $4.11 | $4.07 |
| 233105 | 2024-07-23 | $10.25 | USPS First Class | 1 | 0.06 lbs | $4.36 | $4.36 | $0.00 |
| 233106 | 2024-07-23 | $11.35 | USPS First Class | 1 | 0.05 lbs | $3.86 | $3.86 | $0.00 |
| 233149 | 2024-08-05 | $44.34 | Priority Mail Flat Rate Envelope | 8 | 0.45 lbs | $9.60 | $8.18 | $1.42 |
| 233151 | 2024-08-06 | $30.06 | USPS Priority Mail | 1 | 1.70 lbs | $7.07 | $7.07 | $0.00 |
| 233152 | 2024-08-06 | $11.05 | USPS First Class | 1 | 0.15 lbs | $4.36 | $4.36 | $0.00 |
| 233153 | 2024-08-05 | $23.89 | USPS First Class | 2 | 0.12 lbs | $4.11 | $4.11 | $0.00 |
| 233154 | 2024-08-06 | $17.34 | USPS First Class | 1 | 0.35 lbs | $4.55 | $4.55 | $0.00 |
| 233155 | 2024-08-06 | $10.65 | USPS First Class | 1 | 0.10 lbs | $3.96 | $3.96 | $0.00 |
| 233156 | 2024-08-06 | $12.45 | USPS First Class | 1 | 0.12 lbs | $4.36 | $4.36 | $0.00 |
| 233157 | 2024-08-06 | $17.68 | UPS Ground | 1 | 0.04 lbs | $10.69 | $7.47 | $3.22 |
| 233158 | 2024-08-06 | $10.68 | USPS First Class | 1 | 0.02 lbs | $4.19 | $4.19 | $0.00 |
| 233161 | 2024-08-07 | $12.95 | USPS First Class | 1 | 0.18 lbs | $3.96 | $4.38 | $-0.42 |
| 233162 | 2024-08-07 | $23.31 | USPS First Class | 1 | 0.65 lbs | $5.32 | $6.23 | $-0.91 |
| 233163 | 2024-08-07 | $8.75 | USPS First Class | 1 | 0.07 lbs | $3.96 | $3.96 | $0.00 |
| 233165 | 2024-08-07 | $8.10 | USPS First Class | 1 | 0.05 lbs | $4.11 | $4.11 | $0.00 |
| 233166 | 2024-08-07 | $8.95 | USPS First Class | 1 | 0.03 lbs | $3.96 | $3.96 | $0.00 |
| 233167 | 2024-08-07 | $10.65 | USPS First Class | 1 | 0.15 lbs | $3.96 | $3.96 | $0.00 |
| 233168 | 2024-08-07 | $67.45 | USPS First Class | 4 | 0.99 lbs | $16.49 | $7.17 | $9.32 |
| 233169 | 2024-08-07 | $25.96 | USPS First Class | 1 | 0.50 lbs | $4.47 | $5.32 | $-0.85 |
| 233170 | 2024-08-08 | $37.55 | USPS Ground Advantage | 1 | 1.18 lbs | $7.56 | $7.56 | $0.00 |
| 233171 | 2024-08-07 | $8.75 | USPS First Class | 1 | 0.10 lbs | $3.96 | $3.96 | $0.00 |
| 233172 | 2024-08-08 | $23.35 | USPS Ground Advantage | 1 | 0.12 lbs | $4.36 | $4.36 | $0.00 |
| 233173 | 2024-08-08 | $24.10 | USPS First Class | 1 | 0.15 lbs | $4.11 | $4.11 | $0.00 |
| 233174 | 2024-08-08 | $19.35 | USPS First Class | 1 | 0.19 lbs | $4.36 | $4.68 | $-0.32 |
| 233175 | 2024-08-08 | $30.90 | USPS First Class | 1 | 0.06 lbs | $4.36 | $4.36 | $0.00 |
| 233176 | 2024-08-09 | $9.85 | USPS First Class | 1 | 0.10 lbs | $4.36 | $4.36 | $0.00 |
| 233177 | 2024-08-10 | $20.18 | USPS First Class | 1 | 0.20 lbs | $4.19 | $4.55 | $-0.36 |
| 233178 | 2024-08-09 | $25.36 | UPS Ground | 2 | 0.20 lbs | $7.56 | $4.37 | $3.19 |
| 233179 | 2024-08-11 | $13.17 | USPS First Class | 2 | 0.12 lbs | $4.19 | $4.19 | $0.00 |
| 233180 | 2024-08-11 | $10.10 | USPS Ground Advantage | 1 | 0.18 lbs | $4.11 | $4.47 | $-0.36 |
| 233181 | 2024-08-11 | $12.95 | USPS First Class | 1 | 0.12 lbs | $3.96 | $3.96 | $0.00 |
| 233182 | 2024-08-11 | $9.95 | USPS First Class | 1 | 0.07 lbs | $3.96 | $3.96 | $0.00 |
| 233183 | 2024-08-11 | $10.75 | USPS First Class | 1 | 0.05 lbs | $3.86 | $3.86 | $0.00 |
| 233184 | 2024-08-11 | $10.35 | USPS First Class | 1 | 0.06 lbs | $4.36 | $4.36 | $0.00 |
| 233185 | 2024-08-11 | $10.18 | USPS Ground Advantage | 1 | 0.18 lbs | $4.19 | $4.19 | $0.00 |
| 233186 | 2024-08-11 | $16.54 | USPS First Class | 1 | 0.40 lbs | $4.55 | $5.45 | $-0.90 |
| 233187 | 2024-08-10 | $8.00 | USPS Ground Advantage | 2 | 0.06 lbs | $4.02 | $4.02 | $0.00 |
| 233188 | 2024-08-10 | $15.20 | USPS First Class | 1 | 0.12 lbs | $3.96 | $3.96 | $0.00 |
| 233189 | 2024-08-10 | $22.63 | USPS First Class | 1 | 0.55 lbs | $5.45 | $5.45 | $0.00 |
| 233191 | 2024-08-12 | $33.51 | USPS First Class | 1 | 0.06 lbs | $4.02 | $4.02 | $0.00 |
| 233192 | 2024-08-12 | $11.01 | USPS First Class | 1 | 0.03 lbs | $4.02 | $4.02 | $0.00 |
| 233193 | 2024-08-12 | $42.86 | USPS Priority Mail | 1 | 1.25 lbs | $7.07 | $8.71 | $-1.64 |
| 233194 | 2024-08-13 | $16.82 | USPS First Class | 1 | 0.35 lbs | $4.43 | $5.15 | $-0.72 |
| 233195 | 2024-08-13 | $10.85 | USPS First Class | 1 | 0.05 lbs | $3.96 | $3.96 | $0.00 |
| 233196 | 2024-08-12 | $16.35 | USPS Ground Advantage | 1 | 0.25 lbs | $4.36 | $4.68 | $-0.32 |
| 233197 | 2024-08-12 | $13.98 | USPS First Class | 1 | 0.04 lbs | $4.19 | $4.19 | $0.00 |
| 233198 | 2024-08-12 | $10.88 | USPS First Class | 1 | 0.05 lbs | $4.19 | $4.19 | $0.00 |
| 233199 | 2024-08-12 | $15.47 | USPS First Class | 1 | 0.30 lbs | $4.68 | $4.68 | $0.00 |
| 233200 | 2024-08-12 | $15.98 | USPS First Class | 1 | 0.05 lbs | $4.19 | $4.19 | $0.00 |
| 233201 | 2024-08-13 | $22.92 | USPS Priority Mail | 1 | 1.00 lbs | $9.43 | $8.95 | $0.48 |
| 233202 | 2024-08-13 | $27.70 | USPS First Class | 2 | 0.15 lbs | $7.72 | $3.86 | $3.86 |
| 233203 | 2024-08-13 | $11.05 | USPS Ground Advantage | 1 | 0.05 lbs | $4.36 | $4.36 | $0.00 |
| 233204 | 2024-08-13 | $16.81 | USPS First Class | 1 | 0.10 lbs | $4.02 | $4.02 | $0.00 |
| 233205 | 2024-08-13 | $32.25 | USPS Ground Advantage | 1 | 3.15 lbs | $6.26 | $6.88 | $-0.62 |
| 233206 | 2024-08-13 | $12.00 | USPS Ground Advantage | 1 | 0.06 lbs | $4.11 | $4.11 | $0.00 |
| 233207 | 2024-08-13 | $18.90 | USPS First Class | 2 | 0.62 lbs | $5.32 | $6.23 | $-0.91 |
| 233208 | 2024-08-14 | $23.34 | USPS First Class | 1 | 0.50 lbs | $4.55 | $5.45 | $-0.90 |
| 233209 | 2024-08-14 | $14.18 | USPS First Class | 1 | 0.20 lbs | $4.19 | $4.55 | $-0.36 |
| 233210 | 2024-08-14 | $7.95 | USPS First Class | 1 | 0.05 lbs | $3.96 | $3.96 | $0.00 |
| 233211 | 2024-08-14 | $97.68 | Priority Mail | 2 | 4.00 lbs | $27.52 | $23.96 | $3.56 |
| 233212 | 2024-08-14 | $28.95 | USPS First Class | 1 | 0.03 lbs | $3.96 | $3.96 | $0.00 |
| 233213 | 2024-08-14 | $30.09 | USPS Ground Advantage | 1 | 2.30 lbs | $8.00 | $11.57 | $-3.57 |
| 233214 | 2024-08-15 | $17.15 | USPS First Class | 1 | 0.15 lbs | $4.36 | $4.36 | $0.00 |
| 233215 | 2024-08-15 | $16.53 | USPS Ground Advantage | 2 | 0.36 lbs | $4.55 | $5.45 | $-0.90 |
| 233216 | 2024-08-16 | $17.32 | USPS Ground Advantage | 1 | 0.27 lbs | $4.43 | $4.43 | $0.00 |
| 233217 | 2024-08-16 | $14.00 | USPS Ground Advantage | 1 | 0.06 lbs | $4.11 | $4.11 | $0.00 |
| 233218 | 2024-08-15 | $16.62 | USPS First Class | 1 | 0.40 lbs | $4.43 | $5.15 | $-0.72 |
| 233219 | 2024-08-17 | $10.08 | USPS First Class | 1 | 0.03 lbs | $4.19 | $4.19 | $0.00 |
| 233220 | 2024-08-16 | $20.25 | USPS First Class | 1 | 0.25 lbs | $3.96 | $4.38 | $-0.42 |
| 233221 | 2024-08-16 | $15.35 | USPS First Class | 1 | 0.05 lbs | $4.36 | $4.36 | $0.00 |
| 233222 | 2024-08-16 | $21.45 | USPS Ground Advantage | 1 | 0.12 lbs | $4.36 | $4.36 | $0.00 |
| 233224 | 2024-08-17 | $15.58 | USPS First Class | 1 | 0.05 lbs | $3.79 | $3.79 | $0.00 |
| 233225 | 2024-08-19 | $15.60 | USPS First Class | 1 | 0.10 lbs | $4.11 | $4.11 | $0.00 |
| 233226 | 2024-08-19 | $62.99 | USPS Ground Advantage | 1 | 1.50 lbs | $8.00 | $8.00 | $0.00 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |