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 |
|---|---|---|---|---|---|---|---|---|
| 213647 | 2020-07-15 | $82.58 | Priority Mail 3-Day Padded Flat Rate Envelope | 2 | 5.30 lbs | $8.60 | $7.75 | $0.85 |
| 213649 | 2020-07-15 | $12.81 | First-Class Mail Stamped Letter | 4 | 0.10 lbs | $3.35 | $2.78 | $0.57 |
| 213651 | 2020-07-15 | $12.78 | Priority Mail 3-Day Small Flat Rate Box | 2 | 0.07 lbs | $8.50 | $7.65 | $0.85 |
| 213652 | 2020-07-15 | $9.79 | First-Class Mail Stamped Letter | 1 | 0.15 lbs | $3.50 | $3.52 | $-0.02 |
| 213653 | 2020-07-16 | $10.16 | USPSFirstClass | 1 | 0.05 lbs | $4.44 | $3.18 | $1.26 |
| 213654 | 2020-07-15 | $14.28 | First-Class Package Service | 4 | 0.76 lbs | $5.52 | $5.27 | $0.25 |
| 213656 | 2020-07-15 | $31.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.00 | $7.75 | $0.25 |
| 213657 | 2020-07-15 | $29.56 | Priority Mail 2-Day Flat Rate Envelope | 4 | 0.23 lbs | $8.00 | $7.65 | $0.35 |
| 213658 | 2020-07-16 | $36.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 1.10 lbs | $8.00 | $7.65 | $0.35 |
| 213659 | 2020-07-16 | $27.47 | USPSPriority | 1 | 7.60 lbs | $12.98 | $8.45 | $4.53 |
| 213660 | 2020-07-16 | $9.24 | USPSFirstClass | 1 | 0.10 lbs | $4.27 | $3.05 | $1.22 |
| 213661 | 2020-07-16 | $50.71 | Priority Mail 2-Day Medium Flat Rate Box | 4 | 1.59 lbs | $14.45 | $7.65 | $6.80 |
| 213662 | 2020-07-16 | $25.79 | USPSFirstClass | 1 | 0.30 lbs | $5.80 | $3.39 | $2.41 |
| 213663 | 2020-07-16 | $49.99 | Priority Mail 3-Day Large Flat Rate Box | 1 | 1.45 lbs | $7.00 | $7.65 | $-0.65 |
| 213664 | 2020-07-16 | $27.44 | First-Class Package Service | 1 | 0.50 lbs | $5.95 | $4.46 | $1.49 |
| 213665 | 2020-07-16 | $28.89 | USPSFirstClass | 2 | 0.74 lbs | $5.98 | $5.27 | $0.71 |
| 213667 | 2020-07-16 | $12.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.05 lbs | $8.50 | $7.65 | $0.85 |
| 213668 | 2020-07-16 | $21.65 | USPSFirstClass | 1 | 0.15 lbs | $4.70 | $3.25 | $1.45 |
| 213669 | 2020-07-16 | $9.49 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.03 lbs | $8.00 | $7.65 | $0.35 |
| 213673 | 2020-07-16 | $35.48 | Priority Mail 3-Day Small Flat Rate Box | 2 | 2.00 lbs | $8.50 | $7.65 | $0.85 |
| 213675 | 2020-07-16 | $40.49 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.00 | $7.65 | $0.35 |
| 213678 | 2020-07-16 | $27.26 | First-Class Package Service | 2 | 0.54 lbs | $4.33 | $4.08 | $0.25 |
| 213679 | 2020-07-16 | $73.48 | Priority Mail 3-Day Small Flat Rate Box | 2 | 1.70 lbs | $8.50 | $7.65 | $0.85 |
| 213680 | 2020-07-16 | $15.89 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 213681 | 2020-07-16 | $75.48 | Priority Mail 2-Day Flat Rate Envelope | 2 | 2.50 lbs | $8.00 | $7.75 | $0.25 |
| 213682 | 2020-07-17 | $17.64 | USPSFirstClass | 4 | 0.80 lbs | $8.54 | $7.98 | $0.56 |
| 213683 | 2020-07-16 | $38.52 | Priority Mail 2-Day | 7 | 0.36 lbs | $11.39 | $8.15 | $3.24 |
| 213684 | 2020-07-16 | $24.57 | Priority Mail 2-Day | 3 | 0.26 lbs | $9.00 | $8.15 | $0.85 |
| 213685 | 2020-07-17 | $30.19 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.45 lbs | $8.00 | $7.65 | $0.35 |
| 213686 | 2020-07-17 | $157.63 | Ground | 4 | 13.20 lbs | $31.07 | $25.42 | $5.65 |
| 213688 | 2020-07-17 | $335.08 | Priority Mail 2-Day Large Flat Rate Box | 27 | 10.10 lbs | $22.80 | $13.20 | $9.60 |
| 213689 | 2020-07-17 | $230.75 | Priority Mail 2-Day | 3 | 14.29 lbs | $53.98 | $53.13 | $0.85 |
| 213690 | 2020-07-17 | $17.85 | USPSFirstClass | 2 | 0.15 lbs | $4.36 | $3.52 | $0.84 |
| 213695 | 2020-07-16 | $77.69 | Priority Mail 3-Day Large Flat Rate Box | 5 | 2.49 lbs | $12.00 | $11.13 | $0.87 |
| 213696 | 2020-07-17 | $12.45 | Priority Mail 2-Day Flat Rate Envelope | 5 | 0.32 lbs | $8.00 | $7.65 | $0.35 |
| 213697 | 2020-07-17 | $7.83 | First-Class Mail Stamped Letter | 2 | 0.06 lbs | $3.35 | $2.93 | $0.42 |
| 213698 | 2020-07-17 | $9.98 | First-Class Package Service | 1 | 0.50 lbs | $5.99 | $3.52 | $2.47 |
| 213700 | 2020-07-17 | $19.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 213701 | 2020-07-17 | $31.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.00 | $7.75 | $0.25 |
| 213702 | 2020-07-17 | $99.67 | Direct Link International | 3 | 2.65 lbs | $30.40 | $27.68 | $2.72 |
| 213703 | 2020-07-17 | $5.16 | First-Class Mail Stamped Letter | 4 | 0.04 lbs | $3.20 | $3.05 | $0.15 |
| 213704 | 2020-07-18 | $28.76 | USPSFirstClass | 2 | 0.74 lbs | $6.28 | $5.70 | $0.58 |
| 213705 | 2020-07-17 | $14.84 | First-Class Mail Stamped Letter | 3 | 0.15 lbs | $3.50 | $2.74 | $0.76 |
| 213706 | 2020-07-17 | $30.61 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 7.20 lbs | $8.60 | $7.75 | $0.85 |
| 213707 | 2020-07-18 | $9.60 | USPSFirstClass | 1 | 0.07 lbs | $4.15 | $2.78 | $1.37 |
| 213709 | 2020-07-18 | $78.12 | Ground | 5 | 3.30 lbs | $20.17 | $12.52 | $7.65 |
| 213710 | 2020-07-18 | $47.57 | Priority Mail 2-Day | 12 | 7.38 lbs | $19.45 | $15.39 | $4.06 |
| 213713 | 2020-07-18 | $26.29 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.25 lbs | $8.00 | $7.65 | $0.35 |
| 213715 | 2020-07-18 | $73.48 | Priority Mail 3-Day Small Flat Rate Box | 2 | 1.70 lbs | $8.50 | $7.65 | $0.85 |
| 213716 | 2020-07-18 | $10.22 | USPSFirstClass | 1 | 0.20 lbs | $4.45 | $3.67 | $0.78 |
| 213717 | 2020-07-18 | $58.37 | Priority Mail 1-Day | 3 | 1.80 lbs | $8.69 | $7.84 | $0.85 |
| 213719 | 2020-07-18 | $60.86 | Priority Mail 2-Day | 3 | 0.96 lbs | $11.39 | $10.54 | $0.85 |
| 213720 | 2020-07-18 | $6.19 | First-Class Mail Stamped Letter | 1 | 0.04 lbs | $3.20 | $2.93 | $0.27 |
| 213721 | 2020-07-18 | $187.55 | Ground | 9 | 19.05 lbs | $32.84 | $27.19 | $5.65 |
| 213722 | 2020-07-18 | $227.37 | Ground | 1 | 17.00 lbs | $27.77 | $22.55 | $5.22 |
| 213723 | 2020-07-18 | $22.43 | First-Class Mail Stamped Letter | 3 | 0.08 lbs | $3.35 | $2.93 | $0.42 |
| 213724 | 2020-07-18 | $18.03 | Priority Mail 3-Day Medium Flat Rate Box | 2 | 0.25 lbs | $14.05 | $7.98 | $6.07 |
| 213725 | 2020-07-18 | $7.84 | First-Class Mail Stamped Letter | 1 | 0.07 lbs | $3.35 | $3.05 | $0.30 |
| 213727 | 2020-07-18 | $33.56 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.50 | $7.65 | $0.85 |
| 213728 | 2020-07-18 | $27.39 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.22 lbs | $8.00 | $7.65 | $0.35 |
| 213729 | 2020-07-18 | $21.16 | USPSFirstClass | 2 | 0.68 lbs | $5.99 | $5.54 | $0.45 |
| 213730 | 2020-07-18 | $60.70 | Priority Mail 2-Day | 1 | 1.60 lbs | $10.39 | $9.54 | $0.85 |
| 213731 | 2020-07-18 | $9.32 | First-Class Mail Stamped Letter | 3 | 0.06 lbs | $3.35 | $2.84 | $0.51 |
| 213732 | 2020-07-19 | $22.30 | USPSFirstClass | 1 | 0.15 lbs | $5.00 | $3.67 | $1.33 |
| 213733 | 2020-07-18 | $14.03 | First-Class Mail Stamped Letter | 2 | 0.17 lbs | $3.65 | $3.18 | $0.47 |
| 213734 | 2020-07-19 | $7.41 | USPSFirstClass | 1 | 0.07 lbs | $4.19 | $3.52 | $0.67 |
| 213735 | 2020-07-18 | $18.30 | Priority Mail 2-Day Flat Rate Envelope | 6 | 0.43 lbs | $8.00 | $7.65 | $0.35 |
| 213736 | 2020-07-18 | $22.49 | First-Class Package Service | 4 | 0.46 lbs | $4.33 | $4.08 | $0.25 |
| 213737 | 2020-07-18 | $7.19 | First-Class Mail Stamped Letter | 1 | 0.04 lbs | $3.20 | $2.84 | $0.36 |
| 213738 | 2020-07-19 | $33.58 | USPSFirstClass | 2 | 1.00 lbs | $9.00 | $9.98 | $-0.98 |
| 213739 | 2020-07-18 | $21.89 | First-Class Package Service | 3 | 0.73 lbs | $5.72 | $5.27 | $0.45 |
| 213740 | 2020-07-19 | $9.98 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.04 lbs | $8.00 | $7.65 | $0.35 |
| 213742 | 2020-07-19 | $46.97 | Priority Mail 3-Day | 3 | 1.90 lbs | $13.00 | $7.75 | $5.25 |
| 213744 | 2020-07-19 | $12.28 | First-Class Mail Stamped Letter | 2 | 0.10 lbs | $3.50 | $3.05 | $0.45 |
| 213745 | 2020-07-19 | $35.66 | First-Class Package Service | 13 | 0.62 lbs | $5.79 | $4.32 | $1.47 |
| 213746 | 2020-07-19 | $9.96 | USPSFirstClass | 1 | 0.20 lbs | $4.30 | $3.52 | $0.78 |
| 213747 | 2020-07-19 | $64.18 | Priority Mail 3-Day | 1 | 2.40 lbs | $10.39 | $9.54 | $0.85 |
| 213748 | 2020-07-19 | $38.20 | Priority Mail 2-Day Medium Flat Rate Box | 5 | 1.85 lbs | $14.45 | $13.20 | $1.25 |
| 213749 | 2020-07-19 | $19.04 | First-Class Package Service | 1 | 0.35 lbs | $4.25 | $4.00 | $0.25 |
| 213750 | 2020-07-19 | $14.39 | First-Class Mail Stamped Letter | 11 | 0.12 lbs | $3.50 | $2.93 | $0.57 |
| 213751 | 2020-07-19 | $9.68 | USPSFirstClass | 1 | 0.10 lbs | $4.24 | $2.93 | $1.31 |
| 213753 | 2020-07-19 | $13.82 | First-Class Mail Stamped Letter | 3 | 0.09 lbs | $3.35 | $3.05 | $0.30 |
| 213754 | 2020-07-19 | $9.64 | First-Class Mail Stamped Letter | 1 | 0.18 lbs | $3.65 | $3.31 | $0.34 |
| 213755 | 2020-07-19 | $15.90 | USPSFirstClass | 2 | 0.40 lbs | $5.02 | $5.27 | $-0.25 |
| 213757 | 2020-07-19 | $88.04 | Priority Mail 2-Day | 5 | 2.50 lbs | $16.59 | $17.42 | $-0.83 |
| 213758 | 2020-07-19 | $10.10 | First-Class Mail Stamped Letter | 5 | 0.06 lbs | $3.35 | $2.93 | $0.42 |
| 213760 | 2020-07-19 | $38.06 | Priority Mail 2-Day | 1 | 0.85 lbs | $11.39 | $10.54 | $0.85 |
| 213761 | 2020-07-19 | $15.65 | USPSFirstClass | 1 | 0.20 lbs | $4.51 | $2.93 | $1.58 |
| 213764 | 2020-07-19 | $27.50 | Priority Mail 2-Day Flat Rate Envelope | 1 | 1.15 lbs | $8.00 | $7.65 | $0.35 |
| 213765 | 2020-07-19 | $35.35 | Ground | 1 | 1.25 lbs | $19.56 | $15.92 | $3.64 |
| 213766 | 2020-07-20 | $6.88 | USPSFirstClass | 1 | 0.07 lbs | $4.09 | $2.84 | $1.25 |
| 213767 | 2020-07-19 | $29.94 | Priority Mail 3-Day Flat Rate Envelope | 6 | 0.44 lbs | $8.00 | $7.65 | $0.35 |
| 213768 | 2020-07-19 | $26.79 | Priority Mail 3-Day Small Flat Rate Box | 1 | 0.25 lbs | $8.50 | $7.65 | $0.85 |
| 213769 | 2020-07-20 | $7.57 | USPSFirstClass | 2 | 0.04 lbs | $4.02 | $2.84 | $1.18 |
| 213770 | 2020-07-20 | $139.65 | Priority Mail 2-Day | 7 | 8.04 lbs | $12.82 | $8.21 | $4.61 |
| 213773 | 2020-07-20 | $8.73 | First-Class Mail Stamped Letter | 2 | 0.06 lbs | $3.35 | $2.93 | $0.42 |
| 213777 | 2020-07-20 | $6.32 | First-Class Mail Stamped Letter | 3 | 0.06 lbs | $3.35 | $3.18 | $0.17 |
| 213778 | 2020-07-20 | $84.24 | Ground | 4 | 4.50 lbs | $19.68 | $16.03 | $3.65 |
| 213779 | 2020-07-20 | $13.13 | First-Class Mail Stamped Letter | 2 | 0.17 lbs | $3.65 | $3.25 | $0.40 |
| 213780 | 2020-07-20 | $6.77 | First-Class Package Service | 1 | 0.07 lbs | $3.38 | $2.93 | $0.45 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |