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.

21025 matching order(s)

Order ID ▲DateOrder TotalShipping Method# ProductsTotal WeightShipping ChargedShipping PaidProfit
218884 2020-12-18 $9.45 USPSFirstClass 1 0.08 lbs $4.26 $3.18 $1.08
218885 2020-12-18 $26.84 USPSFirstClass 1 0.40 lbs $5.85 $4.43 $1.42
218886 2020-12-18 $11.10 USPSFirstClass 2 0.08 lbs $4.12 $3.09 $1.03
218887 2020-12-17 $9.08 First-Class Mail Stamped Letter 2 0.06 lbs $3.10 $3.09 $0.01
218888 2020-12-17 $51.89 Priority Mail 2-Day Small Flat Rate Box 1 1.55 lbs $8.90 $7.90 $1.00
218889 2020-12-18 $12.23 USPSFirstClass 2 0.10 lbs $4.25 $3.30 $0.95
218890 2020-12-18 $50.22 Priority Mail 3-Day Padded Flat Rate Envelope 2 1.62 lbs $9.00 $8.05 $0.95
218891 2020-12-18 $22.31 Priority Mail 2-Day 3 1.35 lbs $11.24 $10.82 $0.42
218892 2020-12-18 $67.81 First-Class Package Service 7 0.57 lbs $4.88 $4.43 $0.45
218893 2020-12-18 $243.12 Ground 2 14.40 lbs $39.14 $27.85 $11.29
218895 2020-12-18 $51.89 Priority Mail 3-Day Small Flat Rate Box 1 1.55 lbs $8.90 $7.90 $1.00
218897 2020-12-18 $14.17 USPSFirstClass 1 0.10 lbs $4.44 $3.56 $0.88
218898 2020-12-18 $27.89 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $8.40 $8.15 $0.25
218899 2020-12-18 $27.24 Ground 1 0.90 lbs $8.85 $8.45 $0.40
218902 2020-12-18 $63.73 Priority Mail 2-Day 12 1.20 lbs $9.37 $8.52 $0.85
218904 2020-12-18 $7.01 First-Class Package Service 1 0.20 lbs $3.71 $2.99 $0.72
218907 2020-12-18 $14.42 USPSFirstClass 1 0.10 lbs $4.69 $3.43 $1.26
218909 2021-02-20 $798.37 Priority Mail 1-Day 16 20.12 lbs $32.28 $18.07 $14.21
218910 2020-12-18 $14.09 First-Class Mail Stamped Letter 1 0.05 lbs $3.10 $3.43 $-0.33
218911 2020-12-18 $16.80 First-Class Package Service 1 0.25 lbs $4.01 $3.56 $0.45
218915 2020-12-18 $11.09 First-Class Mail Stamped Letter 1 0.05 lbs $3.10 $3.03 $0.07
218916 2020-12-18 $6.36 First-Class Package Service 1 0.38 lbs $4.37 $3.92 $0.45
218917 2020-12-18 $23.83 Priority Mail 2-Day Small Flat Rate Box 7 0.28 lbs $8.90 $8.05 $0.85
218918 2020-12-18 $20.60 First-Class Package Service 3 0.45 lbs $4.70 $4.25 $0.45
218920 2020-12-18 $46.32 First-Class Package Service 2 0.62 lbs $5.62 $5.37 $0.25
218922 2020-12-19 $8.39 USPSFirstClass 1 0.08 lbs $4.40 $3.43 $0.97
218923 2020-12-19 $30.53 Priority Mail 3-Day 1 0.74 lbs $11.24 $10.39 $0.85
218925 2020-12-19 $6.14 USPSFirstClass 1 0.19 lbs $4.15 $3.30 $0.85
218928 2020-12-19 $9.18 USPSFirstClass 1 0.05 lbs $4.29 $3.30 $0.99
218930 2020-12-19 $44.32 First-Class Package Service 1 0.76 lbs $5.74 $5.29 $0.45
218937 2020-12-19 $36.19 First-Class Package Service 1 0.40 lbs $6.20 $5.95 $0.25
218938 2020-12-19 $8.59 First-Class Mail Stamped Letter 1 0.05 lbs $3.10 $2.99 $0.11
218939 2020-12-19 $38.69 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $8.90 $7.90 $1.00
218940 2020-12-19 $38.69 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $8.90 $7.65 $1.25
218941 2020-12-19 $60.49 Priority Mail 2-Day 7 1.49 lbs $11.24 $10.82 $0.42
218942 2020-12-19 $27.21 USPSFirstClass 3 1.82 lbs $16.44 $8.24 $8.20
218943 2020-12-19 $10.39 First-Class Mail Stamped Letter 1 0.19 lbs $3.40 $3.09 $0.31
218948 2020-12-20 $15.06 USPSFirstClass 2 0.90 lbs $7.68 $8.04 $-0.36
218949 2020-12-19 $228.98 Ground 1 21.00 lbs $35.79 $31.07 $4.72
218951 2020-12-19 $45.49 Priority Mail 2-Day Padded Flat Rate Envelope 1 2.44 lbs $9.00 $8.15 $0.85
218953 2020-12-19 $66.10 Priority Mail 3-Day 2 4.60 lbs $19.72 $18.87 $0.85
218954 2020-12-19 $43.40 Priority Mail 3-Day Small Flat Rate Box 1 0.12 lbs $8.90 $8.05 $0.85
218957 2020-12-20 $21.21 First-Class Package Service 2 0.43 lbs $4.63 $4.18 $0.45
218958 2020-12-20 $14.81 First-Class Package Service 1 0.40 lbs $5.02 $3.77 $1.25
218960 2020-12-20 $8.77 USPSFirstClass 2 0.40 lbs $4.99 $4.57 $0.42
218961 2020-12-20 $26.66 Priority Mail 3-Day 3 1.14 lbs $11.79 $10.94 $0.85
218963 2020-12-20 $9.03 USPSFirstClass 1 0.04 lbs $4.14 $3.03 $1.11
218964 2020-12-20 $171.24 Priority Mail 2-Day Medium Flat Rate Box 161 7.40 lbs $14.85 $13.60 $1.25
218966 2020-12-20 $458.50 Ground 2 26.30 lbs $38.52 $29.70 $8.82
218968 2020-12-20 $20.88 Priority Mail 2-Day Small Flat Rate Box 2 0.04 lbs $8.90 $8.05 $0.85
218970 2020-12-20 $83.67 Priority Mail 2-Day Flat Rate Envelope 3 2.35 lbs $8.40 $8.00 $0.40
218971 2020-12-20 $18.35 First-Class Package Service 2 0.38 lbs $4.37 $3.43 $0.94
218973 2020-12-20 $6.94 First-Class Mail Stamped Letter 1 0.04 lbs $2.95 $3.18 $-0.23
218974 2020-12-20 $10.57 First-Class Mail Stamped Letter 3 0.06 lbs $3.10 $3.18 $-0.08
218975 2020-12-20 $51.88 Priority Mail 2-Day 1 1.55 lbs $8.89 $7.90 $0.99
218977 2020-12-20 $44.86 First-Class Package Service 9 0.35 lbs $3.95 $3.50 $0.45
218980 2020-12-20 $8.09 First-Class Mail Stamped Letter 1 0.06 lbs $3.10 $3.18 $-0.08
218986 2020-12-20 $22.36 First-Class Package Service 4 0.72 lbs $5.90 $5.65 $0.25
218988 2020-12-20 $42.35 Priority Mail 2-Day Flat Rate Envelope 5 0.90 lbs $8.40 $7.90 $0.50
218989 2020-12-20 $17.02 Priority Mail 2-Day Flat Rate Envelope 1 0.06 lbs $8.40 $8.05 $0.35
218991 2020-12-20 $131.90 Ground Home Delivery 2 7.85 lbs $23.92 $19.61 $4.31
218992 2020-12-21 $8.14 USPSFirstClass 1 0.04 lbs $4.15 $3.09 $1.06
218993 2020-12-20 $25.71 First-Class Package Service 1 0.35 lbs $4.22 $3.77 $0.45
218994 2020-12-20 $11.00 First-Class Package Service 1 0.17 lbs $4.01 $3.56 $0.45
218997 2020-12-21 $14.43 First-Class Package Service 1 0.30 lbs $4.22 $3.77 $0.45
218998 2020-12-21 $27.26 Priority Mail 2-Day 1 1.70 lbs $9.37 $8.52 $0.85
218999 2020-12-21 $39.68 Priority Mail 3-Day Small Flat Rate Box 2 1.17 lbs $8.90 $7.90 $1.00
219001 2020-12-21 $233.89 Ground 4 8.75 lbs $13.93 $17.06 $-3.13
219003 2020-12-21 $32.85 First-Class Package Service - Retail 10 0.33 lbs $5.85 $3.92 $1.93
219004 2020-12-21 $10.55 USPSFirstClass 1 0.20 lbs $4.26 $3.09 $1.17
219006 2020-12-21 $7.95 First-Class Mail Stamped Letter 1 0.05 lbs $3.10 $2.99 $0.11
219011 2020-12-21 $7.14 First-Class Mail Stamped Letter 1 0.15 lbs $3.25 $3.92 $-0.67
219013 2020-12-21 $210.20 Ground 11 7.01 lbs $29.06 $20.75 $8.31
219014 2020-12-21 $28.71 Priority Mail 2-Day 2 0.46 lbs $9.23 $8.05 $1.18
219015 2020-12-21 $64.83 Priority Mail 2-Day Medium Flat Rate Box 2 1.90 lbs $14.85 $11.63 $3.22
219016 2020-12-21 $49.23 Priority Mail 2-Day 1 1.20 lbs $12.44 $11.69 $0.75
219019 2020-12-21 $17.09 USPSFirstClass 1 0.05 lbs $4.81 $3.43 $1.38
219020 2020-12-21 $3.44 First-Class Mail Stamped Letter 1 0.01 lbs $2.95 $3.09 $-0.14
219021 2020-12-21 $63.78 Priority Mail 3-Day Padded Flat Rate Envelope 2 1.18 lbs $9.00 $8.15 $0.85
219024 2020-12-21 $25.52 First-Class Package Service 2 0.10 lbs $3.54 $3.09 $0.45
219026 2020-12-21 $38.69 Priority Mail 3-Day Small Flat Rate Box 1 1.40 lbs $8.90 $8.05 $0.85
219029 2020-12-22 $9.13 USPSFirstClass 1 0.05 lbs $4.24 $3.18 $1.06
219032 2020-12-21 $24.14 Priority Mail 2-Day Small Flat Rate Box 6 1.14 lbs $8.90 $7.90 $1.00
219033 2020-12-21 $48.99 Direct Link International 8 0.77 lbs $23.14 $5.37 $17.77
219034 2020-12-21 $28.38 Priority Mail 3-Day Flat Rate Envelope 1 0.35 lbs $8.40 $8.05 $0.35
219037 2020-12-21 $51.89 Priority Mail 2-Day Small Flat Rate Box 1 1.55 lbs $8.90 $7.90 $1.00
219038 2020-12-21 $51.89 Priority Mail 2-Day Small Flat Rate Box 1 1.55 lbs $8.90 $7.90 $1.00
219040 2020-12-21 $28.26 Direct Link International 1 0.06 lbs $19.27 $3.03 $16.24
219041 2020-12-22 $27.35 First-Class Package Service 3 0.32 lbs $4.58 $4.33 $0.25
219042 2020-12-22 $9.29 USPSFirstClass 1 0.06 lbs $4.30 $3.30 $1.00
219043 2020-12-22 $80.31 Priority Mail 2-Day 1 2.85 lbs $10.32 $8.61 $1.71
219046 2020-12-22 $46.83 Priority Mail 3-Day 3 1.52 lbs $9.37 $8.61 $0.76
219047 2020-12-22 $56.23 Priority Mail 3-Day 1 1.10 lbs $11.24 $10.44 $0.80
219048 2020-12-22 $58.34 Priority Mail 2-Day Medium Flat Rate Box 1 12.00 lbs $14.85 $13.60 $1.25
219049 2020-12-22 $11.34 USPSFirstClass 1 0.19 lbs $4.35 $3.18 $1.17
219051 2020-12-22 $51.78 Priority Mail 2-Day Padded Flat Rate Envelope 2 1.62 lbs $9.00 $7.90 $1.10
219053 2020-12-22 $37.25 Priority Mail 2-Day 2 1.05 lbs $9.37 $8.61 $0.76
219055 2020-12-22 $51.89 Priority Mail 2-Day Small Flat Rate Box 1 1.55 lbs $8.90 $7.90 $1.00
219056 2020-12-22 $15.32 First-Class Package Service 6 0.24 lbs $4.88 $3.58 $1.30
219061 2020-12-22 $25.22 First-Class Package Service 10 0.25 lbs $4.22 $3.30 $0.92
Total 21025 order(s) 59971 29292.14 lbs $193562.51 $270247.54 $-76685.03