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 |
|---|---|---|---|---|---|---|---|---|
| 219064 | 2020-12-22 | $63.38 | Priority Mail 2-Day | 2 | 1.95 lbs | $13.40 | $10.89 | $2.51 |
| 219065 | 2020-12-22 | $9.40 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.10 | $3.30 | $-0.20 |
| 219068 | 2020-12-22 | $36.09 | USPSFirstClass | 1 | 0.64 lbs | $7.10 | $8.15 | $-1.05 |
| 219069 | 2020-12-23 | $35.74 | USPSFirstClass | 1 | 0.64 lbs | $6.75 | $4.18 | $2.57 |
| 219070 | 2020-12-22 | $26.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.40 | $8.00 | $0.40 |
| 219071 | 2020-12-22 | $36.89 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.40 lbs | $8.90 | $8.05 | $0.85 |
| 219078 | 2020-12-22 | $60.88 | Priority Mail 2-Day Small Flat Rate Box | 2 | 1.70 lbs | $8.90 | $7.90 | $1.00 |
| 219079 | 2020-12-22 | $16.01 | First-Class Package Service | 1 | 0.30 lbs | $4.22 | $3.69 | $0.53 |
| 219080 | 2020-12-23 | $17.09 | USPSFirstClass | 1 | 0.05 lbs | $4.81 | $3.43 | $1.38 |
| 219081 | 2020-12-22 | $120.69 | Priority Mail 2-Day | 3 | 3.45 lbs | $10.32 | $8.88 | $1.44 |
| 219083 | 2020-12-22 | $49.41 | Priority Mail 2-Day | 3 | 2.40 lbs | $9.84 | $8.00 | $1.84 |
| 219085 | 2020-12-22 | $26.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.40 | $8.00 | $0.40 |
| 219087 | 2020-12-22 | $23.91 | First-Class Package Service | 3 | 0.60 lbs | $6.04 | $4.53 | $1.51 |
| 219088 | 2020-12-23 | $24.66 | USPSFirstClass | 6 | 0.95 lbs | $11.52 | $8.05 | $3.47 |
| 219089 | 2020-12-22 | $1103.63 | Priority Mail 2-Day | 8 | 114.40 lbs | $143.71 | $115.07 | $28.64 |
| 219090 | 2020-12-22 | $13.64 | First-Class Package Service | 4 | 0.63 lbs | $4.88 | $5.65 | $-0.77 |
| 219091 | 2020-12-22 | $92.06 | Priority Mail 2-Day Medium Flat Rate Box | 3 | 3.47 lbs | $14.85 | $13.75 | $1.10 |
| 219092 | 2020-12-23 | $126.34 | Priority Mail 2-Day | 30 | 13.50 lbs | $15.64 | $15.25 | $0.39 |
| 219095 | 2020-12-23 | $18.07 | First-Class Package Service | 2 | 0.38 lbs | $4.09 | $3.18 | $0.91 |
| 219097 | 2020-12-23 | $20.26 | USPSFirstClass | 1 | 0.15 lbs | $4.77 | $3.64 | $1.13 |
| 219098 | 2020-12-23 | $35.89 | First-Class Package Service | 1 | 1.15 lbs | $6.10 | $7.90 | $-1.80 |
| 219099 | 2020-12-23 | $10.99 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.10 | $3.43 | $-0.33 |
| 219101 | 2020-12-23 | $10.53 | First-Class Mail Stamped Letter | 2 | 0.15 lbs | $3.25 | $3.18 | $0.07 |
| 219102 | 2020-12-23 | $47.69 | First-Class Package Service | 4 | 0.25 lbs | $4.09 | $3.18 | $0.91 |
| 219103 | 2020-12-23 | $51.84 | Priority Mail 2-Day Medium Flat Rate Box | 1 | 2.20 lbs | $14.85 | $12.03 | $2.82 |
| 219105 | 2020-12-23 | $22.61 | USPSFirstClass | 3 | 0.81 lbs | $8.24 | $8.52 | $-0.28 |
| 219107 | 2020-12-23 | $28.56 | Ground | 1 | 0.40 lbs | $13.57 | $11.55 | $2.02 |
| 219108 | 2020-12-23 | $20.19 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.40 | $8.05 | $0.35 |
| 219111 | 2020-12-23 | $7.87 | First-Class Package Service | 1 | 0.06 lbs | $3.88 | $3.43 | $0.45 |
| 219112 | 2020-12-23 | $14.42 | USPSFirstClass | 1 | 0.10 lbs | $4.69 | $3.43 | $1.26 |
| 219113 | 2020-11-25 | $339.80 | Pickup From Store | 4 | 28.60 lbs | $19.84 | $30.64 | $-10.80 |
| 219116 | 2020-12-23 | $108.77 | Priority Mail 2-Day | 2 | 5.60 lbs | $10.99 | $10.13 | $0.86 |
| 219118 | 2020-12-23 | $6.35 | First-Class Package Service | 1 | 0.02 lbs | $3.88 | $3.43 | $0.45 |
| 219119 | 2020-12-23 | $26.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.40 | $8.00 | $0.40 |
| 219122 | 2020-12-23 | $6.62 | First-Class Package Service | 1 | 0.05 lbs | $3.63 | $3.18 | $0.45 |
| 219124 | 2020-12-23 | $60.02 | Priority Mail 3-Day Medium Flat Rate Box | 3 | 1.92 lbs | $14.85 | $12.13 | $2.72 |
| 219125 | 2020-12-24 | $30.12 | USPSFirstClass | 2 | 0.90 lbs | $8.54 | $5.37 | $3.17 |
| 219129 | 2020-12-23 | $15.88 | First-Class Package Service | 1 | 0.30 lbs | $4.09 | $3.58 | $0.51 |
| 219130 | 2020-12-23 | $40.06 | Priority Mail 3-Day Small Flat Rate Box | 4 | 0.60 lbs | $8.90 | $8.05 | $0.85 |
| 219131 | 2020-12-23 | $17.92 | First-Class Package Service | 1 | 0.27 lbs | $3.93 | $3.48 | $0.45 |
| 219133 | 2020-12-24 | $9.29 | USPSFirstClass | 1 | 0.06 lbs | $4.30 | $3.30 | $1.00 |
| 219134 | 2020-12-24 | $6.98 | USPSFirstClass | 1 | 0.06 lbs | $4.19 | $3.30 | $0.89 |
| 219135 | 2020-12-24 | $106.63 | Priority Mail 3-Day | 7 | 4.76 lbs | $22.70 | $21.85 | $0.85 |
| 219137 | 2020-12-24 | $9.33 | USPSFirstClass | 1 | 0.05 lbs | $4.44 | $3.43 | $1.01 |
| 219138 | 2020-12-24 | $31.88 | First-Class Package Service | 2 | 0.60 lbs | $6.10 | $5.65 | $0.45 |
| 219143 | 2020-12-24 | $132.25 | Priority Mail 2-Day | 6 | 5.58 lbs | $10.99 | $8.61 | $2.38 |
| 219144 | 2020-12-24 | $36.19 | USPSFirstClass | 1 | 0.64 lbs | $7.20 | $5.95 | $1.25 |
| 219146 | 2020-12-24 | $300.19 | Priority Mail 2-Day Medium Flat Rate Box | 7 | 10.95 lbs | $14.85 | $12.64 | $2.21 |
| 219147 | 2020-12-24 | $8.23 | First-Class Mail Stamped Letter | 2 | 0.17 lbs | $3.25 | $3.67 | $-0.42 |
| 219148 | 2020-12-24 | $10.09 | USPSFirstClass | 1 | 0.16 lbs | $4.10 | $2.99 | $1.11 |
| 219150 | 2020-12-24 | $91.20 | Priority Mail 2-Day Medium Flat Rate Box | 5 | 2.40 lbs | $14.85 | $13.75 | $1.10 |
| 219151 | 2020-12-24 | $109.16 | Priority Mail 3-Day | 3 | 5.85 lbs | $10.99 | $10.13 | $0.86 |
| 219154 | 2020-12-24 | $32.06 | First-Class Package Service | 1 | 0.41 lbs | $5.77 | $4.20 | $1.57 |
| 219155 | 2020-12-24 | $31.45 | First-Class Package Service | 2 | 0.47 lbs | $5.62 | $5.12 | $0.50 |
| 219158 | 2020-12-25 | $12.08 | USPSFirstClass | 2 | 0.10 lbs | $4.10 | $3.03 | $1.07 |
| 219160 | 2020-12-24 | $27.58 | First-Class Package Service | 2 | 0.74 lbs | $6.40 | $4.68 | $1.72 |
| 219161 | 2020-12-24 | $6.53 | First-Class Mail Stamped Letter | 7 | 0.07 lbs | $3.10 | $3.06 | $0.04 |
| 219162 | 2020-12-24 | $7.45 | First-Class Mail Stamped Letter | 1 | 0.08 lbs | $3.10 | $2.93 | $0.17 |
| 219163 | 2020-12-25 | $11.05 | USPSFirstClass | 2 | 0.06 lbs | $4.07 | $3.03 | $1.04 |
| 219165 | 2020-12-25 | $21.20 | USPSFirstClass | 4 | 0.60 lbs | $5.64 | $4.33 | $1.31 |
| 219166 | 2020-12-24 | $4.08 | First-Class Mail Stamped Letter | 2 | 0.04 lbs | $3.10 | $3.18 | $-0.08 |
| 219167 | 2020-12-24 | $9.40 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.10 | $2.93 | $0.17 |
| 219169 | 2020-12-25 | $7.86 | USPSFirstClass | 1 | 0.03 lbs | $4.37 | $3.43 | $0.94 |
| 219170 | 2020-12-25 | $7.98 | USPSFirstClass | 1 | 0.05 lbs | $4.09 | $3.03 | $1.06 |
| 219171 | 2020-12-25 | $93.98 | Priority Mail 2-Day Flat Rate Envelope | 2 | 3.05 lbs | $8.00 | $8.00 | $0.00 |
| 219172 | 2020-12-25 | $10.78 | USPSFirstClass | 1 | 0.39 lbs | $4.99 | $4.25 | $0.74 |
| 219173 | 2020-12-25 | $9.40 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.10 | $3.05 | $0.05 |
| 219174 | 2020-12-25 | $84.33 | Priority Mail 3-Day | 2 | 4.90 lbs | $10.35 | $9.64 | $0.71 |
| 219175 | 2020-12-25 | $80.49 | Priority Mail 2-Day | 10 | 2.46 lbs | $16.59 | $15.74 | $0.85 |
| 219177 | 2020-12-25 | $39.70 | Priority Mail 2-Day | 4 | 1.70 lbs | $8.97 | $8.12 | $0.85 |
| 219178 | 2020-12-25 | $11.13 | USPSFirstClass | 1 | 0.20 lbs | $4.24 | $3.50 | $0.74 |
| 219179 | 2020-12-25 | $9.40 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.10 | $3.05 | $0.05 |
| 219180 | 2020-12-25 | $15.76 | First-Class Package Service | 2 | 0.20 lbs | $3.84 | $3.39 | $0.45 |
| 219181 | 2020-12-26 | $17.31 | USPSFirstClass | 3 | 0.66 lbs | $5.64 | $5.27 | $0.37 |
| 219186 | 2020-12-25 | $388.18 | Ground Home Delivery | 4 | 2.25 lbs | $61.13 | $20.42 | $40.71 |
| 219187 | 2020-12-25 | $35.55 | Priority Mail 2-Day | 1 | 2.14 lbs | $14.34 | $11.13 | $3.21 |
| 219189 | 2020-12-25 | $91.98 | Priority Mail 2-Day Flat Rate Envelope | 2 | 4.19 lbs | $8.00 | $7.75 | $0.25 |
| 219190 | 2020-12-25 | $12.91 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.10 | $3.18 | $-0.08 |
| 219191 | 2020-12-25 | $108.97 | Ground | 2 | 2.95 lbs | $17.69 | $16.87 | $0.82 |
| 219197 | 2020-12-26 | $24.94 | First-Class Package Service | 6 | 0.49 lbs | $5.52 | $4.20 | $1.32 |
| 219198 | 2020-12-26 | $8.67 | USPSFirstClass | 1 | 0.45 lbs | $4.98 | $4.18 | $0.80 |
| 219201 | 2020-12-26 | $34.82 | USPSPriority | 1 | 2.14 lbs | $13.61 | $8.92 | $4.69 |
| 219202 | 2020-12-26 | $51.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.50 | $7.90 | $0.60 |
| 219203 | 2020-12-26 | $30.97 | USPSPriority | 1 | 2.14 lbs | $9.76 | $7.68 | $2.08 |
| 219204 | 2020-12-26 | $13.28 | USPSFirstClass | 1 | 0.04 lbs | $4.49 | $3.05 | $1.44 |
| 219205 | 2020-12-26 | $55.83 | Priority Mail 3-Day | 1 | 1.10 lbs | $10.84 | $10.44 | $0.40 |
| 219206 | 2020-12-26 | $26.32 | First-Class Package Service | 4 | 0.52 lbs | $4.57 | $5.54 | $-0.97 |
| 219207 | 2020-12-26 | $213.56 | Ground | 2 | 17.10 lbs | $45.58 | $41.14 | $4.44 |
| 219208 | 2020-12-26 | $48.83 | Priority Mail 2-Day | 1 | 1.10 lbs | $12.04 | $11.69 | $0.35 |
| 219209 | 2020-12-26 | $9.18 | USPSFirstClass | 1 | 0.04 lbs | $4.29 | $3.05 | $1.24 |
| 219211 | 2020-12-26 | $51.49 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.50 | $7.90 | $0.60 |
| 219213 | 2020-12-26 | $23.67 | First-Class Mail Stamped Letter | 8 | 0.14 lbs | $3.25 | $2.84 | $0.41 |
| 219214 | 2020-12-26 | $18.47 | First-Class Package Service | 3 | 0.04 lbs | $3.50 | $3.05 | $0.45 |
| 219218 | 2020-12-26 | $48.18 | Priority Mail 2-Day | 1 | 1.15 lbs | $11.39 | $11.62 | $-0.23 |
| 219219 | 2020-12-26 | $7.44 | First-Class Package Service | 3 | 0.21 lbs | $3.97 | $3.05 | $0.92 |
| 219221 | 2020-12-26 | $74.80 | Priority Mail 2-Day | 1 | 2.85 lbs | $11.18 | $8.92 | $2.26 |
| 219222 | 2020-12-27 | $14.17 | USPSFirstClass | 1 | 0.10 lbs | $4.44 | $2.84 | $1.60 |
| 219223 | 2020-12-26 | $21.87 | Priority Mail 2-Day | 2 | 0.10 lbs | $9.27 | $7.65 | $1.62 |
| 219224 | 2020-12-26 | $38.61 | First-Class Package Service | 3 | 0.19 lbs | $3.66 | $2.74 | $0.92 |
| 219226 | 2020-12-26 | $9.40 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.10 | $2.93 | $0.17 |
| Total | 21025 order(s) | 59971 | 29292.14 lbs | $193562.51 | $270247.54 | $-76685.03 |