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
207951 2019-10-03 $54.37 Priority Mail 2-Day Flat Rate Envelope 3 1.68 lbs $7.80 $7.55 $0.25
207953 2019-10-03 $17.03 First-Class Package Service 2 0.16 lbs $3.75 $3.22 $0.53
207954 2019-10-03 $11.29 Priority Mail 2-Day Flat Rate Envelope 1 0.04 lbs $7.80 $6.95 $0.85
207955 2019-10-03 $33.15 Priority Mail 3-Day 6 1.95 lbs $10.11 $9.26 $0.85
207957 2019-10-03 $14.37 Priority Mail 2-Day Flat Rate Envelope 3 0.15 lbs $7.80 $6.95 $0.85
207959 2019-10-04 $93.91 Priority Mail 2-Day 3 3.05 lbs $16.44 $15.59 $0.85
207960 2019-10-04 $27.64 Priority Mail 3-Day Small Flat Rate Box 1 1.05 lbs $8.35 $7.50 $0.85
207962 2019-10-04 $37.79 Priority Mail 3-Day Flat Rate Envelope 1 2.25 lbs $7.80 $7.55 $0.25
207963 2019-10-04 $24.96 First-Class Package Service 2 0.65 lbs $5.38 $5.53 $-0.15
207964 2019-10-04 $16.22 First-Class Package Service 1 0.25 lbs $4.33 $3.28 $1.05
207965 2019-10-04 $18.05 First-Class Package Service 2 0.33 lbs $4.27 $3.88 $0.39
207966 2019-10-04 $20.32 First-Class Package Service 7 0.21 lbs $3.89 $3.36 $0.53
207967 2019-10-05 $55.32 Priority Mail 2-Day 7 1.66 lbs $9.19 $7.88 $1.31
207968 2019-10-05 $21.35 Direct Link International 2 0.17 lbs $10.47 $10.73 $-0.26
207969 2019-10-05 $40.17 Priority Mail 3-Day Padded Flat Rate Envelope 3 1.11 lbs $8.40 $7.55 $0.85
207970 2019-10-05 $10.00 First-Class Package Service 1 0.02 lbs $4.01 $2.96 $1.05
207971 2019-10-05 $46.12 Priority Mail 3-Day Flat Rate Envelope 8 1.20 lbs $7.80 $7.50 $0.30
207972 2019-10-05 $6.72 First-Class Package Service 3 0.03 lbs $3.75 $2.70 $1.05
207976 2019-10-05 $67.48 Priority Mail 2-Day 12 4.58 lbs $14.62 $13.77 $0.85
207977 2019-10-05 $17.74 First-Class Package Service 1 0.05 lbs $3.75 $2.70 $1.05
207982 2019-10-06 $54.04 Priority Mail 2-Day Small Flat Rate Box 1 1.75 lbs $8.35 $7.50 $0.85
207983 2019-10-06 $8.91 First-Class Package Service 10 0.10 lbs $4.01 $2.96 $1.05
207985 2019-10-06 $14.28 First-Class Package Service 6 0.30 lbs $4.54 $3.49 $1.05
207987 2019-10-07 $17.21 First-Class Package Service 2 0.80 lbs $6.23 $10.23 $-4.00
207989 2019-10-07 $8.71 First-Class Package Service 10 0.10 lbs $3.81 $2.76 $1.05
207990 2019-10-07 $272.71 Priority Mail 2-Day 6 22.77 lbs $26.23 $26.99 $-0.76
207992 2019-10-07 $18.14 Priority Mail 2-Day 1 0.95 lbs $9.35 $8.50 $0.85
207993 2019-10-07 $16.06 First-Class Package Service 1 0.30 lbs $4.27 $3.22 $1.05
207996 2019-10-07 $16.10 First-Class Package Service 4 0.04 lbs $4.14 $3.09 $1.05
207997 2019-10-07 $10.71 First-Class Package Service 3 0.25 lbs $4.54 $4.19 $0.35
207998 2019-10-07 $19.87 Priority Mail 3-Day 1 0.95 lbs $11.08 $10.23 $0.85
207999 2019-10-07 $19.87 First-Class Package Service 6 0.40 lbs $4.33 $3.28 $1.05
208001 2019-10-08 $71.37 Direct Link International 3 1.47 lbs $26.80 $26.79 $0.01
208003 2019-10-08 $10.97 First-Class Package Service 4 0.08 lbs $4.01 $2.96 $1.05
208005 2019-10-08 $79.58 Ground 3 1.05 lbs $19.34 $16.84 $2.50
208008 2019-10-08 $62.97 Priority Mail 2-Day Flat Rate Envelope 3 2.70 lbs $7.80 $10.00 $-2.20
208009 2019-10-09 $5.88 First-Class Package Service 1 0.03 lbs $3.89 $2.84 $1.05
208011 2019-10-09 $44.61 Priority Mail 3-Day 8 2.44 lbs $9.19 $8.12 $1.07
208012 2019-10-09 $78.40 Priority Mail 2-Day Large Flat Rate Box 5 3.40 lbs $18.45 $17.60 $0.85
208013 2019-10-09 $34.01 Priority Mail 2-Day Medium Flat Rate Box 4 1.68 lbs $14.05 $12.80 $1.25
208014 2019-10-09 $51.67 Priority Mail 2-Day 4 1.40 lbs $11.71 $10.86 $0.85
208015 2019-10-05 $38.77 First-Class Package Service 8 1.25 lbs $10.98 $8.50 $2.48
208016 2019-10-09 $29.58 First-Class Package Service 2 0.48 lbs $5.24 $4.19 $1.05
208017 2019-10-09 $9.29 First-Class Package Service 2 0.08 lbs $3.81 $2.76 $1.05
208018 2019-10-09 $76.44 Priority Mail 2-Day Medium Flat Rate Box 21 2.59 lbs $14.05 $11.20 $2.85
208021 2019-10-09 $38.14 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $8.35 $7.50 $0.85
208023 2019-10-09 $19.51 First-Class Package Service 3 0.30 lbs $4.54 $2.96 $1.58
208024 2019-10-09 $43.73 Priority Mail 2-Day Flat Rate Envelope 7 0.87 lbs $7.80 $7.50 $0.30
208025 2019-10-09 $35.37 First-Class Package Service 1 1.00 lbs $6.29 $7.50 $-1.21
208026 2019-10-09 $52.56 Priority Mail 3-Day 4 1.02 lbs $8.00 $10.23 $-2.23
208027 2019-10-09 $125.70 Ground 6 6.17 lbs $24.39 $18.19 $6.20
208031 2019-10-10 $12.75 First-Class Package Service 2 0.80 lbs $5.97 $5.12 $0.85
208033 2019-10-10 $33.69 First-Class Package Service 4 0.62 lbs $6.23 $5.38 $0.85
208034 2019-10-10 $95.34 First-Class Package International Service 9 2.40 lbs $33.19 $24.94 $8.25
208037 2019-10-11 $27.25 First-Class Package Service 2 0.74 lbs $6.07 $5.02 $1.05
208039 2019-10-11 $69.35 Priority Mail 3-Day 4 1.20 lbs $8.73 $7.88 $0.85
208040 2019-10-11 $18.14 Priority Mail 3-Day 1 0.95 lbs $9.35 $8.50 $0.85
208041 2019-10-11 $19.34 Priority Mail 3-Day 1 0.95 lbs $10.55 $9.70 $0.85
208044 2019-10-12 $8.80 First-Class Package Service 1 0.10 lbs $3.81 $2.76 $1.05
208045 2019-10-12 $17.03 First-Class Package Service 3 0.30 lbs $5.11 $5.24 $-0.13
208046 2019-10-12 $25.22 First-Class Package International Service 1 0.19 lbs $18.23 $9.98 $8.25
208047 2019-10-12 $49.51 Priority Mail 2-Day 4 1.14 lbs $10.55 $9.70 $0.85
208048 2019-10-12 $17.79 First-Class Package Service 2 0.12 lbs $3.81 $2.76 $1.05
208049 2019-10-12 $11.41 First-Class Package Service 2 0.13 lbs $3.81 $3.28 $0.53
208050 2019-10-12 $212.28 Priority Mail 2-Day 10 10.12 lbs $30.29 $32.72 $-2.43
208051 2019-10-12 $21.30 Priority Mail 2-Day 3 1.20 lbs $8.73 $7.88 $0.85
208053 2019-10-13 $16.67 First-Class Package Service 1 0.40 lbs $4.68 $4.33 $0.35
208054 2019-10-13 $45.40 Priority Mail 2-Day Large Flat Rate Box 5 0.23 lbs $18.45 $7.55 $10.90
208055 2019-10-13 $36.26 Priority Mail 3-Day 9 0.86 lbs $9.35 $8.50 $0.85
208056 2019-10-13 $54.27 Priority Mail 2-Day Flat Rate Envelope 3 1.90 lbs $7.80 $7.50 $0.30
208057 2019-10-13 $29.00 First-Class Package Service 6 0.20 lbs $4.33 $3.28 $1.05
208059 2019-10-13 $7.00 First-Class Package Service 1 0.03 lbs $4.01 $2.96 $1.05
208060 2019-10-13 $9.98 First-Class Package Service 3 0.09 lbs $4.01 $2.96 $1.05
208062 2019-10-13 $21.13 First-Class Package Service 5 0.57 lbs $6.38 $5.53 $0.85
208063 2019-10-13 $27.69 Priority Mail 2-Day 2 1.90 lbs $10.11 $9.26 $0.85
208064 2019-10-14 $69.58 Priority Mail 2-Day Medium Flat Rate Box 27 2.26 lbs $14.05 $11.20 $2.85
208066 2019-10-14 $54.39 Priority Mail 2-Day Large Flat Rate Box 6 3.72 lbs $18.45 $12.80 $5.65
208067 2019-10-14 $54.39 Priority Mail 2-Day Large Flat Rate Box 6 3.72 lbs $18.45 $12.80 $5.65
208068 2019-10-14 $54.39 Priority Mail 2-Day Large Flat Rate Box 6 3.72 lbs $18.45 $12.80 $5.65
208069 2019-10-14 $54.39 Priority Mail 2-Day Large Flat Rate Box 5 3.10 lbs $18.45 $12.80 $5.65
208070 2019-10-14 $13.30 First-Class Package Service 4 0.40 lbs $4.54 $2.96 $1.58
208071 2019-10-14 $4.14 Media Mail Parcel 2 1.15 lbs $4.12 $3.27 $0.85
208072 2019-10-14 $8.84 First-Class Package Service 5 0.05 lbs $3.89 $2.84 $1.05
208074 2019-10-14 $42.14 Priority Mail 3-Day Small Flat Rate Box 1 1.50 lbs $8.35 $7.50 $0.85
208078 2019-10-15 $14.28 First-Class Package Service 3 0.09 lbs $3.81 $2.76 $1.05
208079 2019-10-15 $15.59 First-Class Package Service 4 0.74 lbs $6.23 $5.38 $0.85
208081 2019-10-15 $27.64 Priority Mail 2-Day Small Flat Rate Box 1 1.00 lbs $8.35 $7.50 $0.85
208083 2019-10-15 $33.30 Priority Mail 2-Day Small Flat Rate Box 5 0.50 lbs $8.35 $7.50 $0.85
208084 2019-10-15 $9.19 First-Class Package Service 2 0.34 lbs $4.81 $3.96 $0.85
208086 2019-10-15 $18.14 Priority Mail 2-Day 1 0.95 lbs $9.35 $8.50 $0.85
208089 2019-08-10 $3.71 Priority Mail 2-Day 1 0.25 lbs $0.00 $6.95 $-6.95
208090 2019-10-16 $10.60 First-Class Package Service 1 0.07 lbs $4.01 $2.96 $1.05
208095 2019-10-16 $15.99 First-Class Package Service 2 0.20 lbs $4.07 $3.88 $0.19
208096 2019-10-17 $15.53 First-Class Package Service 1 0.30 lbs $4.54 $3.49 $1.05
208099 2019-10-17 $16.69 First-Class Package Service 6 0.12 lbs $3.75 $2.70 $1.05
208100 2019-10-17 $14.08 First-Class Package Service 1 0.65 lbs $6.09 $5.24 $0.85
208101 2019-10-17 $22.45 First-Class Package Service 2 0.65 lbs $5.11 $5.24 $-0.13
208102 2019-10-17 $4.87 First-Class Package Service 2 0.04 lbs $3.89 $2.84 $1.05
208104 2019-10-17 $17.52 Priority Mail 2-Day 1 0.95 lbs $8.73 $8.34 $0.39
208105 2019-10-17 $11.00 First-Class Package Service 1 0.07 lbs $4.01 $2.96 $1.05
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56