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
221975 2021-02-11 $10.45 First-Class Package Service 2 0.50 lbs $5.67 $4.20 $1.47
221977 2021-02-11 $7.19 First-Class Mail Stamped Letter 1 0.10 lbs $3.20 $3.35 $-0.15
221978 2021-02-11 $35.76 First-Class Mail Stamped Letter 1 0.10 lbs $3.40 $3.12 $0.28
221979 2021-02-11 $18.29 First-Class Package Service 1 0.40 lbs $4.88 $3.58 $1.30
221980 2021-02-11 $150.56 Priority Mail 2-Day Medium Flat Rate Box 4 6.50 lbs $15.00 $12.13 $2.87
221982 2021-02-11 $7.18 USPSFirstClass 1 0.05 lbs $4.29 $3.06 $1.23
221983 2021-02-11 $9.44 USPSFirstClass 1 0.05 lbs $4.45 $3.12 $1.33
221985 2021-02-11 $68.58 Priority Mail 3-Day Padded Flat Rate Envelope 1 3.12 lbs $8.85 $8.00 $0.85
221986 2021-02-11 $24.13 First-Class Package Service 2 0.45 lbs $4.62 $4.12 $0.50
221989 2021-02-11 $52.31 Priority Mail 3-Day 6 1.28 lbs $11.86 $11.01 $0.85
221992 2021-02-11 $140.61 Priority Mail 1-Day 1 3.95 lbs $9.05 $8.20 $0.85
221994 2021-02-11 $16.02 First-Class Mail Stamped Letter 1 0.03 lbs $3.20 $3.22 $-0.02
221998 2021-02-11 $23.05 First-Class Package Service 1 0.32 lbs $4.08 $3.58 $0.50
222000 2021-02-11 $48.82 Priority Mail 2-Day 3 0.18 lbs $8.73 $7.90 $0.83
222002 2021-02-11 $68.11 Priority Mail 3-Day 11 0.88 lbs $11.86 $11.01 $0.85
222003 2021-02-11 $35.56 First-Class Package Service 1 1.15 lbs $5.77 $7.90 $-2.13
222004 2021-02-11 $13.98 Priority Mail 2-Day 1 0.05 lbs $9.19 $7.90 $1.29
222007 2021-02-11 $94.23 Priority Mail 3-Day Flat Rate Envelope 2 3.00 lbs $8.25 $8.45 $-0.20
222008 2021-02-12 $21.53 USPSFirstClass 1 0.49 lbs $5.74 $3.57 $2.17
222009 2021-02-12 $10.33 USPSFirstClass 2 0.04 lbs $4.35 $3.12 $1.23
222010 2021-02-12 $9.90 USPSFirstClass 1 0.06 lbs $4.57 $3.35 $1.22
222011 2021-02-12 $14.48 USPSFirstClass 1 0.06 lbs $4.74 $3.22 $1.52
222012 2021-02-12 $4.99 First-Class Mail Stamped Letter 1 0.02 lbs $3.00 $3.49 $-0.49
222013 2021-02-12 $8.18 First-Class Package Service 1 0.19 lbs $4.19 $3.35 $0.84
222016 2021-02-12 $43.23 Priority Mail 3-Day Flat Rate Envelope 2 1.39 lbs $8.25 $8.25 $0.00
222017 2021-02-12 $13.38 First-Class Mail Stamped Letter 2 0.10 lbs $3.40 $3.35 $0.05
222019 2021-02-12 $24.42 USPSFirstClass 2 0.12 lbs $4.94 $3.49 $1.45
222020 2021-02-12 $7.33 USPSFirstClass 1 0.10 lbs $4.44 $3.35 $1.09
222021 2021-02-12 $66.69 USPSPriority 1 5.15 lbs $18.70 $14.32 $4.38
222022 2021-02-12 $40.92 USPSFirstClass 5 2.00 lbs $21.97 $8.72 $13.25
222026 2021-01-04 $43.99 Priority Mail 2-Day Medium Flat Rate Box 1 3.32 lbs $10.00 $8.00 $2.00
222027 2021-02-12 $7.99 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.35 $-0.15
222028 2021-02-12 $12.68 First-Class Mail Stamped Letter 2 0.10 lbs $3.40 $3.12 $0.28
222029 2021-02-12 $94.23 Priority Mail 2-Day Flat Rate Envelope 2 3.05 lbs $8.25 $8.45 $-0.20
222031 2021-02-12 $41.95 Priority Mail 2-Day 8 0.98 lbs $11.29 $10.44 $0.85
222034 2021-02-12 $23.42 Priority Mail 2-Day Flat Rate Envelope 3 0.10 lbs $8.25 $7.90 $0.35
222035 2021-02-12 $129.04 Priority Mail 2-Day 1 3.62 lbs $9.05 $8.10 $0.95
222037 2021-02-12 $98.99 Priority Mail 2-Day 41 8.20 lbs $13.30 $15.59 $-2.29
222040 2021-02-12 $7.81 USPSFirstClass 1 0.03 lbs $4.32 $3.06 $1.26
222041 2021-02-12 $15.38 USPSFirstClass 2 0.12 lbs $4.72 $3.49 $1.23
222042 2021-02-12 $23.93 USPSFirstClass 7 0.49 lbs $10.00 $5.98 $4.02
222043 2021-02-12 $12.09 First-Class Mail Stamped Letter 1 0.18 lbs $3.60 $3.35 $0.25
222044 2021-02-12 $23.08 Priority Mail 3-Day 1 1.12 lbs $9.09 $8.34 $0.75
222046 2021-02-12 $42.33 Priority Mail 2-Day Small Flat Rate Box 2 0.90 lbs $8.75 $8.25 $0.50
222048 2021-02-12 $5.18 First-Class Mail Stamped Letter 2 0.03 lbs $3.20 $3.12 $0.08
222049 2021-02-12 $36.74 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.75 $7.90 $0.85
222050 2021-02-12 $23.24 Priority Mail 3-Day Flat Rate Envelope 1 0.03 lbs $8.25 $7.90 $0.35
222052 2021-02-12 $16.54 Priority Mail 3-Day Small Flat Rate Box 1 0.04 lbs $8.75 $7.67 $1.08
222056 2021-02-12 $19.99 First-Class Package Service 2 0.37 lbs $4.01 $3.51 $0.50
222058 2021-02-13 $9.90 USPSFirstClass 1 0.10 lbs $4.71 $3.49 $1.22
222059 2021-02-13 $67.99 USPSPriority 1 1.19 lbs $14.62 $7.90 $6.72
222062 2021-02-13 $16.01 First-Class Package Service 2 0.09 lbs $3.85 $3.35 $0.50
222063 2021-02-13 $13.36 USPSFirstClass 1 0.18 lbs $4.87 $3.85 $1.02
222064 2021-02-13 $7.14 USPSFirstClass 1 0.03 lbs $4.15 $3.01 $1.14
222065 2021-02-13 $14.48 USPSFirstClass 2 0.10 lbs $4.50 $3.22 $1.28
222067 2021-02-13 $34.98 Priority Mail 2-Day Small Flat Rate Box 1 1.00 lbs $8.75 $7.90 $0.85
222068 2021-02-13 $14.29 First-Class Package Service 1 0.30 lbs $4.08 $3.58 $0.50
222069 2021-02-13 $43.18 First-Class Package Service 1 0.25 lbs $4.19 $3.69 $0.50
222070 2021-02-13 $38.54 Priority Mail 2-Day Small Flat Rate Box 1 0.90 lbs $8.75 $7.90 $0.85
222071 2021-02-13 $16.85 First-Class Package Service 2 0.30 lbs $4.07 $3.57 $0.50
222073 2021-02-13 $21.21 First-Class Package Service 1 0.60 lbs $4.45 $5.42 $-0.97
222076 2021-02-13 $8.44 USPSFirstClass 1 0.05 lbs $4.45 $3.22 $1.23
222077 2021-02-13 $8.11 USPSFirstClass 1 0.04 lbs $4.62 $3.49 $1.13
222078 2021-02-13 $12.43 USPSFirstClass 1 0.06 lbs $4.64 $3.22 $1.42
222079 2021-02-13 $66.87 Priority Mail 3-Day Padded Flat Rate Envelope 2 2.20 lbs $8.85 $7.90 $0.95
222080 2021-02-13 $7.18 First-Class Package Service 1 0.20 lbs $4.19 $3.69 $0.50
222082 2021-02-13 $8.39 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.35 $-0.15
222083 2021-02-13 $51.74 Priority Mail 2-Day Small Flat Rate Box 1 1.45 lbs $8.75 $7.90 $0.85
222084 2021-02-13 $58.84 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.31 lbs $8.85 $8.00 $0.85
222088 2021-02-13 $94.94 Ground 4 4.86 lbs $25.89 $23.61 $2.28
222089 2021-02-13 $45.83 Priority Mail 2-Day 6 4.98 lbs $10.49 $9.64 $0.85
222090 2021-02-13 $5.49 First-Class Mail Stamped Letter 1 0.01 lbs $3.00 $3.12 $-0.12
222091 2021-02-13 $35.76 First-Class Mail Stamped Letter 1 0.10 lbs $3.40 $3.49 $-0.09
222092 2021-02-13 $23.74 Priority Mail 2-Day Small Flat Rate Box 1 0.35 lbs $8.75 $7.90 $0.85
222097 2021-02-13 $18.44 First-Class Package Service 3 0.21 lbs $4.07 $3.12 $0.95
222099 2021-02-14 $19.18 USPSFirstClass 1 0.40 lbs $5.77 $3.69 $2.08
222100 2021-02-14 $5.49 USPSFirstClass 1 0.01 lbs $4.50 $3.49 $1.01
222101 2021-02-14 $19.08 USPSFirstClass 1 0.40 lbs $5.67 $3.58 $2.09
222105 2021-02-14 $9.09 First-Class Package Service 10 0.20 lbs $4.19 $3.69 $0.50
222106 2021-02-14 $38.95 First-Class Package Service 2 0.75 lbs $5.77 $5.57 $0.20
222107 2021-02-14 $13.40 First-Class Package Service 2 0.06 lbs $3.62 $3.12 $0.50
222108 2021-02-14 $6.70 First-Class Package Service 2 0.02 lbs $3.72 $3.22 $0.50
222109 2021-02-14 $29.28 USPSPriority 1 3.10 lbs $10.49 $8.00 $2.49
222110 2021-02-14 $11.84 USPSFirstClass 3 0.03 lbs $4.37 $3.58 $0.79
222112 2021-02-14 $14.70 First-Class Package Service 2 0.09 lbs $3.72 $3.22 $0.50
222114 2021-02-14 $8.39 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.01 $0.19
222116 2021-02-14 $9.18 First-Class Mail Stamped Letter 2 0.10 lbs $3.40 $3.49 $-0.09
222117 2021-02-14 $6.67 First-Class Package Service 1 0.19 lbs $4.08 $3.22 $0.86
222118 2021-02-14 $12.39 First-Class Mail Stamped Letter 1 0.10 lbs $3.40 $3.12 $0.28
222119 2021-02-14 $29.47 Priority Mail 2-Day Medium Flat Rate Box 3 0.68 lbs $15.00 $10.89 $4.11
222120 2021-02-14 $13.85 USPSPriority 1 0.06 lbs $8.52 $7.67 $0.85
222121 2021-02-14 $9.49 USPSFirstClass 1 0.02 lbs $4.50 $3.22 $1.28
222122 2021-02-14 $21.77 USPSFirstClass 2 0.77 lbs $10.19 $11.69 $-1.50
222123 2021-02-14 $9.90 USPSFirstClass 1 0.07 lbs $4.71 $3.49 $1.22
222124 2021-02-14 $29.04 USPSFirstClass 4 0.40 lbs $5.20 $4.12 $1.08
222128 2021-02-14 $11.09 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.49 $-0.29
222129 2021-02-14 $13.23 Priority Mail 3-Day Flat Rate Envelope 2 0.40 lbs $8.25 $8.52 $-0.27
222131 2021-02-14 $64.37 Priority Mail 2-Day 1 3.95 lbs $10.38 $9.53 $0.85
222132 2021-02-14 $13.04 First-Class Package Service - Retail 1 0.05 lbs $5.15 $3.35 $1.80
222133 2021-02-14 $5.84 First-Class Package Service 1 0.19 lbs $4.35 $3.49 $0.86
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56