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 |
|---|---|---|---|---|---|---|---|---|
| 217524 | 2020-11-12 | $287.39 | Ground | 1 | 14.40 lbs | $33.40 | $28.04 | $5.36 |
| 217525 | 2020-11-12 | $12.18 | USPSFirstClass | 2 | 0.10 lbs | $4.20 | $3.18 | $1.02 |
| 217527 | 2020-11-12 | $13.17 | First-Class Package Service | 2 | 0.16 lbs | $3.63 | $3.18 | $0.45 |
| 217528 | 2020-11-12 | $11.49 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.50 | $3.30 | $0.20 |
| 217529 | 2020-11-12 | $49.24 | Priority Mail 3-Day | 7 | 1.20 lbs | $10.01 | $9.32 | $0.69 |
| 217531 | 2020-11-12 | $10.82 | First-Class Mail Stamped Letter | 3 | 0.07 lbs | $3.35 | $3.18 | $0.17 |
| 217532 | 2020-11-12 | $49.43 | Priority Mail 3-Day | 1 | 1.85 lbs | $14.74 | $13.89 | $0.85 |
| 217536 | 2020-11-12 | $20.69 | Priority Mail 3-Day Small Flat Rate Box | 1 | 0.30 lbs | $8.90 | $8.20 | $0.70 |
| 217538 | 2020-11-12 | $118.92 | Ground | 1 | 1.87 lbs | $19.54 | $17.04 | $2.50 |
| 217539 | 2020-11-13 | $30.53 | Priority Mail 3-Day | 1 | 0.65 lbs | $11.24 | $8.38 | $2.86 |
| 217541 | 2020-11-13 | $37.19 | Priority Mail 3-Day Flat Rate Envelope | 1 | 1.10 lbs | $8.40 | $7.90 | $0.50 |
| 217543 | 2020-11-13 | $13.18 | First-Class Package Service | 4 | 0.30 lbs | $4.22 | $3.77 | $0.45 |
| 217546 | 2020-11-13 | $63.38 | Priority Mail 2-Day | 6 | 1.85 lbs | $9.84 | $8.52 | $1.32 |
| 217548 | 2020-11-13 | $38.69 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.35 lbs | $8.90 | $8.05 | $0.85 |
| 217549 | 2020-11-13 | $61.47 | Priority Mail 3-Day Padded Flat Rate Envelope | 3 | 1.95 lbs | $9.00 | $8.15 | $0.85 |
| 217552 | 2020-11-13 | $44.48 | Priority Mail 2-Day Small Flat Rate Box | 2 | 1.30 lbs | $8.90 | $8.05 | $0.85 |
| 217554 | 2020-11-13 | $15.69 | First-Class Package Service | 3 | 0.12 lbs | $3.44 | $2.99 | $0.45 |
| 217556 | 2020-11-13 | $14.30 | Priority Mail 2-Day | 1 | 0.15 lbs | $8.81 | $8.15 | $0.66 |
| 217557 | 2020-09-08 | $33.99 | Priority Mail 2-Day | 1 | 1.05 lbs | $9.00 | $10.44 | $-1.44 |
| 217558 | 2020-11-13 | $148.30 | Priority Mail 3-Day Flat Rate Envelope | 10 | 8.59 lbs | $8.40 | $8.61 | $-0.21 |
| 217559 | 2020-11-13 | $113.81 | Priority Mail 2-Day | 1 | 13.80 lbs | $20.78 | $18.70 | $2.08 |
| 217561 | 2020-11-13 | $228.64 | Priority Mail 3-Day | 1 | 14.05 lbs | $35.65 | $30.47 | $5.18 |
| 217562 | 2020-11-13 | $12.29 | First-Class Mail Stamped Letter | 1 | 0.08 lbs | $3.50 | $3.30 | $0.20 |
| 217563 | 2020-11-13 | $21.70 | Priority Mail 2-Day | 3 | 0.07 lbs | $9.23 | $8.05 | $1.18 |
| 217565 | 2020-11-13 | $9.36 | First-Class Package Service | 2 | 0.34 lbs | $4.58 | $4.33 | $0.25 |
| 217566 | 2020-11-13 | $54.36 | Priority Mail 2-Day | 1 | 1.20 lbs | $9.37 | $8.52 | $0.85 |
| 217567 | 2020-11-13 | $9.45 | First-Class Package Service | 1 | 0.22 lbs | $4.96 | $3.43 | $1.53 |
| 217568 | 2020-11-13 | $69.16 | Ground | 2 | 6.25 lbs | $21.79 | $18.35 | $3.44 |
| 217569 | 2020-11-13 | $23.87 | First-Class Package Service | 1 | 0.60 lbs | $4.58 | $4.33 | $0.25 |
| 217570 | 2020-11-14 | $15.54 | USPSFirstClass | 1 | 0.05 lbs | $4.55 | $3.18 | $1.37 |
| 217571 | 2020-11-14 | $17.12 | USPSFirstClass | 2 | 0.20 lbs | $8.34 | $3.09 | $5.25 |
| 217572 | 2020-11-14 | $9.24 | USPSFirstClass | 1 | 0.10 lbs | $4.25 | $3.18 | $1.07 |
| 217574 | 2020-11-14 | $16.29 | USPSFirstClass | 1 | 0.40 lbs | $5.30 | $4.33 | $0.97 |
| 217576 | 2020-11-14 | $38.79 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 1.25 lbs | $9.00 | $8.05 | $0.95 |
| 217577 | 2020-11-14 | $11.33 | First-Class Mail Stamped Letter | 2 | 0.07 lbs | $3.35 | $3.09 | $0.26 |
| 217579 | 2020-11-14 | $17.56 | First-Class Package Service | 4 | 0.71 lbs | $6.20 | $5.95 | $0.25 |
| 217580 | 2020-11-14 | $364.92 | Ground | 4 | 16.25 lbs | $38.16 | $33.69 | $4.47 |
| 217583 | 2020-11-14 | $9.29 | InternationalPriorityShipping | 1 | 0.02 lbs | $4.30 | $3.30 | $1.00 |
| 217584 | 2020-11-14 | $45.42 | First-Class Package Service | 28 | 0.56 lbs | $4.70 | $8.05 | $-3.35 |
| 217585 | 2020-11-14 | $68.02 | Priority Mail 3-Day | 2 | 1.90 lbs | $9.84 | $8.72 | $1.12 |
| 217589 | 2020-11-14 | $18.40 | First-Class Mail Stamped Letter | 10 | 0.14 lbs | $3.50 | $3.64 | $-0.14 |
| 217590 | 2020-11-14 | $39.36 | First-Class Package Service | 1 | 0.27 lbs | $4.37 | $3.92 | $0.45 |
| 217592 | 2020-11-14 | $38.68 | Priority Mail 2-Day | 1 | 1.20 lbs | $8.89 | $8.05 | $0.84 |
| 217594 | 2020-11-14 | $54.36 | Priority Mail 2-Day | 1 | 1.20 lbs | $9.37 | $8.24 | $1.13 |
| 217596 | 2020-11-14 | $19.78 | Priority Mail 2-Day Padded Flat Rate Envelope | 2 | 0.17 lbs | $9.00 | $8.15 | $0.85 |
| 217598 | 2020-11-14 | $40.99 | First-Class Package Service | 23 | 0.28 lbs | $4.22 | $3.05 | $1.17 |
| 217599 | 2020-11-14 | $77.62 | Priority Mail 2-Day | 2 | 4.26 lbs | $10.64 | $8.61 | $2.03 |
| 217601 | 2020-11-14 | $63.35 | Priority Mail 2-Day | 2 | 1.60 lbs | $9.37 | $9.41 | $-0.04 |
| 217602 | 2020-11-14 | $24.88 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.40 | $8.15 | $0.25 |
| 217604 | 2020-11-15 | $10.00 | USPSFirstClass | 1 | 0.30 lbs | $5.05 | $3.18 | $1.87 |
| 217606 | 2020-11-14 | $16.10 | First-Class Package Service | 2 | 0.26 lbs | $4.22 | $3.77 | $0.45 |
| 217608 | 2020-11-14 | $26.89 | First-Class Package Service | 1 | 0.40 lbs | $4.70 | $4.25 | $0.45 |
| 217612 | 2020-11-15 | $18.61 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.40 | $8.05 | $0.35 |
| 217614 | 2020-11-15 | $4.34 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.30 | $0.05 |
| 217616 | 2020-11-15 | $7.94 | First-Class Mail Stamped Letter | 1 | 0.06 lbs | $3.35 | $3.18 | $0.17 |
| 217617 | 2020-11-15 | $12.48 | USPSFirstClass | 1 | 0.20 lbs | $4.59 | $3.92 | $0.67 |
| 217618 | 2020-11-15 | $4.19 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $3.20 | $3.43 | $-0.23 |
| 217622 | 2020-11-15 | $17.54 | First-Class Package Service | 5 | 0.07 lbs | $4.09 | $3.64 | $0.45 |
| 217623 | 2020-11-15 | $22.20 | First-Class Package Service | 3 | 0.49 lbs | $4.63 | $3.46 | $1.17 |
| 217624 | 2020-11-15 | $64.39 | Priority Mail 3-Day | 3 | 3.00 lbs | $11.58 | $9.93 | $1.65 |
| 217626 | 2020-11-15 | $9.70 | USPSFirstClass | 2 | 0.34 lbs | $4.92 | $4.43 | $0.49 |
| 217627 | 2020-11-15 | $19.52 | USPSFirstClass | 2 | 0.60 lbs | $5.74 | $5.37 | $0.37 |
| 217628 | 2020-11-15 | $248.69 | Priority Mail 2-Day | 1 | 13.15 lbs | $38.70 | $41.20 | $-2.50 |
| 217629 | 2020-11-15 | $12.23 | First-Class Package Service | 1 | 0.11 lbs | $3.44 | $2.99 | $0.45 |
| 217630 | 2020-11-15 | $15.39 | First-Class Package Service | 2 | 0.22 lbs | $4.01 | $3.56 | $0.45 |
| 217631 | 2020-11-16 | $8.67 | USPSFirstClass | 2 | 0.40 lbs | $4.89 | $3.64 | $1.25 |
| 217632 | 2020-11-15 | $33.86 | Priority Mail 2-Day Flat Rate Envelope | 1 | 1.10 lbs | $8.40 | $8.05 | $0.35 |
| 217634 | 2020-11-15 | $43.28 | Priority Mail 3-Day | 1 | 1.20 lbs | $11.79 | $8.05 | $3.74 |
| 217636 | 2020-11-15 | $5.18 | First-Class Mail Stamped Letter | 2 | 0.02 lbs | $3.20 | $3.18 | $0.02 |
| 217637 | 2020-11-15 | $38.69 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.25 lbs | $8.90 | $8.05 | $0.85 |
| 217638 | 2020-11-15 | $51.36 | Priority Mail 2-Day Padded Flat Rate Envelope | 4 | 1.48 lbs | $9.00 | $7.75 | $1.25 |
| 217640 | 2020-11-16 | $25.20 | First-Class Package Service | 2 | 0.50 lbs | $4.82 | $4.57 | $0.25 |
| 217641 | 2020-11-16 | $14.34 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.09 | $0.26 |
| 217643 | 2020-11-16 | $70.84 | Priority Mail 2-Day Padded Flat Rate Envelope | 2 | 7.00 lbs | $9.00 | $8.15 | $0.85 |
| 217644 | 2020-11-16 | $57.43 | Priority Mail 2-Day | 1 | 1.10 lbs | $12.44 | $11.59 | $0.85 |
| 217645 | 2020-11-16 | $15.33 | First-Class Mail Stamped Letter | 2 | 0.06 lbs | $3.35 | $3.03 | $0.32 |
| 217647 | 2020-11-16 | $53.08 | Direct Link International | 1 | 1.10 lbs | $24.29 | $18.52 | $5.77 |
| 217648 | 2020-11-16 | $14.68 | Priority Mail 2-Day Small Flat Rate Box | 2 | 0.10 lbs | $8.90 | $7.15 | $1.75 |
| 217649 | 2020-11-16 | $51.89 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.90 | $7.90 | $1.00 |
| 217650 | 2020-11-16 | $12.82 | First-Class Package Service | 5 | 0.20 lbs | $4.37 | $3.43 | $0.94 |
| 217651 | 2020-11-16 | $237.88 | Ground | 1 | 14.05 lbs | $44.89 | $30.40 | $14.49 |
| 217653 | 2020-11-16 | $65.33 | Priority Mail 3-Day Padded Flat Rate Envelope | 1 | 3.12 lbs | $9.00 | $8.15 | $0.85 |
| 217656 | 2020-11-16 | $178.73 | Ground | 175 | 10.46 lbs | $26.98 | $17.94 | $9.04 |
| 217657 | 2020-11-16 | $15.69 | First-Class Package Service | 2 | 0.31 lbs | $4.01 | $3.31 | $0.70 |
| 217658 | 2020-11-16 | $15.08 | First-Class Package Service | 1 | 0.20 lbs | $4.09 | $3.18 | $0.91 |
| 217659 | 2020-11-16 | $72.87 | Priority Mail 3-Day Flat Rate Envelope | 3 | 1.05 lbs | $8.40 | $7.90 | $0.50 |
| 217660 | 2020-11-17 | $9.40 | USPSFirstClass | 1 | 0.10 lbs | $4.21 | $3.09 | $1.12 |
| 217663 | 2020-11-16 | $247.07 | Priority Mail 3-Day | 4 | 12.75 lbs | $28.21 | $30.47 | $-2.26 |
| 217664 | 2020-11-17 | $14.23 | USPSFirstClass | 1 | 0.10 lbs | $4.44 | $3.56 | $0.88 |
| 217668 | 2020-11-16 | $13.04 | First-Class Package Service | 1 | 0.30 lbs | $4.37 | $4.71 | $-0.34 |
| 217669 | 2020-11-16 | $51.89 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.90 | $7.90 | $1.00 |
| 217670 | 2020-11-16 | $92.37 | Priority Mail 3-Day Flat Rate Envelope | 3 | 1.35 lbs | $8.40 | $8.05 | $0.35 |
| 217672 | 2020-11-16 | $18.32 | First-Class Mail Stamped Letter | 3 | 0.06 lbs | $3.35 | $3.50 | $-0.15 |
| 217673 | 2020-11-16 | $62.22 | First-Class Package Service | 2 | 0.90 lbs | $6.24 | $8.05 | $-1.81 |
| 217674 | 2020-11-16 | $62.18 | Direct Link International | 1 | 1.30 lbs | $29.39 | $8.05 | $21.34 |
| 217675 | 2020-11-16 | $17.01 | First-Class Package Service | 8 | 0.21 lbs | $4.09 | $3.64 | $0.45 |
| 217676 | 2020-11-16 | $56.34 | Priority Mail 3-Day Flat Rate Envelope | 3 | 1.48 lbs | $8.40 | $8.15 | $0.25 |
| 217678 | 2020-11-16 | $64.66 | Priority Mail 2-Day | 3 | 1.10 lbs | $11.79 | $10.53 | $1.26 |
| 217679 | 2020-11-16 | $38.69 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.90 | $8.05 | $0.85 |
| 217681 | 2020-11-16 | $71.74 | Priority Mail 2-Day | 3 | 1.75 lbs | $11.24 | $10.38 | $0.86 |
| Total | 21025 order(s) | 59971 | 29292.14 lbs | $193562.51 | $270247.54 | $-76685.03 |