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
219813 2021-01-05 $13.63 First-Class Package Service 1 0.35 lbs $3.84 $3.39 $0.45
219814 2021-01-05 $20.73 First-Class Package Service 1 0.25 lbs $3.84 $2.93 $0.91
219815 2021-01-06 $12.13 USPSFirstClass 1 0.06 lbs $4.34 $2.84 $1.50
219816 2021-01-05 $42.62 Priority Mail 2-Day Padded Flat Rate Envelope 1 1.40 lbs $8.60 $7.65 $0.95
219817 2021-01-06 $11.29 USPSFirstClass 1 0.19 lbs $4.30 $2.84 $1.46
219818 2021-01-06 $9.65 USPSFirstClass 1 0.06 lbs $4.32 $3.05 $1.27
219819 2021-01-06 $12.38 USPSFirstClass 1 0.06 lbs $4.59 $3.18 $1.41
219820 2021-01-06 $7.33 USPSFirstClass 1 0.06 lbs $4.06 $2.78 $1.28
219821 2021-01-06 $11.39 USPSFirstClass 1 0.19 lbs $4.40 $3.05 $1.35
219822 2021-01-05 $46.40 Priority Mail 2-Day 1 0.65 lbs $8.41 $7.56 $0.85
219823 2021-01-06 $31.89 USPSPriority 1 1.70 lbs $11.90 $8.76 $3.14
219824 2021-01-05 $26.39 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $8.00 $8.00 $0.00
219825 2021-01-05 $29.34 First-Class Package Service 2 0.23 lbs $3.76 $2.84 $0.92
219829 2021-01-06 $19.47 Priority Mail 3-Day Small Flat Rate Box 3 0.26 lbs $8.50 $7.65 $0.85
219830 2021-01-06 $59.70 Priority Mail 2-Day 3 1.47 lbs $9.61 $8.92 $0.69
219831 2021-01-06 $13.91 USPSFirstClass 1 0.10 lbs $4.42 $2.84 $1.58
219832 2021-01-06 $9.55 USPSFirstClass 1 0.06 lbs $4.22 $2.84 $1.38
219833 2021-01-06 $13.55 First-Class Package Service 1 0.30 lbs $3.76 $3.31 $0.45
219835 2021-01-06 $6.83 USPSFirstClass 1 0.06 lbs $4.04 $2.78 $1.26
219837 2021-01-06 $43.49 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $8.50 $7.65 $0.85
219839 2021-01-06 $24.53 First-Class Package Service 1 0.26 lbs $3.70 $3.25 $0.45
219840 2021-01-06 $45.88 Priority Mail 3-Day Flat Rate Envelope 2 1.80 lbs $8.00 $8.00 $0.00
219841 2021-01-06 $43.49 Priority Mail 3-Day Small Flat Rate Box 1 1.40 lbs $8.50 $7.90 $0.60
219842 2021-01-06 $12.18 USPSFirstClass 1 0.06 lbs $4.39 $2.93 $1.46
219844 2021-01-06 $10.07 First-Class Mail Stamped Letter 3 0.03 lbs $3.10 $3.18 $-0.08
219846 2021-01-06 $8.29 First-Class Mail Stamped Letter 1 0.08 lbs $3.10 $2.84 $0.26
219848 2021-01-06 $13.09 First-Class Mail Stamped Letter 1 0.07 lbs $3.10 $2.84 $0.26
219849 2021-01-06 $61.44 Priority Mail 2-Day 5 1.85 lbs $8.49 $8.00 $0.49
219850 2021-01-06 $18.44 First-Class Package Service - Retail 1 0.25 lbs $5.65 $3.58 $2.07
219852 2021-01-06 $9.96 USPSFirstClass 1 0.06 lbs $4.47 $3.18 $1.29
219853 2021-01-06 $15.93 USPSFirstClass 1 0.45 lbs $5.14 $3.93 $1.21
219855 2021-01-06 $9.22 First-Class Mail Stamped Letter 3 0.14 lbs $3.25 $3.18 $0.07
219856 2021-01-06 $89.01 Priority Mail 2-Day 2 5.05 lbs $15.03 $14.32 $0.71
219859 2020-07-31 $5.49 Priority Mail 3-Day Flat Rate Envelope 1 0.10 lbs $0.00 $7.90 $-7.90
219860 2021-01-06 $30.34 Priority Mail 2-Day 10 2.00 lbs $9.44 $8.12 $1.32
219861 2021-01-07 $24.50 InternationalPriorityShipping 1 0.07 lbs $4.31 $3.05 $1.26
219862 2021-01-07 $7.38 USPSFirstClass 1 0.06 lbs $4.11 $2.84 $1.27
219863 2021-01-07 $156.74 USPSPriority 1 2.88 lbs $20.08 $13.65 $6.43
219864 2021-01-07 $19.97 USPSFirstClass 2 0.12 lbs $4.39 $2.93 $1.46
219865 2021-01-07 $11.14 USPSFirstClass 1 0.19 lbs $4.15 $2.74 $1.41
219866 2021-01-06 $16.37 First-Class Package Service 2 0.62 lbs $5.79 $5.54 $0.25
219867 2021-01-07 $14.13 USPSFirstClass 1 0.06 lbs $4.39 $2.78 $1.61
219868 2021-01-07 $17.59 USPSFirstClass 1 0.05 lbs $4.60 $2.84 $1.76
219869 2021-01-07 $12.13 USPSFirstClass 1 0.06 lbs $4.34 $2.84 $1.50
219871 2021-01-07 $8.08 USPSFirstClass 1 0.05 lbs $4.19 $2.93 $1.26
219873 2021-01-06 $10.99 Priority Mail 3-Day Flat Rate Envelope 1 0.04 lbs $8.00 $7.65 $0.35
219874 2021-01-06 $15.66 First-Class Package Service 6 0.75 lbs $5.72 $5.27 $0.45
219875 2021-01-07 $9.65 USPSFirstClass 1 0.07 lbs $4.46 $3.18 $1.28
219876 2021-01-07 $6.98 USPSFirstClass 1 0.10 lbs $4.09 $2.84 $1.25
219877 2021-01-06 $41.67 Priority Mail 2-Day Flat Rate Envelope 3 1.19 lbs $8.00 $8.00 $0.00
219879 2021-01-06 $7.58 First-Class Mail Stamped Letter 2 0.11 lbs $3.10 $2.93 $0.17
219880 2021-01-07 $14.18 USPSFirstClass 2 0.12 lbs $4.20 $2.84 $1.36
219881 2021-01-06 $78.45 Priority Mail 3-Day Small Flat Rate Box 5 4.29 lbs $8.50 $7.65 $0.85
219882 2021-01-06 $7.02 First-Class Mail Stamped Letter 8 0.08 lbs $3.10 $2.78 $0.32
219883 2021-01-06 $14.32 First-Class Package Service 1 0.40 lbs $4.53 $3.31 $1.22
219884 2021-01-07 $14.18 USPSFirstClass 1 0.06 lbs $4.44 $2.84 $1.60
219886 2021-01-07 $17.10 FedExHomeDelivery 1 0.02 lbs $12.31 $15.20 $-2.89
219887 2021-01-07 $13.76 USPSFirstClass 1 0.10 lbs $4.27 $2.74 $1.53
219888 2021-01-07 $9.14 USPSFirstClass 1 0.05 lbs $4.15 $2.78 $1.37
219889 2021-01-07 $64.61 Priority Mail 3-Day Padded Flat Rate Envelope 1 1.51 lbs $8.60 $7.65 $0.95
219890 2021-01-07 $34.64 USPSPriority 1 1.70 lbs $14.65 $10.53 $4.12
219891 2021-01-07 $51.49 Priority Mail 3-Day Small Flat Rate Box 1 1.55 lbs $8.50 $7.90 $0.60
219892 2021-01-07 $20.22 First-Class Package Service 1 0.16 lbs $3.50 $3.25 $0.25
219893 2021-01-07 $43.49 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $8.50 $7.65 $0.85
219894 2021-01-07 $45.06 First-Class Package Service 9 0.81 lbs $6.15 $5.70 $0.45
219895 2021-01-07 $30.62 First-Class Package Service 5 0.55 lbs $4.77 $4.32 $0.45
219897 2021-01-07 $11.22 First-Class Package Service 2 0.19 lbs $3.84 $3.39 $0.45
219898 2021-01-07 $16.43 USPSPriority 1 0.06 lbs $8.64 $7.80 $0.84
219899 2021-01-07 $9.65 USPSFirstClass 1 0.07 lbs $4.46 $3.18 $1.28
219901 2021-01-07 $9.39 First-Class Mail Stamped Letter 1 0.05 lbs $3.10 $2.93 $0.17
219904 2021-01-07 $54.11 Priority Mail 3-Day Small Flat Rate Box 1 1.38 lbs $8.50 $7.75 $0.75
219905 2021-01-07 $16.65 First-Class Package Service 1 0.30 lbs $3.76 $3.31 $0.45
219906 2021-01-07 $86.26 Priority Mail 2-Day Padded Flat Rate Envelope 2 5.00 lbs $8.60 $7.75 $0.85
219907 2021-01-07 $6.98 USPSFirstClass 1 0.06 lbs $4.19 $3.05 $1.14
219908 2021-01-07 $19.35 USPSFirstClass 1 0.49 lbs $5.40 $3.25 $2.15
219909 2021-01-07 $7.38 USPSFirstClass 1 0.06 lbs $4.11 $2.84 $1.27
219910 2021-01-07 $31.89 USPSPriority 1 1.70 lbs $11.90 $8.76 $3.14
219911 2021-01-07 $7.61 USPSFirstClass 1 0.03 lbs $4.12 $2.84 $1.28
219912 2021-01-07 $17.10 USPSFirstClass 1 0.29 lbs $5.39 $2.93 $2.46
219914 2021-01-07 $23.24 Priority Mail 2-Day Flat Rate Envelope 6 1.14 lbs $8.00 $7.90 $0.10
219917 2021-01-07 $13.63 First-Class Package Service 1 0.35 lbs $3.84 $3.39 $0.45
219920 2021-01-07 $6.03 USPSFirstClass 2 0.02 lbs $4.05 $2.93 $1.12
219923 2021-01-07 $11.54 USPSFirstClass 1 0.06 lbs $4.55 $3.18 $1.37
219924 2021-01-07 $9.50 USPSFirstClass 1 0.06 lbs $4.17 $2.78 $1.39
219925 2021-01-07 $17.05 USPSFirstClass 1 0.29 lbs $5.34 $3.31 $2.03
219927 2021-01-07 $85.28 Ground 1 3.85 lbs $25.29 $23.36 $1.93
219928 2021-01-07 $147.81 Priority Mail 3-Day Medium Flat Rate Box 5 3.66 lbs $14.45 $10.53 $3.92
219931 2021-01-07 $9.66 USPSFirstClass 1 0.06 lbs $4.17 $2.78 $1.39
219932 2021-01-07 $59.14 Priority Mail 2-Day 6 1.86 lbs $13.00 $10.89 $2.11
219933 2021-01-08 $19.11 USPSFirstClass 1 0.04 lbs $4.62 $2.78 $1.84
219935 2021-01-07 $43.49 Priority Mail 2-Day Small Flat Rate Box 1 1.40 lbs $8.50 $7.65 $0.85
219936 2021-01-08 $9.50 USPSFirstClass 1 0.10 lbs $4.31 $3.05 $1.26
219937 2021-01-08 $35.84 USPSFirstClass 1 0.56 lbs $6.85 $4.00 $2.85
219939 2021-01-07 $16.59 Priority Mail 3-Day Padded Flat Rate Envelope 1 0.05 lbs $8.60 $7.56 $1.04
219941 2021-01-07 $27.99 Priority Mail 2-Day Flat Rate Envelope 1 0.85 lbs $8.00 $7.75 $0.25
219943 2021-01-08 $66.94 USPSPriority 1 1.12 lbs $13.57 $7.65 $5.92
219944 2021-01-07 $5.94 First-Class Mail Stamped Letter 1 0.01 lbs $2.95 $2.78 $0.17
219945 2021-01-08 $33.39 USPSFirstClass 1 0.25 lbs $5.40 $3.39 $2.01
219946 2021-01-08 $26.74 USPSFirstClass 1 0.40 lbs $5.75 $4.00 $1.75
219948 2021-01-08 $23.61 USPSFirstClass 1 0.06 lbs $5.12 $3.18 $1.94
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56