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.21025 matching order(s)
| Order ID ▲ | Date | Order Total | Shipping Method | # Products | Total Weight | Shipping Charged | Shipping Paid | Profit |
|---|---|---|---|---|---|---|---|---|
| 218003 | 2020-11-26 | $46.35 | USPSFirstClass | 5 | 3.04 lbs | $28.40 | $14.56 | $13.84 |
| 218004 | 2020-11-26 | $13.80 | First-Class Package Service | 1 | 0.30 lbs | $4.01 | $3.56 | $0.45 |
| 218007 | 2020-11-26 | $68.36 | Priority Mail 2-Day | 4 | 1.79 lbs | $12.44 | $8.15 | $4.29 |
| 218010 | 2020-11-26 | $24.94 | First-Class Package Service | 1 | 0.35 lbs | $3.95 | $4.12 | $-0.17 |
| 218013 | 2020-11-27 | $22.86 | First-Class Package Service | 1 | 0.65 lbs | $6.20 | $5.95 | $0.25 |
| 218014 | 2020-11-27 | $37.19 | Priority Mail 3-Day Flat Rate Envelope | 1 | 1.00 lbs | $8.40 | $8.05 | $0.35 |
| 218015 | 2020-11-27 | $66.98 | Priority Mail 2-Day Padded Flat Rate Envelope | 2 | 4.60 lbs | $9.00 | $8.15 | $0.85 |
| 218016 | 2020-11-27 | $8.61 | USPSFirstClass | 1 | 0.10 lbs | $4.22 | $3.18 | $1.04 |
| 218017 | 2020-11-27 | $15.80 | First-Class Package Service | 1 | 0.30 lbs | $4.01 | $3.56 | $0.45 |
| 218021 | 2020-11-27 | $54.36 | Priority Mail 3-Day | 1 | 1.20 lbs | $9.37 | $8.24 | $1.13 |
| 218022 | 2020-11-27 | $12.34 | First-Class Mail Stamped Letter | 1 | 0.07 lbs | $3.35 | $3.09 | $0.26 |
| 218023 | 2020-11-27 | $27.59 | First-Class Package Service | 4 | 0.08 lbs | $3.63 | $3.18 | $0.45 |
| 218025 | 2020-11-27 | $20.76 | First-Class Package Service | 1 | 0.60 lbs | $5.77 | $5.52 | $0.25 |
| 218027 | 2020-11-27 | $20.42 | USPSFirstClass | 10 | 0.20 lbs | $5.52 | $4.33 | $1.19 |
| 218031 | 2020-11-27 | $8.25 | First-Class Mail Stamped Letter | 10 | 0.10 lbs | $3.35 | $3.30 | $0.05 |
| 218032 | 2020-11-27 | $51.89 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.90 | $7.90 | $1.00 |
| 218035 | 2020-11-27 | $59.35 | Direct Link International | 3 | 0.59 lbs | $21.68 | $8.78 | $12.90 |
| 218036 | 2020-11-27 | $9.45 | USPSFirstClass | 1 | 0.10 lbs | $4.26 | $3.18 | $1.08 |
| 218037 | 2020-11-27 | $6.61 | USPSFirstClass | 1 | 0.01 lbs | $4.12 | $3.18 | $0.94 |
| 218039 | 2020-11-27 | $6.34 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.30 | $0.05 |
| 218040 | 2020-11-28 | $27.36 | USPSFirstClass | 1 | 0.35 lbs | $5.87 | $3.64 | $2.23 |
| 218042 | 2020-11-27 | $8.00 | First-Class Package Service | 1 | 0.19 lbs | $4.01 | $3.09 | $0.92 |
| 218043 | 2020-11-28 | $28.09 | USPSFirstClass | 1 | 0.15 lbs | $5.15 | $3.18 | $1.97 |
| 218044 | 2020-11-27 | $48.92 | Priority Mail 2-Day Flat Rate Envelope | 4 | 1.21 lbs | $8.40 | $7.90 | $0.50 |
| 218045 | 2020-11-28 | $5.61 | USPSFirstClass | 1 | 0.03 lbs | $4.12 | $3.30 | $0.82 |
| 218046 | 2020-11-27 | $5.87 | First-Class Package Service | 1 | 0.13 lbs | $3.88 | $3.92 | $-0.04 |
| 218048 | 2020-11-28 | $9.44 | USPSFirstClass | 1 | 0.06 lbs | $4.45 | $3.43 | $1.02 |
| 218049 | 2020-11-27 | $8.07 | First-Class Package Service | 2 | 0.38 lbs | $4.09 | $3.18 | $0.91 |
| 218053 | 2020-11-27 | $6.09 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.20 | $3.09 | $0.11 |
| 218055 | 2020-11-28 | $8.47 | USPSFirstClass | 1 | 0.10 lbs | $4.12 | $3.03 | $1.09 |
| 218059 | 2020-11-28 | $27.07 | First-Class Package Service | 1 | 0.40 lbs | $4.88 | $4.43 | $0.45 |
| 218061 | 2020-11-28 | $41.69 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.00 lbs | $8.90 | $7.90 | $1.00 |
| 218062 | 2020-11-28 | $20.38 | First-Class Mail Stamped Letter | 7 | 0.18 lbs | $3.65 | $3.18 | $0.47 |
| 218063 | 2020-11-28 | $15.34 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.30 | $0.05 |
| 218064 | 2020-11-28 | $11.08 | USPSFirstClass | 1 | 0.05 lbs | $4.29 | $3.09 | $1.20 |
| 218065 | 2020-11-28 | $16.17 | USPSFirstClass | 1 | 0.40 lbs | $5.44 | $3.77 | $1.67 |
| 218068 | 2020-11-28 | $24.41 | USPSFirstClass | 4 | 0.24 lbs | $4.45 | $3.92 | $0.53 |
| 218069 | 2020-11-28 | $48.52 | Pickup From Store | 1 | 1.70 lbs | $0.00 | $7.90 | $-7.90 |
| 218070 | 2020-11-28 | $6.61 | USPSFirstClass | 1 | 0.01 lbs | $4.12 | $3.18 | $0.94 |
| 218071 | 2020-11-28 | $11.34 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.18 | $0.17 |
| 218072 | 2020-11-28 | $9.09 | USPSFirstClass | 1 | 0.50 lbs | $5.10 | $4.57 | $0.53 |
| 218073 | 2020-11-28 | $7.97 | First-Class Mail Stamped Letter | 3 | 0.09 lbs | $3.50 | $3.09 | $0.41 |
| 218074 | 2020-11-28 | $48.58 | Priority Mail 2-Day | 1 | 1.15 lbs | $11.79 | $11.01 | $0.78 |
| 218075 | 2020-11-28 | $24.04 | USPSFirstClass | 6 | 0.90 lbs | $12.10 | $8.52 | $3.58 |
| 218077 | 2020-11-28 | $14.43 | First-Class Package Service | 11 | 0.12 lbs | $3.54 | $3.56 | $-0.02 |
| 218079 | 2020-11-28 | $7.74 | First-Class Package Service | 1 | 0.03 lbs | $3.75 | $3.30 | $0.45 |
| 218080 | 2020-11-28 | $7.24 | First-Class Package Service | 1 | 0.03 lbs | $3.75 | $3.30 | $0.45 |
| 218081 | 2020-11-28 | $32.39 | Priority Mail 2-Day Flat Rate Envelope | 1 | 1.00 lbs | $8.40 | $8.00 | $0.40 |
| 218084 | 2020-11-28 | $70.95 | Direct Link International | 7 | 0.85 lbs | $21.52 | $13.12 | $8.40 |
| 218085 | 2020-11-28 | $25.89 | First-Class Package Service | 1 | 0.85 lbs | $6.40 | $5.98 | $0.42 |
| 218086 | 2020-11-28 | $26.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.40 | $8.00 | $0.40 |
| 218089 | 2020-11-28 | $26.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.40 | $8.00 | $0.40 |
| 218093 | 2020-11-28 | $32.06 | First-Class Package Service | 1 | 0.41 lbs | $5.77 | $3.56 | $2.21 |
| 218094 | 2020-11-28 | $18.94 | First-Class Package Service | 1 | 0.24 lbs | $3.95 | $3.50 | $0.45 |
| 218095 | 2020-11-28 | $46.99 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 1.40 lbs | $9.00 | $8.15 | $0.85 |
| 218098 | 2020-11-28 | $96.65 | Priority Mail 2-Day Flat Rate Envelope | 4 | 4.02 lbs | $8.40 | $8.15 | $0.25 |
| 218099 | 2020-11-28 | $22.70 | First-Class Package Service | 1 | 0.65 lbs | $6.04 | $5.79 | $0.25 |
| 218100 | 2020-11-28 | $36.31 | First-Class Package Service | 1 | 0.25 lbs | $4.02 | $3.52 | $0.50 |
| 218101 | 2020-11-29 | $5.76 | USPSFirstClass | 1 | 0.03 lbs | $4.27 | $3.43 | $0.84 |
| 218102 | 2020-11-29 | $21.07 | USPSFirstClass | 2 | 0.40 lbs | $5.29 | $4.57 | $0.72 |
| 218105 | 2020-11-29 | $38.69 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.90 | $8.05 | $0.85 |
| 218106 | 2020-11-29 | $68.37 | Priority Mail 2-Day Flat Rate Envelope | 3 | 1.91 lbs | $8.40 | $7.90 | $0.50 |
| 218107 | 2020-11-29 | $14.67 | First-Class Package Service | 1 | 0.40 lbs | $4.88 | $3.64 | $1.24 |
| 218108 | 2020-11-29 | $48.23 | Priority Mail 3-Day | 1 | 2.13 lbs | $14.74 | $10.88 | $3.86 |
| 218109 | 2020-11-29 | $67.23 | Priority Mail 2-Day | 6 | 1.79 lbs | $10.79 | $9.94 | $0.85 |
| 218110 | 2020-11-29 | $41.08 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.30 lbs | $8.40 | $7.90 | $0.50 |
| 218111 | 2020-11-29 | $74.40 | Priority Mail 3-Day | 3 | 2.30 lbs | $10.79 | $9.64 | $1.15 |
| 218115 | 2020-11-29 | $92.99 | Priority Mail 3-Day | 3 | 2.95 lbs | $10.32 | $8.34 | $1.98 |
| 218116 | 2020-11-29 | $25.43 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.40 | $8.15 | $0.25 |
| 218118 | 2020-11-29 | $193.20 | Priority Mail 2-Day Flat Rate Envelope | 3 | 14.10 lbs | $8.40 | $8.15 | $0.25 |
| 218119 | 2020-11-29 | $27.07 | Priority Mail 3-Day | 1 | 1.78 lbs | $9.84 | $8.15 | $1.69 |
| 218120 | 2020-11-29 | $31.91 | First-Class Package Service | 1 | 0.41 lbs | $5.62 | $3.50 | $2.12 |
| 218121 | 2020-11-29 | $274.41 | Ground | 6 | 21.80 lbs | $42.07 | $29.63 | $12.44 |
| 218123 | 2020-11-29 | $7.19 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.20 | $3.03 | $0.17 |
| 218124 | 2020-11-29 | $54.84 | Priority Mail 3-Day Medium Flat Rate Box | 1 | 1.70 lbs | $14.85 | $13.60 | $1.25 |
| 218125 | 2020-11-29 | $75.88 | Priority Mail 3-Day Small Flat Rate Box | 2 | 1.87 lbs | $8.90 | $8.05 | $0.85 |
| 218128 | 2020-11-29 | $35.76 | First-Class Package Service | 1 | 0.75 lbs | $5.77 | $5.52 | $0.25 |
| 218129 | 2020-11-29 | $154.43 | Priority Mail 2-Day Large Flat Rate Box | 8 | 8.47 lbs | $19.55 | $15.79 | $3.76 |
| 218130 | 2020-11-29 | $26.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.40 | $8.15 | $0.25 |
| 218132 | 2020-11-29 | $52.21 | First-Class Package Service | 1 | 0.25 lbs | $4.22 | $3.77 | $0.45 |
| 218136 | 2020-11-29 | $9.83 | First-Class Mail Stamped Letter | 2 | 0.03 lbs | $3.35 | $3.09 | $0.26 |
| 218137 | 2020-11-29 | $54.36 | Priority Mail 2-Day | 1 | 1.10 lbs | $9.37 | $8.24 | $1.13 |
| 218138 | 2020-11-29 | $6.68 | First-Class Mail Stamped Letter | 2 | 0.04 lbs | $3.20 | $3.30 | $-0.10 |
| 218139 | 2020-11-29 | $18.37 | Priority Mail 3-Day Flat Rate Envelope | 3 | 0.97 lbs | $8.40 | $7.90 | $0.50 |
| 218140 | 2020-11-29 | $34.83 | Priority Mail 3-Day | 1 | 2.62 lbs | $9.84 | $9.47 | $0.37 |
| 218141 | 2020-11-30 | $20.54 | USPSFirstClass | 1 | 0.30 lbs | $5.55 | $3.64 | $1.91 |
| 218146 | 2020-11-30 | $28.04 | USPSFirstClass | 1 | 0.15 lbs | $5.10 | $3.09 | $2.01 |
| 218147 | 2020-11-30 | $32.62 | USPSPriority | 2 | 2.20 lbs | $13.04 | $9.32 | $3.72 |
| 218148 | 2020-11-29 | $14.07 | First-Class Package Service | 2 | 0.23 lbs | $4.09 | $3.64 | $0.45 |
| 218152 | 2020-11-29 | $19.51 | First-Class Package Service | 12 | 0.08 lbs | $3.63 | $2.93 | $0.70 |
| 218154 | 2020-11-29 | $8.54 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.03 | $0.32 |
| 218155 | 2020-11-30 | $13.29 | USPSFirstClass | 1 | 0.31 lbs | $5.30 | $3.77 | $1.53 |
| 218156 | 2020-11-30 | $392.12 | Ground Home Delivery | 6 | 26.29 lbs | $46.08 | $39.91 | $6.17 |
| 218161 | 2020-11-30 | $94.38 | Priority Mail 2-Day Flat Rate Envelope | 2 | 3.05 lbs | $8.40 | $11.42 | $-3.02 |
| 218162 | 2020-11-30 | $232.97 | Ground | 1 | 14.05 lbs | $39.98 | $28.11 | $11.87 |
| 218163 | 2020-11-30 | $6.48 | First-Class Mail Stamped Letter | 2 | 0.10 lbs | $3.50 | $3.30 | $0.20 |
| 218167 | 2020-11-30 | $38.69 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.90 | $8.05 | $0.85 |
| 218168 | 2020-11-30 | $47.63 | Priority Mail 3-Day Padded Flat Rate Envelope | 1 | 1.46 lbs | $9.00 | $8.15 | $0.85 |
| 218169 | 2020-11-30 | $11.02 | USPSFirstClass | 1 | 0.05 lbs | $4.24 | $3.03 | $1.21 |
| 218170 | 2020-11-30 | $18.43 | First-Class Mail Stamped Letter | 7 | 0.09 lbs | $3.50 | $3.77 | $-0.27 |
| Total | 21025 order(s) | 59971 | 29292.14 lbs | $193562.51 | $270247.54 | $-76685.03 |