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
210242 2020-03-15 $7.49 First-Class Mail Stamped Letter 1 0.11 lbs $3.50 $3.05 $0.45
210243 2020-03-15 $49.03 Priority Mail 2-Day 1 1.85 lbs $14.34 $11.13 $3.21
210244 2020-03-15 $40.96 Priority Mail 2-Day Flat Rate Envelope 4 0.73 lbs $8.00 $7.65 $0.35
210245 2020-03-15 $28.96 Priority Mail 2-Day Flat Rate Envelope 4 0.38 lbs $8.00 $7.65 $0.35
210246 2020-03-15 $20.47 Priority Mail 2-Day Flat Rate Envelope 3 0.34 lbs $8.00 $7.65 $0.35
210247 2020-03-15 $10.39 First-Class Package Service 1 0.30 lbs $8.00 $4.08 $3.92
210249 2020-03-15 $36.24 Priority Mail 2-Day 10 1.90 lbs $14.34 $13.49 $0.85
210250 2020-03-15 $18.45 First-Class Mail Stamped Letter 5 0.17 lbs $3.50 $2.78 $0.72
210252 2020-03-16 $255.40 Priority Mail 2-Day 11 10.25 lbs $0.00 $24.18 $-24.18
210253 2020-03-16 $21.99 Priority Mail 3-Day Flat Rate Envelope 1 0.23 lbs $8.00 $7.65 $0.35
210257 2020-03-16 $27.26 Priority Mail 2-Day 8 1.68 lbs $14.34 $13.20 $1.14
210258 2020-03-16 $6.33 First-Class Mail Stamped Letter 2 0.05 lbs $3.35 $2.93 $0.42
210260 2020-03-16 $48.20 First-Class Package Service 1 0.46 lbs $4.71 $4.46 $0.25
210264 2020-03-16 $10.91 First-Class Mail Stamped Letter 4 0.04 lbs $3.35 $3.18 $0.17
210270 2020-03-17 $13.82 First-Class Mail Stamped Letter 3 0.09 lbs $3.35 $2.78 $0.57
210271 2020-03-17 $10.34 First-Class Mail Stamped Letter 1 0.07 lbs $3.35 $2.78 $0.57
210272 2020-03-17 $8.54 First-Class Mail Stamped Letter 1 0.05 lbs $3.35 $2.84 $0.51
210273 2020-03-17 $36.79 Priority Mail 3-Day Flat Rate Envelope 1 1.00 lbs $8.00 $7.65 $0.35
210275 2020-03-17 $7.30 First-Class Mail Stamped Letter 5 0.06 lbs $3.35 $3.31 $0.04
210276 2020-03-17 $38.29 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $8.50 $7.65 $0.85
210277 2020-03-17 $68.14 Priority Mail 2-Day 18 4.68 lbs $19.32 $16.14 $3.18
210278 2020-03-17 $12.52 First-Class Package Service 1 0.20 lbs $4.63 $3.39 $1.24
210279 2020-03-17 $29.30 Priority Mail 2-Day 1 1.15 lbs $9.61 $8.76 $0.85
210282 2020-03-17 $62.69 Priority Mail International Padded Flat Rate Envelope 1 1.20 lbs $32.90 $33.60 $-0.70
210283 2020-03-17 $18.84 Priority Mail 2-Day Flat Rate Envelope 16 0.25 lbs $0.00 $7.65 $-7.65
210288 2020-03-18 $13.43 First-Class Package Service 2 0.34 lbs $4.45 $5.12 $-0.67
210290 2020-03-18 $36.82 Priority Mail 3-Day 9 2.83 lbs $15.01 $16.14 $-1.13
210291 2020-03-18 $26.39 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $8.00 $7.75 $0.25
210293 2020-03-18 $34.62 First-Class Package Service 1 0.45 lbs $4.63 $4.18 $0.45
210294 2020-03-18 $29.91 First-Class Mail Stamped Letter 9 0.13 lbs $3.50 $3.05 $0.45
210296 2020-03-18 $40.87 Priority Mail 2-Day Small Flat Rate Box 3 0.95 lbs $8.50 $7.65 $0.85
210297 2020-03-18 $54.68 Priority Mail 2-Day Large Flat Rate Box 17 3.27 lbs $19.15 $13.20 $5.95
210298 2020-03-18 $78.16 Priority Mail 3-Day 3 2.70 lbs $10.39 $8.92 $1.47
210299 2020-03-18 $9.33 First-Class Mail Stamped Letter 2 0.10 lbs $3.35 $2.84 $0.51
210300 2020-03-18 $200.16 Ground 6 8.40 lbs $0.00 $30.06 $-30.06
210302 2020-03-18 $17.48 First-Class Mail Stamped Letter 2 0.12 lbs $3.50 $2.93 $0.57
210303 2020-03-18 $15.46 First-Class Mail Stamped Letter 4 0.12 lbs $3.50 $2.76 $0.74
210304 2020-03-18 $74.68 Priority Mail 2-Day Flat Rate Envelope 2 2.10 lbs $8.00 $7.65 $0.35
210307 2020-03-18 $115.34 Priority Mail 3-Day 1 3.00 lbs $15.35 $9.50 $5.85
210309 2020-03-19 $335.27 Ground 109 28.85 lbs $55.26 $38.85 $16.41
210310 2020-03-19 $64.23 Priority Mail 2-Day 1 3.95 lbs $10.24 $9.39 $0.85
210312 2020-03-19 $6.57 First-Class Mail Stamped Letter 1 0.03 lbs $3.20 $2.74 $0.46
210313 2020-03-19 $7.19 First-Class Mail Stamped Letter 1 0.03 lbs $3.20 $2.84 $0.36
210315 2020-03-19 $12.64 First-Class Package Service 3 0.30 lbs $3.70 $3.25 $0.45
210317 2020-03-19 $9.91 First-Class Mail Stamped Letter 2 0.10 lbs $3.35 $2.74 $0.61
210318 2020-03-19 $13.46 First-Class Mail Stamped Letter 4 0.20 lbs $3.50 $2.93 $0.57
210320 2020-03-18 $10.59 Priority Mail 2-Day Flat Rate Envelope 1 0.37 lbs $0.00 $7.65 $-7.65
210321 2020-03-19 $13.60 First-Class Mail Stamped Letter 1 0.14 lbs $3.50 $2.93 $0.57
210322 2020-03-19 $22.38 First-Class Package Service 10 0.84 lbs $5.79 $3.52 $2.27
210324 2020-03-19 $8.95 First-Class Package Service 2 0.34 lbs $4.57 $4.32 $0.25
210326 2020-03-19 $57.45 Priority Mail 2-Day 10 1.00 lbs $9.61 $7.65 $1.96
210327 2020-03-19 $8.99 First-Class Mail Stamped Letter 1 0.10 lbs $3.50 $2.78 $0.72
210329 2020-03-19 $6.83 First-Class Mail Stamped Letter 2 0.08 lbs $3.35 $3.18 $0.17
210330 2020-03-19 $43.49 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $8.50 $7.65 $0.85
210332 2020-03-19 $17.48 First-Class Mail Stamped Letter 2 0.12 lbs $3.50 $2.93 $0.57
210333 2020-03-19 $12.32 First-Class Mail Stamped Letter 3 0.10 lbs $3.35 $2.78 $0.57
210334 2020-03-19 $30.19 Priority Mail 2-Day Flat Rate Envelope 1 0.45 lbs $8.00 $7.65 $0.35
210335 2020-03-19 $294.51 Ground Home Delivery 4 16.58 lbs $39.55 $33.39 $6.16
210338 2020-03-19 $7.34 First-Class Mail Stamped Letter 1 0.06 lbs $3.35 $2.78 $0.57
210340 2020-03-20 $94.58 Priority Mail 2-Day Padded Flat Rate Envelope 2 2.90 lbs $8.60 $8.21 $0.39
210341 2020-03-20 $239.04 Priority Mail International 4 5.00 lbs $72.38 $70.63 $1.75
210342 2020-03-20 $140.98 Priority Mail 2-Day 4 3.13 lbs $26.32 $14.18 $12.14
210343 2020-03-20 $33.24 Priority Mail 2-Day 10 2.00 lbs $14.34 $13.49 $0.85
210344 2020-03-20 $88.58 Priority Mail 2-Day Padded Flat Rate Envelope 2 4.70 lbs $8.60 $7.75 $0.85
210345 2020-03-20 $27.49 Priority Mail 3-Day Flat Rate Envelope 1 0.90 lbs $8.00 $7.75 $0.25
210348 2020-03-20 $60.78 Priority Mail 2-Day 2 1.70 lbs $13.00 $9.98 $3.02
210349 2020-03-20 $54.19 Priority Mail 3-Day Small Flat Rate Box 1 1.65 lbs $8.50 $7.65 $0.85
210350 2020-03-20 $51.49 Priority Mail 2-Day Small Flat Rate Box 1 1.55 lbs $8.50 $7.65 $0.85
210351 2020-03-20 $8.24 First-Class Mail Stamped Letter 1 0.05 lbs $3.35 $2.84 $0.51
210352 2020-03-20 $50.85 Priority Mail 1-Day Flat Rate Envelope 2 1.45 lbs $8.00 $7.65 $0.35
210353 2020-03-20 $51.49 Priority Mail 2-Day Small Flat Rate Box 1 1.55 lbs $8.50 $7.65 $0.85
210354 2020-03-20 $20.45 First-Class Mail Stamped Letter 5 0.16 lbs $3.50 $2.93 $0.57
210355 2020-03-20 $15.13 First-Class Package Service 4 0.50 lbs $4.77 $4.32 $0.45
210357 2020-03-20 $51.49 Priority Mail 2-Day Small Flat Rate Box 1 1.55 lbs $8.50 $7.65 $0.85
210359 2020-03-20 $23.45 First-Class Mail Stamped Letter 5 0.12 lbs $3.50 $2.84 $0.66
210360 2020-03-20 $73.30 Priority Mail 3-Day 1 3.90 lbs $19.31 $18.46 $0.85
210361 2020-03-20 $7.32 First-Class Mail Stamped Letter 3 0.06 lbs $3.35 $3.05 $0.30
210362 2020-03-20 $51.49 Priority Mail 3-Day Small Flat Rate Box 1 1.55 lbs $8.50 $7.65 $0.85
210363 2020-03-20 $36.60 First-Class Package Service 2 0.60 lbs $4.18 $3.93 $0.25
210364 2020-03-20 $51.49 Priority Mail 2-Day Small Flat Rate Box 1 1.50 lbs $8.50 $7.65 $0.85
210365 2020-03-20 $38.29 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $8.50 $7.65 $0.85
210366 2020-03-20 $51.49 Priority Mail 2-Day Small Flat Rate Box 1 1.55 lbs $8.50 $7.65 $0.85
210374 2020-03-20 $22.98 Priority Mail 2-Day Small Flat Rate Box 3 0.23 lbs $8.50 $7.65 $0.85
210376 2020-03-20 $43.49 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $8.50 $7.65 $0.85
210379 2020-03-20 $56.88 Priority Mail 3-Day 3 1.46 lbs $9.61 $8.92 $0.69
210380 2020-03-20 $56.14 Priority Mail 2-Day Flat Rate Envelope 6 1.65 lbs $8.00 $7.65 $0.35
210381 2020-03-20 $77.95 Priority Mail 2-Day 6 1.82 lbs $9.61 $9.48 $0.13
210383 2020-03-20 $47.97 Priority Mail 3-Day 2 1.24 lbs $9.61 $8.76 $0.85
210384 2020-03-21 $61.56 Priority Mail 2-Day Flat Rate Envelope 4 1.93 lbs $8.00 $7.65 $0.35
210386 2020-03-21 $57.23 Priority Mail 2-Day 5 0.94 lbs $9.61 $8.76 $0.85
210388 2020-03-21 $5.83 First-Class Package Service 1 0.38 lbs $3.84 $3.39 $0.45
210390 2020-03-21 $22.79 Priority Mail 2-Day Flat Rate Envelope 1 0.20 lbs $8.00 $7.80 $0.20
210391 2020-03-21 $54.17 Priority Mail 3-Day 2 1.50 lbs $11.39 $11.13 $0.26
210392 2020-03-21 $67.02 Priority Mail 2-Day Medium Flat Rate Box 3 2.05 lbs $14.45 $11.18 $3.27
210393 2020-03-21 $54.59 Priority Mail 2-Day 5 0.86 lbs $10.84 $9.99 $0.85
210394 2020-03-21 $7.74 First-Class Mail Stamped Letter 1 0.05 lbs $3.35 $2.78 $0.57
210395 2020-03-21 $17.96 Priority Mail 3-Day 1 0.95 lbs $8.97 $8.12 $0.85
210396 2020-03-21 $62.43 Priority Mail 2-Day Medium Flat Rate Box 2 7.10 lbs $14.45 $11.13 $3.32
210397 2020-03-21 $12.53 First-Class Mail Stamped Letter 2 0.07 lbs $3.35 $3.05 $0.30
210398 2020-03-21 $6.24 First-Class Mail Stamped Letter 1 0.03 lbs $3.35 $2.84 $0.51
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56