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 |
|---|---|---|---|---|---|---|---|---|
| 233227 | 2024-08-19 | $34.37 | USPS Ground Advantage | 1 | 0.39 lbs | $4.38 | $5.07 | $-0.69 |
| 233228 | 2024-08-18 | $136.71 | USPS Priority Mail | 1 | 7.20 lbs | $9.32 | $11.06 | $-1.74 |
| 233229 | 2024-08-18 | $13.17 | USPS First Class | 1 | 0.06 lbs | $4.36 | $4.36 | $0.00 |
| 233230 | 2024-08-18 | $19.35 | USPS First Class | 1 | 0.03 lbs | $4.36 | $4.36 | $0.00 |
| 233231 | 2024-08-18 | $52.43 | USPS First Class | 4 | 0.50 lbs | $4.47 | $5.32 | $-0.85 |
| 233232 | 2024-08-17 | $21.84 | USPS Priority Mail | 1 | 2.30 lbs | $10.85 | $10.07 | $0.78 |
| 233233 | 2024-08-19 | $36.89 | USPS First Class | 5 | 2.28 lbs | $6.94 | $6.94 | $0.00 |
| 233234 | 2024-08-19 | $23.00 | USPS First Class | 2 | 0.10 lbs | $4.02 | $4.02 | $0.00 |
| 233235 | 2024-08-19 | $11.45 | USPS First Class | 1 | 0.25 lbs | $4.36 | $5.62 | $-1.26 |
| 233236 | 2024-08-21 | $7.90 | USPS First Class | 1 | 0.18 lbs | $4.11 | $4.11 | $0.00 |
| 233237 | 2024-08-20 | $31.46 | USPS Priority Mail | 1 | 5.44 lbs | $11.97 | $11.97 | $0.00 |
| 233238 | 2024-08-20 | $53.06 | USPS Priority Mail | 1 | 1.35 lbs | $7.07 | $7.07 | $0.00 |
| 233239 | 2024-08-20 | $19.01 | USPS First Class | 1 | 0.19 lbs | $4.02 | $4.02 | $0.00 |
| 233240 | 2024-08-20 | $19.01 | USPS First Class | 1 | 0.03 lbs | $4.02 | $4.02 | $0.00 |
| 233241 | 2024-08-20 | $6.94 | USPS First Class | 2 | 0.02 lbs | $4.36 | $4.36 | $0.00 |
| 233242 | 2024-08-20 | $12.45 | USPS First Class | 1 | 0.05 lbs | $3.96 | $3.96 | $0.00 |
| 233243 | 2024-08-20 | $13.75 | USPS Ground Advantage | 4 | 0.12 lbs | $3.79 | $3.79 | $0.00 |
| 233244 | 2024-08-21 | $10.67 | USPS First Class | 1 | 0.46 lbs | $4.68 | $5.62 | $-0.94 |
| 233245 | 2024-08-17 | $13.34 | USPS Ground Parcel or Priority Mail | 1 | 0.12 lbs | $8.85 | $3.96 | $4.89 |
| 233246 | 2024-08-21 | $32.59 | Priority Mail Flat Rate Envelope | 1 | 0.40 lbs | $9.60 | $8.18 | $1.42 |
| 233247 | 2024-08-22 | $18.10 | USPS First Class | 1 | 0.19 lbs | $4.11 | $4.11 | $0.00 |
| 233248 | 2024-08-22 | $9.25 | USPS First Class | 1 | 0.12 lbs | $4.36 | $4.36 | $0.00 |
| 233249 | 2024-08-21 | $9.21 | USPS Ground Advantage | 1 | 0.18 lbs | $4.02 | $4.02 | $0.00 |
| 233250 | 2024-08-21 | $12.05 | USPS First Class | 1 | 0.02 lbs | $3.96 | $3.96 | $0.00 |
| 233251 | 2024-08-22 | $12.51 | USPS First Class | 1 | 0.21 lbs | $4.02 | $4.02 | $0.00 |
| 233252 | 2024-08-23 | $24.42 | USPS First Class | 1 | 0.35 lbs | $4.43 | $5.15 | $-0.72 |
| 233253 | 2024-08-22 | $37.33 | USPS Ground Advantage | 1 | 1.18 lbs | $7.34 | $7.34 | $0.00 |
| 233254 | 2024-08-22 | $18.94 | USPS First Class | 1 | 0.40 lbs | $4.55 | $5.45 | $-0.90 |
| 233255 | 2024-08-22 | $16.35 | USPS First Class | 1 | 0.12 lbs | $4.36 | $4.36 | $0.00 |
| 233256 | 2024-08-22 | $22.10 | USPS First Class | 1 | 0.23 lbs | $4.11 | $4.47 | $-0.36 |
| 233257 | 2024-08-23 | $12.14 | USPS First Class | 1 | 0.05 lbs | $4.19 | $4.19 | $0.00 |
| 233258 | 2024-08-22 | $28.87 | USPS Ground Parcel or Priority Mail | 1 | 0.40 lbs | $3.88 | $5.45 | $-1.57 |
| 233259 | 2024-08-23 | $9.18 | USPS First Class | 1 | 0.03 lbs | $4.19 | $4.19 | $0.00 |
| 233261 | 2024-08-23 | $101.34 | Priority Mail | 23 | 8.88 lbs | $33.95 | $31.27 | $2.68 |
| 233262 | 2024-08-23 | $14.88 | USPS First Class | 2 | 0.18 lbs | $4.02 | $4.43 | $-0.41 |
| 233264 | 2024-08-24 | $11.85 | USPS Ground Advantage | 1 | 0.06 lbs | $3.96 | $3.96 | $0.00 |
| 233265 | 2024-08-24 | $11.48 | USPS First Class | 1 | 0.03 lbs | $4.19 | $4.19 | $0.00 |
| 233266 | 2024-08-24 | $23.61 | USPS First Class | 1 | 0.75 lbs | $5.62 | $6.66 | $-1.04 |
| 233267 | 2024-08-24 | $15.35 | USPS First Class | 1 | 0.10 lbs | $3.86 | $3.86 | $0.00 |
| 233268 | 2024-08-24 | $40.75 | UPS Ground | 1 | 0.55 lbs | $6.76 | $4.99 | $1.77 |
| 233269 | 2024-08-23 | $46.98 | USPS First Class | 1 | 0.90 lbs | $6.09 | $6.62 | $-0.53 |
| 233270 | 2024-08-23 | $22.80 | USPS First Class | 2 | 0.12 lbs | $4.02 | $4.02 | $0.00 |
| 233271 | 2024-08-25 | $21.74 | USPS Ground Parcel or Priority Mail | 1 | 0.20 lbs | $9.15 | $4.11 | $5.04 |
| 233272 | 2024-08-26 | $13.91 | USPS Ground Advantage | 1 | 0.06 lbs | $4.02 | $4.02 | $0.00 |
| 233273 | 2024-08-26 | $13.81 | USPS First Class | 1 | 0.06 lbs | $4.02 | $4.02 | $0.00 |
| 233274 | 2024-08-26 | $52.11 | UPS Ground | 1 | 0.70 lbs | $10.12 | $8.53 | $1.59 |
| 233275 | 2024-08-26 | $10.91 | USPS Ground Parcel or Priority Mail | 1 | 0.06 lbs | $8.18 | $4.11 | $4.07 |
| 233277 | 2024-08-26 | $29.40 | Priority Mail | 3 | 0.60 lbs | $10.96 | $8.95 | $2.01 |
| 233278 | 2024-08-25 | $9.25 | USPS Ground Parcel or Priority Mail | 1 | 0.03 lbs | $4.26 | $3.96 | $0.30 |
| 233279 | 2024-08-27 | $12.92 | USPS First Class | 1 | 0.06 lbs | $4.11 | $4.11 | $0.00 |
| 233280 | 2024-08-27 | $44.45 | USPS Ground Advantage | 2 | 0.38 lbs | $4.47 | $4.47 | $0.00 |
| 233281 | 2024-08-27 | $38.38 | UPS Ground | 1 | 0.75 lbs | $8.39 | $5.93 | $2.46 |
| 233282 | 2024-08-27 | $9.85 | USPS First Class | 1 | 0.06 lbs | $3.96 | $3.96 | $0.00 |
| 233283 | 2024-08-28 | $26.17 | USPS First Class | 1 | 0.30 lbs | $4.38 | $4.38 | $0.00 |
| 233284 | 2024-08-28 | $19.35 | USPS First Class | 1 | 0.19 lbs | $4.36 | $4.36 | $0.00 |
| 233285 | 2024-08-29 | $18.62 | USPS Ground Parcel or Priority Mail | 1 | 0.06 lbs | $8.18 | $3.96 | $4.22 |
| 233288 | 2024-09-01 | $42.37 | USPS Ground Advantage | 3 | 0.44 lbs | $12.34 | $4.38 | $7.96 |
| 233289 | 2024-08-31 | $19.14 | USPS Ground Advantage | 1 | 0.60 lbs | $7.15 | $4.02 | $3.13 |
| 233290 | 2024-09-03 | $16.07 | USPS Ground Advantage | 2 | 0.82 lbs | $8.09 | $7.17 | $0.92 |
| 233291 | 2024-09-02 | $13.01 | USPS Ground Advantage | 1 | 0.05 lbs | $6.02 | $4.02 | $2.00 |
| 233292 | 2024-09-04 | $15.85 | USPS Ground Advantage | 1 | 0.06 lbs | $5.86 | $4.36 | $1.50 |
| 233293 | 2024-09-04 | $9.85 | USPS Ground Advantage | 1 | 0.05 lbs | $4.86 | $4.36 | $0.50 |
| 233294 | 2024-09-06 | $16.37 | USPS Ground Advantage | 1 | 0.05 lbs | $4.86 | $4.36 | $0.50 |
| 233295 | 2024-09-05 | $17.85 | USPS Ground Advantage | 1 | 0.19 lbs | $4.86 | $4.36 | $0.50 |
| 233296 | 2024-09-05 | $11.48 | USPS Ground Advantage | 1 | 0.18 lbs | $4.69 | $4.19 | $0.50 |
| 233297 | 2024-09-06 | $11.25 | USPS Ground Advantage | 1 | 0.18 lbs | $4.46 | $4.38 | $0.08 |
| 233298 | 2024-09-08 | $12.25 | USPS Ground Advantage | 1 | 0.07 lbs | $4.76 | $4.11 | $0.65 |
| 233299 | 2024-09-08 | $9.25 | USPS Ground Advantage | 1 | 0.03 lbs | $4.76 | $4.11 | $0.65 |
| 233300 | 2024-09-07 | $46.19 | USPS Ground Advantage | 3 | 0.56 lbs | $5.72 | $5.07 | $0.65 |
| 233301 | 2024-09-07 | $10.23 | USPS Ground Advantage | 1 | 0.06 lbs | $4.84 | $4.19 | $0.65 |
| 233302 | 2024-09-06 | $9.50 | USPS Ground Advantage | 1 | 0.03 lbs | $5.01 | $4.36 | $0.65 |
| 233303 | 2024-09-06 | $33.50 | USPS Priority Mail | 1 | 20.00 lbs | $10.51 | $17.10 | $-6.59 |
| 233304 | 2024-09-06 | $23.04 | USPS Ground Advantage | 1 | 0.45 lbs | $5.05 | $4.55 | $0.50 |
| 233305 | 2024-09-09 | $32.90 | USPS Ground Advantage | 1 | 0.90 lbs | $7.31 | $6.66 | $0.65 |
| 233306 | 2024-09-09 | $13.13 | USPS Ground Advantage | 1 | 0.05 lbs | $4.84 | $4.19 | $0.65 |
| 233307 | 2024-09-10 | $11.60 | USPS Ground Advantage | 1 | 0.04 lbs | $4.61 | $3.96 | $0.65 |
| 233308 | 2024-09-12 | $29.83 | USPS Ground Advantage | 1 | 0.03 lbs | $4.84 | $4.19 | $0.65 |
| 233309 | 2024-09-12 | $12.83 | USPS Ground Advantage | 1 | 0.21 lbs | $4.84 | $4.19 | $0.65 |
| 233310 | 2024-09-13 | $71.72 | USPS Ground Advantage | 2 | 0.88 lbs | $6.74 | $7.43 | $-0.69 |
| 233311 | 2024-09-13 | $43.23 | USPS Ground Advantage | 1 | 0.85 lbs | $6.88 | $6.79 | $0.09 |
| 233312 | 2024-09-14 | $13.16 | USPS Ground Advantage | 1 | 0.21 lbs | $4.67 | $4.02 | $0.65 |
| 233313 | 2024-09-15 | $11.99 | USPS Ground Advantage | 2 | 1.20 lbs | $11.20 | $7.32 | $3.88 |
| 233315 | 2024-09-15 | $51.88 | USPS Ground Advantage | 8 | 1.54 lbs | $37.91 | $6.23 | $31.68 |
| 233316 | 2024-09-15 | $26.21 | USPS Priority Mail | 1 | 1.19 lbs | $11.22 | $10.57 | $0.65 |
| 233320 | 2024-09-15 | $20.80 | USPS Ground Advantage | 1 | 0.16 lbs | $4.61 | $4.38 | $0.23 |
| 233321 | 2024-09-15 | $14.00 | USPS Ground Advantage | 1 | 0.08 lbs | $5.01 | $4.36 | $0.65 |
| 233322 | 2024-09-15 | $13.10 | USPS Ground Advantage | 1 | 0.05 lbs | $4.61 | $3.96 | $0.65 |
| 233323 | 2024-09-15 | $17.51 | USPS Ground Advantage | 1 | 0.05 lbs | $4.52 | $4.43 | $0.09 |
| 233324 | 2024-09-14 | $8.98 | USPS Ground Advantage | 1 | 0.06 lbs | $4.67 | $4.02 | $0.65 |
| 233325 | 2024-09-14 | $8.98 | USPS Ground Advantage | 1 | 0.23 lbs | $4.67 | $4.43 | $0.24 |
| 233326 | 2024-09-17 | $20.62 | USPS Ground Advantage | 1 | 0.30 lbs | $5.33 | $4.68 | $0.65 |
| 233327 | 2024-09-16 | $35.27 | USPS Ground Advantage | 1 | 0.40 lbs | $5.08 | $5.15 | $-0.07 |
| 233328 | 2024-09-16 | $17.52 | USPS Ground Advantage | 1 | 0.40 lbs | $5.33 | $5.62 | $-0.29 |
| 233329 | 2024-09-16 | $15.32 | USPS Ground Advantage | 1 | 0.29 lbs | $5.33 | $5.62 | $-0.29 |
| 233330 | 2024-09-17 | $14.33 | USPS Ground Advantage | 1 | 0.19 lbs | $4.84 | $4.19 | $0.65 |
| 233331 | 2024-09-17 | $35.30 | USPS Ground Advantage | 1 | 0.85 lbs | $7.31 | $6.66 | $0.65 |
| 233333 | 2024-09-18 | $14.63 | USPS Ground Advantage | 1 | 0.06 lbs | $4.84 | $4.19 | $0.65 |
| 233334 | 2024-09-18 | $17.64 | USPS Ground Advantage | 1 | 0.60 lbs | $5.65 | $3.86 | $1.79 |
| 233335 | 2024-09-18 | $10.62 | USPS Ground Advantage | 1 | 0.04 lbs | $4.76 | $4.11 | $0.65 |
| 233336 | 2024-09-19 | $18.57 | USPS Ground Advantage | 1 | 0.30 lbs | $5.08 | $4.43 | $0.65 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |