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 |
|---|---|---|---|---|---|---|---|---|
| 217682 | 2020-11-17 | $139.85 | Priority Mail 2-Day Large Flat Rate Box | 5 | 9.16 lbs | $19.55 | $11.58 | $7.97 |
| 217683 | 2020-11-17 | $19.79 | USPSFirstClass | 1 | 0.04 lbs | $4.80 | $3.30 | $1.50 |
| 217684 | 2020-11-17 | $9.65 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.09 | $0.26 |
| 217686 | 2020-11-17 | $114.41 | Ground | 1 | 13.80 lbs | $30.68 | $26.03 | $4.65 |
| 217689 | 2020-11-17 | $6.24 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.18 | $0.17 |
| 217690 | 2020-11-17 | $32.39 | Priority Mail 3-Day Flat Rate Envelope | 1 | 1.00 lbs | $8.40 | $8.00 | $0.40 |
| 217695 | 2020-11-17 | $9.65 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.18 | $0.17 |
| 217698 | 2020-11-17 | $12.10 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.43 | $-0.08 |
| 217699 | 2020-11-18 | $9.40 | USPSFirstClass | 1 | 0.05 lbs | $4.21 | $3.09 | $1.12 |
| 217700 | 2020-11-18 | $7.85 | USPSFirstClass | 1 | 0.05 lbs | $4.14 | $3.09 | $1.05 |
| 217701 | 2020-11-18 | $15.49 | USPSFirstClass | 1 | 0.05 lbs | $4.50 | $3.09 | $1.41 |
| 217702 | 2020-11-17 | $45.67 | Priority Mail 2-Day Small Flat Rate Box | 3 | 1.31 lbs | $8.90 | $8.05 | $0.85 |
| 217705 | 2020-11-17 | $25.77 | First-Class Package Service | 1 | 0.40 lbs | $4.78 | $4.33 | $0.45 |
| 217706 | 2020-11-17 | $16.12 | First-Class Package Service | 2 | 0.40 lbs | $4.88 | $4.43 | $0.45 |
| 217709 | 2020-11-18 | $51.89 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.90 | $7.90 | $1.00 |
| 217710 | 2020-11-18 | $7.71 | USPSFirstClass | 1 | 0.03 lbs | $4.22 | $3.30 | $0.92 |
| 217712 | 2020-11-18 | $8.70 | First-Class Package Service | 5 | 0.05 lbs | $3.75 | $3.30 | $0.45 |
| 217713 | 2020-11-18 | $13.66 | USPSFirstClass | 1 | 0.10 lbs | $4.27 | $2.99 | $1.28 |
| 217715 | 2020-11-18 | $35.76 | Priority Mail 2-Day | 3 | 1.59 lbs | $11.79 | $10.93 | $0.86 |
| 217716 | 2020-11-18 | $19.08 | First-Class Package Service | 1 | 0.27 lbs | $4.09 | $3.64 | $0.45 |
| 217718 | 2020-11-18 | $17.05 | First-Class Package Service | 11 | 0.58 lbs | $5.16 | $5.95 | $-0.79 |
| 217724 | 2020-11-18 | $8.54 | First-Class Mail Stamped Letter | 1 | 0.07 lbs | $3.35 | $3.43 | $-0.08 |
| 217725 | 2020-11-18 | $91.82 | Priority Mail 3-Day Padded Flat Rate Envelope | 2 | 2.75 lbs | $9.00 | $8.15 | $0.85 |
| 217727 | 2020-11-18 | $9.59 | First-Class Package Service - Retail | 1 | 0.19 lbs | $5.60 | $3.09 | $2.51 |
| 217728 | 2020-11-18 | $243.36 | Priority Mail 3-Day Large Flat Rate Box | 12 | 27.48 lbs | $33.15 | $18.30 | $14.85 |
| 217729 | 2020-11-18 | $36.89 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.90 | $7.90 | $1.00 |
| 217731 | 2020-11-18 | $13.65 | USPSPriority | 1 | 1.00 lbs | $8.70 | $8.05 | $0.65 |
| 217732 | 2020-11-18 | $36.47 | First-Class Mail Stamped Letter | 3 | 0.15 lbs | $3.50 | $3.56 | $-0.06 |
| 217733 | 2020-11-18 | $20.38 | First-Class Mail Stamped Letter | 12 | 0.14 lbs | $3.50 | $3.09 | $0.41 |
| 217735 | 2020-11-19 | $9.35 | USPSFirstClass | 1 | 0.10 lbs | $4.16 | $3.03 | $1.13 |
| 217737 | 2020-11-18 | $17.66 | First-Class Package Service | 5 | 0.35 lbs | $4.01 | $3.57 | $0.44 |
| 217738 | 2020-11-18 | $31.60 | Priority Mail 3-Day Medium Flat Rate Box | 5 | 1.82 lbs | $14.85 | $13.60 | $1.25 |
| 217741 | 2020-11-19 | $14.18 | USPSFirstClass | 2 | 0.20 lbs | $4.20 | $3.09 | $1.11 |
| 217742 | 2020-11-18 | $17.47 | First-Class Package Service | 1 | 0.16 lbs | $3.48 | $3.50 | $-0.02 |
| 217744 | 2020-11-18 | $90.83 | Priority Mail 3-Day Medium Flat Rate Box | 2 | 2.02 lbs | $14.85 | $11.53 | $3.32 |
| 217747 | 2020-11-19 | $13.19 | USPSFirstClass | 1 | 0.05 lbs | $4.44 | $3.18 | $1.26 |
| 217749 | 2020-11-19 | $29.73 | USPSFirstClass | 2 | 0.38 lbs | $10.18 | $4.71 | $5.47 |
| 217751 | 2020-11-19 | $76.25 | Priority Mail 2-Day | 1 | 3.95 lbs | $22.26 | $21.41 | $0.85 |
| 217753 | 2020-11-19 | $44.77 | Priority Mail 3-Day | 1 | 1.20 lbs | $11.79 | $10.94 | $0.85 |
| 217754 | 2020-11-19 | $7.18 | First-Class Mail Stamped Letter | 2 | 0.02 lbs | $3.20 | $3.06 | $0.14 |
| 217755 | 2020-11-19 | $20.69 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.25 lbs | $8.90 | $8.05 | $0.85 |
| 217756 | 2020-11-19 | $19.89 | First-Class Package Service | 2 | 0.38 lbs | $4.09 | $3.64 | $0.45 |
| 217757 | 2020-11-19 | $21.42 | USPSFirstClass | 2 | 0.34 lbs | $5.16 | $4.33 | $0.83 |
| 217765 | 2020-11-19 | $50.43 | Priority Mail 2-Day Medium Flat Rate Box | 2 | 3.50 lbs | $14.85 | $11.53 | $3.32 |
| 217766 | 2020-11-19 | $21.43 | First-Class Mail Stamped Letter | 7 | 0.15 lbs | $3.50 | $3.09 | $0.41 |
| 217767 | 2020-11-19 | $57.58 | Priority Mail 3-Day Padded Flat Rate Envelope | 1 | 2.50 lbs | $9.00 | $8.15 | $0.85 |
| 217768 | 2020-11-19 | $227.68 | Ground | 1 | 21.00 lbs | $34.49 | $28.67 | $5.82 |
| 217770 | 2020-11-19 | $143.10 | Ground Home Delivery | 1 | 12.90 lbs | $33.11 | $30.29 | $2.82 |
| 217771 | 2020-11-19 | $295.19 | Priority Mail 3-Day | 1 | 14.40 lbs | $41.20 | $43.95 | $-2.75 |
| 217772 | 2020-11-19 | $76.42 | Priority Mail 2-Day Padded Flat Rate Envelope | 2 | 2.62 lbs | $9.00 | $8.15 | $0.85 |
| 217773 | 2020-11-20 | $9.35 | USPSFirstClass | 1 | 0.07 lbs | $4.16 | $3.03 | $1.13 |
| 217774 | 2020-11-20 | $28.19 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 1.88 lbs | $9.00 | $8.15 | $0.85 |
| 217777 | 2020-11-20 | $276.02 | Priority Mail 2-Day | 1 | 14.40 lbs | $22.03 | $23.40 | $-1.37 |
| 217780 | 2020-11-20 | $6.34 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.43 | $-0.08 |
| 217781 | 2020-11-20 | $20.99 | First-Class Package Service | 2 | 0.36 lbs | $4.01 | $3.57 | $0.44 |
| 217782 | 2020-11-20 | $51.26 | Standard | 1 | 0.04 lbs | $43.77 | $41.27 | $2.50 |
| 217784 | 2020-11-20 | $35.76 | First-Class Package Service | 1 | 0.75 lbs | $5.77 | $5.52 | $0.25 |
| 217786 | 2020-11-20 | $5.18 | First-Class Mail Stamped Letter | 2 | 0.01 lbs | $3.20 | $3.30 | $-0.10 |
| 217789 | 2020-11-20 | $12.39 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.03 lbs | $8.40 | $8.05 | $0.35 |
| 217790 | 2020-11-20 | $12.68 | First-Class Mail Stamped Letter | 2 | 0.12 lbs | $3.50 | $3.30 | $0.20 |
| 217793 | 2020-11-20 | $37.98 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.90 | $8.05 | $0.85 |
| 217795 | 2020-11-20 | $43.98 | Priority Mail 3-Day Padded Flat Rate Envelope | 2 | 1.30 lbs | $9.00 | $8.05 | $0.95 |
| 217796 | 2020-11-20 | $4.34 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $3.35 | $3.09 | $0.26 |
| 217797 | 2020-11-20 | $51.89 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.50 lbs | $8.90 | $8.05 | $0.85 |
| 217798 | 2020-11-20 | $7.70 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.03 | $0.32 |
| 217799 | 2020-11-20 | $14.34 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.18 | $0.17 |
| 217800 | 2020-11-21 | $8.56 | USPSFirstClass | 1 | 0.40 lbs | $5.17 | $4.71 | $0.46 |
| 217801 | 2020-11-20 | $4.19 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $3.20 | $3.18 | $0.02 |
| 217803 | 2020-11-21 | $51.25 | Priority Mail 2-Day | 42 | 0.42 lbs | $9.67 | $7.65 | $2.02 |
| 217805 | 2020-11-21 | $38.69 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.90 | $7.90 | $1.00 |
| 217807 | 2020-11-21 | $6.47 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.20 | $2.99 | $0.21 |
| 217808 | 2020-11-21 | $8.62 | USPSFirstClass | 1 | 0.07 lbs | $4.27 | $3.30 | $0.97 |
| 217809 | 2020-11-21 | $76.84 | Priority Mail 2-Day Medium Flat Rate Box | 1 | 17.25 lbs | $14.85 | $13.60 | $1.25 |
| 217815 | 2020-11-21 | $25.06 | First-Class Package Service | 1 | 0.65 lbs | $5.77 | $5.52 | $0.25 |
| 217817 | 2020-11-21 | $35.60 | Priority Mail 2-Day | 1 | 1.30 lbs | $9.37 | $8.05 | $1.32 |
| 217818 | 2020-11-21 | $20.31 | USPSFirstClass | 1 | 0.15 lbs | $4.82 | $3.30 | $1.52 |
| 217820 | 2020-11-21 | $19.66 | First-Class Package Service | 1 | 0.45 lbs | $4.88 | $4.43 | $0.45 |
| 217821 | 2020-11-21 | $7.19 | First-Class Mail Stamped Letter | 1 | 0.04 lbs | $3.20 | $3.03 | $0.17 |
| 217823 | 2020-11-21 | $14.26 | First-Class Package Service | 1 | 0.13 lbs | $3.44 | $3.46 | $-0.02 |
| 217824 | 2020-11-21 | $11.33 | First-Class Mail Stamped Letter | 2 | 0.05 lbs | $3.35 | $3.30 | $0.05 |
| 217825 | 2020-11-21 | $14.34 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.09 | $0.26 |
| 217826 | 2020-11-21 | $114.84 | Priority Mail 2-Day Medium Flat Rate Box | 1 | 7.20 lbs | $14.85 | $31.34 | $-16.49 |
| 217827 | 2020-11-21 | $19.92 | USPSFirstClass | 3 | 0.30 lbs | $4.95 | $3.03 | $1.92 |
| 217828 | 2020-11-21 | $38.69 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.90 | $8.05 | $0.85 |
| 217829 | 2020-11-21 | $16.67 | First-Class Package Service | 1 | 0.55 lbs | $4.88 | $4.43 | $0.45 |
| 217830 | 2020-11-21 | $78.28 | Priority Mail 2-Day | 6 | 2.22 lbs | $14.74 | $7.75 | $6.99 |
| 217831 | 2020-11-22 | $14.44 | USPSFirstClass | 1 | 0.50 lbs | $5.45 | $5.95 | $-0.50 |
| 217833 | 2020-11-21 | $44.77 | Priority Mail 3-Day | 1 | 1.20 lbs | $11.79 | $10.94 | $0.85 |
| 217837 | 2020-11-21 | $50.04 | Priority Mail 3-Day Padded Flat Rate Envelope | 1 | 1.35 lbs | $9.00 | $8.15 | $0.85 |
| 217838 | 2020-11-22 | $11.17 | USPSFirstClass | 1 | 0.05 lbs | $4.39 | $3.30 | $1.09 |
| 217839 | 2020-11-21 | $25.46 | First-Class Package Service | 1 | 0.85 lbs | $5.97 | $5.52 | $0.45 |
| 217840 | 2020-11-22 | $21.49 | USPSFirstClass | 1 | 0.40 lbs | $5.50 | $4.25 | $1.25 |
| 217841 | 2020-11-22 | $21.54 | USPSFirstClass | 1 | 0.40 lbs | $5.55 | $4.33 | $1.22 |
| 217842 | 2020-11-22 | $38.69 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.90 | $8.05 | $0.85 |
| 217843 | 2020-11-22 | $13.91 | USPSFirstClass | 1 | 0.10 lbs | $4.52 | $3.30 | $1.22 |
| 217844 | 2020-11-22 | $26.35 | USPSFirstClass | 3 | 1.20 lbs | $14.98 | $11.58 | $3.40 |
| 217845 | 2020-11-22 | $27.36 | USPSFirstClass | 1 | 0.35 lbs | $5.87 | $3.64 | $2.23 |
| 217846 | 2020-11-22 | $20.97 | USPSFirstClass | 2 | 0.40 lbs | $5.19 | $4.43 | $0.76 |
| 217850 | 2020-11-22 | $6.39 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.50 | $3.18 | $0.32 |
| 217851 | 2020-11-22 | $36.59 | Priority Mail 3-Day | 9 | 2.63 lbs | $11.58 | $9.94 | $1.64 |
| Total | 21025 order(s) | 59971 | 29292.14 lbs | $193562.51 | $270247.54 | $-76685.03 |