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
206485 2019-04-18 $34.70 Priority Mail 3-Day Small Flat Rate Box 1 1.15 lbs $8.35 $7.50 $0.85
206486 2019-04-18 $20.99 Priority Mail 2-Day 6 1.30 lbs $10.55 $9.70 $0.85
206487 2019-04-18 $107.66 Priority Mail 2-Day 20 9.00 lbs $20.36 $21.31 $-0.95
206488 2019-04-18 $44.01 Priority Mail 3-Day 7 1.03 lbs $11.08 $10.23 $0.85
206489 2019-04-19 $6.88 First-Class Package Service 1 0.02 lbs $3.89 $2.84 $1.05
206491 2019-04-19 $18.66 First-Class Package Service 2 0.38 lbs $4.68 $3.09 $1.59
206492 2019-04-19 $44.69 Priority Mail 3-Day 1 1.20 lbs $11.71 $10.86 $0.85
206495 2019-04-19 $21.50 Priority Mail 3-Day 5 0.95 lbs $10.55 $9.70 $0.85
206498 2019-04-19 $32.59 Priority Mail 2-Day 14 1.25 lbs $8.73 $8.12 $0.61
206503 2019-04-20 $21.90 First-Class Package Service 1 0.45 lbs $4.41 $4.06 $0.35
206504 2019-04-20 $10.99 First-Class Package Service 2 0.06 lbs $4.01 $2.96 $1.05
206506 2019-04-20 $38.53 Priority Mail 2-Day 3 2.40 lbs $18.46 $17.61 $0.85
206507 2019-04-21 $70.95 Priority Mail 2-Day Flat Rate Envelope 5 1.62 lbs $7.80 $7.50 $0.30
206508 2019-04-21 $13.87 First-Class Package Service 14 0.17 lbs $4.01 $4.19 $-0.18
206509 2019-04-21 $16.48 First-Class Package Service 6 0.21 lbs $4.54 $4.19 $0.35
206512 2019-04-21 $8.59 First-Class Package Service 2 0.38 lbs $4.41 $3.36 $1.05
206514 2019-04-21 $29.68 First-Class Package Service 10 0.53 lbs $5.24 $4.19 $1.05
206518 2019-04-22 $56.36 Priority Mail 2-Day Flat Rate Envelope 24 1.83 lbs $7.80 $7.55 $0.25
206520 2019-04-22 $14.90 First-Class Package Service 11 0.12 lbs $4.01 $2.96 $1.05
206522 2019-04-22 $8.88 First-Class Package Service 1 0.07 lbs $3.89 $3.36 $0.53
206524 2019-04-22 $37.50 First-Class Package International Service 4 0.26 lbs $21.54 $13.54 $8.00
206526 2019-04-23 $23.76 Ground 4 0.80 lbs $13.80 $11.69 $2.11
206527 2019-04-23 $19.00 First-Class Package Service 1 0.18 lbs $4.01 $3.49 $0.52
206529 2019-04-23 $35.23 First-Class Package Service 1 0.45 lbs $5.24 $4.19 $1.05
206530 2019-04-23 $44.09 Priority Mail 2-Day 2 1.80 lbs $10.11 $8.76 $1.35
206532 2019-04-25 $30.23 Priority Mail 2-Day 2 1.90 lbs $12.65 $11.80 $0.85
206533 2019-04-25 $8.80 First-Class Package Service 1 0.10 lbs $3.81 $2.76 $1.05
206536 2019-04-25 $19.34 Priority Mail 3-Day 1 0.95 lbs $10.55 $9.70 $0.85
206538 2019-04-25 $13.99 First-Class Package Service 2 0.20 lbs $4.01 $2.96 $1.05
206539 2019-04-26 $15.82 First-Class Package Service 2 0.60 lbs $5.24 $5.38 $-0.14
206540 2019-04-26 $101.79 Priority Mail 2-Day Medium Flat Rate Box 1 1.90 lbs $13.80 $12.80 $1.00
206541 2019-04-26 $31.93 Priority Mail 3-Day Small Flat Rate Box 2 0.60 lbs $8.35 $7.50 $0.85
206543 2019-04-26 $45.76 Priority Mail 2-Day Flat Rate Envelope 4 2.37 lbs $7.80 $7.50 $0.30
206544 2019-04-26 $21.65 First-Class Package Service 9 0.49 lbs $5.24 $3.49 $1.75
206553 2019-04-27 $102.56 First-Class Package International Service 12 2.55 lbs $46.58 $55.10 $-8.52
206554 2019-04-27 $15.12 First-Class Package Service 2 0.04 lbs $4.14 $3.63 $0.51
206555 2019-04-27 $42.66 Priority Mail 2-Day Flat Rate Envelope 3 1.00 lbs $7.80 $7.50 $0.30
206556 2019-04-28 $14.00 First-Class Package Service 1 0.07 lbs $4.01 $3.49 $0.52
206557 2019-04-28 $64.38 Ground 2 1.35 lbs $23.10 $20.60 $2.50
206558 2019-04-28 $8.12 First-Class Package Service 2 0.02 lbs $4.14 $3.09 $1.05
206560 2019-04-29 $55.51 Priority Mail 2-Day 27 4.76 lbs $18.78 $19.86 $-1.08
206562 2019-04-29 $8.91 First-Class Package Service 10 0.10 lbs $4.01 $2.96 $1.05
206564 2019-04-29 $22.31 First-Class Package Service 2 0.28 lbs $4.33 $3.28 $1.05
206570 2019-04-30 $6.83 First-Class Package Service 6 0.06 lbs $3.89 $2.84 $1.05
206578 2019-04-30 $6.89 First-Class Package Service 1 0.05 lbs $3.89 $2.84 $1.05
206583 2019-04-30 $49.27 Priority Mail 2-Day 8 0.65 lbs $9.35 $8.50 $0.85
206590 2019-04-30 $6.83 First-Class Package Service 6 0.06 lbs $3.89 $2.84 $1.05
206592 2019-05-01 $8.94 First-Class Package Service 1 0.05 lbs $3.75 $2.70 $1.05
206594 2019-05-01 $118.77 Priority Mail 2-Day Large Flat Rate Box 27 7.21 lbs $36.05 $17.60 $18.45
206595 2019-05-01 $30.27 First-Class Package Service 6 0.46 lbs $4.33 $3.28 $1.05
206596 2019-05-01 $39.59 Priority Mail 3-Day 7 2.75 lbs $9.66 $8.81 $0.85
206597 2019-05-01 $18.17 First-Class Package Service 4 0.30 lbs $4.41 $3.36 $1.05
206598 2019-05-01 $23.15 First-Class Package Service 2 0.44 lbs $4.27 $3.88 $0.39
206599 2019-05-01 $6.73 First-Class Package Service 2 0.10 lbs $3.75 $2.70 $1.05
206603 2019-05-01 $24.79 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $7.80 $7.50 $0.30
206606 2019-05-01 $112.60 Priority Mail International Small Flat Rate Box 25 2.06 lbs $26.35 $25.50 $0.85
206608 2019-05-01 $64.77 Priority Mail 2-Day Medium Flat Rate Box 3 2.63 lbs $13.80 $10.55 $3.25
206609 2019-05-01 $62.41 Priority Mail 2-Day Medium Flat Rate Box 19 2.04 lbs $13.80 $11.20 $2.60
206610 2019-05-01 $72.43 Priority Mail 2-Day Large Flat Rate Box 22 3.26 lbs $18.45 $17.61 $0.84
206611 2019-05-01 $50.45 Priority Mail 2-Day Flat Rate Envelope 35 1.15 lbs $7.80 $7.50 $0.30
206612 2019-05-01 $8.79 First-Class Package Service 2 0.02 lbs $3.81 $2.76 $1.05
206613 2019-05-02 $6.73 First-Class Package Service 2 0.03 lbs $3.75 $2.70 $1.05
206614 2019-05-02 $147.77 Ground 1 21.70 lbs $22.56 $16.91 $5.65
206615 2019-05-02 $9.72 First-Class Package Service 3 0.09 lbs $3.75 $2.70 $1.05
206618 2019-05-03 $207.10 Priority Mail International 5 4.78 lbs $65.15 $60.90 $4.25
206620 2019-05-03 $89.89 Priority Mail 2-Day Large Flat Rate Box 16 4.17 lbs $18.45 $17.92 $0.53
206621 2019-05-03 $59.89 Priority Mail 2-Day 2 2.00 lbs $10.11 $8.76 $1.35
206622 2019-05-03 $25.67 First-Class Package Service 1 0.35 lbs $4.68 $4.33 $0.35
206624 2019-05-03 $15.76 First-Class Package Service 1 0.35 lbs $4.27 $3.88 $0.39
206628 2019-05-04 $37.70 Priority Mail 2-Day 9 1.57 lbs $9.19 $7.88 $1.31
206631 2019-05-04 $33.69 Priority Mail 3-Day 2 1.01 lbs $11.71 $10.86 $0.85
206632 2019-05-04 $102.35 First-Class Package International Service 3 2.58 lbs $46.58 $59.38 $-12.80
206635 2019-05-04 $198.28 Priority Mail International 1 12.90 lbs $100.29 $93.29 $7.00
206636 2019-05-04 $108.91 First-Class Package International Service 7 2.18 lbs $46.58 $36.58 $10.00
206637 2019-05-04 $97.36 First-Class Package International Service 2 2.50 lbs $46.58 $59.38 $-12.80
206640 2019-05-04 $95.95 First-Class Package International Service 6 1.48 lbs $46.58 $23.28 $23.30
206641 2019-05-04 $99.85 First-Class Package International Service 3 1.73 lbs $46.58 $36.58 $10.00
206643 2019-05-04 $7.59 First-Class Package Service 2 0.10 lbs $4.01 $2.96 $1.05
206644 2019-05-04 $166.38 Priority Mail International 6 4.20 lbs $62.44 $60.90 $1.54
206646 2019-05-04 $95.75 First-Class Package International Service 3 1.50 lbs $31.28 $23.28 $8.00
206649 2019-05-04 $43.20 Priority Mail 2-Day Medium Flat Rate Box 8 1.80 lbs $13.80 $12.80 $1.00
206651 2019-05-05 $84.54 First-Class Package International Service 4 2.37 lbs $46.58 $36.58 $10.00
206653 2019-05-05 $11.85 First-Class Package Service 4 0.16 lbs $3.89 $3.36 $0.53
206654 2019-05-05 $47.64 Priority Mail 2-Day Small Flat Rate Box 2 1.35 lbs $8.35 $7.50 $0.85
206655 2019-05-05 $9.74 First-Class Package Service 1 0.03 lbs $3.75 $2.70 $1.05
206656 2019-05-05 $19.38 First-Class Package Service 30 0.30 lbs $4.68 $3.09 $1.59
206657 2019-05-05 $11.00 First-Class Package Service 1 0.07 lbs $4.01 $2.96 $1.05
206658 2019-05-05 $26.86 First-Class Package Service 2 0.37 lbs $5.18 $3.63 $1.55
206659 2019-05-05 $19.37 First-Class Package Service 2 0.20 lbs $3.89 $3.36 $0.53
206661 2019-05-05 $7.97 First-Class Package Service 4 0.04 lbs $4.01 $2.96 $1.05
206665 2019-05-06 $51.38 Priority Mail 3-Day Medium Flat Rate Box 2 1.85 lbs $13.80 $12.80 $1.00
206666 2019-05-06 $23.07 First-Class Package Service 2 0.15 lbs $3.89 $3.36 $0.53
206668 2019-05-06 $19.97 First-Class Package Service 4 0.10 lbs $4.01 $3.49 $0.52
206669 2019-05-06 $22.83 First-Class Package Service 1 0.30 lbs $4.54 $3.49 $1.05
206671 2019-05-07 $40.09 Priority Mail 2-Day Medium Flat Rate Box 1 3.10 lbs $13.80 $12.80 $1.00
206672 2019-05-07 $16.30 Priority Mail 2-Day 4 0.14 lbs $8.34 $7.50 $0.84
206673 2019-05-07 $12.33 First-Class Package Service 6 0.07 lbs $3.89 $2.84 $1.05
206674 2019-05-07 $60.53 First-Class Package International Service 2 0.65 lbs $30.33 $22.33 $8.00
206678 2019-05-07 $73.33 Priority Mail 3-Day Small Flat Rate Box 2 1.70 lbs $8.35 $7.50 $0.85
206680 2019-05-08 $35.99 Priority Mail 3-Day 6 4.45 lbs $11.18 $13.77 $-2.59
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56