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 |
|---|---|---|---|---|---|---|---|---|
| 213781 | 2020-07-20 | $49.26 | Priority Mail 2-Day | 5 | 0.81 lbs | $12.04 | $11.19 | $0.85 |
| 213782 | 2020-07-20 | $26.29 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 213783 | 2020-07-20 | $115.09 | Priority Mail 3-Day Medium Flat Rate Box | 4 | 4.70 lbs | $14.45 | $13.20 | $1.25 |
| 213784 | 2020-07-20 | $9.83 | First-Class Mail Stamped Letter | 2 | 0.03 lbs | $3.35 | $2.93 | $0.42 |
| 213785 | 2020-07-20 | $5.19 | First-Class Mail Stamped Letter | 1 | 0.02 lbs | $3.20 | $2.78 | $0.42 |
| 213786 | 2020-07-20 | $29.37 | Priority Mail 2-Day | 5 | 2.75 lbs | $9.92 | $8.21 | $1.71 |
| 213787 | 2020-07-21 | $54.10 | USPSFirstClass | 2 | 0.30 lbs | $6.20 | $3.67 | $2.53 |
| 213788 | 2020-07-20 | $47.37 | Priority Mail 2-Day | 5 | 2.44 lbs | $10.39 | $8.92 | $1.47 |
| 213789 | 2020-07-20 | $22.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 213790 | 2020-07-20 | $25.39 | First-Class Mail Stamped Letter | 11 | 0.12 lbs | $3.50 | $3.18 | $0.32 |
| 213791 | 2020-07-20 | $121.06 | Priority Mail 3-Day | 5 | 3.20 lbs | $16.91 | $16.06 | $0.85 |
| 213792 | 2020-07-21 | $25.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.85 lbs | $8.50 | $7.65 | $0.85 |
| 213793 | 2020-07-21 | $99.93 | USPSFirstClass | 9 | 1.80 lbs | $24.57 | $15.74 | $8.83 |
| 213796 | 2020-07-21 | $12.84 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.18 | $0.17 |
| 213797 | 2020-07-21 | $37.69 | First-Class Package Service | 1 | 0.30 lbs | $4.71 | $3.67 | $1.04 |
| 213798 | 2020-07-21 | $35.56 | Priority Mail 3-Day Flat Rate Envelope | 4 | 0.74 lbs | $8.00 | $7.65 | $0.35 |
| 213799 | 2020-07-21 | $27.31 | Priority Mail 2-Day | 1 | 0.74 lbs | $9.61 | $8.76 | $0.85 |
| 213800 | 2020-07-21 | $29.49 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.35 lbs | $8.00 | $7.65 | $0.35 |
| 213801 | 2020-07-21 | $12.45 | First-Class Mail Stamped Letter | 5 | 0.10 lbs | $3.50 | $2.93 | $0.57 |
| 213803 | 2020-07-21 | $65.22 | Priority Mail 3-Day | 16 | 5.30 lbs | $21.31 | $18.47 | $2.84 |
| 213804 | 2020-07-21 | $97.26 | USPSFirstClass | 8 | 4.00 lbs | $39.64 | $21.01 | $18.63 |
| 213805 | 2020-07-21 | $52.77 | Priority Mail 2-Day | 4 | 0.90 lbs | $9.61 | $8.76 | $0.85 |
| 213808 | 2020-07-21 | $34.18 | Priority Mail 3-Day | 1 | 0.95 lbs | $11.39 | $10.53 | $0.86 |
| 213810 | 2020-07-21 | $110.21 | Priority Mail 3-Day Medium Flat Rate Box | 4 | 3.75 lbs | $14.45 | $7.75 | $6.70 |
| 213811 | 2020-07-21 | $27.13 | USPSFirstClass | 4 | 0.40 lbs | $4.99 | $4.08 | $0.91 |
| 213812 | 2020-07-21 | $139.28 | Ground | 1 | 3.00 lbs | $39.29 | $26.60 | $12.69 |
| 213818 | 2020-07-21 | $13.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.10 lbs | $8.00 | $7.65 | $0.35 |
| 213819 | 2020-07-21 | $17.47 | Priority Mail 2-Day Small Flat Rate Box | 3 | 0.09 lbs | $8.50 | $7.65 | $0.85 |
| 213820 | 2020-07-22 | $13.92 | USPSFirstClass | 3 | 0.10 lbs | $4.15 | $2.93 | $1.22 |
| 213822 | 2020-07-21 | $12.28 | First-Class Mail Stamped Letter | 7 | 0.08 lbs | $3.35 | $2.78 | $0.57 |
| 213823 | 2020-07-22 | $11.83 | USPSFirstClass | 1 | 0.05 lbs | $4.35 | $2.93 | $1.42 |
| 213824 | 2020-07-21 | $60.50 | Priority Mail 2-Day Flat Rate Envelope | 3 | 0.83 lbs | $8.00 | $7.75 | $0.25 |
| 213825 | 2020-07-22 | $17.48 | Priority Mail 2-Day Small Flat Rate Box | 2 | 0.21 lbs | $8.50 | $7.65 | $0.85 |
| 213827 | 2020-07-22 | $24.64 | Priority Mail 3-Day | 4 | 2.40 lbs | $9.08 | $8.23 | $0.85 |
| 213829 | 2020-07-22 | $8.82 | First-Class Mail Stamped Letter | 3 | 0.09 lbs | $3.35 | $3.05 | $0.30 |
| 213831 | 2020-07-22 | $247.95 | Priority Mail 2-Day | 10 | 5.00 lbs | $10.35 | $8.21 | $2.14 |
| 213832 | 2020-07-22 | $15.89 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 213834 | 2020-07-22 | $9.33 | First-Class Mail Stamped Letter | 2 | 0.07 lbs | $3.35 | $3.18 | $0.17 |
| 213835 | 2020-07-22 | $19.91 | First-Class Package Service | 4 | 0.44 lbs | $4.45 | $4.00 | $0.45 |
| 213836 | 2020-07-22 | $18.98 | Priority Mail 1-Day Flat Rate Envelope | 3 | 0.22 lbs | $8.00 | $7.65 | $0.35 |
| 213838 | 2020-07-22 | $14.78 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.02 lbs | $8.00 | $7.65 | $0.35 |
| 213839 | 2020-07-22 | $63.95 | Ground | 4 | 1.30 lbs | $20.29 | $15.30 | $4.99 |
| 213842 | 2020-07-22 | $82.60 | Priority Mail 2-Day | 23 | 1.82 lbs | $13.00 | $12.15 | $0.85 |
| 213844 | 2020-07-23 | $5.18 | First-Class Mail Stamped Letter | 2 | 0.02 lbs | $3.20 | $2.93 | $0.27 |
| 213845 | 2020-07-23 | $45.98 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.80 lbs | $8.00 | $7.75 | $0.25 |
| 213846 | 2020-07-23 | $12.35 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.08 lbs | $8.00 | $7.65 | $0.35 |
| 213847 | 2020-07-23 | $425.75 | Ground | 7 | 32.91 lbs | $71.45 | $50.28 | $21.17 |
| 213848 | 2020-07-23 | $27.78 | USPSFirstClass | 2 | 1.10 lbs | $11.80 | $10.42 | $1.38 |
| 213851 | 2020-07-23 | $8.54 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.05 | $0.30 |
| 213852 | 2020-07-23 | $102.89 | Priority Mail 2-Day | 5 | 2.13 lbs | $9.44 | $8.59 | $0.85 |
| 213853 | 2020-07-23 | $9.49 | First-Class Package Service | 2 | 0.34 lbs | $4.71 | $4.46 | $0.25 |
| 213854 | 2020-07-23 | $47.63 | Priority Mail 2-Day | 1 | 1.15 lbs | $10.84 | $9.99 | $0.85 |
| 213855 | 2020-07-23 | $25.64 | First-Class Package Service | 1 | 0.85 lbs | $6.15 | $5.95 | $0.20 |
| 213856 | 2020-07-23 | $10.82 | First-Class Mail Stamped Letter | 3 | 0.03 lbs | $3.35 | $2.93 | $0.42 |
| 213858 | 2020-07-24 | $12.22 | USPSFirstClass | 1 | 0.45 lbs | $5.12 | $5.40 | $-0.28 |
| 213859 | 2020-07-23 | $5.49 | First-Class Mail Stamped Letter | 1 | 0.12 lbs | $3.50 | $3.52 | $-0.02 |
| 213860 | 2020-07-24 | $7.61 | USPSFirstClass | 1 | 0.03 lbs | $4.12 | $2.84 | $1.28 |
| 213861 | 2020-07-24 | $55.64 | Ground | 1 | 0.45 lbs | $16.65 | $16.08 | $0.57 |
| 213862 | 2020-07-24 | $27.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 3.50 lbs | $8.00 | $7.65 | $0.35 |
| 213863 | 2020-07-24 | $6.68 | USPSFirstClass | 1 | 0.04 lbs | $4.30 | $3.18 | $1.12 |
| 213864 | 2020-06-24 | $213.63 | Priority Mail 2-Day | 1 | 14.05 lbs | $20.64 | $20.78 | $-0.14 |
| 213866 | 2020-07-24 | $8.25 | First-Class Mail Stamped Letter | 10 | 0.10 lbs | $3.35 | $3.05 | $0.30 |
| 213869 | 2020-07-24 | $16.04 | Priority Mail 2-Day Medium Flat Rate Box | 1 | 0.12 lbs | $14.05 | $8.42 | $5.63 |
| 213870 | 2020-07-24 | $9.73 | USPSFirstClass | 1 | 0.06 lbs | $4.45 | $3.18 | $1.27 |
| 213871 | 2020-07-24 | $9.13 | USPSFirstClass | 1 | 0.05 lbs | $4.40 | $3.18 | $1.22 |
| 213874 | 2020-07-24 | $27.59 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 1.36 lbs | $8.60 | $7.75 | $0.85 |
| 213877 | 2020-07-25 | $27.68 | USPSFirstClass | 4 | 1.34 lbs | $11.64 | $10.54 | $1.10 |
| 213878 | 2020-07-24 | $24.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.45 lbs | $8.00 | $7.65 | $0.35 |
| 213879 | 2020-07-24 | $31.37 | Priority Mail 3-Day Small Flat Rate Box | 13 | 0.16 lbs | $8.50 | $7.65 | $0.85 |
| 213880 | 2020-07-25 | $34.73 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.50 | $7.65 | $0.85 |
| 213881 | 2020-07-25 | $56.07 | Priority Mail 3-Day | 2 | 1.47 lbs | $11.39 | $10.54 | $0.85 |
| 213882 | 2020-07-25 | $11.98 | USPSFirstClass | 1 | 0.19 lbs | $4.40 | $3.05 | $1.35 |
| 213883 | 2020-07-25 | $14.58 | USPSFirstClass | 1 | 0.55 lbs | $6.15 | $5.70 | $0.45 |
| 213884 | 2020-07-25 | $83.68 | Priority Mail 3-Day Padded Flat Rate Envelope | 4 | 8.00 lbs | $8.60 | $7.65 | $0.95 |
| 213885 | 2020-07-25 | $15.07 | USPSFirstClass | 2 | 0.06 lbs | $4.29 | $3.05 | $1.24 |
| 213886 | 2020-07-25 | $8.37 | USPSFirstClass | 1 | 0.05 lbs | $4.10 | $2.78 | $1.32 |
| 213887 | 2020-07-25 | $16.28 | Priority Mail 2-Day Small Flat Rate Box | 2 | 0.30 lbs | $8.50 | $7.65 | $0.85 |
| 213889 | 2020-07-25 | $37.29 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.15 lbs | $8.50 | $7.65 | $0.85 |
| 213890 | 2020-07-25 | $12.64 | First-Class Mail Stamped Letter | 1 | 0.16 lbs | $3.65 | $3.52 | $0.13 |
| 213891 | 2020-07-25 | $26.79 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.25 lbs | $8.50 | $7.65 | $0.85 |
| 213893 | 2020-07-26 | $21.99 | USPSFirstClass | 1 | 0.15 lbs | $4.70 | $2.78 | $1.92 |
| 213894 | 2020-07-26 | $137.90 | Priority Mail 2-Day Flat Rate Envelope | 10 | 8.59 lbs | $8.00 | $7.75 | $0.25 |
| 213895 | 2020-07-26 | $9.99 | Priority Mail 2-Day | 1 | 0.95 lbs | $15.01 | $10.44 | $4.57 |
| 213897 | 2020-07-26 | $93.60 | Priority Mail 2-Day | 2 | 4.80 lbs | $19.32 | $18.47 | $0.85 |
| 213899 | 2020-07-26 | $19.90 | USPSFirstClass | 3 | 0.14 lbs | $4.44 | $3.67 | $0.77 |
| 213900 | 2020-07-26 | $89.16 | Priority Mail 2-Day | 4 | 2.10 lbs | $13.00 | $10.42 | $2.58 |
| 213902 | 2020-07-26 | $21.80 | Priority Mail 2-Day | 4 | 1.09 lbs | $12.04 | $11.19 | $0.85 |
| 213903 | 2020-07-26 | $25.42 | USPSFirstClass | 1 | 0.06 lbs | $4.92 | $2.93 | $1.99 |
| 213904 | 2020-07-26 | $49.38 | Priority Mail 2-Day | 1 | 1.80 lbs | $10.39 | $9.94 | $0.45 |
| 213905 | 2020-07-26 | $13.46 | First-Class Mail Stamped Letter | 4 | 0.12 lbs | $3.50 | $3.31 | $0.19 |
| 213909 | 2020-07-26 | $9.32 | First-Class Mail Stamped Letter | 3 | 0.06 lbs | $3.35 | $3.05 | $0.30 |
| 213911 | 2020-07-26 | $44.59 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 1.35 lbs | $8.60 | $7.75 | $0.85 |
| 213912 | 2020-07-26 | $24.70 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.35 lbs | $8.00 | $7.65 | $0.35 |
| 213913 | 2020-07-26 | $68.88 | USPSFirstClass | 1 | 0.80 lbs | $8.99 | $9.99 | $-1.00 |
| 213914 | 2020-07-26 | $38.29 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.50 | $7.65 | $0.85 |
| 213915 | 2020-07-26 | $66.18 | Priority Mail 2-Day Padded Flat Rate Envelope | 2 | 2.25 lbs | $8.60 | $8.15 | $0.45 |
| 213916 | 2020-07-26 | $5.18 | First-Class Mail Stamped Letter | 2 | 0.02 lbs | $3.20 | $3.05 | $0.15 |
| 213918 | 2020-07-26 | $5.16 | First-Class Mail Stamped Letter | 4 | 0.04 lbs | $3.20 | $2.78 | $0.42 |
| 213919 | 2020-07-26 | $44.12 | Priority Mail 2-Day | 5 | 1.31 lbs | $8.97 | $8.12 | $0.85 |
| 213920 | 2020-07-26 | $18.99 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |