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 |
|---|---|---|---|---|---|---|---|---|
| 211238 | 2020-04-16 | $19.19 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 0.37 lbs | $8.60 | $7.65 | $0.95 |
| 211239 | 2020-04-16 | $51.76 | Priority Mail 3-Day Padded Flat Rate Envelope | 4 | 1.80 lbs | $8.60 | $7.75 | $0.85 |
| 211240 | 2020-04-16 | $32.08 | Priority Mail 2-Day Small Flat Rate Box | 2 | 0.60 lbs | $8.50 | $7.65 | $0.85 |
| 211241 | 2020-04-16 | $153.02 | Priority Mail 2-Day | 1 | 12.90 lbs | $43.03 | $42.18 | $0.85 |
| 211242 | 2020-04-16 | $23.86 | First-Class Package Service | 1 | 0.60 lbs | $4.57 | $4.32 | $0.25 |
| 211243 | 2020-04-16 | $9.03 | First-Class Mail Stamped Letter | 2 | 0.16 lbs | $3.65 | $2.78 | $0.87 |
| 211244 | 2020-04-16 | $42.90 | Priority Mail 2-Day Flat Rate Envelope | 10 | 0.50 lbs | $8.00 | $7.80 | $0.20 |
| 211245 | 2020-04-16 | $59.51 | Priority Mail 3-Day | 3 | 1.82 lbs | $14.34 | $10.53 | $3.81 |
| 211246 | 2020-04-16 | $12.32 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.50 | $2.84 | $0.66 |
| 211247 | 2020-04-16 | $33.96 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.15 lbs | $8.50 | $7.65 | $0.85 |
| 211248 | 2020-04-16 | $37.97 | Priority Mail 2-Day | 3 | 0.89 lbs | $9.00 | $7.65 | $1.35 |
| 211249 | 2020-04-16 | $27.11 | Priority Mail 3-Day Small Flat Rate Box | 2 | 0.45 lbs | $8.50 | $7.65 | $0.85 |
| 211250 | 2020-04-16 | $136.13 | Priority Mail 3-Day | 2 | 9.95 lbs | $15.35 | $14.50 | $0.85 |
| 211251 | 2020-04-16 | $22.73 | Priority Mail 3-Day | 6 | 1.20 lbs | $11.39 | $10.53 | $0.86 |
| 211252 | 2020-04-16 | $8.54 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.84 | $0.51 |
| 211253 | 2020-04-16 | $29.68 | Priority Mail 2-Day Small Flat Rate Box | 2 | 0.74 lbs | $8.50 | $7.65 | $0.85 |
| 211255 | 2020-04-16 | $13.72 | First-Class Package Service | 4 | 0.14 lbs | $3.76 | $3.31 | $0.45 |
| 211256 | 2020-03-18 | $200.60 | Ground | 10 | 9.50 lbs | $0.00 | $28.63 | $-28.63 |
| 211257 | 2020-03-18 | $200.60 | Ground | 10 | 9.50 lbs | $0.00 | $28.63 | $-28.63 |
| 211258 | 2020-03-18 | $266.88 | Ground | 8 | 11.20 lbs | $0.00 | $29.30 | $-29.30 |
| 211259 | 2020-03-18 | $200.16 | Ground | 6 | 8.40 lbs | $0.00 | $25.81 | $-25.81 |
| 211261 | 2020-04-16 | $75.00 | Priority Mail 2-Day | 1 | 3.50 lbs | $15.01 | $16.14 | $-1.13 |
| 211264 | 2020-04-16 | $13.68 | Priority Mail 2-Day Small Flat Rate Box | 2 | 0.24 lbs | $8.50 | $7.65 | $0.85 |
| 211265 | 2020-04-16 | $19.58 | Priority Mail 2-Day | 3 | 0.85 lbs | $9.61 | $8.76 | $0.85 |
| 211266 | 2020-04-16 | $76.90 | Priority Mail 2-Day | 1 | 3.50 lbs | $16.91 | $16.06 | $0.85 |
| 211267 | 2020-04-16 | $39.76 | Priority Mail 3-Day | 2 | 1.60 lbs | $9.61 | $8.76 | $0.85 |
| 211268 | 2020-04-16 | $129.61 | Ground | 1 | 19.40 lbs | $34.62 | $31.97 | $2.65 |
| 211269 | 2020-04-16 | $51.28 | Priority Mail 3-Day Small Flat Rate Box | 2 | 1.62 lbs | $8.50 | $7.65 | $0.85 |
| 211270 | 2020-04-16 | $23.35 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.25 lbs | $8.00 | $7.65 | $0.35 |
| 211271 | 2020-04-17 | $28.29 | Priority Mail 2-Day | 1 | 0.60 lbs | $9.00 | $8.15 | $0.85 |
| 211272 | 2020-04-17 | $75.19 | Priority Mail 2-Day | 4 | 2.03 lbs | $14.34 | $11.13 | $3.21 |
| 211273 | 2020-04-17 | $12.64 | First-Class Mail Stamped Letter | 1 | 0.06 lbs | $3.35 | $2.93 | $0.42 |
| 211279 | 2020-04-17 | $20.92 | Priority Mail 2-Day | 5 | 1.50 lbs | $8.97 | $8.12 | $0.85 |
| 211280 | 2020-04-17 | $19.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.35 lbs | $8.00 | $7.65 | $0.35 |
| 211281 | 2020-04-17 | $15.98 | Priority Mail 3-Day Flat Rate Envelope | 2 | 0.20 lbs | $8.00 | $7.15 | $0.85 |
| 211283 | 2020-04-17 | $49.58 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.60 lbs | $8.00 | $7.65 | $0.35 |
| 211284 | 2020-04-17 | $70.22 | Priority Mail 2-Day | 7 | 1.01 lbs | $12.04 | $7.75 | $4.29 |
| 211285 | 2020-04-17 | $5.65 | First-Class Mail Stamped Letter | 5 | 0.05 lbs | $3.20 | $2.93 | $0.27 |
| 211287 | 2020-04-17 | $12.84 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.18 | $0.17 |
| 211289 | 2020-04-17 | $6.24 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.84 | $0.51 |
| 211292 | 2020-04-17 | $14.79 | First-Class Package Service | 2 | 0.28 lbs | $5.37 | $4.00 | $1.37 |
| 211294 | 2020-04-10 | $51.66 | Priority Mail 2-Day Small Flat Rate Box | 3 | 1.30 lbs | $14.99 | $8.76 | $6.23 |
| 211297 | 2020-04-17 | $10.64 | First-Class Mail Stamped Letter | 1 | 0.19 lbs | $3.65 | $2.93 | $0.72 |
| 211308 | 2020-04-17 | $16.93 | First-Class Package Service | 2 | 0.45 lbs | $4.25 | $4.00 | $0.25 |
| 211309 | 2020-04-17 | $50.17 | Priority Mail 2-Day Small Flat Rate Box | 18 | 0.57 lbs | $11.85 | $7.65 | $4.20 |
| 211310 | 2020-04-17 | $14.32 | First-Class Package Service | 1 | 0.50 lbs | $4.43 | $4.18 | $0.25 |
| 211311 | 2020-04-17 | $52.82 | Priority Mail 3-Day Flat Rate Envelope | 18 | 0.94 lbs | $8.00 | $7.65 | $0.35 |
| 211313 | 2020-04-17 | $88.86 | Ground | 16 | 4.54 lbs | $21.36 | $18.86 | $2.50 |
| 211316 | 2020-04-17 | $65.62 | Priority Mail 2-Day | 12 | 3.77 lbs | $10.24 | $8.21 | $2.03 |
| 211317 | 2020-04-17 | $8.95 | First-Class Package Service | 2 | 0.50 lbs | $4.25 | $5.12 | $-0.87 |
| 211318 | 2020-04-17 | $28.07 | Priority Mail 2-Day Flat Rate Envelope | 3 | 0.52 lbs | $8.00 | $7.65 | $0.35 |
| 211319 | 2020-04-17 | $196.36 | Priority Mail 3-Day | 3 | 11.83 lbs | $25.14 | $21.77 | $3.37 |
| 211320 | 2020-04-17 | $44.93 | Priority Mail 2-Day | 7 | 1.61 lbs | $10.39 | $9.54 | $0.85 |
| 211321 | 2020-04-18 | $9.99 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.19 lbs | $8.00 | $7.15 | $0.85 |
| 211325 | 2020-04-18 | $28.56 | Priority Mail 3-Day | 1 | 0.60 lbs | $9.27 | $8.42 | $0.85 |
| 211326 | 2020-04-18 | $19.79 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 211328 | 2020-04-18 | $5.31 | First-Class Mail Stamped Letter | 4 | 0.06 lbs | $3.35 | $2.93 | $0.42 |
| 211329 | 2020-04-18 | $35.00 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.50 | $7.65 | $0.85 |
| 211330 | 2020-04-18 | $47.63 | Priority Mail 3-Day | 1 | 1.30 lbs | $10.84 | $9.99 | $0.85 |
| 211333 | 2020-04-18 | $15.78 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.15 lbs | $8.00 | $7.75 | $0.25 |
| 211335 | 2020-04-18 | $48.26 | Priority Mail 3-Day Flat Rate Envelope | 4 | 1.40 lbs | $8.00 | $7.65 | $0.35 |
| 211337 | 2020-04-18 | $16.59 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 211339 | 2020-04-18 | $23.54 | First-Class Package Service | 1 | 0.60 lbs | $4.25 | $5.12 | $-0.87 |
| 211342 | 2020-04-18 | $6.69 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.20 | $3.05 | $0.15 |
| 211343 | 2020-04-18 | $36.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 1.00 lbs | $8.00 | $7.65 | $0.35 |
| 211344 | 2020-04-18 | $14.96 | Priority Mail 2-Day Flat Rate Envelope | 4 | 0.16 lbs | $8.00 | $7.65 | $0.35 |
| 211345 | 2020-04-18 | $8.69 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.50 | $2.78 | $0.72 |
| 211346 | 2020-04-18 | $18.45 | First-Class Mail Stamped Letter | 5 | 0.17 lbs | $3.50 | $2.84 | $0.66 |
| 211348 | 2020-04-18 | $136.59 | Priority Mail 2-Day | 6 | 4.70 lbs | $10.35 | $9.50 | $0.85 |
| 211350 | 2020-04-18 | $34.06 | Priority Mail 3-Day Padded Flat Rate Envelope | 1 | 1.10 lbs | $8.60 | $7.65 | $0.95 |
| 211352 | 2020-04-18 | $8.69 | First-Class Mail Stamped Letter | 1 | 0.15 lbs | $3.50 | $3.05 | $0.45 |
| 211354 | 2020-04-19 | $36.76 | Ground | 1 | 1.10 lbs | $15.77 | $7.65 | $8.12 |
| 211355 | 2020-04-19 | $33.79 | Priority Mail 2-Day | 5 | 1.45 lbs | $12.04 | $11.18 | $0.86 |
| 211356 | 2020-04-19 | $272.82 | Priority Mail 3-Day | 3 | 16.45 lbs | $45.05 | $44.20 | $0.85 |
| 211358 | 2020-04-19 | $37.57 | Priority Mail 3-Day Padded Flat Rate Envelope | 3 | 1.78 lbs | $8.60 | $7.65 | $0.95 |
| 211359 | 2020-04-19 | $124.04 | Priority Mail 3-Day | 22 | 8.80 lbs | $49.46 | $48.61 | $0.85 |
| 211360 | 2020-04-19 | $13.94 | Priority Mail 2-Day Flat Rate Envelope | 6 | 0.32 lbs | $8.00 | $7.65 | $0.35 |
| 211363 | 2020-04-19 | $26.48 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.31 lbs | $8.00 | $7.65 | $0.35 |
| 211364 | 2020-04-19 | $121.46 | Priority Mail 3-Day Medium Flat Rate Box | 2 | 2.00 lbs | $14.45 | $7.75 | $6.70 |
| 211365 | 2020-04-19 | $106.64 | Ground | 5 | 6.80 lbs | $28.32 | $22.17 | $6.15 |
| 211367 | 2020-04-19 | $15.46 | First-Class Mail Stamped Letter | 4 | 0.14 lbs | $3.50 | $3.05 | $0.45 |
| 211371 | 2020-04-19 | $29.48 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.46 lbs | $8.00 | $7.65 | $0.35 |
| 211372 | 2020-04-19 | $62.25 | Priority Mail 2-Day Flat Rate Envelope | 15 | 1.35 lbs | $8.00 | $7.65 | $0.35 |
| 211375 | 2020-04-19 | $8.61 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 0.30 lbs | $8.60 | $7.75 | $0.85 |
| 211376 | 2020-04-19 | $18.34 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.84 | $0.51 |
| 211377 | 2020-04-19 | $11.48 | First-Class Mail Stamped Letter | 2 | 0.10 lbs | $3.50 | $2.78 | $0.72 |
| 211379 | 2020-04-19 | $14.03 | First-Class Mail Stamped Letter | 2 | 0.17 lbs | $3.65 | $2.78 | $0.87 |
| 211382 | 2020-04-19 | $149.78 | Priority Mail 2-Day | 12 | 4.66 lbs | $22.30 | $16.38 | $5.92 |
| 211383 | 2020-04-19 | $58.08 | Priority Mail 3-Day | 3 | 1.20 lbs | $9.61 | $8.92 | $0.69 |
| 211384 | 2020-04-19 | $19.09 | Priority Mail 3-Day Small Flat Rate Box | 1 | 0.37 lbs | $8.50 | $7.65 | $0.85 |
| 211385 | 2020-04-19 | $53.11 | Priority Mail 2-Day | 6 | 0.96 lbs | $8.97 | $8.12 | $0.85 |
| 211386 | 2020-04-20 | $60.68 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.87 lbs | $8.00 | $7.75 | $0.25 |
| 211387 | 2020-04-20 | $7.34 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.05 | $0.30 |
| 211389 | 2020-04-20 | $26.39 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.00 | $7.75 | $0.25 |
| 211390 | 2020-04-20 | $18.35 | Priority Mail 3-Day Flat Rate Envelope | 5 | 0.69 lbs | $8.00 | $7.65 | $0.35 |
| 211391 | 2020-04-20 | $17.95 | Priority Mail 2-Day Flat Rate Envelope | 5 | 0.14 lbs | $8.00 | $7.65 | $0.35 |
| 211392 | 2020-04-20 | $74.02 | Priority Mail International Flat Rate Envelope | 8 | 1.39 lbs | $32.90 | $33.60 | $-0.70 |
| 211393 | 2020-04-20 | $11.48 | First-Class Mail Stamped Letter | 2 | 0.10 lbs | $3.50 | $3.05 | $0.45 |
| 211394 | 2020-04-20 | $66.18 | Priority Mail 3-Day Padded Flat Rate Envelope | 2 | 2.15 lbs | $8.60 | $7.75 | $0.85 |
| 211395 | 2020-04-20 | $23.42 | First-Class Package Service | 8 | 0.28 lbs | $3.50 | $4.00 | $-0.50 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |