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
200983 2017-11-29 $157.92 Priority Mail International 1 8.55 lbs $73.93 $71.68 $2.25
200984 2017-11-29 $23.21 First-Class Package Service 1 0.22 lbs $3.82 $2.77 $1.05
200985 2017-11-29 $92.77 First-Class Package International Service 11 3.58 lbs $47.88 $54.82 $-6.94
200986 2017-11-29 $95.28 First-Class Package International Service 10 3.20 lbs $47.88 $47.03 $0.85
200989 2017-11-30 $55.50 First-Class Package International Service 3 1.34 lbs $22.23 $21.38 $0.85
200990 2017-11-30 $55.51 First-Class Package International Service 2 0.70 lbs $22.23 $21.38 $0.85
200991 2017-11-30 $68.17 First-Class Package International Service 1 2.20 lbs $32.68 $31.83 $0.85
200992 2017-11-30 $51.20 First-Class Package International Service 3 0.53 lbs $22.23 $21.38 $0.85
200993 2017-11-30 $51.72 First-Class Package International Service 1 1.20 lbs $22.23 $21.38 $0.85
200994 2017-11-30 $51.72 First-Class Package International Service 1 1.20 lbs $22.23 $21.38 $0.85
200996 2017-11-30 $26.00 First-Class Mail Large Envelope 1 0.45 lbs $4.01 $3.32 $0.69
200997 2017-11-30 $47.79 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $7.30 $6.25 $1.05
200998 2017-11-30 $225.18 Priority Mail International 11 11.19 lbs $76.59 $79.37 $-2.78
200999 2017-11-30 $127.73 Priority Mail International 1 5.65 lbs $60.44 $61.56 $-1.12
201000 2017-11-30 $57.08 Priority Mail 2-Day Flat Rate Envelope 2 1.55 lbs $6.80 $6.25 $0.55
201001 2017-11-30 $29.72 First-Class Package International Service 2 0.28 lbs $13.44 $12.59 $0.85
201004 2017-11-30 $50.81 Priority Mail 2-Day Padded Flat Rate Envelope 4 1.56 lbs $7.35 $6.25 $1.10
201005 2017-11-30 $88.59 Priority Mail International 2 1.70 lbs $44.41 $43.56 $0.85
201006 2017-11-30 $11.26 First-Class Package Service 6 0.17 lbs $3.82 $2.77 $1.05
201007 2017-12-01 $93.74 Priority Mail 2-Day 8 6.65 lbs $11.82 $10.64 $1.18
201008 2017-12-01 $127.73 Priority Mail International 1 5.65 lbs $60.44 $61.56 $-1.12
201009 2017-12-01 $62.72 First-Class Package International Service 1 1.50 lbs $22.23 $21.38 $0.85
201010 2017-12-01 $118.55 Priority Mail 2-Day Flat Rate Envelope 75 3.75 lbs $6.80 $12.50 $-5.70
201012 2017-12-01 $11.12 First-Class Package Service 4 0.05 lbs $3.66 $2.61 $1.05
201013 2017-12-02 $232.18 Priority Mail 2-Day Large Flat Rate Box 12 4.45 lbs $30.30 $16.55 $13.75
201016 2017-12-02 $41.68 Priority Mail 2-Day Small Flat Rate Box 2 1.10 lbs $7.30 $6.25 $1.05
201017 2017-12-02 $90.32 Priority Mail 2-Day Flat Rate Envelope 3 3.60 lbs $12.75 $9.19 $3.56
201022 2017-12-02 $38.18 First-Class Package International Service 5 0.37 lbs $22.23 $21.38 $0.85
201023 2017-12-02 $54.08 Priority Mail 2-Day 13 2.12 lbs $8.71 $6.63 $2.08
201024 2017-12-02 $51.17 Priority Mail 2-Day Flat Rate Envelope 3 1.40 lbs $6.80 $6.25 $0.55
201025 2017-12-02 $20.54 First-Class Package Service 12 0.14 lbs $3.66 $2.61 $1.05
201026 2017-12-02 $6.55 First-Class Package Service 1 0.03 lbs $3.66 $2.61 $1.05
201027 2017-12-02 $11.64 First-Class Package Service 2 0.10 lbs $3.66 $2.61 $1.05
201028 2017-12-03 $30.15 First-Class Mail Large Envelope 6 0.30 lbs $4.01 $2.77 $1.24
201029 2017-12-03 $67.56 Priority Mail 3-Day 1 3.50 lbs $9.57 $8.91 $0.66
201030 2017-12-03 $44.58 Priority Mail 2-Day Flat Rate Envelope 2 1.80 lbs $6.80 $6.66 $0.14
201031 2017-12-03 $7.65 First-Class Package Service 1 0.06 lbs $3.66 $2.61 $1.05
201033 2017-12-03 $44.99 First-Class Package Service 2 0.85 lbs $5.01 $4.30 $0.71
201035 2017-12-04 $15.38 First-Class Mail Large Envelope 1 0.30 lbs $3.59 $3.32 $0.27
201037 2017-12-04 $17.37 First-Class Mail Large Envelope 2 0.32 lbs $3.59 $6.25 $-2.66
201038 2017-12-04 $27.19 First-Class Package Service 2 0.45 lbs $4.31 $3.46 $0.85
201040 2017-12-04 $10.65 First-Class Package Service 1 0.06 lbs $3.66 $2.61 $1.05
201041 2017-12-04 $37.78 First-Class Package Service 4 0.35 lbs $3.82 $2.77 $1.05
201042 2017-12-04 $30.67 First-Class Package Service 6 0.50 lbs $4.73 $3.74 $0.99
201044 2017-12-05 $11.99 Priority Mail 3-Day Flat Rate Envelope 1 0.07 lbs $6.80 $6.30 $0.50
201047 2017-12-05 $126.68 Priority Mail 2-Day Flat Rate Envelope 12 5.96 lbs $6.80 $6.25 $0.55
201049 2017-12-05 $35.79 Priority Mail 2-Day Flat Rate Envelope 1 1.05 lbs $6.80 $6.25 $0.55
201052 2017-12-05 $54.46 First-Class Package International Service 22 0.45 lbs $13.68 $21.38 $-7.70
201053 2017-12-05 $42.83 Priority Mail 2-Day 1 0.75 lbs $10.84 $9.69 $1.15
201055 2017-12-05 $7.65 First-Class Package Service 1 0.04 lbs $3.66 $2.61 $1.05
201056 2017-12-05 $25.09 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $6.80 $6.30 $0.50
201057 2017-12-05 $29.80 First-Class Package Service 2 0.17 lbs $3.82 $2.77 $1.05
201058 2017-12-05 $239.69 Ground 2 21.25 lbs $33.71 $28.51 $5.20
201060 2017-12-05 $32.31 Priority Mail 3-Day 9 0.86 lbs $9.00 $7.91 $1.09
201062 2017-12-05 $115.30 Priority Mail 3-Day 1 12.90 lbs $17.31 $15.96 $1.35
201065 2017-12-05 $68.17 First-Class Package International Service 1 2.20 lbs $32.68 $31.83 $0.85
201067 2017-12-05 $24.14 Priority Mail 2-Day 6 1.56 lbs $9.00 $7.91 $1.09
201068 2017-12-05 $8.81 First-Class Package Service 1 0.20 lbs $3.82 $3.46 $0.36
201070 2017-12-06 $99.39 Priority Mail 2-Day Medium Flat Rate Box 1 10.70 lbs $13.40 $6.83 $6.57
201075 2017-12-06 $28.17 First-Class Package Service 2 0.60 lbs $4.59 $3.74 $0.85
201077 2017-12-07 $5.64 First-Class Package Service 2 0.02 lbs $3.66 $2.61 $1.05
201078 2017-12-07 $37.09 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $7.30 $6.25 $1.05
201081 2017-12-07 $152.92 Priority Mail 2-Day 1 9.60 lbs $33.73 $31.89 $1.84
201082 2017-12-07 $232.63 Priority Mail 2-Day 8 6.25 lbs $17.21 $14.68 $2.53
201083 2017-12-07 $13.79 Priority Mail 3-Day Flat Rate Envelope 1 0.19 lbs $6.80 $5.75 $1.05
201084 2017-12-07 $47.79 Priority Mail 2-Day Small Flat Rate Box 1 1.45 lbs $7.30 $6.25 $1.05
201085 2017-12-07 $60.29 First-Class Package International Service 1 1.55 lbs $22.23 $21.38 $0.85
201086 2017-12-07 $61.12 First-Class Package International Service 1 2.20 lbs $32.68 $31.83 $0.85
201087 2017-12-07 $122.31 Priority Mail 2-Day 6 5.03 lbs $20.33 $17.06 $3.27
201089 2017-12-08 $85.08 First-Class Package International Service 5 0.78 lbs $22.23 $21.38 $0.85
201090 2017-12-08 $18.62 Priority Mail 2-Day 2 0.85 lbs $10.84 $6.30 $4.54
201092 2017-12-08 $17.27 Priority Mail 3-Day Flat Rate Envelope 3 0.09 lbs $6.80 $6.66 $0.14
201093 2017-12-08 $25.65 First-Class Package International Service 3 0.21 lbs $13.68 $12.83 $0.85
201094 2017-12-08 $12.70 First-Class Package Service 2 0.15 lbs $3.82 $2.77 $1.05
201096 2017-12-08 $22.53 Priority Mail 2-Day 1 0.80 lbs $10.04 $8.91 $1.13
201097 2017-12-09 $52.25 Priority Mail 2-Day 1 2.40 lbs $7.46 $6.41 $1.05
201099 2017-12-09 $27.18 Priority Mail 3-Day 3 0.32 lbs $7.71 $6.66 $1.05
201102 2017-12-09 $16.62 First-Class Package Service 4 0.06 lbs $3.66 $2.61 $1.05
201105 2017-12-10 $11.81 First-Class Package Service 1 0.17 lbs $3.82 $2.77 $1.05
201106 2017-12-10 $34.91 First-Class Package Service 2 0.69 lbs $4.93 $4.02 $0.91
201108 2017-12-10 $26.00 First-Class Mail Large Envelope 1 0.40 lbs $4.01 $3.74 $0.27
201111 2017-12-10 $237.69 Ground 2 21.30 lbs $33.71 $28.51 $5.20
201114 2017-12-11 $65.21 First-Class Package International Service 2 1.00 lbs $22.23 $21.38 $0.85
201115 2017-12-11 $113.86 First-Class Package International Service 2 2.70 lbs $47.88 $47.03 $0.85
201116 2017-12-11 $7.15 First-Class Package Service 1 0.05 lbs $3.66 $2.61 $1.05
201118 2017-12-11 $102.70 Priority Mail 2-Day 6 2.87 lbs $18.46 $17.08 $1.38
201119 2017-12-11 $17.27 Priority Mail 2-Day Flat Rate Envelope 3 0.09 lbs $6.80 $5.75 $1.05
201120 2017-12-12 $36.56 Priority Mail 2-Day 2 0.60 lbs $7.58 $6.25 $1.33
201121 2017-12-12 $60.20 First-Class Package International Service 1 1.50 lbs $22.23 $21.38 $0.85
201122 2017-12-12 $62.72 First-Class Package International Service 1 1.50 lbs $22.23 $21.38 $0.85
201124 2017-12-12 $55.01 Priority Mail 2-Day 3 1.60 lbs $10.04 $8.91 $1.13
201129 2017-12-12 $47.42 First-Class Package Service 3 0.85 lbs $5.15 $4.16 $0.99
201131 2017-12-13 $6.64 First-Class Package Service 2 0.06 lbs $3.66 $2.61 $1.05
201132 2017-12-13 $65.06 First-Class Package Service 1 0.70 lbs $5.07 $4.02 $1.05
201133 2017-12-13 $5.64 First-Class Package Service 2 0.02 lbs $3.66 $2.61 $1.05
201134 2017-12-13 $18.59 First-Class Package Service 3 0.23 lbs $3.82 $2.77 $1.05
201135 2017-12-13 $71.46 Priority Mail 2-Day Medium Flat Rate Box 4 2.63 lbs $13.40 $12.05 $1.35
201138 2017-12-13 $11.53 First-Class Package Service 2 0.80 lbs $5.15 $4.30 $0.85
201139 2017-12-13 $304.33 Priority Mail 3-Day 3 25.04 lbs $73.16 $65.84 $7.32
201140 2017-12-13 $15.62 First-Class Package Service 4 0.12 lbs $3.66 $2.61 $1.05
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56