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
207624 2019-09-03 $14.09 Priority Mail 2-Day 1 0.42 lbs $9.10 $8.25 $0.85
207625 2019-09-03 $42.78 Priority Mail 2-Day Flat Rate Envelope 2 1.38 lbs $7.80 $7.50 $0.30
207627 2019-09-03 $18.14 Priority Mail 2-Day 1 0.95 lbs $9.35 $8.50 $0.85
207629 2019-09-03 $24.29 Priority Mail 2-Day 6 0.84 lbs $10.55 $7.82 $2.73
207633 2019-09-03 $12.46 First-Class Package Service 3 0.14 lbs $3.89 $2.84 $1.05
207634 2019-09-03 $43.32 Priority Mail 2-Day 2 1.50 lbs $8.27 $7.61 $0.66
207635 2019-09-04 $53.69 Priority Mail 2-Day 2 1.25 lbs $11.71 $10.86 $0.85
207637 2019-09-04 $8.70 First-Class Package Service 5 0.06 lbs $3.75 $2.70 $1.05
207638 2019-09-04 $157.35 Ground Home Delivery 13 13.39 lbs $27.88 $20.20 $7.68
207639 2019-09-04 $13.50 First-Class Package Service 1 0.05 lbs $4.01 $2.96 $1.05
207641 2019-09-04 $48.71 Priority Mail 3-Day 3 2.40 lbs $8.84 $7.85 $0.99
207642 2019-09-04 $30.69 Priority Mail 2-Day 6 0.81 lbs $9.35 $7.65 $1.70
207643 2019-09-04 $80.10 Priority Mail 2-Day 5 1.90 lbs $12.65 $10.00 $2.65
207644 2019-09-04 $25.22 First-Class Package Service 2 0.45 lbs $5.24 $4.19 $1.05
207647 2019-09-05 $181.57 Priority Mail 3-Day 2 13.85 lbs $27.59 $26.74 $0.85
207648 2019-09-05 $70.47 Priority Mail 2-Day Flat Rate Envelope 3 2.01 lbs $7.80 $7.55 $0.25
207651 2019-09-05 $10.38 First-Class Package Service 13 0.13 lbs $4.01 $2.96 $1.05
207653 2019-09-05 $16.33 First-Class Package Service 1 0.30 lbs $4.54 $3.49 $1.05
207654 2019-09-05 $10.50 First-Class Package Service 3 0.25 lbs $4.33 $3.28 $1.05
207655 2019-09-05 $34.39 First-Class Package Service 2 0.55 lbs $4.81 $3.96 $0.85
207656 2019-09-06 $38.14 Priority Mail 3-Day Small Flat Rate Box 1 1.35 lbs $8.35 $7.50 $0.85
207657 2019-09-06 $72.18 Priority Mail 2-Day 4 2.20 lbs $13.95 $13.10 $0.85
207661 2019-09-06 $69.27 Priority Mail 2-Day 3 1.67 lbs $8.46 $7.61 $0.85
207662 2019-09-06 $60.73 Priority Mail 3-Day 2 2.15 lbs $13.95 $10.55 $3.40
207664 2019-09-06 $24.65 First-Class Package Service 6 0.40 lbs $4.91 $4.06 $0.85
207665 2019-09-07 $23.04 Priority Mail 3-Day Flat Rate Envelope 6 1.14 lbs $7.80 $7.50 $0.30
207667 2019-09-07 $15.74 First-Class Package Service 1 0.37 lbs $4.23 $3.18 $1.05
207668 2019-09-07 $19.30 First-Class Package Service 3 0.30 lbs $4.33 $3.28 $1.05
207669 2019-09-07 $19.99 First-Class Package Service 1 0.05 lbs $3.81 $2.96 $0.85
207670 2019-09-07 $31.08 First-Class Package Service 3 0.44 lbs $4.41 $4.06 $0.35
207671 2019-09-07 $5.52 First-Class Package Service 1 0.02 lbs $3.71 $2.66 $1.05
207675 2019-09-07 $16.33 Priority Mail 3-Day 2 1.22 lbs $9.35 $8.50 $0.85
207677 2019-09-08 $37.84 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $8.35 $9.70 $-1.35
207678 2019-09-08 $17.99 First-Class Package Service 2 0.12 lbs $4.01 $2.96 $1.05
207679 2019-09-08 $19.87 Priority Mail 2-Day 1 0.95 lbs $11.08 $10.23 $0.85
207680 2019-09-08 $20.20 First-Class Package Service 8 0.45 lbs $4.68 $4.33 $0.35
207681 2019-09-08 $67.16 Priority Mail 2-Day Flat Rate Envelope 4 2.04 lbs $7.80 $7.55 $0.25
207685 2019-09-08 $9.89 First-Class Package Service 12 0.12 lbs $4.01 $2.96 $1.05
207687 2019-09-09 $9.75 First-Class Package Service 6 0.09 lbs $3.81 $3.28 $0.53
207688 2019-09-09 $26.53 Direct Link International 1 0.65 lbs $18.54 $17.50 $1.04
207689 2019-09-09 $20.70 Direct Link International 2 0.36 lbs $12.72 $13.04 $-0.32
207691 2019-09-09 $19.34 Priority Mail 2-Day 1 0.95 lbs $10.55 $7.82 $2.73
207692 2019-09-09 $97.04 Priority Mail 2-Day 3 3.68 lbs $9.97 $9.12 $0.85
207693 2019-09-09 $13.11 First-Class Package Service 3 0.10 lbs $4.14 $3.09 $1.05
207695 2019-09-09 $24.53 First-Class Package Service 1 0.40 lbs $4.54 $4.19 $0.35
207696 2019-09-09 $23.42 First-Class Package International Service 1 0.05 lbs $18.23 $9.98 $8.25
207697 2019-09-09 $8.76 First-Class Package Service 5 0.05 lbs $3.81 $2.76 $1.05
207698 2019-09-09 $49.73 Priority Mail 2-Day Small Flat Rate Box 2 1.62 lbs $8.35 $7.50 $0.85
207700 2019-09-10 $26.19 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $7.80 $7.55 $0.25
207701 2019-09-10 $42.28 Priority Mail 2-Day 3 1.05 lbs $9.35 $9.26 $0.09
207702 2019-09-10 $6.78 First-Class Package Service 1 0.01 lbs $3.81 $2.76 $1.05
207703 2019-09-10 $69.63 Priority Mail 2-Day 3 2.60 lbs $9.19 $8.12 $1.07
207704 2019-09-10 $62.35 Priority Mail 2-Day 3 1.80 lbs $11.08 $10.55 $0.53
207706 2019-09-10 $23.55 Priority Mail 3-Day Medium Flat Rate Box 10 1.90 lbs $13.65 $10.23 $3.42
207707 2019-09-10 $45.68 Priority Mail 2-Day Flat Rate Envelope 2 1.80 lbs $7.80 $7.55 $0.25
207708 2019-09-10 $45.44 Priority Mail 2-Day 27 1.12 lbs $11.71 $10.86 $0.85
207709 2019-09-10 $80.13 Priority Mail 2-Day Medium Flat Rate Box 32 2.80 lbs $14.05 $11.20 $2.85
207710 2019-09-10 $7.00 First-Class Package Service 1 0.05 lbs $4.01 $2.96 $1.05
207712 2019-09-11 $22.87 First-Class Package Service 2 0.10 lbs $3.89 $2.84 $1.05
207713 2019-09-11 $33.83 First-Class Package Service 10 0.65 lbs $4.93 $3.88 $1.05
207715 2019-09-11 $43.22 Priority Mail 3-Day Flat Rate Envelope 2 1.80 lbs $7.80 $7.55 $0.25
207718 2019-09-11 $8.79 First-Class Package Service 2 0.08 lbs $3.81 $2.76 $1.05
207720 2019-09-12 $210.26 Priority Mail 2-Day 1 14.90 lbs $20.27 $20.35 $-0.08
207721 2019-09-12 $39.19 Priority Mail 1-Day 3 3.58 lbs $8.56 $7.65 $0.91
207722 2019-09-13 $15.32 Priority Mail 3-Day 2 0.50 lbs $8.34 $7.49 $0.85
207728 2019-08-08 $39.99 Priority Mail 3-Day 1 1.25 lbs $0.00 $7.50 $-7.50
207729 2019-09-13 $223.97 Priority Mail 2-Day 21 6.76 lbs $17.69 $16.84 $0.85
207730 2019-09-13 $8.80 First-Class Package Service 1 0.10 lbs $3.81 $2.76 $1.05
207734 2019-09-13 $24.64 First-Class Package Service 5 0.57 lbs $6.09 $5.24 $0.85
207735 2019-09-13 $23.04 First-Class Package Service 3 0.27 lbs $4.27 $3.22 $1.05
207737 2019-09-14 $16.36 First-Class Package Service 2 0.90 lbs $6.58 $5.53 $1.05
207738 2019-09-14 $42.46 Priority Mail 2-Day Flat Rate Envelope 4 0.98 lbs $7.80 $7.50 $0.30
207739 2019-09-14 $136.74 Priority Mail 3-Day Flat Rate Envelope 6 2.10 lbs $7.80 $7.50 $0.30
207741 2019-09-14 $106.11 Priority Mail 2-Day Large Flat Rate Box 24 2.98 lbs $18.45 $11.20 $7.25
207744 2019-09-14 $24.57 First-Class Package Service 7 0.23 lbs $3.71 $3.18 $0.53
207746 2019-09-14 $18.03 First-Class Package Service 2 0.26 lbs $4.25 $3.85 $0.40
207748 2019-09-14 $10.49 First-Class Package Service 2 0.03 lbs $4.01 $2.96 $1.05
207749 2019-09-15 $16.93 First-Class Package Service 1 0.20 lbs $4.14 $3.63 $0.51
207750 2019-09-15 $16.33 First-Class Package Service 1 0.30 lbs $4.54 $3.49 $1.05
207752 2019-09-15 $40.48 Priority Mail 2-Day Flat Rate Envelope 2 1.35 lbs $7.80 $7.50 $0.30
207755 2019-09-15 $63.26 Priority Mail 2-Day 9 1.75 lbs $13.95 $10.55 $3.40
207756 2019-09-15 $5.73 First-Class Package Service 2 0.02 lbs $3.75 $2.70 $1.05
207757 2019-09-15 $17.10 First-Class Package Service 1 0.57 lbs $5.11 $4.06 $1.05
207758 2019-09-15 $23.04 Priority Mail 2-Day Flat Rate Envelope 6 1.14 lbs $7.80 $7.50 $0.30
207759 2019-09-15 $33.23 Priority Mail 2-Day 8 2.00 lbs $10.11 $9.26 $0.85
207762 2019-09-15 $6.88 First-Class Package Service 1 0.04 lbs $3.89 $2.84 $1.05
207763 2019-09-16 $131.10 Priority Mail 2-Day 14 2.68 lbs $16.44 $15.59 $0.85
207765 2019-09-16 $34.58 Priority Mail 3-Day Small Flat Rate Box 1 1.30 lbs $8.35 $7.50 $0.85
207768 2019-09-16 $100.49 Priority Mail 2-Day Medium Flat Rate Box 6 3.14 lbs $14.05 $10.55 $3.50
207770 2019-09-16 $14.75 Priority Mail 2-Day Flat Rate Envelope 5 0.14 lbs $7.80 $6.95 $0.85
207771 2019-09-16 $30.39 First-Class Package Service 2 0.38 lbs $4.41 $3.36 $1.05
207772 2019-09-16 $59.77 Priority Mail 2-Day 2 2.40 lbs $12.65 $11.80 $0.85
207773 2019-09-17 $9.33 First-Class Package Service 1 0.07 lbs $4.14 $3.09 $1.05
207774 2019-09-17 $13.99 First-Class Package Service 2 0.12 lbs $4.01 $3.49 $0.52
207776 2019-09-17 $46.61 Priority Mail 3-Day Flat Rate Envelope 3 1.45 lbs $7.80 $7.55 $0.25
207777 2019-09-18 $57.31 Priority Mail 1-Day 1 1.65 lbs $8.27 $7.50 $0.77
207779 2019-09-18 $10.08 First-Class Package Service 6 0.06 lbs $4.14 $3.09 $1.05
207780 2019-09-18 $8.20 First-Class Package Service 1 0.07 lbs $3.81 $2.76 $1.05
207781 2019-09-18 $29.48 First-Class Package Service 6 0.40 lbs $4.54 $4.19 $0.35
207782 2019-09-18 $32.96 First-Class Package Service 5 0.55 lbs $5.01 $3.96 $1.05
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56