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 |
|---|---|---|---|---|---|---|---|---|
| 214901 | 2020-08-26 | $39.52 | First-Class Package Service | 3 | 0.67 lbs | $5.95 | $4.46 | $1.49 |
| 214905 | 2020-08-26 | $18.96 | Priority Mail 2-Day | 1 | 0.95 lbs | $8.97 | $8.12 | $0.85 |
| 214908 | 2020-08-26 | $30.29 | First-Class Package Service | 2 | 0.59 lbs | $4.91 | $4.46 | $0.45 |
| 214909 | 2020-08-26 | $268.33 | Ground | 2 | 17.60 lbs | $51.35 | $42.20 | $9.15 |
| 214913 | 2020-08-26 | $9.78 | USPSFirstClass | 1 | 0.05 lbs | $4.19 | $2.84 | $1.35 |
| 214915 | 2020-08-26 | $35.85 | First-Class Package Service | 1 | 0.25 lbs | $3.56 | $3.31 | $0.25 |
| 214917 | 2020-08-26 | $51.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.50 | $7.65 | $0.85 |
| 214919 | 2020-08-26 | $80.78 | Priority Mail 2-Day Flat Rate Envelope | 2 | 2.80 lbs | $8.00 | $7.75 | $0.25 |
| 214920 | 2020-08-26 | $34.95 | Priority Mail 2-Day Small Flat Rate Box | 2 | 1.11 lbs | $8.50 | $7.65 | $0.85 |
| 214921 | 2020-08-26 | $18.96 | Priority Mail 2-Day | 1 | 0.95 lbs | $8.97 | $8.12 | $0.85 |
| 214923 | 2020-08-26 | $8.45 | First-Class Mail Stamped Letter | 5 | 0.13 lbs | $3.50 | $3.18 | $0.32 |
| 214925 | 2020-08-26 | $69.99 | Priority Mail 3-Day | 2 | 1.70 lbs | $14.34 | $13.49 | $0.85 |
| 214926 | 2020-08-26 | $51.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.50 | $7.65 | $0.85 |
| 214927 | 2020-08-26 | $66.46 | Ground | 5 | 5.99 lbs | $21.34 | $19.28 | $2.06 |
| 214930 | 2020-08-26 | $14.18 | First-Class Package Service | 1 | 0.25 lbs | $3.97 | $3.52 | $0.45 |
| 214931 | 2020-08-26 | $51.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.50 | $7.65 | $0.85 |
| 214932 | 2020-08-26 | $7.22 | First-Class Package Service | 1 | 0.05 lbs | $3.23 | $2.78 | $0.45 |
| 214935 | 2020-08-26 | $10.69 | First-Class Package Service | 2 | 0.55 lbs | $5.29 | $5.04 | $0.25 |
| 214936 | 2020-08-27 | $17.84 | USPSFirstClass | 2 | 1.00 lbs | $9.04 | $7.75 | $1.29 |
| 214941 | 2020-08-27 | $74.58 | Priority Mail 2-Day Padded Flat Rate Envelope | 2 | 1.14 lbs | $8.60 | $7.75 | $0.85 |
| 214942 | 2020-08-27 | $12.75 | USPSFirstClass | 1 | 0.05 lbs | $4.39 | $2.93 | $1.46 |
| 214944 | 2020-08-27 | $8.69 | First-Class Package Service | 1 | 0.05 lbs | $3.50 | $3.05 | $0.45 |
| 214945 | 2020-08-27 | $44.78 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.80 lbs | $8.00 | $7.75 | $0.25 |
| 214947 | 2020-08-27 | $145.44 | Ground Home Delivery | 1 | 12.90 lbs | $35.45 | $30.28 | $5.17 |
| 214948 | 2020-08-27 | $9.65 | USPSFirstClass | 1 | 0.03 lbs | $4.24 | $2.93 | $1.31 |
| 214949 | 2020-08-27 | $20.83 | Priority Mail 2-Day | 1 | 0.95 lbs | $10.84 | $9.99 | $0.85 |
| 214951 | 2020-08-27 | $23.26 | First-Class Package Service | 1 | 0.45 lbs | $4.77 | $4.32 | $0.45 |
| 214952 | 2020-08-27 | $237.97 | Ground | 1 | 14.05 lbs | $44.98 | $31.07 | $13.91 |
| 214953 | 2020-08-27 | $20.16 | USPSFirstClass | 1 | 0.95 lbs | $8.95 | $9.99 | $-1.04 |
| 214955 | 2020-08-27 | $28.32 | Priority Mail 3-Day | 2 | 1.11 lbs | $12.04 | $11.19 | $0.85 |
| 214956 | 2020-08-27 | $15.14 | USPSFirstClass | 2 | 0.20 lbs | $4.25 | $2.93 | $1.32 |
| 214957 | 2020-08-27 | $14.21 | First-Class Package Service | 4 | 0.50 lbs | $4.25 | $3.25 | $1.00 |
| 214959 | 2020-08-27 | $40.68 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.25 lbs | $8.00 | $7.90 | $0.10 |
| 214960 | 2020-08-28 | $19.02 | USPSFirstClass | 1 | 0.05 lbs | $4.70 | $3.05 | $1.65 |
| 214962 | 2020-08-27 | $34.73 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.50 | $7.65 | $0.85 |
| 214965 | 2020-08-27 | $54.19 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.65 lbs | $8.50 | $7.65 | $0.85 |
| 214966 | 2020-08-27 | $56.88 | Priority Mail 3-Day | 1 | 1.15 lbs | $11.39 | $10.54 | $0.85 |
| 214970 | 2020-08-28 | $18.07 | First-Class Package Service | 5 | 0.30 lbs | $4.12 | $3.67 | $0.45 |
| 214972 | 2020-08-28 | $13.50 | USPSFirstClass | 1 | 0.05 lbs | $4.59 | $3.18 | $1.41 |
| 214973 | 2020-08-28 | $12.04 | USPSFirstClass | 1 | 0.20 lbs | $4.43 | $3.05 | $1.38 |
| 214975 | 2020-08-28 | $35.67 | Priority Mail 3-Day | 12 | 2.33 lbs | $10.39 | $8.92 | $1.47 |
| 214976 | 2020-08-28 | $89.81 | Priority Mail 3-Day Medium Flat Rate Box | 4 | 2.95 lbs | $14.45 | $13.75 | $0.70 |
| 214977 | 2020-08-28 | $22.19 | USPSFirstClass | 1 | 0.30 lbs | $5.65 | $3.52 | $2.13 |
| 214979 | 2020-08-28 | $51.49 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.50 | $7.65 | $0.85 |
| 214982 | 2020-08-28 | $76.98 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.51 lbs | $8.00 | $7.75 | $0.25 |
| 214983 | 2020-08-28 | $28.13 | USPSFirstClass | 1 | 0.45 lbs | $5.75 | $4.00 | $1.75 |
| 214984 | 2020-08-28 | $10.89 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.10 lbs | $8.00 | $7.65 | $0.35 |
| 214985 | 2020-08-28 | $8.29 | First-Class Mail Stamped Letter | 6 | 0.06 lbs | $3.35 | $3.05 | $0.30 |
| 214986 | 2020-08-28 | $374.08 | Priority Mail 2-Day | 6 | 17.17 lbs | $25.14 | $26.11 | $-0.97 |
| 214990 | 2020-08-28 | $7.22 | First-Class Package Service | 1 | 0.05 lbs | $3.23 | $2.78 | $0.45 |
| 214991 | 2020-08-28 | $7.31 | First-Class Package Service | 3 | 0.21 lbs | $3.84 | $2.93 | $0.91 |
| 214993 | 2020-08-28 | $42.83 | Priority Mail 3-Day | 1 | 0.70 lbs | $10.84 | $9.99 | $0.85 |
| 214994 | 2020-08-28 | $32.81 | USPSFirstClass | 1 | 0.30 lbs | $6.25 | $3.67 | $2.58 |
| 214995 | 2020-08-28 | $64.23 | Priority Mail 2-Day | 1 | 3.95 lbs | $10.24 | $9.39 | $0.85 |
| 214997 | 2020-08-28 | $31.07 | Ground | 2 | 1.05 lbs | $8.79 | $11.33 | $-2.54 |
| 214998 | 2020-08-28 | $20.88 | USPSFirstClass | 1 | 0.95 lbs | $8.96 | $9.99 | $-1.03 |
| 214999 | 2020-08-28 | $66.18 | Priority Mail 2-Day Padded Flat Rate Envelope | 2 | 2.30 lbs | $8.60 | $8.15 | $0.45 |
| 215000 | 2020-08-28 | $234.43 | Priority Mail 2-Day Medium Flat Rate Box | 2 | 16.00 lbs | $14.45 | $14.25 | $0.20 |
| 215001 | 2020-08-28 | $52.58 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.50 lbs | $8.00 | $7.90 | $0.10 |
| 215003 | 2020-08-28 | $21.99 | First-Class Package Service | 1 | 0.25 lbs | $3.70 | $3.25 | $0.45 |
| 215008 | 2020-08-28 | $38.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.50 | $7.65 | $0.85 |
| 215011 | 2020-08-28 | $38.29 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.50 | $7.65 | $0.85 |
| 215014 | 2020-08-29 | $8.92 | USPSFirstClass | 1 | 0.05 lbs | $4.22 | $2.93 | $1.29 |
| 215015 | 2020-08-29 | $51.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.45 lbs | $8.50 | $7.65 | $0.85 |
| 215017 | 2020-08-29 | $63.52 | Priority Mail 3-Day | 2 | 1.63 lbs | $12.04 | $7.65 | $4.39 |
| 215019 | 2020-08-29 | $30.42 | Priority Mail 3-Day | 5 | 0.70 lbs | $9.00 | $7.65 | $1.35 |
| 215020 | 2020-08-29 | $67.58 | Priority Mail 2-Day Flat Rate Envelope | 2 | 2.35 lbs | $8.00 | $7.75 | $0.25 |
| 215022 | 2020-08-29 | $26.09 | Priority Mail 3-Day | 1 | 0.90 lbs | $9.61 | $7.75 | $1.86 |
| 215024 | 2020-08-29 | $10.73 | USPSFirstClass | 1 | 0.04 lbs | $4.30 | $2.93 | $1.37 |
| 215028 | 2020-08-29 | $8.94 | First-Class Package Service | 3 | 0.22 lbs | $3.97 | $3.52 | $0.45 |
| 215030 | 2020-08-29 | $82.58 | Priority Mail 2-Day Padded Flat Rate Envelope | 2 | 4.41 lbs | $8.60 | $7.75 | $0.85 |
| 215033 | 2020-08-29 | $7.11 | USPSFirstClass | 1 | 0.05 lbs | $4.04 | $2.78 | $1.26 |
| 215037 | 2020-08-29 | $10.26 | First-Class Package Service | 1 | 0.20 lbs | $3.97 | $3.05 | $0.92 |
| 215038 | 2020-08-29 | $56.56 | Priority Mail 3-Day | 2 | 2.10 lbs | $10.39 | $8.92 | $1.47 |
| 215042 | 2020-08-29 | $70.87 | Priority Mail 3-Day | 3 | 1.85 lbs | $13.00 | $10.42 | $2.58 |
| 215043 | 2020-08-29 | $21.70 | First-Class Package Service | 1 | 0.45 lbs | $4.91 | $7.65 | $-2.74 |
| 215045 | 2020-08-29 | $28.72 | Priority Mail 2-Day | 1 | 0.35 lbs | $8.83 | $7.65 | $1.18 |
| 215046 | 2020-08-29 | $210.05 | Priority Mail 3-Day | 1 | 14.05 lbs | $35.25 | $31.50 | $3.75 |
| 215047 | 2020-08-29 | $7.34 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.05 | $0.30 |
| 215048 | 2020-08-29 | $12.39 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.07 lbs | $8.00 | $7.15 | $0.85 |
| 215049 | 2020-08-29 | $25.90 | First-Class Package Service | 1 | 0.40 lbs | $4.91 | $4.46 | $0.45 |
| 215050 | 2020-08-29 | $26.96 | First-Class Package Service | 1 | 0.45 lbs | $4.77 | $4.32 | $0.45 |
| 215051 | 2020-08-29 | $23.29 | First-Class Package Service | 4 | 0.41 lbs | $4.33 | $3.31 | $1.02 |
| 215052 | 2020-08-29 | $6.14 | First-Class Mail Stamped Letter | 1 | 0.06 lbs | $3.35 | $2.93 | $0.42 |
| 215054 | 2020-08-29 | $56.38 | Priority Mail 2-Day | 1 | 1.10 lbs | $11.39 | $10.54 | $0.85 |
| 215055 | 2020-08-29 | $24.24 | Priority Mail 2-Day | 7 | 1.40 lbs | $9.61 | $8.92 | $0.69 |
| 215056 | 2020-08-29 | $21.24 | First-Class Package Service | 1 | 0.45 lbs | $4.45 | $4.00 | $0.45 |
| 215057 | 2020-08-29 | $22.24 | USPSFirstClass | 2 | 0.77 lbs | $9.14 | $10.53 | $-1.39 |
| 215058 | 2020-08-29 | $6.41 | First-Class Package Service | 2 | 0.02 lbs | $3.23 | $2.78 | $0.45 |
| 215059 | 2020-08-29 | $87.31 | Priority Mail 2-Day | 1 | 4.40 lbs | $19.32 | $16.14 | $3.18 |
| 215062 | 2020-08-29 | $26.64 | First-Class Package Service | 1 | 0.45 lbs | $4.45 | $4.00 | $0.45 |
| 215064 | 2020-08-30 | $9.14 | USPSFirstClass | 1 | 0.05 lbs | $4.22 | $2.93 | $1.29 |
| 215065 | 2020-08-29 | $11.29 | First-Class Package Service | 1 | 0.15 lbs | $3.50 | $3.52 | $-0.02 |
| 215066 | 2020-08-29 | $8.81 | First-Class Package Service | 2 | 0.38 lbs | $4.63 | $4.18 | $0.45 |
| 215067 | 2020-08-30 | $41.25 | InternationalPriorityShipping | 1 | 0.15 lbs | $4.95 | $3.52 | $1.43 |
| 215070 | 2020-08-29 | $154.44 | Priority Mail 2-Day Medium Flat Rate Box | 1 | 12.88 lbs | $14.45 | $13.20 | $1.25 |
| 215071 | 2020-08-29 | $8.57 | First-Class Package Service | 1 | 0.05 lbs | $3.38 | $2.93 | $0.45 |
| 215073 | 2020-08-30 | $42.58 | Priority Mail 2-Day Padded Flat Rate Envelope | 2 | 1.18 lbs | $8.60 | $7.65 | $0.95 |
| 215074 | 2020-08-30 | $36.36 | InternationalPriorityShipping | 1 | 0.35 lbs | $5.49 | $4.32 | $1.17 |
| 215076 | 2020-08-30 | $21.56 | First-Class Package Service | 1 | 0.45 lbs | $4.77 | $4.57 | $0.20 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |