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
222451 2021-02-21 $98.69 USPSPriority 1 1.44 lbs $19.18 $7.90 $11.28
222452 2021-02-21 $11.41 USPSFirstClass 1 0.05 lbs $4.64 $3.35 $1.29
222453 2021-02-21 $9.90 USPSFirstClass 1 0.06 lbs $4.57 $3.35 $1.22
222454 2021-02-21 $14.16 USPSFirstClass 1 0.10 lbs $4.67 $3.12 $1.55
222455 2021-02-21 $14.21 USPSFirstClass 1 0.10 lbs $4.72 $3.22 $1.50
222456 2021-02-21 $31.75 USPSFirstClass 3 1.16 lbs $14.38 $10.44 $3.94
222457 2021-02-21 $16.68 USPSFirstClass 1 0.10 lbs $4.89 $3.69 $1.20
222458 2021-02-21 $31.48 USPSPriority 1 3.10 lbs $12.69 $8.34 $4.35
222459 2021-02-21 $8.88 First-Class Package Service 2 0.38 lbs $4.70 $3.57 $1.13
222460 2021-02-21 $8.97 First-Class Package Service 2 0.02 lbs $3.99 $3.49 $0.50
222461 2021-02-21 $6.81 USPSFirstClass 1 0.01 lbs $4.32 $3.12 $1.20
222462 2021-02-21 $8.44 USPSFirstClass 1 0.05 lbs $4.45 $3.22 $1.23
222464 2021-02-21 $26.04 USPSFirstClass 4 0.25 lbs $4.72 $3.49 $1.23
222468 2021-02-21 $8.59 First-Class Mail Stamped Letter 1 0.10 lbs $3.40 $3.35 $0.05
222469 2021-02-21 $13.78 First-Class Mail Stamped Letter 2 0.15 lbs $3.40 $3.06 $0.34
222470 2021-02-21 $32.08 Priority Mail 2-Day 1 0.85 lbs $9.09 $5.27 $3.82
222471 2021-02-21 $7.18 USPSFirstClass 1 0.10 lbs $4.29 $3.06 $1.23
222472 2021-02-21 $7.48 USPSFirstClass 1 0.10 lbs $4.59 $3.49 $1.10
222473 2021-02-21 $9.92 First-Class Package Service 1 0.42 lbs $4.93 $4.68 $0.25
222474 2021-02-21 $6.29 First-Class Mail Stamped Letter 1 0.10 lbs $3.40 $3.49 $-0.09
222475 2021-02-21 $25.97 First-Class Package Service 1 0.85 lbs $6.48 $5.98 $0.50
222477 2021-02-21 $25.44 USPSFirstClass 1 0.03 lbs $5.45 $3.49 $1.96
222478 2021-02-21 $16.04 Priority Mail 2-Day Flat Rate Envelope 1 0.04 lbs $8.25 $7.67 $0.58
222479 2021-02-21 $19.57 First-Class Package Service 1 0.35 lbs $4.78 $4.53 $0.25
222481 2021-02-21 $8.99 First-Class Mail Stamped Letter 1 0.01 lbs $3.00 $3.12 $-0.12
222482 2021-02-22 $6.91 USPSFirstClass 1 0.01 lbs $4.42 $3.35 $1.07
222484 2021-02-21 $15.15 First-Class Package Service 3 0.30 lbs $4.78 $4.53 $0.25
222487 2021-02-21 $10.48 First-Class Mail Stamped Letter 2 0.11 lbs $3.40 $3.35 $0.05
222488 2021-02-21 $10.51 First-Class Package Service 1 0.03 lbs $3.72 $3.22 $0.50
222489 2021-02-21 $22.85 First-Class Package Service 1 0.35 lbs $4.01 $3.51 $0.50
222491 2021-02-21 $28.28 First-Class Package Service 2 0.60 lbs $4.70 $4.20 $0.50
222493 2021-02-21 $9.99 First-Class Package Service - Retail 1 0.02 lbs $5.00 $3.06 $1.94
222495 2021-02-21 $18.98 First-Class Package Service 1 0.20 lbs $4.19 $3.35 $0.84
222496 2021-02-21 $473.22 Ground Home Delivery 5 29.15 lbs $46.76 $27.23 $19.53
222497 2021-02-22 $38.65 Priority Mail 2-Day 2 3.45 lbs $10.06 $8.00 $2.06
222499 2021-02-22 $35.53 Priority Mail 2-Day 1 0.85 lbs $12.54 $8.80 $3.74
222500 2021-02-22 $210.19 USPSPriority 1 9.20 lbs $30.20 $11.76 $18.44
222501 2021-02-22 $12.63 USPSFirstClass 1 0.06 lbs $4.84 $3.49 $1.35
222502 2021-02-22 $45.09 USPSFirstClass 1 0.25 lbs $6.10 $3.51 $2.59
222503 2021-02-22 $7.33 USPSFirstClass 1 0.10 lbs $4.44 $3.35 $1.09
222504 2021-02-22 $14.39 USPSFirstClass 1 0.31 lbs $5.40 $3.57 $1.83
222505 2021-02-22 $7.48 USPSFirstClass 1 0.10 lbs $4.59 $3.49 $1.10
222506 2021-02-22 $27.57 USPSPriority 1 7.00 lbs $16.55 $10.37 $6.18
222507 2021-02-22 $11.14 First-Class Package Service 1 0.06 lbs $3.85 $3.35 $0.50
222508 2021-02-22 $6.39 First-Class Mail Stamped Letter 1 0.15 lbs $3.40 $3.06 $0.34
222511 2021-02-22 $16.62 USPSFirstClass 3 0.15 lbs $4.65 $3.49 $1.16
222513 2021-02-22 $5.49 First-Class Mail Stamped Letter 1 0.01 lbs $3.00 $3.06 $-0.06
222514 2021-02-22 $30.10 Priority Mail 2-Day 4 0.65 lbs $12.54 $8.00 $4.54
222515 2021-02-22 $145.07 Priority Mail 3-Day 1 3.95 lbs $17.72 $15.47 $2.25
222517 2021-02-22 $7.62 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.22 $-0.02
222518 2021-02-22 $35.37 USPSPriority 1 1.90 lbs $14.92 $14.10 $0.82
222519 2021-02-22 $8.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.35 $-0.15
222520 2021-02-22 $58.84 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.31 lbs $8.85 $8.00 $0.85
222521 2021-02-22 $80.03 Priority Mail 3-Day Flat Rate Envelope 2 2.75 lbs $8.25 $7.90 $0.35
222522 2021-02-22 $6.91 USPSFirstClass 1 0.01 lbs $4.42 $3.35 $1.07
222523 2021-02-22 $16.49 First-Class Package Service 2 0.62 lbs $5.91 $5.66 $0.25
222526 2021-02-23 $11.60 USPSFirstClass 2 0.06 lbs $4.62 $3.49 $1.13
222527 2021-02-22 $38.54 Priority Mail 3-Day Small Flat Rate Box 1 1.30 lbs $8.75 $7.90 $0.85
222528 2021-02-22 $20.67 First-Class Package Service 1 0.40 lbs $5.18 $3.85 $1.33
222532 2021-02-22 $0.99 First-Class Package Service 1 0.01 lbs $0.00 $3.49 $-3.49
222534 2021-02-22 $14.06 First-Class Package Service 6 0.14 lbs $3.62 $3.12 $0.50
222535 2021-02-22 $19.18 Priority Mail 3-Day Flat Rate Envelope 7 0.07 lbs $8.25 $7.90 $0.35
222538 2021-02-23 $14.41 USPSFirstClass 1 0.10 lbs $4.92 $3.49 $1.43
222539 2021-02-23 $9.43 USPSFirstClass 1 0.03 lbs $4.54 $3.35 $1.19
222540 2021-02-23 $9.90 USPSFirstClass 1 0.06 lbs $4.57 $3.35 $1.22
222541 2021-02-23 $12.33 USPSFirstClass 1 0.06 lbs $4.54 $3.06 $1.48
222542 2021-02-23 $31.34 USPSFirstClass 4 1.40 lbs $11.78 $8.85 $2.93
222543 2021-02-23 $21.48 USPSFirstClass 1 0.35 lbs $5.59 $3.46 $2.13
222544 2021-02-23 $33.14 USPSFirstClass 1 0.89 lbs $9.44 $5.27 $4.17
222547 2021-02-23 $148.58 Ground 4 16.39 lbs $38.11 $20.94 $17.17
222549 2021-02-23 $23.21 Priority Mail 3-Day Flat Rate Envelope 4 0.83 lbs $8.25 $7.90 $0.35
222550 2021-02-23 $20.38 USPSPriority 1 1.10 lbs $10.59 $8.24 $2.35
222551 2021-02-23 $8.39 First-Class Mail Stamped Letter 1 0.07 lbs $3.40 $3.12 $0.28
222552 2021-02-23 $13.38 First-Class Mail Stamped Letter 2 0.10 lbs $3.40 $3.35 $0.05
222553 2021-02-23 $44.61 First-Class Package Service 1 0.60 lbs $4.62 $4.12 $0.50
222554 2021-02-23 $11.15 First-Class Mail Stamped Letter 5 0.06 lbs $3.20 $3.49 $-0.29
222555 2021-02-23 $129.26 Priority Mail 2-Day 2 3.54 lbs $11.28 $9.01 $2.27
222557 2021-02-23 $13.69 USPSFirstClass 1 0.05 lbs $4.70 $3.58 $1.12
222558 2021-02-23 $17.84 First-Class Package Service 1 0.06 lbs $3.85 $3.35 $0.50
222559 2021-02-23 $20.71 USPSFirstClass 3 0.19 lbs $4.72 $3.49 $1.23
222561 2021-02-23 $9.35 First-Class Package Service 2 0.40 lbs $4.37 $4.12 $0.25
222566 2021-02-23 $4.98 First-Class Mail Stamped Letter 2 0.02 lbs $3.00 $3.35 $-0.35
222567 2021-02-23 $31.83 First-Class Package Service 5 0.26 lbs $4.08 $3.58 $0.50
222568 2021-02-23 $192.34 Priority Mail 3-Day Medium Flat Rate Box 5 6.65 lbs $15.00 $12.32 $2.68
222569 2021-02-23 $8.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.12 $0.08
222570 2021-02-23 $21.54 First-Class Package Service 2 0.52 lbs $4.70 $4.20 $0.50
222571 2021-02-24 $25.18 First-Class Package Service 1 0.35 lbs $4.19 $3.69 $0.50
222572 2021-02-24 $17.14 First-Class Mail Stamped Letter 6 0.08 lbs $3.20 $3.49 $-0.29
222573 2021-02-24 $19.89 First-Class Package Service 2 0.55 lbs $5.91 $4.38 $1.53
222575 2021-02-24 $13.38 First-Class Mail Stamped Letter 2 0.12 lbs $3.40 $3.06 $0.34
222576 2021-02-24 $7.33 USPSFirstClass 1 0.10 lbs $4.44 $3.35 $1.09
222577 2021-02-24 $33.93 USPSPriority 1 3.10 lbs $15.14 $8.00 $7.14
222578 2021-02-24 $14.38 USPSFirstClass 4 0.04 lbs $4.42 $3.35 $1.07
222581 2021-02-24 $25.43 First-Class Package Service 2 0.53 lbs $4.45 $4.20 $0.25
222582 2021-02-24 $22.73 USPSFirstClass 2 0.10 lbs $4.75 $3.69 $1.06
222583 2021-02-24 $27.53 USPSFirstClass 2 1.00 lbs $9.55 $11.63 $-2.08
222584 2021-02-24 $12.48 USPSFirstClass 1 0.06 lbs $4.69 $3.35 $1.34
222585 2021-02-24 $9.70 USPSFirstClass 1 0.06 lbs $4.37 $3.03 $1.34
222586 2021-02-24 $8.23 USPSFirstClass 2 0.16 lbs $4.25 $3.06 $1.19
222587 2021-02-24 $21.47 USPSFirstClass 4 0.63 lbs $9.87 $4.04 $5.83
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56