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 |
|---|---|---|---|---|---|---|---|---|
| 209704 | 2020-02-04 | $8.24 | First-Class Package Service | 1 | 0.10 lbs | $3.89 | $2.84 | $1.05 |
| 209705 | 2020-02-04 | $15.59 | First-Class Package Service | 1 | 0.15 lbs | $4.44 | $3.39 | $1.05 |
| 209708 | 2020-02-04 | $38.52 | First-Class Package Service | 2 | 0.80 lbs | $6.09 | $5.04 | $1.05 |
| 209709 | 2020-02-04 | $14.15 | First-Class Package Service | 1 | 0.35 lbs | $4.36 | $4.08 | $0.28 |
| 209710 | 2020-02-05 | $46.99 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.25 lbs | $8.50 | $7.65 | $0.85 |
| 209712 | 2020-02-05 | $41.96 | Priority Mail 3-Day Small Flat Rate Box | 3 | 0.95 lbs | $8.50 | $7.65 | $0.85 |
| 209713 | 2020-02-05 | $7.09 | First-Class Package Service | 1 | 0.03 lbs | $4.10 | $3.05 | $1.05 |
| 209715 | 2020-02-05 | $7.96 | First-Class Package Service | 2 | 0.20 lbs | $3.98 | $2.93 | $1.05 |
| 209717 | 2020-02-05 | $6.08 | First-Class Package Service | 1 | 0.10 lbs | $3.89 | $2.84 | $1.05 |
| 209719 | 2020-02-06 | $36.01 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.50 lbs | $8.00 | $7.65 | $0.35 |
| 209721 | 2020-02-06 | $147.95 | Priority Mail 2-Day Flat Rate Envelope | 5 | 2.00 lbs | $8.00 | $7.65 | $0.35 |
| 209724 | 2020-02-06 | $19.12 | First-Class Package Service | 2 | 0.30 lbs | $4.44 | $3.39 | $1.05 |
| 209727 | 2020-02-06 | $23.99 | First-Class Mail Large Envelope | 1 | 0.60 lbs | $4.70 | $5.70 | $-1.00 |
| 209732 | 2020-02-06 | $7.06 | First-Class Package Service | 4 | 0.04 lbs | $4.10 | $3.05 | $1.05 |
| 209733 | 2020-02-06 | $27.13 | First-Class Package Service | 2 | 0.60 lbs | $5.13 | $5.27 | $-0.14 |
| 209749 | 2020-02-07 | $71.36 | Priority Mail 2-Day Flat Rate Envelope | 4 | 2.79 lbs | $8.00 | $7.75 | $0.25 |
| 209750 | 2020-02-07 | $10.04 | First-Class Package Service | 6 | 0.18 lbs | $4.10 | $3.05 | $1.05 |
| 209757 | 2020-02-07 | $8.61 | First-Class Package Service | 3 | 0.47 lbs | $5.23 | $5.70 | $-0.47 |
| 209758 | 2020-02-07 | $9.17 | First-Class Package Service | 1 | 0.15 lbs | $3.98 | $2.93 | $1.05 |
| 209759 | 2020-02-07 | $20.35 | First-Class Package Service | 1 | 0.40 lbs | $4.36 | $4.08 | $0.28 |
| 209760 | 2020-02-07 | $38.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.50 | $7.65 | $0.85 |
| 209764 | 2020-02-07 | $17.22 | First-Class Package Service | 1 | 0.57 lbs | $5.23 | $5.40 | $-0.17 |
| 209765 | 2020-02-07 | $15.08 | First-Class Package Service | 1 | 0.20 lbs | $4.10 | $3.52 | $0.58 |
| 209766 | 2020-02-07 | $30.52 | Priority Mail 2-Day | 1 | 1.15 lbs | $11.39 | $10.54 | $0.85 |
| 209767 | 2020-02-07 | $8.81 | First-Class Package Service | 2 | 0.06 lbs | $3.83 | $2.78 | $1.05 |
| 209769 | 2020-02-08 | $38.31 | First-Class Package Service | 6 | 0.60 lbs | $5.37 | $3.52 | $1.85 |
| 209770 | 2020-02-08 | $5.27 | First-Class Package Service | 1 | 0.10 lbs | $3.98 | $3.39 | $0.59 |
| 209772 | 2020-02-08 | $16.92 | First-Class Package Service | 6 | 0.16 lbs | $3.98 | $3.39 | $0.59 |
| 209773 | 2020-02-08 | $15.53 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.10 lbs | $8.00 | $7.65 | $0.35 |
| 209774 | 2020-02-08 | $16.07 | Priority Mail 3-Day Flat Rate Envelope | 3 | 0.23 lbs | $8.00 | $7.65 | $0.35 |
| 209775 | 2020-02-08 | $34.85 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.50 | $7.65 | $0.85 |
| 209776 | 2020-02-08 | $10.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.03 lbs | $8.00 | $7.15 | $0.85 |
| 209779 | 2020-02-08 | $10.89 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.05 lbs | $8.00 | $7.15 | $0.85 |
| 209781 | 2020-02-09 | $47.00 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.50 lbs | $8.50 | $7.65 | $0.85 |
| 209782 | 2020-02-09 | $12.88 | Priority Mail 3-Day Small Flat Rate Box | 2 | 0.10 lbs | $8.50 | $7.65 | $0.85 |
| 209783 | 2020-02-09 | $99.08 | Priority Mail 2-Day Padded Flat Rate Envelope | 3 | 3.90 lbs | $8.60 | $7.65 | $0.95 |
| 209784 | 2020-02-09 | $22.99 | First-Class Package Service | 1 | 0.49 lbs | $5.97 | $5.12 | $0.85 |
| 209786 | 2020-02-09 | $40.46 | Priority Mail 3-Day | 1 | 1.20 lbs | $8.97 | $7.65 | $1.32 |
| 209787 | 2020-02-09 | $37.99 | Priority Mail 2-Day | 2 | 0.95 lbs | $8.49 | $7.64 | $0.85 |
| 209790 | 2020-02-09 | $71.34 | Priority Mail 3-Day | 7 | 2.98 lbs | $16.91 | $13.20 | $3.71 |
| 209791 | 2020-02-09 | $51.14 | Priority Mail 2-Day | 3 | 1.51 lbs | $8.97 | $8.12 | $0.85 |
| 209794 | 2020-02-09 | $74.91 | Priority Mail 2-Day | 7 | 3.16 lbs | $11.18 | $10.33 | $0.85 |
| 209797 | 2020-02-09 | $167.24 | Priority Mail 2-Day | 10 | 4.57 lbs | $19.32 | $13.20 | $6.12 |
| 209798 | 2020-02-10 | $14.47 | Priority Mail 3-Day | 1 | 1.35 lbs | $8.97 | $8.12 | $0.85 |
| 209799 | 2020-02-10 | $37.92 | Priority Mail 2-Day | 1 | 0.70 lbs | $8.97 | $8.12 | $0.85 |
| 209801 | 2020-02-10 | $27.79 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.00 lbs | $8.50 | $7.65 | $0.85 |
| 209802 | 2020-02-10 | $19.99 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.40 lbs | $8.00 | $7.65 | $0.35 |
| 209804 | 2020-02-10 | $60.01 | Priority Mail 2-Day Large Flat Rate Box | 14 | 0.56 lbs | $19.15 | $11.19 | $7.96 |
| 209807 | 2020-02-10 | $25.28 | Priority Mail 3-Day Small Flat Rate Box | 2 | 0.25 lbs | $8.50 | $7.65 | $0.85 |
| 209808 | 2020-02-10 | $117.73 | Priority Mail 2-Day | 9 | 1.40 lbs | $10.84 | $12.15 | $-1.31 |
| 209810 | 2020-02-10 | $71.24 | Priority Mail International Small Flat Rate Box | 1 | 1.00 lbs | $38.45 | $37.60 | $0.85 |
| 209812 | 2020-02-11 | $15.98 | Priority Mail 3-Day Flat Rate Envelope | 2 | 0.04 lbs | $8.00 | $7.15 | $0.85 |
| 209814 | 2020-02-11 | $51.04 | Priority Mail 2-Day | 1 | 1.20 lbs | $12.04 | $11.19 | $0.85 |
| 209815 | 2020-02-11 | $23.16 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.10 lbs | $8.00 | $7.65 | $0.35 |
| 209817 | 2020-02-11 | $51.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.45 lbs | $8.50 | $7.65 | $0.85 |
| 209819 | 2020-02-11 | $11.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.08 lbs | $8.00 | $7.15 | $0.85 |
| 209822 | 2020-02-11 | $27.49 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.00 | $7.75 | $0.25 |
| 209826 | 2020-02-12 | $47.01 | Priority Mail 1-Day Large Flat Rate Box | 1 | 0.57 lbs | $19.15 | $7.64 | $11.51 |
| 209827 | 2020-01-19 | $308.51 | Priority Mail 2-Day Large Flat Rate Box | 29 | 11.22 lbs | $45.40 | $38.40 | $7.00 |
| 209828 | 2020-02-12 | $14.97 | Priority Mail 3-Day Flat Rate Envelope | 3 | 0.04 lbs | $8.00 | $7.65 | $0.35 |
| 209830 | 2020-02-12 | $98.34 | Priority Mail 3-Day | 3 | 3.04 lbs | $11.18 | $10.33 | $0.85 |
| 209832 | 2020-02-12 | $37.59 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 0.17 lbs | $8.60 | $7.65 | $0.95 |
| 209836 | 2020-02-12 | $15.89 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 209837 | 2020-02-12 | $11.78 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.02 lbs | $8.00 | $7.65 | $0.35 |
| 209840 | 2020-02-12 | $308.90 | Ground | 5 | 23.10 lbs | $37.95 | $25.82 | $12.13 |
| 209842 | 2020-02-13 | $26.29 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 209847 | 2020-02-13 | $10.96 | Priority Mail 2-Day Flat Rate Envelope | 4 | 0.10 lbs | $8.00 | $7.65 | $0.35 |
| 209848 | 2020-02-13 | $26.50 | Priority Mail 3-Day Flat Rate Envelope | 1 | 1.00 lbs | $8.00 | $7.65 | $0.35 |
| 209849 | 2020-02-13 | $38.80 | Priority Mail 2-Day Small Flat Rate Box | 6 | 0.65 lbs | $8.50 | $7.65 | $0.85 |
| 209850 | 2020-02-13 | $49.14 | Priority Mail 2-Day | 1 | 1.20 lbs | $8.97 | $8.12 | $0.85 |
| 209851 | 2020-02-13 | $21.85 | Priority Mail 2-Day Flat Rate Envelope | 15 | 0.20 lbs | $8.00 | $7.15 | $0.85 |
| 209852 | 2020-02-13 | $89.78 | Priority Mail 3-Day | 3 | 9.57 lbs | $13.01 | $10.84 | $2.17 |
| 209853 | 2020-02-13 | $43.83 | First-Class Package Service | 10 | 0.50 lbs | $4.93 | $4.08 | $0.85 |
| 209857 | 2020-02-14 | $67.11 | First-Class Package International Service | 5 | 0.83 lbs | $27.96 | $19.71 | $8.25 |
| 209858 | 2020-02-14 | $14.57 | Priority Mail 2-Day Flat Rate Envelope | 3 | 0.15 lbs | $8.00 | $7.65 | $0.35 |
| 209859 | 2020-02-14 | $38.67 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.07 lbs | $8.00 | $7.75 | $0.25 |
| 209860 | 2020-02-14 | $89.50 | Priority Mail 3-Day | 10 | 2.80 lbs | $16.91 | $11.13 | $5.78 |
| 209861 | 2020-02-14 | $19.38 | First-Class Package Service | 1 | 0.20 lbs | $4.57 | $3.52 | $1.05 |
| 209863 | 2020-02-14 | $44.29 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.35 lbs | $8.00 | $7.65 | $0.35 |
| 209865 | 2020-02-14 | $30.48 | Priority Mail 2-Day Small Flat Rate Box | 2 | 0.70 lbs | $8.50 | $7.65 | $0.85 |
| 209866 | 2020-02-14 | $12.35 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.15 lbs | $8.00 | $7.15 | $0.85 |
| 209868 | 2020-02-14 | $37.59 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 0.17 lbs | $8.60 | $7.65 | $0.95 |
| 209869 | 2020-02-15 | $41.39 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 1.20 lbs | $8.60 | $7.65 | $0.95 |
| 209875 | 2020-02-15 | $36.39 | Priority Mail 2-Day Flat Rate Envelope | 1 | 1.27 lbs | $8.00 | $7.65 | $0.35 |
| 209876 | 2020-02-15 | $10.98 | Priority Mail 3-Day Flat Rate Envelope | 2 | 0.10 lbs | $8.00 | $7.65 | $0.35 |
| 209878 | 2020-02-15 | $24.79 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.45 lbs | $8.00 | $7.65 | $0.35 |
| 209879 | 2020-02-15 | $75.40 | Priority Mail 2-Day Flat Rate Envelope | 3 | 1.31 lbs | $8.00 | $7.65 | $0.35 |
| 209880 | 2020-02-15 | $18.60 | Priority Mail 2-Day | 1 | 0.95 lbs | $9.61 | $8.76 | $0.85 |
| 209882 | 2020-02-15 | $10.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.01 lbs | $8.00 | $7.65 | $0.35 |
| 209887 | 2020-02-16 | $25.84 | First-Class Package Service | 1 | 0.65 lbs | $6.55 | $5.70 | $0.85 |
| 209888 | 2020-02-16 | $48.52 | Priority Mail 3-Day | 2 | 1.45 lbs | $10.84 | $9.99 | $0.85 |
| 209889 | 2020-02-16 | $10.48 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.08 lbs | $8.00 | $7.65 | $0.35 |
| 209891 | 2020-02-16 | $32.36 | Priority Mail 2-Day Flat Rate Envelope | 4 | 0.97 lbs | $8.00 | $7.65 | $0.35 |
| 209892 | 2020-02-16 | $21.94 | Priority Mail 2-Day Flat Rate Envelope | 6 | 0.08 lbs | $8.00 | $7.65 | $0.35 |
| 209893 | 2020-02-16 | $21.94 | Priority Mail 3-Day Flat Rate Envelope | 6 | 0.08 lbs | $8.00 | $7.65 | $0.35 |
| 209894 | 2020-02-16 | $24.29 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.41 lbs | $8.00 | $7.65 | $0.35 |
| 209897 | 2020-02-16 | $93.86 | Priority Mail 2-Day | 3 | 2.75 lbs | $18.99 | $13.20 | $5.79 |
| 209900 | 2020-02-16 | $17.93 | Priority Mail 3-Day Flat Rate Envelope | 7 | 0.12 lbs | $8.00 | $7.65 | $0.35 |
| 209901 | 2020-02-16 | $19.46 | Priority Mail 3-Day Small Flat Rate Box | 4 | 0.48 lbs | $8.50 | $7.65 | $0.85 |
| 209907 | 2020-02-17 | $4.34 | First-Class Mail Stamped Letter | 1 | 0.03 lbs | $3.35 | $2.84 | $0.51 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |