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
200412 2017-09-29 $7.20 First-Class Package Service 1 0.02 lbs $3.71 $2.61 $1.10
200413 2017-09-29 $15.85 First-Class Package Service 2 0.30 lbs $3.87 $2.77 $1.10
200414 2017-09-30 $44.23 Priority Mail 2-Day Flat Rate Envelope 2 1.80 lbs $6.95 $6.83 $0.12
200416 2017-09-30 $114.60 First-Class Package International Service 9 2.44 lbs $34.69 $32.78 $1.91
200418 2017-09-30 $39.75 First-Class Package Service 2 0.75 lbs $4.87 $4.30 $0.57
200420 2017-09-30 $56.40 Priority Mail 3-Day 2 3.80 lbs $12.12 $10.62 $1.50
200422 2017-09-30 $35.86 Priority Mail 2-Day Small Flat Rate Box 1 1.25 lbs $7.47 $6.25 $1.22
200425 2017-10-01 $23.54 First-Class Mail Large Envelope 1 0.40 lbs $3.55 $3.74 $-0.19
200426 2017-10-01 $23.66 First-Class Mail Large Envelope 2 0.42 lbs $3.98 $3.74 $0.24
200427 2017-10-01 $20.35 Priority Mail 3-Day 1 0.80 lbs $7.86 $6.63 $1.23
200428 2017-10-01 $30.09 Priority Mail 3-Day 4 0.91 lbs $9.23 $7.91 $1.32
200429 2017-10-01 $44.84 First-Class Package International Service 7 0.56 lbs $22.91 $21.38 $1.53
200432 2017-10-02 $12.90 First-Class Mail Large Envelope 2 0.24 lbs $3.12 $2.77 $0.35
200434 2017-10-02 $100.21 First-Class Package International Service 2 2.50 lbs $49.43 $47.03 $2.40
200435 2017-10-02 $77.99 First-Class Package International Service 2 1.90 lbs $33.71 $31.83 $1.88
200436 2017-10-02 $30.42 Priority Mail 2-Day 1 0.60 lbs $11.13 $6.71 $4.42
200438 2017-10-02 $63.29 First-Class Package International Service 2 1.57 lbs $22.91 $21.38 $1.53
200440 2017-10-02 $53.14 Priority Mail 3-Day Small Flat Rate Box 1 1.65 lbs $7.45 $6.25 $1.20
200441 2017-10-02 $8.78 First-Class Package Service 3 0.03 lbs $3.81 $2.61 $1.20
200443 2017-10-03 $14.03 First-Class Mail Large Envelope 1 0.30 lbs $3.24 $2.77 $0.47
200445 2017-10-03 $72.66 Priority Mail 2-Day Medium Flat Rate Box 4 5.05 lbs $13.40 $12.05 $1.35
200448 2017-10-03 $26.91 Priority Mail 3-Day 4 1.20 lbs $9.15 $7.91 $1.24
200449 2017-10-03 $35.49 Priority Mail 3-Day Padded Flat Rate Envelope 1 1.20 lbs $7.50 $6.25 $1.25
200450 2017-10-03 $64.74 First-Class Package International Service 4 1.48 lbs $22.38 $21.38 $1.00
200451 2017-10-03 $68.32 First-Class Package International Service 1 2.20 lbs $32.83 $31.83 $1.00
200452 2017-10-03 $56.64 Priority Mail 2-Day 2 2.10 lbs $8.86 $6.83 $2.03
200453 2017-10-03 $66.45 Priority Mail 3-Day Padded Flat Rate Envelope 5 1.50 lbs $7.50 $6.25 $1.25
200455 2017-10-03 $210.84 Ground 14 7.20 lbs $30.68 $20.13 $10.55
200456 2017-10-04 $314.06 Priority Mail 2-Day 4 19.60 lbs $31.30 $50.30 $-19.00
200458 2017-10-04 $9.00 First-Class Package Service 1 0.05 lbs $3.81 $2.61 $1.20
200460 2017-10-04 $33.49 Priority Mail 3-Day Padded Flat Rate Envelope 1 4.70 lbs $7.50 $6.25 $1.25
200462 2017-10-04 $8.96 First-Class Package Service 1 0.30 lbs $3.97 $2.77 $1.20
200464 2017-10-05 $37.13 Priority Mail 3-Day Flat Rate Envelope 2 1.20 lbs $6.95 $6.25 $0.70
200465 2017-10-05 $32.79 Priority Mail 1-Day Flat Rate Envelope 3 0.47 lbs $6.95 $6.25 $0.70
200469 2017-10-06 $50.39 Priority Mail 3-Day 2 1.50 lbs $12.81 $8.91 $3.90
200471 2017-10-06 $44.42 First-Class Mail Large Envelope 4 0.40 lbs $3.66 $3.32 $0.34
200472 2017-10-06 $147.13 Priority Mail International 8 3.50 lbs $56.61 $52.01 $4.60
200473 2017-10-06 $34.92 First-Class Package Service 6 0.47 lbs $5.08 $3.60 $1.48
200474 2017-10-06 $64.20 Priority Mail 3-Day 2 9.40 lbs $12.22 $6.25 $5.97
200475 2017-10-06 $21.63 First-Class Mail Large Envelope 1 0.25 lbs $3.24 $2.77 $0.47
200477 2017-10-07 $100.76 First-Class Package International Service 2 0.95 lbs $22.38 $21.38 $1.00
200479 2017-10-07 $18.04 First-Class Package International Service 2 0.25 lbs $14.06 $13.06 $1.00
200480 2017-10-07 $70.61 First-Class Package International Service 3 0.65 lbs $22.14 $21.14 $1.00
200482 2017-10-07 $72.77 Priority Mail 3-Day 3 6.20 lbs $11.50 $10.19 $1.31
200484 2017-10-07 $63.03 Priority Mail 1-Day Small Flat Rate Box 2 9.40 lbs $7.45 $6.25 $1.20
200485 2017-10-08 $36.94 Priority Mail 2-Day Small Flat Rate Box 1 1.15 lbs $7.45 $6.25 $1.20
200486 2017-10-08 $26.32 First-Class Package International Service 2 0.40 lbs $22.14 $12.59 $9.55
200487 2017-10-08 $80.97 Priority Mail 2-Day Medium Flat Rate Box 3 2.85 lbs $13.40 $9.19 $4.21
200489 2017-10-08 $75.80 Priority Mail 2-Day Medium Flat Rate Box 10 1.63 lbs $13.40 $9.69 $3.71
200495 2017-10-09 $22.65 Priority Mail 2-Day 1 0.49 lbs $7.86 $6.66 $1.20
200512 2017-10-10 $7.80 First-Class Package Service 1 0.05 lbs $3.81 $2.61 $1.20
200513 2017-10-10 $6.75 First-Class Package Service 6 0.06 lbs $3.81 $2.61 $1.20
200514 2017-10-11 $429.44 Priority Mail International 4 20.00 lbs $107.98 $97.00 $10.98
200515 2017-10-11 $34.79 Priority Mail 2-Day Small Flat Rate Box 2 0.52 lbs $7.45 $6.25 $1.20
200516 2017-10-11 $84.16 First-Class Package International Service 2 1.00 lbs $22.38 $21.38 $1.00
200517 2017-10-11 $25.34 Priority Mail 2-Day Flat Rate Envelope 1 0.90 lbs $6.95 $6.25 $0.70
200518 2017-10-11 $73.66 Priority Mail 3-Day 4 3.10 lbs $16.60 $15.13 $1.47
200519 2017-10-11 $9.00 First-Class Package Service 1 0.10 lbs $3.81 $2.61 $1.20
200520 2017-10-11 $7.80 First-Class Package Service 1 0.05 lbs $3.81 $2.61 $1.20
200523 2017-10-12 $99.56 Priority Mail 2-Day 3 3.80 lbs $10.19 $6.83 $3.36
200524 2017-10-12 $34.10 Priority Mail 2-Day 27 0.74 lbs $9.15 $7.91 $1.24
200525 2017-10-12 $273.30 Priority Mail 2-Day Medium Flat Rate Box 10 47.00 lbs $13.40 $12.05 $1.35
200526 2017-10-12 $50.44 Priority Mail 2-Day Small Flat Rate Box 1 5.30 lbs $7.45 $6.25 $1.20
200530 2017-10-13 $247.41 Ground 4 16.90 lbs $38.15 $29.59 $8.56
200533 2017-10-13 $38.72 Priority Mail 3-Day Flat Rate Envelope 3 1.11 lbs $6.95 $6.30 $0.65
200535 2017-10-13 $42.23 Priority Mail 3-Day 1 0.70 lbs $7.83 $6.63 $1.20
200537 2017-10-13 $16.51 First-Class Package Service 5 0.71 lbs $5.02 $3.32 $1.70
200538 2017-10-14 $15.03 First-Class Mail Large Envelope 1 0.25 lbs $3.24 $2.77 $0.47
200541 2017-10-14 $15.03 First-Class Mail Large Envelope 1 0.30 lbs $3.24 $2.77 $0.47
200542 2017-10-14 $27.20 First-Class Mail Large Envelope 1 0.45 lbs $3.66 $3.32 $0.34
200543 2017-10-14 $45.52 Priority Mail 2-Day Flat Rate Envelope 3 1.31 lbs $6.95 $6.25 $0.70
200544 2017-10-15 $50.44 Priority Mail 2-Day Small Flat Rate Box 1 5.30 lbs $7.45 $6.25 $1.20
200549 2017-10-16 $68.17 Priority Mail 2-Day 4 1.75 lbs $12.81 $22.92 $-10.11
200556 2017-10-16 $44.19 First-Class Package International Service 5 0.55 lbs $22.14 $21.14 $1.00
200564 2017-10-17 $15.95 First-Class Package Service 2 0.17 lbs $3.97 $2.77 $1.20
200565 2017-10-17 $85.09 Priority Mail 2-Day 3 2.45 lbs $9.72 $7.62 $2.10
200566 2017-10-17 $69.94 Priority Mail 3-Day 1 3.50 lbs $11.95 $10.19 $1.76
200567 2017-10-17 $12.64 Priority Mail 2-Day Flat Rate Envelope 1 1.00 lbs $6.95 $5.75 $1.20
200568 2017-10-17 $29.64 First-Class Package Service 13 0.29 lbs $3.97 $2.77 $1.20
200572 2017-10-18 $48.84 Priority Mail 3-Day Small Flat Rate Box 1 1.50 lbs $7.45 $6.25 $1.20
200573 2017-10-18 $22.21 First-Class Package International Service 2 0.08 lbs $13.83 $12.83 $1.00
200574 2017-10-18 $16.93 First-Class Package Service 1 0.27 lbs $3.97 $3.60 $0.37
200575 2017-10-18 $63.69 Priority Mail International 1 0.60 lbs $45.70 $44.70 $1.00
200576 2017-10-18 $57.75 First-Class Package International Service 3 0.60 lbs $22.38 $21.38 $1.00
200577 2017-10-18 $98.21 First-Class Package International Service 2 2.50 lbs $48.03 $47.03 $1.00
200578 2017-10-18 $78.41 First-Class Package International Service 2 1.90 lbs $32.83 $31.83 $1.00
200581 2017-10-19 $15.78 First-Class Package Service 3 0.07 lbs $3.81 $2.61 $1.20
200582 2017-10-19 $39.43 Priority Mail 2-Day Flat Rate Envelope 27 1.75 lbs $6.95 $6.25 $0.70
200583 2017-10-19 $124.27 Standard 5 5.45 lbs $33.02 $27.76 $5.26
200584 2017-10-19 $106.03 Priority Mail 3-Day 7 3.19 lbs $11.50 $8.15 $3.35
200587 2017-10-19 $46.91 Priority Mail 3-Day Flat Rate Envelope 4 0.94 lbs $6.95 $6.25 $0.70
200588 2017-10-20 $89.86 First-Class Package International Service 2 2.15 lbs $33.78 $32.78 $1.00
200589 2017-10-20 $8.27 First-Class Package Service 1 0.02 lbs $3.81 $2.61 $1.20
200590 2017-10-20 $74.02 First-Class Package International Service 1 2.40 lbs $48.03 $47.03 $1.00
200591 2017-10-20 $35.94 Priority Mail 3-Day Flat Rate Envelope 1 1.10 lbs $6.95 $6.25 $0.70
200592 2017-10-20 $98.81 First-Class Package International Service 2 2.50 lbs $48.03 $47.03 $1.00
200593 2017-10-20 $219.59 Ground 3 15.30 lbs $19.62 $6.25 $13.37
200595 2017-10-20 $59.40 First-Class Package International Service 1 1.30 lbs $22.61 $21.61 $1.00
200596 2017-10-20 $37.09 Priority Mail 2-Day 2 0.61 lbs $10.99 $6.71 $4.28
200598 2017-10-20 $61.66 Priority Mail 2-Day 2 2.00 lbs $8.86 $6.83 $2.03
Total 21021 order(s) 59963 29290.36 lbs $193530.22 $270216.78 $-76686.56