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 |
|---|---|---|---|---|---|---|---|---|
| 230766 | 2022-12-31 | $26.59 | USPS First Class | 1 | 0.45 lbs | $6.10 | $5.38 | $0.72 |
| 230767 | 2022-12-31 | $7.84 | USPS First Class | 1 | 0.02 lbs | $4.95 | $3.67 | $1.28 |
| 230768 | 2023-01-02 | $17.45 | First-Class Package Service | 3 | 0.18 lbs | $5.48 | $3.98 | $1.50 |
| 230769 | 2023-01-02 | $9.36 | USPS Shipping | 1 | 0.03 lbs | $5.23 | $4.26 | $0.97 |
| 230770 | 2023-01-02 | $20.07 | First-Class Package Service | 2 | 0.23 lbs | $5.59 | $4.39 | $1.20 |
| 230771 | 2023-01-02 | $39.44 | Priority Mail | 1 | 1.20 lbs | $9.84 | $8.10 | $1.74 |
| 230772 | 2023-01-02 | $10.19 | USPS First Class | 1 | 0.05 lbs | $5.40 | $4.12 | $1.28 |
| 230774 | 2023-01-02 | $14.61 | First-Class Package Service | 1 | 0.05 lbs | $5.32 | $4.12 | $1.20 |
| 230775 | 2023-01-02 | $11.92 | First-Class Package Service | 1 | 0.10 lbs | $5.18 | $3.98 | $1.20 |
| 230777 | 2023-01-03 | $9.29 | USPS First Class | 1 | 0.20 lbs | $5.30 | $3.88 | $1.42 |
| 230779 | 2023-01-03 | $15.43 | First-Class Package Service | 3 | 0.13 lbs | $5.46 | $4.26 | $1.20 |
| 230781 | 2023-01-04 | $14.43 | First-Class Package Service | 3 | 0.10 lbs | $5.46 | $4.26 | $1.20 |
| 230782 | 2023-01-03 | $12.39 | USPS First Class | 1 | 0.12 lbs | $5.60 | $4.26 | $1.34 |
| 230783 | 2023-01-04 | $28.79 | USPS Shipping | 1 | 0.50 lbs | $5.80 | $8.00 | $-2.20 |
| 230784 | 2023-01-04 | $7.59 | First-Class Package Service | 3 | 0.03 lbs | $4.87 | $3.67 | $1.20 |
| 230785 | 2023-01-04 | $14.74 | First-Class Package Service | 1 | 0.10 lbs | $5.32 | $4.12 | $1.20 |
| 230787 | 2023-01-04 | $14.99 | USPS First Class | 1 | 0.30 lbs | $6.00 | $4.39 | $1.61 |
| 230788 | 2023-01-05 | $13.49 | USPS First Class | 1 | 0.06 lbs | $5.60 | $4.26 | $1.34 |
| 230789 | 2023-01-05 | $22.39 | USPS First Class | 1 | 0.40 lbs | $5.90 | $4.28 | $1.62 |
| 230790 | 2023-01-05 | $52.11 | Priority Mail | 1 | 3.50 lbs | $22.67 | $21.57 | $1.10 |
| 230792 | 2023-01-05 | $32.05 | First-Class Package Service | 4 | 0.67 lbs | $7.71 | $6.51 | $1.20 |
| 230794 | 2023-01-05 | $8.41 | First-Class Package Service | 2 | 0.02 lbs | $5.18 | $3.98 | $1.20 |
| 230796 | 2023-01-05 | $86.00 | Priority Mail | 8 | 2.96 lbs | $13.44 | $8.30 | $5.14 |
| 230797 | 2023-01-05 | $59.45 | First-Class Package Service | 13 | 0.49 lbs | $6.18 | $6.51 | $-0.33 |
| 230800 | 2023-01-06 | $10.56 | First-Class Package Service | 1 | 0.05 lbs | $5.32 | $4.12 | $1.20 |
| 230803 | 2023-01-06 | $6.94 | USPS First Class | 1 | 0.04 lbs | $4.95 | $3.67 | $1.28 |
| 230804 | 2023-01-06 | $8.41 | First-Class Package Service | 2 | 0.02 lbs | $5.18 | $4.28 | $0.90 |
| 230805 | 2023-01-06 | $15.31 | First-Class Package Service | 1 | 0.13 lbs | $5.32 | $4.12 | $1.20 |
| 230807 | 2023-01-06 | $31.75 | Priority Mail Padded Flat Rate Envelope | 1 | 1.63 lbs | $10.30 | $8.10 | $2.20 |
| 230809 | 2023-01-07 | $38.51 | Priority Mail Small Flat Rate Box | 1 | 1.25 lbs | $10.10 | $8.10 | $2.00 |
| 230810 | 2023-01-07 | $19.59 | First-Class Package Service | 1 | 0.40 lbs | $6.28 | $4.28 | $2.00 |
| 230811 | 2023-01-06 | $53.22 | USPS First Class | 1 | 0.58 lbs | $6.60 | $5.08 | $1.52 |
| 230812 | 2023-01-07 | $25.20 | First-Class Package Service | 2 | 0.26 lbs | $5.22 | $4.27 | $0.95 |
| 230813 | 2023-01-07 | $52.77 | Priority Mail | 1 | 1.25 lbs | $9.84 | $8.10 | $1.74 |
| 230814 | 2023-01-07 | $23.12 | First-Class Package Service | 1 | 0.30 lbs | $5.59 | $4.39 | $1.20 |
| 230815 | 2023-01-07 | $13.56 | First-Class Package Service | 1 | 0.10 lbs | $5.32 | $4.12 | $1.20 |
| 230816 | 2023-01-08 | $27.19 | First-Class Package Service | 5 | 0.06 lbs | $4.84 | $3.64 | $1.20 |
| 230817 | 2023-01-08 | $10.06 | First-Class Package Service | 1 | 0.03 lbs | $5.32 | $4.12 | $1.20 |
| 230818 | 2023-01-08 | $19.83 | First-Class Package Service | 2 | 0.64 lbs | $7.63 | $6.68 | $0.95 |
| 230820 | 2023-01-09 | $55.98 | Priority Mail | 1 | 1.85 lbs | $11.83 | $9.25 | $2.58 |
| 230821 | 2023-01-09 | $158.68 | Priority Mail | 13 | 2.75 lbs | $13.44 | $9.25 | $4.19 |
| 230822 | 2023-01-08 | $8.99 | USPS First Class | 1 | 0.05 lbs | $5.60 | $4.26 | $1.34 |
| 230823 | 2023-01-07 | $20.99 | USPS First Class | 1 | 0.05 lbs | $5.60 | $4.26 | $1.34 |
| 230824 | 2023-01-07 | $14.99 | USPS First Class | 1 | 0.30 lbs | $6.00 | $4.39 | $1.61 |
| 230825 | 2023-01-09 | $31.66 | First-Class Package Service | 2 | 0.70 lbs | $7.46 | $6.51 | $0.95 |
| 230826 | 2023-01-09 | $16.40 | USPS Shipping | 1 | 0.12 lbs | $5.51 | $3.98 | $1.53 |
| 230827 | 2023-01-09 | $11.41 | First-Class Package Service | 1 | 0.10 lbs | $5.32 | $4.12 | $1.20 |
| 230828 | 2023-01-09 | $7.83 | First-Class Package Service | 1 | 0.03 lbs | $5.32 | $4.12 | $1.20 |
| 230829 | 2023-01-09 | $42.26 | Priority Mail | 2 | 0.95 lbs | $14.56 | $13.46 | $1.10 |
| 230830 | 2023-01-10 | $15.00 | First-Class Package Service | 3 | 0.48 lbs | $6.28 | $5.08 | $1.20 |
| 230831 | 2023-01-10 | $15.50 | USPS Shipping | 2 | 0.10 lbs | $5.51 | $3.88 | $1.63 |
| 230832 | 2023-01-10 | $33.06 | First-Class Package Service | 1 | 0.40 lbs | $6.28 | $5.08 | $1.20 |
| 230833 | 2023-01-10 | $18.07 | First-Class Package Service | 7 | 0.15 lbs | $5.18 | $3.98 | $1.20 |
| 230834 | 2023-01-10 | $9.66 | First-Class Package Service | 2 | 0.08 lbs | $4.87 | $3.67 | $1.20 |
| 230835 | 2023-01-11 | $43.08 | Priority Mail | 2 | 1.10 lbs | $12.86 | $9.94 | $2.92 |
| 230838 | 2023-01-11 | $8.56 | First-Class Package Service | 1 | 0.06 lbs | $5.32 | $4.12 | $1.20 |
| 230839 | 2023-01-11 | $36.80 | Priority Mail Flat Rate Envelope | 1 | 0.90 lbs | $9.60 | $8.30 | $1.30 |
| 230841 | 2023-01-12 | $77.21 | Priority Mail Medium Flat Rate Box | 2 | 3.00 lbs | $16.65 | $8.30 | $8.35 |
| 230843 | 2023-01-12 | $2.82 | First-Class Package Service | 1 | 0.19 lbs | $5.47 | $3.88 | $1.59 |
| 230844 | 2023-01-12 | $25.79 | USPS Shipping | 1 | 0.35 lbs | $5.80 | $4.59 | $1.21 |
| 230846 | 2023-01-12 | $15.15 | First-Class Package Service | 1 | 0.30 lbs | $5.48 | $5.08 | $0.40 |
| 230851 | 2023-01-12 | $15.80 | First-Class Package Service | 2 | 0.09 lbs | $4.84 | $3.64 | $1.20 |
| 230852 | 2023-01-12 | $24.34 | First-Class Package Service | 4 | 0.02 lbs | $5.18 | $3.98 | $1.20 |
| 230855 | 2023-01-13 | $9.54 | First-Class Package Service | 3 | 0.04 lbs | $5.32 | $4.12 | $1.20 |
| 230856 | 2023-01-13 | $71.50 | Priority Mail | 4 | 1.77 lbs | $15.24 | $10.63 | $4.61 |
| 230857 | 2023-01-14 | $13.07 | USPS Shipping | 1 | 0.10 lbs | $5.23 | $4.26 | $0.97 |
| 230858 | 2023-01-14 | $10.00 | USPS Shipping | 1 | 0.12 lbs | $5.51 | $3.98 | $1.53 |
| 230859 | 2023-01-14 | $19.06 | First-Class Package Service | 1 | 0.66 lbs | $7.07 | $6.12 | $0.95 |
| 230860 | 2023-01-14 | $7.72 | First-Class Package Service | 1 | 0.01 lbs | $5.18 | $3.98 | $1.20 |
| 230861 | 2023-01-14 | $9.30 | First-Class Package Service | 3 | 0.03 lbs | $5.08 | $3.88 | $1.20 |
| 230867 | 2023-01-15 | $13.28 | First-Class Package Service | 5 | 0.07 lbs | $5.08 | $4.27 | $0.81 |
| 230868 | 2023-01-15 | $16.43 | First-Class Package Service | 3 | 0.03 lbs | $5.46 | $4.26 | $1.20 |
| 230870 | 2023-01-16 | $24.71 | First-Class Package Service | 1 | 0.40 lbs | $6.58 | $5.38 | $1.20 |
| 230872 | 2023-01-15 | $10.09 | 420004_S | 1 | 0.05 lbs | $5.30 | $3.88 | $1.42 |
| 230873 | 2023-01-16 | $30.71 | USPS Shipping | 2 | 0.40 lbs | $10.46 | $6.68 | $3.78 |
| 230874 | 2023-01-16 | $16.02 | USPS Shipping | 1 | 0.31 lbs | $3.88 | $4.39 | $-0.51 |
| 230875 | 2023-01-16 | $12.99 | USPS Shipping | 1 | 0.15 lbs | $5.23 | $4.26 | $0.97 |
| 230876 | 2023-01-16 | $9.50 | USPS Shipping | 1 | 0.02 lbs | $5.51 | $3.88 | $1.63 |
| 230880 | 2023-01-16 | $18.16 | First-Class Package Service | 3 | 0.07 lbs | $5.46 | $4.26 | $1.20 |
| 230881 | 2023-01-16 | $49.21 | Priority Mail | 11 | 2.63 lbs | $13.44 | $9.59 | $3.85 |
| 230882 | 2023-01-16 | $13.29 | First-Class Package Service | 2 | 0.25 lbs | $5.50 | $4.55 | $0.95 |
| 230885 | 2023-01-16 | $14.69 | USPS First Class | 1 | 0.05 lbs | $5.40 | $4.12 | $1.28 |
| 230886 | 2023-01-17 | $16.40 | USPS Shipping | 1 | 0.12 lbs | $5.51 | $3.67 | $1.84 |
| 230889 | 2023-01-17 | $23.23 | First-Class Package Service | 1 | 0.25 lbs | $6.18 | $4.39 | $1.79 |
| 230890 | 2023-01-17 | $33.47 | First-Class Package Service | 7 | 0.60 lbs | $7.63 | $6.68 | $0.95 |
| 230891 | 2023-01-17 | $11.44 | First-Class Package Service - Retail | 1 | 0.03 lbs | $6.70 | $4.26 | $2.44 |
| 230892 | 2023-01-17 | $10.69 | First-Class Package Service | 2 | 0.02 lbs | $5.46 | $4.26 | $1.20 |
| 230893 | 2023-01-17 | $66.11 | Priority Mail Medium Flat Rate Box | 1 | 25.00 lbs | $16.65 | $14.00 | $2.65 |
| 230894 | 2023-01-17 | $10.83 | First-Class Package Service | 1 | 0.18 lbs | $5.59 | $4.39 | $1.20 |
| 230895 | 2023-01-17 | $40.06 | Priority Mail | 2 | 0.90 lbs | $9.84 | $8.30 | $1.54 |
| 230898 | 2023-01-18 | $12.70 | First-Class Package Service | 1 | 0.50 lbs | $7.46 | $6.51 | $0.95 |
| 230900 | 2023-01-18 | $9.33 | USPS Shipping | 1 | 0.03 lbs | $5.23 | $4.26 | $0.97 |
| 230907 | 2023-01-18 | $20.31 | First-Class Package Service | 11 | 0.39 lbs | $5.59 | $4.39 | $1.20 |
| 230908 | 2023-01-18 | $37.25 | First-Class Package Service | 1 | 0.31 lbs | $5.26 | $4.67 | $0.59 |
| 230909 | 2023-01-18 | $63.39 | Priority Mail Flat Rate Envelope | 2 | 2.60 lbs | $9.60 | $8.30 | $1.30 |
| 230910 | 2023-01-19 | $15.55 | First-Class Package Service | 1 | 0.20 lbs | $5.26 | $4.06 | $1.20 |
| 230916 | 2023-01-19 | $11.03 | USPS Shipping | 1 | 0.05 lbs | $5.23 | $3.88 | $1.35 |
| 230917 | 2023-01-19 | $23.34 | First-Class Package Service | 1 | 0.80 lbs | $7.63 | $6.68 | $0.95 |
| 230918 | 2023-01-19 | $18.43 | First-Class Package Service | 4 | 0.20 lbs | $5.47 | $4.27 | $1.20 |
| 230919 | 2023-01-20 | $39.43 | Priority Mail | 9 | 1.44 lbs | $13.52 | $8.30 | $5.22 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |