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
223896 2021-04-04 $23.42 First-Class Package Service 1 0.40 lbs $5.03 $4.53 $0.50
223897 2021-04-05 $11.04 First-Class Package Service 3 0.14 lbs $4.07 $3.12 $0.95
223898 2021-04-05 $7.39 USPSFirstClass 1 0.10 lbs $4.40 $3.22 $1.18
223899 2021-04-05 $13.48 USPSFirstClass 1 0.05 lbs $4.69 $3.22 $1.47
223900 2021-04-05 $12.43 USPSFirstClass 1 0.06 lbs $4.64 $3.22 $1.42
223901 2021-04-05 $38.19 USPSFirstClass 1 0.89 lbs $10.20 $10.44 $-0.24
223902 2021-04-05 $7.59 USPSFirstClass 1 0.10 lbs $4.60 $3.49 $1.11
223903 2021-04-05 $22.91 First-Class Package Service 1 0.35 lbs $4.07 $3.57 $0.50
223904 2021-04-05 $42.59 First-Class Package Service 3 0.15 lbs $3.62 $3.57 $0.05
223905 2021-04-05 $22.05 First-Class Package Service 3 0.35 lbs $4.08 $3.58 $0.50
223906 2021-04-05 $27.54 Priority Mail 3-Day 3 0.40 lbs $9.37 $7.90 $1.47
223911 2021-04-05 $64.74 Priority Mail 3-Day 2 1.40 lbs $17.30 $11.69 $5.61
223913 2021-04-05 $52.54 Priority Mail 3-Day 1 1.80 lbs $13.55 $12.70 $0.85
223914 2021-04-05 $15.36 Priority Mail 3-Day 1 0.14 lbs $9.37 $8.52 $0.85
223915 2021-04-05 $10.05 USPSFirstClass 1 0.06 lbs $4.72 $3.49 $1.23
223916 2021-04-05 $9.76 USPSFirstClass 1 0.07 lbs $4.51 $3.22 $1.29
223917 2021-04-05 $19.24 Priority Mail 2-Day Flat Rate Envelope 1 0.10 lbs $8.25 $7.90 $0.35
223918 2021-04-05 $14.85 First-Class Mail Stamped Letter 5 0.21 lbs $3.40 $3.22 $0.18
223919 2021-04-05 $14.23 Priority Mail 2-Day Flat Rate Envelope 2 0.10 lbs $8.25 $7.40 $0.85
223922 2021-04-05 $124.73 Priority Mail 2-Day Medium Flat Rate Box 2 50.10 lbs $28.75 $13.75 $15.00
223923 2021-04-05 $19.38 First-Class Mail Stamped Letter 2 0.10 lbs $3.40 $3.12 $0.28
223924 2021-04-05 $31.52 Priority Mail 3-Day Small Flat Rate Box 2 0.50 lbs $8.75 $7.90 $0.85
223925 2021-04-05 $39.83 Priority Mail 2-Day 6 1.07 lbs $9.09 $8.24 $0.85
223927 2021-04-05 $13.83 First-Class Package Service 2 0.12 lbs $3.85 $3.35 $0.50
223929 2021-04-05 $7.99 First-Class Mail Stamped Letter 1 0.04 lbs $3.00 $3.12 $-0.12
223930 2021-04-06 $47.17 Priority Mail 3-Day Flat Rate Envelope 8 0.90 lbs $8.25 $7.90 $0.35
223932 2021-04-06 $19.14 Priority Mail 3-Day Small Flat Rate Box 1 0.14 lbs $8.75 $7.90 $0.85
223933 2021-04-06 $16.72 First-Class Package Service 1 0.40 lbs $4.93 $4.68 $0.25
223934 2021-04-06 $27.49 First-Class Package Service 4 0.70 lbs $6.23 $5.98 $0.25
223935 2021-04-06 $7.81 USPSFirstClass 1 0.07 lbs $4.42 $3.22 $1.20
223936 2021-04-06 $26.04 USPSPriority 1 7.00 lbs $13.05 $9.65 $3.40
223937 2021-04-06 $9.75 USPSFirstClass 1 0.06 lbs $4.42 $3.06 $1.36
223939 2021-04-06 $16.00 First-Class Package Service 1 0.25 lbs $4.01 $3.51 $0.50
223940 2021-04-06 $7.33 USPSFirstClass 1 0.25 lbs $4.44 $3.69 $0.75
223941 2021-04-06 $7.91 USPSFirstClass 1 0.02 lbs $4.42 $3.22 $1.20
223943 2021-04-06 $12.48 USPSFirstClass 1 0.06 lbs $4.69 $3.35 $1.34
223944 2021-04-06 $10.03 First-Class Package Service 2 0.20 lbs $4.07 $3.57 $0.50
223945 2021-04-06 $10.07 First-Class Package Service 1 0.10 lbs $4.08 $3.22 $0.86
223947 2021-04-06 $7.34 USPSFirstClass 1 0.10 lbs $4.35 $3.12 $1.23
223950 2021-04-06 $116.12 Priority Mail 2-Day Flat Rate Envelope 3 4.12 lbs $8.25 $8.00 $0.25
223952 2021-04-06 $30.97 First-Class Package Service 4 0.40 lbs $4.93 $4.68 $0.25
223954 2021-04-06 $33.81 Priority Mail 3-Day Small Flat Rate Box 1 1.20 lbs $8.75 $7.90 $0.85
223957 2021-04-07 $12.33 USPSFirstClass 1 0.06 lbs $4.54 $3.06 $1.48
223958 2021-04-07 $12.38 USPSFirstClass 1 0.06 lbs $4.59 $3.12 $1.47
223959 2021-04-07 $17.65 USPSMedia 1 0.90 lbs $3.59 $3.45 $0.14
223962 2021-04-07 $12.33 USPSFirstClass 1 0.06 lbs $4.54 $3.06 $1.48
223963 2021-04-07 $20.34 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.15 lbs $8.85 $7.90 $0.95
223964 2021-04-07 $6.58 First-Class Mail Stamped Letter 2 0.02 lbs $3.60 $3.49 $0.11
223965 2021-04-07 $12.79 First-Class Mail Stamped Letter 11 0.11 lbs $3.40 $3.06 $0.34
223967 2021-04-07 $81.60 Priority Mail 2-Day 8 3.21 lbs $11.28 $10.43 $0.85
223968 2021-04-07 $56.74 Priority Mail 2-Day Small Flat Rate Box 1 1.50 lbs $8.75 $7.90 $0.85
223969 2021-04-07 $28.24 Priority Mail 3-Day Flat Rate Envelope 1 0.85 lbs $8.25 $8.00 $0.25
223970 2021-04-07 $28.24 Priority Mail 3-Day Flat Rate Envelope 1 0.85 lbs $8.25 $8.00 $0.25
223971 2021-04-07 $74.96 Priority Mail 2-Day Medium Flat Rate Box 4 3.20 lbs $15.00 $12.64 $2.36
223973 2021-04-07 $23.24 Priority Mail 2-Day Flat Rate Envelope 1 0.80 lbs $8.25 $8.00 $0.25
223975 2021-04-07 $65.47 Priority Mail 2-Day 2 2.00 lbs $10.49 $9.01 $1.48
223976 2021-04-07 $156.83 Priority Mail 3-Day 1 10.30 lbs $26.84 $30.47 $-3.63
223978 2021-04-07 $173.08 Priority Mail 2-Day 1 10.30 lbs $43.09 $42.24 $0.85
223979 2021-04-07 $28.24 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $8.25 $8.00 $0.25
223981 2021-04-07 $14.40 First-Class Package Service 1 0.14 lbs $4.01 $3.06 $0.95
223984 2021-04-07 $16.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.49 $-0.29
223985 2021-04-07 $42.87 Priority Mail 2-Day 2 0.98 lbs $11.29 $10.44 $0.85
223986 2021-04-07 $14.59 First-Class Mail Stamped Letter 2 0.15 lbs $3.40 $3.22 $0.18
223987 2021-04-08 $24.39 First-Class Package Service 1 0.90 lbs $6.23 $5.98 $0.25
223988 2021-04-08 $15.98 First-Class Package Service 1 0.30 lbs $4.19 $3.69 $0.50
223991 2021-04-08 $68.14 Priority Mail 3-Day Large Flat Rate Box 1 25.05 lbs $20.15 $13.75 $6.40
223992 2021-04-08 $29.26 USPSFirstClass 3 0.90 lbs $8.59 $5.27 $3.32
223993 2021-04-08 $6.55 USPSFirstClass 1 0.20 lbs $4.36 $3.58 $0.78
223994 2021-04-08 $7.71 USPSFirstClass 1 0.07 lbs $4.32 $3.06 $1.26
223996 2021-04-08 $33.71 Priority Mail 2-Day Flat Rate Envelope 1 1.10 lbs $8.25 $7.90 $0.35
223997 2021-04-08 $31.09 USPSPriority 1 1.70 lbs $11.10 $8.34 $2.76
224001 2021-04-08 $10.23 Priority Mail 2-Day Flat Rate Envelope 2 0.02 lbs $8.25 $7.40 $0.85
224004 2021-04-08 $6.33 First-Class Mail Stamped Letter 4 0.04 lbs $3.00 $3.01 $-0.01
224005 2021-04-08 $15.80 First-Class Package Service 1 0.30 lbs $4.01 $3.51 $0.50
224006 2021-04-08 $22.30 First-Class Package Service 1 0.30 lbs $4.01 $4.67 $-0.66
224007 2021-04-08 $19.14 Priority Mail 2-Day Small Flat Rate Box 1 0.14 lbs $8.75 $7.90 $0.85
224008 2021-04-08 $13.84 First-Class Package Service 1 0.13 lbs $3.85 $3.35 $0.50
224010 2021-04-08 $12.36 First-Class Package Service 2 0.30 lbs $4.07 $3.57 $0.50
224011 2021-04-08 $65.18 Priority Mail 2-Day Medium Flat Rate Box 2 2.20 lbs $15.40 $13.75 $1.65
224012 2021-04-08 $11.17 First-Class Mail Stamped Letter 3 0.07 lbs $3.20 $3.35 $-0.15
224016 2021-04-09 $11.99 First-Class Mail Stamped Letter 1 0.11 lbs $3.20 $3.35 $-0.15
224018 2021-04-09 $25.22 Priority Mail 3-Day Flat Rate Envelope 3 0.20 lbs $8.25 $7.90 $0.35
224020 2021-04-09 $19.80 First-Class Package Service 5 0.31 lbs $4.35 $3.85 $0.50
224023 2021-04-09 $14.34 Priority Mail 3-Day Padded Flat Rate Envelope 1 0.38 lbs $8.85 $8.00 $0.85
224024 2021-04-09 $18.80 First-Class Package Service 1 0.25 lbs $4.01 $3.51 $0.50
224025 2021-04-09 $44.31 Priority Mail 3-Day 1 1.65 lbs $9.70 $9.64 $0.06
224027 2021-04-09 $6.97 First-Class Package Service 2 0.02 lbs $3.99 $3.49 $0.50
224030 2021-04-09 $12.33 First-Class Package Service 2 0.30 lbs $4.35 $3.85 $0.50
224033 2021-04-09 $7.98 First-Class Mail Stamped Letter 2 0.04 lbs $3.00 $3.49 $-0.49
224034 2021-04-09 $5.96 First-Class Mail Stamped Letter 4 0.04 lbs $3.00 $3.12 $-0.12
224035 2021-04-09 $9.49 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.35 $-0.15
224036 2021-04-09 $10.54 USPSFirstClass 1 0.16 lbs $4.55 $3.22 $1.33
224037 2021-04-09 $33.34 First-Class Mail Stamped Letter 6 0.12 lbs $3.40 $4.68 $-1.28
224038 2021-04-09 $134.97 Priority Mail 2-Day Medium Flat Rate Box 3 9.75 lbs $15.00 $9.01 $5.99
224041 2021-04-09 $45.89 Priority Mail 2-Day Flat Rate Envelope 3 1.40 lbs $8.25 $7.90 $0.35
224042 2021-04-09 $27.81 Priority Mail 3-Day 6 0.42 lbs $9.37 $8.00 $1.37
224043 2021-04-09 $24.12 First-Class Package Service 1 0.60 lbs $4.63 $4.38 $0.25
224047 2021-04-09 $282.24 Priority Mail 2-Day 1 15.20 lbs $24.25 $23.40 $0.85
224049 2021-04-09 $52.62 Priority Mail 3-Day Flat Rate Envelope 3 2.58 lbs $8.25 $7.90 $0.35
224050 2021-04-09 $36.84 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.20 lbs $8.85 $7.90 $0.95
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56