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 |
|---|---|---|---|---|---|---|---|---|
| 212767 | 2020-06-09 | $151.33 | Priority Mail Express International | 2 | 2.40 lbs | $85.37 | $8.59 | $76.78 |
| 212768 | 2020-06-09 | $67.77 | Priority Mail 3-Day | 3 | 1.12 lbs | $13.00 | $12.15 | $0.85 |
| 212769 | 2020-06-10 | $68.90 | InternationalPriorityShipping | 5 | 1.25 lbs | $20.70 | $9.99 | $10.71 |
| 212770 | 2020-06-10 | $19.78 | USPSFirstClass | 1 | 0.95 lbs | $8.95 | $9.99 | $-1.04 |
| 212771 | 2020-06-10 | $23.38 | USPSPriority | 1 | 1.00 lbs | $8.68 | $7.56 | $1.12 |
| 212772 | 2020-06-10 | $40.56 | First-Class Package Service | 1 | 0.45 lbs | $4.45 | $4.00 | $0.45 |
| 212773 | 2020-06-10 | $26.86 | First-Class Package Service | 1 | 0.50 lbs | $5.37 | $4.00 | $1.37 |
| 212774 | 2020-06-10 | $8.14 | USPSFirstClass | 1 | 0.05 lbs | $4.15 | $2.84 | $1.31 |
| 212776 | 2020-06-10 | $5.98 | USPSFirstClass | 1 | 0.01 lbs | $4.09 | $2.93 | $1.16 |
| 212779 | 2020-06-10 | $28.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.42 lbs | $8.00 | $7.65 | $0.35 |
| 212780 | 2020-06-10 | $12.29 | First-Class Mail Stamped Letter | 1 | 0.08 lbs | $3.50 | $2.84 | $0.66 |
| 212781 | 2020-06-11 | $27.62 | USPSFirstClass | 5 | 0.50 lbs | $5.67 | $3.31 | $2.36 |
| 212784 | 2020-06-10 | $9.34 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.35 | $3.05 | $0.30 |
| 212785 | 2020-06-10 | $39.99 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.20 lbs | $8.50 | $7.65 | $0.85 |
| 212786 | 2020-06-10 | $10.34 | First-Class Mail Stamped Letter | 1 | 0.07 lbs | $3.35 | $2.78 | $0.57 |
| 212790 | 2020-06-11 | $96.70 | First-Class Package International Service | 2 | 2.15 lbs | $51.10 | $60.85 | $-9.75 |
| 212792 | 2020-06-11 | $40.88 | Priority Mail 2-Day | 3 | 2.40 lbs | $16.91 | $16.06 | $0.85 |
| 212793 | 2020-06-11 | $10.23 | USPSFirstClass | 1 | 0.05 lbs | $4.34 | $3.52 | $0.82 |
| 212796 | 2020-06-11 | $26.94 | USPSFirstClass | 1 | 0.30 lbs | $5.75 | $3.31 | $2.44 |
| 212797 | 2020-06-11 | $51.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.45 lbs | $8.50 | $7.65 | $0.85 |
| 212798 | 2020-06-11 | $7.83 | First-Class Mail Stamped Letter | 2 | 0.08 lbs | $3.35 | $2.84 | $0.51 |
| 212799 | 2020-06-11 | $56.35 | Priority Mail International Flat Rate Envelope | 5 | 1.75 lbs | $26.40 | $26.50 | $-0.10 |
| 212800 | 2020-06-11 | $12.98 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.25 lbs | $8.00 | $7.65 | $0.35 |
| 212802 | 2020-06-11 | $24.48 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.00 | $7.75 | $0.25 |
| 212804 | 2020-06-12 | $31.06 | USPSPriority | 1 | 1.65 lbs | $11.78 | $7.65 | $4.13 |
| 212805 | 2020-06-12 | $8.25 | USPSFirstClass | 1 | 0.03 lbs | $4.12 | $2.84 | $1.28 |
| 212806 | 2020-06-12 | $7.19 | First-Class Mail Stamped Letter | 1 | 0.03 lbs | $3.20 | $3.05 | $0.15 |
| 212807 | 2020-06-12 | $18.64 | USPSFirstClass | 1 | 0.35 lbs | $5.34 | $3.31 | $2.03 |
| 212808 | 2020-06-12 | $8.54 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $3.22 | $0.13 |
| 212809 | 2020-06-12 | $7.19 | First-Class Mail Stamped Letter | 1 | 0.03 lbs | $3.20 | $3.05 | $0.15 |
| 212810 | 2020-06-12 | $19.82 | USPSFirstClass | 1 | 0.95 lbs | $8.50 | $8.12 | $0.38 |
| 212811 | 2020-06-12 | $24.47 | Priority Mail 2-Day Flat Rate Envelope | 3 | 0.28 lbs | $8.00 | $7.65 | $0.35 |
| 212812 | 2020-06-12 | $4.19 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $3.20 | $2.78 | $0.42 |
| 212814 | 2020-06-12 | $21.38 | Priority Mail 3-Day | 1 | 0.95 lbs | $11.39 | $10.54 | $0.85 |
| 212815 | 2020-06-12 | $12.25 | USPSFirstClass | 3 | 0.60 lbs | $5.84 | $4.46 | $1.38 |
| 212817 | 2020-06-12 | $27.62 | USPSFirstClass | 2 | 0.58 lbs | $9.76 | $8.15 | $1.61 |
| 212818 | 2020-06-12 | $11.34 | USPSFirstClass | 1 | 0.19 lbs | $4.35 | $2.93 | $1.42 |
| 212820 | 2020-06-12 | $84.53 | Priority Mail 2-Day | 2 | 2.75 lbs | $14.34 | $7.75 | $6.59 |
| 212821 | 2020-06-12 | $28.12 | USPSFirstClass | 3 | 0.68 lbs | $12.63 | $7.80 | $4.83 |
| 212826 | 2020-06-12 | $41.79 | Priority Mail 3-Day Flat Rate Envelope | 3 | 0.90 lbs | $8.00 | $7.65 | $0.35 |
| 212828 | 2020-06-12 | $20.87 | First-Class Mail Stamped Letter | 13 | 0.15 lbs | $3.50 | $3.05 | $0.45 |
| 212831 | 2020-06-12 | $8.49 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.50 | $3.39 | $0.11 |
| 212832 | 2020-06-13 | $9.05 | USPSFirstClass | 1 | 0.10 lbs | $4.42 | $3.18 | $1.24 |
| 212833 | 2020-06-13 | $9.76 | USPSFirstClass | 1 | 0.50 lbs | $5.20 | $5.70 | $-0.50 |
| 212835 | 2020-06-13 | $16.94 | First-Class Package Service | 5 | 0.54 lbs | $5.99 | $4.32 | $1.67 |
| 212837 | 2020-06-13 | $10.64 | First-Class Mail Stamped Letter | 1 | 0.19 lbs | $3.65 | $2.84 | $0.81 |
| 212838 | 2020-06-13 | $10.34 | First-Class Mail Stamped Letter | 1 | 0.06 lbs | $3.35 | $2.84 | $0.51 |
| 212839 | 2020-06-13 | $9.75 | First-Class Package Service | 1 | 0.25 lbs | $3.76 | $3.31 | $0.45 |
| 212840 | 2020-06-13 | $5.99 | USPSFirstClass | 1 | 0.20 lbs | $3.99 | $2.78 | $1.21 |
| 212841 | 2020-06-13 | $85.97 | Priority Mail 3-Day Flat Rate Envelope | 3 | 2.85 lbs | $8.00 | $7.75 | $0.25 |
| 212844 | 2020-06-13 | $6.68 | USPSFirstClass | 1 | 0.20 lbs | $4.15 | $3.52 | $0.63 |
| 212845 | 2020-06-13 | $15.85 | USPSFirstClass | 1 | 0.10 lbs | $4.47 | $3.31 | $1.16 |
| 212846 | 2020-06-13 | $19.86 | USPSFirstClass | 2 | 0.90 lbs | $5.72 | $8.12 | $-2.40 |
| 212847 | 2020-06-13 | $12.71 | USPSFirstClass | 3 | 0.04 lbs | $7.94 | $2.78 | $5.16 |
| 212848 | 2020-06-13 | $7.10 | USPSFirstClass | 2 | 0.10 lbs | $4.12 | $3.05 | $1.07 |
| 212849 | 2020-06-13 | $18.75 | USPSFirstClass | 2 | 0.15 lbs | $8.29 | $3.25 | $5.04 |
| 212850 | 2020-06-13 | $23.40 | First-Class Package Service | 1 | 0.45 lbs | $4.91 | $4.46 | $0.45 |
| 212851 | 2020-06-13 | $80.48 | Priority Mail International | 1 | 3.20 lbs | $59.74 | $48.88 | $10.86 |
| 212852 | 2020-06-14 | $23.34 | Priority Mail 2-Day | 5 | 1.50 lbs | $11.39 | $10.54 | $0.85 |
| 212853 | 2020-06-14 | $21.64 | USPSFirstClass | 3 | 0.30 lbs | $5.00 | $2.84 | $2.16 |
| 212854 | 2020-06-14 | $11.54 | USPSFirstClass | 1 | 0.19 lbs | $4.55 | $3.18 | $1.37 |
| 212855 | 2020-06-14 | $29.77 | Priority Mail 2-Day Flat Rate Envelope | 3 | 0.45 lbs | $8.00 | $7.65 | $0.35 |
| 212856 | 2020-06-14 | $19.94 | Priority Mail 2-Day Flat Rate Envelope | 6 | 0.11 lbs | $8.00 | $7.65 | $0.35 |
| 212857 | 2020-06-14 | $8.52 | Ground | 10 | 0.10 lbs | $2.62 | $2.93 | $-0.31 |
| 212858 | 2020-06-14 | $24.79 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 212859 | 2020-06-15 | $15.85 | USPSFirstClass | 1 | 0.10 lbs | $4.47 | $2.84 | $1.63 |
| 212860 | 2020-06-14 | $22.94 | Priority Mail 2-Day Flat Rate Envelope | 6 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 212861 | 2020-06-14 | $65.48 | Priority Mail 3-Day | 1 | 3.95 lbs | $11.49 | $14.18 | $-2.69 |
| 212862 | 2020-06-15 | $23.69 | First-Class Mail Stamped Letter | 3 | 0.19 lbs | $3.65 | $2.84 | $0.81 |
| 212864 | 2020-06-15 | $26.39 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.00 | $7.75 | $0.25 |
| 212865 | 2020-06-15 | $25.18 | USPSFirstClass | 1 | 0.45 lbs | $5.80 | $8.15 | $-2.35 |
| 212866 | 2020-06-15 | $35.13 | Ground | 2 | 0.38 lbs | $21.15 | $18.65 | $2.50 |
| 212868 | 2020-06-15 | $16.02 | Priority Mail 3-Day | 3 | 0.27 lbs | $8.65 | $7.80 | $0.85 |
| 212869 | 2020-06-15 | $10.34 | First-Class Mail Stamped Letter | 1 | 0.06 lbs | $3.35 | $3.05 | $0.30 |
| 212870 | 2020-06-15 | $17.78 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.90 lbs | $8.00 | $7.65 | $0.35 |
| 212871 | 2020-06-15 | $5.33 | First-Class Mail Stamped Letter | 2 | 0.02 lbs | $3.35 | $3.18 | $0.17 |
| 212872 | 2020-06-15 | $126.26 | Priority Mail 3-Day Medium Flat Rate Box | 7 | 6.35 lbs | $14.45 | $13.20 | $1.25 |
| 212873 | 2020-06-15 | $12.36 | USPSFirstClass | 1 | 0.34 lbs | $5.04 | $4.00 | $1.04 |
| 212874 | 2020-06-15 | $25.08 | First-Class Package Service | 1 | 0.65 lbs | $5.79 | $5.54 | $0.25 |
| 212875 | 2020-06-15 | $38.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.50 | $7.65 | $0.85 |
| 212876 | 2020-06-16 | $8.19 | USPSFirstClass | 1 | 0.05 lbs | $4.20 | $2.93 | $1.27 |
| 212877 | 2020-06-15 | $32.40 | Priority Mail 3-Day Flat Rate Envelope | 8 | 0.32 lbs | $8.00 | $7.65 | $0.35 |
| 212878 | 2020-06-15 | $12.29 | First-Class Mail Stamped Letter | 1 | 0.08 lbs | $3.50 | $2.93 | $0.57 |
| 212879 | 2020-06-16 | $7.28 | USPSFirstClass | 1 | 0.20 lbs | $4.05 | $3.25 | $0.80 |
| 212880 | 2020-06-15 | $43.49 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.40 lbs | $8.50 | $7.65 | $0.85 |
| 212881 | 2020-06-15 | $36.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 1.10 lbs | $8.00 | $7.65 | $0.35 |
| 212882 | 2020-06-16 | $5.18 | First-Class Mail Stamped Letter | 2 | 0.02 lbs | $3.20 | $3.18 | $0.02 |
| 212884 | 2020-06-16 | $50.38 | Priority Mail 2-Day | 1 | 0.75 lbs | $11.39 | $10.54 | $0.85 |
| 212886 | 2020-06-16 | $30.32 | Priority Mail 2-Day | 7 | 1.18 lbs | $11.39 | $10.54 | $0.85 |
| 212887 | 2020-06-16 | $32.61 | Ground Home Delivery | 4 | 1.04 lbs | $21.55 | $15.27 | $6.28 |
| 212888 | 2020-06-16 | $21.48 | Priority Mail 3-Day Flat Rate Envelope | 2 | 0.62 lbs | $8.00 | $7.65 | $0.35 |
| 212890 | 2020-06-16 | $8.24 | USPSFirstClass | 1 | 0.03 lbs | $4.22 | $3.05 | $1.17 |
| 212891 | 2020-06-16 | $66.12 | Priority Mail 2-Day Padded Flat Rate Envelope | 2 | 2.20 lbs | $8.60 | $7.65 | $0.95 |
| 212892 | 2020-06-16 | $11.62 | USPSFirstClass | 1 | 0.05 lbs | $4.34 | $2.93 | $1.41 |
| 212895 | 2020-06-16 | $13.81 | USPSFirstClass | 1 | 0.10 lbs | $4.42 | $2.84 | $1.58 |
| 212896 | 2020-06-16 | $97.75 | Direct Link International | 11 | 1.21 lbs | $26.07 | $7.65 | $18.42 |
| 212899 | 2020-06-16 | $7.64 | First-Class Mail Stamped Letter | 1 | 0.18 lbs | $3.65 | $3.31 | $0.34 |
| 212900 | 2020-06-16 | $25.64 | First-Class Package Service | 1 | 0.85 lbs | $6.15 | $5.70 | $0.45 |
| 212901 | 2020-06-16 | $124.76 | Priority Mail 3-Day | 5 | 2.95 lbs | $13.00 | $9.98 | $3.02 |
| 212902 | 2020-06-16 | $54.60 | Priority Mail 3-Day | 1 | 1.10 lbs | $9.61 | $8.76 | $0.85 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |