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
224198 2021-04-15 $6.91 USPSFirstClass 1 0.01 lbs $4.42 $3.35 $1.07
224199 2021-04-15 $7.29 USPSFirstClass 1 0.10 lbs $4.30 $3.06 $1.24
224201 2021-04-15 $27.03 Priority Mail 2-Day 1 1.50 lbs $12.54 $11.69 $0.85
224202 2021-04-15 $51.19 Priority Mail 2-Day Medium Flat Rate Box 31 2.44 lbs $15.00 $11.69 $3.31
224205 2021-04-15 $57.65 Priority Mail 2-Day 7 3.83 lbs $17.72 $14.80 $2.92
224206 2021-04-15 $13.02 First-Class Package Service 1 0.35 lbs $4.35 $4.68 $-0.33
224207 2021-04-15 $50.65 First-Class Package Service 1 0.75 lbs $6.16 $4.38 $1.78
224209 2021-04-15 $27.28 First-Class Package International Service 1 0.04 lbs $21.29 $13.54 $7.75
224210 2021-04-15 $10.99 First-Class Mail Stamped Letter 1 0.06 lbs $3.20 $3.06 $0.14
224211 2021-04-15 $34.98 Priority Mail 3-Day Small Flat Rate Box 1 1.40 lbs $8.75 $7.90 $0.85
224212 2021-04-15 $159.36 Priority Mail 2-Day 15 2.58 lbs $19.81 $16.45 $3.36
224213 2021-04-15 $17.22 First-Class Package Service 4 0.34 lbs $3.76 $3.51 $0.25
224214 2021-04-15 $24.94 First-Class Package Service 7 0.25 lbs $4.01 $3.51 $0.50
224215 2021-04-15 $92.93 Priority Mail 2-Day 3 3.10 lbs $11.28 $9.01 $2.27
224216 2021-04-16 $26.41 Priority Mail 2-Day 1 0.65 lbs $9.65 $8.80 $0.85
224217 2021-04-16 $7.49 First-Class Mail Stamped Letter 1 0.03 lbs $3.00 $3.35 $-0.35
224219 2021-04-16 $22.67 First-Class Package Service 1 0.65 lbs $5.91 $5.66 $0.25
224220 2021-04-16 $22.89 First-Class Mail Stamped Letter 1 0.18 lbs $3.60 $3.51 $0.09
224221 2021-04-16 $7.29 USPSFirstClass 1 0.10 lbs $4.30 $3.06 $1.24
224222 2021-04-16 $10.33 USPSFirstClass 1 0.35 lbs $5.44 $4.68 $0.76
224223 2021-04-16 $14.31 Priority Mail 2-Day 2 0.12 lbs $8.73 $7.90 $0.83
224224 2021-04-16 $10.38 First-Class Mail Stamped Letter 2 0.14 lbs $3.40 $3.49 $-0.09
224226 2021-04-16 $14.58 USPSFirstClass 1 0.17 lbs $4.79 $3.69 $1.10
224227 2021-04-16 $59.99 Priority Mail 2-Day Medium Flat Rate Box 1 25.00 lbs $15.00 $13.75 $1.25
224228 2021-04-16 $5.49 First-Class Mail Stamped Letter 1 0.01 lbs $3.00 $3.35 $-0.35
224229 2021-04-16 $16.14 Priority Mail 2-Day Flat Rate Envelope 1 0.05 lbs $8.25 $7.90 $0.35
224232 2021-04-16 $6.98 First-Class Mail Stamped Letter 2 0.02 lbs $3.00 $3.35 $-0.35
224233 2021-04-16 $7.99 First-Class Mail Stamped Letter 1 0.02 lbs $3.00 $3.12 $-0.12
224235 2021-04-16 $8.98 First-Class Mail Stamped Letter 2 0.03 lbs $3.00 $3.22 $-0.22
224236 2021-04-16 $93.83 Priority Mail 3-Day Padded Flat Rate Envelope 2 2.50 lbs $8.85 $8.00 $0.85
224237 2021-04-16 $90.47 Priority Mail 2-Day 2 2.35 lbs $10.49 $9.55 $0.94
224238 2021-04-17 $10.85 First-Class Package Service 1 0.06 lbs $3.56 $3.06 $0.50
224240 2021-04-17 $40.92 Priority Mail 3-Day 6 5.76 lbs $10.98 $8.34 $2.64
224242 2021-04-17 $57.15 Priority Mail 2-Day 6 1.28 lbs $9.70 $9.64 $0.06
224243 2021-04-17 $15.98 First-Class Package Service 1 0.30 lbs $4.19 $3.69 $0.50
224246 2021-04-17 $16.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.06 $0.14
224248 2021-04-17 $10.17 First-Class Mail Stamped Letter 3 0.04 lbs $3.20 $3.22 $-0.02
224250 2021-04-17 $9.39 USPSFirstClass 1 0.05 lbs $4.40 $3.06 $1.34
224251 2021-04-17 $12.18 Priority Mail 3-Day 1 0.03 lbs $9.19 $7.40 $1.79
224252 2021-04-17 $44.27 First-Class Package Service 1 0.75 lbs $6.16 $5.66 $0.50
224253 2021-04-17 $12.37 First-Class Package Service 1 0.30 lbs $4.78 $3.69 $1.09
224256 2021-04-17 $13.77 First-Class Package Service 2 0.10 lbs $3.99 $3.49 $0.50
224259 2021-04-17 $67.23 Priority Mail 2-Day Flat Rate Envelope 2 2.20 lbs $8.25 $8.00 $0.25
224260 2021-04-17 $9.49 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.49 $-0.29
224261 2021-04-17 $59.99 Priority Mail 2-Day Medium Flat Rate Box 1 25.00 lbs $15.00 $13.75 $1.25
224262 2021-04-17 $32.90 First-Class Package Service 6 0.95 lbs $6.06 $11.01 $-4.95
224263 2021-04-17 $28.76 First-Class Package Service 2 0.60 lbs $5.18 $4.68 $0.50
224265 2021-04-17 $10.18 First-Class Package Service 1 0.15 lbs $4.19 $3.69 $0.50
224267 2021-04-17 $73.00 Priority Mail 3-Day 2 1.45 lbs $9.09 $8.24 $0.85
224268 2021-04-18 $34.54 Priority Mail 3-Day Flat Rate Envelope 1 0.41 lbs $8.25 $8.00 $0.25
224269 2021-04-18 $14.44 First-Class Package Service 4 0.22 lbs $4.08 $3.58 $0.50
224270 2021-04-18 $9.28 USPSFirstClass 1 0.05 lbs $4.39 $3.06 $1.33
224271 2021-04-18 $5.24 USPSFirstClass 1 0.03 lbs $4.25 $3.12 $1.13
224272 2021-04-18 $12.33 USPSFirstClass 1 0.30 lbs $5.44 $3.69 $1.75
224276 2021-04-18 $11.16 First-Class Mail Stamped Letter 4 0.08 lbs $3.20 $3.06 $0.14
224277 2021-04-18 $13.79 First-Class Mail Stamped Letter 1 0.14 lbs $3.40 $3.06 $0.34
224278 2021-04-18 $25.50 First-Class Package Service 1 0.35 lbs $4.01 $3.51 $0.50
224279 2021-04-18 $13.68 USPSFirstClass 1 0.04 lbs $4.89 $3.49 $1.40
224284 2021-04-18 $17.15 First-Class Package Service 4 0.23 lbs $4.19 $3.69 $0.50
224285 2021-04-18 $22.60 First-Class Package Service 21 0.28 lbs $4.01 $3.51 $0.50
224287 2021-04-18 $9.49 First-Class Package Service 1 0.20 lbs $4.19 $3.69 $0.50
224289 2021-04-18 $49.11 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.31 lbs $8.85 $8.00 $0.85
224290 2021-04-18 $33.71 First-Class Package Service 5 0.37 lbs $3.96 $4.04 $-0.08
224292 2021-04-18 $33.81 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.75 $7.90 $0.85
224295 2021-04-19 $9.70 First-Class Package Service 1 0.05 lbs $3.99 $3.49 $0.50
224296 2021-04-19 $10.90 USPSFirstClass 1 0.10 lbs $4.61 $3.35 $1.26
224297 2021-04-19 $12.36 USPSFirstClass 4 0.12 lbs $4.40 $3.35 $1.05
224298 2021-04-19 $13.89 USPSFirstClass 1 0.05 lbs $4.90 $3.85 $1.05
224299 2021-04-19 $94.17 Ground 7 5.60 lbs $14.74 $17.78 $-3.04
224300 2021-04-19 $13.18 First-Class Mail Stamped Letter 2 0.10 lbs $3.40 $3.35 $0.05
224302 2021-04-19 $34.60 First-Class Package Service 8 0.43 lbs $5.18 $3.85 $1.33
224304 2021-03-15 $102.80 Priority Mail 2-Day 8 3.30 lbs $11.28 $10.43 $0.85
224305 2021-04-19 $43.86 First-Class Package Service 9 0.75 lbs $5.69 $4.04 $1.65
224306 2021-03-15 $21.24 Priority Mail 2-Day 3 0.30 lbs $4.77 $3.57 $1.20
224307 2021-04-19 $25.33 USPSFirstClass 4 0.21 lbs $13.07 $5.42 $7.65
224308 2021-04-19 $187.83 Ground 1 30.00 lbs $44.22 $42.42 $1.80
224310 2021-04-19 $18.04 Priority Mail 2-Day Flat Rate Envelope 1 0.35 lbs $8.25 $7.90 $0.35
224311 2021-04-19 $17.83 First-Class Mail Stamped Letter 7 0.09 lbs $3.40 $3.35 $0.05
224315 2021-04-19 $8.88 First-Class Mail Stamped Letter 2 0.10 lbs $3.40 $3.12 $0.28
224317 2021-04-20 $8.64 USPSFirstClass 1 0.10 lbs $4.65 $3.49 $1.16
224318 2021-04-19 $97.20 Priority Mail 2-Day 11 10.45 lbs $16.44 $8.34 $8.10
224323 2021-04-19 $22.36 Priority Mail 2-Day 1 0.05 lbs $9.37 $7.90 $1.47
224325 2021-04-20 $19.14 First-Class Package Service 1 0.25 lbs $4.35 $3.49 $0.86
224326 2021-04-20 $4.49 First-Class Mail Stamped Letter 1 0.01 lbs $3.00 $3.49 $-0.49
224328 2021-04-20 $24.42 First-Class Package Service 1 0.60 lbs $4.93 $4.68 $0.25
224330 2021-04-20 $98.53 Priority Mail 3-Day 3 3.30 lbs $10.06 $8.00 $2.06
224331 2021-04-20 $32.68 First-Class Package Service 2 0.58 lbs $4.70 $4.20 $0.50
224332 2021-04-20 $19.16 USPSFirstClass 2 0.07 lbs $9.38 $3.49 $5.89
224333 2021-04-20 $8.16 USPSMedia 1 0.23 lbs $3.14 $2.89 $0.25
224335 2021-04-20 $14.95 First-Class Package Service 5 0.17 lbs $2.50 $3.69 $-1.19
224340 2021-04-20 $9.38 USPSFirstClass 1 0.03 lbs $4.49 $3.22 $1.27
224344 2021-04-20 $11.15 USPSFirstClass 2 0.14 lbs $4.37 $3.12 $1.25
224345 2020-12-11 $139.86 Priority Mail 3-Day Small Flat Rate Box 15 6.38 lbs $8.90 $19.30 $-10.40
224346 2021-04-20 $66.04 Priority Mail 3-Day 3 1.25 lbs $11.29 $10.44 $0.85
224347 2021-04-20 $7.69 First-Class Mail Stamped Letter 1 0.03 lbs $3.20 $3.49 $-0.29
224348 2021-04-20 $12.38 USPSFirstClass 1 0.06 lbs $4.59 $3.12 $1.47
224349 2021-04-20 $49.03 First Class International 8 0.36 lbs $26.51 $18.76 $7.75
224350 2021-04-20 $54.61 First-Class Package Service 1 0.56 lbs $4.62 $4.12 $0.50
224352 2021-04-20 $44.37 Priority Mail 2-Day 3 1.07 lbs $9.70 $8.85 $0.85
224353 2021-04-20 $13.98 First-Class Package Service 1 0.13 lbs $3.99 $3.49 $0.50
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56