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 |
|---|---|---|---|---|---|---|---|---|
| 211817 | 2020-05-01 | $49.91 | Priority Mail 2-Day | 6 | 0.95 lbs | $10.84 | $9.98 | $0.86 |
| 211818 | 2020-05-02 | $8.99 | USPSFirstClass | 1 | 0.05 lbs | $3.80 | $2.74 | $1.06 |
| 211819 | 2020-05-02 | $130.60 | Ground | 3 | 5.95 lbs | $36.63 | $27.92 | $8.71 |
| 211824 | 2020-05-02 | $44.86 | Priority Mail International Flat Rate Envelope | 9 | 0.09 lbs | $36.45 | $36.65 | $-0.20 |
| 211825 | 2020-05-02 | $60.42 | Priority Mail International Flat Rate Envelope | 8 | 0.36 lbs | $37.50 | $36.65 | $0.85 |
| 211826 | 2020-05-02 | $8.44 | USPSFirstClass | 1 | 0.05 lbs | $4.05 | $3.05 | $1.00 |
| 211828 | 2020-05-02 | $44.37 | Priority Mail 2-Day | 7 | 1.07 lbs | $12.04 | $11.18 | $0.86 |
| 211829 | 2020-05-02 | $105.86 | Priority Mail 2-Day Medium Flat Rate Box | 14 | 2.29 lbs | $15.40 | $12.13 | $3.27 |
| 211830 | 2020-05-02 | $22.99 | Priority Mail 2-Day | 6 | 0.54 lbs | $8.65 | $7.80 | $0.85 |
| 211831 | 2020-05-02 | $16.96 | Priority Mail 3-Day Flat Rate Envelope | 4 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 211832 | 2020-05-02 | $82.96 | Priority Mail 2-Day Medium Flat Rate Box | 9 | 2.17 lbs | $14.45 | $13.20 | $1.25 |
| 211833 | 2020-05-02 | $8.11 | USPSFirstClass | 1 | 0.19 lbs | $3.90 | $2.78 | $1.12 |
| 211834 | 2020-05-02 | $19.74 | USPSFirstClass | 1 | 0.95 lbs | $8.25 | $8.76 | $-0.51 |
| 211835 | 2020-05-02 | $6.20 | First-Class Mail Stamped Letter | 3 | 0.03 lbs | $3.20 | $3.05 | $0.15 |
| 211836 | 2020-05-02 | $44.60 | Priority Mail 3-Day | 1 | 1.35 lbs | $9.61 | $8.92 | $0.69 |
| 211837 | 2020-05-02 | $21.29 | Priority Mail 2-Day | 5 | 1.00 lbs | $10.84 | $9.98 | $0.86 |
| 211838 | 2020-05-02 | $6.54 | First-Class Mail Stamped Letter | 1 | 0.04 lbs | $3.35 | $2.78 | $0.57 |
| 211839 | 2020-05-02 | $9.06 | USPSFirstClass | 1 | 0.05 lbs | $3.90 | $2.78 | $1.12 |
| 211840 | 2020-05-02 | $29.49 | USPSFirstClass | 1 | 0.15 lbs | $3.80 | $3.21 | $0.59 |
| 211841 | 2020-05-02 | $32.15 | Priority Mail 2-Day | 6 | 0.81 lbs | $9.61 | $7.80 | $1.81 |
| 211842 | 2020-05-02 | $24.29 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.41 lbs | $8.00 | $7.65 | $0.35 |
| 211843 | 2020-05-02 | $18.94 | First-Class Package Service | 2 | 0.20 lbs | $3.76 | $3.31 | $0.45 |
| 211844 | 2020-05-03 | $15.65 | USPSFirstClass | 3 | 0.13 lbs | $4.95 | $2.76 | $2.19 |
| 211846 | 2020-05-02 | $24.29 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.41 lbs | $8.00 | $7.65 | $0.35 |
| 211847 | 2020-05-02 | $18.98 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 211848 | 2020-05-03 | $22.06 | Priority Mail 2-Day Small Flat Rate Box | 4 | 0.35 lbs | $8.50 | $7.65 | $0.85 |
| 211849 | 2020-05-03 | $7.16 | USPSFirstClass | 1 | 0.07 lbs | $4.20 | $3.18 | $1.02 |
| 211850 | 2020-05-03 | $25.74 | USPSFirstClass | 1 | 0.35 lbs | $4.75 | $4.08 | $0.67 |
| 211851 | 2020-05-03 | $8.24 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.84 | $0.51 |
| 211852 | 2020-05-03 | $9.58 | USPSFirstClass | 1 | 0.07 lbs | $4.05 | $3.05 | $1.00 |
| 211853 | 2020-05-03 | $18.55 | USPSFirstClass | 1 | 0.95 lbs | $8.00 | $8.12 | $-0.12 |
| 211854 | 2020-05-03 | $36.46 | Priority Mail 2-Day Small Flat Rate Box | 14 | 0.65 lbs | $8.50 | $7.65 | $0.85 |
| 211855 | 2020-05-03 | $12.98 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.24 lbs | $8.00 | $7.65 | $0.35 |
| 211856 | 2020-05-03 | $13.88 | First-Class Mail Stamped Letter | 2 | 0.12 lbs | $3.50 | $3.05 | $0.45 |
| 211857 | 2020-05-03 | $12.88 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.25 lbs | $8.00 | $7.65 | $0.35 |
| 211858 | 2020-05-03 | $14.98 | Priority Mail 2-Day Small Flat Rate Box | 2 | 0.15 lbs | $8.50 | $7.65 | $0.85 |
| 211859 | 2020-05-03 | $22.08 | USPSFirstClass | 2 | 0.40 lbs | $4.90 | $4.32 | $0.58 |
| 211861 | 2020-05-03 | $37.72 | Priority Mail 3-Day | 2 | 0.95 lbs | $12.04 | $11.19 | $0.85 |
| 211862 | 2020-05-03 | $7.12 | USPSFirstClass | 1 | 0.10 lbs | $4.00 | $2.93 | $1.07 |
| 211863 | 2020-05-03 | $17.48 | First-Class Mail Stamped Letter | 2 | 0.12 lbs | $3.50 | $3.18 | $0.32 |
| 211865 | 2020-05-03 | $143.21 | Priority Mail 2-Day Medium Flat Rate Box | 5 | 5.50 lbs | $14.45 | $8.92 | $5.53 |
| 211866 | 2020-05-03 | $13.78 | First-Class Package Service | 1 | 0.65 lbs | $5.79 | $5.54 | $0.25 |
| 211867 | 2020-05-03 | $89.99 | USPSPriority | 1 | 2.85 lbs | $20.00 | $13.20 | $6.80 |
| 211868 | 2020-05-03 | $38.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.25 lbs | $8.50 | $7.65 | $0.85 |
| 211869 | 2020-05-03 | $26.29 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.00 | $7.75 | $0.25 |
| 211871 | 2020-05-03 | $34.18 | Ground | 1 | 1.25 lbs | $18.39 | $14.86 | $3.53 |
| 211873 | 2020-05-03 | $209.37 | Priority Mail 3-Day | 4 | 9.90 lbs | $14.38 | $13.53 | $0.85 |
| 211875 | 2020-05-03 | $48.00 | Ground | 1 | 0.50 lbs | $18.23 | $17.37 | $0.86 |
| 211876 | 2020-05-04 | $7.90 | USPSFirstClass | 1 | 0.04 lbs | $4.00 | $2.93 | $1.07 |
| 211879 | 2020-05-03 | $19.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 211880 | 2020-05-03 | $24.08 | Priority Mail 2-Day Small Flat Rate Box | 2 | 0.47 lbs | $8.50 | $7.65 | $0.85 |
| 211881 | 2020-05-03 | $46.88 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.54 lbs | $8.00 | $8.76 | $-0.76 |
| 211882 | 2020-05-04 | $5.99 | USPSFirstClass | 1 | 0.03 lbs | $4.00 | $2.93 | $1.07 |
| 211883 | 2020-05-04 | $16.32 | USPSFirstClass | 2 | 0.40 lbs | $4.75 | $4.08 | $0.67 |
| 211884 | 2020-05-04 | $90.11 | USPSPriority | 1 | 2.85 lbs | $13.25 | $13.20 | $0.05 |
| 211885 | 2020-05-04 | $30.37 | Priority Mail 2-Day | 2 | 1.90 lbs | $10.39 | $9.54 | $0.85 |
| 211887 | 2020-05-04 | $85.07 | Priority Mail 3-Day Medium Flat Rate Box | 1 | 13.80 lbs | $14.45 | $18.30 | $-3.85 |
| 211888 | 2020-05-04 | $69.67 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 1.85 lbs | $8.60 | $7.65 | $0.95 |
| 211889 | 2020-05-04 | $137.48 | Priority Mail 3-Day Flat Rate Envelope | 2 | 3.61 lbs | $8.00 | $7.75 | $0.25 |
| 211890 | 2020-05-04 | $73.04 | USPSPriority | 3 | 3.30 lbs | $29.50 | $12.10 | $17.40 |
| 211891 | 2020-05-04 | $67.58 | Priority Mail 2-Day Flat Rate Envelope | 2 | 2.65 lbs | $8.00 | $7.75 | $0.25 |
| 211892 | 2020-05-04 | $9.54 | First-Class Package Service | 3 | 0.33 lbs | $4.57 | $4.32 | $0.25 |
| 211894 | 2020-05-04 | $194.55 | Priority Mail 1-Day | 70 | 4.20 lbs | $8.89 | $8.04 | $0.85 |
| 211896 | 2020-05-04 | $23.89 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.40 lbs | $8.00 | $7.65 | $0.35 |
| 211897 | 2020-05-04 | $11.99 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.05 lbs | $8.00 | $7.65 | $0.35 |
| 211898 | 2020-05-04 | $25.18 | USPSFirstClass | 2 | 0.80 lbs | $9.60 | $8.42 | $1.18 |
| 211900 | 2020-05-04 | $21.28 | Priority Mail 2-Day Small Flat Rate Box | 2 | 0.18 lbs | $8.50 | $7.65 | $0.85 |
| 211901 | 2020-05-04 | $20.59 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 0.35 lbs | $8.60 | $7.65 | $0.95 |
| 211904 | 2020-05-05 | $11.36 | USPSFirstClass | 1 | 0.06 lbs | $3.95 | $2.84 | $1.11 |
| 211905 | 2020-05-04 | $58.23 | Priority Mail 3-Day Medium Flat Rate Box | 2 | 5.72 lbs | $14.45 | $13.20 | $1.25 |
| 211906 | 2020-05-05 | $12.31 | USPSFirstClass | 1 | 0.30 lbs | $4.80 | $4.18 | $0.62 |
| 211907 | 2020-05-05 | $7.32 | USPSFirstClass | 1 | 0.10 lbs | $4.00 | $2.93 | $1.07 |
| 211909 | 2020-05-05 | $7.43 | USPSFirstClass | 1 | 0.10 lbs | $4.05 | $3.05 | $1.00 |
| 211910 | 2020-05-05 | $65.80 | Priority Mail 2-Day | 3 | 2.55 lbs | $8.69 | $7.68 | $1.01 |
| 211913 | 2020-05-05 | $36.89 | First-Class Package Service | 4 | 0.85 lbs | $6.15 | $5.70 | $0.45 |
| 211916 | 2020-05-05 | $8.34 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.84 | $0.51 |
| 211917 | 2020-05-05 | $18.24 | USPSFirstClass | 1 | 0.95 lbs | $8.25 | $8.76 | $-0.51 |
| 211918 | 2020-05-05 | $8.58 | First-Class Package Service - Retail | 2 | 0.06 lbs | $6.60 | $3.18 | $3.42 |
| 211919 | 2020-05-06 | $7.75 | USPSFirstClass | 2 | 0.05 lbs | $4.20 | $3.18 | $1.02 |
| 211920 | 2020-05-05 | $15.96 | Priority Mail 3-Day | 1 | 0.65 lbs | $8.97 | $7.75 | $1.22 |
| 211921 | 2020-05-05 | $80.37 | Priority Mail 2-Day | 4 | 1.56 lbs | $9.61 | $8.76 | $0.85 |
| 211922 | 2020-05-05 | $28.42 | First-Class Package Service | 2 | 0.60 lbs | $4.38 | $3.93 | $0.45 |
| 211923 | 2020-05-06 | $7.92 | USPSFirstClass | 1 | 0.05 lbs | $3.90 | $2.78 | $1.12 |
| 211925 | 2020-05-06 | $1.63 | USPSFirstClass | 1 | 0.01 lbs | $0.55 | $2.84 | $-2.29 |
| 211926 | 2020-05-06 | $20.01 | USPSFirstClass | 4 | 1.00 lbs | $8.45 | $9.98 | $-1.53 |
| 211928 | 2020-05-06 | $56.18 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.65 lbs | $8.00 | $7.65 | $0.35 |
| 211929 | 2020-05-06 | $102.33 | Ground | 4 | 3.24 lbs | $38.69 | $24.43 | $14.26 |
| 211930 | 2020-05-06 | $11.68 | USPSFirstClass | 1 | 0.10 lbs | $4.00 | $2.93 | $1.07 |
| 211931 | 2020-05-06 | $39.77 | Priority Mail 3-Day Flat Rate Envelope | 3 | 1.11 lbs | $8.00 | $7.75 | $0.25 |
| 211932 | 2020-05-06 | $128.57 | Priority Mail 2-Day Padded Flat Rate Envelope | 3 | 7.05 lbs | $8.60 | $7.75 | $0.85 |
| 211934 | 2020-05-06 | $8.15 | First-Class Mail Stamped Letter | 5 | 0.02 lbs | $3.20 | $2.93 | $0.27 |
| 211935 | 2020-05-06 | $47.63 | Priority Mail 3-Day | 1 | 1.20 lbs | $10.84 | $9.99 | $0.85 |
| 211938 | 2020-05-06 | $40.18 | USPSFirstClass | 2 | 1.90 lbs | $20.20 | $15.74 | $4.46 |
| 211939 | 2020-05-06 | $16.75 | USPSFirstClass | 1 | 0.37 lbs | $5.23 | $3.25 | $1.98 |
| 211940 | 2020-05-06 | $22.03 | Priority Mail 3-Day | 1 | 0.95 lbs | $12.04 | $11.19 | $0.85 |
| 211941 | 2020-05-06 | $39.77 | Priority Mail 3-Day Flat Rate Envelope | 3 | 1.11 lbs | $8.00 | $7.75 | $0.25 |
| 211942 | 2020-05-06 | $6.89 | First-Class Package Service | 1 | 0.07 lbs | $3.50 | $3.05 | $0.45 |
| 211943 | 2020-05-06 | $39.77 | Priority Mail 2-Day Flat Rate Envelope | 3 | 1.11 lbs | $8.00 | $7.75 | $0.25 |
| 211947 | 2020-05-06 | $181.52 | Priority Mail 1-Day | 16 | 6.20 lbs | $12.15 | $8.39 | $3.76 |
| 211948 | 2020-05-06 | $74.12 | USPSFirstClass | 8 | 0.42 lbs | $35.50 | $3.67 | $31.83 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |