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
201615 2018-01-25 $12.44 First-Class Package Service 3 0.16 lbs $3.97 $3.34 $0.63
201616 2018-01-25 $69.62 Priority Mail 3-Day Medium Flat Rate Box 3 2.75 lbs $13.85 $10.80 $3.05
201617 2018-01-26 $15.38 First-Class Package Service 2 0.40 lbs $4.39 $3.82 $0.57
201618 2018-01-26 $48.88 Priority Mail 2-Day Flat Rate Envelope 2 1.90 lbs $7.40 $6.90 $0.50
201619 2018-01-26 $65.64 Priority Mail 2-Day 8 3.35 lbs $10.22 $9.09 $1.13
201622 2018-01-27 $53.59 Priority Mail 2-Day Small Flat Rate Box 1 1.65 lbs $7.90 $6.85 $1.05
201623 2018-01-27 $115.00 Priority Mail International 1 3.95 lbs $61.01 $56.76 $4.25
201629 2018-01-27 $8.69 First-Class Package Service 2 0.08 lbs $3.71 $2.66 $1.05
201630 2018-01-27 $64.21 Priority Mail 2-Day Medium Flat Rate Box 4 2.03 lbs $13.85 $10.29 $3.56
201631 2018-01-27 $15.18 Priority Mail 3-Day Flat Rate Envelope 2 1.20 lbs $7.40 $6.90 $0.50
201633 2018-01-28 $29.08 First-Class Mail Large Envelope 4 0.35 lbs $3.82 $3.18 $0.64
201634 2018-01-28 $16.87 Priority Mail 3-Day Small Flat Rate Box 3 0.87 lbs $7.90 $6.85 $1.05
201636 2018-01-28 $48.37 Priority Mail 2-Day Flat Rate Envelope 3 1.23 lbs $7.40 $6.90 $0.50
201637 2018-01-28 $11.69 First-Class Package Service 2 0.10 lbs $3.71 $2.66 $1.05
201638 2018-01-28 $97.30 Priority Mail 2-Day 2 3.60 lbs $19.32 $15.59 $3.73
201639 2018-01-28 $14.26 First-Class Package Service 5 0.15 lbs $3.71 $2.79 $0.92
201640 2018-01-28 $19.47 First-Class Package Service 3 0.28 lbs $3.90 $3.05 $0.85
201643 2018-01-28 $45.86 First-Class Package Service 3 0.73 lbs $5.51 $4.38 $1.13
201644 2018-01-29 $86.62 Priority Mail 2-Day Padded Flat Rate Envelope 3 2.35 lbs $7.95 $6.90 $1.05
201648 2018-01-29 $7.20 First-Class Package Service 1 0.04 lbs $3.71 $2.66 $1.05
201649 2018-01-29 $16.52 First-Class Mail Large Envelope 1 0.45 lbs $4.03 $3.50 $0.53
201650 2018-01-29 $5.70 First-Class Package Service 1 0.12 lbs $3.71 $2.66 $1.05
201651 2018-01-29 $297.57 Priority Mail International 25 9.69 lbs $84.27 $216.80 $-132.53
201652 2018-01-29 $142.13 Priority Mail International 5 2.76 lbs $66.48 $62.23 $4.25
201653 2018-01-29 $114.49 Priority Mail 2-Day 3 4.18 lbs $10.22 $9.09 $1.13
201655 2018-01-29 $32.46 Priority Mail 3-Day 5 2.50 lbs $13.01 $9.47 $3.54
201658 2018-01-29 $49.18 Priority Mail 2-Day Small Flat Rate Box 2 1.45 lbs $7.90 $6.85 $1.05
201659 2018-01-29 $10.69 First-Class Package Service 2 0.10 lbs $3.71 $2.66 $1.05
201662 2018-01-30 $42.39 Priority Mail 3-Day Flat Rate Envelope 1 2.35 lbs $7.40 $6.90 $0.50
201664 2018-01-30 $14.39 Priority Mail 3-Day Flat Rate Envelope 1 1.00 lbs $7.40 $6.85 $0.55
201665 2018-01-30 $16.90 First-Class Mail Large Envelope 1 0.30 lbs $3.61 $3.18 $0.43
201666 2018-01-30 $21.65 First-Class Package Service 6 0.15 lbs $3.71 $2.79 $0.92
201667 2018-01-30 $53.59 Priority Mail 3-Day Small Flat Rate Box 1 1.65 lbs $7.90 $6.85 $1.05
201668 2018-01-31 $35.98 First-Class Mail Large Envelope 3 0.09 lbs $3.61 $3.05 $0.56
201669 2018-01-31 $103.54 Priority Mail 3-Day 8 4.21 lbs $10.56 $9.09 $1.47
201670 2018-01-31 $181.00 Priority Mail International 4 5.15 lbs $68.04 $63.79 $4.25
201671 2018-01-31 $67.82 First-Class Package International Service 1 1.50 lbs $27.33 $22.33 $5.00
201672 2018-01-31 $67.82 First-Class Package International Service 1 1.50 lbs $27.33 $22.33 $5.00
201673 2018-01-31 $67.82 First-Class Package International Service 1 1.55 lbs $27.33 $22.33 $5.00
201674 2018-01-31 $32.13 First-Class Package Service 2 0.45 lbs $4.35 $3.50 $0.85
201677 2018-01-31 $45.21 Priority Mail 2-Day 3 3.45 lbs $8.16 $7.10 $1.06
201678 2018-01-31 $5.18 First-Class Package Service 3 0.03 lbs $3.71 $2.66 $1.05
201679 2018-01-31 $61.82 First-Class Package International Service 1 1.50 lbs $27.33 $22.33 $5.00
201681 2018-01-31 $126.71 Ground 6 6.09 lbs $21.65 $21.24 $0.41
201682 2018-01-31 $42.39 Priority Mail 3-Day Flat Rate Envelope 1 2.35 lbs $7.40 $6.90 $0.50
201683 2018-02-01 $115.00 Priority Mail International 1 3.95 lbs $61.01 $56.76 $4.25
201684 2018-02-01 $67.82 First-Class Package International Service 1 1.50 lbs $27.33 $22.33 $5.00
201685 2018-02-01 $23.36 First-Class Package Service 1 0.22 lbs $3.97 $2.92 $1.05
201686 2018-02-01 $73.50 First-Class Package International Service 1 2.20 lbs $38.01 $33.01 $5.00
201687 2018-02-01 $43.31 Priority Mail 2-Day 1 1.35 lbs $10.32 $9.19 $1.13
201688 2018-02-01 $27.91 First-Class Mail Large Envelope 3 0.50 lbs $4.24 $3.34 $0.90
201692 2018-02-01 $10.68 First-Class Package Service 7 0.07 lbs $3.71 $2.66 $1.05
201693 2018-02-01 $5.20 First-Class Package Service 1 0.03 lbs $3.71 $2.66 $1.05
201697 2018-02-02 $257.27 Ground 2 16.60 lbs $27.46 $25.06 $2.40
201698 2018-02-02 $15.66 First-Class Package Service 5 0.20 lbs $3.71 $2.79 $0.92
201699 2018-02-02 $58.28 Priority Mail 2-Day 4 4.35 lbs $10.22 $7.40 $2.82
201700 2018-02-02 $83.98 Priority Mail 2-Day 13 2.17 lbs $10.11 $8.15 $1.96
201701 2018-02-02 $92.39 Priority Mail 3-Day Small Flat Rate Box 1 2.85 lbs $7.90 $6.85 $1.05
201703 2018-02-03 $31.61 Priority Mail 2-Day 4 0.80 lbs $11.65 $10.48 $1.17
201705 2018-02-03 $26.18 First-Class Package Service 1 0.40 lbs $4.19 $3.34 $0.85
201708 2018-02-03 $104.58 Priority Mail 2-Day 6 3.50 lbs $19.32 $12.45 $6.87
201709 2018-02-03 $249.19 Priority Mail 3-Day 2 22.15 lbs $26.51 $24.89 $1.62
201713 2018-02-03 $121.40 Ground 1 19.40 lbs $24.20 $21.70 $2.50
201715 2018-02-04 $11.66 First-Class Package Service 5 0.06 lbs $3.71 $2.66 $1.05
201716 2018-02-04 $8.81 First-Class Mail Large Envelope 1 0.45 lbs $3.82 $3.50 $0.32
201717 2018-02-04 $12.66 First-Class Package Service 1 0.65 lbs $4.67 $4.94 $-0.27
201719 2018-02-04 $52.48 Priority Mail 2-Day Small Flat Rate Box 2 1.35 lbs $7.90 $6.85 $1.05
201720 2018-02-04 $23.07 First-Class Package Service 3 0.35 lbs $4.10 $3.18 $0.92
201721 2018-02-04 $35.39 Priority Mail 3-Day Flat Rate Envelope 1 1.20 lbs $7.40 $6.85 $0.55
201726 2018-02-05 $60.99 Priority Mail International Small Flat Rate Box 1 1.20 lbs $31.50 $22.33 $9.17
201728 2018-02-05 $10.70 First-Class Package Service 1 0.19 lbs $3.71 $2.66 $1.05
201730 2018-02-05 $40.69 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $7.90 $6.85 $1.05
201731 2018-02-05 $6.37 First-Class Package Service 1 0.20 lbs $3.97 $2.92 $1.05
201735 2018-02-06 $31.82 First-Class Package Service 2 0.16 lbs $3.84 $14.56 $-10.72
201736 2018-02-06 $31.69 First-Class Package Service 2 0.57 lbs $4.35 $3.82 $0.53
201739 2018-02-06 $60.48 Priority Mail 3-Day 6 2.30 lbs $9.54 $8.22 $1.32
201741 2018-02-06 $92.45 First-Class Package International Service 3 1.65 lbs $38.01 $33.01 $5.00
201742 2018-02-06 $9.82 First-Class Package Service 2 0.19 lbs $3.84 $2.79 $1.05
201743 2018-02-06 $6.65 First-Class Package Service 6 0.06 lbs $3.71 $2.66 $1.05
201744 2018-02-06 $63.58 First-Class Package International Service 5 0.77 lbs $27.33 $22.33 $5.00
201745 2018-02-07 $39.76 Priority Mail 3-Day 4 1.24 lbs $9.00 $7.91 $1.09
201746 2018-02-07 $50.58 Priority Mail 3-Day 7 1.38 lbs $8.25 $7.18 $1.07
201747 2018-02-07 $17.67 First-Class Package Service 4 0.16 lbs $3.71 $2.79 $0.92
201748 2018-02-07 $166.14 Priority Mail 2-Day 1 12.25 lbs $38.95 $36.96 $1.99
201749 2018-02-07 $17.67 First-Class Package Service 4 0.20 lbs $3.71 $2.79 $0.92
201750 2018-02-07 $71.76 Priority Mail 3-Day Medium Flat Rate Box 5 1.90 lbs $13.85 $6.85 $7.00
201751 2018-02-07 $72.34 Priority Mail 2-Day 21 1.05 lbs $11.65 $6.85 $4.80
201752 2018-02-07 $15.22 First-Class Package Service 2 0.10 lbs $3.84 $2.66 $1.18
201753 2018-02-08 $73.50 First-Class Package International Service 1 2.20 lbs $38.01 $33.01 $5.00
201756 2018-02-08 $7.19 First-Class Package Service 2 0.06 lbs $3.71 $2.66 $1.05
201757 2018-02-08 $40.39 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $7.40 $6.85 $0.55
201759 2018-02-08 $38.83 First-Class Package Service 4 0.72 lbs $4.87 $4.66 $0.21
201762 2018-02-09 $17.67 First-Class Package Service 4 0.16 lbs $3.71 $2.79 $0.92
201763 2018-02-09 $73.50 First-Class Package International Service 1 2.20 lbs $38.01 $33.01 $5.00
201764 2018-02-09 $15.67 First-Class Package Service 4 0.14 lbs $3.71 $2.66 $1.05
201765 2018-02-09 $15.40 First-Class Mail Large Envelope 1 0.30 lbs $3.61 $3.05 $0.56
201767 2018-02-10 $65.00 First-Class Package International Service 1 2.20 lbs $38.01 $33.01 $5.00
201768 2018-02-10 $73.50 First-Class Package International Service 1 2.20 lbs $38.01 $33.01 $5.00
201769 2018-02-10 $96.27 First-Class Package International Service 14 2.21 lbs $38.01 $33.01 $5.00
201770 2018-02-10 $13.75 First-Class Package Service 2 0.14 lbs $3.97 $2.66 $1.31
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56