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 |
|---|---|---|---|---|---|---|---|---|
| 204489 | 2018-11-03 | $134.04 | Priority Mail 2-Day | 4 | 3.65 lbs | $21.88 | $12.45 | $9.43 |
| 204490 | 2018-11-03 | $46.96 | Priority Mail 3-Day Flat Rate Envelope | 4 | 1.26 lbs | $7.40 | $6.90 | $0.50 |
| 204492 | 2018-11-04 | $77.71 | Priority Mail 2-Day Large Flat Rate Box | 19 | 3.53 lbs | $18.50 | $12.45 | $6.05 |
| 204494 | 2018-11-04 | $62.58 | Priority Mail 2-Day Flat Rate Envelope | 2 | 2.00 lbs | $7.40 | $6.85 | $0.55 |
| 204495 | 2018-11-04 | $56.81 | Direct Link International | 3 | 1.11 lbs | $25.04 | $34.96 | $-9.92 |
| 204498 | 2018-11-04 | $37.21 | First-Class Package Service | 2 | 0.78 lbs | $5.43 | $4.10 | $1.33 |
| 204500 | 2018-11-04 | $6.20 | First-Class Package Service | 1 | 0.20 lbs | $3.71 | $3.05 | $0.66 |
| 204501 | 2018-11-04 | $25.69 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.90 lbs | $7.40 | $6.90 | $0.50 |
| 204502 | 2018-11-04 | $12.37 | First-Class Package Service | 5 | 0.06 lbs | $3.71 | $2.66 | $1.05 |
| 204503 | 2018-11-04 | $15.61 | First-Class Package Service | 3 | 0.25 lbs | $3.84 | $3.05 | $0.79 |
| 204504 | 2018-11-05 | $22.89 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.30 lbs | $7.90 | $6.85 | $1.05 |
| 204505 | 2018-11-05 | $10.18 | First-Class Package Service | 3 | 0.15 lbs | $3.71 | $2.66 | $1.05 |
| 204508 | 2018-11-05 | $34.36 | First-Class Package Service | 7 | 0.71 lbs | $5.43 | $4.10 | $1.33 |
| 204509 | 2018-11-05 | $23.81 | First-Class Package Service | 3 | 0.21 lbs | $3.84 | $3.05 | $0.79 |
| 204510 | 2018-11-05 | $22.13 | First-Class Package Service | 1 | 0.25 lbs | $3.84 | $3.05 | $0.79 |
| 204511 | 2018-11-05 | $10.70 | First-Class Package Service | 1 | 0.19 lbs | $3.71 | $2.66 | $1.05 |
| 204513 | 2018-11-05 | $5.69 | First-Class Package Service | 2 | 0.02 lbs | $3.71 | $2.66 | $1.05 |
| 204516 | 2018-11-05 | $61.62 | Priority Mail 3-Day Flat Rate Envelope | 2 | 2.00 lbs | $7.40 | $6.90 | $0.50 |
| 204517 | 2018-11-06 | $9.70 | First-Class Package Service | 1 | 0.13 lbs | $3.71 | $2.79 | $0.92 |
| 204518 | 2018-11-06 | $36.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.40 lbs | $7.90 | $6.85 | $1.05 |
| 204520 | 2018-11-07 | $24.09 | First-Class Package Service | 1 | 0.40 lbs | $4.10 | $3.34 | $0.76 |
| 204521 | 2018-11-07 | $11.70 | First-Class Package Service | 1 | 0.20 lbs | $3.71 | $3.18 | $0.53 |
| 204524 | 2018-11-07 | $11.70 | First-Class Package Service | 1 | 0.05 lbs | $3.71 | $2.66 | $1.05 |
| 204525 | 2018-11-07 | $48.10 | Priority Mail 2-Day | 1 | 2.20 lbs | $10.11 | $8.15 | $1.96 |
| 204527 | 2018-11-07 | $23.96 | First-Class Package Service | 1 | 0.60 lbs | $4.67 | $4.10 | $0.57 |
| 204528 | 2018-11-07 | $22.37 | Priority Mail 3-Day Flat Rate Envelope | 3 | 0.84 lbs | $7.40 | $6.90 | $0.50 |
| 204531 | 2018-11-07 | $12.63 | First-Class Package Service | 8 | 0.12 lbs | $3.71 | $2.66 | $1.05 |
| 204532 | 2018-11-08 | $5.20 | First-Class Package Service | 1 | 0.01 lbs | $3.71 | $2.66 | $1.05 |
| 204541 | 2018-11-08 | $74.97 | Priority Mail 2-Day | 3 | 3.97 lbs | $17.00 | $15.67 | $1.33 |
| 204542 | 2018-11-08 | $58.52 | Priority Mail 1-Day Flat Rate Envelope | 2 | 1.60 lbs | $7.40 | $6.85 | $0.55 |
| 204543 | 2018-11-08 | $51.15 | Direct Link International | 15 | 2.49 lbs | $26.69 | $43.42 | $-16.73 |
| 204544 | 2018-11-08 | $51.84 | Direct Link International | 16 | 2.51 lbs | $26.18 | $42.40 | $-16.22 |
| 204545 | 2018-11-08 | $15.76 | First-Class Package Service | 1 | 0.30 lbs | $3.97 | $3.05 | $0.92 |
| 204546 | 2018-11-08 | $6.60 | First-Class Package Service | 1 | 0.03 lbs | $3.71 | $2.66 | $1.05 |
| 204547 | 2018-11-08 | $10.29 | First-Class Package Service | 1 | 0.10 lbs | $3.71 | $2.66 | $1.05 |
| 204548 | 2018-11-09 | $16.61 | First-Class Package Service | 5 | 0.13 lbs | $3.71 | $2.66 | $1.05 |
| 204551 | 2018-11-09 | $17.79 | Priority Mail 2-Day | 1 | 0.95 lbs | $9.00 | $7.91 | $1.09 |
| 204553 | 2018-11-09 | $17.69 | First-Class Package Service | 2 | 0.12 lbs | $3.71 | $2.66 | $1.05 |
| 204554 | 2018-11-09 | $30.64 | First-Class Package Service | 7 | 0.16 lbs | $3.71 | $3.05 | $0.66 |
| 204555 | 2018-11-09 | $30.22 | Priority Mail 3-Day | 10 | 2.00 lbs | $9.32 | $7.40 | $1.92 |
| 204556 | 2018-11-09 | $31.80 | First-Class Package Service | 2 | 0.90 lbs | $9.42 | $6.85 | $2.57 |
| 204558 | 2018-11-09 | $27.38 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.26 lbs | $7.40 | $6.85 | $0.55 |
| 204559 | 2018-11-10 | $38.58 | First-Class Package Service | 9 | 0.58 lbs | $4.87 | $3.82 | $1.05 |
| 204560 | 2018-11-10 | $24.38 | First-Class Package Service | 1 | 0.48 lbs | $4.39 | $3.34 | $1.05 |
| 204563 | 2018-11-10 | $45.29 | First-Class Package International Service | 1 | 0.30 lbs | $21.30 | $22.33 | $-1.03 |
| 204564 | 2018-11-10 | $15.58 | First-Class Package Service | 13 | 0.14 lbs | $3.71 | $2.66 | $1.05 |
| 204565 | 2018-11-10 | $43.57 | Priority Mail 2-Day Flat Rate Envelope | 3 | 1.37 lbs | $7.40 | $6.85 | $0.55 |
| 204570 | 2018-11-10 | $14.89 | First-Class Package Service | 1 | 0.40 lbs | $4.10 | $3.34 | $0.76 |
| 204572 | 2018-11-11 | $8.70 | First-Class Package Service | 1 | 0.10 lbs | $3.71 | $2.66 | $1.05 |
| 204574 | 2018-11-11 | $23.96 | First-Class Package Service | 1 | 0.35 lbs | $3.97 | $3.18 | $0.79 |
| 204575 | 2018-11-11 | $81.36 | Priority Mail 3-Day | 6 | 2.15 lbs | $9.32 | $7.40 | $1.92 |
| 204576 | 2018-11-11 | $17.31 | Priority Mail 2-Day | 4 | 0.74 lbs | $8.35 | $7.28 | $1.07 |
| 204577 | 2018-11-11 | $9.69 | First-Class Package Service | 2 | 0.10 lbs | $3.71 | $2.66 | $1.05 |
| 204578 | 2018-11-11 | $15.25 | First-Class Package Service | 4 | 0.26 lbs | $5.79 | $3.18 | $2.61 |
| 204579 | 2018-11-11 | $31.58 | Priority Mail 3-Day | 2 | 1.90 lbs | $14.00 | $12.76 | $1.24 |
| 204581 | 2018-11-11 | $65.01 | Ground | 13 | 5.46 lbs | $20.64 | $18.91 | $1.73 |
| 204582 | 2018-11-11 | $9.70 | First-Class Package Service | 1 | 0.19 lbs | $3.71 | $2.66 | $1.05 |
| 204583 | 2018-11-11 | $66.27 | Priority Mail 2-Day | 4 | 1.76 lbs | $10.11 | $8.98 | $1.13 |
| 204584 | 2018-11-11 | $42.17 | First-Class Package Service | 2 | 0.85 lbs | $5.79 | $6.90 | $-1.11 |
| 204586 | 2018-11-11 | $14.55 | First-Class Package Service | 4 | 0.76 lbs | $5.79 | $4.94 | $0.85 |
| 204587 | 2018-11-12 | $25.46 | First-Class Package Service | 4 | 0.58 lbs | $4.55 | $3.82 | $0.73 |
| 204588 | 2018-11-12 | $337.22 | Priority Mail International | 20 | 17.73 lbs | $105.17 | $92.72 | $12.45 |
| 204589 | 2018-11-12 | $8.01 | First-Class Mail Large Envelope | 2 | 0.34 lbs | $4.03 | $3.50 | $0.53 |
| 204590 | 2018-11-12 | $60.25 | Priority Mail 2-Day | 7 | 1.81 lbs | $9.32 | $8.22 | $1.10 |
| 204591 | 2018-11-12 | $8.70 | First-Class Package Service | 1 | 0.10 lbs | $3.71 | $2.66 | $1.05 |
| 204592 | 2018-11-12 | $45.79 | Priority Mail 2-Day | 1 | 1.20 lbs | $9.00 | $7.91 | $1.09 |
| 204595 | 2018-11-12 | $145.48 | Priority Mail 3-Day Medium Flat Rate Box | 7 | 6.40 lbs | $13.85 | $12.45 | $1.40 |
| 204596 | 2018-11-12 | $46.49 | Priority Mail 2-Day | 2 | 1.65 lbs | $10.11 | $8.98 | $1.13 |
| 204597 | 2018-11-13 | $40.99 | Priority Mail 3-Day | 1 | 0.75 lbs | $9.00 | $7.91 | $1.09 |
| 204598 | 2018-11-13 | $15.76 | First-Class Package Service | 1 | 0.30 lbs | $3.97 | $3.05 | $0.92 |
| 204601 | 2018-11-13 | $16.95 | First-Class Package Service | 2 | 0.30 lbs | $3.97 | $2.79 | $1.18 |
| 204603 | 2018-11-14 | $15.39 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.20 lbs | $7.40 | $6.85 | $0.55 |
| 204606 | 2018-11-14 | $92.44 | Direct Link International | 5 | 2.75 lbs | $30.14 | $8.43 | $21.71 |
| 204610 | 2018-11-14 | $51.99 | Priority Mail 2-Day Small Flat Rate Box | 11 | 1.40 lbs | $7.90 | $6.85 | $1.05 |
| 204612 | 2018-11-14 | $14.60 | First-Class Package Service | 11 | 0.12 lbs | $3.71 | $2.66 | $1.05 |
| 204614 | 2018-11-15 | $36.57 | Priority Mail 3-Day | 8 | 0.34 lbs | $11.65 | $7.53 | $4.12 |
| 204616 | 2018-11-15 | $37.69 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.30 lbs | $7.90 | $6.85 | $1.05 |
| 204617 | 2018-11-16 | $6.70 | First-Class Package Service | 1 | 0.05 lbs | $3.71 | $2.66 | $1.05 |
| 204618 | 2018-11-16 | $45.35 | Priority Mail 2-Day Flat Rate Envelope | 5 | 0.69 lbs | $7.40 | $6.90 | $0.50 |
| 204620 | 2018-11-16 | $29.98 | First-Class Package Service | 5 | 0.64 lbs | $5.23 | $4.38 | $0.85 |
| 204621 | 2018-11-16 | $212.63 | Ground | 4 | 18.72 lbs | $37.76 | $33.75 | $4.01 |
| 204623 | 2018-11-16 | $48.69 | Priority Mail 2-Day | 4 | 0.63 lbs | $7.95 | $6.35 | $1.60 |
| 204624 | 2018-11-17 | $52.58 | Priority Mail 2-Day | 3 | 1.80 lbs | $13.01 | $9.47 | $3.54 |
| 204625 | 2018-11-17 | $70.43 | Priority Mail 3-Day Medium Flat Rate Box | 7 | 2.34 lbs | $13.85 | $10.80 | $3.05 |
| 204626 | 2018-11-17 | $7.11 | First-Class Package Service | 1 | 0.03 lbs | $3.71 | $2.66 | $1.05 |
| 204627 | 2018-11-17 | $23.88 | Priority Mail 3-Day Flat Rate Envelope | 2 | 0.35 lbs | $7.40 | $6.85 | $0.55 |
| 204629 | 2018-11-18 | $91.22 | First-Class Package International Service | 4 | 1.80 lbs | $41.96 | $33.96 | $8.00 |
| 204630 | 2018-11-18 | $94.64 | Priority Mail 2-Day | 5 | 3.20 lbs | $16.92 | $15.59 | $1.33 |
| 204632 | 2018-11-18 | $19.69 | First-Class Package Service | 2 | 0.10 lbs | $3.71 | $2.66 | $1.05 |
| 204633 | 2018-11-18 | $22.32 | First-Class Mail Large Envelope | 1 | 0.40 lbs | $4.03 | $3.34 | $0.69 |
| 204637 | 2018-11-18 | $17.79 | Priority Mail 2-Day | 1 | 0.95 lbs | $9.00 | $7.91 | $1.09 |
| 204639 | 2018-11-18 | $12.53 | First-Class Package Service | 7 | 0.38 lbs | $4.10 | $3.34 | $0.76 |
| 204640 | 2018-11-19 | $55.75 | Priority Mail 2-Day Medium Flat Rate Box | 10 | 2.26 lbs | $13.85 | $10.80 | $3.05 |
| 204641 | 2018-11-19 | $42.84 | Priority Mail 3-Day | 7 | 0.52 lbs | $13.01 | $11.80 | $1.21 |
| 204643 | 2018-11-19 | $6.65 | First-Class Package Service | 6 | 0.06 lbs | $3.71 | $2.66 | $1.05 |
| 204644 | 2018-11-19 | $14.76 | First-Class Package Service | 1 | 0.30 lbs | $3.97 | $3.18 | $0.79 |
| 204645 | 2018-11-19 | $41.68 | Priority Mail 2-Day Padded Flat Rate Envelope | 27 | 1.16 lbs | $7.95 | $6.90 | $1.05 |
| 204646 | 2018-11-19 | $80.72 | Priority Mail 2-Day Medium Flat Rate Box | 3 | 2.39 lbs | $13.85 | $10.29 | $3.56 |
| 204647 | 2018-11-20 | $131.17 | Direct Link International | 17 | 4.47 lbs | $55.14 | $48.46 | $6.68 |
| 204648 | 2018-11-20 | $65.98 | Priority Mail 3-Day | 3 | 2.25 lbs | $13.01 | $9.47 | $3.54 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |