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
221817 2021-02-09 $18.21 USPSFirstClass 1 0.25 lbs $4.82 $3.06 $1.76
221818 2021-02-09 $18.26 USPSFirstClass 1 0.25 lbs $4.87 $3.57 $1.30
221819 2021-02-09 $15.75 USPSFirstClass 1 0.06 lbs $4.85 $3.35 $1.50
221820 2021-02-09 $14.53 USPSFirstClass 1 0.06 lbs $4.79 $3.35 $1.44
221821 2021-02-09 $6.76 USPSFirstClass 1 0.01 lbs $4.27 $3.06 $1.21
221822 2021-02-09 $15.60 USPSFirstClass 1 0.06 lbs $4.70 $3.06 $1.64
221823 2021-02-09 $10.70 USPSFirstClass 2 0.12 lbs $4.16 $3.01 $1.15
221824 2021-02-09 $7.73 USPSFirstClass 1 0.06 lbs $4.42 $3.22 $1.20
221825 2021-02-09 $10.60 USPSFirstClass 1 0.06 lbs $4.50 $3.12 $1.38
221826 2021-02-09 $7.73 USPSFirstClass 1 0.06 lbs $4.46 $3.35 $1.11
221827 2021-02-09 $10.90 USPSFirstClass 2 0.12 lbs $4.36 $3.12 $1.24
221828 2021-02-09 $19.44 USPSFirstClass 2 1.22 lbs $12.26 $11.69 $0.57
221829 2021-02-09 $9.54 USPSFirstClass 1 0.05 lbs $4.55 $3.35 $1.20
221830 2021-02-09 $21.41 USPSFirstClass 5 0.31 lbs $5.06 $3.06 $2.00
221831 2021-02-09 $9.28 USPSFirstClass 1 0.03 lbs $4.39 $3.06 $1.33
221832 2021-02-09 $9.44 USPSFirstClass 1 0.05 lbs $4.45 $3.12 $1.33
221833 2021-02-09 $9.28 USPSFirstClass 2 0.38 lbs $5.10 $3.58 $1.52
221834 2021-02-09 $15.60 USPSFirstClass 1 0.06 lbs $4.70 $3.06 $1.64
221835 2021-02-09 $11.14 Priority Mail 2-Day Flat Rate Envelope 1 0.05 lbs $8.25 $3.06 $5.19
221836 2021-02-09 $14.84 First-Class Package Service 1 0.05 lbs $3.85 $3.35 $0.50
221837 2021-02-09 $19.24 Priority Mail 2-Day Flat Rate Envelope 1 0.02 lbs $8.25 $7.90 $0.35
221838 2021-02-09 $38.54 Priority Mail 2-Day Small Flat Rate Box 1 1.30 lbs $8.75 $7.90 $0.85
221840 2021-02-09 $71.40 Priority Mail 2-Day 4 2.60 lbs $17.30 $16.45 $0.85
221842 2021-02-09 $120.90 Priority Mail 2-Day Medium Flat Rate Box 10 3.70 lbs $15.00 $12.64 $2.36
221849 2021-02-09 $10.34 First-Class Package Service - Retail 1 0.05 lbs $5.15 $3.35 $1.80
221850 2021-02-09 $21.11 First-Class Package Service 2 0.32 lbs $4.93 $4.68 $0.25
221852 2021-02-09 $16.54 First-Class Package Service - Retail 1 0.40 lbs $4.75 $4.12 $0.63
221853 2021-02-09 $6.99 First-Class Mail Stamped Letter 1 0.03 lbs $3.00 $3.22 $-0.22
221855 2021-02-09 $19.72 First-Class Package Service 1 0.35 lbs $4.93 $4.68 $0.25
221856 2021-01-29 $404.37 Priority Mail 3-Day 12 9.22 lbs $25.49 $13.75 $11.74
221858 2021-02-09 $39.83 Priority Mail 2-Day 12 2.28 lbs $13.55 $12.70 $0.85
221859 2021-02-09 $38.54 Priority Mail 2-Day Small Flat Rate Box 1 1.20 lbs $8.75 $7.90 $0.85
221860 2021-02-09 $5.19 First-Class Mail Stamped Letter 1 0.03 lbs $3.20 $3.22 $-0.02
221861 2021-02-09 $31.84 Priority Mail 2-Day Padded Flat Rate Envelope 1 0.75 lbs $8.85 $7.90 $0.95
221862 2021-02-09 $17.40 First-Class Package Service 3 0.48 lbs $4.63 $4.38 $0.25
221864 2021-02-09 $65.65 Priority Mail 2-Day Flat Rate Envelope 10 2.78 lbs $8.25 $7.90 $0.35
221865 2021-02-09 $20.62 First-Class Package Service 1 0.40 lbs $4.63 $4.38 $0.25
221866 2021-02-09 $29.53 First-Class Package Service 2 0.20 lbs $4.35 $3.85 $0.50
221867 2020-09-19 $33.79 Priority Mail 2-Day Medium Flat Rate Box 1 3.10 lbs $15.00 $13.75 $1.25
221869 2021-02-09 $30.65 Priority Mail 2-Day 5 0.76 lbs $9.70 $8.85 $0.85
221870 2021-02-09 $30.81 Priority Mail 2-Day 1 1.78 lbs $9.57 $8.00 $1.57
221871 2021-02-09 $14.19 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.35 $-0.15
221874 2021-02-09 $124.17 Priority Mail 3-Day Padded Flat Rate Envelope 4 5.60 lbs $8.85 $8.00 $0.85
221875 2021-02-09 $11.77 First-Class Mail Stamped Letter 3 0.04 lbs $3.00 $3.06 $-0.06
221876 2021-02-09 $13.78 First-Class Mail Stamped Letter 2 0.10 lbs $3.40 $3.06 $0.34
221877 2021-02-09 $76.80 Priority Mail 3-Day 1 3.95 lbs $22.81 $21.96 $0.85
221879 2021-02-09 $12.03 First-Class Package Service 4 0.32 lbs $4.07 $4.20 $-0.13
221881 2021-02-09 $8.39 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.22 $-0.02
221884 2021-02-10 $6.87 First-Class Mail Stamped Letter 3 0.10 lbs $3.40 $3.35 $0.05
221890 2021-02-10 $57.73 Priority Mail 3-Day 6 11.83 lbs $25.87 $36.38 $-10.51
221893 2021-02-10 $17.77 First-Class Package Service - Retail 2 0.20 lbs $5.85 $3.58 $2.27
221894 2021-02-10 $13.88 First-Class Package Service 4 0.76 lbs $5.92 $3.12 $2.80
221897 2021-02-10 $27.54 First-Class Package Service 4 0.20 lbs $4.08 $3.58 $0.50
221898 2021-02-10 $23.20 Priority Mail 3-Day Small Flat Rate Box 5 0.25 lbs $8.75 $7.90 $0.85
221899 2021-02-10 $74.67 Priority Mail 2-Day Padded Flat Rate Envelope 2 2.80 lbs $8.85 $8.00 $0.85
221900 2021-02-10 $6.09 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.35 $-0.15
221902 2021-02-10 $11.62 Priority Mail 2-Day 1 0.05 lbs $8.73 $7.40 $1.33
221906 2021-02-10 $21.45 First-Class Package Service 6 0.25 lbs $4.01 $3.51 $0.50
221907 2021-02-10 $51.74 Priority Mail 3-Day Small Flat Rate Box 1 1.25 lbs $8.75 $7.90 $0.85
221908 2021-02-10 $8.80 First-Class Package Service 2 0.40 lbs $4.62 $3.51 $1.11
221911 2021-02-10 $46.84 Priority Mail 3-Day Padded Flat Rate Envelope 1 2.95 lbs $8.85 $8.00 $0.85
221920 2021-02-10 $6.09 First-Class Mail Stamped Letter 1 0.05 lbs $3.20 $3.06 $0.14
221921 2021-02-10 $10.88 First-Class Package Service 2 0.14 lbs $4.10 $3.85 $0.25
221922 2021-02-10 $9.99 First-Class Mail Stamped Letter 1 0.03 lbs $3.20 $3.22 $-0.02
221925 2021-02-10 $47.87 First-Class Package Service 1 0.56 lbs $4.88 $4.38 $0.50
221926 2021-02-10 $84.19 Priority Mail 2-Day Flat Rate Envelope 1 1.15 lbs $8.25 $8.00 $0.25
221932 2021-02-11 $15.60 USPSFirstClass 1 0.06 lbs $4.70 $3.06 $1.64
221934 2021-02-11 $14.48 USPSFirstClass 2 0.20 lbs $4.50 $3.58 $0.92
221935 2021-02-11 $7.58 USPSFirstClass 1 0.06 lbs $4.31 $3.06 $1.25
221936 2021-02-11 $28.34 USPSFirstClass 1 0.15 lbs $5.40 $3.58 $1.82
221937 2021-02-11 $17.71 USPSFirstClass 1 0.03 lbs $4.89 $3.22 $1.67
221938 2021-02-11 $31.54 USPSFirstClass 3 0.54 lbs $6.07 $4.20 $1.87
221939 2021-02-11 $7.18 USPSFirstClass 1 0.05 lbs $4.29 $3.06 $1.23
221940 2021-02-11 $7.58 USPSFirstClass 1 0.06 lbs $4.31 $3.06 $1.25
221941 2021-02-11 $9.70 USPSFirstClass 1 0.06 lbs $4.37 $3.03 $1.34
221942 2021-02-11 $8.77 USPSFirstClass 1 0.10 lbs $4.42 $3.12 $1.30
221943 2021-02-11 $7.68 USPSFirstClass 1 0.06 lbs $4.41 $3.22 $1.19
221944 2021-02-11 $7.68 USPSFirstClass 1 0.06 lbs $4.41 $3.22 $1.19
221945 2021-02-11 $14.43 USPSFirstClass 1 0.06 lbs $4.69 $3.12 $1.57
221946 2021-02-11 $15.90 USPSFirstClass 1 0.06 lbs $5.00 $3.49 $1.51
221947 2021-02-11 $12.48 USPSFirstClass 1 0.06 lbs $4.69 $3.35 $1.34
221948 2021-02-11 $9.49 USPSFirstClass 1 0.02 lbs $4.50 $3.22 $1.28
221949 2021-02-11 $39.70 USPSPriority 1 1.60 lbs $11.51 $8.24 $3.27
221950 2021-02-11 $62.84 USPSFirstClass 1 0.50 lbs $7.85 $5.81 $2.04
221958 2021-02-11 $31.48 USPSPriority 1 3.10 lbs $12.69 $8.34 $4.35
221959 2021-02-11 $21.99 USPSFirstClass 1 0.40 lbs $6.00 $3.85 $2.15
221960 2021-02-11 $21.99 USPSFirstClass 1 0.40 lbs $6.00 $4.68 $1.32
221961 2021-02-11 $31.18 USPSFirstClass 1 0.80 lbs $7.68 $5.42 $2.26
221962 2021-02-11 $12.33 USPSFirstClass 1 0.06 lbs $4.54 $3.06 $1.48
221964 2021-02-11 $23.51 USPSFirstClass 1 0.06 lbs $5.02 $3.03 $1.99
221965 2021-02-11 $14.36 USPSFirstClass 3 0.75 lbs $5.69 $5.23 $0.46
221966 2021-02-11 $8.49 USPSFirstClass 1 0.09 lbs $4.50 $3.35 $1.15
221967 2021-02-11 $34.36 USPSFirstClass 7 1.75 lbs $14.13 $8.24 $5.89
221968 2021-02-11 $17.48 USPSFirstClass 1 0.35 lbs $5.69 $4.53 $1.16
221969 2021-02-11 $147.19 USPSPriority 1 3.62 lbs $27.20 $16.78 $10.42
221970 2021-02-11 $14.47 USPSFirstClass 2 0.12 lbs $4.69 $3.49 $1.20
221971 2021-02-11 $143.59 USPSPriority 1 3.62 lbs $23.60 $14.80 $8.80
221972 2021-02-11 $140.19 USPSPriority 1 3.62 lbs $20.20 $12.42 $7.78
221973 2021-02-11 $117.45 FedExHomeDelivery 2 3.68 lbs $21.69 $20.33 $1.36
221974 2021-02-11 $9.49 USPSFirstClass 1 0.05 lbs $4.50 $3.22 $1.28
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56