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
223302 2021-03-14 $7.18 USPSFirstClass 1 0.10 lbs $4.29 $3.06 $1.23
223304 2021-03-14 $20.34 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.15 lbs $8.85 $8.00 $0.85
223307 2021-03-14 $13.18 Priority Mail 3-Day 1 0.05 lbs $9.19 $7.40 $1.79
223308 2021-03-14 $7.18 USPSFirstClass 1 0.10 lbs $4.29 $3.06 $1.23
223311 2021-03-14 $6.49 First-Class Mail Stamped Letter 1 0.03 lbs $3.00 $3.06 $-0.06
223312 2021-03-14 $8.45 First-Class Mail Stamped Letter 1 0.07 lbs $3.20 $3.12 $0.08
223313 2021-03-14 $11.09 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.06 $0.14
223314 2021-03-15 $12.63 USPSFirstClass 1 0.06 lbs $4.84 $3.49 $1.35
223315 2021-03-15 $40.24 USPSFirstClass 4 1.54 lbs $17.08 $8.24 $8.84
223316 2021-03-15 $7.96 USPSFirstClass 1 0.03 lbs $4.47 $3.35 $1.12
223317 2021-03-15 $14.94 USPSFirstClass 3 0.09 lbs $4.47 $3.35 $1.12
223318 2021-03-15 $8.16 USPSMedia 1 0.25 lbs $3.14 $2.89 $0.25
223322 2020-11-26 $41.58 Priority Mail 3-Day Medium Flat Rate Box 2 1.65 lbs $10.00 $8.00 $2.00
223325 2021-03-15 $75.15 Priority Mail 2-Day Flat Rate Envelope 2 3.75 lbs $8.25 $8.00 $0.25
223329 2021-03-15 $34.49 USPSPriority 1 2.30 lbs $14.50 $22.65 $-8.15
223330 2021-03-15 $8.19 First-Class Mail Stamped Letter 1 0.04 lbs $3.20 $3.49 $-0.29
223331 2021-03-15 $44.69 Priority Mail 3-Day 1 1.10 lbs $9.70 $8.85 $0.85
223334 2021-03-15 $69.55 Ground 3 6.71 lbs $16.81 $20.15 $-3.34
223335 2021-03-15 $9.69 First-Class Package Service 1 0.45 lbs $4.70 $4.20 $0.50
223336 2021-03-15 $87.70 Ground 2 0.98 lbs $28.12 $21.93 $6.19
223339 2021-03-15 $58.27 First-Class Package Service 2 0.80 lbs $6.23 $5.98 $0.25
223340 2021-03-15 $36.30 Priority Mail 3-Day Flat Rate Envelope 2 1.30 lbs $8.25 $7.90 $0.35
223341 2021-03-15 $7.39 First-Class Mail Stamped Letter 1 0.11 lbs $3.40 $3.22 $0.18
223342 2021-03-15 $144.21 Ground 28 11.20 lbs $46.49 $41.33 $5.16
223346 2021-03-15 $15.55 First-Class Mail Stamped Letter 2 0.18 lbs $3.60 $3.01 $0.59
223347 2021-03-16 $92.48 Priority Mail 2-Day Medium Flat Rate Box 2 19.00 lbs $15.00 $13.75 $1.25
223348 2021-03-16 $11.09 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.49 $-0.29
223349 2021-03-16 $8.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.49 $-0.29
223350 2021-03-16 $9.64 First-Class Package Service 1 0.31 lbs $4.35 $3.85 $0.50
223351 2021-03-16 $32.15 USPSFirstClass 3 1.16 lbs $14.78 $11.01 $3.77
223352 2021-03-16 $7.34 USPSFirstClass 1 0.10 lbs $4.35 $3.12 $1.23
223353 2021-03-16 $6.43 USPSFirstClass 1 0.01 lbs $4.54 $3.49 $1.05
223354 2021-03-16 $11.03 USPSFirstClass 1 0.39 lbs $5.24 $4.20 $1.04
223356 2021-03-16 $12.43 USPSFirstClass 1 0.06 lbs $4.64 $3.22 $1.42
223357 2021-03-16 $4.99 First-Class Mail Stamped Letter 1 0.01 lbs $3.00 $3.12 $-0.12
223358 2021-03-16 $8.19 First-Class Mail Stamped Letter 1 0.10 lbs $3.40 $3.12 $0.28
223359 2021-02-22 $15.12 First-Class Package Service 3 0.33 lbs $4.35 $3.85 $0.50
223360 2021-03-16 $14.64 USPSFirstClass 1 0.50 lbs $5.65 $5.98 $-0.33
223361 2021-03-16 $18.69 First-Class Package Service 3 0.24 lbs $4.01 $3.06 $0.95
223362 2021-03-16 $7.76 USPSFirstClass 1 0.07 lbs $4.37 $3.12 $1.25
223363 2021-03-16 $37.84 Priority Mail Express 2-Day 1 0.03 lbs $34.85 $34.00 $0.85
223366 2021-03-16 $14.39 USPSFirstClass 1 0.31 lbs $5.40 $4.20 $1.20
223367 2021-03-16 $8.98 First-Class Package Service 1 0.04 lbs $3.99 $3.49 $0.50
223368 2021-03-16 $13.79 First-Class Mail Stamped Letter 1 0.14 lbs $3.40 $3.06 $0.34
223370 2021-03-16 $42.14 Priority Mail 3-Day 6 1.25 lbs $9.70 $8.85 $0.85
223371 2021-03-16 $136.98 Priority Mail 2-Day Medium Flat Rate Box 2 13.59 lbs $15.00 $10.97 $4.03
223372 2021-03-16 $19.36 USPSFirstClass 3 0.14 lbs $4.69 $3.85 $0.84
223375 2021-03-16 $14.28 First-Class Package Service 1 0.30 lbs $4.07 $3.57 $0.50
223376 2021-03-16 $17.00 First-Class Package Service 1 0.29 lbs $4.01 $3.51 $0.50
223377 2021-03-16 $34.16 Priority Mail 3-Day 4 0.98 lbs $9.70 $8.85 $0.85
223378 2021-03-16 $54.87 First-Class Package Service 1 0.50 lbs $4.88 $4.38 $0.50
223379 2021-03-16 $9.87 First-Class Package Service 1 0.40 lbs $4.88 $3.58 $1.30
223381 2021-03-16 $23.72 Priority Mail 2-Day Small Flat Rate Box 3 0.17 lbs $8.75 $7.90 $0.85
223383 2021-03-16 $13.23 Priority Mail 2-Day Flat Rate Envelope 2 0.08 lbs $8.25 $7.90 $0.35
223384 2021-03-16 $26.17 First-Class Package Service 1 0.40 lbs $5.18 $4.68 $0.50
223385 2021-03-16 $93.94 Priority Mail 3-Day 1 2.50 lbs $14.95 $11.63 $3.32
223387 2021-03-17 $12.39 First-Class Mail Stamped Letter 1 0.11 lbs $3.40 $3.58 $-0.18
223389 2021-03-17 $9.58 First-Class Mail Stamped Letter 2 0.03 lbs $3.20 $3.22 $-0.02
223390 2021-03-17 $37.62 UPSGround 1 0.69 lbs $12.63 $19.15 $-6.52
223391 2021-03-17 $14.39 USPSFirstClass 1 0.50 lbs $5.40 $4.20 $1.20
223392 2021-03-17 $14.82 USPSFirstClass 3 0.60 lbs $5.85 $4.38 $1.47
223394 2021-03-17 $21.49 First-Class Package Service 2 0.20 lbs $4.35 $3.85 $0.50
223395 2021-03-17 $6.34 USPSFirstClass 1 0.08 lbs $4.35 $3.22 $1.13
223396 2021-03-17 $6.49 First-Class Mail Stamped Letter 1 0.04 lbs $3.00 $3.06 $-0.06
223397 2021-03-17 $6.29 USPSFirstClass 1 0.08 lbs $4.30 $3.12 $1.18
223400 2021-03-17 $8.11 USPSFirstClass 1 0.03 lbs $4.62 $3.49 $1.13
223401 2021-03-17 $19.51 USPSFirstClass 2 0.16 lbs $4.57 $4.20 $0.37
223402 2021-03-17 $84.99 Priority Mail 3-Day Medium Flat Rate Box 1 5.30 lbs $15.00 $13.75 $1.25
223403 2021-03-17 $68.77 USPSFirstClass 10 0.81 lbs $11.87 $8.85 $3.02
223404 2021-03-17 $42.40 Priority Mail 2-Day 9 1.59 lbs $10.49 $8.85 $1.64
223406 2021-03-17 $38.80 UPSGround 1 0.69 lbs $13.81 $21.93 $-8.12
223408 2021-03-18 $6.62 First-Class Package Service 1 0.29 lbs $4.63 $3.58 $1.05
223409 2021-03-18 $28.80 Priority Mail 2-Day Padded Flat Rate Envelope 5 0.75 lbs $8.85 $7.90 $0.95
223410 2021-03-18 $75.99 Priority Mail 2-Day Medium Flat Rate Box 5 21.95 lbs $14.00 $13.75 $0.25
223411 2021-03-18 $37.37 Priority Mail 2-Day 6 1.29 lbs $9.70 $8.85 $0.85
223412 2021-03-18 $13.06 First-Class Package Service 13 0.17 lbs $4.19 $3.72 $0.47
223413 2021-03-18 $7.81 USPSFirstClass 1 0.07 lbs $4.42 $3.22 $1.20
223414 2021-03-18 $13.09 USPSFirstClass 2 0.07 lbs $8.81 $3.69 $5.12
223415 2021-03-18 $8.16 USPSMedia 1 0.23 lbs $3.14 $2.89 $0.25
223416 2021-03-18 $9.49 USPSFirstClass 2 0.40 lbs $5.11 $3.58 $1.53
223417 2021-03-18 $12.63 USPSFirstClass 1 0.06 lbs $4.84 $3.49 $1.35
223418 2021-03-18 $14.07 First-Class Package Service 1 0.19 lbs $4.08 $3.22 $0.86
223419 2021-03-18 $68.14 Priority Mail 2-Day Large Flat Rate Box 1 25.05 lbs $20.15 $13.75 $6.40
223420 2021-03-18 $28.50 Priority Mail 2-Day 4 0.81 lbs $12.54 $11.69 $0.85
223421 2021-03-18 $76.92 Priority Mail 3-Day Flat Rate Envelope 3 4.97 lbs $8.25 $8.00 $0.25
223424 2021-03-18 $39.55 Priority Mail 2-Day 2 1.85 lbs $9.57 $8.72 $0.85
223426 2021-03-18 $0.49 USPSFirstClass 1 0.01 lbs $0.00 $3.06 $-3.06
223427 2021-03-18 $47.04 Priority Mail 3-Day 7 1.54 lbs $17.30 $11.69 $5.61
223429 2021-03-18 $43.51 Priority Mail 3-Day 1 0.27 lbs $8.52 $7.67 $0.85
223431 2021-03-18 $3.06 USPSFirstClass 4 0.04 lbs $0.00 $3.06 $-3.06
223432 2021-03-18 $11.34 First-Class Package Service - Retail 1 0.10 lbs $5.05 $3.12 $1.93
223433 2021-03-18 $15.52 First-Class Package Service 4 0.14 lbs $3.56 $3.06 $0.50
223434 2021-03-18 $8.11 USPSFirstClass 1 0.03 lbs $4.62 $3.49 $1.13
223435 2021-03-18 $67.42 Ground 5 1.72 lbs $23.67 $21.22 $2.45
223437 2021-03-18 $52.83 Priority Mail 2-Day Padded Flat Rate Envelope 2 1.80 lbs $8.85 $8.00 $0.85
223439 2021-03-18 $36.34 First-Class Package Service 1 0.31 lbs $4.35 $3.85 $0.50
223440 2021-03-18 $41.54 Priority Mail 3-Day Small Flat Rate Box 1 1.00 lbs $8.75 $7.90 $0.85
223445 2021-03-19 $55.02 First-Class Package Service 1 0.56 lbs $5.03 $4.53 $0.50
223446 2021-03-19 $26.49 First-Class Package Service 4 0.50 lbs $5.03 $4.53 $0.50
223447 2021-03-19 $4.49 First-Class Mail Stamped Letter 1 0.01 lbs $3.00 $3.49 $-0.49
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56