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 |
|---|---|---|---|---|---|---|---|---|
| 232718 | 2024-02-03 | $10.14 | USPS First Class | 1 | 0.05 lbs | $5.35 | $4.02 | $1.33 |
| 232719 | 2024-02-03 | $19.94 | USPS First Class | 1 | 0.45 lbs | $5.95 | $4.43 | $1.52 |
| 232720 | 2024-02-03 | $9.39 | USPS First Class | 1 | 0.05 lbs | $5.40 | $4.11 | $1.29 |
| 232721 | 2024-02-03 | $15.54 | USPS First Class | 1 | 0.07 lbs | $5.55 | $4.36 | $1.19 |
| 232722 | 2024-02-04 | $13.97 | USPS Ground Parcel or Priority Mail | 1 | 0.06 lbs | $8.18 | $4.02 | $4.16 |
| 232723 | 2024-02-04 | $21.17 | USPS Ground Parcel or Priority Mail | 1 | 0.15 lbs | $8.18 | $4.36 | $3.82 |
| 232725 | 2024-02-05 | $25.14 | USPS First Class | 1 | 0.12 lbs | $5.25 | $3.96 | $1.29 |
| 232726 | 2024-02-05 | $10.04 | USPS First Class | 1 | 0.05 lbs | $5.25 | $3.96 | $1.29 |
| 232727 | 2024-02-05 | $11.99 | USPS First Class | 1 | 0.36 lbs | $6.00 | $4.11 | $1.89 |
| 232729 | 2024-02-06 | $16.86 | Priority Mail | 2 | 0.12 lbs | $9.19 | $7.99 | $1.20 |
| 232730 | 2024-02-07 | $16.14 | USPS Ground Advantage | 1 | 0.50 lbs | $6.15 | $6.33 | $-0.18 |
| 232731 | 2024-02-06 | $28.17 | USPS Ground Parcel or Priority Mail | 1 | 0.35 lbs | $8.18 | $5.15 | $3.03 |
| 232732 | 2024-02-07 | $13.64 | USPS First Class | 1 | 0.06 lbs | $5.25 | $3.96 | $1.29 |
| 232733 | 2024-02-08 | $10.34 | USPS First Class | 1 | 0.05 lbs | $5.35 | $4.02 | $1.33 |
| 232734 | 2024-02-09 | $9.44 | USPS First Class | 1 | 0.05 lbs | $5.45 | $4.19 | $1.26 |
| 232736 | 2024-02-09 | $20.24 | USPS First Class | 1 | 0.05 lbs | $5.25 | $3.96 | $1.29 |
| 232740 | 2024-02-10 | $25.44 | USPS First Class | 1 | 0.12 lbs | $5.55 | $4.36 | $1.19 |
| 232741 | 2024-02-10 | $11.89 | USPS First Class | 1 | 0.36 lbs | $5.90 | $4.38 | $1.52 |
| 232742 | 2024-02-12 | $12.20 | USPS Ground Parcel or Priority Mail | 1 | 0.25 lbs | $6.02 | $4.13 | $1.89 |
| 232743 | 2024-02-12 | $15.69 | USPS First Class | 1 | 0.10 lbs | $5.40 | $4.11 | $1.29 |
| 232744 | 2024-02-12 | $11.44 | USPS First Class | 1 | 0.10 lbs | $5.25 | $3.96 | $1.29 |
| 232745 | 2024-02-12 | $25.44 | USPS First Class | 1 | 0.12 lbs | $5.55 | $4.36 | $1.19 |
| 232746 | 2024-02-12 | $43.98 | USPS First Class | 2 | 0.12 lbs | $10.50 | $3.96 | $6.54 |
| 232747 | 2024-02-13 | $14.44 | USPS First Class | 1 | 0.04 lbs | $5.45 | $4.19 | $1.26 |
| 232748 | 2024-02-13 | $13.54 | USPS First Class | 1 | 0.06 lbs | $5.55 | $4.36 | $1.19 |
| 232749 | 2024-02-13 | $14.04 | USPS First Class | 1 | 0.21 lbs | $5.55 | $4.36 | $1.19 |
| 232750 | 2024-02-13 | $22.57 | USPS Ground Parcel or Priority Mail | 1 | 0.40 lbs | $8.18 | $4.68 | $3.50 |
| 232751 | 2024-02-16 | $12.54 | USPS First Class | 1 | 0.25 lbs | $5.45 | $4.55 | $0.90 |
| 232752 | 2024-02-15 | $11.44 | USPS First Class | 1 | 0.06 lbs | $5.55 | $4.36 | $1.19 |
| 232753 | 2024-02-14 | $10.24 | USPS First Class | 1 | 0.12 lbs | $5.35 | $4.02 | $1.33 |
| 232754 | 2024-02-16 | $31.85 | USPS Ground Parcel or Priority Mail | 1 | 1.78 lbs | $6.77 | $4.87 | $1.90 |
| 232755 | 2024-02-18 | $21.74 | USPS First Class | 1 | 0.19 lbs | $5.55 | $4.68 | $0.87 |
| 232756 | 2024-02-17 | $27.69 | USPS Ground Advantage | 1 | 0.92 lbs | $8.70 | $7.15 | $1.55 |
| 232757 | 2024-02-17 | $22.94 | USPS First Class | 1 | 0.06 lbs | $5.45 | $4.19 | $1.26 |
| 232758 | 2024-02-17 | $9.44 | USPS First Class | 1 | 0.05 lbs | $5.45 | $4.19 | $1.26 |
| 232759 | 2024-02-16 | $20.04 | USPS Ground Advantage | 1 | 0.70 lbs | $6.05 | $6.23 | $-0.18 |
| 232760 | 2024-02-18 | $16.07 | USPS Ground Parcel or Priority Mail | 1 | 0.04 lbs | $8.18 | $4.11 | $4.07 |
| 232761 | 2024-02-19 | $11.89 | USPS First Class | 1 | 0.36 lbs | $5.90 | $4.38 | $1.52 |
| 232762 | 2024-02-19 | $13.79 | USPS First Class | 1 | 0.06 lbs | $5.40 | $4.11 | $1.29 |
| 232763 | 2024-02-19 | $17.14 | USPS First Class | 1 | 0.05 lbs | $5.35 | $4.02 | $1.33 |
| 232764 | 2024-02-20 | $22.57 | USPS Ground Parcel or Priority Mail | 1 | 0.40 lbs | $8.18 | $4.68 | $3.50 |
| 232765 | 2024-02-20 | $9.54 | USPS First Class | 1 | 0.05 lbs | $5.25 | $3.96 | $1.29 |
| 232766 | 2024-02-20 | $13.94 | USPS First Class | 1 | 0.21 lbs | $5.45 | $4.19 | $1.26 |
| 232767 | 2024-02-22 | $10.19 | USPS First Class | 1 | 0.06 lbs | $5.40 | $4.11 | $1.29 |
| 232768 | 2024-02-22 | $21.54 | USPS First Class | 1 | 0.06 lbs | $5.55 | $4.36 | $1.19 |
| 232769 | 2024-02-22 | $27.84 | USPS Ground Advantage | 1 | 0.92 lbs | $8.85 | $7.57 | $1.28 |
| 232771 | 2024-02-23 | $10.29 | USPS First Class | 1 | 0.12 lbs | $5.40 | $4.11 | $1.29 |
| 232773 | 2024-02-25 | $7.54 | USPS First Class | 1 | 0.06 lbs | $5.55 | $4.36 | $1.19 |
| 232774 | 2024-02-25 | $11.34 | USPS First Class | 1 | 0.05 lbs | $5.55 | $4.36 | $1.19 |
| 232775 | 2024-02-24 | $13.54 | USPS First Class | 1 | 0.06 lbs | $5.15 | $3.86 | $1.29 |
| 232776 | 2024-02-26 | $26.89 | USPS Ground Parcel or Priority Mail | 1 | 0.40 lbs | $8.18 | $4.43 | $3.75 |
| 232777 | 2024-02-24 | $18.97 | USPS Ground Parcel or Priority Mail | 1 | 0.05 lbs | $8.18 | $4.19 | $3.99 |
| 232778 | 2024-02-24 | $14.87 | USPS Ground Parcel or Priority Mail | 1 | 0.09 lbs | $8.18 | $4.36 | $3.82 |
| 232779 | 2024-02-26 | $59.49 | USPS Priority Mail | 1 | 1.45 lbs | $14.50 | $8.74 | $5.76 |
| 232780 | 2024-02-26 | $54.16 | Priority Mail | 1 | 1.23 lbs | $28.07 | $24.91 | $3.16 |
| 232781 | 2024-02-26 | $41.04 | USPS First Class | 1 | 0.31 lbs | $6.05 | $4.55 | $1.50 |
| 232782 | 2024-02-26 | $25.34 | USPS First Class | 1 | 0.12 lbs | $5.45 | $4.19 | $1.26 |
| 232785 | 2024-02-28 | $13.74 | USPS First Class | 1 | 0.06 lbs | $5.35 | $4.02 | $1.33 |
| 232786 | 2024-02-29 | $46.16 | Priority Mail | 3 | 0.31 lbs | $9.19 | $8.51 | $0.68 |
| 232788 | 2024-02-29 | $54.32 | Priority Mail | 1 | 1.20 lbs | $10.38 | $6.82 | $3.56 |
| 232789 | 2024-02-29 | $23.24 | Priority Mail Flat Rate Envelope | 4 | 0.12 lbs | $9.60 | $7.99 | $1.61 |
| 232790 | 2024-02-29 | $14.84 | Priority Mail Flat Rate Envelope | 1 | 0.05 lbs | $9.60 | $7.99 | $1.61 |
| 232791 | 2024-02-29 | $15.04 | USPS First Class | 1 | 0.06 lbs | $5.25 | $3.96 | $1.29 |
| 232792 | 2024-03-01 | $14.95 | USPS Ground Parcel or Priority Mail | 1 | 0.05 lbs | $8.18 | $4.19 | $3.99 |
| 232793 | 2024-03-01 | $14.95 | USPS Ground Parcel or Priority Mail | 1 | 0.05 lbs | $8.18 | $4.19 | $3.99 |
| 232794 | 2024-03-04 | $10.24 | USPS Ground Advantage | 1 | 0.15 lbs | $5.55 | $4.68 | $0.87 |
| 232795 | 2024-03-02 | $13.24 | USPS First Class | 1 | 0.06 lbs | $5.35 | $4.02 | $1.33 |
| 232796 | 2024-03-02 | $10.24 | USPS First Class | 1 | 0.06 lbs | $5.25 | $3.96 | $1.29 |
| 232797 | 2024-03-02 | $25.29 | USPS First Class | 1 | 0.12 lbs | $5.40 | $4.11 | $1.29 |
| 232798 | 2024-03-02 | $12.97 | USPS Ground Parcel or Priority Mail | 1 | 0.04 lbs | $8.18 | $4.19 | $3.99 |
| 232799 | 2024-03-04 | $44.38 | USPS First Class | 2 | 0.12 lbs | $10.90 | $4.19 | $6.71 |
| 232800 | 2024-03-05 | $20.24 | USPS First Class | 1 | 0.05 lbs | $5.25 | $3.96 | $1.29 |
| 232802 | 2024-03-06 | $13.84 | USPS First Class | 1 | 0.05 lbs | $5.35 | $4.02 | $1.33 |
| 232803 | 2024-03-07 | $10.19 | USPS First Class | 1 | 0.06 lbs | $5.40 | $4.11 | $1.29 |
| 232804 | 2024-03-07 | $51.89 | USPS Priority Mail | 1 | 3.15 lbs | $26.90 | $13.17 | $13.73 |
| 232805 | 2024-03-07 | $25.24 | USPS First Class | 1 | 0.15 lbs | $5.25 | $3.96 | $1.29 |
| 232806 | 2024-03-06 | $11.34 | USPS First Class | 1 | 0.05 lbs | $5.55 | $4.36 | $1.19 |
| 232807 | 2024-03-07 | $12.17 | USPS Ground Parcel or Priority Mail | 1 | 0.02 lbs | $8.18 | $4.19 | $3.99 |
| 232808 | 2024-03-08 | $9.34 | USPS First Class | 1 | 0.05 lbs | $5.35 | $4.02 | $1.33 |
| 232810 | 2024-03-10 | $50.25 | Priority Mail Small Flat Rate Box | 3 | 0.43 lbs | $10.15 | $8.51 | $1.64 |
| 232811 | 2024-03-10 | $22.94 | USPS First Class | 1 | 0.06 lbs | $5.45 | $4.19 | $1.26 |
| 232812 | 2024-03-10 | $33.84 | USPS First Class | 1 | 0.06 lbs | $5.35 | $4.02 | $1.33 |
| 232813 | 2024-03-09 | $9.14 | USPS First Class | 1 | 0.05 lbs | $5.35 | $4.02 | $1.33 |
| 232814 | 2024-03-09 | $9.99 | USPS First Class | 1 | 0.20 lbs | $5.10 | $4.28 | $0.82 |
| 232815 | 2024-03-11 | $45.49 | USPS Priority Mail | 1 | 3.15 lbs | $20.50 | $9.94 | $10.56 |
| 232818 | 2024-03-12 | $16.98 | Priority Mail | 2 | 0.40 lbs | $11.69 | $8.74 | $2.95 |
| 232819 | 2024-03-13 | $13.54 | USPS First Class | 1 | 0.12 lbs | $5.55 | $4.36 | $1.19 |
| 232820 | 2024-03-14 | $6.64 | USPS First Class | 1 | 0.01 lbs | $5.35 | $4.02 | $1.33 |
| 232821 | 2024-03-14 | $12.39 | USPS First Class | 1 | 0.03 lbs | $5.40 | $4.11 | $1.29 |
| 232822 | 2024-03-15 | $12.20 | USPS Ground Parcel or Priority Mail | 1 | 0.25 lbs | $6.02 | $4.13 | $1.89 |
| 232823 | 2024-03-17 | $15.54 | USPS First Class | 1 | 0.05 lbs | $5.55 | $4.36 | $1.19 |
| 232824 | 2024-03-16 | $17.14 | USPS First Class | 1 | 0.05 lbs | $5.35 | $4.02 | $1.33 |
| 232825 | 2024-03-16 | $12.09 | USPS First Class | 1 | 0.07 lbs | $5.40 | $4.11 | $1.29 |
| 232826 | 2024-03-15 | $16.14 | USPS Ground Advantage | 1 | 0.30 lbs | $6.15 | $4.68 | $1.47 |
| 232827 | 2024-03-18 | $16.28 | USPS Ground Parcel or Priority Mail | 1 | 0.15 lbs | $8.18 | $4.11 | $4.07 |
| 232828 | 2024-03-18 | $19.67 | USPS Ground Parcel or Priority Mail | 1 | 0.06 lbs | $8.18 | $4.11 | $4.07 |
| 232829 | 2024-03-18 | $17.19 | USPS Ground Parcel or Priority Mail | 1 | 0.07 lbs | $8.18 | $3.96 | $4.22 |
| 232830 | 2024-03-18 | $23.42 | USPS First Class | 3 | 0.15 lbs | $5.45 | $4.19 | $1.26 |
| 232831 | 2024-03-18 | $10.14 | USPS First Class | 1 | 0.06 lbs | $5.35 | $4.02 | $1.33 |
| 232832 | 2024-03-18 | $33.89 | USPS First Class | 1 | 0.06 lbs | $5.40 | $4.11 | $1.29 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |