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
202267 2018-03-18 $9.91 First-Class Package Service 6 0.24 lbs $3.97 $3.05 $0.92
202270 2018-03-18 $16.09 First-Class Package Service 25 0.25 lbs $3.84 $2.66 $1.18
202271 2018-03-18 $182.74 Priority Mail 2-Day 2 13.35 lbs $26.56 $26.22 $0.34
202272 2018-03-18 $9.69 First-Class Package Service 2 0.07 lbs $3.71 $2.66 $1.05
202274 2018-03-18 $7.70 First-Class Package Service 1 0.10 lbs $3.71 $2.66 $1.05
202275 2018-03-18 $10.20 First-Class Package Service 1 0.06 lbs $3.71 $2.66 $1.05
202276 2018-03-19 $45.77 First-Class Package Service 2 0.75 lbs $5.79 $4.94 $0.85
202281 2018-03-19 $20.01 First-Class Mail Large Envelope 4 0.52 lbs $4.45 $3.66 $0.79
202283 2018-03-19 $78.83 Priority Mail 3-Day Medium Flat Rate Box 2 2.25 lbs $13.85 $10.80 $3.05
202286 2018-03-19 $28.31 Priority Mail 3-Day 1 0.60 lbs $10.32 $9.19 $1.13
202287 2018-03-19 $105.20 Priority Mail 2-Day Medium Flat Rate Box 5 3.51 lbs $13.85 $9.47 $4.38
202288 2018-03-19 $24.02 First-Class Mail Large Envelope 1 0.40 lbs $4.03 $3.50 $0.53
202290 2018-03-19 $11.83 First-Class Package Service 1 0.20 lbs $3.84 $3.34 $0.50
202291 2018-03-20 $26.89 First-Class Package Service 2 0.74 lbs $5.71 $4.66 $1.05
202293 2018-03-20 $36.17 Priority Mail 2-Day Flat Rate Envelope 3 0.76 lbs $7.40 $6.85 $0.55
202294 2018-03-20 $120.71 First-Class Package International Service 5 2.22 lbs $38.96 $48.93 $-9.97
202297 2018-03-20 $36.59 First-Class Package International Service 1 0.30 lbs $18.30 $13.30 $5.00
202298 2018-03-20 $146.86 First-Class Package International Service 7 2.75 lbs $53.93 $48.93 $5.00
202299 2018-03-20 $6.70 First-Class Package Service 1 0.00 lbs $3.71 $2.66 $1.05
202300 2018-03-20 $45.21 Priority Mail 1-Day Padded Flat Rate Envelope 2 1.35 lbs $7.95 $6.85 $1.10
202301 2018-03-20 $25.69 Priority Mail 3-Day Flat Rate Envelope 1 0.85 lbs $7.40 $6.90 $0.50
202303 2018-03-20 $22.54 First-Class Package Service 7 0.45 lbs $4.71 $4.38 $0.33
202306 2018-03-21 $55.18 Priority Mail 3-Day Flat Rate Envelope 2 1.50 lbs $7.40 $6.85 $0.55
202309 2018-03-21 $46.76 Priority Mail 3-Day Small Flat Rate Box 1 1.50 lbs $7.90 $6.85 $1.05
202311 2018-03-21 $10.70 First-Class Package Service 1 0.19 lbs $3.71 $2.66 $1.05
202312 2018-03-21 $64.58 First-Class Package International Service 1 1.50 lbs $27.33 $22.33 $5.00
202313 2018-03-21 $67.82 First-Class Package International Service 1 1.50 lbs $27.33 $22.33 $5.00
202314 2018-03-21 $67.82 First-Class Package International Service 1 1.50 lbs $27.33 $22.33 $5.00
202315 2018-03-21 $67.82 First-Class Package International Service 1 1.55 lbs $27.33 $22.33 $5.00
202316 2018-03-21 $67.82 First-Class Package International Service 1 1.45 lbs $27.33 $22.33 $5.00
202317 2018-03-21 $67.82 First-Class Package International Service 1 1.45 lbs $27.33 $22.33 $5.00
202318 2018-03-21 $64.58 First-Class Package International Service 1 1.50 lbs $27.33 $22.33 $5.00
202319 2018-03-21 $66.24 First-Class Package International Service 1 1.50 lbs $27.33 $22.33 $5.00
202320 2018-03-21 $67.82 First-Class Package International Service 1 1.50 lbs $27.33 $22.33 $5.00
202321 2018-03-21 $67.82 First-Class Package International Service 1 1.45 lbs $27.33 $22.33 $5.00
202322 2018-03-21 $67.82 First-Class Package International Service 1 1.55 lbs $27.33 $22.33 $5.00
202323 2018-03-21 $67.82 First-Class Package International Service 1 1.50 lbs $27.33 $22.33 $5.00
202324 2018-03-21 $67.82 First-Class Package International Service 1 1.55 lbs $27.33 $22.33 $5.00
202325 2018-03-21 $77.89 First-Class Package International Service 5 0.97 lbs $27.33 $22.33 $5.00
202326 2018-03-21 $19.48 First-Class Package International Service 2 0.16 lbs $14.50 $9.50 $5.00
202328 2018-03-21 $251.44 Priority Mail International 4 14.07 lbs $100.48 $93.48 $7.00
202332 2018-03-21 $46.57 Priority Mail 3-Day 4 0.96 lbs $8.61 $10.48 $-1.87
202342 2018-03-21 $98.32 Priority Mail 3-Day 8 2.23 lbs $14.00 $12.76 $1.24
202344 2018-03-21 $99.84 Priority Mail 2-Day Medium Flat Rate Box 1 10.70 lbs $13.85 $7.40 $6.45
202352 2018-03-22 $27.13 First-Class Package Service 7 0.51 lbs $5.15 $4.38 $0.77
202353 2018-03-22 $190.37 Priority Mail International 1 12.90 lbs $100.58 $93.58 $7.00
202358 2018-03-22 $81.49 Priority Mail 3-Day 2 2.50 lbs $13.01 $9.47 $3.54
202359 2018-03-22 $131.82 Priority Mail International 1 5.65 lbs $64.53 $63.79 $0.74
202361 2018-03-22 $37.14 Priority Mail 2-Day 1 0.95 lbs $11.65 $10.48 $1.17
202362 2018-03-22 $11.95 First-Class Package Service 2 0.28 lbs $3.97 $2.79 $1.18
202363 2018-03-22 $5.67 First-Class Package Service 4 0.04 lbs $3.71 $2.66 $1.05
202366 2018-03-23 $10.70 First-Class Package Service 1 0.19 lbs $3.71 $2.66 $1.05
202368 2018-03-23 $38.76 First-Class Package Service 3 0.75 lbs $5.99 $4.66 $1.33
202371 2018-03-23 $12.68 First-Class Package Service 3 0.10 lbs $3.71 $2.66 $1.05
202375 2018-03-23 $191.96 Priority Mail 2-Day 6 15.51 lbs $21.42 $20.85 $0.57
202376 2018-03-23 $25.69 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $7.40 $6.90 $0.50
202377 2018-03-23 $23.15 First-Class Package Service 6 0.08 lbs $3.71 $2.66 $1.05
202378 2018-03-23 $5.67 First-Class Package Service 4 0.04 lbs $3.71 $2.66 $1.05
202379 2018-03-23 $37.67 First-Class Package Service 11 0.75 lbs $5.23 $3.82 $1.41
202383 2018-03-24 $58.92 Priority Mail 2-Day 3 1.65 lbs $8.25 $7.40 $0.85
202384 2018-03-24 $35.39 Priority Mail 3-Day Flat Rate Envelope 1 1.20 lbs $7.40 $6.85 $0.55
202386 2018-03-24 $121.00 Priority Mail International 1 3.85 lbs $61.01 $60.28 $0.73
202388 2018-03-24 $105.85 Priority Mail 2-Day 4 3.49 lbs $11.19 $8.15 $3.04
202390 2018-03-24 $48.68 Priority Mail 2-Day Flat Rate Envelope 2 1.35 lbs $7.40 $6.85 $0.55
202394 2018-03-25 $42.12 First-Class Package Service 11 0.59 lbs $5.23 $4.10 $1.13
202398 2018-03-25 $26.63 First-Class Package Service 10 0.39 lbs $4.23 $3.50 $0.73
202400 2018-03-25 $45.43 Priority Mail 3-Day 8 1.76 lbs $10.11 $8.98 $1.13
202402 2018-03-25 $25.79 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $7.40 $6.85 $0.55
202404 2018-03-25 $64.38 First-Class Package International Service 2 0.82 lbs $27.33 $22.33 $5.00
202405 2018-03-25 $5.70 First-Class Package Service 1 0.01 lbs $3.71 $2.66 $1.05
202407 2018-03-25 $212.24 Priority Mail 2-Day 15 5.30 lbs $24.59 $23.03 $1.56
202408 2018-03-25 $10.70 First-Class Package Service 1 0.19 lbs $3.71 $2.66 $1.05
202409 2018-03-25 $45.79 Priority Mail 3-Day 1 1.20 lbs $9.00 $7.91 $1.09
202410 2018-03-26 $7.70 First-Class Package Service 1 0.05 lbs $3.71 $2.66 $1.05
202411 2018-03-26 $52.32 First-Class Package International Service 1 0.65 lbs $27.33 $22.33 $5.00
202413 2018-03-26 $14.44 First-Class Package Service 7 0.16 lbs $4.51 $3.18 $1.33
202414 2018-03-26 $6.70 First-Class Package Service 1 0.02 lbs $3.71 $2.66 $1.05
202415 2018-03-26 $181.24 Priority Mail 1-Day 19 7.73 lbs $10.57 $8.46 $2.11
202419 2018-03-27 $35.84 First-Class Package Service 9 0.55 lbs $5.43 $3.18 $2.25
202420 2018-03-27 $92.16 First-Class Package International Service 7 1.29 lbs $27.33 $22.33 $5.00
202421 2018-03-27 $101.65 First-Class Package International Service 6 2.26 lbs $38.01 $33.01 $5.00
202423 2018-03-27 $88.79 First-Class Package International Service 2 2.50 lbs $38.01 $48.93 $-10.92
202424 2018-03-27 $207.86 Priority Mail 3-Day 2 14.40 lbs $27.88 $27.52 $0.36
202428 2018-03-27 $23.21 Priority Mail 2-Day 4 0.95 lbs $11.65 $10.48 $1.17
202429 2018-03-27 $28.02 First-Class Package Service 13 0.52 lbs $5.15 $4.94 $0.21
202431 2018-03-27 $12.46 First-Class Package Service 1 0.45 lbs $4.67 $3.18 $1.49
202432 2018-03-27 $10.19 First-Class Package Service 2 0.06 lbs $3.71 $2.66 $1.05
202435 2018-03-27 $42.94 Priority Mail 2-Day Flat Rate Envelope 6 0.50 lbs $7.40 $20.96 $-13.56
202437 2018-03-27 $16.47 Priority Mail 3-Day 5 0.65 lbs $10.32 $9.19 $1.13
202438 2018-03-27 $71.49 Priority Mail 2-Day 1 3.60 lbs $11.50 $10.33 $1.17
202439 2018-03-27 $46.04 Priority Mail 2-Day 2 4.70 lbs $10.56 $7.40 $3.16
202440 2018-03-27 $18.89 First-Class Mail Large Envelope 6 0.54 lbs $4.45 $3.18 $1.27
202441 2018-03-28 $10.70 First-Class Package Service 1 0.07 lbs $3.71 $2.66 $1.05
202442 2018-03-28 $53.22 First-Class Mail Large Envelope 1 0.60 lbs $4.87 $4.94 $-0.07
202443 2018-03-28 $45.04 Priority Mail 2-Day 1 1.10 lbs $8.25 $7.18 $1.07
202445 2018-03-28 $35.86 Priority Mail 3-Day Flat Rate Envelope 4 0.56 lbs $7.40 $6.85 $0.55
202448 2018-03-28 $67.82 First-Class Package International Service 1 1.40 lbs $27.33 $22.33 $5.00
202449 2018-03-28 $25.04 First-Class Package Service 1 0.13 lbs $3.71 $2.79 $0.92
202450 2018-03-28 $197.42 Priority Mail 2-Day 48 3.63 lbs $11.50 $10.33 $1.17
202451 2018-03-28 $53.22 First-Class Mail Large Envelope 1 0.60 lbs $4.87 $4.94 $-0.07
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56