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
209908 2020-02-17 $17.94 Priority Mail 3-Day Flat Rate Envelope 2 0.30 lbs $8.00 $7.65 $0.35
209909 2020-02-18 $31.88 Priority Mail 2-Day Flat Rate Envelope 12 0.16 lbs $8.00 $7.65 $0.35
209910 2020-02-18 $12.97 Priority Mail 2-Day Flat Rate Envelope 3 0.10 lbs $8.00 $7.65 $0.35
209911 2020-02-18 $47.25 Media Mail Parcel 3 1.50 lbs $4.18 $8.76 $-4.58
209912 2020-02-18 $29.23 Media Mail Parcel 1 3.55 lbs $5.24 $11.13 $-5.89
209914 2020-02-18 $38.97 Ground 3 0.50 lbs $22.10 $21.21 $0.89
209920 2020-02-19 $8.99 Priority Mail 2-Day Flat Rate Envelope 1 0.01 lbs $8.00 $7.65 $0.35
209922 2020-02-19 $20.47 Priority Mail 2-Day Small Flat Rate Box 3 0.15 lbs $8.50 $2.78 $5.72
209923 2020-02-19 $183.15 Ground 19 24.38 lbs $46.10 $26.50 $19.60
209927 2020-02-19 $72.58 Priority Mail 2-Day Padded Flat Rate Envelope 2 1.70 lbs $8.60 $7.65 $0.95
209928 2020-02-19 $25.56 First-Class Package Service 1 0.60 lbs $4.78 $5.04 $-0.26
209929 2020-02-20 $19.79 Priority Mail 3-Day Flat Rate Envelope 1 0.25 lbs $8.00 $7.65 $0.35
209931 2020-02-20 $8.69 First-Class Mail Stamped Letter 1 0.15 lbs $3.50 $2.84 $0.66
209932 2020-02-20 $11.99 Priority Mail 3-Day Flat Rate Envelope 1 0.08 lbs $8.00 $7.15 $0.85
209935 2020-02-20 $12.87 First-Class Mail Stamped Letter 3 0.13 lbs $3.50 $2.78 $0.72
209936 2020-02-20 $9.08 First-Class Mail Stamped Letter 2 0.12 lbs $3.50 $3.05 $0.45
209937 2020-02-20 $216.08 Direct Link International 8 6.50 lbs $61.96 $10.84 $51.12
209938 2020-02-20 $29.49 Priority Mail 3-Day Flat Rate Envelope 1 0.35 lbs $8.00 $7.65 $0.35
209939 2020-02-20 $47.18 Priority Mail 2-Day 9 2.38 lbs $10.39 $9.54 $0.85
209940 2020-02-20 $35.96 Priority Mail 2-Day Flat Rate Envelope 4 0.66 lbs $8.00 $7.65 $0.35
209942 2020-02-20 $56.18 Priority Mail 2-Day Flat Rate Envelope 2 1.52 lbs $8.00 $7.65 $0.35
209943 2020-02-21 $12.30 First-Class Package Service 2 0.80 lbs $5.52 $5.27 $0.25
209944 2020-02-21 $50.72 Direct Link International 19 0.57 lbs $21.41 $16.33 $5.08
209945 2020-02-21 $9.33 First-Class Mail Stamped Letter 2 0.07 lbs $3.35 $2.76 $0.59
209946 2020-02-21 $20.41 First-Class Package Service 2 0.40 lbs $4.63 $4.18 $0.45
209948 2020-02-21 $5.34 First-Class Mail Stamped Letter 1 0.03 lbs $3.35 $2.84 $0.51
209958 2020-02-22 $24.44 First-Class Package Service 3 0.38 lbs $4.77 $3.52 $1.25
209959 2020-02-22 $8.95 First-Class Package Service 2 0.34 lbs $4.57 $4.32 $0.25
209961 2020-02-22 $50.62 Ground 1 1.85 lbs $15.93 $9.48 $6.45
209962 2020-02-22 $32.32 Priority Mail 3-Day 2 1.90 lbs $14.34 $13.49 $0.85
209964 2020-02-23 $12.34 First-Class Mail Stamped Letter 1 0.08 lbs $3.35 $2.84 $0.51
209965 2020-02-23 $58.28 Priority Mail 2-Day Flat Rate Envelope 2 1.50 lbs $8.00 $7.65 $0.35
209966 2020-02-23 $44.60 Priority Mail 2-Day 1 1.35 lbs $9.61 $8.76 $0.85
209969 2020-02-23 $22.74 Priority Mail 2-Day Flat Rate Envelope 6 0.47 lbs $8.00 $7.65 $0.35
209971 2020-02-23 $19.43 Priority Mail 3-Day Flat Rate Envelope 7 0.07 lbs $8.00 $7.65 $0.35
209973 2020-02-23 $7.64 First-Class Package Service 1 0.40 lbs $4.25 $4.00 $0.25
209974 2020-02-23 $41.24 Priority Mail 2-Day Small Flat Rate Box 2 0.23 lbs $8.50 $7.65 $0.85
209976 2020-02-23 $67.33 Priority Mail International Small Flat Rate Box 2 0.90 lbs $27.35 $26.50 $0.85
209977 2020-02-23 $13.41 First-Class Mail Stamped Letter 9 0.10 lbs $3.50 $3.18 $0.32
209978 2020-02-24 $31.82 Priority Mail 2-Day 2 1.11 lbs $10.84 $9.99 $0.85
209979 2020-02-24 $88.87 Priority Mail 2-Day 2 3.75 lbs $8.89 $8.04 $0.85
209988 2020-02-24 $36.89 Priority Mail 3-Day Small Flat Rate Box 1 1.40 lbs $8.50 $7.65 $0.85
209990 2020-02-24 $22.45 First-Class Package Service 1 0.65 lbs $5.79 $5.54 $0.25
209991 2020-02-24 $12.97 Priority Mail 2-Day Flat Rate Envelope 3 0.22 lbs $8.00 $7.65 $0.35
209992 2020-02-25 $8.49 First-Class Mail Stamped Letter 1 0.10 lbs $3.50 $2.93 $0.57
209994 2020-02-25 $8.54 First-Class Mail Stamped Letter 1 0.05 lbs $3.35 $2.78 $0.57
209995 2020-02-25 $9.09 First-Class Mail Stamped Letter 1 0.15 lbs $3.50 $3.05 $0.45
209997 2020-02-25 $9.22 First-Class Package Service 1 0.13 lbs $3.23 $3.25 $-0.02
209998 2020-02-25 $141.39 Priority Mail 3-Day Medium Flat Rate Box 6 5.40 lbs $14.45 $8.92 $5.53
210000 2020-02-25 $7.34 First-Class Mail Stamped Letter 1 0.05 lbs $3.35 $3.18 $0.17
210001 2020-02-21 $4.99 Direct Link International 1 0.10 lbs $0.00 $9.29 $-9.29
210002 2020-02-25 $94.01 Priority Mail 1-Day 5 3.45 lbs $8.79 $7.94 $0.85
210003 2020-02-25 $49.29 Priority Mail 2-Day 20 4.00 lbs $11.49 $10.64 $0.85
210004 2020-02-26 $116.88 Ground 2 8.75 lbs $30.80 $21.83 $8.97
210005 2020-02-26 $26.70 First-Class Package Service 3 0.41 lbs $4.33 $4.08 $0.25
210006 2020-02-26 $53.91 Priority Mail 2-Day 10 3.50 lbs $15.01 $13.20 $1.81
210007 2020-02-26 $76.21 Priority Mail 3-Day 6 2.02 lbs $14.34 $10.53 $3.81
210008 2020-02-26 $13.88 First-Class Package Service 4 0.76 lbs $5.52 $5.27 $0.25
210009 2020-02-26 $184.45 Priority Mail 2-Day 25 8.96 lbs $25.03 $26.96 $-1.93
210010 2020-02-27 $9.99 Priority Mail 2-Day Flat Rate Envelope 1 0.19 lbs $8.00 $7.65 $0.35
210012 2020-02-27 $55.92 Priority Mail 3-Day 2 2.05 lbs $9.44 $8.21 $1.23
210014 2020-02-27 $32.29 Priority Mail 2-Day 10 1.90 lbs $10.39 $9.54 $0.85
210015 2020-02-27 $65.50 Priority Mail 3-Day 5 4.13 lbs $9.35 $8.50 $0.85
210016 2020-02-27 $6.14 First-Class Mail Stamped Letter 1 0.06 lbs $3.35 $2.93 $0.42
210018 2020-02-27 $4.18 First-Class Mail Stamped Letter 2 0.02 lbs $3.20 $3.05 $0.15
210020 2020-02-27 $34.86 Priority Mail 3-Day Medium Flat Rate Box 9 0.20 lbs $14.45 $8.92 $5.53
210022 2020-02-27 $34.98 Priority Mail 2-Day Flat Rate Envelope 2 0.66 lbs $8.00 $7.65 $0.35
210023 2020-02-27 $27.99 Priority Mail 2-Day Flat Rate Envelope 1 0.40 lbs $8.00 $7.65 $0.35
210027 2020-02-27 $47.25 First-Class Package International Service 1 0.60 lbs $27.96 $19.71 $8.25
210032 2020-02-28 $11.32 First-Class Mail Stamped Letter 3 0.04 lbs $3.35 $2.84 $0.51
210034 2020-02-28 $36.38 Priority Mail 2-Day 1 2.40 lbs $10.39 $10.33 $0.06
210037 2020-02-28 $22.25 Direct Link International 6 1.20 lbs $10.91 $19.69 $-8.78
210038 2020-02-28 $5.65 First-Class Mail Stamped Letter 5 0.05 lbs $3.20 $3.05 $0.15
210039 2020-02-28 $94.83 Priority Mail 2-Day 5 6.06 lbs $9.24 $8.39 $0.85
210040 2020-02-28 $5.18 First-Class Mail Stamped Letter 2 0.02 lbs $3.20 $2.78 $0.42
210041 2020-02-28 $38.29 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.50 $7.65 $0.85
210042 2020-02-28 $7.80 First-Class Mail Stamped Letter 1 0.05 lbs $3.35 $2.74 $0.61
210045 2020-02-29 $57.16 Priority Mail 2-Day 3 1.58 lbs $11.39 $10.53 $0.86
210047 2020-02-29 $49.03 Priority Mail 2-Day 1 1.85 lbs $14.34 $11.13 $3.21
210048 2020-02-29 $29.63 Priority Mail 3-Day Large Flat Rate Box 2 0.73 lbs $19.15 $8.76 $10.39
210049 2020-02-29 $23.72 First-Class Package Service 1 0.60 lbs $4.43 $5.40 $-0.97
210050 2020-02-29 $3.69 First-Class Mail Stamped Letter 1 0.01 lbs $3.20 $2.78 $0.42
210051 2020-02-29 $18.99 Priority Mail 2-Day Flat Rate Envelope 1 0.30 lbs $8.00 $7.65 $0.35
210052 2020-02-29 $47.29 Priority Mail 3-Day 2 1.50 lbs $9.61 $8.76 $0.85
210053 2020-02-29 $11.03 First-Class Mail Stamped Letter 1 0.10 lbs $3.50 $3.52 $-0.02
210054 2020-03-01 $5.33 First-Class Mail Stamped Letter 2 0.04 lbs $3.35 $3.25 $0.10
210056 2020-03-01 $56.36 Priority Mail 2-Day 10 0.96 lbs $10.84 $7.65 $3.19
210057 2020-03-01 $7.14 First-Class Mail Stamped Letter 1 0.05 lbs $3.35 $2.78 $0.57
210058 2020-03-01 $8.54 First-Class Mail Stamped Letter 1 0.07 lbs $3.35 $2.76 $0.59
210060 2020-03-01 $8.25 First-Class Mail Stamped Letter 10 0.10 lbs $3.35 $3.05 $0.30
210062 2020-03-01 $35.35 Priority Mail 2-Day Medium Flat Rate Box 10 2.00 lbs $14.45 $13.20 $1.25
210063 2020-03-01 $294.79 Priority Mail 2-Day 1 14.40 lbs $40.80 $41.98 $-1.18
210064 2020-03-01 $40.31 Priority Mail 2-Day Flat Rate Envelope 5 0.95 lbs $8.00 $7.80 $0.20
210065 2020-03-01 $21.19 Priority Mail 3-Day Flat Rate Envelope 1 0.80 lbs $8.00 $7.75 $0.25
210066 2020-03-01 $15.78 First-Class Mail Stamped Letter 6 0.27 lbs $4.00 $3.67 $0.33
210068 2020-03-01 $35.78 Priority Mail 2-Day Flat Rate Envelope 2 0.71 lbs $8.00 $7.65 $0.35
210069 2020-03-01 $19.79 Priority Mail 2-Day Flat Rate Envelope 1 0.30 lbs $8.00 $7.65 $0.35
210072 2020-03-01 $49.71 Priority Mail 2-Day 12 3.15 lbs $18.53 $9.07 $9.46
210073 2020-03-01 $23.00 Priority Mail 3-Day 6 1.18 lbs $12.04 $11.19 $0.85
210074 2020-03-02 $26.39 Priority Mail 3-Day Flat Rate Envelope 1 0.90 lbs $8.00 $8.15 $-0.15
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56