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
225858 2021-06-22 $38.31 Priority Mail 2-Day Small Flat Rate Box 1 1.27 lbs $9.00 $7.90 $1.10
225859 2021-06-22 $11.75 First-Class Mail Stamped Letter 5 0.06 lbs $3.80 $3.06 $0.74
225861 2021-06-22 $15.02 First-Class Package Service 1 0.30 lbs $4.71 $3.51 $1.20
225863 2021-06-22 $34.83 First-Class Package Service 5 0.36 lbs $4.77 $3.57 $1.20
225869 2021-06-23 $57.08 USPSPriority 2 10.60 lbs $24.22 $26.98 $-2.76
225870 2021-06-23 $331.02 Priority Mail 2-Day Large Flat Rate Box 16 12.85 lbs $23.10 $13.75 $9.35
225872 2021-06-23 $50.68 Priority Mail 2-Day Flat Rate Envelope 12 0.81 lbs $8.50 $7.90 $0.60
225873 2021-06-23 $11.01 First-Class Package Service 4 0.23 lbs $5.05 $3.85 $1.20
225874 2021-06-23 $18.13 First-Class Package Service 2 0.29 lbs $4.71 $3.51 $1.20
225875 2021-06-23 $25.78 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $8.50 $8.00 $0.50
225876 2021-06-23 $10.78 First-Class Mail Stamped Letter 2 0.10 lbs $3.80 $5.27 $-1.47
225878 2021-06-24 $42.27 Priority Mail 3-Day 2 2.59 lbs $9.82 $8.00 $1.82
225882 2021-06-24 $6.60 USPSFirstClass 1 0.01 lbs $4.41 $3.35 $1.06
225884 2021-06-24 $5.39 USPSFirstClass 1 0.06 lbs $0.00 $3.12 $-3.12
225890 2021-06-24 $9.59 First-Class Mail Stamped Letter 1 0.15 lbs $4.00 $3.06 $0.94
225892 2021-06-24 $29.99 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $8.50 $8.00 $0.50
225893 2021-06-24 $56.38 Priority Mail 1-Day 1 2.20 lbs $9.10 $7.83 $1.27
225894 2021-06-24 $21.15 Priority Mail 2-Day 2 0.15 lbs $8.77 $7.67 $1.10
225898 2021-06-25 $16.53 USPSFirstClass 2 0.08 lbs $4.55 $3.22 $1.33
225899 2021-06-25 $31.72 First-Class Package Service 1 0.40 lbs $5.73 $3.69 $2.04
225900 2021-06-25 $16.88 First-Class Package Service 1 0.30 lbs $4.89 $3.69 $1.20
225901 2021-06-25 $10.78 First-Class Mail Stamped Letter 2 0.10 lbs $3.80 $3.35 $0.45
225902 2021-06-25 $6.98 First-Class Mail Stamped Letter 2 0.10 lbs $4.00 $3.06 $0.94
225905 2021-06-25 $49.66 Ground 3 1.50 lbs $27.09 $20.88 $6.21
225906 2021-06-25 $17.22 First-Class Package Service 1 0.40 lbs $5.73 $3.69 $2.04
225907 2021-06-25 $17.04 First-Class Package Service 1 0.30 lbs $5.05 $3.85 $1.20
225908 2021-06-25 $16.42 USPSFirstClass 3 0.15 lbs $4.45 $3.22 $1.23
225909 2021-06-25 $25.85 First-Class Package Service 3 0.51 lbs $5.58 $3.58 $2.00
225910 2021-06-25 $133.12 Ground Home Delivery 1 10.85 lbs $30.62 $24.79 $5.83
225911 2021-06-25 $112.09 Priority Mail 3-Day Padded Flat Rate Envelope 1 1.25 lbs $9.10 $8.00 $1.10
225912 2021-06-25 $28.75 Priority Mail 2-Day 1 0.65 lbs $8.26 $7.16 $1.10
225915 2021-06-26 $23.28 Priority Mail 2-Day 1 0.95 lbs $12.79 $8.80 $3.99
225916 2021-06-26 $17.78 First-Class Package Service 1 0.25 lbs $4.89 $3.35 $1.54
225917 2021-06-26 $13.66 First-Class Package Service 3 0.05 lbs $4.69 $3.49 $1.20
225919 2021-06-26 $15.61 First-Class Package Service 2 0.18 lbs $5.63 $3.49 $2.14
225920 2021-06-26 $10.59 USPSFirstClass 1 0.04 lbs $4.60 $3.35 $1.25
225921 2021-06-26 $8.39 USPSFirstClass 1 0.05 lbs $4.40 $3.12 $1.28
225922 2021-06-26 $28.29 Priority Mail 2-Day Flat Rate Envelope 1 0.80 lbs $8.50 $8.00 $0.50
225925 2021-06-26 $41.29 Priority Mail 2-Day Flat Rate Envelope 1 1.27 lbs $8.50 $7.90 $0.60
225929 2021-06-26 $56.49 Priority Mail 2-Day Flat Rate Envelope 1 1.15 lbs $8.50 $8.00 $0.50
225930 2021-06-26 $29.99 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $8.50 $8.00 $0.50
225931 2021-06-27 $16.79 First-Class Mail Stamped Letter 1 0.15 lbs $4.00 $3.06 $0.94
225933 2021-06-27 $13.88 First-Class Package Service 1 0.19 lbs $4.89 $3.35 $1.54
225935 2021-06-27 $20.87 USPSFirstClass 2 0.40 lbs $5.29 $5.27 $0.02
225936 2021-06-27 $18.68 USPSFirstClass 1 0.22 lbs $4.94 $3.22 $1.72
225937 2021-06-27 $9.65 USPSFirstClass 1 0.05 lbs $4.70 $3.49 $1.21
225945 2021-06-27 $68.70 Ground 2 1.98 lbs $23.72 $17.74 $5.98
225953 2021-06-27 $43.79 Priority Mail 2-Day 1 2.20 lbs $13.80 $7.90 $5.90
225954 2021-06-27 $15.36 First-Class Package Service 1 0.30 lbs $5.05 $3.85 $1.20
225956 2021-06-28 $9.96 USPSFirstClass 1 0.06 lbs $4.57 $3.35 $1.22
225957 2021-06-28 $16.81 USPSFirstClass 2 0.20 lbs $4.51 $3.57 $0.94
225958 2021-06-28 $20.69 USPSFirstClass 3 0.19 lbs $4.52 $4.38 $0.14
225959 2021-06-28 $27.12 USPSPriority 1 1.50 lbs $12.67 $10.44 $2.23
225962 2021-06-28 $214.14 Ground Home Delivery 2 20.95 lbs $46.16 $29.44 $16.72
225963 2021-06-28 $10.77 First-Class Mail Stamped Letter 3 0.04 lbs $3.80 $3.35 $0.45
225964 2021-06-28 $33.55 USPSPriority 1 5.30 lbs $17.12 $12.42 $4.70
225965 2021-06-29 $20.36 USPSFirstClass 4 0.20 lbs $4.40 $3.12 $1.28
225966 2021-06-28 $28.83 First-Class Package Service 5 0.19 lbs $4.53 $3.58 $0.95
225967 2021-06-28 $6.59 First-Class Mail Stamped Letter 1 0.01 lbs $3.60 $3.35 $0.25
225968 2021-06-28 $10.29 First-Class Mail Stamped Letter 1 0.15 lbs $4.00 $3.22 $0.78
225969 2021-06-29 $17.53 First-Class Package Service 2 0.28 lbs $5.05 $3.85 $1.20
225970 2021-06-29 $73.09 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.25 lbs $9.10 $7.90 $1.20
225971 2021-06-29 $15.34 USPSFirstClass 3 0.21 lbs $5.17 $4.38 $0.79
225972 2021-06-29 $12.78 First-Class Package Service 1 0.20 lbs $4.89 $3.35 $1.54
225973 2021-06-29 $392.12 Ground Home Delivery 1 1.50 lbs $0.00 $7.90 $-7.90
225974 2021-06-29 $140.68 Priority Mail 2-Day Medium Flat Rate Box 2 18.97 lbs $15.40 $13.75 $1.65
225975 2021-06-29 $6.78 First-Class Mail Stamped Letter 2 0.08 lbs $3.80 $3.06 $0.74
225976 2021-06-29 $852.39 Ground 25 28.25 lbs $40.67 $43.43 $-2.76
225978 2021-06-29 $28.29 Priority Mail 3-Day Flat Rate Envelope 1 0.80 lbs $8.50 $8.00 $0.50
225979 2021-06-29 $22.48 Priority Mail 2-Day 6 1.20 lbs $9.34 $8.24 $1.10
225980 2021-06-30 $6.24 USPSFirstClass 1 0.15 lbs $4.25 $3.06 $1.19
225983 2021-06-30 $35.79 First-Class Mail Stamped Letter 1 0.12 lbs $4.00 $3.49 $0.51
225986 2021-06-30 $11.59 First-Class Mail Stamped Letter 1 0.04 lbs $3.80 $3.06 $0.74
225987 2021-07-01 $5.24 USPSFirstClass 1 0.01 lbs $4.25 $3.12 $1.13
225989 2021-07-01 $48.25 Priority Mail 2-Day 1 1.15 lbs $12.11 $11.01 $1.10
225990 2021-07-01 $59.59 Priority Mail 3-Day 2 1.80 lbs $9.34 $8.24 $1.10
225991 2021-07-01 $14.11 USPSFirstClass 1 0.10 lbs $4.62 $3.06 $1.56
225996 2021-07-01 $19.38 First-Class Mail Stamped Letter 2 0.08 lbs $3.80 $3.12 $0.68
225998 2021-07-01 $75.65 Priority Mail 3-Day 1 1.25 lbs $9.95 $8.85 $1.10
226000 2021-07-02 $7.79 First-Class Mail Stamped Letter 1 0.03 lbs $3.80 $3.22 $0.58
226004 2021-07-02 $104.78 Ground 10 2.08 lbs $17.88 $8.00 $9.88
226007 2021-07-02 $27.79 USPSFirstClass 1 0.70 lbs $6.75 $5.66 $1.09
226013 2021-07-02 $12.29 United States 1 0.04 lbs $3.50 $3.12 $0.38
226014 2021-07-02 $23.86 United States 9 0.62 lbs $3.95 $4.68 $-0.73
226020 2021-07-03 $21.57 USPSFirstClass 2 0.68 lbs $5.99 $5.27 $0.72
226023 2021-07-03 $90.29 Priority Mail 2-Day 2 2.80 lbs $10.31 $9.21 $1.10
226024 2021-07-03 $17.49 United States 1 0.95 lbs $7.00 $7.67 $-0.67
226026 2021-07-03 $13.06 First-Class Package Service 15 0.23 lbs $4.71 $3.51 $1.20
226028 2021-07-03 $21.89 Priority Mail 3-Day 1 0.30 lbs $9.90 $7.90 $2.00
226030 2021-07-03 $12.27 United States 3 0.04 lbs $3.50 $3.12 $0.38
226031 2021-07-03 $12.42 USPSFirstClass 1 0.06 lbs $4.83 $3.49 $1.34
226032 2021-07-03 $80.79 Priority Mail 2-Day 7 2.44 lbs $12.80 $10.43 $2.37
226033 2021-07-03 $30.59 Priority Mail 2-Day 1 0.90 lbs $9.10 $8.00 $1.10
226035 2021-07-03 $44.31 First-Class Package Service 1 0.58 lbs $5.32 $4.12 $1.20
226036 2021-07-03 $9.79 United States 1 0.10 lbs $3.50 $3.22 $0.28
226037 2021-07-04 $28.29 USPSFirstClass 1 0.32 lbs $6.30 $3.85 $2.45
226038 2021-07-04 $21.78 USPSFirstClass 1 0.05 lbs $4.99 $3.06 $1.93
226039 2021-07-04 $9.65 USPSFirstClass 1 0.05 lbs $4.46 $3.12 $1.34
226041 2021-07-04 $10.85 USPSFirstClass 1 0.05 lbs $4.56 $3.22 $1.34
226042 2021-07-04 $10.58 First-Class Mail Stamped Letter 2 0.04 lbs $3.60 $3.22 $0.38
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56