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
224355 2021-04-20 $12.33 USPSFirstClass 1 0.06 lbs $4.54 $3.06 $1.48
224356 2021-04-20 $31.22 Priority Mail 2-Day Small Flat Rate Box 3 0.40 lbs $8.75 $7.90 $0.85
224359 2021-04-20 $43.88 First-Class Package Service 1 0.75 lbs $5.77 $4.12 $1.65
224360 2021-04-21 $22.02 First-Class Package Service 1 0.49 lbs $6.23 $5.98 $0.25
224361 2021-04-21 $50.25 Priority Mail 2-Day 5 1.21 lbs $11.86 $11.01 $0.85
224362 2021-04-21 $16.58 USPSFirstClass 1 0.10 lbs $4.79 $3.57 $1.22
224363 2021-04-21 $12.48 USPSFirstClass 1 0.06 lbs $4.69 $3.35 $1.34
224364 2021-04-21 $47.20 Priority Mail 3-Day 4 1.60 lbs $9.70 $9.64 $0.06
224365 2021-04-21 $112.62 Ground 2 2.14 lbs $26.83 $24.28 $2.55
224367 2021-04-21 $10.33 USPSFirstClass 1 0.35 lbs $5.44 $4.68 $0.76
224368 2021-04-21 $22.82 First-Class Package Service 1 0.65 lbs $6.06 $4.53 $1.53
224369 2021-04-21 $21.24 Priority Mail 2-Day Flat Rate Envelope 1 0.05 lbs $8.25 $7.90 $0.35
224370 2021-04-21 $11.24 Priority Mail 2-Day Flat Rate Envelope 1 0.02 lbs $8.25 $7.40 $0.85
224371 2021-04-21 $34.68 First-Class Mail Stamped Letter 2 0.07 lbs $3.20 $3.22 $-0.02
224372 2021-04-21 $14.06 First-Class Package Service 2 0.38 lbs $4.08 $3.22 $0.86
224373 2021-04-21 $14.33 USPSFirstClass 4 0.04 lbs $4.37 $3.22 $1.15
224374 2021-04-21 $20.34 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.15 lbs $8.85 $7.90 $0.95
224375 2021-04-21 $30.84 First-Class Package International Service 1 0.15 lbs $25.09 $17.34 $7.75
224376 2021-04-21 $36.59 Priority Mail 2-Day Flat Rate Envelope 4 0.25 lbs $8.25 $7.90 $0.35
224377 2021-04-21 $14.56 USPSFirstClass 1 0.10 lbs $4.79 $3.69 $1.10
224378 2021-04-21 $86.85 Priority Mail 3-Day Padded Flat Rate Envelope 1 2.10 lbs $8.85 $8.00 $0.85
224379 2021-04-21 $23.28 Priority Mail 2-Day Flat Rate Envelope 1 0.15 lbs $8.25 $7.90 $0.35
224380 2021-04-21 $19.57 First-Class Package Service 5 0.15 lbs $3.72 $3.58 $0.14
224381 2021-04-22 $18.21 Priority Mail 2-Day Small Flat Rate Box 4 0.13 lbs $8.75 $7.90 $0.85
224382 2021-04-22 $11.24 Priority Mail 3-Day Flat Rate Envelope 1 0.02 lbs $8.25 $7.90 $0.35
224384 2021-04-22 $40.94 Priority Mail 3-Day 1 2.40 lbs $14.95 $14.10 $0.85
224385 2021-04-22 $5.29 USPSFirstClass 1 0.01 lbs $4.30 $3.22 $1.08
224386 2021-04-22 $14.71 USPSFirstClass 1 0.10 lbs $4.94 $3.85 $1.09
224387 2021-04-22 $12.63 USPSFirstClass 1 0.06 lbs $4.84 $3.49 $1.35
224388 2021-04-22 $7.39 USPSFirstClass 1 0.10 lbs $4.40 $3.22 $1.18
224389 2021-04-22 $16.04 Priority Mail 3-Day Flat Rate Envelope 1 0.06 lbs $8.25 $7.90 $0.35
224390 2021-04-22 $56.89 USPSFirstClass 7 2.45 lbs $22.66 $8.72 $13.94
224391 2021-04-22 $10.18 First-Class Mail Stamped Letter 2 0.10 lbs $3.20 $3.22 $-0.02
224392 2021-04-22 $28.86 Priority Mail 2-Day 1 0.60 lbs $9.37 $8.52 $0.85
224393 2021-04-22 $13.19 First-Class Mail Stamped Letter 1 0.08 lbs $3.20 $3.35 $-0.15
224394 2021-04-22 $7.08 USPSFirstClass 1 0.06 lbs $4.29 $3.06 $1.23
224395 2021-04-22 $18.18 First-Class Package Service 1 0.28 lbs $4.39 $3.69 $0.70
224396 2021-04-22 $42.82 Priority Mail 2-Day Small Flat Rate Box 2 1.45 lbs $8.80 $8.85 $-0.05
224397 2021-04-22 $28.09 First-Class Package Service 2 0.90 lbs $6.51 $5.81 $0.70
224398 2021-04-22 $33.62 First-Class Package Service 1 0.20 lbs $4.65 $3.85 $0.80
224403 2021-04-22 $21.84 First-Class Package Service 1 0.60 lbs $5.08 $5.81 $-0.73
224404 2021-04-22 $21.07 First-Class Package Service 1 0.40 lbs $5.18 $4.38 $0.80
224405 2021-04-22 $25.61 Priority Mail 2-Day Small Flat Rate Box 1 1.00 lbs $8.90 $7.90 $1.00
224407 2021-04-23 $51.89 Priority Mail 3-Day Small Flat Rate Box 1 1.50 lbs $8.90 $8.25 $0.65
224408 2021-04-23 $257.82 Priority Mail 2-Day Medium Flat Rate Box 2 16.00 lbs $15.20 $11.42 $3.78
224410 2021-04-23 $20.92 First-Class Package Service 1 0.40 lbs $4.93 $4.38 $0.55
224411 2021-04-23 $14.27 First-Class Mail Stamped Letter 3 0.15 lbs $3.80 $3.06 $0.74
224412 2021-04-23 $10.85 USPSFirstClass 1 0.08 lbs $4.56 $3.22 $1.34
224416 2021-04-23 $37.89 USPSFirstClass 1 0.89 lbs $9.90 $8.85 $1.05
224417 2021-04-23 $35.25 First-Class Package Service 3 0.39 lbs $5.28 $4.53 $0.75
224419 2021-04-23 $64.03 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.80 lbs $9.00 $8.00 $1.00
224420 2021-04-23 $11.31 USPSFirstClass 1 0.05 lbs $4.54 $3.12 $1.42
224424 2021-04-23 $39.56 First-Class Package Service 1 0.27 lbs $4.57 $3.57 $1.00
224426 2021-04-23 $15.49 First-Class Package Service 2 0.20 lbs $4.51 $3.06 $1.45
224429 2021-04-23 $29.71 Priority Mail 2-Day 3 0.21 lbs $9.34 $8.34 $1.00
224430 2021-04-24 $17.47 First-Class Package Service 1 0.30 lbs $4.58 $3.58 $1.00
224432 2021-04-24 $6.99 USPSFirstClass 1 0.02 lbs $2.35 $3.49 $-1.14
224437 2021-04-24 $13.09 First-Class Package Service - Retail 1 0.04 lbs $5.30 $3.35 $1.95
224438 2021-04-24 $10.58 First-Class Mail Stamped Letter 2 0.10 lbs $3.60 $3.12 $0.48
224440 2021-04-24 $81.42 Priority Mail 2-Day 1 2.85 lbs $11.43 $9.01 $2.42
224441 2021-04-24 $15.55 First-Class Package Service 1 0.25 lbs $4.57 $3.12 $1.45
224442 2021-04-24 $26.40 Priority Mail 1-Day 1 0.95 lbs $8.79 $7.16 $1.63
224443 2021-04-24 $18.30 Priority Mail 2-Day 4 0.06 lbs $9.34 $7.90 $1.44
224444 2021-04-24 $21.59 First-Class Package Service 2 0.60 lbs $6.41 $5.66 $0.75
224445 2021-04-24 $11.39 First-Class Mail Stamped Letter 1 0.04 lbs $3.60 $3.12 $0.48
224446 2021-04-24 $11.57 First-Class Mail Stamped Letter 1 0.06 lbs $3.60 $3.01 $0.59
224447 2021-04-24 $19.18 First-Class Mail Stamped Letter 2 0.08 lbs $3.60 $3.06 $0.54
224449 2021-04-24 $14.19 First-Class Mail Stamped Letter 1 0.14 lbs $3.80 $3.06 $0.74
224450 2021-04-25 $89.44 Priority Mail 2-Day 20 2.03 lbs $10.64 $9.64 $1.00
224451 2021-04-25 $14.56 USPSFirstClass 1 0.10 lbs $4.79 $3.35 $1.44
224452 2021-04-25 $9.58 USPSFirstClass 1 0.05 lbs $4.69 $3.49 $1.20
224453 2021-04-25 $9.87 USPSFirstClass 2 0.12 lbs $4.29 $3.06 $1.23
224454 2021-04-25 $15.51 First-Class Package Service 2 0.40 lbs $5.53 $3.69 $1.84
224456 2021-04-25 $183.45 FedExHomeDelivery 1 30.00 lbs $39.84 $30.35 $9.49
224457 2021-04-25 $23.36 First-Class Package Service 1 0.25 lbs $4.57 $3.57 $1.00
224459 2021-04-25 $18.14 First-Class Package Service 17 0.22 lbs $4.51 $3.06 $1.45
224460 2021-04-25 $14.69 Priority Mail 3-Day Flat Rate Envelope 1 0.07 lbs $8.40 $7.70 $0.70
224463 2021-04-25 $11.48 First-Class Package Service 1 0.06 lbs $4.49 $3.49 $1.00
224464 2021-04-25 $30.53 USPSFirstClass 1 0.90 lbs $9.83 $5.66 $4.17
224466 2021-04-25 $11.39 First-Class Mail Stamped Letter 1 0.06 lbs $3.60 $3.49 $0.11
224469 2021-04-26 $46.68 First-Class Package Service 2 0.60 lbs $5.20 $5.42 $-0.22
224470 2021-04-26 $35.79 Priority Mail 2-Day Flat Rate Envelope 1 1.29 lbs $8.40 $7.90 $0.50
224471 2021-04-26 $62.34 Priority Mail 2-Day 2 1.02 lbs $12.01 $11.01 $1.00
224472 2021-04-26 $12.33 USPSFirstClass 2 0.10 lbs $4.35 $3.06 $1.29
224474 2021-04-26 $12.38 USPSFirstClass 1 0.03 lbs $4.59 $3.12 $1.47
224476 2021-04-26 $44.06 Ground 4 0.30 lbs $20.29 $15.59 $4.70
224478 2021-04-26 $19.56 First-Class Package Service 1 0.24 lbs $4.57 $3.57 $1.00
224479 2021-04-26 $129.30 Priority Mail 2-Day 3 2.96 lbs $11.53 $9.01 $2.52
224480 2021-04-26 $14.92 First-Class Package Service 1 0.30 lbs $4.71 $3.51 $1.20
224481 2021-04-27 $71.47 Priority Mail 3-Day 3 0.60 lbs $9.34 $7.67 $1.67
224482 2021-04-27 $10.79 First-Class Mail Stamped Letter 1 0.09 lbs $4.00 $3.49 $0.51
224483 2021-04-27 $11.78 First-Class Mail Stamped Letter 2 0.08 lbs $3.80 $3.49 $0.31
224484 2021-04-27 $31.90 First-Class Package Service 5 0.22 lbs $5.05 $3.85 $1.20
224485 2021-04-27 $14.33 USPSFirstClass 4 0.04 lbs $4.37 $3.22 $1.15
224488 2021-04-27 $718.67 Ground Home Delivery 1 53.00 lbs $112.03 $91.58 $20.45
224489 2021-04-27 $14.98 Priority Mail 2-Day Flat Rate Envelope 2 0.15 lbs $8.50 $8.00 $0.50
224490 2021-04-27 $9.79 First-Class Mail Stamped Letter 1 0.05 lbs $3.80 $3.12 $0.68
224491 2021-04-27 $16.52 First-Class Package Service 1 0.45 lbs $5.73 $3.69 $2.04
224492 2021-04-27 $23.49 Priority Mail 3-Day Flat Rate Envelope 1 0.80 lbs $8.50 $8.00 $0.50
224493 2021-04-27 $67.61 Priority Mail 2-Day 1 2.06 lbs $9.82 $8.34 $1.48
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56