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
215805 2020-09-21 $19.29 First-Class Package Service 6 0.95 lbs $6.15 $7.65 $-1.50
215806 2020-09-21 $19.90 Priority Mail 2-Day 1 0.95 lbs $9.61 $8.85 $0.76
215807 2020-09-21 $10.53 USPSFirstClass 1 0.05 lbs $4.19 $3.25 $0.94
215808 2020-09-21 $11.92 USPSFirstClass 1 0.05 lbs $4.24 $2.78 $1.46
215809 2020-09-21 $54.79 Priority Mail 3-Day 5 1.10 lbs $10.84 $9.99 $0.85
215810 2020-09-21 $10.52 First-Class Package Service 1 0.59 lbs $4.53 $5.27 $-0.74
215811 2020-09-21 $5.16 First-Class Mail Stamped Letter 4 0.04 lbs $3.20 $3.05 $0.15
215812 2020-09-21 $20.80 First-Class Package Service 1 0.40 lbs $4.91 $4.46 $0.45
215813 2020-09-21 $7.70 USPSFirstClass 1 0.03 lbs $4.20 $3.05 $1.15
215814 2020-09-21 $9.29 USPSFirstClass 1 0.07 lbs $4.30 $3.05 $1.25
215815 2020-09-21 $31.90 USPSFirstClass 3 1.05 lbs $10.74 $8.21 $2.53
215816 2020-09-21 $13.17 USPSFirstClass 3 0.10 lbs $4.20 $3.05 $1.15
215818 2020-09-21 $10.80 First-Class Package Service 2 0.10 lbs $3.19 $2.74 $0.45
215821 2020-09-21 $38.29 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $8.50 $7.65 $0.85
215822 2020-09-22 $43.25 USPSFirstClass 4 1.54 lbs $17.08 $8.76 $8.32
215824 2020-09-22 $10.68 USPSFirstClass 1 0.05 lbs $4.19 $2.78 $1.41
215828 2020-09-22 $104.93 Priority Mail 3-Day Padded Flat Rate Envelope 3 3.96 lbs $8.60 $7.75 $0.85
215830 2020-09-22 $8.15 USPSFirstClass 1 0.03 lbs $4.17 $2.93 $1.24
215831 2020-09-22 $8.54 First-Class Package Service - Retail 1 0.18 lbs $5.55 $3.25 $2.30
215832 2020-09-22 $19.33 First-Class Package Service 3 0.23 lbs $3.76 $3.31 $0.45
215834 2020-09-22 $52.94 USPSFirstClass 5 1.75 lbs $17.46 $15.74 $1.72
215835 2020-09-22 $24.94 USPSFirstClass 1 0.25 lbs $4.96 $3.52 $1.44
215836 2020-09-22 $6.69 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $2.84 $0.36
215837 2020-09-22 $12.99 Priority Mail 2-Day 1 0.05 lbs $9.00 $8.15 $0.85
215839 2020-09-22 $34.73 Priority Mail 3-Day Small Flat Rate Box 1 1.00 lbs $8.50 $7.65 $0.85
215840 2020-09-22 $57.95 Ground 1 1.20 lbs $21.16 $18.42 $2.74
215841 2020-09-22 $116.21 Priority Mail 2-Day 7 4.94 lbs $12.82 $8.21 $4.61
215843 2020-09-23 $9.03 First-Class Package Service 2 0.34 lbs $4.25 $4.00 $0.25
215844 2020-09-23 $10.99 USPSFirstClass 1 0.05 lbs $4.34 $3.52 $0.82
215845 2020-09-23 $79.45 Priority Mail 2-Day Medium Flat Rate Box 1 5.30 lbs $14.45 $13.20 $1.25
215848 2020-09-23 $15.55 First-Class Package Service 1 0.30 lbs $3.76 $3.31 $0.45
215849 2020-09-23 $15.91 First-Class Package Service 1 0.30 lbs $4.12 $3.67 $0.45
215850 2020-09-23 $7.73 First-Class Package Service 1 0.10 lbs $3.38 $2.93 $0.45
215852 2020-09-23 $3.54 First-Class Mail Stamped Letter 1 0.05 lbs $3.35 $2.93 $0.42
215855 2020-09-23 $17.60 First-Class Package Service 2 0.26 lbs $4.12 $3.67 $0.45
215856 2020-09-23 $20.35 USPSFirstClass 2 0.38 lbs $5.15 $2.93 $2.22
215857 2020-09-23 $34.35 First-Class Package Service 7 0.59 lbs $4.91 $4.46 $0.45
215858 2020-09-23 $51.49 Priority Mail 3-Day Small Flat Rate Box 1 1.55 lbs $8.50 $7.65 $0.85
215859 2020-09-23 $6.96 First-Class Package Service 1 0.02 lbs $3.97 $3.52 $0.45
215862 2020-09-23 $9.71 USPSFirstClass 1 0.20 lbs $4.22 $4.08 $0.14
215867 2020-09-23 $15.21 First-Class Package Service 2 0.03 lbs $3.23 $2.78 $0.45
215870 2020-09-23 $61.58 Priority Mail 2-Day Flat Rate Envelope 2 1.87 lbs $8.00 $8.15 $-0.15
215873 2020-09-23 $49.44 Priority Mail 2-Day Small Flat Rate Box 6 0.36 lbs $8.50 $7.80 $0.70
215875 2020-09-23 $9.96 USPSFirstClass 1 0.04 lbs $4.44 $3.18 $1.26
215876 2020-09-23 $8.83 First-Class Package Service 1 0.24 lbs $3.84 $3.39 $0.45
215877 2020-09-23 $8.39 First-Class Package Service 1 0.05 lbs $3.50 $3.05 $0.45
215878 2020-09-24 $9.35 USPSFirstClass 1 0.05 lbs $4.14 $2.78 $1.36
215879 2020-09-23 $26.48 Priority Mail 2-Day 6 1.07 lbs $10.84 $10.42 $0.42
215881 2020-09-23 $15.35 First-Class Package Service 2 0.90 lbs $5.57 $7.65 $-2.08
215885 2020-09-24 $9.26 USPSFirstClass 2 0.40 lbs $4.89 $4.18 $0.71
215886 2020-09-24 $37.82 First-Class Package Service 11 0.47 lbs $4.43 $4.18 $0.25
215889 2020-09-24 $13.24 USPSFirstClass 1 0.34 lbs $5.34 $4.46 $0.88
215892 2020-09-24 $145.17 Ground 1 10.85 lbs $38.18 $26.30 $11.88
215896 2020-09-24 $94.44 Priority Mail 2-Day Medium Flat Rate Box 1 7.15 lbs $14.45 $12.10 $2.35
215897 2020-09-24 $22.41 First-Class Package Service 6 0.22 lbs $3.97 $3.05 $0.92
215898 2020-09-24 $19.04 USPSFirstClass 2 0.10 lbs $8.28 $2.78 $5.50
215899 2020-09-24 $38.29 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $8.50 $7.65 $0.85
215901 2020-09-25 $10.39 USPSFirstClass 1 0.20 lbs $4.27 $3.39 $0.88
215902 2020-09-24 $51.49 Priority Mail 3-Day Small Flat Rate Box 1 1.55 lbs $8.50 $8.05 $0.45
215903 2020-09-24 $26.39 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $8.00 $8.00 $0.00
215905 2020-09-25 $6.19 First-Class Mail Stamped Letter 1 0.03 lbs $3.20 $2.84 $0.36
215906 2020-09-25 $232.00 Ground 1 21.00 lbs $38.81 $35.21 $3.60
215908 2020-09-25 $7.77 First-Class Package Service 2 0.04 lbs $3.29 $2.84 $0.45
215909 2020-09-25 $20.74 First-Class Package Service 5 0.15 lbs $3.29 $2.84 $0.45
215910 2020-09-25 $12.26 First-Class Package Service 6 0.16 lbs $3.72 $3.58 $0.14
215911 2020-09-25 $8.34 First-Class Mail Stamped Letter 1 0.07 lbs $3.35 $2.93 $0.42
215912 2020-09-25 $38.47 First-Class Package Service 6 0.60 lbs $4.53 $4.08 $0.45
215913 2020-09-25 $51.49 Priority Mail 2-Day Small Flat Rate Box 1 1.55 lbs $8.50 $8.05 $0.45
215914 2020-09-25 $81.03 Priority Mail 2-Day Medium Flat Rate Box 2 2.35 lbs $14.45 $12.64 $1.81
215915 2020-09-25 $104.28 Priority Mail 3-Day 4 2.55 lbs $9.92 $8.59 $1.33
215916 2020-09-25 $10.23 USPSFirstClass 1 0.05 lbs $4.34 $3.52 $0.82
215917 2020-09-25 $6.33 First-Class Mail Stamped Letter 2 0.05 lbs $3.35 $3.18 $0.17
215918 2020-09-25 $23.97 USPSFirstClass 1 0.25 lbs $4.86 $3.31 $1.55
215919 2020-09-25 $8.46 First-Class Package Service 4 0.28 lbs $3.50 $3.25 $0.25
215921 2020-09-25 $8.75 USPSFirstClass 1 0.05 lbs $4.25 $3.05 $1.20
215922 2020-09-25 $20.21 Priority Mail 3-Day 2 0.16 lbs $8.83 $7.98 $0.85
215923 2020-09-25 $16.79 USPSFirstClass 1 0.16 lbs $4.66 $3.52 $1.14
215924 2020-09-25 $3.69 First-Class Mail Stamped Letter 1 0.02 lbs $3.20 $3.05 $0.15
215925 2020-09-26 $20.38 USPSFirstClass 2 0.40 lbs $5.24 $5.54 $-0.30
215926 2020-09-25 $49.99 Priority Mail 3-Day 1 2.35 lbs $13.00 $10.42 $2.58
215928 2020-09-25 $38.29 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $8.50 $10.54 $-2.04
215932 2020-09-26 $13.70 First-Class Package Service 1 0.20 lbs $3.76 $3.31 $0.45
215934 2020-09-26 $9.88 USPSFirstClass 1 0.07 lbs $4.25 $2.93 $1.32
215935 2020-09-26 $23.32 USPSFirstClass 1 0.40 lbs $5.59 $4.18 $1.41
215936 2020-09-26 $190.47 Priority Mail 1-Day 24 4.40 lbs $8.89 $7.68 $1.21
215937 2020-09-26 $5.34 First-Class Mail Stamped Letter 1 0.07 lbs $3.35 $3.05 $0.30
215938 2020-09-26 $18.44 Priority Mail 2-Day Flat Rate Envelope 6 0.99 lbs $8.00 $7.65 $0.35
215939 2020-09-26 $8.54 First-Class Mail Stamped Letter 1 0.06 lbs $3.35 $3.05 $0.30
215942 2020-09-26 $45.09 Priority Mail 2-Day Padded Flat Rate Envelope 1 2.44 lbs $8.60 $7.84 $0.76
215943 2020-09-26 $28.55 USPSFirstClass 6 1.20 lbs $14.98 $10.53 $4.45
215948 2020-09-26 $58.59 Priority Mail 3-Day Padded Flat Rate Envelope 1 1.95 lbs $8.60 $7.75 $0.85
215950 2020-09-26 $9.15 First-Class Package Service 1 0.05 lbs $3.23 $2.78 $0.45
215954 2020-09-26 $34.05 First-Class Package Service 3 0.45 lbs $4.45 $4.00 $0.45
215955 2020-09-27 $26.11 USPSFirstClass 1 0.95 lbs $9.10 $8.76 $0.34
215956 2020-09-27 $13.98 Priority Mail 2-Day Flat Rate Envelope 2 0.04 lbs $8.00 $7.65 $0.35
215957 2020-09-27 $14.88 USPSFirstClass 2 0.06 lbs $4.24 $2.93 $1.31
215959 2020-09-27 $6.30 USPSFirstClass 1 0.20 lbs $4.00 $3.25 $0.75
215962 2020-09-27 $8.90 USPSFirstClass 1 0.20 lbs $4.42 $3.67 $0.75
215963 2020-09-28 $10.02 USPSFirstClass 1 0.07 lbs $4.45 $3.18 $1.27
215964 2020-09-27 $35.55 Priority Mail 2-Day 1 2.14 lbs $14.34 $11.13 $3.21
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56