Shipping Charges Analysis

Shipping Charges Analysis — Functional Description

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)

  • High Profit Profit greater than or equal to $2.00 — green row highlight (table-success)
  • Moderate Profit Profit between $1.00 and $1.99 inclusive — yellow row highlight (table-warning)
  • Low / Loss Profit strictly below $1.00 — red row highlight (table-danger)
  • Date range — optional Start Date and End Date boundaries filter on oc_order.date_added.
  • Weight range slider — dual-handle control auto-scales to the absolute minimum and maximum total product weight present in the active dataset (respecting the selected date range).
  • Profit range slider — dual-handle control auto-scales to the absolute minimum and maximum shipping profit (charged minus paid) present in the active dataset.
  • Shipping methods — multi-select narrows results to one or more normalized carrier methods; leave empty to include all methods.
  • Click any column header to sort; pagination retains all active filter and sort parameters.
Report Filters
Start End
Drag both handles to narrow total product weight (0–115 lbs).
Drag both handles to narrow shipping profit ($-103476.00–$126.00).
Leave unselected to include all shipping methods.

21021 matching order(s)

Order ID ▲DateOrder TotalShipping Method# ProductsTotal WeightShipping ChargedShipping PaidProfit
201772 2018-02-10 $11.67 First-Class Package Service 4 0.04 lbs $3.71 $2.66 $1.05
201773 2018-02-10 $12.80 First-Class Package Service 4 0.42 lbs $3.84 $3.66 $0.18
201774 2018-02-10 $70.16 Priority Mail 2-Day 3 0.87 lbs $16.19 $10.48 $5.71
201775 2018-02-10 $27.69 Priority Mail 2-Day 2 1.90 lbs $10.11 $8.98 $1.13
201778 2018-02-11 $995.54 Priority Mail International 5 44.70 lbs $280.61 $178.93 $101.68
201779 2018-02-11 $14.70 First-Class Package Service 1 0.10 lbs $3.71 $7.00 $-3.29
201782 2018-02-11 $185.96 Priority Mail 2-Day 5 9.25 lbs $12.31 $9.37 $2.94
201785 2018-02-11 $19.46 First-Class Package Service 5 0.07 lbs $5.51 $3.18 $2.33
201786 2018-02-11 $10.70 First-Class Package Service 1 0.19 lbs $3.71 $2.66 $1.05
201787 2018-02-11 $17.60 First-Class Package Service 11 0.14 lbs $3.71 $2.66 $1.05
201790 2018-02-11 $6.16 First-Class Package Service 5 0.05 lbs $3.71 $2.66 $1.05
201792 2018-02-11 $10.70 First-Class Package Service 1 0.06 lbs $3.71 $2.66 $1.05
201793 2018-02-11 $49.15 Priority Mail 2-Day 5 2.00 lbs $14.00 $12.76 $1.24
201794 2018-02-11 $21.95 First-Class Package Service 2 0.28 lbs $3.97 $3.18 $0.79
201796 2018-02-11 $164.30 Ground 2 14.30 lbs $29.52 $25.57 $3.95
201798 2018-02-11 $103.54 Priority Mail 3-Day 5 3.43 lbs $11.19 $10.03 $1.16
201799 2018-02-12 $36.39 Priority Mail 3-Day Flat Rate Envelope 1 1.10 lbs $7.40 $6.85 $0.55
201802 2018-02-12 $253.17 Ground 3 18.35 lbs $27.20 $26.93 $0.27
201803 2018-02-12 $167.34 Standard 4 6.35 lbs $56.88 $48.58 $8.30
201804 2018-02-12 $108.48 Standard 4 3.00 lbs $33.32 $24.39 $8.93
201805 2018-02-12 $5.83 First-Class Package Service 1 0.03 lbs $3.84 $2.66 $1.18
201806 2018-02-12 $26.02 First-Class Mail Large Envelope 1 0.40 lbs $4.03 $3.18 $0.85
201807 2018-02-12 $25.69 Priority Mail 3-Day Flat Rate Envelope 1 1.00 lbs $7.40 $6.90 $0.50
201808 2018-02-12 $6.60 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
201809 2018-02-12 $15.69 First-Class Package Service 2 0.04 lbs $3.71 $2.66 $1.05
201811 2018-02-12 $51.43 Priority Mail 2-Day Medium Flat Rate Box 2 1.60 lbs $13.85 $9.98 $3.87
201812 2018-02-13 $6.70 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
201814 2018-02-13 $23.62 First-Class Package Service 1 0.90 lbs $5.23 $4.94 $0.29
201818 2018-02-13 $14.40 First-Class Mail Large Envelope 1 0.30 lbs $3.61 $3.18 $0.43
201819 2018-02-13 $25.69 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $7.40 $6.90 $0.50
201820 2018-02-13 $79.88 Priority Mail 2-Day 3 2.10 lbs $10.11 $6.85 $3.26
201821 2018-02-13 $65.42 First-Class Package Service 1 0.70 lbs $5.43 $4.94 $0.49
201822 2018-02-13 $28.41 First-Class Package Service 2 0.70 lbs $5.23 $4.94 $0.29
201826 2018-02-14 $9.39 Priority Mail 2-Day Flat Rate Envelope 2 1.02 lbs $7.40 $6.85 $0.55
201829 2018-02-14 $53.14 Priority Mail 2-Day Flat Rate Envelope 6 1.20 lbs $7.40 $6.85 $0.55
201830 2018-02-14 $23.93 First-Class Package Service 6 0.17 lbs $5.99 $2.79 $3.20
201831 2018-02-14 $37.69 Priority Mail 3-Day Small Flat Rate Box 1 1.25 lbs $7.90 $6.85 $1.05
201833 2018-02-14 $32.31 Priority Mail 2-Day 8 2.33 lbs $11.19 $8.98 $2.21
201834 2018-02-14 $17.96 First-Class Package Service 1 0.24 lbs $3.97 $3.05 $0.92
201836 2018-02-14 $30.51 Priority Mail 2-Day 4 1.00 lbs $8.25 $7.40 $0.85
201837 2018-02-14 $267.72 Priority Mail International 5 15.05 lbs $103.57 $99.66 $3.91
201838 2018-02-14 $7.90 Priority Mail 3-Day Small Flat Rate Box 1 2.60 lbs $7.90 $6.85 $1.05
201840 2018-02-14 $25.22 First-Class Package Service 1 0.35 lbs $4.23 $16.30 $-12.07
201844 2018-02-15 $17.67 First-Class Package Service 4 0.16 lbs $3.71 $2.66 $1.05
201845 2018-02-15 $357.67 Priority Mail International 7 16.95 lbs $101.94 $97.04 $4.90
201852 2018-02-15 $67.01 Priority Mail 2-Day 3 2.15 lbs $9.54 $8.43 $1.11
201853 2018-02-15 $11.50 First-Class Package Service 1 0.15 lbs $3.71 $2.79 $0.92
201854 2018-02-16 $6.68 First-Class Package Service 3 0.03 lbs $3.71 $2.66 $1.05
201855 2018-02-16 $67.82 First-Class Package International Service 1 1.45 lbs $27.33 $22.33 $5.00
201858 2018-02-16 $131.82 Priority Mail International 1 5.65 lbs $64.53 $63.79 $0.74
201859 2018-02-16 $65.42 First-Class Package Service 1 0.70 lbs $5.43 $4.94 $0.49
201862 2018-02-16 $23.62 First-Class Package Service 1 0.90 lbs $5.23 $4.94 $0.29
201864 2018-02-16 $131.82 Priority Mail International 1 5.65 lbs $64.53 $63.79 $0.74
201865 2018-02-16 $53.63 Priority Mail 3-Day Flat Rate Envelope 3 1.73 lbs $7.40 $6.85 $0.55
201868 2018-02-16 $99.84 Priority Mail 2-Day Medium Flat Rate Box 1 10.70 lbs $13.85 $8.15 $5.70
201869 2018-02-16 $16.28 First-Class Package Service 6 0.18 lbs $3.84 $2.92 $0.92
201870 2018-02-16 $37.69 Priority Mail 3-Day Small Flat Rate Box 1 1.40 lbs $7.90 $6.85 $1.05
201871 2018-02-16 $82.10 Priority Mail 3-Day 3 2.65 lbs $15.03 $13.75 $1.28
201875 2018-02-17 $60.81 Priority Mail 3-Day 2 1.95 lbs $8.53 $7.45 $1.08
201876 2018-02-17 $44.92 Priority Mail 2-Day Flat Rate Envelope 1 1.15 lbs $7.40 $6.90 $0.50
201878 2018-02-17 $150.66 Priority Mail International 5 6.41 lbs $70.61 $66.36 $4.25
201879 2018-02-17 $24.02 First-Class Mail Large Envelope 1 0.40 lbs $4.03 $3.18 $0.85
201880 2018-02-17 $48.98 Priority Mail 3-Day Flat Rate Envelope 2 1.50 lbs $7.40 $6.85 $0.55
201882 2018-02-17 $54.61 Priority Mail 2-Day Medium Flat Rate Box 3 7.55 lbs $13.85 $8.15 $5.70
201884 2018-02-18 $94.49 Priority Mail 2-Day 3 3.05 lbs $16.92 $15.59 $1.33
201885 2018-02-18 $93.45 First-Class Package International Service 5 1.85 lbs $49.66 $52.68 $-3.02
201887 2018-02-18 $17.04 Priority Mail 2-Day 1 0.95 lbs $8.25 $7.18 $1.07
201888 2018-02-18 $71.00 Priority Mail 2-Day 6 1.02 lbs $11.14 $9.98 $1.16
201889 2018-02-18 $57.75 Priority Mail 2-Day 5 1.45 lbs $9.00 $7.91 $1.09
201894 2018-02-19 $19.61 First-Class Mail Large Envelope 3 0.37 lbs $4.24 $3.18 $1.06
201897 2018-02-19 $11.56 First-Class Mail Large Envelope 1 0.30 lbs $3.61 $3.18 $0.43
201898 2018-02-19 $15.65 First-Class Package Service 6 0.15 lbs $3.71 $2.66 $1.05
201899 2018-02-19 $35.48 Priority Mail 2-Day 13 2.56 lbs $10.11 $8.98 $1.13
201900 2018-02-19 $131.82 Priority Mail International 1 5.65 lbs $64.53 $63.79 $0.74
201901 2018-02-19 $554.43 Priority Mail International 10 19.34 lbs $150.96 $97.04 $53.92
201902 2018-02-19 $42.52 First-Class Package Service 3 0.80 lbs $5.79 $4.66 $1.13
201903 2018-02-19 $14.32 Priority Mail 3-Day 4 0.39 lbs $8.35 $6.90 $1.45
201904 2018-02-19 $84.80 Priority Mail 3-Day Medium Flat Rate Box 5 1.45 lbs $13.85 $6.85 $7.00
201905 2018-02-19 $47.25 Priority Mail 2-Day Flat Rate Envelope 7 0.68 lbs $7.40 $6.85 $0.55
201906 2018-02-19 $86.00 Priority Mail 2-Day Medium Flat Rate Box 5 2.55 lbs $13.85 $10.29 $3.56
201907 2018-02-19 $16.79 Ground 4 0.20 lbs $10.83 $6.85 $3.98
201908 2018-02-19 $9.69 First-Class Package Service 2 0.06 lbs $3.71 $2.66 $1.05
201909 2018-02-19 $108.51 Ground 22 9.50 lbs $29.73 $43.87 $-14.14
201910 2018-02-20 $334.64 Ground 13 12.95 lbs $29.98 $23.88 $6.10
201911 2018-02-20 $51.65 Priority Mail 2-Day Medium Flat Rate Box 20 4.00 lbs $13.85 $15.67 $-1.82
201914 2018-02-20 $152.80 Priority Mail 2-Day 6 5.96 lbs $9.34 $8.46 $0.88
201915 2018-02-20 $67.37 Priority Mail 3-Day 4 2.20 lbs $30.60 $10.03 $20.57
201919 2018-02-20 $42.77 Priority Mail 2-Day Flat Rate Envelope 3 0.90 lbs $7.40 $6.85 $0.55
201921 2018-02-21 $23.83 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $7.40 $6.90 $0.50
201922 2018-02-21 $81.89 Priority Mail 3-Day 12 3.68 lbs $11.50 $10.33 $1.17
201925 2018-02-21 $25.13 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $7.40 $6.90 $0.50
201926 2018-02-21 $373.50 Priority Mail International 2 15.45 lbs $113.72 $105.12 $8.60
201927 2018-02-21 $58.60 Priority Mail 3-Day 2 2.00 lbs $9.32 $7.40 $1.92
201929 2018-02-21 $35.42 First-Class Package Service 5 0.47 lbs $5.15 $4.10 $1.05
201930 2018-02-21 $17.04 Priority Mail 3-Day 1 0.95 lbs $8.25 $8.22 $0.03
201931 2018-02-21 $198.57 Priority Mail International 1 12.90 lbs $100.58 $89.73 $10.85
201932 2018-02-21 $30.14 First-Class Package Service 1 0.65 lbs $5.15 $4.66 $0.49
201933 2018-02-21 $59.46 Ground 9 2.14 lbs $23.17 $20.89 $2.28
201938 2018-02-22 $197.52 Priority Mail International 24 3.90 lbs $59.92 $55.67 $4.25
201939 2018-02-22 $12.58 First-Class Package Service 3 0.09 lbs $3.71 $2.66 $1.05
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56