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
204654 2018-11-21 $129.81 Priority Mail 3-Day Medium Flat Rate Box 4 4.45 lbs $13.85 $7.40 $6.45
204656 2018-11-21 $129.95 Priority Mail 2-Day 3 6.35 lbs $12.18 $11.07 $1.11
204657 2018-11-21 $37.69 Priority Mail 3-Day Small Flat Rate Box 1 1.30 lbs $7.90 $6.85 $1.05
204661 2018-11-22 $8.60 First-Class Package Service 1 0.15 lbs $3.71 $2.79 $0.92
204662 2018-11-22 $17.40 First-Class Package Service 2 0.28 lbs $3.97 $3.18 $0.79
204663 2018-11-22 $124.02 First-Class Package International Service 9 1.84 lbs $42.91 $34.91 $8.00
204664 2018-11-22 $13.51 First-Class Package Service 20 0.20 lbs $3.71 $2.66 $1.05
204665 2018-11-22 $25.23 Priority Mail 3-Day 2 1.08 lbs $8.25 $7.40 $0.85
204666 2018-11-22 $12.70 First-Class Package Service 1 0.10 lbs $3.71 $2.66 $1.05
204667 2018-11-23 $9.68 First-Class Package Service 3 0.03 lbs $3.71 $2.66 $1.05
204669 2018-11-23 $20.29 First-Class Mail Large Envelope 3 0.36 lbs $3.82 $3.34 $0.48
204672 2018-11-24 $239.82 3 Day Select 4 20.35 lbs $113.76 $58.50 $55.26
204673 2018-11-24 $22.26 First-Class Package Service 1 0.30 lbs $3.97 $3.05 $0.92
204674 2018-11-24 $28.39 Priority Mail 2-Day Flat Rate Envelope 1 0.35 lbs $7.40 $3.05 $4.35
204675 2018-11-24 $80.80 Priority Mail 2-Day 4 2.98 lbs $9.54 $7.40 $2.14
204676 2018-11-24 $11.69 First-Class Package Service 2 0.08 lbs $3.71 $2.66 $1.05
204677 2018-11-24 $12.06 First-Class Package Service 4 0.40 lbs $4.10 $2.66 $1.44
204679 2018-11-25 $86.69 First-Class Package International Service 4 1.65 lbs $30.33 $22.33 $8.00
204681 2018-11-25 $5.70 First-Class Package Service 1 0.01 lbs $3.71 $2.66 $1.05
204683 2018-11-25 $171.08 Priority Mail 2-Day 7 3.62 lbs $30.60 $15.13 $15.47
204686 2018-11-26 $128.84 Priority Mail 2-Day 6 3.45 lbs $11.50 $8.15 $3.35
204687 2018-11-26 $5.70 First-Class Package Service 1 0.19 lbs $3.71 $2.66 $1.05
204688 2018-11-26 $46.22 2nd Day Air 22 0.28 lbs $27.44 $24.94 $2.50
204689 2018-11-26 $27.19 Priority Mail 2-Day Small Flat Rate Box 1 1.00 lbs $7.90 $6.85 $1.05
204690 2018-11-26 $69.12 Priority Mail 2-Day Medium Flat Rate Box 23 1.93 lbs $13.85 $10.48 $3.37
204692 2018-11-26 $57.12 Priority Mail 2-Day Medium Flat Rate Box 3 3.83 lbs $13.85 $12.45 $1.40
204695 2018-11-26 $15.76 First-Class Package Service 1 0.30 lbs $3.97 $3.05 $0.92
204697 2018-11-26 $12.20 First-Class Package Service 1 0.15 lbs $3.71 $2.66 $1.05
204698 2018-11-26 $9.69 First-Class Package Service 2 0.04 lbs $3.71 $2.66 $1.05
204699 2018-11-26 $7.20 First-Class Package Service 1 0.03 lbs $3.71 $2.66 $1.05
204700 2018-11-26 $35.89 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $7.90 $6.85 $1.05
204702 2018-11-26 $8.67 First-Class Package Service 4 0.16 lbs $3.71 $2.66 $1.05
204703 2018-11-27 $34.51 First-Class Package Service 10 0.88 lbs $5.71 $3.05 $2.66
204704 2018-11-27 $6.03 First-Class Package Service 2 0.04 lbs $3.71 $2.79 $0.92
204705 2018-11-27 $27.42 Priority Mail 2-Day Small Flat Rate Box 8 0.45 lbs $7.90 $6.85 $1.05
204706 2018-11-28 $47.54 Priority Mail 2-Day Medium Flat Rate Box 11 2.14 lbs $13.85 $10.80 $3.05
204707 2018-11-28 $49.60 Priority Mail 2-Day 35 1.25 lbs $11.65 $10.48 $1.17
204709 2018-11-28 $11.67 First-Class Package Service 4 0.12 lbs $3.71 $2.79 $0.92
204710 2018-11-28 $21.65 Priority Mail 3-Day Flat Rate Envelope 5 1.13 lbs $7.40 $6.85 $0.55
204711 2018-11-28 $17.04 Priority Mail 3-Day 1 0.95 lbs $8.25 $7.18 $1.07
204712 2018-11-28 $35.65 Ground 4 17.15 lbs $35.65 $30.99 $4.66
204713 2018-11-28 $25.69 Priority Mail 3-Day Flat Rate Envelope 1 0.90 lbs $7.40 $6.90 $0.50
204714 2018-11-28 $65.68 Ground 2 2.70 lbs $0.00 $9.47 $-9.47
204715 2018-11-28 $33.70 First-Class Package Service 1 1.20 lbs $5.71 $6.85 $-1.14
204717 2018-11-29 $81.00 First-Class Package International Service 3 1.60 lbs $30.33 $22.33 $8.00
204718 2018-11-29 $87.21 Direct Link International 2 2.50 lbs $28.23 $8.22 $20.01
204719 2018-11-29 $70.82 First-Class Package International Service 1 1.45 lbs $30.33 $22.33 $8.00
204720 2018-11-29 $85.10 Direct Link International 2 2.19 lbs $28.62 $25.82 $2.80
204721 2018-11-29 $98.87 Direct Link International 4 2.52 lbs $27.91 $8.22 $19.69
204722 2018-11-29 $98.96 Direct Link International 5 2.45 lbs $29.01 $8.43 $20.58
204724 2018-11-29 $46.07 Priority Mail 2-Day 3 0.85 lbs $9.00 $7.91 $1.09
204725 2018-11-29 $27.69 First-Class Package Service 2 0.65 lbs $4.71 $4.66 $0.05
204726 2018-11-29 $21.71 First-Class Package Service 2 0.42 lbs $4.23 $3.50 $0.73
204727 2018-11-29 $22.02 First-Class Mail Large Envelope 2 0.39 lbs $4.24 $3.66 $0.58
204728 2018-11-29 $16.69 First-Class Package Service 2 0.12 lbs $3.71 $2.79 $0.92
204729 2018-11-29 $6.70 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
204731 2018-11-30 $6.20 First-Class Package Service 1 0.19 lbs $3.71 $2.66 $1.05
204732 2018-11-30 $66.36 Priority Mail 3-Day Medium Flat Rate Box 9 1.99 lbs $13.85 $10.29 $3.56
204733 2018-11-30 $5.70 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
204735 2018-11-30 $27.61 Priority Mail 2-Day 4 0.31 lbs $11.65 $7.53 $4.12
204736 2018-11-30 $17.31 First-Class Package Service 6 0.55 lbs $4.67 $3.82 $0.85
204737 2018-11-30 $32.15 First-Class Mail Large Envelope 2 0.70 lbs $4.87 $4.38 $0.49
204738 2018-11-30 $8.70 First-Class Package Service 1 0.10 lbs $3.71 $2.66 $1.05
204740 2018-11-30 $25.69 Priority Mail 3-Day Flat Rate Envelope 1 0.85 lbs $7.40 $6.90 $0.50
204743 2018-12-01 $22.97 First-Class Package Service 4 0.13 lbs $3.71 $2.92 $0.79
204745 2018-12-01 $58.07 Priority Mail 2-Day 4 2.10 lbs $10.11 $8.98 $1.13
204750 2018-12-02 $28.21 Priority Mail 2-Day 4 1.20 lbs $8.25 $7.40 $0.85
204753 2018-12-02 $17.04 Priority Mail 2-Day 1 0.95 lbs $8.25 $7.18 $1.07
204754 2018-12-02 $28.21 Priority Mail 2-Day 4 1.20 lbs $8.25 $7.40 $0.85
204756 2018-12-02 $10.23 First-Class Mail Large Envelope 2 0.50 lbs $4.45 $3.82 $0.63
204758 2018-12-03 $333.19 Priority Mail International 18 9.65 lbs $84.27 $74.43 $9.84
204759 2018-12-03 $5.67 First-Class Package Service 4 0.04 lbs $3.71 $2.66 $1.05
204760 2018-12-03 $37.37 Priority Mail 2-Day Flat Rate Envelope 3 1.05 lbs $7.40 $6.90 $0.50
204762 2018-12-03 $22.26 First-Class Package Service 1 0.30 lbs $3.97 $3.05 $0.92
204764 2018-12-04 $70.82 First-Class Package International Service 1 1.50 lbs $30.33 $22.33 $8.00
204765 2018-12-04 $70.82 First-Class Package International Service 1 1.50 lbs $30.33 $22.33 $8.00
204766 2018-12-04 $70.82 First-Class Package International Service 1 1.55 lbs $30.33 $22.33 $8.00
204768 2018-12-04 $48.39 Priority Mail 2-Day Small Flat Rate Box 1 1.50 lbs $7.90 $6.85 $1.05
204770 2018-12-04 $111.00 Ground 10 5.50 lbs $17.10 $14.96 $2.14
204772 2018-12-04 $19.78 First-Class Package Service 1 0.49 lbs $5.79 $4.94 $0.85
204774 2018-12-05 $9.95 First-Class Package Service 2 0.30 lbs $3.97 $3.18 $0.79
204775 2018-12-05 $12.57 First-Class Package Service 2 0.80 lbs $5.79 $4.94 $0.85
204777 2018-12-05 $11.69 First-Class Package Service 2 0.12 lbs $3.71 $2.66 $1.05
204778 2018-12-05 $17.97 First-Class Package Service 1 0.30 lbs $3.97 $3.18 $0.79
204780 2018-12-05 $15.76 First-Class Package Service 1 0.30 lbs $3.97 $3.18 $0.79
204781 2018-12-05 $48.39 Priority Mail 3-Day Small Flat Rate Box 1 1.45 lbs $7.90 $6.85 $1.05
204782 2018-12-05 $15.68 First-Class Package Service 3 0.21 lbs $3.71 $2.66 $1.05
204783 2018-12-05 $189.46 Priority Mail 2-Day 1 14.05 lbs $19.47 $19.04 $0.43
204784 2018-12-05 $24.09 First-Class Package Service 1 0.35 lbs $4.10 $3.18 $0.92
204785 2018-12-05 $15.20 First-Class Package Service 3 0.41 lbs $4.23 $2.66 $1.57
204786 2018-12-05 $44.99 Priority Mail 2-Day 3 1.23 lbs $10.32 $9.47 $0.85
204788 2018-12-05 $47.89 Priority Mail 3-Day Small Flat Rate Box 1 1.25 lbs $7.90 $6.85 $1.05
204790 2018-12-05 $21.24 Priority Mail 3-Day 1 1.50 lbs $8.25 $7.18 $1.07
204792 2018-12-05 $53.87 Priority Mail 3-Day Flat Rate Envelope 3 1.45 lbs $7.40 $6.85 $0.55
204794 2018-12-06 $95.48 Direct Link International 4 2.65 lbs $31.82 $27.73 $4.09
204795 2018-12-06 $95.48 Direct Link International 4 2.65 lbs $31.82 $27.56 $4.26
204796 2018-12-06 $95.48 Direct Link International 4 2.65 lbs $31.82 $25.17 $6.65
204797 2018-12-06 $95.55 Direct Link International 2 2.70 lbs $29.57 $47.71 $-18.14
204799 2018-12-06 $81.77 Priority Mail 2-Day 12 5.52 lbs $27.89 $23.35 $4.54
204800 2018-12-06 $92.57 Priority Mail 2-Day 12 5.64 lbs $27.89 $12.45 $15.44
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56