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
229605 2022-07-03 $13.17 First-Class Package Service 2 0.20 lbs $5.19 $3.72 $1.47
229606 2022-07-04 $19.04 First-Class Package Service 2 0.12 lbs $5.06 $4.15 $0.91
229607 2022-07-04 $12.54 USPS First Class 1 0.06 lbs $4.65 $3.42 $1.23
229608 2022-07-04 $8.19 USPS First Class 1 0.05 lbs $4.80 $3.72 $1.08
229609 2022-07-04 $25.10 USPS Parcel Select Ground 1 0.91 lbs $8.61 $10.21 $-1.60
229610 2022-07-04 $12.69 USPS First Class 1 0.06 lbs $4.80 $3.72 $1.08
229611 2022-07-04 $14.69 USPS First Class 1 0.05 lbs $4.70 $3.48 $1.22
229612 2022-07-04 $63.94 USPS Priority Mail 1 1.60 lbs $11.75 $8.25 $3.50
229613 2022-07-04 $13.24 USPS First Class 1 0.06 lbs $4.75 $3.58 $1.17
229614 2022-07-04 $40.37 Priority Mail 2-Day Flat Rate Envelope 8 0.72 lbs $8.85 $8.25 $0.60
229616 2022-07-04 $10.19 First-Class Package Service 2 0.06 lbs $5.06 $3.86 $1.20
229644 2022-07-06 $31.32 USPS First Class 3 0.16 lbs $14.25 $3.58 $10.67
229645 2022-07-06 $14.99 USPS First Class 1 0.20 lbs $5.00 $3.86 $1.14
229673 2022-07-07 $16.98 Priority Mail 2-Day Flat Rate Envelope 2 0.46 lbs $8.85 $8.25 $0.60
229677 2022-07-08 $39.90 Priority Mail 3-Day Flat Rate Envelope 1 0.50 lbs $8.85 $8.45 $0.40
229679 2022-07-08 $12.29 First-Class Package Service 2 0.11 lbs $5.06 $3.86 $1.20
229680 2022-07-08 $12.09 USPS First Class 1 0.06 lbs $4.70 $3.48 $1.22
229681 2022-07-08 $16.49 USPS First Class 1 0.14 lbs $4.80 $3.72 $1.08
229682 2022-07-08 $8.14 USPS First Class 1 0.05 lbs $4.75 $3.58 $1.17
229683 2022-07-08 $7.22 USPS Shipping 1 0.06 lbs $0.00 $3.86 $-3.86
229685 2022-07-08 $9.54 USPS First Class 1 0.10 lbs $4.75 $3.58 $1.17
229689 2022-07-09 $30.54 Priority Mail 2 0.12 lbs $8.78 $8.25 $0.53
229691 2022-07-10 $148.79 Priority Mail Medium Flat Rate Box 5 2.14 lbs $15.90 $14.25 $1.65
229692 2022-07-10 $13.73 First-Class Package Service 1 0.20 lbs $5.08 $3.88 $1.20
229694 2022-07-11 $9.19 USPS First Class 1 0.06 lbs $4.70 $3.48 $1.22
229695 2022-07-11 $12.54 USPS First Class 1 0.06 lbs $4.65 $3.42 $1.23
229696 2022-07-11 $24.19 USPS First Class 1 0.12 lbs $4.70 $3.48 $1.22
229697 2022-07-11 $12.69 USPS First Class 1 0.06 lbs $4.80 $3.58 $1.22
229698 2022-07-11 $11.28 USPS Shipping 1 0.23 lbs $5.10 $4.15 $0.95
229699 2022-07-11 $13.92 USPS Shipping 1 0.05 lbs $0.00 $3.72 $-3.72
229700 2022-07-11 $8.42 USPS Shipping 1 0.15 lbs $0.00 $4.15 $-4.15
229701 2022-07-11 $11.66 First-Class Package Service 5 0.05 lbs $5.06 $3.72 $1.34
229702 2022-07-12 $9.15 USPS First-Class Mail or Priority Mail 1 0.05 lbs $4.72 $3.72 $1.00
229703 2022-07-12 $12.74 USPS First Class 1 0.06 lbs $4.75 $3.58 $1.17
229707 2022-07-13 $31.49 USPS First Class 1 0.75 lbs $6.00 $5.96 $0.04
229708 2022-07-13 $12.64 USPS First Class 1 0.06 lbs $4.75 $3.48 $1.27
229709 2022-05-25 $41.27 Priority Mail 2-Day 17 0.88 lbs $10.59 $8.49 $2.10
229710 2022-07-13 $30.98 First-Class Package Service 2 0.60 lbs $5.59 $4.34 $1.25
229714 2022-07-14 $32.78 Priority Mail Flat Rate Envelope 6 0.70 lbs $8.85 $8.25 $0.60
229715 2022-07-14 $31.05 First-Class Package Service 5 0.24 lbs $4.99 $5.49 $-0.50
229717 2022-07-14 $18.03 First-Class Package Service 1 0.30 lbs $4.99 $15.16 $-10.17
229718 2022-07-15 $12.89 USPS First Class 1 0.06 lbs $5.00 $3.86 $1.14
229720 2022-07-15 $18.00 First-Class Package Service 3 0.54 lbs $6.03 $4.68 $1.35
229721 2022-07-15 $24.08 First-Class Package Service 3 0.23 lbs $5.19 $3.99 $1.20
229722 2022-07-16 $12.59 USPS First Class 1 0.06 lbs $4.70 $3.58 $1.12
229723 2022-07-16 $7.70 First-Class Package Service 1 0.01 lbs $5.06 $3.86 $1.20
229725 2022-07-16 $9.79 USPS First Class 1 0.03 lbs $5.00 $3.86 $1.14
229726 2022-07-16 $34.34 USPS Parcel Select Ground 1 2.30 lbs $12.25 $11.64 $0.61
229727 2022-07-16 $10.94 USPS First Class 1 0.08 lbs $4.65 $3.42 $1.23
229728 2022-07-18 $14.64 USPS First Class 1 0.05 lbs $4.65 $3.42 $1.23
229729 2022-07-18 $24.85 FedEx Ground or FedEx Home Delivery 1 0.40 lbs $12.66 $4.83 $7.83
229730 2022-07-18 $15.29 USPS First Class 1 0.07 lbs $5.00 $3.86 $1.14
229731 2022-07-18 $8.59 USPS First Class 1 0.05 lbs $4.60 $3.39 $1.21
229732 2022-07-18 $10.22 USPS Shipping 1 0.08 lbs $0.00 $3.48 $-3.48
229733 2022-07-18 $7.22 USPS Shipping 1 0.06 lbs $0.00 $3.48 $-3.48
229735 2022-07-18 $11.33 First-Class Package Service 1 0.19 lbs $5.19 $3.72 $1.47
229736 2022-07-18 $9.92 First-Class Package Service 1 0.05 lbs $4.78 $3.48 $1.30
229737 2022-07-19 $9.03 First-Class Package Service 4 0.04 lbs $5.07 $3.48 $1.59
229738 2022-07-19 $26.66 First-Class Package Service 1 0.80 lbs $6.67 $5.72 $0.95
229740 2022-07-19 $15.24 First-Class Package Service 3 0.32 lbs $4.99 $3.76 $1.23
229741 2022-07-19 $44.64 First-Class Package Service 3 0.40 lbs $5.93 $4.98 $0.95
229742 2022-07-20 $13.49 USPS First Class 1 0.06 lbs $5.00 $3.86 $1.14
229743 2022-07-20 $21.49 USPS First Class 1 0.15 lbs $4.70 $3.48 $1.22
229744 2022-07-20 $16.29 USPS First Class 1 0.10 lbs $4.80 $3.72 $1.08
229745 2022-07-20 $27.71 Priority Mail Flat Rate Envelope 14 1.06 lbs $8.85 $8.59 $0.26
229757 2022-07-21 $30.77 Priority Mail 1 0.60 lbs $10.78 $9.16 $1.62
229758 2022-07-21 $12.59 USPS First Class 1 0.06 lbs $4.70 $3.48 $1.22
229766 2022-07-21 $12.29 USPS First Class 1 0.20 lbs $4.80 $3.72 $1.08
229767 2022-07-22 $11.33 First-Class Package Service 1 0.20 lbs $5.19 $3.99 $1.20
229770 2022-07-23 $10.79 USPS First Class 1 0.15 lbs $4.50 $3.42 $1.08
229771 2022-07-23 $12.04 USPS First Class 1 0.25 lbs $4.75 $3.87 $0.88
229774 2022-07-25 $8.94 USPS First Class 1 0.15 lbs $4.65 $3.81 $0.84
229775 2022-07-25 $19.57 USPS Shipping 1 0.40 lbs $0.00 $4.83 $-4.83
229776 2022-07-25 $69.04 USPS Priority Mail 1 2.55 lbs $25.65 $23.49 $2.16
229777 2022-07-25 $18.83 First-Class Package Service 1 0.30 lbs $5.19 $3.99 $1.20
229779 2022-07-25 $33.37 Priority Mail International Flat Rate Envelope 1 0.10 lbs $29.23 $29.17 $0.06
229781 2022-07-25 $25.44 First-Class Package Service 1 0.60 lbs $5.45 $5.72 $-0.27
229782 2022-07-25 $26.70 First-Class Package Service 8 0.16 lbs $4.78 $3.48 $1.30
229783 2022-07-25 $38.84 Priority Mail Flat Rate Envelope 1 1.00 lbs $8.85 $8.25 $0.60
229784 2022-07-26 $10.99 USPS First Class 1 0.07 lbs $4.70 $3.42 $1.28
229785 2022-07-26 $15.47 First-Class Package Service 4 0.17 lbs $5.01 $3.81 $1.20
229786 2022-07-26 $11.80 First-Class Package Service 4 0.24 lbs $5.19 $3.88 $1.31
229789 2022-07-27 $24.58 United States 1 0.30 lbs $4.59 $3.88 $0.71
229790 2022-07-27 $9.26 First-Class Package Service 1 0.03 lbs $4.62 $3.42 $1.20
229804 2022-07-28 $12.74 First-Class Package Service 4 0.12 lbs $4.78 $3.58 $1.20
229805 2022-07-28 $9.69 First-Class Package Service 2 0.08 lbs $5.06 $3.72 $1.34
229807 2022-07-28 $37.34 Priority Mail Flat Rate Envelope 1 0.90 lbs $8.85 $8.45 $0.40
229808 2022-07-29 $9.44 USPS First Class 1 0.06 lbs $4.65 $3.42 $1.23
229809 2022-07-29 $71.99 Priority Mail 3 1.53 lbs $12.72 $11.62 $1.10
229813 2022-07-30 $9.17 First-Class Package Service 1 0.02 lbs $4.59 $3.37 $1.22
229814 2022-07-30 $12.89 USPS First Class 1 0.06 lbs $5.00 $3.72 $1.28
229815 2022-07-30 $9.39 USPS First Class 1 0.50 lbs $5.40 $6.11 $-0.71
229817 2022-07-30 $30.84 Priority Mail Small Flat Rate Box 1 1.00 lbs $9.35 $8.25 $1.10
229818 2022-07-30 $80.44 Priority Mail Padded Flat Rate Envelope 1 1.38 lbs $9.55 $8.45 $1.10
229819 2022-07-30 $12.36 First-Class Package Service 1 0.07 lbs $4.92 $3.72 $1.20
229821 2022-07-30 $28.20 First-Class Package Service 2 0.46 lbs $5.70 $4.50 $1.20
229823 2022-07-31 $298.29 Priority Mail 4 5.50 lbs $14.73 $8.45 $6.28
229824 2022-07-31 $7.32 First-Class Package Service 1 0.01 lbs $4.68 $3.48 $1.20
229825 2022-07-31 $21.81 Priority Mail Padded Flat Rate Envelope 1 2.00 lbs $9.55 $8.45 $1.10
229826 2022-07-31 $14.01 First-Class Package Service 2 0.53 lbs $6.03 $5.96 $0.07
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56