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 |
|---|---|---|---|---|---|---|---|---|
| 218373 | 2020-12-05 | $26.80 | First-Class Package Service | 4 | 0.20 lbs | $4.22 | $3.77 | $0.45 |
| 218375 | 2020-12-05 | $3.94 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $2.95 | $3.03 | $-0.08 |
| 218378 | 2020-12-05 | $7.66 | First-Class Mail Stamped Letter | 9 | 0.09 lbs | $3.25 | $3.43 | $-0.18 |
| 218380 | 2020-12-05 | $16.16 | First-Class Package Service | 1 | 0.30 lbs | $4.37 | $3.92 | $0.45 |
| 218382 | 2020-12-05 | $94.96 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 0.85 lbs | $9.00 | $8.05 | $0.95 |
| 218383 | 2020-12-05 | $31.00 | First-Class Package Service | 4 | 0.08 lbs | $3.54 | $3.09 | $0.45 |
| 218385 | 2020-12-05 | $46.02 | Priority Mail 2-Day Flat Rate Envelope | 3 | 1.35 lbs | $8.40 | $8.05 | $0.35 |
| 218392 | 2020-12-05 | $12.43 | First-Class Package Service | 3 | 0.10 lbs | $3.46 | $3.03 | $0.43 |
| 218393 | 2020-12-05 | $19.50 | First-Class Package Service | 1 | 0.45 lbs | $5.16 | $4.71 | $0.45 |
| 218394 | 2020-12-05 | $54.81 | Priority Mail 2-Day | 3 | 1.30 lbs | $11.24 | $10.38 | $0.86 |
| 218396 | 2020-12-05 | $19.98 | First-Class Package Service | 2 | 0.40 lbs | $4.78 | $3.56 | $1.22 |
| 218397 | 2020-12-05 | $240.19 | Ground | 1 | 14.05 lbs | $47.20 | $32.81 | $14.39 |
| 218398 | 2020-12-05 | $17.54 | First-Class Package Service | 3 | 0.21 lbs | $4.37 | $3.43 | $0.94 |
| 218400 | 2020-12-05 | $287.73 | Priority Mail 2-Day Large Flat Rate Box | 10 | 10.30 lbs | $14.00 | $10.89 | $3.11 |
| 218404 | 2020-12-05 | $14.67 | First-Class Package Service | 1 | 0.40 lbs | $4.88 | $3.64 | $1.24 |
| 218405 | 2020-12-05 | $8.95 | First-Class Package Service | 1 | 0.05 lbs | $3.44 | $2.99 | $0.45 |
| 218407 | 2020-12-05 | $71.58 | Priority Mail 2-Day | 2 | 1.90 lbs | $13.40 | $12.70 | $0.70 |
| 218408 | 2020-12-05 | $40.68 | Ground | 2 | 0.95 lbs | $18.89 | $15.30 | $3.59 |
| 218409 | 2020-12-05 | $55.00 | Priority Mail 2-Day | 1 | 1.10 lbs | $10.01 | $8.85 | $1.16 |
| 218410 | 2020-12-05 | $11.14 | First-Class Mail Stamped Letter | 11 | 0.15 lbs | $3.25 | $3.43 | $-0.18 |
| 218411 | 2020-12-06 | $6.98 | USPSFirstClass | 1 | 0.25 lbs | $4.09 | $3.56 | $0.53 |
| 218412 | 2020-12-05 | $15.38 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.10 | $3.92 | $-0.82 |
| 218414 | 2020-12-05 | $47.40 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.50 lbs | $8.90 | $8.05 | $0.85 |
| 218415 | 2020-12-05 | $21.97 | First-Class Package Service | 4 | 0.19 lbs | $4.01 | $3.56 | $0.45 |
| 218416 | 2020-12-05 | $27.96 | Priority Mail 3-Day Flat Rate Envelope | 1 | 1.00 lbs | $8.40 | $8.15 | $0.25 |
| 218417 | 2020-12-05 | $283.36 | Ground | 8 | 16.45 lbs | $32.46 | $31.05 | $1.41 |
| 218419 | 2020-12-05 | $71.71 | Ground | 1 | 3.90 lbs | $23.93 | $19.90 | $4.03 |
| 218420 | 2020-12-05 | $51.94 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.70 lbs | $8.90 | $7.90 | $1.00 |
| 218421 | 2020-12-05 | $51.89 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.90 | $7.90 | $1.00 |
| 218423 | 2020-12-06 | $100.08 | Priority Mail 3-Day Padded Flat Rate Envelope | 3 | 2.70 lbs | $9.00 | $8.05 | $0.95 |
| 218425 | 2020-12-06 | $44.77 | Priority Mail 2-Day | 1 | 1.30 lbs | $11.79 | $10.94 | $0.85 |
| 218426 | 2020-12-06 | $3.94 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $2.95 | $3.09 | $-0.14 |
| 218429 | 2020-12-06 | $45.07 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 1.44 lbs | $9.00 | $8.15 | $0.85 |
| 218430 | 2020-12-06 | $9.44 | USPSFirstClass | 1 | 0.06 lbs | $4.45 | $3.43 | $1.02 |
| 218431 | 2020-12-06 | $116.14 | Ground | 1 | 12.75 lbs | $31.35 | $30.24 | $1.11 |
| 218432 | 2020-12-06 | $58.42 | Priority Mail 2-Day | 1 | 3.90 lbs | $10.64 | $9.79 | $0.85 |
| 218436 | 2020-12-06 | $46.83 | Priority Mail 3-Day | 1 | 2.20 lbs | $9.84 | $8.34 | $1.50 |
| 218437 | 2020-12-06 | $108.03 | Priority Mail 3-Day | 1 | 3.45 lbs | $15.41 | $14.56 | $0.85 |
| 218440 | 2020-12-06 | $14.32 | First-Class Package Service - Retail | 1 | 0.35 lbs | $5.65 | $3.64 | $2.01 |
| 218445 | 2020-12-06 | $19.22 | Priority Mail 3-Day | 1 | 0.13 lbs | $9.23 | $8.38 | $0.85 |
| 218446 | 2020-12-06 | $24.25 | First-Class Package Service | 1 | 0.60 lbs | $4.96 | $5.95 | $-0.99 |
| 218447 | 2020-12-06 | $37.19 | Priority Mail 3-Day Flat Rate Envelope | 1 | 1.05 lbs | $8.40 | $7.90 | $0.50 |
| 218448 | 2020-12-06 | $27.41 | USPSFirstClass | 4 | 0.20 lbs | $4.29 | $3.64 | $0.65 |
| 218449 | 2020-12-06 | $8.56 | USPSFirstClass | 1 | 0.07 lbs | $4.17 | $3.09 | $1.08 |
| 218452 | 2020-12-06 | $38.69 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.50 lbs | $8.90 | $7.65 | $1.25 |
| 218454 | 2020-12-06 | $70.74 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 3.75 lbs | $9.00 | $8.15 | $0.85 |
| 218455 | 2020-12-07 | $14.49 | USPSFirstClass | 1 | 0.15 lbs | $4.50 | $3.64 | $0.86 |
| 218457 | 2020-12-06 | $9.89 | First-Class Mail Stamped Letter | 1 | 0.04 lbs | $3.10 | $3.18 | $-0.08 |
| 218458 | 2020-12-06 | $73.70 | Priority Mail 3-Day | 1 | 3.90 lbs | $19.71 | $19.29 | $0.42 |
| 218459 | 2020-12-06 | $104.88 | Priority Mail 3-Day Flat Rate Envelope | 2 | 3.25 lbs | $8.40 | $8.15 | $0.25 |
| 218463 | 2020-12-06 | $213.51 | Ground | 1 | 23.16 lbs | $38.52 | $29.83 | $8.69 |
| 218464 | 2020-12-07 | $9.13 | USPSFirstClass | 1 | 0.04 lbs | $4.24 | $3.18 | $1.06 |
| 218467 | 2020-12-06 | $34.82 | Priority Mail 2-Day | 2 | 1.61 lbs | $11.24 | $12.55 | $-1.31 |
| 218468 | 2020-12-06 | $35.13 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.90 | $8.05 | $0.85 |
| 218469 | 2020-12-06 | $17.07 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.40 | $8.05 | $0.35 |
| 218470 | 2020-12-06 | $11.15 | First-Class Package Service | 1 | 0.44 lbs | $5.16 | $3.92 | $1.24 |
| 218471 | 2020-12-07 | $51.61 | Priority Mail 2-Day | 3 | 3.93 lbs | $10.64 | $8.21 | $2.43 |
| 218474 | 2020-12-07 | $8.47 | USPSFirstClass | 1 | 0.10 lbs | $4.12 | $3.03 | $1.09 |
| 218476 | 2020-12-07 | $20.72 | USPSFirstClass | 2 | 0.77 lbs | $9.14 | $5.79 | $3.35 |
| 218477 | 2020-12-07 | $7.61 | USPSFirstClass | 1 | 0.03 lbs | $4.12 | $3.09 | $1.03 |
| 218478 | 2020-12-07 | $47.34 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.45 lbs | $8.40 | $8.15 | $0.25 |
| 218479 | 2020-12-07 | $52.18 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.15 lbs | $8.40 | $8.05 | $0.35 |
| 218480 | 2020-12-07 | $50.77 | Priority Mail 2-Day | 2 | 2.05 lbs | $10.79 | $9.01 | $1.78 |
| 218482 | 2020-12-07 | $7.85 | USPSFirstClass | 1 | 0.05 lbs | $4.14 | $3.09 | $1.05 |
| 218483 | 2020-12-07 | $8.61 | USPSFirstClass | 1 | 0.07 lbs | $4.22 | $3.18 | $1.04 |
| 218484 | 2020-12-07 | $36.89 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.90 | $8.05 | $0.85 |
| 218487 | 2020-12-07 | $53.22 | Priority Mail 2-Day | 2 | 1.25 lbs | $11.24 | $10.44 | $0.80 |
| 218490 | 2020-12-07 | $12.09 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.02 lbs | $8.40 | $8.82 | $-0.42 |
| 218491 | 2020-12-07 | $13.09 | USPSFirstClass | 1 | 0.05 lbs | $4.34 | $3.03 | $1.31 |
| 218492 | 2020-12-07 | $26.11 | First-Class Package Service | 4 | 0.41 lbs | $4.63 | $3.46 | $1.17 |
| 218493 | 2020-12-07 | $47.78 | Priority Mail 3-Day | 1 | 2.20 lbs | $10.79 | $9.01 | $1.78 |
| 218496 | 2020-12-07 | $46.38 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.10 lbs | $8.40 | $15.80 | $-7.40 |
| 218497 | 2020-12-07 | $8.19 | USPSFirstClass | 1 | 0.03 lbs | $4.20 | $3.18 | $1.02 |
| 218498 | 2020-12-07 | $58.04 | USPSPriority | 1 | 4.11 lbs | $25.81 | $23.67 | $2.14 |
| 218499 | 2020-12-07 | $9.78 | First-Class Package Service | 1 | 0.05 lbs | $3.48 | $3.03 | $0.45 |
| 218500 | 2020-12-07 | $295.02 | Ground | 1 | 14.40 lbs | $41.03 | $42.36 | $-1.33 |
| 218501 | 2020-12-07 | $6.09 | First-Class Mail Stamped Letter | 1 | 0.04 lbs | $3.10 | $3.43 | $-0.33 |
| 218503 | 2020-12-07 | $48.84 | Priority Mail 2-Day Medium Flat Rate Box | 1 | 3.32 lbs | $14.85 | $12.50 | $2.35 |
| 218504 | 2020-12-08 | $13.19 | USPSFirstClass | 1 | 0.31 lbs | $5.20 | $4.43 | $0.77 |
| 218505 | 2020-12-07 | $56.58 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.60 lbs | $8.40 | $8.05 | $0.35 |
| 218507 | 2020-12-07 | $11.05 | First-Class Mail Stamped Letter | 5 | 0.06 lbs | $3.10 | $3.03 | $0.07 |
| 218509 | 2020-12-07 | $17.12 | Priority Mail 2-Day | 1 | 0.05 lbs | $9.23 | $8.05 | $1.18 |
| 218510 | 2020-12-08 | $24.36 | USPSFirstClass | 4 | 0.30 lbs | $8.40 | $3.18 | $5.22 |
| 218511 | 2020-12-07 | $14.70 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.05 lbs | $8.40 | $8.05 | $0.35 |
| 218512 | 2020-12-07 | $43.33 | Priority Mail 3-Day | 1 | 2.13 lbs | $9.84 | $8.05 | $1.79 |
| 218516 | 2020-12-08 | $101.38 | 2-Day | 1 | 1.19 lbs | $27.41 | $26.55 | $0.86 |
| 218517 | 2020-12-08 | $30.89 | Priority Mail 2-Day | 1 | 0.50 lbs | $9.40 | $8.55 | $0.85 |
| 218518 | 2020-12-08 | $99.21 | Priority Mail 2-Day | 2 | 5.20 lbs | $15.43 | $14.32 | $1.11 |
| 218519 | 2020-12-08 | $9.33 | USPSFirstClass | 1 | 0.05 lbs | $4.44 | $3.43 | $1.01 |
| 218522 | 2020-12-08 | $74.08 | Priority Mail 2-Day Small Flat Rate Box | 2 | 1.95 lbs | $8.90 | $7.65 | $1.25 |
| 218523 | 2020-12-08 | $23.83 | First-Class Package Service | 2 | 0.20 lbs | $4.37 | $3.92 | $0.45 |
| 218524 | 2020-12-08 | $21.00 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.10 lbs | $8.40 | $8.05 | $0.35 |
| 218525 | 2020-12-08 | $7.10 | USPSFirstClass | 2 | 0.05 lbs | $4.12 | $3.30 | $0.82 |
| 218526 | 2020-12-08 | $67.22 | Priority Mail 3-Day | 2 | 2.20 lbs | $9.84 | $8.34 | $1.50 |
| 218529 | 2020-12-08 | $83.26 | Ground | 3 | 14.25 lbs | $33.79 | $24.20 | $9.59 |
| 218530 | 2020-12-08 | $16.12 | USPSFirstClass | 3 | 0.15 lbs | $4.15 | $3.09 | $1.06 |
| 218531 | 2020-12-08 | $34.61 | Priority Mail 2-Day | 1 | 2.14 lbs | $13.40 | $10.38 | $3.02 |
| 218532 | 2020-12-08 | $11.43 | First-Class Package Service | 1 | 0.05 lbs | $3.54 | $3.09 | $0.45 |
| 218535 | 2020-12-08 | $19.39 | Priority Mail 2-Day | 1 | 0.57 lbs | $9.05 | $8.05 | $1.00 |
| 218539 | 2020-12-09 | $9.03 | USPSFirstClass | 1 | 0.05 lbs | $4.14 | $3.03 | $1.11 |
| Total | 21025 order(s) | 59971 | 29292.14 lbs | $193562.51 | $270247.54 | $-76685.03 |