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 |
|---|---|---|---|---|---|---|---|---|
| 234573 | 2025-10-25 | $22.05 | USPS Ground Advantage | 1 | 0.03 lbs | $6.06 | $4.76 | $1.30 |
| 234574 | 2025-10-24 | $26.02 | USPS Ground Advantage | 1 | 0.35 lbs | $6.67 | $6.37 | $0.30 |
| 234575 | 2025-10-24 | $48.08 | USPS Ground Advantage | 4 | 0.46 lbs | $25.40 | $6.37 | $19.03 |
| 234576 | 2025-10-27 | $30.65 | USPS Ground Advantage | 1 | 0.90 lbs | $8.13 | $6.83 | $1.30 |
| 234577 | 2025-10-27 | $13.72 | USPS Ground Advantage | 1 | 0.05 lbs | $6.25 | $5.15 | $1.10 |
| 234578 | 2025-10-26 | $22.39 | USPS Ground Advantage | 1 | 0.45 lbs | $6.56 | $4.80 | $1.76 |
| 234579 | 2025-10-26 | $17.02 | USPS Ground Advantage | 2 | 0.90 lbs | $10.36 | $9.06 | $1.30 |
| 234580 | 2025-10-26 | $28.00 | USPS Ground Advantage | 1 | 0.22 lbs | $6.45 | $5.37 | $1.08 |
| 234581 | 2025-10-27 | $14.24 | USPS Ground Advantage | 1 | 0.05 lbs | $6.06 | $4.76 | $1.30 |
| 234583 | 2025-10-28 | $25.97 | USPS Ground Advantage | 1 | 0.35 lbs | $6.62 | $6.25 | $0.37 |
| 234584 | 2025-10-28 | $10.05 | USPS Ground Advantage | 1 | 0.45 lbs | $6.54 | $6.18 | $0.36 |
| 234585 | 2025-10-28 | $22.80 | USPS Ground Advantage | 5 | 0.75 lbs | $7.90 | $6.73 | $1.17 |
| 234586 | 2025-10-27 | $9.90 | USPS Ground Advantage | 1 | 0.05 lbs | $5.95 | $4.65 | $1.30 |
| 234589 | 2025-10-28 | $20.78 | USPS Ground Advantage | 3 | 1.20 lbs | $11.30 | $10.00 | $1.30 |
| 234592 | 2025-10-29 | $68.92 | Priority Mail | 1 | 1.19 lbs | $10.30 | $7.17 | $3.13 |
| 234593 | 2025-10-30 | $11.70 | USPS Ground Advantage | 1 | 0.06 lbs | $6.25 | $4.95 | $1.30 |
| 234594 | 2025-10-29 | $47.17 | USPS Ground Advantage | 5 | 1.60 lbs | $31.45 | $6.73 | $24.72 |
| 234595 | 2025-10-30 | $18.13 | USPS Ground Advantage | 2 | 0.18 lbs | $6.45 | $5.15 | $1.30 |
| 234596 | 2025-10-30 | $13.22 | USPS Ground Advantage | 1 | 0.05 lbs | $6.22 | $4.92 | $1.30 |
| 234597 | 2025-10-30 | $78.54 | USPS Ground Advantage | 1 | 1.85 lbs | $27.51 | $9.74 | $17.77 |
| 234598 | 2025-10-31 | $14.70 | USPS Ground Advantage | 1 | 0.15 lbs | $6.17 | $4.87 | $1.30 |
| 234599 | 2025-10-31 | $14.80 | USPS Ground Advantage | 1 | 0.05 lbs | $6.10 | $4.80 | $1.30 |
| 234601 | 2025-11-03 | $14.40 | USPS Ground Advantage | 1 | 0.05 lbs | $6.22 | $4.92 | $1.30 |
| 234602 | 2025-11-03 | $21.41 | USPS Ground Advantage | 3 | 0.15 lbs | $5.99 | $4.69 | $1.30 |
| 234603 | 2025-11-03 | $17.00 | USPS Ground Advantage | 1 | 0.05 lbs | $6.45 | $5.15 | $1.30 |
| 234604 | 2025-11-02 | $10.87 | USPS Ground Advantage | 1 | 0.05 lbs | $5.95 | $4.65 | $1.30 |
| 234605 | 2025-11-02 | $27.82 | USPS Ground Advantage | 1 | 1.78 lbs | $8.47 | $5.22 | $3.25 |
| 234606 | 2025-11-02 | $68.75 | USPS Ground Advantage | 3 | 1.38 lbs | $21.79 | $5.37 | $16.42 |
| 234607 | 2025-11-02 | $13.29 | USPS Ground Advantage | 1 | 0.08 lbs | $5.99 | $4.69 | $1.30 |
| 234608 | 2025-11-01 | $14.17 | USPS Ground Advantage | 1 | 0.05 lbs | $5.99 | $4.69 | $1.30 |
| 234609 | 2025-11-01 | $14.24 | USPS Ground Advantage | 1 | 0.05 lbs | $6.06 | $4.76 | $1.30 |
| 234610 | 2025-10-31 | $21.28 | USPS Ground Advantage | 1 | 0.15 lbs | $6.50 | $5.55 | $0.95 |
| 234611 | 2025-11-03 | $51.44 | USPS Ground Advantage | 1 | 1.27 lbs | $7.89 | $6.59 | $1.30 |
| 234612 | 2025-11-03 | $13.02 | USPS Ground Advantage | 1 | 0.10 lbs | $6.45 | $5.15 | $1.30 |
| 234613 | 2025-11-04 | $10.22 | USPS Ground Parcel or Priority Mail | 1 | 0.05 lbs | $9.35 | $4.65 | $4.70 |
| 234614 | 2025-11-05 | $12.11 | USPS Ground Advantage | 1 | 0.05 lbs | $6.22 | $4.92 | $1.30 |
| 234615 | 2025-11-05 | $25.73 | USPS Ground Advantage | 1 | 1.50 lbs | $10.69 | $9.74 | $0.95 |
| 234616 | 2025-11-06 | $29.07 | USPS Ground Advantage | 2 | 0.39 lbs | $6.67 | $5.37 | $1.30 |
| 234617 | 2025-11-07 | $45.03 | Priority Mail | 6 | 2.60 lbs | $19.69 | $13.17 | $6.52 |
| 234618 | 2025-11-07 | $16.66 | USPS Ground Advantage | 2 | 0.40 lbs | $5.94 | $4.99 | $0.95 |
| 234619 | 2025-11-06 | $19.58 | USPS Ground Advantage | 2 | 0.10 lbs | $12.20 | $4.80 | $7.40 |
| 234620 | 2025-11-08 | $30.45 | Priority Mail Flat Rate Envelope | 5 | 0.05 lbs | $11.50 | $9.10 | $2.40 |
| 234621 | 2025-11-10 | $14.61 | USPS Ground Advantage | 1 | 0.06 lbs | $5.99 | $4.69 | $1.30 |
| 234622 | 2025-11-10 | $17.36 | USPS Ground Advantage | 1 | 0.07 lbs | $6.10 | $4.80 | $1.30 |
| 234623 | 2025-11-10 | $48.78 | USPS Ground Advantage | 1 | 1.25 lbs | $9.89 | $8.59 | $1.30 |
| 234624 | 2025-11-09 | $14.30 | USPS Ground Advantage | 3 | 0.60 lbs | $7.67 | $6.37 | $1.30 |
| 234625 | 2025-11-09 | $28.71 | USPS Ground Advantage | 1 | 0.18 lbs | $5.84 | $4.91 | $0.93 |
| 234626 | 2025-11-08 | $21.05 | USPS Ground Advantage | 1 | 0.20 lbs | $6.10 | $5.26 | $0.84 |
| 234627 | 2025-11-08 | $26.28 | USPS Ground Advantage | 5 | 2.00 lbs | $11.38 | $10.08 | $1.30 |
| 234628 | 2025-11-08 | $11.16 | USPS Ground Advantage | 1 | 0.10 lbs | $6.10 | $5.00 | $1.10 |
| 234630 | 2025-11-08 | $12.36 | USPS Ground Advantage | 3 | 0.03 lbs | $6.45 | $5.15 | $1.30 |
| 234631 | 2025-11-07 | $11.38 | USPS Ground Advantage | 2 | 0.10 lbs | $6.30 | $5.00 | $1.30 |
| 234632 | 2025-11-10 | $10.52 | USPS Ground Advantage | 1 | 0.05 lbs | $5.95 | $4.65 | $1.30 |
| 234633 | 2025-11-12 | $47.65 | USPS Ground Advantage | 1 | 2.20 lbs | $16.86 | $15.13 | $1.73 |
| 234634 | 2025-11-13 | $26.20 | USPS Ground Advantage | 1 | 0.35 lbs | $6.85 | $6.59 | $0.26 |
| 234638 | 2025-11-14 | $10.12 | USPS Ground Advantage | 1 | 0.05 lbs | $6.17 | $4.87 | $1.30 |
| 234639 | 2025-11-14 | $23.87 | USPS Ground Advantage | 1 | 0.70 lbs | $8.75 | $7.45 | $1.30 |
| 234641 | 2025-11-16 | $27.52 | USPS Ground Advantage | 1 | 0.38 lbs | $6.46 | $5.90 | $0.56 |
| 234642 | 2025-11-16 | $10.40 | USPS Ground Advantage | 1 | 0.01 lbs | $6.45 | $5.15 | $1.30 |
| 234643 | 2025-11-16 | $12.62 | USPS Ground Advantage | 1 | 0.46 lbs | $6.29 | $5.71 | $0.58 |
| 234644 | 2025-11-16 | $10.64 | USPS Ground Advantage | 1 | 0.03 lbs | $6.45 | $5.15 | $1.30 |
| 234645 | 2025-11-15 | $14.99 | USPS Ground Advantage | 1 | 0.30 lbs | $6.29 | $5.71 | $0.58 |
| 234646 | 2025-11-15 | $10.49 | USPS Ground Advantage | 1 | 0.08 lbs | $6.45 | $5.15 | $1.30 |
| 234647 | 2025-11-17 | $13.61 | USPS Ground Advantage | 1 | 0.05 lbs | $6.25 | $4.95 | $1.30 |
| 234649 | 2025-11-18 | $11.27 | USPS Ground Advantage | 3 | 0.21 lbs | $6.56 | $5.26 | $1.30 |
| 234650 | 2025-11-17 | $10.36 | USPS Ground Advantage | 1 | 0.04 lbs | $6.25 | $4.95 | $1.30 |
| 234651 | 2025-11-17 | $223.76 | USPS Ground Advantage | 1 | 24.50 lbs | $29.73 | $24.01 | $5.72 |
| 234652 | 2025-11-18 | $14.65 | USPS Ground Advantage | 1 | 0.05 lbs | $5.95 | $4.65 | $1.30 |
| 234655 | 2025-11-19 | $92.29 | Priority Mail | 10 | 4.43 lbs | $29.79 | $23.11 | $6.68 |
| 234656 | 2025-11-20 | $12.82 | USPS Ground Advantage | 1 | 0.09 lbs | $6.25 | $4.95 | $1.30 |
| 234657 | 2025-11-19 | $9.79 | USPS Ground Advantage | 1 | 0.05 lbs | $5.84 | $4.54 | $1.30 |
| 234658 | 2025-11-19 | $23.22 | USPS Ground Advantage | 4 | 1.60 lbs | $11.30 | $10.00 | $1.30 |
| 234659 | 2025-11-20 | $58.97 | USPS Ground Advantage | 1 | 1.20 lbs | $9.24 | $8.14 | $1.10 |
| 234660 | 2025-11-20 | $26.80 | USPS Ground Advantage | 1 | 0.18 lbs | $6.22 | $5.32 | $0.90 |
| 234661 | 2025-11-21 | $12.47 | USPS Ground Advantage | 1 | 0.05 lbs | $6.30 | $5.00 | $1.30 |
| 234662 | 2025-11-22 | $44.62 | USPS Ground Advantage | 1 | 13.50 lbs | $13.74 | $13.37 | $0.37 |
| 234663 | 2025-11-22 | $24.35 | USPS Ground Advantage | 1 | 0.31 lbs | $6.54 | $5.24 | $1.30 |
| 234664 | 2025-11-23 | $14.76 | Priority Mail | 1 | 0.02 lbs | $10.52 | $9.42 | $1.10 |
| 234665 | 2025-11-23 | $25.85 | USPS Ground Advantage | 1 | 0.03 lbs | $6.06 | $4.76 | $1.30 |
| 234666 | 2025-11-23 | $19.12 | USPS Ground Advantage | 1 | 0.30 lbs | $6.54 | $5.24 | $1.30 |
| 234667 | 2025-11-23 | $16.38 | USPS Ground Advantage | 1 | 0.10 lbs | $6.25 | $4.95 | $1.30 |
| 234668 | 2025-11-22 | $11.55 | USPS Ground Advantage | 1 | 0.05 lbs | $6.25 | $4.95 | $1.30 |
| 234669 | 2025-11-22 | $11.55 | USPS Ground Advantage | 1 | 0.03 lbs | $6.10 | $4.80 | $1.30 |
| 234670 | 2025-11-22 | $12.63 | USPS Ground Advantage | 1 | 0.05 lbs | $6.30 | $5.00 | $1.30 |
| 234671 | 2025-11-24 | $13.53 | USPS Ground Advantage | 1 | 0.04 lbs | $6.17 | $4.87 | $1.30 |
| 234672 | 2025-11-25 | $20.38 | USPS Ground Advantage | 1 | 0.40 lbs | $6.29 | $4.99 | $1.30 |
| 234673 | 2025-11-24 | $11.82 | USPS Ground Advantage | 1 | 0.36 lbs | $6.29 | $4.65 | $1.64 |
| 234674 | 2025-11-24 | $11.36 | USPS Ground Advantage | 1 | 0.03 lbs | $6.22 | $4.92 | $1.30 |
| 234675 | 2025-11-26 | $10.55 | USPS Ground Advantage | 1 | 0.02 lbs | $6.06 | $4.76 | $1.30 |
| 234676 | 2025-11-25 | $23.46 | USPS Ground Advantage | 1 | 0.10 lbs | $6.10 | $4.80 | $1.30 |
| 234677 | 2025-11-25 | $43.66 | USPS Ground Advantage | 1 | 0.75 lbs | $7.67 | $7.45 | $0.22 |
| 234678 | 2025-11-25 | $22.05 | USPS Ground Advantage | 2 | 0.17 lbs | $11.90 | $4.99 | $6.91 |
| 234679 | 2025-11-26 | $8.66 | USPS Ground Advantage | 1 | 0.02 lbs | $6.06 | $4.76 | $1.30 |
| 234680 | 2025-11-29 | $57.22 | USPS Ground Advantage | 1 | 1.27 lbs | $10.48 | $9.18 | $1.30 |
| 234681 | 2025-11-29 | $11.06 | USPS Ground Advantage | 1 | 0.03 lbs | $6.30 | $5.00 | $1.30 |
| 234682 | 2025-12-01 | $28.44 | USPS Ground Advantage | 1 | 0.03 lbs | $5.95 | $4.65 | $1.30 |
| 234683 | 2025-11-30 | $10.59 | USPS Ground Advantage | 1 | 0.05 lbs | $6.10 | $4.80 | $1.30 |
| 234684 | 2025-11-29 | $10.62 | USPS Ground Advantage | 1 | 0.40 lbs | $6.85 | $6.59 | $0.26 |
| 234685 | 2025-11-29 | $25.93 | USPS Ground Advantage | 1 | 0.70 lbs | $8.75 | $9.74 | $-0.99 |
| 234686 | 2025-12-01 | $11.43 | USPS Ground Advantage | 1 | 0.05 lbs | $6.22 | $4.92 | $1.30 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |