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
223449 2021-03-19 $19.17 Priority Mail 3-Day 2 0.68 lbs $9.19 $10.44 $-1.25
223450 2021-03-19 $16.95 First-Class Package Service 2 0.34 lbs $4.07 $4.20 $-0.13
223452 2021-03-19 $50.88 USPSFirstClass 2 0.28 lbs $10.90 $3.85 $7.05
223454 2021-03-19 $7.81 USPSFirstClass 1 0.03 lbs $4.32 $3.06 $1.26
223455 2021-03-19 $44.00 UPSGround 1 0.50 lbs $14.23 $21.61 $-7.38
223457 2021-03-19 $0.98 Priority Mail 2-Day 2 0.02 lbs $0.00 $3.49 $-3.49
223458 2021-03-19 $8.50 USPSFirstClass 1 0.01 lbs $4.45 $3.22 $1.23
223459 2021-03-19 $0.49 USPSFirstClass 1 0.01 lbs $0.00 $3.35 $-3.35
223460 2021-03-19 $0.49 USPSFirstClass 1 0.01 lbs $0.00 $3.49 $-3.49
223461 2021-03-19 $0.98 First-Class Package Service 2 0.02 lbs $0.00 $3.49 $-3.49
223462 2021-03-19 $0.49 USPSFirstClass 1 0.01 lbs $0.00 $3.12 $-3.12
223463 2021-03-19 $0.49 USPSFirstClass 1 0.01 lbs $0.00 $3.35 $-3.35
223464 2021-03-19 $0.49 First-Class Mail Stamped Letter 1 0.01 lbs $0.00 $3.06 $-3.06
223465 2021-03-19 $0.49 USPSFirstClass 1 0.01 lbs $0.00 $3.35 $-3.35
223466 2021-03-19 $1.96 USPSFirstClass 4 0.04 lbs $0.00 $3.35 $-3.35
223467 2021-03-19 $0.49 USPSFirstClass 1 0.01 lbs $0.00 $3.35 $-3.35
223468 2021-03-19 $0.49 USPSFirstClass 1 0.01 lbs $0.00 $3.22 $-3.22
223469 2021-03-19 $0.98 USPSFirstClass 2 0.02 lbs $0.00 $3.01 $-3.01
223470 2021-03-19 $0.49 USPSFirstClass 1 0.01 lbs $0.00 $3.01 $-3.01
223471 2021-03-19 $57.11 Priority Mail 2-Day 4 3.00 lbs $15.65 $22.70 $-7.05
223473 2021-03-19 $31.73 Priority Mail 3-Day 1 1.78 lbs $10.49 $8.00 $2.49
223474 2021-03-19 $7.19 First-Class Mail Stamped Letter 1 0.10 lbs $3.20 $3.49 $-0.29
223475 2021-03-19 $25.86 Ground 1 0.05 lbs $17.97 $14.55 $3.42
223476 2021-03-19 $15.87 USPSFirstClass 2 0.70 lbs $6.09 $5.81 $0.28
223477 2021-03-19 $65.98 Priority Mail 3-Day Medium Flat Rate Box 2 4.41 lbs $15.00 $7.90 $7.10
223479 2021-03-19 $10.78 First-Class Package Service 1 0.09 lbs $3.99 $3.49 $0.50
223480 2021-03-20 $35.02 First-Class Package Service 1 0.60 lbs $5.03 $5.81 $-0.78
223482 2021-03-20 $16.14 Priority Mail 3-Day Flat Rate Envelope 1 0.05 lbs $8.25 $7.90 $0.35
223483 2021-03-20 $12.43 USPSFirstClass 1 0.06 lbs $4.64 $3.22 $1.42
223484 2021-03-20 $7.29 USPSFirstClass 1 0.10 lbs $4.30 $3.06 $1.24
223485 2021-03-20 $66.44 USPSPriority 1 4.11 lbs $28.45 $20.99 $7.46
223486 2021-03-20 $7.14 USPSFirstClass 1 0.02 lbs $4.15 $3.01 $1.14
223488 2021-03-20 $7.39 First-Class Mail Stamped Letter 1 0.15 lbs $3.40 $3.58 $-0.18
223489 2021-03-20 $34.85 Priority Mail 2-Day 1 0.85 lbs $11.86 $8.52 $3.34
223490 2021-03-20 $45.28 Priority Mail 2-Day 1 1.40 lbs $11.29 $10.89 $0.40
223491 2021-03-20 $12.14 USPSFirstClass 1 0.08 lbs $4.67 $3.69 $0.98
223492 2021-03-20 $18.28 USPSFirstClass 1 0.17 lbs $4.97 $3.69 $1.28
223496 2021-03-20 $29.89 Ground 1 0.08 lbs $23.60 $20.10 $3.50
223498 2021-03-20 $103.28 Priority Mail 2-Day 36 7.20 lbs $24.44 $21.48 $2.96
223499 2021-03-20 $14.48 USPSFirstClass 1 0.17 lbs $4.69 $3.57 $1.12
223500 2021-03-20 $10.33 USPSFirstClass 2 0.06 lbs $4.35 $3.12 $1.23
223501 2021-03-20 $138.68 Priority Mail 3-Day Medium Flat Rate Box 4 14.00 lbs $15.00 $13.75 $1.25
223502 2021-03-20 $16.43 First-Class Package Service 2 0.39 lbs $6.23 $3.85 $2.38
223505 2021-03-20 $48.86 Ground 1 0.90 lbs $31.58 $31.58 $0.00
223506 2021-03-20 $9.38 First-Class Mail Stamped Letter 2 0.10 lbs $3.40 $3.35 $0.05
223507 2021-03-21 $12.54 USPSFirstClass 1 0.05 lbs $4.55 $3.06 $1.49
223509 2021-03-20 $83.24 Priority Mail 2-Day Flat Rate Envelope 1 1.15 lbs $8.25 $8.00 $0.25
223516 2021-03-21 $30.81 First-Class Package Service 2 0.50 lbs $5.03 $5.81 $-0.78
223517 2021-03-21 $7.99 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.49 $-0.29
223519 2021-03-21 $14.94 USPSFirstClass 2 0.17 lbs $4.56 $3.69 $0.87
223520 2021-03-21 $39.64 USPSFirstClass 4 1.36 lbs $12.08 $10.89 $1.19
223521 2021-03-21 $17.36 First-Class Mail Stamped Letter 4 0.16 lbs $3.40 $3.49 $-0.09
223523 2021-03-21 $76.99 Priority Mail 2-Day Medium Flat Rate Box 1 4.39 lbs $15.00 $8.00 $7.00
223524 2021-03-21 $7.19 First-Class Mail Stamped Letter 1 0.07 lbs $3.20 $3.12 $0.08
223525 2021-03-21 $34.58 USPSMedia 1 3.15 lbs $6.00 $4.57 $1.43
223528 2021-03-21 $20.18 First-Class Package Service 2 0.48 lbs $4.70 $4.20 $0.50
223530 2021-03-21 $6.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.49 $-0.29
223531 2021-03-21 $30.94 Priority Mail 2-Day Small Flat Rate Box 1 0.45 lbs $8.75 $8.25 $0.50
223532 2021-03-21 $5.30 First-Class Mail Stamped Letter 1 0.01 lbs $3.00 $3.46 $-0.46
223533 2021-03-21 $8.47 First-Class Package Service 1 0.08 lbs $3.72 $3.22 $0.50
223535 2021-03-21 $19.96 First-Class Package Service 1 0.45 lbs $5.18 $4.68 $0.50
223536 2021-03-21 $40.69 First-Class Package Service 1 0.60 lbs $4.70 $4.20 $0.50
223538 2021-03-21 $14.38 First-Class Package Service - Retail 2 0.10 lbs $5.10 $3.22 $1.88
223539 2021-03-21 $15.80 First-Class Package Service 1 0.29 lbs $4.01 $3.06 $0.95
223540 2021-03-21 $9.76 First-Class Package Service 2 0.40 lbs $4.78 $4.53 $0.25
223541 2021-03-22 $88.56 Priority Mail 3-Day 1 2.50 lbs $9.57 $8.34 $1.23
223542 2021-03-22 $60.95 Priority Mail 3-Day 4 1.33 lbs $11.86 $11.01 $0.85
223543 2021-03-22 $57.55 Priority Mail 2-Day 6 3.00 lbs $19.81 $18.96 $0.85
223544 2021-03-22 $11.64 USPSFirstClass 1 0.06 lbs $4.65 $3.35 $1.30
223545 2021-03-22 $177.85 Priority Mail 3-Day 4 4.22 lbs $12.55 $11.70 $0.85
223546 2021-03-22 $38.04 Priority Mail 2-Day 13 2.47 lbs $9.57 $8.24 $1.33
223550 2021-03-22 $32.08 Priority Mail 2-Day 1 0.85 lbs $9.09 $7.67 $1.42
223553 2021-03-22 $13.79 First-Class Mail Stamped Letter 1 0.14 lbs $3.40 $3.49 $-0.09
223555 2021-03-22 $36.73 UPSGround 1 0.69 lbs $11.74 $9.46 $2.28
223558 2021-03-22 $12.18 USPSFirstClass 1 0.34 lbs $5.29 $3.57 $1.72
223559 2021-03-22 $16.84 USPSFirstClass 1 0.20 lbs $4.85 $3.58 $1.27
223560 2021-03-22 $4.45 First-Class Package Service 5 0.06 lbs $0.00 $7.90 $-7.90
223562 2021-03-22 $7.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.12 $0.08
223565 2021-03-22 $23.06 First-Class Package Service 2 0.36 lbs $4.08 $3.58 $0.50
223567 2021-03-22 $9.09 First-Class Package Service 10 0.20 lbs $4.19 $3.69 $0.50
223569 2021-03-22 $13.94 First-Class Package Service 5 0.09 lbs $3.99 $3.49 $0.50
223570 2021-03-22 $8.84 First-Class Package Service 1 0.20 lbs $3.82 $3.12 $0.70
223572 2021-03-22 $19.96 First-Class Package Service 1 0.12 lbs $3.56 $3.06 $0.50
223575 2021-03-23 $15.57 First-Class Mail Stamped Letter 3 0.18 lbs $3.60 $3.22 $0.38
223576 2021-03-23 $22.45 First-Class Mail Stamped Letter 5 0.04 lbs $3.20 $3.12 $0.08
223578 2021-03-23 $14.56 USPSFirstClass 2 0.22 lbs $8.88 $3.69 $5.19
223579 2021-03-23 $12.23 USPSFirstClass 1 0.30 lbs $5.34 $3.58 $1.76
223581 2021-03-23 $22.32 Priority Mail 2-Day 5 0.54 lbs $9.37 $8.52 $0.85
223583 2021-03-23 $124.02 Priority Mail 3-Day Flat Rate Envelope 3 4.91 lbs $8.25 $8.00 $0.25
223584 2021-03-23 $12.38 USPSFirstClass 1 0.06 lbs $4.59 $3.12 $1.47
223585 2021-03-23 $7.39 USPSFirstClass 1 0.02 lbs $4.40 $3.22 $1.18
223587 2021-03-23 $13.89 First-Class Package Service 2 0.37 lbs $4.01 $3.51 $0.50
223588 2021-03-24 $12.38 USPSFirstClass 1 0.06 lbs $4.59 $3.12 $1.47
223589 2021-03-24 $16.25 USPSFirstClass 2 0.80 lbs $9.27 $5.81 $3.46
223590 2021-03-23 $83.06 Priority Mail 3-Day 1 1.19 lbs $9.09 $8.24 $0.85
223592 2021-03-23 $76.99 Priority Mail 2-Day Medium Flat Rate Box 1 4.39 lbs $15.00 $7.40 $7.60
223594 2021-03-23 $52.53 Priority Mail 3-Day 1 0.70 lbs $12.54 $11.69 $0.85
223597 2021-03-23 $37.08 Priority Mail 2-Day 1 0.89 lbs $9.09 $8.24 $0.85
223598 2021-03-23 $8.00 First-Class Package Service 1 0.20 lbs $4.01 $3.06 $0.95
223600 2021-03-23 $14.22 First-Class Package Service 1 0.30 lbs $4.01 $3.51 $0.50
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56