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
215965 2020-09-27 $15.23 First-Class Mail Stamped Letter 7 0.17 lbs $3.50 $2.84 $0.66
215968 2020-09-27 $51.49 Priority Mail 2-Day Small Flat Rate Box 1 1.55 lbs $8.50 $8.05 $0.45
215969 2020-09-28 $31.09 First-Class Package Service 2 0.55 lbs $4.91 $5.70 $-0.79
215970 2020-09-28 $19.69 USPSFirstClass 1 0.02 lbs $4.70 $2.84 $1.86
215972 2020-09-28 $6.65 USPSFirstClass 1 0.19 lbs $4.10 $2.93 $1.17
215973 2020-09-28 $11.99 USPSFirstClass 1 0.39 lbs $5.29 $3.67 $1.62
215974 2020-09-28 $19.97 USPSFirstClass 3 0.30 lbs $5.00 $2.84 $2.16
215975 2020-09-28 $51.49 Priority Mail 2-Day Small Flat Rate Box 1 1.55 lbs $8.50 $8.05 $0.45
215976 2020-09-28 $30.92 Priority Mail 2-Day Flat Rate Envelope 1 0.45 lbs $8.00 $7.65 $0.35
215977 2020-09-28 $8.82 First-Class Package Service 2 0.24 lbs $3.64 $4.18 $-0.54
215979 2020-09-28 $5.12 First-Class Package Service 1 0.01 lbs $3.23 $2.78 $0.45
215981 2020-09-28 $17.54 First-Class Package Service 3 0.15 lbs $3.23 $3.25 $-0.02
215986 2020-09-29 $39.67 USPSFirstClass 1 0.89 lbs $9.40 $5.12 $4.28
215987 2020-09-28 $9.47 First-Class Mail Stamped Letter 3 0.09 lbs $3.50 $3.05 $0.45
215988 2020-09-28 $12.28 First-Class Mail Stamped Letter 7 0.08 lbs $3.35 $3.05 $0.30
215989 2020-09-28 $5.16 First-Class Mail Stamped Letter 4 0.04 lbs $3.20 $2.84 $0.36
215991 2020-09-29 $8.18 USPSFirstClass 1 0.03 lbs $4.12 $2.84 $1.28
215992 2020-09-28 $15.63 First-Class Package Service 1 0.28 lbs $3.84 $3.64 $0.20
215994 2020-09-29 $31.23 USPSFirstClass 2 0.32 lbs $5.21 $3.21 $2.00
215999 2020-09-28 $17.08 Priority Mail 2-Day 3 0.22 lbs $8.41 $7.65 $0.76
216000 2020-09-28 $9.26 First-Class Package Service 3 0.09 lbs $3.29 $2.84 $0.45
216001 2020-09-29 $10.36 USPSFirstClass 1 0.20 lbs $4.27 $5.40 $-1.13
216004 2020-09-29 $27.56 Priority Mail 2-Day 8 1.60 lbs $10.84 $9.99 $0.85
216005 2020-09-29 $38.29 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.50 $7.65 $0.85
216006 2020-09-29 $20.00 USPSFirstClass 2 1.22 lbs $11.66 $10.54 $1.12
216009 2020-09-29 $9.27 First-Class Package Service 2 0.07 lbs $3.29 $2.84 $0.45
216012 2020-09-29 $9.71 USPSFirstClass 1 0.20 lbs $4.22 $4.08 $0.14
216014 2020-09-29 $44.59 Priority Mail 3-Day Padded Flat Rate Envelope 1 1.35 lbs $8.60 $7.75 $0.85
216015 2020-09-29 $14.75 USPSFirstClass 2 0.07 lbs $4.44 $3.18 $1.26
216016 2020-09-29 $3.72 First-Class Package Service 1 0.01 lbs $3.23 $2.78 $0.45
216017 2020-09-29 $19.92 First-Class Package Service 3 0.41 lbs $4.25 $4.00 $0.25
216018 2020-09-29 $52.74 First-Class Package Service 3 0.75 lbs $5.57 $5.12 $0.45
216021 2020-09-29 $65.93 Priority Mail 3-Day 9 3.00 lbs $9.92 $9.07 $0.85
216022 2020-09-29 $30.12 Priority Mail 2-Day 8 1.90 lbs $13.00 $12.15 $0.85
216025 2020-09-29 $13.15 First-Class Package Service 1 0.25 lbs $3.66 $3.21 $0.45
216029 2020-09-29 $39.07 Priority Mail 1-Day Flat Rate Envelope 1 1.05 lbs $8.00 $7.65 $0.35
216030 2020-09-30 $26.01 USPSFirstClass 4 0.40 lbs $4.85 $2.74 $2.11
216031 2020-09-30 $14.98 USPSFirstClass 2 0.40 lbs $5.00 $4.08 $0.92
216032 2020-09-30 $12.03 USPSFirstClass 4 0.04 lbs $3.99 $2.78 $1.21
216035 2020-09-30 $27.10 First-Class Package Service 1 0.40 lbs $4.91 $4.46 $0.45
216037 2020-09-30 $32.45 First-Class Package Service 2 0.48 lbs $4.38 $3.93 $0.45
216038 2020-09-30 $10.32 First-Class Mail Stamped Letter 3 0.04 lbs $3.35 $3.05 $0.30
216043 2020-09-30 $7.77 First-Class Package Service 1 0.10 lbs $3.38 $2.93 $0.45
216044 2020-09-30 $22.74 First-Class Package Service 3 0.26 lbs $3.97 $4.32 $-0.35
216045 2020-09-30 $40.18 Priority Mail 2-Day Small Flat Rate Box 2 1.20 lbs $8.50 $7.65 $0.85
216048 2020-10-01 $16.00 USPSFirstClass 1 0.05 lbs $4.35 $2.74 $1.61
216049 2020-09-30 $51.34 Priority Mail Express 2-Day 1 0.60 lbs $32.05 $31.20 $0.85
216051 2020-07-10 $2245.69 Ground 58 104.70 lbs $158.79 $123.92 $34.87
216053 2020-10-01 $10.08 USPSFirstClass 1 0.20 lbs $4.45 $3.67 $0.78
216054 2020-09-30 $73.30 Priority Mail 3-Day 1 3.95 lbs $19.31 $18.46 $0.85
216056 2020-10-01 $15.86 USPSFirstClass 3 0.09 lbs $4.17 $2.93 $1.24
216057 2020-09-30 $44.13 Priority Mail 3-Day Padded Flat Rate Envelope 1 1.40 lbs $8.60 $7.75 $0.85
216058 2020-09-30 $26.33 First-Class Package Service 2 0.58 lbs $4.45 $5.12 $-0.67
216061 2020-10-01 $10.22 USPSFirstClass 1 0.02 lbs $4.45 $3.18 $1.27
216063 2020-10-01 $127.40 Priority Mail 2-Day Medium Flat Rate Box 3 7.95 lbs $14.45 $8.30 $6.15
216067 2020-10-01 $9.49 First-Class Package Service 1 0.01 lbs $3.50 $3.05 $0.45
216068 2020-10-01 $18.72 First-Class Package Service 2 0.35 lbs $4.12 $4.46 $-0.34
216069 2020-10-01 $27.49 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $8.00 $7.75 $0.25
216076 2020-10-01 $4.34 First-Class Mail Stamped Letter 1 0.01 lbs $3.35 $3.05 $0.30
216077 2020-10-01 $12.50 USPSFirstClass 3 0.45 lbs $5.50 $5.12 $0.38
216079 2020-10-01 $51.19 First-Class Package Service 6 0.60 lbs $4.45 $4.00 $0.45
216080 2020-10-01 $9.47 USPSFirstClass 1 0.10 lbs $4.22 $2.93 $1.29
216081 2020-10-01 $49.39 Priority Mail 3-Day Flat Rate Envelope 2 1.55 lbs $8.00 $7.65 $0.35
216082 2020-10-01 $11.03 First-Class Package Service 1 0.04 lbs $3.50 $3.05 $0.45
216086 2020-10-01 $25.27 Priority Mail 2-Day 6 0.30 lbs $8.83 $7.65 $1.18
216088 2020-10-01 $9.28 First-Class Mail Stamped Letter 2 0.10 lbs $3.50 $3.05 $0.45
216093 2020-10-01 $9.46 USPSFirstClass 1 0.10 lbs $4.20 $2.84 $1.36
216094 2020-10-01 $10.41 USPSFirstClass 1 0.07 lbs $4.32 $3.05 $1.27
216096 2020-10-01 $11.81 First-Class Package Service 7 0.12 lbs $3.38 $2.93 $0.45
216098 2020-10-01 $22.59 First-Class Package Service 1 0.35 lbs $3.84 $3.39 $0.45
216099 2020-10-01 $44.59 Priority Mail 3-Day Padded Flat Rate Envelope 1 1.35 lbs $8.60 $7.75 $0.85
216100 2020-10-02 $43.02 USPSPriority 1 3.10 lbs $21.74 $7.75 $13.99
216102 2020-10-01 $41.02 Priority Mail 3-Day Flat Rate Envelope 4 0.46 lbs $8.00 $7.65 $0.35
216106 2020-10-01 $31.05 Priority Mail 2-Day Small Flat Rate Box 5 0.20 lbs $8.50 $7.65 $0.85
216107 2020-10-02 $14.26 USPSFirstClass 3 0.10 lbs $4.35 $3.18 $1.17
216112 2020-10-01 $56.49 Priority Mail 3-Day Small Flat Rate Box 1 1.50 lbs $8.50 $7.65 $0.85
216114 2020-10-01 $51.59 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.36 lbs $8.60 $7.75 $0.85
216115 2020-10-01 $21.49 Priority Mail 3-Day Flat Rate Envelope 1 1.00 lbs $8.00 $7.65 $0.35
216116 2020-10-01 $13.24 First-Class Package Service 2 0.25 lbs $3.70 $2.78 $0.92
216117 2020-10-02 $20.96 USPSFirstClass 1 0.03 lbs $4.65 $2.78 $1.87
216118 2020-10-02 $19.88 First-Class Package Service 3 0.47 lbs $4.71 $4.46 $0.25
216119 2020-10-02 $8.16 USPSFirstClass 1 0.03 lbs $4.12 $2.84 $1.28
216121 2020-10-02 $10.27 First-Class Package Service 2 0.08 lbs $3.29 $2.84 $0.45
216122 2020-10-02 $23.57 InternationalPriorityShipping 1 0.35 lbs $5.22 $4.32 $0.90
216123 2020-10-02 $9.74 USPSFirstClass 1 0.02 lbs $4.25 $2.93 $1.32
216124 2020-10-02 $104.92 Priority Mail 3-Day Padded Flat Rate Envelope 4 3.20 lbs $8.60 $7.75 $0.85
216128 2020-10-02 $8.08 USPSFirstClass 1 0.02 lbs $4.16 $2.93 $1.23
216130 2020-10-02 $24.48 Priority Mail 3-Day Flat Rate Envelope 1 0.85 lbs $8.00 $7.75 $0.25
216133 2020-10-02 $38.29 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.50 $7.90 $0.60
216135 2020-10-02 $7.19 First-Class Mail Stamped Letter 1 0.03 lbs $3.20 $2.93 $0.27
216138 2020-10-02 $34.77 USPSFirstClass 5 0.38 lbs $5.67 $3.25 $2.42
216140 2020-10-02 $12.93 First-Class Package Service 4 0.49 lbs $5.57 $4.00 $1.57
216141 2020-10-02 $58.59 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.95 lbs $8.60 $7.75 $0.85
216146 2020-10-02 $44.59 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.35 lbs $8.60 $7.75 $0.85
216147 2020-10-02 $47.00 Priority Mail 3-Day Small Flat Rate Box 1 1.50 lbs $8.50 $7.65 $0.85
216148 2020-10-02 $52.00 Priority Mail 3-Day Flat Rate Envelope 4 1.15 lbs $8.00 $7.65 $0.35
216151 2020-10-02 $8.71 First-Class Package Service 2 0.08 lbs $3.23 $2.78 $0.45
216153 2020-10-02 $20.19 First-Class Package Service 4 0.65 lbs $5.29 $5.04 $0.25
216154 2020-10-02 $13.22 First-Class Package Service 1 0.13 lbs $3.23 $3.25 $-0.02
216155 2020-10-02 $11.66 First-Class Package Service 4 0.12 lbs $3.70 $2.78 $0.92
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56