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 |
|---|---|---|---|---|---|---|---|---|
| 212903 | 2020-06-16 | $149.98 | Ground | 6 | 4.20 lbs | $31.94 | $26.12 | $5.82 |
| 212904 | 2020-06-16 | $34.60 | Priority Mail 2-Day | 1 | 1.05 lbs | $9.61 | $8.92 | $0.69 |
| 212905 | 2020-06-16 | $36.21 | Priority Mail 2-Day | 1 | 3.10 lbs | $9.92 | $9.06 | $0.86 |
| 212906 | 2020-06-17 | $13.28 | USPSFirstClass | 5 | 0.25 lbs | $5.07 | $3.67 | $1.40 |
| 212908 | 2020-06-17 | $11.86 | USPSFirstClass | 2 | 0.06 lbs | $4.17 | $2.93 | $1.24 |
| 212909 | 2020-06-16 | $7.94 | First-Class Package Service | 2 | 0.38 lbs | $3.56 | $4.08 | $-0.52 |
| 212910 | 2020-06-17 | $12.24 | USPSFirstClass | 1 | 0.19 lbs | $4.40 | $3.05 | $1.35 |
| 212911 | 2020-06-17 | $44.59 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 1.35 lbs | $8.60 | $7.75 | $0.85 |
| 212912 | 2020-06-17 | $25.97 | Priority Mail 2-Day Flat Rate Envelope | 3 | 0.30 lbs | $8.00 | $7.98 | $0.02 |
| 212917 | 2020-06-17 | $37.70 | USPSFirstClass | 1 | 0.70 lbs | $6.87 | $8.76 | $-1.89 |
| 212920 | 2020-06-17 | $10.18 | USPSFirstClass | 1 | 0.05 lbs | $4.22 | $2.84 | $1.38 |
| 212921 | 2020-06-17 | $12.13 | USPSFirstClass | 3 | 0.57 lbs | $5.56 | $5.27 | $0.29 |
| 212922 | 2020-06-17 | $38.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.50 | $7.65 | $0.85 |
| 212923 | 2020-06-17 | $43.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.40 lbs | $8.50 | $7.65 | $0.85 |
| 212925 | 2020-06-17 | $26.89 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.90 lbs | $8.50 | $7.65 | $0.85 |
| 212926 | 2020-06-17 | $26.89 | Priority Mail 3-Day Small Flat Rate Box | 1 | 0.90 lbs | $8.50 | $7.65 | $0.85 |
| 212927 | 2020-06-17 | $115.84 | Priority Mail 2-Day | 5 | 4.20 lbs | $11.49 | $10.64 | $0.85 |
| 212928 | 2020-06-17 | $10.98 | First-Class Mail Stamped Letter | 1 | 0.06 lbs | $3.35 | $2.74 | $0.61 |
| 212929 | 2020-06-17 | $49.83 | Priority Mail 2-Day | 1 | 0.75 lbs | $10.84 | $10.42 | $0.42 |
| 212930 | 2020-06-17 | $12.99 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.19 lbs | $8.00 | $7.65 | $0.35 |
| 212931 | 2020-06-17 | $10.97 | Priority Mail 2-Day Small Flat Rate Box | 3 | 0.12 lbs | $8.50 | $7.65 | $0.85 |
| 212932 | 2020-06-17 | $111.01 | Ground | 4 | 4.60 lbs | $22.35 | $21.45 | $0.90 |
| 212935 | 2020-06-18 | $17.46 | USPSFirstClass | 2 | 0.40 lbs | $5.27 | $5.70 | $-0.43 |
| 212936 | 2020-06-17 | $82.52 | Priority Mail 2-Day | 2 | 4.25 lbs | $10.24 | $9.39 | $0.85 |
| 212940 | 2020-06-18 | $9.95 | First-Class Package Service | 8 | 0.34 lbs | $4.53 | $3.31 | $1.22 |
| 212941 | 2020-06-18 | $86.28 | Direct Link International | 8 | 1.38 lbs | $19.06 | $22.44 | $-3.38 |
| 212942 | 2020-06-18 | $43.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.40 lbs | $8.50 | $7.65 | $0.85 |
| 212945 | 2020-06-18 | $25.47 | Ground | 2 | 0.30 lbs | $9.89 | $13.32 | $-3.43 |
| 212946 | 2020-06-18 | $22.42 | USPSFirstClass | 3 | 0.15 lbs | $4.22 | $3.31 | $0.91 |
| 212947 | 2020-06-18 | $37.84 | Priority Mail 2-Day Small Flat Rate Box | 6 | 2.70 lbs | $8.50 | $7.65 | $0.85 |
| 212948 | 2020-06-18 | $13.48 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.11 lbs | $8.00 | $7.65 | $0.35 |
| 212949 | 2020-06-18 | $39.91 | Priority Mail 2-Day | 3 | 1.25 lbs | $10.84 | $9.98 | $0.86 |
| 212950 | 2020-06-18 | $9.97 | First-Class Mail Stamped Letter | 3 | 0.15 lbs | $3.50 | $3.05 | $0.45 |
| 212951 | 2020-06-18 | $24.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.45 lbs | $8.00 | $7.65 | $0.35 |
| 212952 | 2020-06-18 | $24.25 | Priority Mail 3-Day Flat Rate Envelope | 5 | 0.31 lbs | $8.00 | $7.65 | $0.35 |
| 212953 | 2020-06-18 | $9.44 | First-Class Package Service | 1 | 0.40 lbs | $4.45 | $4.00 | $0.45 |
| 212954 | 2020-06-18 | $54.54 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.80 lbs | $8.00 | $7.65 | $0.35 |
| 212957 | 2020-06-18 | $7.59 | USPSFirstClass | 1 | 0.25 lbs | $4.19 | $3.52 | $0.67 |
| 212958 | 2020-06-18 | $47.00 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.40 lbs | $8.50 | $7.65 | $0.85 |
| 212960 | 2020-06-18 | $311.42 | Priority Mail 2-Day | 7 | 25.62 lbs | $34.69 | $33.84 | $0.85 |
| 212961 | 2020-06-18 | $32.17 | Priority Mail 2-Day Small Flat Rate Box | 3 | 0.21 lbs | $8.50 | $7.65 | $0.85 |
| 212963 | 2020-06-18 | $79.92 | Priority Mail 3-Day | 2 | 2.30 lbs | $14.34 | $11.13 | $3.21 |
| 212964 | 2020-06-18 | $23.51 | First-Class Package Service | 2 | 0.48 lbs | $4.53 | $4.08 | $0.45 |
| 212965 | 2020-06-19 | $9.89 | USPSFirstClass | 1 | 0.05 lbs | $4.19 | $3.25 | $0.94 |
| 212966 | 2020-06-19 | $37.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.05 lbs | $8.50 | $7.65 | $0.85 |
| 212967 | 2020-06-19 | $17.84 | First-Class Mail Stamped Letter | 1 | 0.04 lbs | $3.35 | $3.05 | $0.30 |
| 212968 | 2020-06-19 | $9.08 | USPSFirstClass | 3 | 0.07 lbs | $4.07 | $2.93 | $1.14 |
| 212969 | 2020-06-19 | $21.34 | First-Class Mail Stamped Letter | 1 | 0.15 lbs | $3.35 | $3.18 | $0.17 |
| 212970 | 2020-06-19 | $18.07 | USPSFirstClass | 1 | 0.29 lbs | $5.35 | $3.39 | $1.96 |
| 212971 | 2020-06-19 | $107.57 | Priority Mail 3-Day | 3 | 5.10 lbs | $22.30 | $21.45 | $0.85 |
| 212972 | 2020-06-19 | $157.09 | Priority Mail 2-Day | 30 | 6.22 lbs | $10.59 | $11.49 | $-0.90 |
| 212973 | 2020-06-19 | $12.33 | USPSFirstClass | 1 | 0.07 lbs | $4.40 | $3.05 | $1.35 |
| 212974 | 2020-06-19 | $163.01 | Priority Mail 2-Day | 2 | 4.81 lbs | $15.03 | $14.18 | $0.85 |
| 212975 | 2020-06-19 | $247.97 | Ground | 7 | 19.50 lbs | $24.34 | $15.84 | $8.50 |
| 212976 | 2020-06-19 | $220.02 | Ground | 1 | 21.00 lbs | $26.83 | $28.11 | $-1.28 |
| 212979 | 2020-06-19 | $272.61 | Priority Mail 3-Day | 1 | 15.55 lbs | $22.62 | $21.77 | $0.85 |
| 212980 | 2020-06-05 | $2.79 | First-Class Package Service | 1 | 0.06 lbs | $0.00 | $2.93 | $-2.93 |
| 212981 | 2020-06-19 | $87.31 | Priority Mail 2-Day | 1 | 4.40 lbs | $19.32 | $18.47 | $0.85 |
| 212982 | 2020-06-19 | $6.24 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.93 | $0.42 |
| 212983 | 2020-06-19 | $83.98 | Priority Mail International Padded Flat Rate Envelope | 2 | 2.15 lbs | $26.40 | $25.55 | $0.85 |
| 212984 | 2020-06-19 | $7.19 | First-Class Mail Stamped Letter | 1 | 0.03 lbs | $3.20 | $3.05 | $0.15 |
| 212985 | 2020-06-20 | $6.39 | USPSFirstClass | 1 | 0.01 lbs | $4.04 | $2.84 | $1.20 |
| 212986 | 2020-06-19 | $110.05 | Priority Mail 2-Day | 2 | 5.30 lbs | $25.03 | $24.18 | $0.85 |
| 212988 | 2020-06-20 | $16.01 | USPSFirstClass | 2 | 0.90 lbs | $8.18 | $8.12 | $0.06 |
| 212989 | 2020-06-20 | $21.19 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.80 lbs | $8.00 | $7.75 | $0.25 |
| 212990 | 2020-06-20 | $23.24 | USPSFirstClass | 1 | 0.15 lbs | $3.95 | $2.84 | $1.11 |
| 212991 | 2020-06-20 | $29.44 | Priority Mail 1-Day Flat Rate Envelope | 8 | 0.46 lbs | $8.00 | $7.65 | $0.35 |
| 212992 | 2020-06-20 | $25.43 | Priority Mail 2-Day Flat Rate Envelope | 7 | 0.25 lbs | $8.00 | $7.65 | $0.35 |
| 212993 | 2020-06-20 | $49.58 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.35 lbs | $8.00 | $7.65 | $0.35 |
| 212996 | 2020-06-20 | $60.38 | Priority Mail 2-Day | 4 | 3.33 lbs | $9.92 | $8.21 | $1.71 |
| 212997 | 2020-06-20 | $53.96 | Priority Mail 3-Day | 1 | 1.10 lbs | $8.97 | $8.12 | $0.85 |
| 212998 | 2020-06-20 | $327.28 | Priority Mail 2-Day | 2 | 16.50 lbs | $51.45 | $48.22 | $3.23 |
| 212999 | 2020-06-20 | $9.32 | First-Class Mail Stamped Letter | 3 | 0.06 lbs | $3.35 | $3.18 | $0.17 |
| 213000 | 2020-06-20 | $97.07 | Priority Mail 2-Day Padded Flat Rate Envelope | 3 | 3.00 lbs | $8.60 | $7.65 | $0.95 |
| 213002 | 2020-06-20 | $74.41 | Priority Mail 3-Day | 2 | 3.40 lbs | $9.92 | $8.21 | $1.71 |
| 213003 | 2020-06-20 | $10.01 | USPSFirstClass | 2 | 0.34 lbs | $4.82 | $4.00 | $0.82 |
| 213004 | 2020-06-20 | $12.13 | USPSFirstClass | 1 | 0.34 lbs | $5.34 | $4.46 | $0.88 |
| 213005 | 2020-06-20 | $8.52 | First-Class Package Service | 4 | 0.29 lbs | $3.56 | $3.31 | $0.25 |
| 213008 | 2020-06-20 | $63.49 | Priority Mail 2-Day Small Flat Rate Box | 1 | 5.30 lbs | $8.50 | $7.65 | $0.85 |
| 213009 | 2020-06-20 | $31.93 | Priority Mail 2-Day | 1 | 1.06 lbs | $10.84 | $9.99 | $0.85 |
| 213011 | 2020-06-20 | $22.34 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 213013 | 2020-06-20 | $57.62 | Priority Mail 3-Day | 2 | 0.90 lbs | $10.84 | $9.99 | $0.85 |
| 213014 | 2020-06-20 | $14.51 | First-Class Package Service | 2 | 0.40 lbs | $4.53 | $3.31 | $1.22 |
| 213015 | 2020-06-21 | $12.04 | USPSFirstClass | 1 | 0.10 lbs | $4.35 | $2.93 | $1.42 |
| 213016 | 2020-06-20 | $10.39 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.10 lbs | $8.00 | $7.65 | $0.35 |
| 213017 | 2020-06-20 | $38.97 | Priority Mail 2-Day | 14 | 0.45 lbs | $9.61 | $8.92 | $0.69 |
| 213023 | 2020-06-21 | $13.89 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.20 | $3.18 | $0.02 |
| 213024 | 2020-06-21 | $275.62 | Priority Mail 3-Day | 1 | 14.40 lbs | $21.63 | $20.78 | $0.85 |
| 213026 | 2020-06-21 | $24.07 | Priority Mail 2-Day Small Flat Rate Box | 3 | 0.20 lbs | $8.50 | $7.65 | $0.85 |
| 213030 | 2020-06-21 | $43.97 | Priority Mail 3-Day | 3 | 1.65 lbs | $13.00 | $7.75 | $5.25 |
| 213031 | 2020-06-21 | $14.78 | Priority Mail 2-Day | 2 | 0.50 lbs | $9.00 | $8.15 | $0.85 |
| 213032 | 2020-06-21 | $15.90 | Priority Mail 2-Day Flat Rate Envelope | 10 | 0.22 lbs | $8.00 | $7.65 | $0.35 |
| 213033 | 2020-06-21 | $9.95 | First-Class Mail Stamped Letter | 5 | 0.12 lbs | $3.50 | $3.52 | $-0.02 |
| 213034 | 2020-06-21 | $24.79 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.45 lbs | $8.00 | $7.65 | $0.35 |
| 213035 | 2020-06-21 | $9.98 | USPSFirstClass | 1 | 0.20 lbs | $4.30 | $3.52 | $0.78 |
| 213036 | 2020-06-21 | $20.18 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.29 lbs | $8.00 | $7.65 | $0.35 |
| 213037 | 2020-06-21 | $27.28 | First-Class Package Service | 1 | 0.50 lbs | $5.79 | $4.32 | $1.47 |
| 213038 | 2020-06-21 | $13.82 | First-Class Mail Stamped Letter | 3 | 0.09 lbs | $3.35 | $2.78 | $0.57 |
| 213039 | 2020-06-21 | $8.69 | First-Class Mail Stamped Letter | 1 | 0.15 lbs | $3.50 | $2.84 | $0.66 |
| 213040 | 2020-06-21 | $32.28 | Priority Mail 3-Day | 1 | 2.68 lbs | $11.18 | $9.54 | $1.64 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |