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.

21025 matching order(s)

Order ID ▲DateOrder TotalShipping Method# ProductsTotal WeightShipping ChargedShipping PaidProfit
217198 2020-11-02 $13.64 USPSFirstClass 1 0.05 lbs $4.65 $3.43 $1.22
217201 2020-11-02 $15.64 First-Class Mail Stamped Letter 1 0.17 lbs $3.65 $3.56 $0.09
217206 2020-11-02 $24.01 First-Class Package International Service 2 0.01 lbs $22.03 $13.78 $8.25
217208 2020-11-02 $51.89 Priority Mail 2-Day Small Flat Rate Box 1 1.55 lbs $8.90 $7.90 $1.00
217209 2020-11-02 $167.60 Priority Mail 3-Day Medium Flat Rate Box 5 20.15 lbs $14.85 $13.75 $1.10
217211 2020-11-02 $15.21 First-Class Package Service 1 0.20 lbs $3.75 $4.25 $-0.50
217212 2020-11-02 $18.35 First-Class Package Service 2 0.38 lbs $4.37 $3.92 $0.45
217213 2020-11-02 $13.83 First-Class Package Service 2 0.24 lbs $3.95 $3.03 $0.92
217214 2020-11-02 $11.69 First-Class Package Service 3 0.44 lbs $5.02 $3.77 $1.25
217215 2020-11-02 $7.32 First-Class Mail Stamped Letter 3 0.06 lbs $3.35 $3.03 $0.32
217218 2020-11-03 $13.04 First-Class Package Service 1 0.30 lbs $4.37 $3.92 $0.45
217222 2020-11-03 $96.42 Priority Mail 2-Day 21 5.29 lbs $15.43 $12.25 $3.18
217223 2020-11-03 $4.19 First-Class Mail Stamped Letter 1 0.01 lbs $3.20 $3.03 $0.17
217225 2020-11-03 $104.50 Priority Mail 2-Day 1 12.90 lbs $0.00 $11.76 $-11.76
217228 2020-11-03 $18.20 First-Class Package Service 2 0.38 lbs $4.22 $3.30 $0.92
217231 2020-11-03 $38.69 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $8.90 $8.05 $0.85
217234 2020-11-03 $136.18 Priority Mail 2-Day 1 8.10 lbs $15.04 $10.16 $4.88
217235 2020-11-03 $34.86 First-Class Package Service 2 0.48 lbs $4.88 $4.43 $0.45
217240 2020-11-03 $13.74 First-Class Package Service 1 0.25 lbs $3.95 $4.25 $-0.30
217243 2020-11-03 $20.69 Priority Mail 2-Day Small Flat Rate Box 1 0.30 lbs $8.90 $8.05 $0.85
217244 2020-11-03 $23.05 First-Class Package Service 3 0.40 lbs $4.78 $3.56 $1.22
217245 2020-11-04 $9.98 USPSFirstClass 1 0.02 lbs $4.30 $3.30 $1.00
217247 2020-11-04 $99.85 Priority Mail 2-Day 16 3.04 lbs $17.31 $16.06 $1.25
217248 2020-11-04 $10.53 USPSFirstClass 1 0.10 lbs $4.46 $3.43 $1.03
217249 2020-11-04 $106.64 Priority Mail 2-Day 6 5.61 lbs $20.00 $12.25 $7.75
217251 2020-11-04 $7.19 First-Class Mail Stamped Letter 1 0.03 lbs $3.20 $3.30 $-0.10
217252 2020-11-04 $5.11 USPSFirstClass 1 0.01 lbs $4.05 $3.18 $0.87
217253 2020-11-04 $9.71 First-Class Package Service 1 0.15 lbs $4.22 $3.77 $0.45
217257 2020-11-04 $13.83 First-Class Package Service 4 0.26 lbs $4.37 $3.43 $0.94
217258 2020-11-04 $23.07 First-Class Package Service 1 0.30 lbs $4.78 $3.56 $1.22
217260 2020-11-04 $59.82 Priority Mail 3-Day 2 2.00 lbs $9.84 $8.99 $0.85
217262 2020-11-04 $46.89 Priority Mail 2-Day Small Flat Rate Box 1 8.94 lbs $8.90 $8.05 $0.85
217263 2020-11-04 $15.32 First-Class Package Service - Retail 3 0.15 lbs $4.85 $2.93 $1.92
217264 2020-11-04 $21.19 First-Class Package Service 11 0.69 lbs $6.40 $4.68 $1.72
217266 2020-11-04 $12.02 First-Class Package Service 7 0.18 lbs $4.09 $3.64 $0.45
217268 2020-11-04 $22.38 First-Class Package Service 1 0.30 lbs $4.09 $3.64 $0.45
217269 2020-11-04 $18.94 First-Class Package Service 1 0.36 lbs $3.95 $3.50 $0.45
217270 2020-11-04 $24.69 Priority Mail 2-Day Flat Rate Envelope 1 0.41 lbs $8.40 $8.05 $0.35
217271 2020-11-04 $15.78 Priority Mail 2-Day Small Flat Rate Box 2 0.06 lbs $8.90 $8.05 $0.85
217274 2020-11-05 $5.69 First-Class Mail Stamped Letter 1 0.01 lbs $3.20 $3.03 $0.17
217275 2020-11-05 $18.86 First-Class Package Service 1 0.41 lbs $4.78 $4.33 $0.45
217280 2020-11-05 $10.46 USPSFirstClass 2 0.34 lbs $4.87 $4.33 $0.54
217281 2020-11-05 $19.10 First-Class Package Service 1 0.41 lbs $5.02 $4.57 $0.45
217283 2020-11-05 $15.71 USPSFirstClass 1 0.30 lbs $5.21 $3.56 $1.65
217284 2020-11-05 $21.59 Priority Mail 2-Day Flat Rate Envelope 1 0.80 lbs $8.40 $7.55 $0.85
217285 2020-11-05 $25.00 First-Class Package Service 2 0.31 lbs $4.22 $3.77 $0.45
217286 2020-11-05 $26.65 First-Class Package Service 1 0.15 lbs $3.71 $2.99 $0.72
217287 2020-11-05 $14.49 First-Class Mail Stamped Letter 1 0.10 lbs $3.50 $3.09 $0.41
217288 2020-11-05 $26.79 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $8.40 $8.15 $0.25
217289 2020-11-05 $7.18 USPSFirstClass 1 0.10 lbs $4.04 $3.03 $1.01
217290 2020-11-05 $22.66 First-Class Package Service 1 0.30 lbs $4.37 $3.92 $0.45
217291 2020-11-05 $8.54 First-Class Mail Stamped Letter 1 0.08 lbs $3.35 $3.09 $0.26
217292 2020-11-05 $40.57 First-Class Package Service 5 0.75 lbs $5.62 $5.37 $0.25
217293 2020-11-05 $229.42 Priority Mail 2-Day Medium Flat Rate Box 20 5.39 lbs $14.85 $11.53 $3.32
217294 2020-11-06 $9.40 USPSFirstClass 1 0.45 lbs $5.08 $3.77 $1.31
217295 2020-11-06 $10.12 USPSFirstClass 2 0.10 lbs $4.14 $3.18 $0.96
217297 2020-11-05 $9.34 First-Class Package Service 2 0.38 lbs $5.16 $3.92 $1.24
217298 2020-11-05 $11.80 Priority Mail 3-Day 1 0.03 lbs $8.81 $8.05 $0.76
217300 2020-11-05 $6.19 First-Class Mail Stamped Letter 1 0.02 lbs $3.20 $3.09 $0.11
217301 2020-11-06 $16.72 USPSFirstClass 1 0.05 lbs $4.60 $3.30 $1.30
217303 2020-11-06 $5.02 USPSFirstClass 1 0.01 lbs $3.95 $3.03 $0.92
217304 2020-11-05 $35.13 Priority Mail 2-Day Small Flat Rate Box 1 1.00 lbs $8.90 $8.05 $0.85
217305 2020-11-06 $11.73 USPSFirstClass 1 0.05 lbs $4.54 $3.43 $1.11
217306 2020-11-05 $22.56 First-Class Package Service 1 0.80 lbs $5.90 $4.43 $1.47
217307 2020-11-06 $12.20 USPSFirstClass 1 0.19 lbs $4.25 $3.03 $1.22
217309 2020-11-05 $9.14 First-Class Mail Stamped Letter 1 0.15 lbs $3.65 $3.30 $0.35
217311 2020-11-06 $189.30 Priority Mail 2-Day Medium Flat Rate Box 14 10.62 lbs $28.45 $21.14 $7.31
217313 2020-11-06 $19.29 First-Class Mail Stamped Letter 3 0.18 lbs $3.65 $3.43 $0.22
217316 2020-11-06 $11.80 USPSFirstClass 1 0.05 lbs $4.34 $3.64 $0.70
217317 2020-11-06 $52.64 First-Class Package Service 2 0.80 lbs $6.10 $5.65 $0.45
217318 2020-11-06 $25.69 First-Class Package Service 1 0.40 lbs $4.70 $4.25 $0.45
217319 2020-11-06 $37.29 Priority Mail 3-Day Small Flat Rate Box 1 1.25 lbs $8.90 $8.05 $0.85
217321 2020-11-06 $21.82 First-Class Package Service 5 0.25 lbs $4.37 $3.18 $1.19
217322 2020-11-06 $33.98 Priority Mail 2-Day 1 2.30 lbs $10.79 $9.94 $0.85
217326 2020-11-06 $32.39 Priority Mail 2-Day Flat Rate Envelope 1 1.00 lbs $8.40 $8.15 $0.25
217327 2020-11-06 $36.46 First-Class Package Service 1 0.25 lbs $4.17 $3.92 $0.25
217329 2020-11-06 $8.69 First-Class Mail Stamped Letter 1 0.15 lbs $3.50 $3.30 $0.20
217330 2020-07-15 $793.90 Priority Mail 2-Day 20 32.45 lbs $0.00 $51.30 $-51.30
217331 2020-11-06 $9.94 First-Class Mail Stamped Letter 6 0.10 lbs $3.50 $3.43 $0.07
217333 2020-11-06 $22.48 Priority Mail 3-Day Flat Rate Envelope 1 0.41 lbs $8.40 $8.05 $0.35
217334 2020-11-07 $11.39 Priority Mail 3-Day Flat Rate Envelope 1 0.03 lbs $8.40 $8.05 $0.35
217335 2020-11-07 $16.94 First-Class Package Service 1 0.19 lbs $3.95 $3.50 $0.45
217336 2020-11-07 $23.33 USPSFirstClass 1 0.60 lbs $6.41 $5.79 $0.62
217337 2020-11-07 $9.60 USPSFirstClass 1 0.05 lbs $4.24 $3.18 $1.06
217338 2020-11-07 $147.56 Priority Mail 2-Day 15 4.53 lbs $25.77 $64.58 $-38.81
217340 2020-11-07 $48.01 Priority Mail 2-Day 2 1.27 lbs $10.01 $9.16 $0.85
217342 2020-11-07 $26.89 First-Class Package Service 1 0.40 lbs $4.70 $4.25 $0.45
217343 2020-11-07 $24.53 USPSFirstClass 1 0.15 lbs $5.10 $3.43 $1.67
217345 2020-11-07 $9.28 First-Class Package Service 2 0.34 lbs $4.50 $4.25 $0.25
217346 2020-11-07 $30.46 First-Class Package Service 2 0.37 lbs $4.68 $4.43 $0.25
217347 2020-11-07 $42.53 Priority Mail 1-Day Flat Rate Envelope 3 1.25 lbs $8.40 $8.05 $0.35
217348 2020-11-07 $9.54 USPSFirstClass 1 0.02 lbs $4.20 $3.09 $1.11
217349 2020-11-07 $463.22 Priority Mail 2-Day Large Flat Rate Box 9 15.75 lbs $36.80 $18.70 $18.10
217350 2020-11-07 $11.66 USPSFirstClass 1 0.19 lbs $4.25 $3.03 $1.22
217351 2020-11-07 $11.27 USPSFirstClass 1 0.02 lbs $4.14 $2.99 $1.15
217352 2020-11-07 $37.88 Priority Mail 2-Day Flat Rate Envelope 2 1.00 lbs $8.40 $8.00 $0.40
217353 2020-11-07 $18.81 First-Class Package Service 2 0.08 lbs $3.75 $3.30 $0.45
217354 2020-11-07 $4.69 First-Class Package Service 1 0.24 lbs $4.68 $3.18 $1.50
217355 2020-11-07 $22.15 First-Class Package Service 1 0.35 lbs $4.37 $3.92 $0.45
217356 2020-11-07 $9.97 USPSFirstClass 1 0.02 lbs $4.20 $3.09 $1.11
Total 21025 order(s) 59971 29292.14 lbs $193562.51 $270247.54 $-76685.03