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 |
|---|---|---|---|---|---|---|---|---|
| 214759 | 2020-08-22 | $27.98 | USPSFirstClass | 4 | 1.30 lbs | $11.88 | $11.18 | $0.70 |
| 214762 | 2020-08-22 | $44.78 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.75 lbs | $8.00 | $8.15 | $-0.15 |
| 214763 | 2020-08-22 | $18.74 | USPSFirstClass | 1 | 0.95 lbs | $8.75 | $8.76 | $-0.01 |
| 214764 | 2020-08-22 | $23.80 | First-Class Package Service | 4 | 0.40 lbs | $3.84 | $3.39 | $0.45 |
| 214765 | 2020-08-22 | $84.28 | Priority Mail 2-Day | 3 | 2.65 lbs | $15.01 | $12.15 | $2.86 |
| 214766 | 2020-08-22 | $18.94 | First-Class Package Service | 3 | 0.30 lbs | $3.97 | $3.05 | $0.92 |
| 214767 | 2020-08-22 | $17.87 | First-Class Package Service | 3 | 0.27 lbs | $3.66 | $3.21 | $0.45 |
| 214769 | 2020-08-22 | $28.95 | Priority Mail 3-Day | 6 | 1.49 lbs | $9.61 | $8.92 | $0.69 |
| 214770 | 2020-08-22 | $70.84 | Priority Mail 3-Day | 6 | 1.40 lbs | $12.04 | $11.18 | $0.86 |
| 214771 | 2020-08-22 | $16.41 | First-Class Package Service | 1 | 0.30 lbs | $3.66 | $3.21 | $0.45 |
| 214772 | 2020-08-22 | $9.08 | USPSFirstClass | 1 | 0.05 lbs | $4.19 | $2.84 | $1.35 |
| 214773 | 2020-08-23 | $19.30 | USPSFirstClass | 1 | 0.95 lbs | $8.50 | $8.12 | $0.38 |
| 214776 | 2020-08-22 | $45.92 | Priority Mail 2-Day | 12 | 1.65 lbs | $12.04 | $11.18 | $0.86 |
| 214777 | 2020-08-22 | $14.39 | First-Class Package Service | 4 | 0.50 lbs | $4.43 | $4.18 | $0.25 |
| 214778 | 2020-08-22 | $10.64 | First-Class Mail Stamped Letter | 1 | 0.19 lbs | $3.65 | $3.05 | $0.60 |
| 214779 | 2020-08-22 | $29.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.40 lbs | $8.50 | $8.05 | $0.45 |
| 214780 | 2020-08-22 | $38.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.25 lbs | $8.50 | $7.65 | $0.85 |
| 214781 | 2020-08-23 | $6.28 | USPSFirstClass | 1 | 0.01 lbs | $4.09 | $2.93 | $1.16 |
| 214785 | 2020-08-23 | $38.29 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.50 | $7.65 | $0.85 |
| 214786 | 2020-08-23 | $12.69 | First-Class Package Service | 1 | 0.05 lbs | $3.19 | $2.74 | $0.45 |
| 214788 | 2020-08-23 | $20.09 | USPSFirstClass | 1 | 0.95 lbs | $10.10 | $11.19 | $-1.09 |
| 214789 | 2020-08-23 | $14.37 | First-Class Package Service | 1 | 0.10 lbs | $3.38 | $2.93 | $0.45 |
| 214790 | 2020-08-23 | $15.53 | First-Class Package Service | 4 | 0.25 lbs | $3.97 | $3.52 | $0.45 |
| 214791 | 2020-08-23 | $18.96 | Priority Mail 2-Day | 1 | 0.95 lbs | $8.97 | $8.12 | $0.85 |
| 214792 | 2020-08-23 | $283.45 | Ground | 1 | 15.55 lbs | $33.46 | $26.64 | $6.82 |
| 214795 | 2020-08-23 | $19.25 | USPSFirstClass | 1 | 0.95 lbs | $8.50 | $8.12 | $0.38 |
| 214796 | 2020-08-23 | $9.33 | USPSFirstClass | 1 | 0.05 lbs | $4.44 | $3.18 | $1.26 |
| 214797 | 2020-08-23 | $8.54 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.05 | $0.30 |
| 214799 | 2020-08-23 | $30.13 | Priority Mail 2-Day | 1 | 0.74 lbs | $10.84 | $9.99 | $0.85 |
| 214800 | 2020-08-23 | $256.54 | Priority Mail 2-Day | 2 | 16.30 lbs | $33.76 | $32.91 | $0.85 |
| 214806 | 2020-08-23 | $6.20 | First-Class Package Service | 3 | 0.06 lbs | $3.23 | $2.78 | $0.45 |
| 214810 | 2020-08-23 | $109.16 | Priority Mail 3-Day Flat Rate Envelope | 3 | 6.95 lbs | $8.00 | $7.75 | $0.25 |
| 214814 | 2020-08-23 | $6.35 | First-Class Package Service | 1 | 0.05 lbs | $3.19 | $2.74 | $0.45 |
| 214815 | 2020-08-23 | $24.96 | First-Class Package Service | 1 | 0.35 lbs | $3.97 | $4.57 | $-0.60 |
| 214816 | 2020-08-23 | $12.13 | First-Class Package Service | 2 | 0.32 lbs | $4.25 | $3.25 | $1.00 |
| 214817 | 2020-08-23 | $15.76 | First-Class Package Service | 1 | 0.30 lbs | $3.97 | $3.52 | $0.45 |
| 214822 | 2020-08-24 | $12.10 | USPSFirstClass | 1 | 0.05 lbs | $4.30 | $2.84 | $1.46 |
| 214823 | 2020-08-23 | $12.26 | Priority Mail 2-Day | 1 | 0.01 lbs | $9.27 | $7.65 | $1.62 |
| 214824 | 2020-08-24 | $13.73 | USPSFirstClass | 3 | 0.10 lbs | $4.05 | $2.78 | $1.27 |
| 214826 | 2020-08-24 | $16.89 | USPSFirstClass | 1 | 0.05 lbs | $4.61 | $2.93 | $1.68 |
| 214827 | 2020-08-24 | $19.34 | USPSFirstClass | 1 | 0.95 lbs | $9.35 | $10.54 | $-1.19 |
| 214828 | 2020-08-24 | $9.33 | USPSFirstClass | 1 | 0.05 lbs | $4.44 | $3.18 | $1.26 |
| 214829 | 2020-08-23 | $82.48 | Priority Mail 2-Day Flat Rate Envelope | 2 | 2.70 lbs | $8.00 | $8.15 | $-0.15 |
| 214830 | 2020-08-23 | $92.79 | Priority Mail 2-Day Medium Flat Rate Box | 6 | 15.60 lbs | $14.45 | $13.20 | $1.25 |
| 214831 | 2020-08-23 | $22.40 | First-Class Package Service | 3 | 0.47 lbs | $4.33 | $4.08 | $0.25 |
| 214832 | 2020-08-23 | $30.04 | First-Class Package Service | 1 | 0.46 lbs | $4.63 | $4.18 | $0.45 |
| 214833 | 2020-08-24 | $82.67 | First-Class Package Service | 1 | 0.82 lbs | $6.15 | $5.70 | $0.45 |
| 214834 | 2020-08-24 | $10.70 | USPSFirstClass | 2 | 0.07 lbs | $4.35 | $3.18 | $1.17 |
| 214836 | 2020-08-24 | $13.40 | First-Class Package Service | 3 | 0.12 lbs | $3.63 | $3.18 | $0.45 |
| 214838 | 2020-08-24 | $20.95 | Priority Mail 2-Day Flat Rate Envelope | 5 | 0.12 lbs | $8.00 | $7.65 | $0.35 |
| 214839 | 2020-08-24 | $46.40 | Priority Mail 2-Day | 1 | 1.20 lbs | $9.61 | $8.76 | $0.85 |
| 214840 | 2020-08-24 | $42.53 | USPSFirstClass | 1 | 0.60 lbs | $7.22 | $5.27 | $1.95 |
| 214841 | 2020-08-24 | $36.49 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.50 | $7.65 | $0.85 |
| 214842 | 2020-08-24 | $24.10 | First-Class Package Service | 2 | 0.37 lbs | $4.12 | $4.46 | $-0.34 |
| 214845 | 2020-08-24 | $36.10 | First-Class Package Service | 1 | 0.50 lbs | $4.91 | $4.46 | $0.45 |
| 214846 | 2020-08-24 | $45.94 | USPSFirstClass | 1 | 0.45 lbs | $6.95 | $4.46 | $2.49 |
| 214847 | 2020-08-24 | $4.19 | First-Class Mail Stamped Letter | 1 | 0.02 lbs | $3.20 | $3.18 | $0.02 |
| 214848 | 2020-08-24 | $15.96 | First-Class Mail Stamped Letter | 4 | 0.13 lbs | $3.50 | $3.52 | $-0.02 |
| 214849 | 2020-08-24 | $19.46 | USPSFirstClass | 1 | 0.95 lbs | $8.50 | $8.12 | $0.38 |
| 214850 | 2020-08-24 | $48.82 | USPSFirstClass | 1 | 0.45 lbs | $6.95 | $4.46 | $2.49 |
| 214851 | 2020-08-24 | $48.81 | USPSFirstClass | 1 | 0.45 lbs | $6.65 | $4.00 | $2.65 |
| 214853 | 2020-08-24 | $51.03 | Priority Mail 2-Day | 1 | 0.75 lbs | $12.04 | $11.19 | $0.85 |
| 214854 | 2020-08-24 | $26.19 | First-Class Package Service | 4 | 0.42 lbs | $4.63 | $3.39 | $1.24 |
| 214856 | 2020-08-24 | $8.90 | First-Class Package Service | 1 | 0.10 lbs | $3.19 | $2.74 | $0.45 |
| 214857 | 2020-08-24 | $18.96 | Priority Mail 3-Day | 1 | 0.95 lbs | $8.97 | $8.12 | $0.85 |
| 214858 | 2020-08-24 | $19.22 | First-Class Package Service | 1 | 0.35 lbs | $4.43 | $4.18 | $0.25 |
| 214859 | 2020-08-25 | $10.51 | USPSFirstClass | 1 | 0.03 lbs | $4.19 | $2.78 | $1.41 |
| 214860 | 2020-08-25 | $45.69 | USPSFirstClass | 1 | 0.45 lbs | $6.70 | $4.08 | $2.62 |
| 214861 | 2020-08-25 | $159.14 | Priority Mail 2-Day Large Flat Rate Box | 1 | 12.88 lbs | $19.15 | $13.20 | $5.95 |
| 214863 | 2020-08-25 | $12.17 | USPSFirstClass | 2 | 0.10 lbs | $4.13 | $2.84 | $1.29 |
| 214864 | 2020-08-25 | $26.94 | USPSPriority | 1 | 1.78 lbs | $15.44 | $11.19 | $4.25 |
| 214865 | 2020-08-25 | $20.54 | USPSFirstClass | 1 | 0.95 lbs | $8.95 | $9.99 | $-1.04 |
| 214866 | 2020-08-25 | $15.51 | First-Class Package Service | 4 | 0.62 lbs | $5.65 | $5.40 | $0.25 |
| 214867 | 2020-08-25 | $19.46 | USPSFirstClass | 1 | 0.95 lbs | $8.50 | $8.12 | $0.38 |
| 214868 | 2020-08-25 | $21.99 | USPSFirstClass | 1 | 0.15 lbs | $4.77 | $2.93 | $1.84 |
| 214869 | 2020-08-25 | $95.57 | Priority Mail 2-Day | 4 | 1.97 lbs | $16.91 | $13.20 | $3.71 |
| 214870 | 2020-08-25 | $16.55 | USPSFirstClass | 1 | 0.10 lbs | $4.55 | $2.93 | $1.62 |
| 214871 | 2020-08-25 | $30.98 | Priority Mail 2-Day Flat Rate Envelope | 2 | 2.30 lbs | $8.00 | $7.75 | $0.25 |
| 214872 | 2020-08-25 | $34.81 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 7.20 lbs | $8.60 | $7.75 | $0.85 |
| 214874 | 2020-08-25 | $5.18 | First-Class Mail Stamped Letter | 2 | 0.02 lbs | $3.20 | $2.93 | $0.27 |
| 214875 | 2020-08-25 | $16.74 | First-Class Package Service | 3 | 0.28 lbs | $3.97 | $3.52 | $0.45 |
| 214876 | 2020-08-26 | $29.49 | USPSFirstClass | 1 | 0.40 lbs | $5.87 | $4.18 | $1.69 |
| 214877 | 2020-08-25 | $43.53 | Priority Mail 2-Day | 1 | 1.20 lbs | $12.04 | $7.65 | $4.39 |
| 214879 | 2020-08-25 | $75.03 | Priority Mail 2-Day | 21 | 1.17 lbs | $12.04 | $12.10 | $-0.06 |
| 214882 | 2020-08-25 | $232.52 | Priority Mail 3-Day Padded Flat Rate Envelope | 8 | 4.56 lbs | $8.60 | $7.65 | $0.95 |
| 214883 | 2020-08-26 | $8.96 | USPSFirstClass | 1 | 0.05 lbs | $4.12 | $2.78 | $1.34 |
| 214884 | 2020-08-25 | $42.96 | Priority Mail 3-Day | 1 | 1.40 lbs | $8.97 | $8.21 | $0.76 |
| 214885 | 2020-08-26 | $48.71 | USPSFirstClass | 1 | 0.45 lbs | $6.85 | $5.54 | $1.31 |
| 214886 | 2020-08-26 | $18.65 | USPSFirstClass | 1 | 0.05 lbs | $4.65 | $2.93 | $1.72 |
| 214887 | 2020-08-26 | $83.48 | Priority Mail 3-Day Flat Rate Envelope | 2 | 2.85 lbs | $8.00 | $8.15 | $-0.15 |
| 214890 | 2020-08-26 | $196.66 | Direct Link International | 6 | 7.08 lbs | $65.12 | $60.95 | $4.17 |
| 214891 | 2020-08-26 | $38.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.50 | $7.65 | $0.85 |
| 214892 | 2020-08-26 | $54.80 | USPSFirstClass | 1 | 4.05 lbs | $6.20 | $8.92 | $-2.72 |
| 214893 | 2020-08-26 | $18.50 | First-Class Package Service | 2 | 0.20 lbs | $4.12 | $3.67 | $0.45 |
| 214894 | 2020-08-26 | $53.96 | Priority Mail 2-Day | 3 | 1.24 lbs | $11.39 | $10.48 | $0.91 |
| 214895 | 2020-08-26 | $12.08 | First-Class Package Service | 3 | 0.42 lbs | $4.71 | $3.67 | $1.04 |
| 214896 | 2020-08-26 | $23.04 | USPSFirstClass | 1 | 0.40 lbs | $5.70 | $4.32 | $1.38 |
| 214898 | 2020-08-01 | $10.82 | Priority Mail 2-Day | 1 | 0.19 lbs | $8.83 | $2.93 | $5.90 |
| 214899 | 2020-08-26 | $29.07 | USPSFirstClass | 1 | 0.40 lbs | $5.97 | $4.32 | $1.65 |
| 214900 | 2020-08-26 | $32.98 | Priority Mail 3-Day | 2 | 1.90 lbs | $13.00 | $12.15 | $0.85 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |