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 |
|---|---|---|---|---|---|---|---|---|
| 219227 | 2020-12-26 | $17.68 | First-Class Package Service | 2 | 0.38 lbs | $3.70 | $2.78 | $0.92 |
| 219228 | 2020-12-26 | $30.31 | Priority Mail 2-Day | 3 | 1.11 lbs | $10.84 | $7.65 | $3.19 |
| 219229 | 2020-12-26 | $253.42 | Ground | 1 | 13.15 lbs | $43.43 | $32.58 | $10.85 |
| 219230 | 2020-12-26 | $47.88 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.45 lbs | $8.00 | $7.65 | $0.35 |
| 219233 | 2020-12-26 | $28.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.05 lbs | $8.50 | $8.15 | $0.35 |
| 219238 | 2020-12-27 | $29.34 | Priority Mail 3-Day | 5 | 1.25 lbs | $11.39 | $11.13 | $0.26 |
| 219239 | 2020-12-27 | $72.75 | Priority Mail 3-Day | 10 | 4.31 lbs | $10.35 | $9.39 | $0.96 |
| 219240 | 2020-12-27 | $8.44 | First-Class Mail Stamped Letter | 1 | 0.15 lbs | $3.25 | $2.84 | $0.41 |
| 219241 | 2020-12-27 | $81.10 | FedExHomeDelivery | 1 | 2.85 lbs | $17.48 | $17.37 | $0.11 |
| 219243 | 2020-12-27 | $8.77 | USPSFirstClass | 1 | 0.10 lbs | $4.42 | $3.18 | $1.24 |
| 219245 | 2020-12-27 | $15.49 | First-Class Package Service | 1 | 0.30 lbs | $3.70 | $3.51 | $0.19 |
| 219246 | 2020-12-27 | $23.80 | First-Class Package Service | 5 | 0.20 lbs | $3.46 | $3.21 | $0.25 |
| 219248 | 2020-12-27 | $109.68 | Priority Mail 3-Day | 23 | 9.85 lbs | $27.81 | $30.03 | $-2.22 |
| 219249 | 2020-12-27 | $27.49 | USPSFirstClass | 1 | 0.20 lbs | $5.02 | $3.25 | $1.77 |
| 219250 | 2020-12-27 | $14.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.19 lbs | $8.00 | $7.56 | $0.44 |
| 219251 | 2020-12-27 | $26.39 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.00 | $8.00 | $0.00 |
| 219254 | 2020-12-27 | $51.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.50 | $7.90 | $0.60 |
| 219255 | 2020-12-27 | $5.04 | USPSFirstClass | 1 | 0.01 lbs | $4.05 | $2.93 | $1.12 |
| 219257 | 2020-12-27 | $26.39 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.00 | $8.00 | $0.00 |
| 219259 | 2020-12-27 | $41.98 | Priority Mail 3-Day Flat Rate Envelope | 2 | 2.00 lbs | $8.00 | $7.65 | $0.35 |
| 219260 | 2020-12-27 | $42.27 | USPSPriority | 1 | 2.14 lbs | $21.06 | $7.75 | $13.31 |
| 219262 | 2020-12-27 | $38.50 | Direct Link International | 3 | 0.69 lbs | $20.63 | $10.34 | $10.29 |
| 219265 | 2020-12-28 | $22.24 | USPSPriority | 1 | 1.00 lbs | $8.68 | $8.12 | $0.56 |
| 219266 | 2020-12-28 | $10.67 | USPSFirstClass | 2 | 0.50 lbs | $4.89 | $4.08 | $0.81 |
| 219269 | 2020-12-27 | $15.85 | Priority Mail 2-Day | 2 | 0.08 lbs | $7.87 | $7.02 | $0.85 |
| 219274 | 2020-12-27 | $63.28 | Priority Mail 3-Day Small Flat Rate Box | 2 | 1.50 lbs | $8.50 | $7.90 | $0.60 |
| 219276 | 2020-12-27 | $30.19 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.40 lbs | $8.00 | $3.51 | $4.49 |
| 219278 | 2020-12-27 | $94.58 | Priority Mail 2-Day Padded Flat Rate Envelope | 2 | 4.88 lbs | $8.60 | $7.75 | $0.85 |
| 219279 | 2020-12-27 | $9.68 | First-Class Package Service | 1 | 0.05 lbs | $3.38 | $2.93 | $0.45 |
| 219280 | 2020-12-28 | $15.91 | First-Class Package Service | 1 | 0.30 lbs | $4.12 | $4.46 | $-0.34 |
| 219281 | 2020-12-28 | $15.08 | First-Class Mail Stamped Letter | 2 | 0.04 lbs | $3.10 | $3.18 | $-0.08 |
| 219282 | 2020-12-28 | $7.14 | USPSFirstClass | 1 | 0.05 lbs | $4.15 | $2.93 | $1.22 |
| 219283 | 2020-12-28 | $51.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.50 | $7.90 | $0.60 |
| 219285 | 2020-12-28 | $11.34 | USPSFirstClass | 1 | 0.19 lbs | $4.35 | $2.93 | $1.42 |
| 219286 | 2020-12-28 | $40.94 | USPSFirstClass | 4 | 1.20 lbs | $13.38 | $8.12 | $5.26 |
| 219287 | 2020-12-28 | $27.89 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.05 lbs | $8.50 | $7.90 | $0.60 |
| 219288 | 2020-12-28 | $35.94 | USPSFirstClass | 1 | 0.64 lbs | $6.95 | $4.18 | $2.77 |
| 219289 | 2020-12-28 | $8.56 | USPSFirstClass | 1 | 0.40 lbs | $5.17 | $4.46 | $0.71 |
| 219290 | 2020-12-28 | $44.78 | First-Class Package Service | 1 | 0.72 lbs | $5.79 | $5.81 | $-0.02 |
| 219291 | 2020-12-28 | $12.07 | First-Class Mail Stamped Letter | 3 | 0.10 lbs | $3.10 | $3.35 | $-0.25 |
| 219292 | 2020-12-28 | $101.36 | Priority Mail 2-Day | 3 | 2.80 lbs | $16.59 | $8.00 | $8.59 |
| 219293 | 2020-12-28 | $10.39 | First-Class Mail Stamped Letter | 1 | 0.19 lbs | $3.40 | $3.05 | $0.35 |
| 219294 | 2020-12-28 | $18.92 | USPSFirstClass | 2 | 0.40 lbs | $5.14 | $5.40 | $-0.26 |
| 219299 | 2020-12-28 | $14.30 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.05 lbs | $8.00 | $7.65 | $0.35 |
| 219300 | 2020-12-28 | $57.55 | Priority Mail 2-Day Padded Flat Rate Envelope | 5 | 1.65 lbs | $8.60 | $15.80 | $-7.20 |
| 219301 | 2020-12-28 | $51.49 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.50 | $7.90 | $0.60 |
| 219302 | 2020-12-28 | $51.49 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.45 lbs | $8.50 | $7.90 | $0.60 |
| 219303 | 2020-12-29 | $15.77 | USPSFirstClass | 2 | 0.80 lbs | $8.19 | $8.12 | $0.07 |
| 219304 | 2020-12-28 | $28.03 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.00 | $8.00 | $0.00 |
| 219305 | 2020-12-29 | $16.33 | USPSFirstClass | 1 | 0.45 lbs | $5.54 | $4.46 | $1.08 |
| 219307 | 2020-12-28 | $47.95 | Priority Mail 2-Day | 10 | 1.01 lbs | $10.39 | $8.85 | $1.54 |
| 219308 | 2020-12-28 | $6.93 | First-Class Mail Stamped Letter | 2 | 0.04 lbs | $2.95 | $3.18 | $-0.23 |
| 219310 | 2020-12-28 | $8.95 | First-Class Package Service | 2 | 0.40 lbs | $4.77 | $3.52 | $1.25 |
| 219311 | 2020-12-28 | $3.44 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $2.95 | $3.05 | $-0.10 |
| 219312 | 2020-12-29 | $28.68 | USPSPriority | 1 | 1.70 lbs | $10.79 | $8.12 | $2.67 |
| 219313 | 2020-12-28 | $22.70 | First-Class Mail Stamped Letter | 1 | 0.18 lbs | $3.40 | $3.18 | $0.22 |
| 219314 | 2020-12-28 | $38.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.50 | $7.90 | $0.60 |
| 219315 | 2020-12-28 | $11.28 | First-Class Package Service | 1 | 0.05 lbs | $3.29 | $2.84 | $0.45 |
| 219317 | 2020-12-29 | $11.12 | USPSFirstClass | 1 | 0.05 lbs | $4.34 | $2.93 | $1.41 |
| 219319 | 2020-12-28 | $26.39 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.00 | $8.00 | $0.00 |
| 219322 | 2020-12-28 | $45.87 | Priority Mail 3-Day Flat Rate Envelope | 3 | 1.35 lbs | $8.00 | $7.90 | $0.10 |
| 219325 | 2020-12-28 | $12.29 | First-Class Mail Stamped Letter | 1 | 0.06 lbs | $3.10 | $2.78 | $0.32 |
| 219326 | 2020-12-28 | $46.40 | Priority Mail 2-Day | 1 | 1.15 lbs | $9.61 | $9.12 | $0.49 |
| 219330 | 2020-12-29 | $25.50 | USPSFirstClass | 3 | 1.20 lbs | $14.13 | $10.53 | $3.60 |
| 219331 | 2020-12-29 | $18.87 | USPSFirstClass | 2 | 0.40 lbs | $5.09 | $5.27 | $-0.18 |
| 219332 | 2020-12-29 | $7.69 | First-Class Package Service | 8 | 0.10 lbs | $3.77 | $3.72 | $0.05 |
| 219333 | 2020-12-29 | $9.50 | USPSFirstClass | 1 | 0.15 lbs | $4.31 | $3.05 | $1.26 |
| 219336 | 2020-12-29 | $11.54 | USPSFirstClass | 1 | 0.19 lbs | $4.55 | $3.18 | $1.37 |
| 219337 | 2020-12-29 | $82.83 | Priority Mail 3-Day | 20 | 5.40 lbs | $25.03 | $21.45 | $3.58 |
| 219338 | 2020-12-01 | $274.72 | Priority Mail 3-Day | 3 | 14.25 lbs | $49.94 | $53.04 | $-3.10 |
| 219341 | 2020-12-29 | $4.29 | First-Class Mail Stamped Letter | 1 | 0.06 lbs | $3.10 | $2.84 | $0.26 |
| 219342 | 2020-12-29 | $14.00 | First-Class Mail Stamped Letter | 1 | 0.06 lbs | $3.10 | $2.93 | $0.17 |
| 219343 | 2020-12-29 | $14.27 | USPSFirstClass | 1 | 0.10 lbs | $4.54 | $3.05 | $1.49 |
| 219344 | 2020-12-29 | $54.60 | Priority Mail 2-Day | 1 | 1.45 lbs | $9.61 | $8.92 | $0.69 |
| 219347 | 2020-12-29 | $36.59 | Priority Mail 3-Day Padded Flat Rate Envelope | 1 | 1.20 lbs | $8.60 | $7.65 | $0.95 |
| 219348 | 2020-12-29 | $9.93 | First-Class Package Service | 1 | 0.05 lbs | $3.63 | $3.18 | $0.45 |
| 219350 | 2020-12-29 | $9.74 | First-Class Mail Stamped Letter | 1 | 0.02 lbs | $2.95 | $2.84 | $0.11 |
| 219351 | 2020-12-29 | $24.49 | Priority Mail 2-Day | 2 | 0.11 lbs | $9.00 | $8.15 | $0.85 |
| 219352 | 2020-12-29 | $29.26 | USPSFirstClass | 3 | 0.90 lbs | $8.59 | $7.75 | $0.84 |
| 219353 | 2020-12-29 | $46.65 | Priority Mail 2-Day | 2 | 1.50 lbs | $8.97 | $8.24 | $0.73 |
| 219354 | 2020-12-30 | $18.26 | USPSFirstClass | 2 | 0.10 lbs | $8.48 | $2.93 | $5.55 |
| 219355 | 2020-12-30 | $19.03 | USPSFirstClass | 2 | 0.38 lbs | $5.05 | $2.78 | $2.27 |
| 219356 | 2020-12-29 | $15.66 | First-Class Package Service | 4 | 0.16 lbs | $3.19 | $2.74 | $0.45 |
| 219358 | 2020-12-29 | $29.36 | Priority Mail 2-Day Flat Rate Envelope | 4 | 1.02 lbs | $8.00 | $8.00 | $0.00 |
| 219360 | 2020-12-29 | $24.66 | First-Class Package Service | 1 | 0.65 lbs | $5.37 | $5.27 | $0.10 |
| 219364 | 2020-12-30 | $6.14 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.25 | $3.05 | $0.20 |
| 219367 | 2020-12-30 | $11.68 | First-Class Package Service | 2 | 0.20 lbs | $3.70 | $2.78 | $0.92 |
| 219368 | 2020-12-30 | $35.72 | First-Class Package Service | 1 | 0.20 lbs | $4.12 | $3.67 | $0.45 |
| 219372 | 2020-12-30 | $96.12 | Priority Mail 3-Day Medium Flat Rate Box | 3 | 3.10 lbs | $14.45 | $12.64 | $1.81 |
| 219375 | 2020-12-30 | $7.56 | USPSFirstClass | 1 | 0.04 lbs | $4.07 | $2.78 | $1.29 |
| 219376 | 2020-12-30 | $57.93 | Priority Mail 3-Day | 12 | 1.03 lbs | $8.69 | $7.84 | $0.85 |
| 219378 | 2020-12-30 | $14.31 | Priority Mail 2-Day | 1 | 0.91 lbs | $9.61 | $7.88 | $1.73 |
| 219380 | 2020-12-30 | $17.30 | USPSFirstClass | 1 | 0.29 lbs | $5.59 | $4.46 | $1.13 |
| 219381 | 2020-12-30 | $28.29 | USPSFirstClass | 1 | 0.15 lbs | $5.35 | $3.67 | $1.68 |
| 219385 | 2020-12-30 | $70.98 | Priority Mail 2-Day | 1 | 3.95 lbs | $16.99 | $16.87 | $0.12 |
| 219389 | 2020-12-30 | $8.43 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $2.95 | $2.74 | $0.21 |
| 219390 | 2020-12-30 | $81.75 | Priority Mail 3-Day | 5 | 2.71 lbs | $13.00 | $9.98 | $3.02 |
| 219391 | 2020-12-30 | $7.08 | USPSFirstClass | 1 | 0.10 lbs | $4.19 | $3.05 | $1.14 |
| 219392 | 2020-12-30 | $18.98 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 219395 | 2020-12-30 | $18.83 | First-Class Package Service | 1 | 0.19 lbs | $3.84 | $3.39 | $0.45 |
| Total | 21025 order(s) | 59971 | 29292.14 lbs | $193562.51 | $270247.54 | $-76685.03 |