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
229443 2022-05-25 $49.75 Priority Mail 2-Day 5 1.93 lbs $0.00 $8.31 $-8.31
229444 2022-05-25 $14.90 First-Class Package Service 2 0.12 lbs $4.92 $3.72 $1.20
229445 2022-05-25 $15.90 First-Class Package Service 2 0.09 lbs $4.92 $3.72 $1.20
229447 2022-05-26 $12.64 USPS First Class 1 0.06 lbs $4.65 $3.42 $1.23
229448 2022-05-26 $16.34 USPS First Class 1 0.14 lbs $4.65 $3.42 $1.23
229449 2022-05-26 $13.16 First-Class Package Service 1 0.50 lbs $6.52 $3.81 $2.71
229450 2022-05-26 $10.81 First-Class Package Service 2 0.12 lbs $4.68 $3.48 $1.20
229451 2022-05-27 $33.84 USPS First Class 1 0.91 lbs $9.85 $5.72 $4.13
229452 2022-05-27 $9.79 USPS First Class 1 0.03 lbs $5.00 $3.86 $1.14
229455 2022-05-27 $22.07 First-Class Package Service 12 0.20 lbs $5.19 $3.99 $1.20
229456 2022-05-28 $34.64 USPS First Class 1 0.85 lbs $10.15 $5.96 $4.19
229457 2022-05-28 $20.11 First-Class Package Service 2 0.38 lbs $4.96 $3.76 $1.20
229458 2022-05-28 $30.01 First-Class Package Service 2 0.60 lbs $6.03 $6.11 $-0.08
229460 2022-05-29 $61.55 Priority Mail 3-Day 1 1.63 lbs $13.76 $12.66 $1.10
229461 2022-05-29 $14.60 First-Class Package Service 2 0.04 lbs $4.62 $3.42 $1.20
229462 2022-05-29 $38.31 First-Class Package Service 9 0.45 lbs $5.70 $3.87 $1.83
229463 2022-05-29 $37.51 First-Class Package Service 12 0.54 lbs $6.03 $4.83 $1.20
229464 2022-05-30 $12.44 USPS First Class 1 0.06 lbs $4.65 $3.42 $1.23
229465 2022-05-30 $10.79 USPS First Class 1 0.06 lbs $5.00 $3.86 $1.14
229466 2022-05-30 $12.35 USPS Shipping 1 0.05 lbs $0.00 $3.42 $-3.42
229467 2022-05-30 $14.94 USPS First Class 1 0.10 lbs $4.65 $3.42 $1.23
229468 2022-05-30 $27.24 USPS First Class 1 0.15 lbs $4.75 $3.58 $1.17
229469 2022-05-30 $59.85 Priority Mail 2-Day 1 1.63 lbs $12.06 $10.96 $1.10
229474 2022-05-31 $48.34 First-Class Package Service 1 0.29 lbs $5.35 $4.98 $0.37
229475 2022-05-31 $8.09 USPS First Class 1 0.03 lbs $4.70 $3.48 $1.22
229478 2022-05-31 $126.82 Priority Mail 2-Day Flat Rate Envelope 3 1.50 lbs $8.85 $9.99 $-1.14
229483 2022-06-02 $8.09 USPS First Class 1 0.05 lbs $4.70 $3.48 $1.22
229484 2022-06-02 $17.59 USPS First Class 1 0.15 lbs $4.80 $3.99 $0.81
229485 2022-06-02 $12.31 First-Class Package Service 2 0.10 lbs $4.78 $3.58 $1.20
229486 2022-06-03 $10.44 USPS First Class 1 0.06 lbs $4.65 $3.42 $1.23
229487 2022-06-03 $50.02 Priority Mail 2-Day Flat Rate Envelope 3 1.41 lbs $8.85 $8.25 $0.60
229489 2022-06-04 $89.93 USPS Shipping 1 2.40 lbs $0.00 $14.25 $-14.25
229490 2022-06-04 $14.99 USPS Shipping 1 0.45 lbs $0.00 $4.83 $-4.83
229492 2022-06-05 $42.26 First-Class Package Service 2 0.65 lbs $7.48 $6.28 $1.20
229494 2022-06-07 $10.79 USPS First Class 1 0.06 lbs $5.00 $3.86 $1.14
229495 2022-06-07 $15.53 First-Class Package Service 3 0.09 lbs $5.06 $4.15 $0.91
229497 2022-06-08 $15.97 First-Class Package Service 2 0.30 lbs $5.19 $3.99 $1.20
229498 2022-06-08 $13.55 First-Class Package Service 2 0.04 lbs $4.92 $3.72 $1.20
229499 2022-06-08 $11.45 First-Class Package Service 1 0.22 lbs $4.82 $3.87 $0.95
229500 2022-06-08 $49.82 Priority Mail 3-Day Flat Rate Envelope 3 1.10 lbs $8.85 $8.25 $0.60
229501 2022-06-09 $12.66 First-Class Package Service 2 0.09 lbs $4.68 $3.48 $1.20
229502 2022-06-09 $46.12 Priority Mail 2-Day 7 0.97 lbs $9.59 $8.49 $1.10
229503 2022-06-09 $38.26 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $9.35 $8.25 $1.10
229504 2022-06-09 $9.06 First-Class Package Service 1 0.03 lbs $4.92 $3.72 $1.20
229505 2022-06-10 $8.54 USPS First Class 1 0.05 lbs $4.65 $3.42 $1.23
229506 2022-06-10 $11.99 USPS First Class 1 0.03 lbs $4.70 $3.48 $1.22
229508 2022-06-10 $18.98 First-Class Package Service 3 0.21 lbs $5.01 $3.42 $1.59
229510 2022-06-11 $9.49 USPS First Class 1 0.03 lbs $4.70 $3.48 $1.22
229511 2022-06-11 $14.64 USPS First Class 1 0.05 lbs $4.65 $3.42 $1.23
229512 2022-06-11 $12.54 USPS First Class 1 0.06 lbs $4.75 $3.58 $1.17
229513 2022-06-11 $15.66 First-Class Package Service 1 0.30 lbs $5.35 $4.15 $1.20
229514 2022-06-12 $10.15 First-Class Package Service 1 0.20 lbs $5.01 $3.81 $1.20
229516 2022-06-12 $49.31 Priority Mail 2-Day Flat Rate Envelope 2 2.10 lbs $8.85 $8.45 $0.40
229518 2022-06-13 $13.59 USPS First Class 1 0.15 lbs $4.80 $3.72 $1.08
229519 2022-06-13 $12.14 USPS First Class 1 0.04 lbs $4.65 $3.42 $1.23
229520 2022-06-13 $23.09 USPS Shipping 1 0.22 lbs $0.00 $4.15 $-4.15
229521 2022-06-13 $12.94 USPS Shipping 1 0.25 lbs $0.00 $3.87 $-3.87
229522 2022-06-13 $7.74 USPS First Class 1 0.03 lbs $4.75 $3.58 $1.17
229523 2022-06-13 $40.19 USPS First Class 1 0.50 lbs $5.20 $3.81 $1.39
229532 2022-06-14 $9.42 First-Class Package Service 1 0.03 lbs $4.78 $3.58 $1.20
229534 2022-06-15 $42.81 Priority Mail 2-Day 12 0.51 lbs $9.69 $8.25 $1.44
229535 2022-06-15 $9.49 USPS First Class 1 0.05 lbs $4.70 $3.48 $1.22
229536 2022-06-15 $16.02 USPS Parcel Select Ground 1 0.50 lbs $9.03 $9.03 $0.00
229537 2022-06-15 $19.59 First-Class Package Service 3 0.11 lbs $4.62 $3.42 $1.20
229538 2022-06-16 $12.24 USPS First Class 1 0.06 lbs $4.75 $3.58 $1.17
229539 2022-06-16 $21.79 USPS First Class 1 0.22 lbs $4.80 $3.99 $0.81
229540 2022-06-16 $11.99 USPS First Class 1 0.04 lbs $4.50 $3.37 $1.13
229541 2022-06-16 $15.59 Priority Mail 3-Day Flat Rate Envelope 1 0.06 lbs $8.85 $7.75 $1.10
229546 2022-06-18 $42.02 First-Class Package Service 3 0.85 lbs $7.48 $6.28 $1.20
229548 2022-06-19 $139.09 Priority Mail 2-Day 4 4.05 lbs $18.13 $14.00 $4.13
229551 2022-06-20 $16.54 Priority Mail 3-Day Flat Rate Envelope 6 0.06 lbs $8.85 $7.75 $1.10
229553 2022-06-20 $37.84 Priority Mail 3-Day Flat Rate Envelope 1 0.90 lbs $8.85 $7.90 $0.95
229554 2022-06-20 $18.61 First-Class Package Service 1 0.10 lbs $4.62 $3.42 $1.20
229555 2022-06-21 $11.52 First-Class Package Service 1 0.06 lbs $4.78 $3.58 $1.20
229556 2022-06-22 $8.42 USPS Shipping 2 0.30 lbs $0.00 $3.76 $-3.76
229557 2022-06-22 $9.19 First-Class Package Service 2 0.02 lbs $5.06 $3.86 $1.20
229558 2022-06-24 $15.24 USPS First Class 1 0.79 lbs $7.65 $4.98 $2.67
229559 2022-06-24 $139.34 Priority Mail 3-Day Small Flat Rate Box 1 9.35 lbs $9.35 $9.79 $-0.44
229561 2022-06-24 $12.37 First-Class Package Service 6 0.06 lbs $4.68 $3.87 $0.81
229563 2022-06-25 $18.17 First-Class Package Service 1 0.35 lbs $6.18 $4.15 $2.03
229564 2022-06-25 $68.82 Priority Mail 1-Day 3 1.44 lbs $9.12 $8.25 $0.87
229566 2022-06-25 $61.54 Priority Mail 2-Day Small Flat Rate Box 1 1.65 lbs $9.35 $8.25 $1.10
229571 2022-06-26 $15.04 First-Class Package Service 1 0.25 lbs $5.08 $3.88 $1.20
229572 2022-06-26 $17.18 First-Class Package Service 1 0.25 lbs $5.19 $3.99 $1.20
229573 2022-06-26 $15.92 First-Class Package Service 1 0.35 lbs $5.93 $4.98 $0.95
229577 2022-06-27 $15.86 USPS Parcel Select Ground 1 0.83 lbs $7.87 $8.22 $-0.35
229578 2022-06-27 $24.90 First-Class Package Service 2 0.80 lbs $6.92 $5.72 $1.20
229584 2022-06-29 $9.18 First-Class Package Service 3 0.03 lbs $5.06 $3.86 $1.20
229586 2022-06-29 $13.41 First-Class Package Service 2 0.14 lbs $4.83 $3.58 $1.25
229589 2022-06-30 $8.64 USPS First Class 1 0.05 lbs $4.65 $3.42 $1.23
229590 2022-06-30 $15.46 First-Class Package Service 1 0.07 lbs $4.57 $3.37 $1.20
229591 2022-07-01 $16.49 USPS First Class 1 0.10 lbs $5.00 $3.86 $1.14
229593 2022-07-01 $26.08 First-Class Package Service 8 0.70 lbs $7.16 $5.96 $1.20
229594 2022-07-02 $14.99 USPS First Class 1 0.05 lbs $5.00 $3.86 $1.14
229595 2022-07-02 $9.79 USPS First Class 1 0.04 lbs $5.00 $3.86 $1.14
229596 2022-07-02 $9.36 First-Class Package Service 1 0.06 lbs $4.92 $3.72 $1.20
229597 2022-07-02 $53.66 USPS First Class 4 0.68 lbs $19.80 $8.61 $11.19
229598 2022-07-02 $97.15 Priority Mail 3-Day 16 7.20 lbs $33.31 $24.01 $9.30
229602 2022-07-02 $49.19 Priority Mail 2-Day Flat Rate Envelope 6 0.08 lbs $8.85 $8.25 $0.60
229604 2022-07-03 $8.56 First-Class Package Service 1 0.08 lbs $4.92 $3.72 $1.20
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56