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 |
|---|---|---|---|---|---|---|---|---|
| 214265 | 2020-08-05 | $4.84 | First-Class Mail Stamped Letter | 1 | 0.03 lbs | $3.35 | $3.05 | $0.30 |
| 214269 | 2020-08-05 | $44.96 | Priority Mail 2-Day | 1 | 1.44 lbs | $8.97 | $7.75 | $1.22 |
| 214270 | 2020-08-06 | $23.89 | USPSPriority | 1 | 1.10 lbs | $12.24 | $9.98 | $2.26 |
| 214271 | 2020-08-05 | $37.85 | Priority Mail 2-Day Small Flat Rate Box | 2 | 0.19 lbs | $8.50 | $7.65 | $0.85 |
| 214272 | 2020-08-06 | $79.46 | Priority Mail 3-Day | 1 | 3.60 lbs | $21.86 | $21.01 | $0.85 |
| 214275 | 2020-08-06 | $91.06 | Priority Mail | 3 | 2.22 lbs | $16.59 | $15.74 | $0.85 |
| 214277 | 2020-08-06 | $5.83 | First-Class Mail Stamped Letter | 2 | 0.04 lbs | $3.35 | $3.05 | $0.30 |
| 214279 | 2020-08-06 | $36.31 | Priority Mail 2-Day | 1 | 2.30 lbs | $16.59 | $15.74 | $0.85 |
| 214280 | 2020-08-06 | $9.61 | USPSFirstClass | 1 | 0.05 lbs | $4.42 | $3.18 | $1.24 |
| 214281 | 2020-08-06 | $8.34 | First-Class Mail Stamped Letter | 1 | 0.07 lbs | $3.35 | $3.18 | $0.17 |
| 214282 | 2020-08-06 | $54.02 | Priority Mail 3-Day Medium Flat Rate Box | 3 | 2.40 lbs | $14.45 | $7.75 | $6.70 |
| 214283 | 2020-08-06 | $37.50 | USPSFirstClass | 1 | 0.64 lbs | $7.05 | $4.32 | $2.73 |
| 214284 | 2020-08-06 | $10.28 | USPSFirstClass | 1 | 0.05 lbs | $4.31 | $3.05 | $1.26 |
| 214287 | 2020-08-05 | $48.13 | Ground | 9 | 0.47 lbs | $25.72 | $3.31 | $22.41 |
| 214290 | 2020-08-06 | $22.04 | Priority Mail 3-Day | 1 | 0.40 lbs | $8.65 | $7.80 | $0.85 |
| 214291 | 2020-08-06 | $5.18 | First-Class Mail Stamped Letter | 2 | 0.02 lbs | $3.20 | $3.18 | $0.02 |
| 214293 | 2020-08-07 | $7.48 | USPSFirstClass | 1 | 0.06 lbs | $4.09 | $2.84 | $1.25 |
| 214297 | 2020-08-06 | $56.64 | Priority Mail 2-Day | 2 | 2.10 lbs | $9.44 | $8.21 | $1.23 |
| 214301 | 2020-08-07 | $104.44 | Priority Mail 2-Day Medium Flat Rate Box | 1 | 8.00 lbs | $14.45 | $11.18 | $3.27 |
| 214302 | 2020-08-07 | $7.89 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.50 | $3.05 | $0.45 |
| 214304 | 2020-08-07 | $16.30 | USPSFirstClass | 1 | 0.35 lbs | $5.25 | $4.08 | $1.17 |
| 214305 | 2020-08-07 | $57.02 | Priority Mail 2-Day Small Flat Rate Box | 2 | 1.02 lbs | $8.50 | $7.65 | $0.85 |
| 214306 | 2020-08-07 | $88.50 | Priority Mail 2-Day Flat Rate Envelope | 5 | 1.25 lbs | $8.00 | $7.65 | $0.35 |
| 214307 | 2020-08-07 | $12.66 | USPSFirstClass | 1 | 0.34 lbs | $5.14 | $4.18 | $0.96 |
| 214309 | 2020-08-07 | $61.62 | Priority Mail 3-Day Flat Rate Envelope | 2 | 2.55 lbs | $8.00 | $7.75 | $0.25 |
| 214310 | 2020-08-07 | $16.91 | Priority Mail 3-Day Flat Rate Envelope | 9 | 0.87 lbs | $8.00 | $8.42 | $-0.42 |
| 214313 | 2020-08-07 | $23.71 | Priority Mail 3-Day | 3 | 1.05 lbs | $12.04 | $11.13 | $0.91 |
| 214314 | 2020-08-07 | $33.63 | Priority Mail 3-Day | 1 | 0.95 lbs | $10.84 | $9.99 | $0.85 |
| 214315 | 2020-08-07 | $35.74 | USPSFirstClass | 3 | 0.30 lbs | $5.17 | $3.25 | $1.92 |
| 214319 | 2020-08-07 | $9.11 | First-Class Package Service | 2 | 0.29 lbs | $3.64 | $4.18 | $-0.54 |
| 214322 | 2020-08-07 | $8.99 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.50 | $3.18 | $0.32 |
| 214323 | 2020-08-08 | $45.69 | USPSFirstClass | 1 | 0.45 lbs | $6.70 | $3.31 | $3.39 |
| 214324 | 2020-08-07 | $19.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 214328 | 2020-08-08 | $72.99 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.16 lbs | $8.00 | $7.65 | $0.35 |
| 214330 | 2020-08-08 | $25.51 | Priority Mail 2-Day | 3 | 1.05 lbs | $10.84 | $9.98 | $0.86 |
| 214331 | 2020-08-08 | $62.11 | First-Class Package Service | 2 | 0.50 lbs | $4.53 | $4.08 | $0.45 |
| 214332 | 2020-08-08 | $18.92 | Priority Mail 1-Day | 3 | 0.60 lbs | $7.87 | $7.02 | $0.85 |
| 214333 | 2020-08-08 | $16.68 | USPSFirstClass | 2 | 0.10 lbs | $4.18 | $2.78 | $1.40 |
| 214334 | 2020-08-08 | $26.29 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 214335 | 2020-08-08 | $114.44 | Priority Mail 2-Day Medium Flat Rate Box | 1 | 8.00 lbs | $14.45 | $7.75 | $6.70 |
| 214336 | 2020-08-08 | $136.62 | Ground | 1 | 3.00 lbs | $36.63 | $26.54 | $10.09 |
| 214337 | 2020-08-08 | $26.95 | Priority Mail 2-Day Flat Rate Envelope | 5 | 0.89 lbs | $8.00 | $7.65 | $0.35 |
| 214339 | 2020-08-08 | $18.99 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 214341 | 2020-08-08 | $7.48 | First-Class Mail Stamped Letter | 2 | 0.06 lbs | $3.50 | $2.84 | $0.66 |
| 214345 | 2020-08-08 | $36.89 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.25 lbs | $8.50 | $7.65 | $0.85 |
| 214348 | 2020-08-08 | $127.26 | Priority Mail 2-Day | 3 | 4.20 lbs | $11.49 | $7.75 | $3.74 |
| 214349 | 2020-08-08 | $19.79 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 214350 | 2020-08-09 | $7.14 | USPSFirstClass | 1 | 0.03 lbs | $4.15 | $2.93 | $1.22 |
| 214352 | 2020-08-09 | $18.92 | USPSFirstClass | 2 | 0.07 lbs | $8.28 | $2.78 | $5.50 |
| 214353 | 2020-08-09 | $19.84 | USPSFirstClass | 1 | 0.40 lbs | $5.47 | $3.39 | $2.08 |
| 214354 | 2020-08-09 | $9.56 | USPSFirstClass | 1 | 0.05 lbs | $4.06 | $2.74 | $1.32 |
| 214355 | 2020-08-09 | $78.07 | Priority Mail 3-Day Medium Flat Rate Box | 1 | 2.85 lbs | $14.45 | $13.20 | $1.25 |
| 214356 | 2020-08-09 | $83.81 | Priority Mail 2-Day Padded Flat Rate Envelope | 3 | 2.64 lbs | $8.60 | $7.65 | $0.95 |
| 214358 | 2020-08-09 | $11.99 | USPSFirstClass | 3 | 0.30 lbs | $4.82 | $2.78 | $2.04 |
| 214359 | 2020-08-09 | $4.84 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.78 | $0.57 |
| 214361 | 2020-08-09 | $10.06 | First-Class Mail Stamped Letter | 3 | 0.12 lbs | $3.50 | $3.21 | $0.29 |
| 214362 | 2020-08-09 | $19.37 | USPSFirstClass | 2 | 0.60 lbs | $5.79 | $5.27 | $0.52 |
| 214364 | 2020-08-09 | $49.53 | USPSFirstClass | 1 | 0.45 lbs | $6.65 | $4.00 | $2.65 |
| 214365 | 2020-08-09 | $18.95 | Priority Mail 3-Day | 2 | 0.66 lbs | $8.97 | $8.12 | $0.85 |
| 214366 | 2020-08-09 | $8.54 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.84 | $0.51 |
| 214367 | 2020-08-09 | $15.95 | USPSFirstClass | 1 | 0.20 lbs | $4.51 | $3.39 | $1.12 |
| 214368 | 2020-08-10 | $13.18 | USPSFirstClass | 3 | 0.18 lbs | $4.04 | $3.25 | $0.79 |
| 214369 | 2020-08-10 | $23.23 | USPSFirstClass | 2 | 0.16 lbs | $4.34 | $2.78 | $1.56 |
| 214372 | 2020-08-09 | $33.54 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.57 lbs | $8.50 | $7.65 | $0.85 |
| 214375 | 2020-08-09 | $35.98 | First-Class Package Service | 1 | 0.39 lbs | $5.99 | $3.52 | $2.47 |
| 214376 | 2020-08-09 | $24.04 | Priority Mail 2-Day Medium Flat Rate Box | 1 | 0.19 lbs | $14.05 | $7.56 | $6.49 |
| 214378 | 2020-08-09 | $10.99 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.01 lbs | $8.50 | $7.65 | $0.85 |
| 214384 | 2020-08-10 | $27.69 | USPSFirstClass | 6 | 0.06 lbs | $5.07 | $3.05 | $2.02 |
| 214385 | 2020-08-10 | $34.25 | USPSFirstClass | 1 | 0.60 lbs | $6.82 | $5.27 | $1.55 |
| 214389 | 2020-08-10 | $73.45 | Priority Mail 2-Day Small Flat Rate Box | 5 | 4.29 lbs | $8.50 | $7.65 | $0.85 |
| 214392 | 2020-08-10 | $23.23 | First-Class Package Service | 2 | 0.70 lbs | $5.95 | $4.46 | $1.49 |
| 214393 | 2020-08-10 | $36.52 | Priority Mail 2-Day | 2 | 1.61 lbs | $12.04 | $11.18 | $0.86 |
| 214395 | 2020-08-10 | $6.48 | USPSFirstClass | 1 | 0.10 lbs | $3.92 | $2.74 | $1.18 |
| 214397 | 2020-08-10 | $23.62 | First-Class Package Service | 1 | 0.60 lbs | $4.33 | $5.27 | $-0.94 |
| 214400 | 2020-08-10 | $25.21 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.00 lbs | $8.50 | $7.65 | $0.85 |
| 214401 | 2020-08-10 | $7.51 | USPSFirstClass | 1 | 0.07 lbs | $4.14 | $3.39 | $0.75 |
| 214402 | 2020-08-10 | $18.60 | USPSFirstClass | 1 | 0.25 lbs | $4.54 | $3.25 | $1.29 |
| 214404 | 2020-08-10 | $11.56 | USPSFirstClass | 2 | 0.06 lbs | $4.14 | $2.84 | $1.30 |
| 214405 | 2020-08-10 | $80.78 | Priority Mail 3-Day Flat Rate Envelope | 2 | 2.40 lbs | $8.00 | $7.75 | $0.25 |
| 214408 | 2020-08-10 | $86.48 | Priority Mail 2-Day Small Flat Rate Box | 2 | 19.52 lbs | $8.50 | $7.65 | $0.85 |
| 214409 | 2020-08-10 | $24.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.45 lbs | $8.00 | $7.65 | $0.35 |
| 214411 | 2020-08-10 | $11.81 | First-Class Mail Stamped Letter | 4 | 0.08 lbs | $3.35 | $3.05 | $0.30 |
| 214414 | 2020-08-11 | $19.47 | USPSFirstClass | 2 | 0.07 lbs | $8.48 | $7.65 | $0.83 |
| 214415 | 2020-08-10 | $95.30 | Priority Mail 3-Day | 1 | 3.56 lbs | $19.31 | $16.06 | $3.25 |
| 214416 | 2020-08-10 | $12.09 | First-Class Package Service - Retail | 1 | 0.09 lbs | $6.90 | $2.78 | $4.12 |
| 214417 | 2020-08-10 | $12.97 | Priority Mail 3-Day Flat Rate Envelope | 3 | 0.22 lbs | $8.00 | $7.65 | $0.35 |
| 214418 | 2020-08-11 | $33.47 | First-Class Package Service | 6 | 0.61 lbs | $4.33 | $4.08 | $0.25 |
| 214419 | 2020-08-11 | $64.98 | First-Class Package International Service | 3 | 1.20 lbs | $31.53 | $23.28 | $8.25 |
| 214422 | 2020-08-11 | $300.68 | Priority Mail 2-Day | 1 | 14.40 lbs | $46.69 | $45.84 | $0.85 |
| 214424 | 2020-08-11 | $9.86 | USPSFirstClass | 1 | 0.05 lbs | $4.29 | $3.05 | $1.24 |
| 214425 | 2020-08-11 | $37.51 | USPSFirstClass | 1 | 0.70 lbs | $6.82 | $4.00 | $2.82 |
| 214427 | 2020-08-11 | $125.38 | Priority Mail 3-Day | 3 | 3.50 lbs | $15.01 | $14.56 | $0.45 |
| 214431 | 2020-08-11 | $8.69 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.50 | $2.93 | $0.57 |
| 214433 | 2020-08-11 | $30.99 | First-Class Package Service | 1 | 0.75 lbs | $5.37 | $4.00 | $1.37 |
| 214438 | 2020-08-11 | $24.59 | First-Class Package Service | 4 | 0.39 lbs | $4.57 | $3.52 | $1.05 |
| 214441 | 2020-08-11 | $7.06 | First-Class Mail Stamped Letter | 1 | 0.03 lbs | $3.35 | $2.78 | $0.57 |
| 214442 | 2020-08-11 | $7.31 | First-Class Mail Stamped Letter | 4 | 0.04 lbs | $3.35 | $2.84 | $0.51 |
| 214443 | 2020-08-11 | $39.50 | Priority Mail 2-Day | 11 | 0.90 lbs | $9.61 | $8.92 | $0.69 |
| 214444 | 2020-08-12 | $10.29 | USPSFirstClass | 1 | 0.16 lbs | $4.30 | $2.93 | $1.37 |
| 214446 | 2020-08-11 | $38.29 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.25 lbs | $8.50 | $7.65 | $0.85 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |