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
201941 2018-02-22 $47.00 Priority Mail 2-Day Flat Rate Envelope 6 0.81 lbs $7.40 $6.85 $0.55
201942 2018-02-22 $123.80 First-Class Package International Service 3 2.85 lbs $53.93 $48.93 $5.00
201946 2018-02-22 $13.10 First-Class Package Service 1 0.10 lbs $3.71 $2.66 $1.05
201947 2018-02-22 $34.75 First-Class Package Service 2 0.60 lbs $4.67 $4.10 $0.57
201949 2018-02-22 $21.97 First-Class Package Service 4 0.28 lbs $4.71 $3.18 $1.53
201950 2018-02-22 $81.88 Priority Mail 2-Day Large Flat Rate Box 6 3.95 lbs $18.50 $10.29 $8.21
201951 2018-02-22 $23.29 First-Class Package Service 2 0.45 lbs $4.35 $3.50 $0.85
201952 2018-02-22 $59.86 Priority Mail 2-Day 5 1.87 lbs $9.32 $8.22 $1.10
201958 2018-02-23 $27.50 First-Class Mail Large Envelope 2 0.40 lbs $3.82 $3.50 $0.32
201959 2018-02-23 $5.83 First-Class Package Service 1 0.19 lbs $3.84 $2.66 $1.18
201960 2018-02-23 $68.02 Priority Mail 3-Day 7 3.41 lbs $11.19 $10.03 $1.16
201961 2018-02-23 $19.93 Priority Mail 2-Day 1 0.95 lbs $11.14 $9.98 $1.16
201962 2018-02-23 $30.70 First-Class Mail Large Envelope 4 0.56 lbs $4.24 $3.66 $0.58
201963 2018-02-23 $6.16 First-Class Package Service 5 0.05 lbs $3.71 $2.66 $1.05
201967 2018-02-24 $25.61 First-Class Package Service 3 0.16 lbs $3.84 $2.79 $1.05
201969 2018-02-24 $50.97 Priority Mail 3-Day 3 1.11 lbs $9.00 $7.91 $1.09
201970 2018-02-24 $15.40 First-Class Mail Large Envelope 1 0.30 lbs $3.61 $3.18 $0.43
201971 2018-02-24 $36.54 First-Class Package Service 5 0.68 lbs $5.79 $4.94 $0.85
201972 2018-02-24 $7.70 First-Class Package Service 1 0.10 lbs $3.71 $2.66 $1.05
201973 2018-02-24 $21.38 Priority Mail 2-Day Flat Rate Envelope 2 0.12 lbs $7.40 $6.85 $0.55
201975 2018-02-24 $7.70 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
201976 2018-02-24 $24.02 First-Class Mail Large Envelope 1 0.40 lbs $4.03 $13.70 $-9.67
201977 2018-02-25 $47.32 First-Class Package International Service 1 0.35 lbs $27.33 $22.33 $5.00
201978 2018-02-25 $51.38 Priority Mail 2-Day 4 1.73 lbs $10.32 $9.47 $0.85
201979 2018-02-25 $35.89 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $7.90 $6.85 $1.05
201981 2018-02-25 $33.50 First-Class Package Service 1 1.20 lbs $5.51 $6.85 $-1.34
201982 2018-02-25 $5.69 First-Class Package Service 2 0.02 lbs $3.71 $2.66 $1.05
201983 2018-02-25 $67.64 Ground 4 1.85 lbs $19.08 $15.80 $3.28
201984 2018-02-25 $117.46 Priority Mail 3-Day 1 12.90 lbs $19.47 $18.06 $1.41
201985 2018-02-25 $37.69 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $7.90 $6.85 $1.05
201986 2018-02-25 $252.47 Priority Mail 2-Day 7 13.36 lbs $41.84 $39.76 $2.08
201991 2018-02-26 $98.50 First-Class Package International Service 3 2.25 lbs $38.96 $33.96 $5.00
201993 2018-02-26 $121.00 Priority Mail International 1 3.85 lbs $61.01 $60.28 $0.73
201997 2018-02-26 $6.70 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
201998 2018-02-26 $19.67 Priority Mail 2-Day 5 1.63 lbs $9.00 $6.90 $2.10
201999 2018-02-26 $33.50 First-Class Package Service 1 1.20 lbs $5.51 $6.85 $-1.34
202001 2018-02-27 $56.12 First-Class Package International Service 1 1.30 lbs $27.33 $22.33 $5.00
202002 2018-02-27 $54.12 First-Class Package International Service 1 1.30 lbs $27.33 $22.33 $5.00
202003 2018-02-27 $8.70 First-Class Package Service 1 0.10 lbs $3.71 $2.66 $1.05
202004 2018-02-27 $37.39 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $7.90 $6.85 $1.05
202005 2018-02-27 $56.82 First-Class Package International Service 1 1.15 lbs $27.33 $22.33 $5.00
202006 2018-02-27 $102.99 Priority Mail 2-Day Medium Flat Rate Box 12 3.84 lbs $13.85 $10.80 $3.05
202007 2018-02-27 $35.00 First-Class Package Service 1 1.10 lbs $5.51 $4.94 $0.57
202009 2018-02-27 $9.70 First-Class Package Service 1 0.27 lbs $4.71 $3.82 $0.89
202010 2018-02-27 $220.73 Priority Mail 2-Day 2 18.50 lbs $31.75 $23.01 $8.74
202011 2018-02-28 $8.45 First-Class Package Service 5 0.07 lbs $3.71 $2.66 $1.05
202012 2018-02-28 $67.82 First-Class Package International Service 1 1.55 lbs $27.33 $22.33 $5.00
202013 2018-02-28 $67.82 First-Class Package International Service 2 2.75 lbs $27.33 $22.33 $5.00
202014 2018-02-28 $67.82 First-Class Package International Service 1 1.50 lbs $27.33 $22.33 $5.00
202015 2018-02-28 $67.82 First-Class Package International Service 1 1.50 lbs $27.33 $22.33 $5.00
202016 2018-02-28 $73.60 First-Class Package International Service 3 1.60 lbs $27.33 $22.33 $5.00
202018 2018-02-28 $75.70 First-Class Package International Service 3 1.61 lbs $27.33 $22.33 $5.00
202019 2018-02-28 $78.60 First-Class Package International Service 3 1.62 lbs $27.33 $22.33 $5.00
202021 2018-02-28 $41.87 Priority Mail 2-Day Flat Rate Envelope 3 1.05 lbs $7.40 $6.85 $0.55
202022 2018-02-28 $42.04 Priority Mail 2-Day 1 1.50 lbs $8.25 $6.85 $1.40
202023 2018-02-28 $73.50 First-Class Package International Service 1 2.20 lbs $38.01 $33.01 $5.00
202024 2018-02-28 $67.82 First-Class Package International Service 1 1.50 lbs $27.33 $22.33 $5.00
202025 2018-02-28 $67.82 First-Class Package International Service 1 1.50 lbs $27.33 $22.33 $5.00
202026 2018-02-28 $67.82 First-Class Package International Service 1 1.55 lbs $27.33 $22.33 $5.00
202027 2018-02-28 $11.06 First-Class Package Service 15 0.15 lbs $3.71 $2.66 $1.05
202028 2018-02-28 $112.53 Priority Mail 3-Day 7 3.22 lbs $17.00 $13.75 $3.25
202030 2018-02-28 $36.29 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $7.90 $6.85 $1.05
202031 2018-02-28 $15.66 First-Class Package Service 6 0.45 lbs $5.71 $3.18 $2.53
202032 2018-02-28 $48.48 Priority Mail 3-Day Small Flat Rate Box 2 1.70 lbs $7.90 $6.85 $1.05
202035 2018-02-28 $138.18 Ground 7 4.38 lbs $20.85 $15.65 $5.20
202039 2018-02-28 $42.27 Priority Mail 3-Day Small Flat Rate Box 3 0.80 lbs $7.90 $6.85 $1.05
202040 2018-02-28 $53.59 Priority Mail 2-Day Small Flat Rate Box 1 1.65 lbs $7.90 $6.85 $1.05
202041 2018-03-01 $39.72 First-Class Mail Large Envelope 5 0.64 lbs $4.87 $4.66 $0.21
202042 2018-03-01 $37.39 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $7.90 $6.85 $1.05
202043 2018-03-01 $18.08 First-Class Package Service 2 0.12 lbs $4.10 $2.66 $1.44
202044 2018-03-01 $14.39 Priority Mail 2-Day Flat Rate Envelope 1 1.00 lbs $7.40 $6.85 $0.55
202047 2018-03-01 $36.69 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $7.90 $6.85 $1.05
202048 2018-03-01 $33.95 Priority Mail 2-Day 5 1.70 lbs $9.00 $8.15 $0.85
202049 2018-03-01 $379.48 Priority Mail International 21 12.53 lbs $94.72 $82.27 $12.45
202050 2018-03-01 $54.90 Priority Mail 3-Day 1 2.40 lbs $10.11 $8.98 $1.13
202052 2018-03-01 $3.97 First-Class Package Service 1 0.30 lbs $3.97 $2.92 $1.05
202054 2018-03-01 $159.31 Priority Mail 2-Day 30 4.88 lbs $16.45 $13.77 $2.68
202057 2018-03-02 $22.82 First-Class Package Service 15 0.23 lbs $3.97 $2.66 $1.31
202061 2018-03-02 $16.78 First-Class Package Service 6 0.16 lbs $3.84 $2.79 $1.05
202062 2018-03-02 $62.79 First-Class Package International Service 1 1.45 lbs $27.33 $22.33 $5.00
202063 2018-03-02 $73.50 First-Class Package International Service 1 2.20 lbs $38.01 $33.01 $5.00
202064 2018-03-02 $324.71 Ground 18 19.43 lbs $21.23 $18.73 $2.50
202066 2018-03-02 $46.60 Priority Mail 2-Day 2 1.15 lbs $10.32 $9.19 $1.13
202068 2018-03-02 $45.12 First-Class Package International Service 3 1.38 lbs $20.20 $15.20 $5.00
202069 2018-03-02 $79.16 Priority Mail 2-Day 3 2.60 lbs $11.19 $10.03 $1.16
202070 2018-03-02 $13.82 First-Class Package Service 2 0.20 lbs $3.84 $2.92 $0.92
202074 2018-03-02 $60.08 First-Class Package International Service 1 1.30 lbs $27.09 $22.09 $5.00
202075 2018-03-03 $81.47 First-Class Package International Service 5 1.83 lbs $38.96 $33.96 $5.00
202077 2018-03-03 $8.21 First-Class Package Service 2 0.38 lbs $4.23 $2.66 $1.57
202078 2018-03-03 $61.98 Priority Mail 2-Day 4 2.07 lbs $9.32 $7.40 $1.92
202079 2018-03-03 $29.19 First-Class Mail Large Envelope 5 0.50 lbs $4.24 $3.82 $0.42
202080 2018-03-03 $25.69 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $7.40 $7.18 $0.22
202081 2018-03-03 $45.14 Priority Mail 2-Day Flat Rate Envelope 2 1.65 lbs $7.40 $6.85 $0.55
202082 2018-03-03 $34.16 First-Class Package International Service 4 0.27 lbs $20.20 $9.50 $10.70
202083 2018-03-03 $12.08 First-Class Package Service 3 0.18 lbs $3.71 $2.92 $0.79
202085 2018-03-03 $45.57 Priority Mail 2-Day Flat Rate Envelope 3 1.58 lbs $7.40 $6.90 $0.50
202087 2018-03-03 $77.85 Priority Mail 2-Day 1 5.65 lbs $10.56 $9.42 $1.14
202091 2018-03-03 $11.71 First-Class Package Service 3 0.39 lbs $4.23 $3.18 $1.05
202093 2018-03-04 $17.70 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
202094 2018-03-04 $37.69 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $7.90 $6.85 $1.05
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56