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
223018 2021-03-06 $47.13 First-Class Package Service 5 0.30 lbs $4.01 $3.51 $0.50
223019 2021-03-06 $15.86 First-Class Package Service 1 0.35 lbs $4.07 $4.20 $-0.13
223020 2021-03-06 $7.48 USPSFirstClass 1 0.10 lbs $4.59 $3.49 $1.10
223021 2021-03-06 $6.29 USPSFirstClass 1 0.08 lbs $4.30 $3.12 $1.18
223022 2021-03-06 $8.77 USPSFirstClass 1 0.10 lbs $4.42 $3.12 $1.30
223023 2021-03-06 $8.44 USPSFirstClass 1 0.09 lbs $4.45 $3.22 $1.23
223024 2021-03-06 $94.30 Priority Mail 2-Day 3 8.06 lbs $13.30 $8.34 $4.96
223025 2021-03-06 $15.05 First-Class Package Service 1 0.25 lbs $4.07 $3.57 $0.50
223026 2021-03-06 $30.24 Priority Mail 2-Day Flat Rate Envelope 1 1.00 lbs $8.25 $8.45 $-0.20
223028 2021-03-06 $9.58 USPSFirstClass 1 0.05 lbs $4.69 $3.49 $1.20
223031 2021-03-06 $4.96 First-Class Mail Stamped Letter 4 0.04 lbs $3.00 $3.06 $-0.06
223032 2021-03-06 $12.27 First-Class Mail Stamped Letter 3 0.15 lbs $3.60 $3.35 $0.25
223034 2021-03-06 $8.38 Pickup From Store 1 0.05 lbs $0.00 $3.06 $-3.06
223035 2021-03-06 $7.23 USPSFirstClass 1 0.10 lbs $4.34 $3.12 $1.22
223036 2021-03-06 $38.37 Priority Mail 2-Day Flat Rate Envelope 2 1.15 lbs $8.25 $7.90 $0.35
223039 2021-03-06 $72.27 Priority Mail 2-Day Medium Flat Rate Box 23 2.69 lbs $15.00 $13.75 $1.25
223040 2021-03-06 $8.18 First-Class Package Service 1 0.19 lbs $4.19 $3.35 $0.84
223042 2021-03-06 $6.18 First-Class Mail Stamped Letter 2 0.10 lbs $3.20 $3.06 $0.14
223045 2021-03-06 $10.17 First-Class Mail Stamped Letter 3 0.08 lbs $3.20 $3.49 $-0.29
223048 2021-03-06 $35.27 First-Class Package Service - Retail 3 0.54 lbs $6.80 $4.68 $2.12
223051 2021-03-06 $48.83 Priority Mail 3-Day Padded Flat Rate Envelope 2 2.10 lbs $8.85 $7.90 $0.95
223054 2021-03-06 $5.18 First-Class Mail Stamped Letter 2 0.04 lbs $3.20 $3.22 $-0.02
223055 2021-03-06 $57.99 Priority Mail 2-Day Medium Flat Rate Box 1 1.70 lbs $15.00 $12.64 $2.36
223058 2021-03-06 $41.46 Priority Mail 3-Day 9 2.42 lbs $14.95 $14.10 $0.85
223059 2021-03-06 $12.83 First-Class Package Service 2 0.23 lbs $4.19 $3.69 $0.50
223060 2021-03-07 $51.29 Priority Mail 2-Day 7 2.96 lbs $10.06 $8.34 $1.72
223062 2021-03-07 $20.83 First-Class Package Service - Retail 12 0.27 lbs $6.05 $3.85 $2.20
223063 2021-03-07 $28.50 First-Class Package Service 2 0.65 lbs $5.92 $5.42 $0.50
223064 2021-03-07 $7.33 USPSFirstClass 1 0.10 lbs $4.44 $3.35 $1.09
223065 2021-03-07 $9.43 USPSFirstClass 1 0.03 lbs $4.54 $3.35 $1.19
223066 2021-03-07 $34.58 USPSMedia 1 3.15 lbs $6.00 $4.57 $1.43
223067 2021-03-07 $17.22 Priority Mail 3-Day Flat Rate Envelope 3 0.10 lbs $8.25 $7.88 $0.37
223068 2021-03-07 $7.29 First-Class Mail Stamped Letter 1 0.15 lbs $3.40 $3.85 $-0.45
223069 2021-03-07 $10.53 USPSFirstClass 1 0.04 lbs $4.74 $3.49 $1.25
223070 2021-03-07 $7.67 First-Class Mail Stamped Letter 3 0.15 lbs $3.20 $3.49 $-0.29
223071 2021-03-07 $9.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.06 $0.14
223072 2021-03-07 $7.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.12 $0.08
223073 2021-03-07 $20.07 USPSFirstClass 2 0.60 lbs $6.29 $4.68 $1.61
223074 2021-03-07 $6.49 First-Class Mail Stamped Letter 1 0.03 lbs $3.00 $3.06 $-0.06
223075 2021-03-07 $14.61 First-Class Package Service 11 0.12 lbs $3.72 $3.22 $0.50
223076 2021-03-07 $48.92 Priority Mail 2-Day Flat Rate Envelope 3 1.16 lbs $8.25 $8.45 $-0.20
223077 2021-03-07 $6.09 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.35 $-0.15
223078 2021-03-07 $12.74 First-Class Mail Stamped Letter 2 0.11 lbs $3.40 $3.58 $-0.18
223079 2021-03-07 $15.67 First-Class Mail Stamped Letter 3 0.07 lbs $3.20 $3.22 $-0.02
223080 2021-03-07 $106.00 Priority Mail 2-Day 3 5.65 lbs $25.11 $18.04 $7.07
223081 2021-03-07 $12.43 USPSFirstClass 1 0.30 lbs $5.54 $3.85 $1.69
223083 2021-03-08 $29.07 USPSMedia 1 1.95 lbs $4.67 $3.45 $1.22
223086 2021-03-08 $12.33 USPSFirstClass 1 0.06 lbs $4.54 $3.06 $1.48
223087 2021-03-08 $8.40 USPSFirstClass 1 0.01 lbs $4.35 $3.06 $1.29
223090 2021-03-07 $17.70 Priority Mail 2-Day 3 0.03 lbs $8.73 $7.90 $0.83
223093 2021-03-07 $34.22 Priority Mail 2-Day Flat Rate Envelope 3 0.33 lbs $8.25 $7.90 $0.35
223094 2021-03-07 $25.16 First-Class Package Service 1 0.80 lbs $5.67 $5.42 $0.25
223095 2021-03-07 $21.35 First-Class Package Service 4 0.60 lbs $4.54 $5.19 $-0.65
223096 2021-03-07 $83.83 Priority Mail 2-Day Padded Flat Rate Envelope 2 2.70 lbs $8.85 $8.00 $0.85
223097 2021-03-07 $145.05 Priority Mail 3-Day 1 2.92 lbs $10.06 $9.21 $0.85
223100 2021-03-07 $9.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.06 $0.14
223101 2021-03-08 $16.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.06 $0.14
223102 2021-03-08 $29.38 First-Class Mail Stamped Letter 2 0.10 lbs $3.40 $3.06 $0.34
223103 2021-03-08 $114.86 USPSPriority 4 9.20 lbs $34.90 $47.21 $-12.31
223105 2021-03-08 $12.18 USPSFirstClass 1 0.06 lbs $4.39 $3.01 $1.38
223106 2021-03-08 $70.43 Priority Mail 2-Day 2 2.90 lbs $8.95 $7.83 $1.12
223107 2021-03-08 $41.29 Priority Mail 2-Day Padded Flat Rate Envelope 1 7.50 lbs $8.85 $8.00 $0.85
223108 2021-03-08 $12.98 First-Class Mail Stamped Letter 2 0.10 lbs $3.40 $3.35 $0.05
223109 2021-03-08 $12.23 USPSFirstClass 1 0.30 lbs $5.34 $3.58 $1.76
223110 2021-03-08 $6.09 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.49 $-0.29
223111 2021-03-08 $8.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.06 $0.14
223112 2021-03-08 $6.49 First-Class Mail Stamped Letter 1 0.03 lbs $3.00 $3.49 $-0.49
223113 2021-03-08 $99.59 Priority Mail 2-Day Medium Flat Rate Box 4 9.55 lbs $15.00 $9.52 $5.48
223114 2021-03-08 $10.29 First-Class Package Service 6 0.25 lbs $4.35 $3.49 $0.86
223115 2021-03-08 $22.03 USPSFirstClass 2 0.25 lbs $9.05 $3.12 $5.93
223116 2021-03-08 $7.50 USPSMedia 1 0.25 lbs $3.11 $2.89 $0.22
223117 2021-03-08 $8.11 USPSFirstClass 1 0.02 lbs $4.62 $3.49 $1.13
223118 2021-03-08 $21.87 First-Class Package Service 2 0.45 lbs $5.03 $4.53 $0.50
223119 2021-03-08 $21.39 First-Class Package Service 2 0.36 lbs $4.19 $3.69 $0.50
223122 2021-03-08 $11.35 USPSFirstClass 2 0.06 lbs $4.37 $3.12 $1.25
223123 2021-03-08 $18.49 First-Class Package Service 4 0.14 lbs $3.76 $3.51 $0.25
223124 2021-03-08 $8.55 First-Class Package Service 1 0.07 lbs $3.56 $3.06 $0.50
223125 2021-03-08 $8.61 First-Class Package Service 1 0.05 lbs $3.62 $3.12 $0.50
223126 2021-03-08 $13.79 First-Class Mail Stamped Letter 1 0.14 lbs $3.40 $3.12 $0.28
223127 2021-03-08 $47.79 First-Class Package Service 2 0.30 lbs $4.01 $3.51 $0.50
223128 2021-03-08 $16.96 First-Class Package Service - Retail 4 0.11 lbs $5.00 $3.06 $1.94
223130 2021-03-08 $148.34 Ground 9 32.59 lbs $48.79 $47.36 $1.43
223133 2021-03-09 $30.13 Priority Mail 2-Day Flat Rate Envelope 2 1.28 lbs $8.25 $7.90 $0.35
223134 2021-03-09 $19.84 First-Class Mail Stamped Letter 6 0.13 lbs $3.40 $3.12 $0.28
223136 2021-03-09 $17.40 First-Class Package Service 2 0.10 lbs $3.62 $3.12 $0.50
223138 2021-03-09 $16.34 First-Class Package Service 1 0.24 lbs $4.35 $3.85 $0.50
223139 2021-03-09 $36.19 USPSPriority 1 1.70 lbs $16.20 $12.13 $4.07
223140 2021-03-09 $7.44 USPSFirstClass 1 0.03 lbs $4.45 $3.35 $1.10
223141 2021-03-09 $9.49 USPSFirstClass 1 0.05 lbs $4.50 $3.22 $1.28
223142 2021-03-09 $37.62 UPSGround 1 0.69 lbs $12.63 $20.49 $-7.86
223143 2021-03-09 $113.02 Priority Mail 3-Day Medium Flat Rate Box 4 6.16 lbs $15.00 $11.63 $3.37
223144 2021-03-09 $10.98 First-Class Mail Stamped Letter 2 0.09 lbs $3.20 $3.49 $-0.29
223145 2021-03-09 $9.62 USPSFirstClass 1 0.61 lbs $6.03 $5.81 $0.22
223147 2021-03-09 $13.08 First-Class Mail Stamped Letter 2 0.10 lbs $3.40 $3.06 $0.34
223149 2021-03-09 $9.28 USPSFirstClass 1 0.04 lbs $4.39 $3.06 $1.33
223150 2021-03-09 $38.80 UPSGround 1 0.69 lbs $13.81 $17.25 $-3.44
223151 2021-03-09 $25.03 First-Class Package Service 17 0.25 lbs $3.76 $3.51 $0.25
223153 2021-03-09 $15.87 First-Class Package Service 1 0.30 lbs $4.08 $3.58 $0.50
223154 2021-03-09 $48.72 First-Class Package Service 1 0.90 lbs $5.73 $5.23 $0.50
223156 2021-03-09 $11.45 First-Class Package Service 1 0.05 lbs $3.56 $3.06 $0.50
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56