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
202096 2018-03-04 $19.52 First-Class Mail Large Envelope 1 0.40 lbs $4.03 $3.18 $0.85
202098 2018-03-04 $125.23 Priority Mail International 18 1.47 lbs $48.11 $50.83 $-2.72
202100 2018-03-04 $18.82 First-Class Mail Large Envelope 1 0.35 lbs $4.03 $3.66 $0.37
202101 2018-03-04 $22.08 First-Class Package Service 3 0.12 lbs $3.71 $2.79 $0.92
202102 2018-03-04 $36.68 Priority Mail 2-Day 2 0.56 lbs $8.20 $7.13 $1.07
202103 2018-03-05 $13.89 First-Class Package Service 8 0.26 lbs $3.97 $3.05 $0.92
202105 2018-03-05 $12.08 First-Class Package Service 3 0.18 lbs $3.71 $2.79 $0.92
202107 2018-03-05 $8.60 First-Class Package Service 1 0.10 lbs $3.71 $2.66 $1.05
202108 2018-03-05 $69.38 First-Class Package Service 1 0.70 lbs $5.43 $4.38 $1.05
202109 2018-03-05 $48.00 Priority Mail 3-Day 1 2.20 lbs $13.01 $9.47 $3.54
202111 2018-03-06 $47.18 Priority Mail 3-Day Flat Rate Envelope 2 1.50 lbs $7.40 $6.85 $0.55
202112 2018-03-06 $19.35 Priority Mail 2-Day 7 2.90 lbs $14.00 $12.76 $1.24
202113 2018-03-06 $115.00 Priority Mail International 1 3.95 lbs $61.01 $60.28 $0.73
202116 2018-03-06 $31.18 First-Class Package Service 5 0.53 lbs $4.67 $4.38 $0.29
202117 2018-03-06 $62.82 Priority Mail 2-Day 2 2.58 lbs $9.54 $8.22 $1.32
202118 2018-03-06 $32.42 First-Class Mail Large Envelope 3 0.39 lbs $4.45 $3.34 $1.11
202123 2018-03-06 $256.32 Priority Mail International 1 14.05 lbs $86.33 $84.17 $2.16
202124 2018-03-06 $15.40 First-Class Mail Large Envelope 1 0.30 lbs $3.61 $3.18 $0.43
202125 2018-03-06 $8.19 First-Class Package Service 2 0.21 lbs $3.71 $3.05 $0.66
202127 2018-03-06 $36.01 First-Class Package Service 2 0.75 lbs $5.23 $4.94 $0.29
202128 2018-03-07 $857.65 Priority Mail International 81 24.77 lbs $281.88 $193.75 $88.13
202129 2018-03-07 $162.89 Priority Mail International 14 6.28 lbs $68.04 $63.79 $4.25
202130 2018-03-07 $19.52 First-Class Mail Large Envelope 1 0.35 lbs $4.03 $3.18 $0.85
202133 2018-03-07 $8.50 First-Class Package Service 1 0.07 lbs $3.71 $2.66 $1.05
202134 2018-03-07 $21.36 Priority Mail 2-Day Flat Rate Envelope 4 0.16 lbs $7.40 $6.35 $1.05
202135 2018-03-07 $250.28 Priority Mail International Medium Flat Rate Box 7 9.65 lbs $70.25 $66.00 $4.25
202136 2018-03-07 $3.97 First-Class Package Service 1 0.30 lbs $3.97 $3.05 $0.92
202139 2018-03-08 $107.04 Priority Mail International 3 1.35 lbs $47.07 $30.65 $16.42
202140 2018-03-08 $54.19 First-Class Package International Service 1 1.25 lbs $27.33 $22.33 $5.00
202141 2018-03-08 $55.82 First-Class Package International Service 1 1.30 lbs $27.33 $22.33 $5.00
202142 2018-03-08 $115.00 Priority Mail International 1 3.95 lbs $61.01 $60.28 $0.73
202144 2018-03-08 $19.67 First-Class Package Service 4 0.14 lbs $3.71 $2.79 $0.92
202145 2018-03-08 $42.16 Priority Mail 3-Day 9 0.73 lbs $8.25 $7.18 $1.07
202146 2018-03-08 $67.62 Priority Mail 2-Day Medium Flat Rate Box 3 4.60 lbs $13.85 $10.29 $3.56
202147 2018-03-09 $55.84 First-Class Package International Service 1 1.05 lbs $26.85 $21.85 $5.00
202148 2018-03-09 $103.99 First-Class Package International Service 2 1.64 lbs $38.01 $33.01 $5.00
202149 2018-03-09 $98.98 First-Class Package International Service 3 1.80 lbs $38.01 $33.01 $5.00
202150 2018-03-09 $421.56 Priority Mail International 26 14.64 lbs $139.72 $87.50 $52.22
202151 2018-03-09 $7.70 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
202152 2018-03-09 $37.19 First-Class Package International Service 1 0.85 lbs $20.20 $15.20 $5.00
202154 2018-03-09 $6.70 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
202155 2018-03-09 $41.16 First-Class Package Service 3 0.90 lbs $5.79 $4.94 $0.85
202156 2018-03-09 $247.19 Priority Mail 2-Day 1 21.00 lbs $54.00 $52.89 $1.11
202157 2018-03-09 $123.79 Ground 6 13.71 lbs $21.53 $16.36 $5.17
202158 2018-03-10 $105.49 Priority Mail 2-Day 5 2.98 lbs $9.54 $8.43 $1.11
202161 2018-03-10 $6.60 First-Class Package Service 1 0.03 lbs $3.71 $2.66 $1.05
202162 2018-03-10 $156.62 Priority Mail 2-Day 8 3.95 lbs $11.50 $10.33 $1.17
202164 2018-03-10 $12.68 First-Class Package Service 3 0.09 lbs $3.71 $2.66 $1.05
202166 2018-03-10 $7.69 First-Class Package Service 2 0.06 lbs $3.71 $2.66 $1.05
202167 2018-03-10 $35.89 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $7.90 $6.85 $1.05
202174 2018-03-10 $8.40 First-Class Mail Large Envelope 1 0.25 lbs $3.61 $3.18 $0.43
202175 2018-03-10 $31.83 First-Class Package Service 14 0.26 lbs $3.97 $2.92 $1.05
202182 2018-03-11 $8.70 First-Class Package Service 1 0.10 lbs $3.71 $2.66 $1.05
202183 2018-03-11 $55.83 Priority Mail 3-Day 5 1.00 lbs $10.32 $9.19 $1.13
202184 2018-03-11 $8.37 First-Class Package Service 2 0.40 lbs $4.19 $3.18 $1.01
202185 2018-03-11 $40.89 Priority Mail 3-Day Small Flat Rate Box 1 1.30 lbs $7.90 $6.85 $1.05
202186 2018-03-11 $6.68 First-Class Package Service 3 0.03 lbs $3.71 $2.66 $1.05
202187 2018-03-11 $105.42 Priority Mail 2-Day 11 3.50 lbs $15.03 $15.67 $-0.64
202189 2018-03-11 $22.19 First-Class Package Service 1 0.30 lbs $3.90 $3.18 $0.72
202190 2018-03-11 $24.49 First-Class Package Service 3 0.50 lbs $5.71 $3.66 $2.05
202192 2018-03-12 $25.69 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $7.40 $6.90 $0.50
202193 2018-03-12 $6.70 First-Class Package Service 1 0.03 lbs $3.71 $2.66 $1.05
202196 2018-03-12 $86.64 First-Class Package International Service 37 1.69 lbs $38.01 $22.33 $15.68
202197 2018-03-12 $13.45 First-Class Package Service 2 0.10 lbs $3.97 $2.79 $1.18
202198 2018-03-12 $11.83 First-Class Package Service 1 0.20 lbs $3.84 $2.92 $0.92
202199 2018-03-12 $46.63 Priority Mail 2-Day 2 1.06 lbs $11.65 $10.48 $1.17
202200 2018-03-12 $45.18 Priority Mail 2-Day Flat Rate Envelope 2 1.75 lbs $7.40 $6.90 $0.50
202201 2018-03-12 $110.08 Ground 4 4.80 lbs $23.62 $17.81 $5.81
202202 2018-03-13 $37.39 Priority Mail 2-Day Small Flat Rate Box 1 1.15 lbs $7.90 $6.85 $1.05
202203 2018-03-13 $73.50 First-Class Package International Service 1 2.20 lbs $38.01 $33.01 $5.00
202204 2018-03-13 $73.50 First-Class Package International Service 1 2.20 lbs $38.01 $33.01 $5.00
202205 2018-03-13 $165.33 Priority Mail International 1 8.55 lbs $81.34 $74.34 $7.00
202206 2018-03-13 $24.80 First-Class Package Service 1 0.80 lbs $5.51 $4.10 $1.41
202209 2018-03-13 $128.32 Priority Mail International 1 5.65 lbs $64.53 $63.79 $0.74
202210 2018-03-13 $670.31 Priority Mail 3-Day 20 36.56 lbs $45.71 $43.86 $1.85
202211 2018-03-13 $25.69 Priority Mail 3-Day Flat Rate Envelope 1 0.90 lbs $7.40 $6.90 $0.50
202212 2018-03-13 $28.69 First-Class Mail Large Envelope 5 0.42 lbs $4.24 $3.34 $0.90
202213 2018-03-13 $11.69 First-Class Package Service 2 0.14 lbs $3.71 $3.05 $0.66
202215 2018-03-14 $42.33 Priority Mail 2-Day Padded Flat Rate Envelope 2 0.62 lbs $7.95 $6.85 $1.10
202217 2018-03-14 $33.07 First-Class Package Service 2 0.70 lbs $5.79 $4.66 $1.13
202218 2018-03-14 $251.58 Priority Mail 3-Day 12 8.83 lbs $26.76 $25.13 $1.63
202219 2018-03-14 $25.22 First-Class Package Service 1 0.35 lbs $4.23 $3.18 $1.05
202222 2018-03-15 $18.50 First-Class Mail Large Envelope 2 0.30 lbs $3.82 $3.18 $0.64
202224 2018-03-15 $12.82 First-Class Package Service 2 0.15 lbs $3.84 $2.92 $0.92
202225 2018-03-15 $18.98 First-Class Package Service 1 0.35 lbs $4.19 $3.82 $0.37
202231 2018-03-15 $73.02 Ground 4 2.10 lbs $22.46 $19.53 $2.93
202232 2018-03-15 $25.51 Priority Mail 2-Day 3 0.75 lbs $11.14 $9.98 $1.16
202239 2018-03-16 $64.12 First-Class Package International Service 1 1.20 lbs $27.33 $33.25 $-5.92
202242 2018-03-16 $5.18 First-Class Package Service 3 0.03 lbs $3.71 $2.66 $1.05
202247 2018-03-16 $39.77 Priority Mail 3-Day Flat Rate Envelope 2 0.55 lbs $7.40 $6.85 $0.55
202248 2018-03-16 $57.18 Priority Mail 2-Day Flat Rate Envelope 2 1.25 lbs $7.40 $6.85 $0.55
202249 2018-03-16 $51.81 Priority Mail 2-Day 1 1.70 lbs $9.32 $7.40 $1.92
202250 2018-03-16 $12.15 First-Class Package Service 6 0.07 lbs $3.71 $2.66 $1.05
202251 2018-03-16 $104.09 Priority Mail 2-Day 2 8.70 lbs $12.31 $13.42 $-1.11
202252 2018-03-16 $16.31 First-Class Package Service 16 0.28 lbs $3.97 $2.79 $1.18
202262 2018-03-17 $12.20 First-Class Package Service 1 0.18 lbs $3.71 $2.79 $0.92
202263 2018-03-17 $21.28 First-Class Mail Large Envelope 3 0.30 lbs $3.61 $3.18 $0.43
202264 2018-03-18 $50.29 First-Class Package International Service 1 0.31 lbs $18.30 $13.30 $5.00
202265 2018-03-18 $34.23 First-Class Mail Large Envelope 2 0.60 lbs $4.45 $3.82 $0.63
202266 2018-03-18 $49.68 Priority Mail 2-Day Flat Rate Envelope 2 1.70 lbs $7.40 $6.90 $0.50
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56