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
221348 2021-02-01 $10.99 First-Class Mail Stamped Letter 1 0.04 lbs $3.20 $3.06 $0.14
221349 2021-02-01 $13.39 First-Class Package Service 1 0.10 lbs $3.85 $3.69 $0.16
221352 2021-02-01 $19.14 First-Class Package Service 2 0.08 lbs $3.56 $3.06 $0.50
221353 2021-02-01 $8.91 First-Class Package Service 1 0.10 lbs $3.72 $4.38 $-0.66
221354 2021-02-01 $14.68 USPSFirstClass 1 0.06 lbs $4.94 $3.49 $1.45
221355 2021-02-01 $7.48 USPSFirstClass 1 0.10 lbs $4.59 $3.49 $1.10
221356 2021-02-01 $12.75 USPSFirstClass 2 0.02 lbs $4.65 $3.49 $1.16
221360 2021-02-01 $193.91 Ground Home Delivery 1 9.20 lbs $27.49 $22.01 $5.48
221362 2021-02-01 $39.94 Priority Mail 2-Day Flat Rate Envelope 2 1.35 lbs $8.25 $7.90 $0.35
221364 2021-02-01 $15.07 First-Class Package Service 1 0.30 lbs $4.08 $3.58 $0.50
221366 2021-02-01 $20.54 First-Class Package Service 1 0.16 lbs $3.82 $3.57 $0.25
221367 2021-02-01 $13.67 First-Class Mail Stamped Letter 3 0.09 lbs $3.20 $3.22 $-0.02
221368 2021-02-01 $14.68 USPSFirstClass 1 0.06 lbs $4.94 $3.49 $1.45
221369 2021-02-01 $22.68 USPSFirstClass 2 0.10 lbs $4.70 $3.58 $1.12
221370 2021-02-01 $15.80 First-Class Package Service 1 0.30 lbs $4.01 $3.51 $0.50
221371 2021-02-01 $21.47 First-Class Package Service 2 0.15 lbs $4.19 $3.35 $0.84
221373 2021-02-01 $305.91 Ground 1 14.05 lbs $65.92 $36.43 $29.49
221375 2021-02-01 $7.08 USPSFirstClass 1 0.07 lbs $4.29 $3.06 $1.23
221376 2021-02-01 $35.59 First-Class Mail Stamped Letter 1 0.17 lbs $3.60 $3.51 $0.09
221377 2021-02-02 $9.58 USPSFirstClass 1 0.03 lbs $4.69 $3.49 $1.20
221378 2021-02-02 $14.27 USPSFirstClass 2 0.10 lbs $4.49 $3.22 $1.27
221379 2021-02-01 $8.39 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.12 $0.08
221380 2021-02-01 $21.42 Priority Mail 3-Day Flat Rate Envelope 3 0.14 lbs $8.25 $7.90 $0.35
221381 2021-02-02 $18.84 USPSFirstClass 1 0.19 lbs $4.85 $3.51 $1.34
221384 2021-02-01 $12.17 First-Class Mail Stamped Letter 3 0.10 lbs $3.20 $3.12 $0.08
221385 2021-02-02 $16.87 USPSFirstClass 2 0.80 lbs $9.29 $11.01 $-1.72
221386 2021-02-01 $141.31 Priority Mail 2-Day 9 3.11 lbs $8.95 $7.83 $1.12
221387 2021-02-02 $7.28 USPSFirstClass 1 0.10 lbs $4.39 $3.22 $1.17
221388 2021-02-02 $21.89 USPSPriority 1 0.30 lbs $8.90 $7.90 $1.00
221391 2021-02-01 $17.79 First-Class Package Service 1 0.25 lbs $3.96 $3.46 $0.50
221392 2021-02-01 $10.18 First-Class Mail Stamped Letter 1 0.15 lbs $3.60 $3.01 $0.59
221393 2021-02-01 $13.78 First-Class Mail Stamped Letter 2 0.15 lbs $3.40 $3.22 $0.18
221397 2021-02-02 $137.74 USPSPriority 1 3.62 lbs $17.75 $9.21 $8.54
221398 2021-02-02 $31.07 First-Class Package Service 4 0.38 lbs $4.45 $4.20 $0.25
221401 2021-02-02 $38.54 Priority Mail 3-Day Small Flat Rate Box 1 1.30 lbs $8.75 $7.90 $0.85
221402 2021-02-02 $5.19 First-Class Mail Stamped Letter 1 0.03 lbs $3.20 $3.06 $0.14
221403 2021-02-02 $8.59 First-Class Mail Stamped Letter 1 0.15 lbs $3.40 $6.12 $-2.72
221405 2021-02-02 $32.86 First-Class Package Service 2 0.60 lbs $4.88 $4.38 $0.50
221406 2021-02-02 $14.43 USPSFirstClass 1 0.06 lbs $4.69 $3.12 $1.57
221408 2021-02-02 $6.99 First-Class Mail Stamped Letter 1 0.04 lbs $3.00 $3.22 $-0.22
221409 2021-02-02 $20.55 First-Class Package Service 1 0.16 lbs $3.83 $3.58 $0.25
221410 2021-02-02 $8.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.49 $-0.29
221411 2021-02-02 $10.18 First-Class Mail Stamped Letter 2 0.06 lbs $3.20 $3.12 $0.08
221412 2021-02-02 $26.95 First-Class Package Service 2 0.74 lbs $5.77 $5.27 $0.50
221414 2021-02-02 $9.18 First-Class Mail Stamped Letter 2 0.07 lbs $3.20 $3.35 $-0.15
221415 2021-02-02 $20.66 First-Class Package Service 1 0.16 lbs $3.94 $3.69 $0.25
221416 2021-02-02 $8.91 First-Class Package Service 1 0.05 lbs $3.72 $3.22 $0.50
221418 2021-02-02 $11.64 USPSFirstClass 1 0.06 lbs $4.65 $3.35 $1.30
221419 2021-02-02 $89.60 Priority Mail 2-Day Flat Rate Envelope 2 1.75 lbs $8.25 $7.90 $0.35
221421 2021-02-02 $8.59 First-Class Mail Stamped Letter 1 0.10 lbs $3.40 $3.35 $0.05
221423 2021-02-02 $10.41 First-Class Package Service 1 0.03 lbs $3.62 $3.12 $0.50
221427 2021-02-02 $17.05 First-Class Package Service 3 0.27 lbs $4.08 $3.58 $0.50
221428 2021-02-02 $14.43 USPSFirstClass 1 0.06 lbs $4.69 $3.12 $1.57
221429 2021-02-02 $26.43 USPSFirstClass 5 1.25 lbs $11.98 $7.83 $4.15
221430 2021-02-02 $38.64 Priority Mail 3-Day Padded Flat Rate Envelope 1 1.20 lbs $8.85 $7.90 $0.95
221431 2021-02-02 $36.10 First-Class Package Service 1 1.15 lbs $6.31 $7.90 $-1.59
221432 2021-02-02 $51.74 Priority Mail 2-Day Small Flat Rate Box 1 1.50 lbs $8.75 $7.90 $0.85
221434 2021-02-02 $7.48 USPSFirstClass 1 0.10 lbs $4.59 $3.49 $1.10
221435 2021-02-02 $51.60 First-Class Package Service 2 0.73 lbs $6.31 $4.53 $1.78
221437 2021-02-02 $65.49 Priority Mail 3-Day 5 1.85 lbs $12.54 $8.00 $4.54
221438 2021-02-02 $8.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.22 $-0.02
221440 2021-02-02 $9.18 First-Class Package Service 1 0.19 lbs $4.19 $3.35 $0.84
221442 2021-02-02 $12.69 First-Class Package Service 2 0.80 lbs $5.91 $5.66 $0.25
221444 2021-02-02 $31.85 Priority Mail 3-Day 1 1.10 lbs $11.86 $22.02 $-10.16
221445 2021-02-03 $12.33 USPSFirstClass 1 0.06 lbs $4.54 $3.06 $1.48
221447 2021-02-02 $17.06 First-Class Package Service 1 0.19 lbs $4.07 $3.57 $0.50
221448 2021-02-03 $17.69 USPSFirstClass 4 0.80 lbs $10.13 $10.44 $-0.31
221450 2021-02-03 $15.80 First-Class Package Service 1 0.25 lbs $4.01 $3.06 $0.95
221451 2021-02-03 $19.14 First-Class Package Service 5 0.18 lbs $4.19 $3.69 $0.50
221452 2021-02-03 $52.33 Priority Mail 3-Day 8 2.70 lbs $22.81 $18.96 $3.85
221454 2021-02-03 $51.74 Priority Mail 3-Day Small Flat Rate Box 1 1.50 lbs $8.75 $7.90 $0.85
221455 2021-02-03 $124.54 USPSPriority 1 3.00 lbs $14.55 $7.83 $6.72
221457 2021-02-03 $23.09 USPSFirstClass 2 0.53 lbs $9.71 $5.27 $4.44
221459 2021-02-03 $8.55 USPSFirstClass 1 0.01 lbs $4.50 $3.35 $1.15
221460 2021-02-03 $17.22 Priority Mail 3-Day Flat Rate Envelope 3 0.10 lbs $8.25 $7.90 $0.35
221462 2021-02-03 $90.25 Priority Mail 3-Day Flat Rate Envelope 2 3.62 lbs $8.25 $8.00 $0.25
221463 2021-02-03 $19.87 Priority Mail 2-Day 3 1.20 lbs $9.70 $9.01 $0.69
221464 2021-02-03 $14.84 USPSFirstClass 3 0.09 lbs $4.37 $3.12 $1.25
221466 2021-02-03 $7.68 First-Class Mail Stamped Letter 2 0.06 lbs $3.20 $6.98 $-3.78
221467 2021-02-03 $12.18 USPSFirstClass 1 0.06 lbs $4.39 $3.01 $1.38
221468 2021-02-03 $25.81 First-Class Package Service - Retail 4 0.15 lbs $6.05 $3.85 $2.20
221469 2021-02-03 $7.98 First-Class Package Service 1 0.07 lbs $3.99 $3.49 $0.50
221473 2021-02-03 $63.04 Priority Mail 2-Day 1 3.95 lbs $9.05 $8.20 $0.85
221474 2021-02-03 $23.49 Priority Mail 3-Day Flat Rate Envelope 6 1.14 lbs $8.25 $7.90 $0.35
221476 2021-02-03 $17.19 First-Class Mail Stamped Letter 1 0.06 lbs $3.20 $3.06 $0.14
221479 2021-02-04 $12.33 USPSFirstClass 1 0.06 lbs $4.54 $3.06 $1.48
221480 2021-02-03 $36.30 Priority Mail 2-Day 6 1.03 lbs $11.86 $11.01 $0.85
221481 2021-02-03 $13.23 Priority Mail 2-Day Flat Rate Envelope 2 0.40 lbs $8.25 $8.00 $0.25
221483 2021-02-04 $7.08 USPSFirstClass 1 0.06 lbs $4.29 $3.06 $1.23
221484 2021-02-04 $12.43 USPSFirstClass 1 0.06 lbs $4.64 $3.22 $1.42
221485 2021-02-04 $79.26 Priority Mail 2-Day Flat Rate Envelope 2 1.76 lbs $8.25 $7.90 $0.35
221486 2021-02-04 $10.85 USPSFirstClass 1 0.06 lbs $4.75 $3.49 $1.26
221488 2021-02-04 $39.83 USPSFirstClass 1 0.25 lbs $5.71 $3.46 $2.25
221490 2021-02-04 $9.75 USPSFirstClass 1 0.05 lbs $4.56 $3.35 $1.21
221491 2021-02-04 $17.19 First-Class Package Service 1 0.45 lbs $4.70 $4.20 $0.50
221492 2021-02-04 $26.95 First-Class Package Service 2 0.74 lbs $5.77 $5.27 $0.50
221493 2021-02-04 $5.19 USPSFirstClass 1 0.02 lbs $4.20 $3.06 $1.14
221494 2021-02-04 $50.90 Priority Mail 3-Day Flat Rate Envelope 1 1.15 lbs $8.25 $8.00 $0.25
221496 2021-02-04 $28.34 USPSFirstClass 1 0.15 lbs $5.40 $3.58 $1.82
221498 2021-02-04 $104.14 USPSPriority 1 5.30 lbs $34.15 $13.75 $20.40
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56