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
224810 2021-05-09 $6.56 First-Class Mail Stamped Letter 4 0.04 lbs $3.60 $3.22 $0.38
224811 2021-05-09 $14.58 First-Class Package Service 1 0.35 lbs $5.05 $3.85 $1.20
224818 2021-05-10 $29.63 Priority Mail 3-Day 1 0.95 lbs $9.34 $8.34 $1.00
224820 2021-05-10 $33.74 First-Class Package Service 5 0.23 lbs $4.71 $3.51 $1.20
224821 2021-05-10 $12.94 First-Class Package Service 1 0.20 lbs $5.05 $3.49 $1.56
224822 2021-05-10 $28.59 First-Class Package Service 4 0.18 lbs $4.71 $3.51 $1.20
224823 2021-05-10 $212.15 Ground 12 10.86 lbs $26.27 $18.30 $7.97
224824 2021-05-10 $52.21 Priority Mail 3-Day 3 1.00 lbs $9.34 $8.24 $1.10
224826 2021-05-10 $62.84 First-Class Package Service 8 0.43 lbs $5.32 $3.51 $1.81
224827 2021-05-10 $9.59 First-Class Mail Stamped Letter 1 0.10 lbs $3.60 $3.49 $0.11
224829 2021-05-10 $8.79 First-Class Mail Stamped Letter 1 0.08 lbs $3.80 $3.49 $0.31
224830 2021-05-10 $48.85 First-Class Package Service 8 0.50 lbs $5.73 $3.35 $2.38
224831 2021-05-10 $26.86 First-Class Package Service 1 0.80 lbs $6.37 $5.42 $0.95
224833 2021-05-10 $66.38 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.80 lbs $9.10 $8.00 $1.10
224835 2021-05-10 $268.07 Priority Mail 3-Day 1 14.05 lbs $38.08 $32.28 $5.80
224836 2021-05-10 $32.92 Priority Mail 2-Day 2 1.61 lbs $9.34 $8.72 $0.62
224837 2021-05-10 $29.22 First-Class Package Service 2 0.23 lbs $4.78 $3.58 $1.20
224839 2021-05-10 $52.33 Priority Mail 3-Day 3 1.34 lbs $9.95 $8.85 $1.10
224846 2021-05-11 $10.67 First-Class Package Service 2 0.10 lbs $4.69 $3.49 $1.20
224850 2021-05-11 $115.01 Priority Mail 3-Day 3 4.28 lbs $12.80 $11.70 $1.10
224853 2021-05-11 $54.46 Ground 3 1.25 lbs $21.99 $17.29 $4.70
224855 2021-05-11 $8.55 USPSMedia 1 0.23 lbs $3.16 $2.89 $0.27
224856 2021-05-11 $10.19 First-Class Package Service 1 0.20 lbs $4.89 $3.69 $1.20
224858 2021-05-11 $49.36 Priority Mail 3-Day Padded Flat Rate Envelope 1 1.31 lbs $9.10 $8.00 $1.10
224859 2021-05-11 $45.22 First-Class Package Service 6 0.33 lbs $4.78 $3.58 $1.20
224860 2021-05-11 $7.39 USPSFirstClass 1 0.03 lbs $4.40 $3.22 $1.18
224861 2021-05-11 $27.83 Priority Mail 2-Day 2 0.70 lbs $8.77 $7.67 $1.10
224863 2021-05-11 $111.88 Priority Mail 2-Day 2 3.30 lbs $15.90 $7.40 $8.50
224864 2020-11-21 $102.04 Ground Home Delivery 2 3.05 lbs $8.03 $11.42 $-3.39
224865 2021-05-11 $10.01 First-Class Package Service 1 0.15 lbs $4.42 $3.22 $1.20
224867 2021-05-11 $13.98 First-Class Mail Stamped Letter 2 0.15 lbs $4.00 $3.69 $0.31
224868 2021-05-11 $199.47 Priority Mail 3-Day 2 19.95 lbs $53.14 $45.04 $8.10
224869 2021-05-11 $17.01 First-Class Package Service 6 0.24 lbs $5.07 $3.51 $1.56
224870 2021-05-11 $25.82 First-Class Package Service 1 0.60 lbs $5.33 $4.38 $0.95
224872 2021-05-11 $29.99 Priority Mail 3-Day Flat Rate Envelope 1 0.90 lbs $8.50 $8.00 $0.50
224876 2021-05-11 $51.09 Priority Mail 2-Day Padded Flat Rate Envelope 1 2.12 lbs $9.10 $8.00 $1.10
224877 2021-05-11 $42.17 First-Class Package Service 1 0.70 lbs $7.18 $5.98 $1.20
224879 2021-05-11 $27.51 First-Class Package Service 1 0.45 lbs $5.32 $4.12 $1.20
224880 2021-05-11 $51.18 Priority Mail 3-Day 8 3.28 lbs $20.06 $21.96 $-1.90
224881 2021-05-11 $10.82 First-Class Package Service 2 0.07 lbs $4.21 $3.01 $1.20
224884 2021-05-12 $231.38 Priority Mail 2-Day 1 14.05 lbs $38.08 $32.28 $5.80
224885 2021-05-12 $43.71 Priority Mail 2-Day 2 1.70 lbs $9.95 $8.00 $1.95
224886 2021-05-12 $38.79 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $9.00 $7.90 $1.10
224890 2021-05-12 $12.43 USPSFirstClass 1 0.06 lbs $4.64 $3.22 $1.42
224891 2021-05-12 $11.11 First-Class Package Service 1 0.05 lbs $4.32 $3.12 $1.20
224893 2021-05-12 $38.10 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $9.00 $7.90 $1.10
224896 2021-05-12 $9.74 First-Class Mail Stamped Letter 6 0.06 lbs $3.80 $3.22 $0.58
224898 2021-05-12 $48.32 Priority Mail 2-Day Small Flat Rate Box 2 1.50 lbs $9.00 $7.90 $1.10
224899 2021-05-12 $33.36 First-Class Package Service 7 0.71 lbs $6.61 $5.66 $0.95
224901 2021-05-12 $44.89 Priority Mail 2-Day 1 0.70 lbs $9.90 $7.90 $2.00
224903 2021-05-12 $12.33 USPSFirstClass 1 0.06 lbs $4.54 $3.06 $1.48
224909 2021-05-12 $78.48 Priority Mail 3-Day Flat Rate Envelope 2 2.35 lbs $8.50 $8.00 $0.50
224910 2021-05-12 $14.75 Priority Mail 2-Day 2 0.40 lbs $8.77 $7.90 $0.87
224911 2021-05-12 $28.49 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $8.50 $8.00 $0.50
224913 2021-05-13 $36.53 First-Class Package Service 4 0.24 lbs $4.77 $3.57 $1.20
224916 2021-05-13 $12.81 First-Class Package Service - Retail 4 0.05 lbs $5.35 $3.22 $2.13
224919 2021-05-13 $9.81 USPSFirstClass 1 0.06 lbs $4.42 $3.06 $1.36
224920 2021-05-13 $12.33 USPSFirstClass 1 0.06 lbs $4.54 $3.06 $1.48
224921 2021-05-13 $15.57 First-Class Package Service 1 0.30 lbs $4.78 $4.38 $0.40
224922 2021-05-13 $15.62 USPSFirstClass 3 0.15 lbs $4.49 $3.35 $1.14
224924 2021-05-13 $22.26 First-Class Package Service 2 0.27 lbs $4.78 $3.58 $1.20
224925 2021-05-13 $21.76 First-Class Package Service 1 0.25 lbs $4.77 $3.57 $1.20
224927 2021-05-13 $61.30 Priority Mail 2-Day 5 1.91 lbs $17.55 $11.69 $5.86
224928 2021-05-13 $42.00 First-Class Package Service 1 0.70 lbs $7.01 $5.81 $1.20
224930 2021-05-13 $48.02 Priority Mail 2-Day Flat Rate Envelope 2 1.80 lbs $8.50 $8.00 $0.50
224931 2021-05-13 $233.22 Ground Home Delivery 7 7.30 lbs $27.00 $20.75 $6.25
224933 2021-05-13 $68.78 Priority Mail 2-Day Medium Flat Rate Box 13 1.24 lbs $15.40 $11.69 $3.71
224934 2021-05-13 $57.79 Priority Mail 2-Day 1 2.20 lbs $13.80 $10.89 $2.91
224935 2021-05-14 $16.42 USPSFirstClass 3 0.15 lbs $4.45 $3.22 $1.23
224937 2021-05-13 $55.99 Priority Mail 3-Day Small Flat Rate Box 1 1.45 lbs $9.00 $7.90 $1.10
224938 2021-05-13 $25.47 First-Class Package Service 1 0.40 lbs $5.58 $4.38 $1.20
224940 2021-05-13 $42.97 First-Class Package Service 1 0.70 lbs $6.39 $5.19 $1.20
224941 2021-05-13 $129.27 Priority Mail 2-Day 2 4.28 lbs $17.97 $13.75 $4.22
224944 2021-05-13 $11.75 First-Class Mail Stamped Letter 5 0.06 lbs $3.80 $3.49 $0.31
224945 2021-05-13 $16.27 First-Class Package Service 1 0.35 lbs $4.78 $4.38 $0.40
224946 2021-05-13 $85.08 Priority Mail 3-Day Padded Flat Rate Envelope 2 4.82 lbs $9.10 $8.00 $1.10
224947 2021-05-13 $9.58 First-Class Mail Stamped Letter 2 0.03 lbs $3.60 $3.06 $0.54
224950 2021-05-14 $46.22 Priority Mail International Flat Rate Envelope 2 0.40 lbs $28.20 $56.20 $-28.00
224951 2021-05-14 $16.02 First-Class Package Service 1 0.55 lbs $5.58 $5.66 $-0.08
224953 2021-05-14 $8.44 USPSFirstClass 1 0.10 lbs $4.45 $3.22 $1.23
224954 2021-05-14 $12.33 USPSFirstClass 1 0.06 lbs $4.54 $3.06 $1.48
224955 2021-05-14 $29.11 First-Class Package Service 1 0.45 lbs $5.32 $4.12 $1.20
224958 2021-05-14 $43.99 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $9.00 $7.90 $1.10
224960 2021-05-14 $5.58 First-Class Mail Stamped Letter 2 0.02 lbs $3.60 $3.22 $0.38
224963 2021-05-14 $14.31 First-Class Package Service 1 0.13 lbs $4.32 $3.12 $1.20
224964 2021-05-14 $9.58 USPSFirstClass 1 0.04 lbs $4.69 $3.49 $1.20
224965 2021-05-14 $27.66 First-Class Package Service 1 0.35 lbs $4.77 $3.57 $1.20
224966 2021-05-14 $8.39 USPSFirstClass 1 0.05 lbs $4.40 $3.12 $1.28
224967 2021-05-14 $7.06 USPSFirstClass 1 0.10 lbs $4.57 $3.49 $1.08
224968 2021-05-14 $32.35 Priority Mail 3-Day 1 2.14 lbs $15.20 $11.63 $3.57
224969 2021-05-14 $90.48 Priority Mail 3-Day 1 5.65 lbs $20.49 $15.47 $5.02
224970 2021-05-14 $8.66 First-Class Package Service 1 0.20 lbs $4.66 $3.01 $1.65
224971 2021-05-14 $85.38 Priority Mail 2-Day Medium Flat Rate Box 2 2.40 lbs $15.40 $10.82 $4.58
224973 2021-05-14 $10.28 First-Class Mail Stamped Letter 2 0.07 lbs $3.80 $3.22 $0.58
224977 2021-05-14 $85.10 Priority Mail 2-Day Padded Flat Rate Envelope 1 2.25 lbs $9.10 $8.00 $1.10
224978 2021-05-14 $48.48 Priority Mail 2-Day Flat Rate Envelope 2 1.40 lbs $8.50 $8.00 $0.50
224979 2021-05-14 $24.27 First-Class Package Service 4 0.20 lbs $4.71 $3.06 $1.65
224980 2021-05-15 $47.04 Priority Mail 2-Day 1 2.20 lbs $10.74 $9.01 $1.73
224982 2021-05-15 $10.74 USPSFirstClass 1 0.04 lbs $4.75 $3.49 $1.26
224985 2021-05-15 $38.03 First-Class Package Service 4 0.73 lbs $6.37 $5.42 $0.95
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56