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
201316 2017-12-30 $20.76 Priority Mail 2-Day Flat Rate Envelope 4 0.12 lbs $6.80 $5.75 $1.05
201317 2017-12-30 $8.72 First-Class Package Service 11 0.40 lbs $3.82 $2.77 $1.05
201320 2017-12-30 $30.89 First-Class Package Service 2 0.70 lbs $5.15 $4.02 $1.13
201321 2017-12-30 $25.99 Priority Mail 2-Day Flat Rate Envelope 1 1.00 lbs $6.80 $6.25 $0.55
201322 2020-03-19 $105.04 Ground 4 1.40 lbs $21.08 $6.25 $14.83
201323 2017-12-30 $135.84 Priority Mail 3-Day 6 4.66 lbs $10.39 $6.83 $3.56
201324 2017-12-30 $28.19 First-Class Mail Large Envelope 3 0.30 lbs $4.22 $2.77 $1.45
201327 2017-12-31 $10.65 First-Class Package Service 1 0.06 lbs $3.66 $2.61 $1.05
201328 2017-12-31 $38.33 Priority Mail 2-Day Flat Rate Envelope 3 0.90 lbs $6.80 $6.25 $0.55
201329 2017-12-31 $50.68 Priority Mail 3-Day 2 1.20 lbs $9.00 $7.91 $1.09
201330 2017-12-31 $10.64 First-Class Package Service 2 0.04 lbs $3.66 $2.61 $1.05
201331 2017-12-31 $74.57 Priority Mail 2-Day 4 2.47 lbs $8.71 $6.83 $1.88
201333 2018-01-01 $8.61 First-Class Package Service 1 0.45 lbs $3.62 $3.74 $-0.12
201334 2018-01-01 $26.31 First-Class Package Service 10 0.70 lbs $5.01 $4.16 $0.85
201335 2018-01-01 $26.27 Priority Mail 3-Day 3 1.59 lbs $9.00 $7.91 $1.09
201336 2018-01-01 $18.88 First-Class Package Service 2 0.20 lbs $3.82 $2.77 $1.05
201338 2018-01-01 $8.55 First-Class Package Service 1 0.05 lbs $3.66 $2.61 $1.05
201339 2018-01-02 $9.64 First-Class Package Service 2 0.07 lbs $3.66 $2.61 $1.05
201340 2018-01-02 $13.87 First-Class Package International Service 1 0.07 lbs $9.88 $9.03 $0.85
201342 2018-01-02 $161.99 Priority Mail International 1 8.55 lbs $78.68 $71.68 $7.00
201343 2018-01-02 $68.17 First-Class Package International Service 1 2.20 lbs $32.68 $31.83 $0.85
201345 2018-01-02 $43.36 First-Class Package Service 5 0.81 lbs $5.15 $4.30 $0.85
201347 2018-01-02 $26.79 Priority Mail 2-Day Flat Rate Envelope 1 2.00 lbs $6.80 $5.75 $1.05
201349 2018-01-02 $63.08 Priority Mail 2-Day 4 2.50 lbs $11.35 $10.19 $1.16
201351 2018-01-02 $8.60 First-Class Package Service 6 0.06 lbs $3.66 $2.61 $1.05
201352 2018-01-03 $14.41 First-Class Package Service 1 0.37 lbs $3.82 $2.77 $1.05
201353 2018-01-03 $119.94 Priority Mail 2-Day Large Flat Rate Box 6 4.01 lbs $17.90 $10.28 $7.62
201354 2018-01-03 $107.54 Priority Mail 3-Day 2 1.20 lbs $10.84 $9.69 $1.15
201355 2018-01-03 $43.47 First-Class Package International Service 1 0.10 lbs $13.68 $12.83 $0.85
201357 2018-01-03 $14.69 First-Class Package Service 13 0.22 lbs $3.82 $2.77 $1.05
201358 2018-01-03 $99.89 Priority Mail 3-Day 7 3.22 lbs $16.45 $9.99 $6.46
201359 2018-01-03 $19.78 First-Class Package Service 3 0.48 lbs $4.45 $3.46 $0.99
201361 2018-01-03 $36.37 Priority Mail 3-Day 9 2.85 lbs $14.62 $13.36 $1.26
201362 2018-01-03 $24.30 First-Class Package Service 1 0.48 lbs $4.31 $3.46 $0.85
201364 2018-01-04 $214.54 Priority Mail International 31 5.67 lbs $62.91 $58.66 $4.25
201365 2018-01-04 $10.14 First-Class Package Service 2 0.05 lbs $3.66 $2.61 $1.05
201366 2018-01-04 $33.19 Priority Mail 2-Day 9 0.72 lbs $7.68 $6.63 $1.05
201368 2018-01-04 $17.80 First-Class Package Service 2 0.38 lbs $3.82 $2.61 $1.21
201369 2018-01-04 $15.38 First-Class Mail Large Envelope 1 0.30 lbs $3.59 $2.77 $0.82
201370 2018-01-04 $51.89 Priority Mail 2-Day 2 2.03 lbs $8.71 $6.83 $1.88
201373 2018-01-04 $12.14 First-Class Package Service 1 0.15 lbs $3.66 $2.77 $0.89
201375 2018-01-04 $18.80 First-Class Mail Large Envelope 1 0.35 lbs $4.01 $3.74 $0.27
201376 2018-01-04 $7.64 First-Class Package Service 2 0.03 lbs $3.66 $2.61 $1.05
201377 2018-01-04 $10.62 First-Class Package Service 4 0.07 lbs $3.66 $2.61 $1.05
201378 2018-01-04 $56.12 Priority Mail 2-Day 1 0.60 lbs $7.77 $6.71 $1.06
201382 2018-01-05 $116.36 First-Class Package International Service 2 2.85 lbs $47.88 $47.03 $0.85
201384 2018-01-05 $51.72 First-Class Package International Service 1 1.20 lbs $22.23 $21.38 $0.85
201385 2018-01-05 $19.62 First-Class Package Service 4 0.18 lbs $3.66 $2.77 $0.89
201386 2018-01-05 $51.72 First-Class Package International Service 1 1.15 lbs $22.23 $21.38 $0.85
201387 2018-01-05 $51.72 First-Class Package International Service 1 1.15 lbs $22.23 $21.38 $0.85
201388 2018-01-05 $5.64 First-Class Package Service 2 0.03 lbs $3.66 $2.61 $1.05
201389 2018-01-05 $79.96 First-Class Package International Service 2 2.40 lbs $32.68 $47.03 $-14.35
201390 2018-01-05 $76.09 First-Class Package International Service 4 1.52 lbs $22.23 $21.38 $0.85
201391 2018-01-05 $83.46 First-Class Package International Service 2 2.50 lbs $32.68 $47.03 $-14.35
201392 2018-01-05 $98.70 Priority Mail 2-Day 30 1.02 lbs $9.00 $6.25 $2.75
201393 2018-01-05 $38.56 Priority Mail 2-Day 2 1.10 lbs $7.68 $6.83 $0.85
201394 2018-01-05 $81.56 Priority Mail 3-Day Flat Rate Envelope 4 1.50 lbs $6.80 $6.25 $0.55
201395 2018-01-05 $35.74 First-Class Mail Large Envelope 3 0.56 lbs $4.43 $4.16 $0.27
201397 2018-01-06 $170.23 Ground 9 14.04 lbs $31.52 $22.49 $9.03
201398 2018-01-06 $22.11 First-Class Package Service 1 0.25 lbs $3.82 $2.77 $1.05
201399 2018-01-06 $67.17 Priority Mail 2-Day 5 3.20 lbs $14.62 $13.36 $1.26
201400 2018-01-06 $23.26 First-Class Package Service 1 0.90 lbs $4.87 $4.16 $0.71
201401 2018-01-06 $13.82 First-Class Package Service 3 0.75 lbs $5.15 $4.30 $0.85
201402 2018-01-06 $107.37 Priority Mail 2-Day 5 5.70 lbs $23.90 $22.36 $1.54
201404 2018-01-06 $46.67 Priority Mail 3-Day 1 1.60 lbs $7.68 $7.62 $0.06
201405 2018-01-06 $5.65 First-Class Package Service 1 0.03 lbs $3.66 $2.61 $1.05
201408 2018-01-06 $167.48 Ground 5 14.99 lbs $26.53 $23.19 $3.34
201411 2018-01-07 $171.98 Priority Mail International 10 4.50 lbs $58.88 $54.63 $4.25
201412 2018-01-07 $69.52 Priority Mail International 3 0.60 lbs $45.55 $41.33 $4.22
201413 2018-01-07 $68.17 First-Class Package International Service 1 2.20 lbs $32.68 $31.83 $0.85
201414 2018-01-07 $17.48 First-Class Package Service 4 0.36 lbs $3.62 $2.77 $0.85
201415 2018-01-07 $37.09 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $7.30 $6.25 $1.05
201416 2018-01-07 $5.65 First-Class Package Service 1 0.02 lbs $3.66 $2.61 $1.05
201417 2018-01-07 $54.55 Priority Mail 3-Day 3 1.49 lbs $7.68 $6.83 $0.85
201418 2018-01-07 $36.29 Priority Mail 2-Day Flat Rate Envelope 1 1.00 lbs $6.80 $6.25 $0.55
201419 2018-01-07 $21.11 First-Class Package Service 5 0.25 lbs $3.66 $2.61 $1.05
201420 2018-01-07 $33.03 First-Class Package Service 4 0.25 lbs $5.07 $2.77 $2.30
201421 2018-01-07 $26.55 Priority Mail 2-Day 2 1.90 lbs $7.46 $6.41 $1.05
201423 2018-01-08 $43.86 First-Class Package Service 7 0.60 lbs $4.73 $3.46 $1.27
201424 2018-01-08 $13.80 First-Class Package Service 2 0.20 lbs $3.82 $2.77 $1.05
201425 2018-01-08 $20.66 First-Class Package International Service 2 0.30 lbs $13.68 $21.38 $-7.70
201428 2018-01-08 $6.60 First-Class Package Service 6 0.06 lbs $3.66 $2.61 $1.05
201430 2018-01-08 $37.39 Priority Mail 2-Day Medium Flat Rate Box 1 3.55 lbs $13.40 $9.99 $3.41
201432 2018-01-08 $26.80 Priority Mail 2-Day Padded Flat Rate Envelope 5 1.75 lbs $7.35 $9.99 $-2.64
201433 2018-01-08 $16.50 First-Class Mail Large Envelope 1 0.45 lbs $4.01 $3.32 $0.69
201434 2018-01-08 $12.52 First-Class Package Service 1 0.30 lbs $3.82 $3.46 $0.36
201435 2018-01-08 $61.80 Priority Mail 2-Day 4 1.61 lbs $10.04 $8.91 $1.13
201437 2018-01-08 $25.72 Priority Mail 2-Day 8 1.52 lbs $9.00 $7.91 $1.09
201438 2018-01-08 $21.04 First-Class Package Service 2 0.12 lbs $3.66 $2.77 $0.89
201439 2018-01-08 $24.91 First-Class Package Service 2 0.70 lbs $4.93 $4.16 $0.77
201440 2018-01-08 $16.79 Priority Mail 2-Day Small Flat Rate Box 1 0.05 lbs $7.30 $6.25 $1.05
201441 2018-01-08 $50.71 Priority Mail 1-Day Small Flat Rate Box 8 1.51 lbs $7.30 $6.25 $1.05
201444 2018-01-09 $51.72 First-Class Package International Service 1 1.20 lbs $22.23 $21.38 $0.85
201445 2018-01-09 $194.96 Priority Mail International 1 12.90 lbs $96.97 $89.97 $7.00
201446 2018-01-09 $270.71 Priority Mail International Large Flat Rate Box 26 16.07 lbs $86.85 $86.93 $-0.08
201447 2018-01-09 $85.75 Ground 3 2.00 lbs $23.78 $22.57 $1.21
201448 2018-01-09 $15.38 First-Class Mail Large Envelope 1 0.30 lbs $3.59 $2.77 $0.82
201450 2018-01-09 $38.94 First-Class Package Service 2 0.60 lbs $4.79 $4.30 $0.49
201451 2018-01-09 $129.73 Priority Mail International 1 5.65 lbs $62.44 $61.56 $0.88
201452 2018-01-09 $194.96 Priority Mail International 1 12.90 lbs $96.97 $89.97 $7.00
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56