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 |
|---|---|---|---|---|---|---|---|---|
| 213345 | 2020-07-03 | $24.81 | First-Class Package Service | 1 | 0.65 lbs | $5.52 | $5.27 | $0.25 |
| 213346 | 2020-07-03 | $42.87 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.75 lbs | $8.00 | $7.75 | $0.25 |
| 213347 | 2020-07-03 | $20.97 | First-Class Package Service | 2 | 0.46 lbs | $5.99 | $5.54 | $0.45 |
| 213348 | 2020-07-04 | $23.60 | Priority Mail 2-Day | 7 | 1.33 lbs | $8.97 | $8.12 | $0.85 |
| 213349 | 2020-07-04 | $13.13 | USPSFirstClass | 1 | 0.34 lbs | $5.34 | $4.46 | $0.88 |
| 213351 | 2020-07-04 | $68.25 | Priority Mail 2-Day Medium Flat Rate Box | 2 | 6.47 lbs | $14.45 | $13.20 | $1.25 |
| 213353 | 2020-07-04 | $94.45 | Priority Mail 2-Day Medium Flat Rate Box | 1 | 8.00 lbs | $14.45 | $10.42 | $4.03 |
| 213354 | 2020-07-04 | $14.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.02 lbs | $8.00 | $7.65 | $0.35 |
| 213357 | 2020-07-04 | $31.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 3.55 lbs | $8.00 | $7.75 | $0.25 |
| 213358 | 2020-07-04 | $21.99 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.00 lbs | $8.50 | $7.65 | $0.85 |
| 213359 | 2020-07-04 | $17.51 | First-Class Package Service | 2 | 0.40 lbs | $4.63 | $4.18 | $0.45 |
| 213360 | 2020-07-04 | $20.77 | USPSFirstClass | 2 | 0.68 lbs | $5.99 | $5.54 | $0.45 |
| 213364 | 2020-07-04 | $84.12 | Priority Mail 2-Day | 4 | 1.45 lbs | $9.61 | $8.76 | $0.85 |
| 213365 | 2020-07-04 | $33.43 | Priority Mail 2-Day Flat Rate Envelope | 7 | 1.04 lbs | $8.00 | $7.65 | $0.35 |
| 213366 | 2020-07-04 | $15.43 | First-Class Package Service | 2 | 0.37 lbs | $4.45 | $4.00 | $0.45 |
| 213369 | 2020-07-04 | $31.97 | Priority Mail 3-Day Flat Rate Envelope | 3 | 1.11 lbs | $8.00 | $7.65 | $0.35 |
| 213370 | 2020-07-05 | $12.25 | USPSFirstClass | 1 | 0.19 lbs | $4.30 | $2.93 | $1.37 |
| 213374 | 2020-07-04 | $8.61 | Priority Mail 3-Day Padded Flat Rate Envelope | 1 | 0.20 lbs | $8.60 | $7.75 | $0.85 |
| 213375 | 2020-07-05 | $6.69 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.20 | $3.05 | $0.15 |
| 213376 | 2020-07-05 | $11.24 | First-Class Mail Stamped Letter | 1 | 0.07 lbs | $3.35 | $3.18 | $0.17 |
| 213378 | 2020-07-05 | $21.05 | First-Class Package Service | 1 | 0.35 lbs | $3.56 | $3.31 | $0.25 |
| 213379 | 2020-07-05 | $8.50 | USPSFirstClass | 2 | 0.08 lbs | $4.30 | $3.18 | $1.12 |
| 213380 | 2020-07-05 | $14.97 | Priority Mail 2-Day Flat Rate Envelope | 3 | 0.04 lbs | $8.00 | $7.56 | $0.44 |
| 213381 | 2020-07-05 | $16.38 | USPSFirstClass | 1 | 0.05 lbs | $4.58 | $3.18 | $1.40 |
| 213382 | 2020-07-05 | $9.97 | First-Class Mail Stamped Letter | 3 | 0.11 lbs | $3.50 | $3.05 | $0.45 |
| 213384 | 2020-07-05 | $41.88 | Priority Mail 2-Day | 4 | 2.22 lbs | $9.92 | $9.07 | $0.85 |
| 213386 | 2020-07-05 | $23.96 | Priority Mail 2-Day Flat Rate Envelope | 4 | 0.72 lbs | $8.00 | $7.65 | $0.35 |
| 213387 | 2020-07-05 | $6.69 | First-Class Mail Stamped Letter | 1 | 0.03 lbs | $3.20 | $2.93 | $0.27 |
| 213388 | 2020-07-05 | $40.46 | Priority Mail 2-Day | 3 | 1.23 lbs | $11.39 | $10.53 | $0.86 |
| 213389 | 2020-07-05 | $12.30 | First-Class Package Service | 2 | 0.80 lbs | $5.52 | $5.27 | $0.25 |
| 213392 | 2020-07-05 | $33.86 | Priority Mail 2-Day Flat Rate Envelope | 4 | 0.39 lbs | $8.00 | $7.65 | $0.35 |
| 213393 | 2020-07-05 | $45.76 | Priority Mail 2-Day | 4 | 1.78 lbs | $13.00 | $10.42 | $2.58 |
| 213394 | 2020-07-06 | $12.34 | USPSFirstClass | 3 | 0.60 lbs | $5.59 | $5.40 | $0.19 |
| 213396 | 2020-07-05 | $37.28 | Priority Mail 3-Day Flat Rate Envelope | 2 | 0.55 lbs | $8.00 | $7.75 | $0.25 |
| 213398 | 2020-07-06 | $59.68 | Priority Mail 2-Day | 16 | 1.05 lbs | $12.04 | $11.18 | $0.86 |
| 213399 | 2020-07-06 | $20.15 | USPSFirstClass | 2 | 0.38 lbs | $5.10 | $2.84 | $2.26 |
| 213401 | 2020-07-06 | $11.43 | First-Class Package Service | 2 | 0.59 lbs | $5.95 | $4.46 | $1.49 |
| 213402 | 2020-07-06 | $55.49 | Priority Mail International Flat Rate Envelope | 1 | 0.15 lbs | $37.50 | $37.60 | $-0.10 |
| 213403 | 2020-07-06 | $19.65 | Priority Mail 2-Day Small Flat Rate Box | 5 | 0.23 lbs | $8.50 | $7.75 | $0.75 |
| 213404 | 2020-07-06 | $64.15 | Priority Mail 2-Day Flat Rate Envelope | 7 | 1.26 lbs | $8.00 | $7.75 | $0.25 |
| 213405 | 2020-07-06 | $24.89 | First-Class Package Service | 1 | 0.64 lbs | $5.29 | $3.93 | $1.36 |
| 213406 | 2020-07-06 | $12.18 | USPSFirstClass | 1 | 0.10 lbs | $4.40 | $3.18 | $1.22 |
| 213407 | 2020-07-06 | $198.88 | Priority Mail 1-Day | 10 | 13.48 lbs | $17.66 | $17.34 | $0.32 |
| 213408 | 2020-07-06 | $34.63 | Priority Mail 3-Day | 1 | 2.40 lbs | $13.00 | $14.16 | $-1.16 |
| 213409 | 2020-07-06 | $36.71 | Priority Mail 3-Day | 1 | 3.15 lbs | $9.92 | $8.21 | $1.71 |
| 213410 | 2020-07-06 | $18.78 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 213413 | 2020-07-06 | $45.11 | Priority Mail 2-Day Small Flat Rate Box | 3 | 1.51 lbs | $8.50 | $7.65 | $0.85 |
| 213414 | 2020-07-06 | $112.79 | Priority Mail 2-Day | 2 | 7.73 lbs | $12.34 | $7.75 | $4.59 |
| 213415 | 2020-07-06 | $51.49 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.50 | $7.65 | $0.85 |
| 213416 | 2020-07-06 | $38.29 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.50 | $7.65 | $0.85 |
| 213417 | 2020-07-07 | $5.58 | USPSFirstClass | 1 | 0.02 lbs | $4.25 | $3.18 | $1.07 |
| 213418 | 2020-07-07 | $26.39 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.00 | $7.75 | $0.25 |
| 213419 | 2020-07-07 | $22.94 | Priority Mail 2-Day Flat Rate Envelope | 6 | 0.24 lbs | $8.00 | $7.65 | $0.35 |
| 213420 | 2020-07-07 | $24.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.40 lbs | $8.00 | $7.65 | $0.35 |
| 213423 | 2020-07-07 | $5.76 | USPSFirstClass | 1 | 0.02 lbs | $4.27 | $3.18 | $1.09 |
| 213426 | 2020-07-07 | $5.93 | USPSFirstClass | 2 | 0.04 lbs | $3.95 | $3.25 | $0.70 |
| 213430 | 2020-07-07 | $223.31 | Ground Home Delivery | 1 | 21.00 lbs | $30.12 | $23.80 | $6.32 |
| 213435 | 2020-07-07 | $35.25 | Priority Mail 2-Day Flat Rate Envelope | 25 | 0.45 lbs | $8.00 | $7.65 | $0.35 |
| 213436 | 2020-07-07 | $221.89 | Ground | 1 | 21.00 lbs | $28.70 | $20.83 | $7.87 |
| 213438 | 2020-07-07 | $30.02 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.40 lbs | $8.00 | $7.65 | $0.35 |
| 213439 | 2020-07-07 | $6.19 | First-Class Mail Stamped Letter | 1 | 0.03 lbs | $3.20 | $3.05 | $0.15 |
| 213440 | 2020-07-07 | $218.36 | Priority Mail 1-Day | 18 | 5.87 lbs | $11.64 | $8.85 | $2.79 |
| 213441 | 2020-07-07 | $8.79 | USPSFirstClass | 2 | 0.02 lbs | $4.15 | $3.05 | $1.10 |
| 213442 | 2020-07-07 | $228.24 | Priority Mail 2-Day | 1 | 14.05 lbs | $35.25 | $30.03 | $5.22 |
| 213443 | 2020-07-07 | $60.79 | Ground | 1 | 1.61 lbs | $17.80 | $15.30 | $2.50 |
| 213444 | 2020-07-07 | $23.62 | First-Class Package Service | 1 | 0.60 lbs | $4.33 | $5.27 | $-0.94 |
| 213447 | 2020-07-08 | $11.76 | USPSFirstClass | 1 | 0.05 lbs | $4.29 | $2.78 | $1.51 |
| 213448 | 2020-07-08 | $9.67 | USPSFirstClass | 1 | 0.20 lbs | $4.20 | $3.25 | $0.95 |
| 213450 | 2020-07-08 | $5.84 | First-Class Mail Stamped Letter | 1 | 0.04 lbs | $3.35 | $2.84 | $0.51 |
| 213451 | 2020-07-08 | $31.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.00 | $7.75 | $0.25 |
| 213452 | 2020-07-08 | $139.75 | Ground | 5 | 4.50 lbs | $28.50 | $22.37 | $6.13 |
| 213454 | 2020-07-08 | $20.33 | First-Class Mail Stamped Letter | 6 | 0.10 lbs | $3.50 | $2.74 | $0.76 |
| 213455 | 2020-07-08 | $55.83 | Priority Mail 3-Day | 1 | 1.20 lbs | $10.84 | $9.99 | $0.85 |
| 213456 | 2020-07-08 | $47.12 | First-Class Package Service | 7 | 0.68 lbs | $5.79 | $4.32 | $1.47 |
| 213457 | 2020-07-08 | $18.92 | USPSFirstClass | 2 | 0.10 lbs | $8.28 | $7.65 | $0.63 |
| 213458 | 2020-07-08 | $6.99 | USPSFirstClass | 1 | 0.10 lbs | $4.12 | $3.05 | $1.07 |
| 213459 | 2020-07-08 | $71.18 | Priority Mail 2-Day | 2 | 2.00 lbs | $13.00 | $12.15 | $0.85 |
| 213461 | 2020-07-08 | $32.93 | First-Class Package Service | 2 | 0.70 lbs | $5.65 | $5.40 | $0.25 |
| 213464 | 2020-07-08 | $9.64 | First-Class Mail Stamped Letter | 1 | 0.18 lbs | $3.65 | $3.67 | $-0.02 |
| 213465 | 2020-07-08 | $33.56 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.50 | $7.65 | $0.85 |
| 213466 | 2020-07-08 | $29.68 | Priority Mail 2-Day Small Flat Rate Box | 2 | 0.74 lbs | $8.50 | $7.65 | $0.85 |
| 213468 | 2020-07-08 | $17.51 | First-Class Package Service | 1 | 0.68 lbs | $5.52 | $5.27 | $0.25 |
| 213469 | 2020-07-08 | $79.58 | Priority Mail 2-Day | 3 | 3.35 lbs | $11.18 | $9.53 | $1.65 |
| 213471 | 2020-07-08 | $96.62 | Priority Mail International Flat Rate Envelope | 4 | 1.15 lbs | $26.40 | $26.50 | $-0.10 |
| 213473 | 2020-07-09 | $10.64 | First-Class Mail Stamped Letter | 1 | 0.19 lbs | $3.65 | $2.78 | $0.87 |
| 213474 | 2020-07-09 | $53.35 | Priority Mail 2-Day Medium Flat Rate Box | 10 | 5.50 lbs | $14.45 | $13.20 | $1.25 |
| 213475 | 2020-07-09 | $27.29 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.00 | $7.65 | $0.35 |
| 213476 | 2020-07-09 | $18.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 213477 | 2020-07-09 | $77.17 | Ground | 5 | 2.60 lbs | $18.87 | $16.00 | $2.87 |
| 213478 | 2020-07-09 | $112.34 | Ground | 1 | 12.75 lbs | $34.00 | $32.36 | $1.64 |
| 213480 | 2020-07-09 | $46.60 | USPSFirstClass | 6 | 0.49 lbs | $10.37 | $5.70 | $4.67 |
| 213481 | 2020-07-09 | $57.65 | First-Class Package Service | 3 | 0.85 lbs | $5.72 | $7.65 | $-1.93 |
| 213482 | 2020-07-09 | $29.88 | Priority Mail 2-Day | 1 | 1.78 lbs | $10.39 | $7.75 | $2.64 |
| 213483 | 2020-07-09 | $21.49 | Priority Mail 2-Day Flat Rate Envelope | 1 | 1.00 lbs | $8.00 | $7.65 | $0.35 |
| 213484 | 2020-07-09 | $54.19 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.70 lbs | $8.50 | $7.65 | $0.85 |
| 213485 | 2020-07-09 | $25.34 | First-Class Package Service | 1 | 0.25 lbs | $4.71 | $4.46 | $0.25 |
| 213486 | 2020-07-09 | $19.95 | Priority Mail 2-Day | 2 | 0.72 lbs | $8.97 | $8.12 | $0.85 |
| 213487 | 2020-07-09 | $38.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.50 | $7.65 | $0.85 |
| 213488 | 2020-07-09 | $45.98 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.10 lbs | $8.00 | $7.65 | $0.35 |
| 213489 | 2020-07-10 | $9.55 | USPSFirstClass | 1 | 0.20 lbs | $4.15 | $3.25 | $0.90 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |