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 |
|---|---|---|---|---|---|---|---|---|
| 231640 | 2023-05-07 | $14.13 | First-Class Package Service | 4 | 0.14 lbs | $5.17 | $3.97 | $1.20 |
| 231641 | 2023-05-07 | $21.19 | First-Class Package Service | 1 | 0.60 lbs | $5.76 | $4.81 | $0.95 |
| 231642 | 2023-05-07 | $25.30 | First-Class Package Service | 10 | 0.30 lbs | $5.40 | $4.88 | $0.52 |
| 231644 | 2023-05-07 | $9.86 | First-Class Package Service | 1 | 0.05 lbs | $5.17 | $3.97 | $1.20 |
| 231645 | 2023-05-07 | $17.39 | Priority Mail Flat Rate Envelope | 1 | 0.07 lbs | $9.15 | $7.60 | $1.55 |
| 231650 | 2023-05-08 | $14.14 | First-Class Package Service | 1 | 0.10 lbs | $5.17 | $3.97 | $1.20 |
| 231651 | 2023-05-08 | $8.44 | USPS First Class | 1 | 0.06 lbs | $5.15 | $3.97 | $1.18 |
| 231652 | 2023-05-06 | $38.54 | USPS First Class | 1 | 0.27 lbs | $5.55 | $4.09 | $1.46 |
| 231653 | 2023-05-08 | $16.46 | USPS Shipping | 1 | 0.05 lbs | $5.15 | $3.97 | $1.18 |
| 231654 | 2023-05-08 | $15.41 | USPS Shipping | 1 | 0.20 lbs | $5.15 | $4.31 | $0.84 |
| 231655 | 2023-05-08 | $26.35 | USPS Shipping | 3 | 0.06 lbs | $15.45 | $3.81 | $11.64 |
| 231660 | 2023-05-08 | $51.71 | Priority Mail | 1 | 2.20 lbs | $11.33 | $9.59 | $1.74 |
| 231663 | 2023-05-08 | $43.50 | Priority Mail Small Flat Rate Box | 1 | 1.15 lbs | $9.65 | $8.10 | $1.55 |
| 231664 | 2023-05-08 | $17.74 | USPS Parcel Select Ground | 1 | 0.30 lbs | $7.75 | $6.62 | $1.13 |
| 231670 | 2023-05-10 | $6.32 | First-Class Package Service | 3 | 0.03 lbs | $5.33 | $4.13 | $1.20 |
| 231671 | 2023-05-10 | $15.24 | USPS First Class | 1 | 0.05 lbs | $5.25 | $4.13 | $1.12 |
| 231672 | 2023-05-10 | $16.64 | USPS First Class | 1 | 0.10 lbs | $5.15 | $3.97 | $1.18 |
| 231674 | 2023-05-10 | $118.28 | Priority Mail | 1 | 1.19 lbs | $10.49 | $8.82 | $1.67 |
| 231675 | 2023-05-10 | $10.87 | First-Class Package Service | 2 | 0.12 lbs | $5.64 | $4.13 | $1.51 |
| 231678 | 2023-05-10 | $43.20 | First-Class Package Service | 2 | 0.75 lbs | $7.02 | $6.07 | $0.95 |
| 231679 | 2023-05-11 | $23.77 | First-Class Package Service | 12 | 0.78 lbs | $7.39 | $6.44 | $0.95 |
| 231680 | 2023-05-10 | $10.14 | USPS Shipping | 1 | 0.20 lbs | $5.15 | $3.97 | $1.18 |
| 231687 | 2023-05-12 | $50.94 | USPS Priority Mail | 1 | 4.54 lbs | $29.35 | $14.22 | $15.13 |
| 231689 | 2023-05-12 | $18.34 | First-Class Package Service | 1 | 0.24 lbs | $5.35 | $4.15 | $1.20 |
| 231690 | 2023-05-13 | $17.50 | First-Class Package Service | 1 | 0.30 lbs | $5.51 | $4.31 | $1.20 |
| 231691 | 2023-05-13 | $15.24 | USPS First Class | 1 | 0.05 lbs | $5.25 | $4.13 | $1.12 |
| 231696 | 2023-05-13 | $10.34 | First-Class Package Service | 1 | 0.05 lbs | $5.10 | $3.90 | $1.20 |
| 231697 | 2023-05-13 | $12.99 | First-Class Package Service | 2 | 0.06 lbs | $5.01 | $3.81 | $1.20 |
| 231699 | 2023-05-15 | $10.77 | First-Class Package Service | 1 | 0.03 lbs | $5.33 | $4.13 | $1.20 |
| 231700 | 2023-05-15 | $7.29 | First-Class Package Service | 1 | 0.01 lbs | $4.95 | $3.75 | $1.20 |
| 231703 | 2023-05-15 | $33.44 | USPS Priority Mail | 1 | 1.78 lbs | $11.45 | $8.30 | $3.15 |
| 231704 | 2023-05-14 | $13.64 | USPS First Class | 1 | 0.30 lbs | $5.65 | $4.20 | $1.45 |
| 231706 | 2023-05-15 | $17.64 | USPS First Class | 1 | 0.30 lbs | $5.65 | $4.20 | $1.45 |
| 231707 | 2023-05-16 | $15.04 | USPS First Class | 1 | 0.10 lbs | $5.05 | $3.81 | $1.24 |
| 231708 | 2023-05-16 | $16.85 | USPS Shipping | 1 | 0.50 lbs | $8.61 | $8.56 | $0.05 |
| 231709 | 2023-05-16 | $30.74 | USPS First Class | 1 | 0.40 lbs | $5.75 | $5.17 | $0.58 |
| 231710 | 2023-05-16 | $13.13 | USPS Shipping | 1 | 0.06 lbs | $5.15 | $3.90 | $1.25 |
| 231716 | 2023-05-17 | $11.79 | USPS First Class | 1 | 0.10 lbs | $5.10 | $3.90 | $1.20 |
| 231717 | 2023-05-17 | $10.99 | USPS First Class | 1 | 0.06 lbs | $5.00 | $3.75 | $1.25 |
| 231718 | 2023-05-18 | $68.33 | Priority Mail Medium Flat Rate Box | 5 | 1.97 lbs | $16.40 | $8.30 | $8.10 |
| 231719 | 2023-05-18 | $23.67 | First-Class Package Service | 2 | 0.40 lbs | $5.99 | $5.04 | $0.95 |
| 231720 | 2023-05-18 | $34.16 | First-Class Package Service | 1 | 0.40 lbs | $7.17 | $4.20 | $2.97 |
| 231721 | 2023-05-19 | $18.90 | USPS Shipping | 1 | 0.30 lbs | $5.75 | $4.24 | $1.51 |
| 231722 | 2023-05-19 | $17.74 | First-Class Package Service | 1 | 0.35 lbs | $5.35 | $4.81 | $0.54 |
| 231723 | 2023-05-19 | $8.54 | USPS Shipping | 1 | 0.06 lbs | $5.15 | $3.81 | $1.34 |
| 231724 | 2023-05-20 | $12.60 | First-Class Package Service | 2 | 0.24 lbs | $5.64 | $4.13 | $1.51 |
| 231725 | 2023-05-20 | $16.64 | USPS First Class | 1 | 0.31 lbs | $5.65 | $4.20 | $1.45 |
| 231726 | 2023-05-20 | $9.59 | First-Class Package Service | 1 | 0.01 lbs | $5.01 | $3.81 | $1.20 |
| 231727 | 2023-05-21 | $25.23 | First-Class Package Service | 1 | 0.35 lbs | $5.64 | $4.44 | $1.20 |
| 231729 | 2023-05-21 | $11.34 | First-Class Package Service | 1 | 0.01 lbs | $5.10 | $3.90 | $1.20 |
| 231730 | 2023-05-21 | $43.65 | First-Class Package Service | 2 | 0.06 lbs | $5.17 | $3.97 | $1.20 |
| 231731 | 2023-05-22 | $15.44 | USPS First Class | 1 | 0.05 lbs | $5.15 | $3.97 | $1.18 |
| 231732 | 2023-05-21 | $9.04 | USPS First Class | 1 | 0.05 lbs | $5.15 | $3.97 | $1.18 |
| 231733 | 2023-05-21 | $7.89 | USPS First Class | 1 | 0.02 lbs | $5.00 | $3.75 | $1.25 |
| 231734 | 2023-05-20 | $10.69 | USPS First Class | 1 | 0.05 lbs | $4.90 | $3.66 | $1.24 |
| 231735 | 2023-05-22 | $17.59 | USPS First Class | 1 | 0.30 lbs | $5.60 | $4.15 | $1.45 |
| 231736 | 2023-05-22 | $11.74 | USPS First Class | 1 | 0.05 lbs | $5.05 | $3.81 | $1.24 |
| 231741 | 2023-05-23 | $11.62 | First-Class Package Service | 3 | 0.09 lbs | $5.10 | $3.90 | $1.20 |
| 231742 | 2023-05-23 | $11.14 | USPS First Class | 1 | 0.03 lbs | $5.25 | $4.13 | $1.12 |
| 231743 | 2023-05-23 | $27.24 | USPS First Class | 1 | 0.45 lbs | $5.75 | $5.17 | $0.58 |
| 231744 | 2023-05-25 | $22.34 | USPS First Class | 1 | 0.40 lbs | $5.85 | $4.44 | $1.41 |
| 231745 | 2023-05-24 | $30.67 | USPS First Class | 3 | 0.12 lbs | $14.70 | $3.66 | $11.04 |
| 231746 | 2023-05-25 | $20.27 | USPS Shipping | 1 | 0.33 lbs | $5.75 | $4.44 | $1.31 |
| 231747 | 2023-05-25 | $47.76 | USPS Shipping | 1 | 1.40 lbs | $9.15 | $8.10 | $1.05 |
| 231748 | 2023-05-25 | $27.36 | Priority Mail | 1 | 1.10 lbs | $9.55 | $8.30 | $1.25 |
| 231749 | 2023-05-25 | $207.06 | Priority Mail Padded Flat Rate Envelope | 2 | 7.36 lbs | $9.90 | $10.28 | $-0.38 |
| 231751 | 2023-05-25 | $14.29 | First-Class Package Service | 1 | 0.40 lbs | $5.76 | $4.15 | $1.61 |
| 231752 | 2023-05-25 | $43.50 | Priority Mail Small Flat Rate Box | 1 | 1.30 lbs | $9.65 | $8.10 | $1.55 |
| 231753 | 2023-05-26 | $28.24 | First-Class Package Service | 8 | 0.37 lbs | $5.64 | $8.56 | $-2.92 |
| 231754 | 2023-05-27 | $25.77 | Priority Mail Flat Rate Envelope | 1 | 0.80 lbs | $9.15 | $8.30 | $0.85 |
| 231755 | 2023-05-27 | $12.89 | USPS First Class | 1 | 0.04 lbs | $5.00 | $3.75 | $1.25 |
| 231757 | 2023-05-27 | $10.98 | First-Class Package Service | 1 | 0.06 lbs | $5.01 | $3.81 | $1.20 |
| 231764 | 2023-05-28 | $37.56 | Priority Mail Small Flat Rate Box | 1 | 1.10 lbs | $9.65 | $8.10 | $1.55 |
| 231765 | 2023-05-29 | $12.80 | USPS Shipping | 1 | 0.10 lbs | $5.15 | $3.75 | $1.40 |
| 231766 | 2023-05-29 | $22.32 | First-Class Package Service | 4 | 0.30 lbs | $5.64 | $4.44 | $1.20 |
| 231768 | 2023-05-29 | $17.73 | Priority Mail Padded Flat Rate Envelope | 2 | 0.70 lbs | $9.90 | $8.30 | $1.60 |
| 231771 | 2023-05-29 | $18.44 | USPS First Class | 1 | 0.60 lbs | $6.45 | $5.04 | $1.41 |
| 231772 | 2023-05-30 | $14.24 | USPS First Class | 1 | 0.08 lbs | $5.25 | $4.13 | $1.12 |
| 231774 | 2023-05-31 | $15.09 | USPS First Class | 1 | 0.05 lbs | $5.10 | $4.24 | $0.86 |
| 231775 | 2023-05-31 | $38.47 | First-Class Package Service | 6 | 0.60 lbs | $6.37 | $5.17 | $1.20 |
| 231776 | 2023-05-31 | $23.25 | First-Class Package Service | 1 | 0.14 lbs | $5.26 | $3.64 | $1.62 |
| 231777 | 2023-05-31 | $17.95 | First-Class Package Service | 2 | 0.06 lbs | $5.17 | $3.97 | $1.20 |
| 231778 | 2023-06-02 | $12.13 | First-Class Package Service | 4 | 0.18 lbs | $5.44 | $5.04 | $0.40 |
| 231779 | 2023-06-01 | $7.94 | USPS Shipping | 1 | 0.02 lbs | $5.15 | $3.90 | $1.25 |
| 231780 | 2023-06-02 | $23.64 | First-Class Package Service | 5 | 0.13 lbs | $5.33 | $4.13 | $1.20 |
| 231782 | 2023-06-02 | $9.69 | First-Class Package Service | 1 | 0.03 lbs | $4.95 | $3.75 | $1.20 |
| 231783 | 2023-06-03 | $9.94 | USPS First Class | 1 | 0.10 lbs | $5.15 | $3.97 | $1.18 |
| 231784 | 2023-06-02 | $23.04 | USPS First Class | 1 | 0.19 lbs | $5.05 | $3.81 | $1.24 |
| 231785 | 2023-06-03 | $29.20 | First-Class Package Service | 13 | 0.40 lbs | $5.64 | $4.44 | $1.20 |
| 231787 | 2023-06-04 | $43.45 | First-Class Package Service | 1 | 0.19 lbs | $5.51 | $3.97 | $1.54 |
| 231788 | 2023-06-04 | $22.73 | First-Class Package Service | 1 | 0.25 lbs | $5.99 | $3.90 | $2.09 |
| 231789 | 2023-06-05 | $10.84 | USPS First Class | 1 | 0.05 lbs | $5.05 | $3.81 | $1.24 |
| 231790 | 2023-06-05 | $30.65 | Priority Mail | 2 | 0.06 lbs | $11.17 | $8.10 | $3.07 |
| 231791 | 2023-06-06 | $9.09 | USPS First Class | 1 | 0.08 lbs | $5.10 | $3.90 | $1.20 |
| 231792 | 2023-06-06 | $12.94 | USPS First Class | 1 | 0.06 lbs | $5.05 | $3.81 | $1.24 |
| 231793 | 2023-06-06 | $35.18 | First-Class Package Service | 5 | 0.62 lbs | $6.53 | $5.33 | $1.20 |
| 231794 | 2023-06-06 | $20.94 | Priority Mail Small Flat Rate Box | 1 | 0.25 lbs | $9.65 | $8.10 | $1.55 |
| 231796 | 2023-06-07 | $30.14 | USPS First Class | 1 | 0.80 lbs | $8.15 | $6.60 | $1.55 |
| 231797 | 2023-06-06 | $11.04 | USPS First Class | 1 | 0.04 lbs | $5.25 | $4.13 | $1.12 |
| 231802 | 2023-06-07 | $15.04 | USPS First Class | 1 | 0.10 lbs | $5.05 | $3.81 | $1.24 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |