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 |
|---|---|---|---|---|---|---|---|---|
| 202452 | 2018-03-28 | $25.00 | First-Class Mail Large Envelope | 4 | 0.38 lbs | $4.24 | $3.18 | $1.06 |
| 202454 | 2018-03-29 | $94.62 | Priority Mail 3-Day Medium Flat Rate Box | 3 | 2.30 lbs | $13.85 | $10.29 | $3.56 |
| 202455 | 2018-03-29 | $37.30 | Priority Mail 2-Day Flat Rate Envelope | 10 | 0.34 lbs | $7.40 | $6.85 | $0.55 |
| 202458 | 2018-03-29 | $102.77 | First-Class Package International Service | 2 | 2.40 lbs | $28.99 | $23.99 | $5.00 |
| 202459 | 2018-03-29 | $16.49 | First-Class Package Service | 2 | 0.80 lbs | $5.51 | $4.94 | $0.57 |
| 202460 | 2018-03-29 | $19.06 | First-Class Package Service | 4 | 0.40 lbs | $4.10 | $2.66 | $1.44 |
| 202461 | 2018-03-29 | $9.19 | First-Class Package Service | 2 | 0.11 lbs | $3.71 | $2.66 | $1.05 |
| 202462 | 2018-03-29 | $15.68 | First-Class Package Service | 3 | 0.07 lbs | $3.71 | $2.66 | $1.05 |
| 202463 | 2018-03-29 | $24.34 | First-Class Package Service | 1 | 0.35 lbs | $4.35 | $3.34 | $1.01 |
| 202464 | 2018-03-29 | $3.97 | First-Class Package Service | 1 | 0.30 lbs | $3.97 | $2.92 | $1.05 |
| 202465 | 2018-03-30 | $7.20 | First-Class Package Service | 1 | 0.02 lbs | $3.71 | $2.66 | $1.05 |
| 202466 | 2018-03-30 | $12.59 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.05 lbs | $7.40 | $6.85 | $0.55 |
| 202467 | 2018-03-30 | $5.51 | First-Class Package Service | 1 | 0.05 lbs | $3.71 | $2.66 | $1.05 |
| 202469 | 2018-03-30 | $43.60 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.70 lbs | $7.40 | $6.90 | $0.50 |
| 202470 | 2018-03-30 | $24.89 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.85 lbs | $7.90 | $6.85 | $1.05 |
| 202475 | 2018-03-31 | $11.80 | First-Class Package Service | 11 | 0.56 lbs | $5.71 | $4.38 | $1.33 |
| 202477 | 2018-03-31 | $28.24 | First-Class Mail Large Envelope | 2 | 0.60 lbs | $4.66 | $34.08 | $-29.42 |
| 202478 | 2018-03-31 | $42.93 | Priority Mail 2-Day Padded Flat Rate Envelope | 2 | 1.38 lbs | $7.95 | $6.85 | $1.10 |
| 202480 | 2018-03-31 | $665.46 | Priority Mail International | 36 | 21.53 lbs | $169.28 | $113.62 | $55.66 |
| 202482 | 2018-03-31 | $15.02 | First-Class Mail Large Envelope | 1 | 0.40 lbs | $4.03 | $3.50 | $0.53 |
| 202484 | 2018-03-31 | $118.35 | Priority Mail 2-Day | 6 | 4.05 lbs | $8.26 | $7.19 | $1.07 |
| 202485 | 2018-03-31 | $24.22 | First-Class Package Service | 1 | 0.35 lbs | $4.23 | $3.18 | $1.05 |
| 202486 | 2018-03-31 | $150.85 | Priority Mail 2-Day Medium Flat Rate Box | 10 | 4.66 lbs | $13.85 | $10.29 | $3.56 |
| 202487 | 2018-03-31 | $14.38 | First-Class Package Service | 1 | 0.35 lbs | $4.39 | $3.82 | $0.57 |
| 202488 | 2018-03-31 | $37.09 | First-Class Package Service | 1 | 0.30 lbs | $4.10 | $3.18 | $0.92 |
| 202492 | 2018-04-01 | $28.52 | First-Class Mail Large Envelope | 4 | 0.63 lbs | $4.66 | $4.38 | $0.28 |
| 202494 | 2018-04-01 | $22.77 | First-Class Package Service | 7 | 0.20 lbs | $3.84 | $2.92 | $0.92 |
| 202496 | 2018-04-01 | $18.66 | First-Class Package Service | 5 | 0.17 lbs | $3.71 | $2.66 | $1.05 |
| 202497 | 2018-04-01 | $114.15 | Priority Mail 3-Day | 14 | 2.95 lbs | $11.19 | $10.03 | $1.16 |
| 202499 | 2018-04-01 | $17.37 | First-Class Package Service | 2 | 0.36 lbs | $4.39 | $3.66 | $0.73 |
| 202500 | 2018-04-01 | $5.70 | First-Class Package Service | 1 | 0.13 lbs | $3.71 | $2.79 | $0.92 |
| 202502 | 2018-04-02 | $56.52 | Priority Mail 2-Day | 3 | 0.85 lbs | $8.05 | $7.91 | $0.14 |
| 202503 | 2018-04-02 | $18.69 | Priority Mail 3-Day Small Flat Rate Box | 1 | 0.30 lbs | $7.90 | $6.85 | $1.05 |
| 202504 | 2018-04-02 | $47.75 | First-Class Package Service | 4 | 1.00 lbs | $5.79 | $6.85 | $-1.06 |
| 202505 | 2018-04-02 | $12.68 | First-Class Package Service | 3 | 0.09 lbs | $3.71 | $2.66 | $1.05 |
| 202506 | 2018-04-02 | $62.66 | Priority Mail 2-Day Flat Rate Envelope | 4 | 1.73 lbs | $7.40 | $6.85 | $0.55 |
| 202508 | 2018-04-02 | $73.50 | First-Class Package International Service | 1 | 2.20 lbs | $38.01 | $33.01 | $5.00 |
| 202509 | 2018-04-02 | $47.38 | Priority Mail 2-Day Small Flat Rate Box | 2 | 1.50 lbs | $7.90 | $6.85 | $1.05 |
| 202510 | 2018-04-02 | $26.18 | First-Class Package Service | 1 | 0.45 lbs | $4.19 | $3.34 | $0.85 |
| 202512 | 2018-04-03 | $15.01 | First-Class Package Service | 2 | 0.29 lbs | $4.23 | $3.18 | $1.05 |
| 202513 | 2018-04-03 | $203.68 | Ground | 7 | 15.25 lbs | $31.25 | $26.05 | $5.20 |
| 202514 | 2018-04-03 | $12.08 | First-Class Mail Large Envelope | 2 | 0.29 lbs | $3.61 | $2.66 | $0.95 |
| 202515 | 2018-04-03 | $161.91 | Priority Mail International | 1 | 8.55 lbs | $81.34 | $74.34 | $7.00 |
| 202517 | 2018-04-03 | $15.69 | First-Class Package Service | 2 | 0.03 lbs | $3.71 | $2.66 | $1.05 |
| 202518 | 2018-04-04 | $83.90 | Priority Mail 2-Day Small Flat Rate Box | 1 | 2.25 lbs | $7.90 | $6.85 | $1.05 |
| 202519 | 2018-04-04 | $14.18 | First-Class Package Service | 3 | 0.09 lbs | $3.71 | $2.66 | $1.05 |
| 202520 | 2018-04-04 | $78.39 | Direct Link International | 1 | 2.85 lbs | $18.60 | $33.56 | $-14.96 |
| 202521 | 2018-04-04 | $34.13 | Priority Mail 3-Day Flat Rate Envelope | 27 | 4.15 lbs | $7.40 | $6.85 | $0.55 |
| 202522 | 2018-04-04 | $196.24 | Ground | 5 | 13.62 lbs | $32.39 | $20.62 | $11.77 |
| 202526 | 2018-04-04 | $5.70 | First-Class Package Service | 1 | 0.01 lbs | $3.71 | $2.66 | $1.05 |
| 202527 | 2018-04-04 | $17.03 | First-Class Package Service | 7 | 0.23 lbs | $4.10 | $2.92 | $1.18 |
| 202528 | 2018-04-04 | $57.89 | Priority Mail 2-Day | 2 | 1.70 lbs | $10.11 | $8.98 | $1.13 |
| 202530 | 2018-04-04 | $22.44 | First-Class Package Service | 3 | 0.35 lbs | $3.97 | $3.18 | $0.79 |
| 202531 | 2018-04-04 | $76.99 | Priority Mail 2-Day | 4 | 2.79 lbs | $15.03 | $13.75 | $1.28 |
| 202532 | 2018-04-04 | $16.89 | First-Class Package Service | 8 | 0.26 lbs | $3.97 | $3.05 | $0.92 |
| 202533 | 2018-04-04 | $68.51 | Priority Mail 2-Day | 3 | 1.62 lbs | $11.14 | $6.85 | $4.29 |
| 202535 | 2018-04-05 | $104.06 | Priority Mail 2-Day | 3 | 2.90 lbs | $11.19 | $10.03 | $1.16 |
| 202537 | 2018-04-05 | $266.72 | Priority Mail International | 1 | 14.05 lbs | $96.73 | $216.49 | $-119.76 |
| 202538 | 2018-04-05 | $87.99 | First-Class Package International Service | 2 | 2.40 lbs | $38.01 | $33.01 | $5.00 |
| 202539 | 2018-04-05 | $75.11 | First-Class Package International Service | 2 | 1.50 lbs | $27.33 | $22.33 | $5.00 |
| 202540 | 2018-04-05 | $44.89 | Priority Mail 3-Day | 1 | 1.20 lbs | $8.10 | $7.03 | $1.07 |
| 202541 | 2018-04-05 | $34.37 | First-Class Mail Large Envelope | 10 | 0.68 lbs | $4.87 | $4.66 | $0.21 |
| 202542 | 2018-04-05 | $7.20 | First-Class Package Service | 1 | 0.03 lbs | $3.71 | $2.66 | $1.05 |
| 202543 | 2018-04-05 | $6.70 | First-Class Package Service | 1 | 0.02 lbs | $3.71 | $2.66 | $1.05 |
| 202545 | 2018-04-05 | $25.37 | Priority Mail 3-Day Flat Rate Envelope | 3 | 1.77 lbs | $7.40 | $6.85 | $0.55 |
| 202546 | 2018-04-05 | $37.39 | Priority Mail 3-Day Small Flat Rate Box | 1 | 0.95 lbs | $7.90 | $6.85 | $1.05 |
| 202548 | 2018-04-05 | $13.97 | First-Class Package Service | 4 | 0.14 lbs | $3.71 | $2.92 | $0.79 |
| 202551 | 2018-04-05 | $26.31 | International | 2 | 0.41 lbs | $4.03 | $6.85 | $-2.82 |
| 202552 | 2018-04-05 | $55.36 | Priority Mail 2-Day Flat Rate Envelope | 4 | 1.01 lbs | $7.40 | $6.85 | $0.55 |
| 202554 | 2018-04-06 | $101.72 | First-Class Package International Service | 3 | 1.95 lbs | $38.25 | $33.25 | $5.00 |
| 202559 | 2018-04-06 | $24.88 | International | 4 | 2.40 lbs | $9.32 | $10.80 | $-1.48 |
| 202560 | 2018-04-06 | $197.87 | Priority Mail 2-Day | 1 | 14.05 lbs | $27.88 | $27.52 | $0.36 |
| 202561 | 2018-04-06 | $70.88 | Priority Mail 2-Day | 3 | 2.00 lbs | $13.01 | $9.47 | $3.54 |
| 202563 | 2018-04-06 | $7.70 | First-Class Package Service | 1 | 0.10 lbs | $3.71 | $2.66 | $1.05 |
| 202566 | 2018-04-06 | $19.52 | First-Class Mail Large Envelope | 1 | 0.35 lbs | $4.03 | $3.18 | $0.85 |
| 202567 | 2018-04-06 | $32.15 | First-Class Mail Large Envelope | 2 | 0.70 lbs | $4.87 | $4.38 | $0.49 |
| 202570 | 2018-04-07 | $60.09 | Priority Mail 2-Day | 2 | 2.10 lbs | $10.11 | $8.98 | $1.13 |
| 202572 | 2018-04-07 | $53.59 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.65 lbs | $7.90 | $6.85 | $1.05 |
| 202573 | 2018-04-07 | $36.39 | Priority Mail 2-Day Flat Rate Envelope | 1 | 1.10 lbs | $7.40 | $6.85 | $0.55 |
| 202574 | 2018-04-07 | $53.78 | Priority Mail 3-Day Flat Rate Envelope | 12 | 1.32 lbs | $7.40 | $6.35 | $1.05 |
| 202575 | 2018-04-07 | $33.39 | First-Class Package Service | 4 | 0.25 lbs | $5.43 | $3.05 | $2.38 |
| 202576 | 2018-04-07 | $14.82 | First-Class Package Service | 1 | 0.37 lbs | $4.23 | $3.34 | $0.89 |
| 202577 | 2018-04-07 | $29.98 | Priority Mail 3-Day | 1 | 3.10 lbs | $11.19 | $8.15 | $3.04 |
| 202578 | 2018-04-07 | $48.47 | Priority Mail 2-Day Small Flat Rate Box | 3 | 1.45 lbs | $7.90 | $6.85 | $1.05 |
| 202579 | 2018-04-07 | $91.27 | Priority Mail 3-Day | 4 | 2.27 lbs | $10.11 | $8.15 | $1.96 |
| 202580 | 2018-04-07 | $31.78 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.07 lbs | $7.40 | $6.85 | $0.55 |
| 202581 | 2018-04-07 | $11.96 | First-Class Package Service | 1 | 0.20 lbs | $3.97 | $3.18 | $0.79 |
| 202582 | 2018-04-07 | $68.10 | Priority Mail 2-Day | 2 | 1.50 lbs | $10.32 | $9.19 | $1.13 |
| 202583 | 2018-04-07 | $11.70 | First-Class Package Service | 1 | 0.05 lbs | $3.71 | $2.66 | $1.05 |
| 202584 | 2018-04-08 | $82.40 | Priority Mail 2-Day | 3 | 2.70 lbs | $15.03 | $13.75 | $1.28 |
| 202585 | 2018-04-08 | $13.47 | First-Class Package Service | 4 | 0.63 lbs | $4.71 | $3.82 | $0.89 |
| 202587 | 2018-04-08 | $58.83 | Priority Mail 2-Day Padded Flat Rate Envelope | 2 | 1.73 lbs | $7.95 | $6.85 | $1.10 |
| 202593 | 2018-04-08 | $19.12 | First-Class Package Service | 9 | 0.13 lbs | $3.71 | $2.66 | $1.05 |
| 202594 | 2018-04-08 | $15.76 | First-Class Package Service | 1 | 0.30 lbs | $3.97 | $3.05 | $0.92 |
| 202597 | 2018-04-09 | $90.94 | First-Class Package International Service | 2 | 2.00 lbs | $38.96 | $33.96 | $5.00 |
| 202598 | 2018-04-09 | $24.02 | First-Class Mail Large Envelope | 1 | 0.35 lbs | $4.03 | $3.18 | $0.85 |
| 202599 | 2018-04-09 | $28.71 | First-Class Mail Large Envelope | 3 | 0.53 lbs | $4.24 | $3.66 | $0.58 |
| 202600 | 2018-04-09 | $24.39 | First-Class Mail Large Envelope | 3 | 0.49 lbs | $3.82 | $3.82 | $0.00 |
| 202602 | 2018-04-09 | $227.90 | Ground | 1 | 21.00 lbs | $34.71 | $29.51 | $5.20 |
| 202606 | 2018-04-09 | $679.08 | Priority Mail International | 16 | 23.68 lbs | $174.60 | $118.85 | $55.75 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |