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
225176 2021-05-21 $107.16 Priority Mail 2-Day 1 3.00 lbs $17.88 $33.56 $-15.68
225178 2021-05-21 $43.99 Priority Mail 3-Day Small Flat Rate Box 1 1.15 lbs $9.00 $15.80 $-6.80
225180 2021-05-21 $31.68 Priority Mail 3-Day 3 0.30 lbs $12.11 $22.02 $-9.91
225181 2021-05-21 $31.23 First-Class Package Service 6 0.36 lbs $5.73 $9.06 $-3.33
225182 2021-05-21 $23.48 First-Class Package Service 1 0.65 lbs $6.22 $10.54 $-4.32
225183 2021-05-21 $200.47 Priority Mail 3-Day Medium Flat Rate Box 3 6.38 lbs $15.40 $16.00 $-0.60
225184 2021-05-22 $51.05 Priority Mail 3-Day Small Flat Rate Box 1 1.70 lbs $9.00 $15.80 $-6.80
225185 2021-05-22 $152.39 Ground 1 8.10 lbs $39.20 $28.52 $10.68
225187 2021-05-22 $9.44 USPSFirstClass 1 0.05 lbs $4.45 $3.12 $1.33
225188 2021-05-22 $19.34 USPSPriority 1 0.31 lbs $10.35 $7.90 $2.45
225189 2021-05-22 $57.99 Priority Mail 2-Day Small Flat Rate Box 1 1.65 lbs $9.00 $15.80 $-6.80
225190 2021-05-22 $31.38 First-Class Package Service 6 0.36 lbs $5.88 $9.36 $-3.48
225193 2021-05-22 $43.99 Priority Mail 2-Day Small Flat Rate Box 1 1.15 lbs $9.00 $15.80 $-6.80
225194 2021-05-22 $43.99 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $9.00 $15.80 $-6.80
225195 2021-05-22 $7.59 First-Class Mail Stamped Letter 1 0.02 lbs $3.60 $6.24 $-2.64
225197 2021-05-22 $30.73 Priority Mail 2-Day 1 2.14 lbs $10.74 $16.00 $-5.26
225198 2021-05-22 $43.99 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $9.00 $15.80 $-6.80
225200 2021-05-22 $5.09 First-Class Mail Stamped Letter 1 0.02 lbs $3.60 $6.44 $-2.84
225201 2021-05-22 $43.99 Priority Mail 3-Day Small Flat Rate Box 1 1.15 lbs $9.00 $15.80 $-6.80
225203 2021-05-23 $15.46 Priority Mail 2-Day 2 0.03 lbs $8.98 $15.76 $-6.78
225204 2021-05-23 $200.38 Priority Mail 3-Day 5 6.75 lbs $13.05 $8.34 $4.71
225205 2021-05-23 $11.30 USPSFirstClass 2 0.06 lbs $4.32 $3.06 $1.26
225206 2021-05-23 $6.56 First-Class Mail Stamped Letter 4 0.04 lbs $3.60 $6.12 $-2.52
225207 2021-05-23 $107.16 Priority Mail 3-Day 1 3.00 lbs $17.88 $16.78 $1.10
225208 2021-05-23 $20.12 USPSFirstClass 2 0.12 lbs $4.54 $3.06 $1.48
225209 2021-05-23 $10.65 First-Class Package Service 1 0.19 lbs $4.66 $3.01 $1.65
225210 2021-05-23 $12.38 USPSFirstClass 1 0.06 lbs $4.59 $3.12 $1.47
225211 2021-05-23 $172.44 Ground Home Delivery 9 3.62 lbs $29.63 $37.90 $-8.27
225212 2021-05-23 $75.09 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.80 lbs $9.10 $8.00 $1.10
225213 2021-05-24 $7.39 USPSFirstClass 1 0.03 lbs $4.40 $3.22 $1.18
225214 2021-05-23 $57.78 Priority Mail International Flat Rate Envelope 2 1.35 lbs $26.65 $28.10 $-1.45
225215 2021-05-23 $67.19 Priority Mail 3-Day 1 1.70 lbs $15.20 $11.63 $3.57
225216 2021-05-24 $10.29 USPSFirstClass 1 0.05 lbs $4.54 $3.22 $1.32
225220 2021-05-24 $43.99 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $9.00 $7.90 $1.10
225222 2021-05-24 $12.63 USPSFirstClass 1 0.06 lbs $4.84 $3.49 $1.35
225223 2021-05-24 $6.58 First-Class Mail Stamped Letter 2 0.02 lbs $3.60 $3.22 $0.38
225225 2021-05-24 $45.54 Priority Mail 2-Day Padded Flat Rate Envelope 2 2.19 lbs $9.10 $7.90 $1.20
225227 2021-05-24 $26.50 Priority Mail 3-Day 1 1.10 lbs $9.34 $16.00 $-6.66
225228 2021-05-24 $11.59 First-Class Mail Stamped Letter 1 0.04 lbs $3.80 $3.12 $0.68
225230 2021-05-24 $38.08 Priority Mail 2-Day 3 1.08 lbs $12.11 $22.02 $-9.91
225233 2021-05-24 $36.02 First-Class Package Service 4 0.42 lbs $5.33 $3.58 $1.75
225234 2021-05-24 $35.39 Priority Mail 3-Day Medium Flat Rate Box 1 2.14 lbs $15.40 $12.64 $2.76
225235 2021-05-24 $19.98 Priority Mail 2-Day Small Flat Rate Box 2 0.20 lbs $9.00 $7.90 $1.10
225237 2021-05-25 $74.72 Priority Mail 2-Day 2 1.86 lbs $10.74 $9.64 $1.10
225238 2021-05-25 $256.61 Priority Mail 2-Day 1 14.05 lbs $26.62 $22.34 $4.28
225240 2021-05-25 $9.79 First-Class Mail Stamped Letter 1 0.07 lbs $3.80 $3.22 $0.58
225241 2021-05-25 $21.99 USPSFirstClass 1 0.30 lbs $6.00 $3.85 $2.15
225242 2021-05-25 $22.16 First-Class Package Service 1 0.49 lbs $6.37 $5.42 $0.95
225243 2021-05-25 $12.59 USPSFirstClass 1 0.15 lbs $4.60 $6.24 $-1.64
225246 2021-05-25 $29.81 Priority Mail 2-Day 1 2.14 lbs $9.82 $8.34 $1.48
225250 2021-05-25 $84.59 First-Class Package Service 2 0.66 lbs $6.61 $5.66 $0.95
225251 2021-05-25 $18.95 First-Class Mail Stamped Letter 5 0.17 lbs $4.00 $3.85 $0.15
225252 2021-05-25 $6.56 First-Class Mail Stamped Letter 4 0.04 lbs $3.60 $3.35 $0.25
225253 2021-05-25 $20.20 First-Class Package Service 2 0.25 lbs $4.89 $3.35 $1.54
225255 2021-05-25 $25.82 First-Class Package Service 1 0.60 lbs $5.33 $4.38 $0.95
225258 2021-05-26 $7.88 First-Class Package Service 1 0.19 lbs $4.89 $3.35 $1.54
225268 2021-05-26 $5.34 USPSFirstClass 1 0.03 lbs $4.35 $6.70 $-2.35
225269 2021-05-26 $46.25 Priority Mail 2-Day 4 1.13 lbs $12.79 $11.69 $1.10
225271 2021-05-26 $27.29 First-Class Package Service - Retail 1 0.60 lbs $6.80 $4.38 $2.42
225272 2021-05-26 $24.94 First-Class Package Service 5 0.22 lbs $4.89 $3.69 $1.20
225276 2020-10-28 $183.55 Priority Mail 1-Day 7 6.15 lbs $9.40 $17.46 $-8.06
225279 2021-05-26 $12.77 First-Class Mail Stamped Letter 3 0.03 lbs $3.80 $3.22 $0.58
225280 2021-05-26 $8.58 First-Class Mail Stamped Letter 2 0.04 lbs $3.60 $3.49 $0.11
225281 2021-05-26 $6.58 First-Class Mail Stamped Letter 2 0.02 lbs $3.60 $3.12 $0.48
225282 2021-05-26 $14.30 First-Class Package Service 1 0.30 lbs $4.78 $3.58 $1.20
225284 2021-05-26 $16.98 Priority Mail 3-Day Small Flat Rate Box 2 0.38 lbs $9.00 $3.49 $5.51
225286 2021-05-26 $55.87 First-Class Package Service 1 0.50 lbs $5.88 $4.68 $1.20
225287 2021-05-26 $55.10 Priority Mail 2-Day 1 1.38 lbs $8.89 $7.79 $1.10
225288 2021-05-26 $17.74 First-Class Mail Stamped Letter 6 0.08 lbs $3.80 $3.22 $0.58
225289 2021-05-26 $27.11 Priority Mail 3-Day 1 1.10 lbs $9.95 $8.85 $1.10
225290 2021-05-27 $49.66 First-Class Package Service 1 0.55 lbs $5.88 $4.68 $1.20
225292 2021-05-27 $9.90 First-Class Mail Stamped Letter 1 0.15 lbs $4.00 $3.35 $0.65
225293 2021-05-27 $6.45 USPSFirstClass 1 0.01 lbs $4.26 $3.06 $1.20
225294 2021-05-27 $14.41 USPSFirstClass 1 0.10 lbs $4.92 $3.49 $1.43
225298 2021-05-27 $55.99 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $9.00 $8.10 $0.90
225300 2021-05-27 $32.73 First-Class Package Service 2 0.55 lbs $5.15 $5.42 $-0.27
225301 2021-05-27 $25.86 First-Class Package Service 2 0.42 lbs $5.58 $3.58 $2.00
225303 2021-05-27 $11.59 First-Class Mail Stamped Letter 1 0.04 lbs $3.80 $3.12 $0.68
225304 2021-05-27 $10.06 USPSFirstClass 1 0.05 lbs $4.48 $3.57 $0.91
225305 2021-05-27 $48.13 First-Class Package Service 3 0.82 lbs $6.76 $11.01 $-4.25
225306 2021-05-27 $14.54 First-Class Package Service 1 0.13 lbs $4.55 $3.35 $1.20
225309 2021-05-28 $51.98 Priority Mail 3-Day Small Flat Rate Box 2 1.25 lbs $9.00 $7.90 $1.10
225310 2021-05-28 $7.71 USPSFirstClass 1 0.06 lbs $4.32 $3.06 $1.26
225311 2021-05-28 $12.38 USPSFirstClass 1 0.06 lbs $4.59 $3.12 $1.47
225315 2021-05-28 $12.38 USPSFirstClass 1 0.06 lbs $4.59 $3.12 $1.47
225316 2021-05-28 $63.96 Priority Mail 2-Day 4 2.35 lbs $15.90 $10.89 $5.01
225317 2021-05-28 $9.69 First-Class Package Service 2 0.20 lbs $4.71 $3.51 $1.20
225319 2021-05-28 $9.33 USPSFirstClass 1 0.03 lbs $4.44 $3.12 $1.32
225320 2021-05-28 $151.15 Priority Mail 2-Day 4 9.81 lbs $21.08 $26.96 $-5.88
225324 2021-05-28 $25.78 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $8.50 $8.00 $0.50
225326 2021-05-28 $22.66 First-Class Package Service 3 0.30 lbs $4.78 $3.58 $1.20
225329 2021-05-28 $41.79 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $9.00 $7.90 $1.10
225330 2021-05-28 $25.91 Priority Mail 3-Day Small Flat Rate Box 1 1.00 lbs $9.00 $7.90 $1.10
225331 2021-05-28 $43.99 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $9.00 $7.90 $1.10
225332 2021-05-28 $35.55 First-Class Package Service 3 0.60 lbs $5.58 $4.38 $1.20
225334 2021-05-29 $31.48 Priority Mail 2-Day Flat Rate Envelope 2 2.30 lbs $8.50 $8.00 $0.50
225335 2021-05-29 $12.63 USPSFirstClass 1 0.06 lbs $4.84 $3.49 $1.35
225336 2021-05-29 $13.68 USPSFirstClass 1 0.05 lbs $4.89 $3.49 $1.40
225337 2021-05-29 $14.73 USPSFirstClass 1 0.17 lbs $4.94 $3.49 $1.45
225338 2021-05-29 $41.79 Priority Mail 3-Day Small Flat Rate Box 1 1.25 lbs $9.00 $7.90 $1.10
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56