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)
table-success)
table-warning)
table-danger)
oc_order.date_added.21025 matching order(s)
| Order ID ▲ | Date | Order Total | Shipping Method | # Products | Total Weight | Shipping Charged | Shipping Paid | Profit |
|---|---|---|---|---|---|---|---|---|
| 218540 | 2020-12-09 | $18.12 | USPSFirstClass | 2 | 0.12 lbs | $8.58 | $3.30 | $5.28 |
| 218541 | 2020-12-09 | $6.23 | USPSFirstClass | 2 | 0.02 lbs | $4.25 | $3.43 | $0.82 |
| 218542 | 2020-12-08 | $95.43 | Next Day Air | 5 | 0.26 lbs | $80.48 | $64.82 | $15.66 |
| 218543 | 2020-12-08 | $28.13 | Priority Mail 3-Day | 3 | 0.15 lbs | $9.23 | $8.05 | $1.18 |
| 218546 | 2020-12-09 | $21.65 | Priority Mail 2-Day | 2 | 0.14 lbs | $9.67 | $8.82 | $0.85 |
| 218547 | 2020-12-09 | $11.43 | USPSFirstClass | 1 | 0.20 lbs | $4.54 | $3.92 | $0.62 |
| 218548 | 2020-12-09 | $46.99 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 1.40 lbs | $9.00 | $8.15 | $0.85 |
| 218549 | 2020-12-09 | $51.89 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.90 | $7.90 | $1.00 |
| 218550 | 2020-12-09 | $14.19 | USPSFirstClass | 1 | 0.50 lbs | $5.20 | $5.52 | $-0.32 |
| 218551 | 2020-12-09 | $94.38 | Priority Mail 2-Day Flat Rate Envelope | 2 | 3.05 lbs | $8.40 | $8.00 | $0.40 |
| 218552 | 2020-12-09 | $11.43 | USPSFirstClass | 1 | 0.20 lbs | $4.54 | $3.92 | $0.62 |
| 218553 | 2020-12-09 | $51.79 | Priority Mail 2-Day | 2 | 1.36 lbs | $10.01 | $8.85 | $1.16 |
| 218554 | 2020-12-09 | $34.78 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.60 lbs | $8.40 | $8.00 | $0.40 |
| 218555 | 2020-12-09 | $7.56 | USPSFirstClass | 1 | 0.03 lbs | $4.07 | $3.03 | $1.04 |
| 218556 | 2020-12-09 | $26.79 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.40 | $9.16 | $-0.76 |
| 218558 | 2020-12-09 | $20.07 | Priority Mail 2-Day Small Flat Rate Box | 7 | 0.10 lbs | $8.90 | $8.05 | $0.85 |
| 218559 | 2020-12-09 | $47.83 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 2.50 lbs | $9.00 | $8.15 | $0.85 |
| 218561 | 2020-12-09 | $129.99 | Priority Mail 2-Day | 1 | 3.95 lbs | $10.64 | $9.79 | $0.85 |
| 218562 | 2020-12-09 | $72.88 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.90 lbs | $8.40 | $7.90 | $0.50 |
| 218563 | 2020-12-09 | $43.48 | Priority Mail 2-Day Small Flat Rate Box | 2 | 1.35 lbs | $8.90 | $8.05 | $0.85 |
| 218564 | 2020-12-09 | $220.05 | Ground Home Delivery | 1 | 21.00 lbs | $26.86 | $26.54 | $0.32 |
| 218566 | 2020-12-09 | $7.49 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.10 | $3.03 | $0.07 |
| 218567 | 2020-12-09 | $32.49 | First-Class Package Service | 1 | 0.41 lbs | $6.20 | $4.71 | $1.49 |
| 218569 | 2020-12-09 | $38.69 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.90 | $8.05 | $0.85 |
| 218574 | 2020-12-09 | $19.81 | First-Class Package Service | 1 | 0.19 lbs | $4.37 | $3.92 | $0.45 |
| 218575 | 2020-12-09 | $4.59 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.10 | $3.09 | $0.01 |
| 218578 | 2020-12-09 | $6.94 | First-Class Mail Stamped Letter | 1 | 0.04 lbs | $2.95 | $3.09 | $-0.14 |
| 218582 | 2020-12-09 | $54.59 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.65 lbs | $8.90 | $7.90 | $1.00 |
| 218583 | 2020-12-10 | $19.11 | USPSFirstClass | 1 | 0.04 lbs | $4.62 | $3.03 | $1.59 |
| 218586 | 2020-12-09 | $19.39 | First-Class Package Service | 1 | 0.19 lbs | $3.95 | $3.50 | $0.45 |
| 218590 | 2020-12-10 | $97.02 | Priority Mail 2-Day | 1 | 3.20 lbs | $14.74 | $13.60 | $1.14 |
| 218593 | 2020-12-10 | $47.26 | USPSFirstClass | 1 | 0.45 lbs | $7.01 | $4.71 | $2.30 |
| 218594 | 2020-12-10 | $5.24 | First-Class Mail Stamped Letter | 1 | 0.13 lbs | $3.25 | $3.18 | $0.07 |
| 218596 | 2020-12-10 | $47.16 | USPSFirstClass | 1 | 0.45 lbs | $6.91 | $4.57 | $2.34 |
| 218597 | 2020-12-10 | $20.36 | Priority Mail 2-Day Flat Rate Envelope | 4 | 0.52 lbs | $8.40 | $7.96 | $0.44 |
| 218598 | 2020-12-10 | $66.58 | Priority Mail 2-Day Padded Flat Rate Envelope | 2 | 2.20 lbs | $9.00 | $8.00 | $1.00 |
| 218599 | 2020-12-10 | $26.95 | USPSFirstClass | 4 | 0.40 lbs | $9.39 | $3.77 | $5.62 |
| 218600 | 2020-12-10 | $13.20 | USPSFirstClass | 2 | 0.14 lbs | $4.42 | $3.43 | $0.99 |
| 218602 | 2020-12-10 | $156.71 | Priority Mail 2-Day | 1 | 9.60 lbs | $26.72 | $24.26 | $2.46 |
| 218606 | 2020-12-10 | $367.65 | Priority Mail 3-Day | 9 | 24.60 lbs | $57.54 | $57.20 | $0.34 |
| 218607 | 2020-12-10 | $21.53 | Priority Mail 3-Day | 1 | 0.95 lbs | $11.24 | $10.44 | $0.80 |
| 218608 | 2020-12-10 | $8.00 | First-Class Mail Stamped Letter | 10 | 0.10 lbs | $3.10 | $3.30 | $-0.20 |
| 218609 | 2020-12-10 | $7.86 | First-Class Package Service | 2 | 0.04 lbs | $3.88 | $3.43 | $0.45 |
| 218611 | 2020-12-10 | $292.29 | Priority Mail 3-Day | 1 | 13.15 lbs | $42.30 | $41.20 | $1.10 |
| 218612 | 2020-12-10 | $228.32 | Ground Home Delivery | 1 | 21.00 lbs | $35.13 | $28.86 | $6.27 |
| 218613 | 2020-12-10 | $3.44 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $2.95 | $3.03 | $-0.08 |
| 218615 | 2020-12-10 | $44.25 | First-Class Package Service | 15 | 0.66 lbs | $6.20 | $5.95 | $0.25 |
| 218618 | 2020-12-10 | $27.00 | First-Class Package Service | 2 | 0.74 lbs | $5.82 | $4.12 | $1.70 |
| 218619 | 2020-12-11 | $6.30 | USPSFirstClass | 1 | 0.19 lbs | $4.11 | $3.64 | $0.47 |
| 218620 | 2020-12-11 | $57.97 | Priority Mail 3-Day | 8 | 5.80 lbs | $25.43 | $13.60 | $11.83 |
| 218621 | 2020-12-11 | $6.61 | USPSFirstClass | 1 | 0.01 lbs | $4.12 | $3.18 | $0.94 |
| 218623 | 2020-12-11 | $22.94 | First-Class Package Service | 2 | 0.58 lbs | $4.96 | $5.95 | $-0.99 |
| 218624 | 2020-12-11 | $14.64 | USPSFirstClass | 3 | 0.09 lbs | $4.17 | $3.18 | $0.99 |
| 218626 | 2020-12-11 | $11.10 | USPSFirstClass | 2 | 0.06 lbs | $4.12 | $3.09 | $1.03 |
| 218633 | 2020-12-11 | $54.80 | Ground | 1 | 1.15 lbs | $18.01 | $8.49 | $9.52 |
| 218634 | 2020-12-11 | $506.20 | Ground | 13 | 16.21 lbs | $50.86 | $31.50 | $19.36 |
| 218635 | 2020-12-11 | $7.71 | USPSFirstClass | 1 | 0.03 lbs | $4.22 | $3.30 | $0.92 |
| 218636 | 2020-12-11 | $135.02 | Ground | 9 | 4.65 lbs | $0.00 | $12.13 | $-12.13 |
| 218638 | 2020-12-11 | $79.98 | Priority Mail 3-Day | 2 | 1.00 lbs | $11.24 | $10.82 | $0.42 |
| 218640 | 2020-12-11 | $91.04 | Ground | 3 | 2.30 lbs | $19.87 | $19.14 | $0.73 |
| 218641 | 2020-12-11 | $11.18 | USPSFirstClass | 1 | 0.20 lbs | $4.29 | $3.56 | $0.73 |
| 218642 | 2020-12-11 | $49.30 | Priority Mail 3-Day | 1 | 0.45 lbs | $9.05 | $8.20 | $0.85 |
| 218649 | 2020-12-11 | $5.94 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $2.95 | $3.09 | $-0.14 |
| 218650 | 2020-12-11 | $43.16 | First-Class Package Service | 8 | 0.69 lbs | $6.04 | $5.79 | $0.25 |
| 218651 | 2020-12-11 | $46.26 | Priority Mail 2-Day | 3 | 1.33 lbs | $10.79 | $9.16 | $1.63 |
| 218652 | 2020-12-12 | $9.08 | USPSFirstClass | 1 | 0.05 lbs | $4.19 | $3.09 | $1.10 |
| 218654 | 2020-12-11 | $83.80 | Priority Mail 2-Day Medium Flat Rate Box | 7 | 5.11 lbs | $14.85 | $13.60 | $1.25 |
| 218655 | 2020-12-12 | $8.09 | USPSFirstClass | 1 | 0.05 lbs | $4.10 | $3.03 | $1.07 |
| 218656 | 2020-12-11 | $18.63 | Priority Mail 1-Day | 1 | 0.06 lbs | $8.27 | $7.42 | $0.85 |
| 218658 | 2020-12-12 | $51.89 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.90 | $7.90 | $1.00 |
| 218661 | 2020-12-12 | $14.23 | First-Class Mail Stamped Letter | 2 | 0.12 lbs | $3.25 | $3.09 | $0.16 |
| 218662 | 2020-12-12 | $51.89 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.90 | $7.90 | $1.00 |
| 218663 | 2020-12-12 | $21.94 | USPSFirstClass | 2 | 0.10 lbs | $4.44 | $3.18 | $1.26 |
| 218667 | 2020-12-12 | $8.87 | USPSFirstClass | 1 | 0.45 lbs | $5.18 | $4.71 | $0.47 |
| 218668 | 2020-12-12 | $19.65 | First-Class Mail Stamped Letter | 1 | 0.12 lbs | $3.25 | $3.03 | $0.22 |
| 218672 | 2020-12-12 | $15.08 | First-Class Mail Stamped Letter | 2 | 0.04 lbs | $3.10 | $3.18 | $-0.08 |
| 218673 | 2020-12-12 | $81.59 | USPSPriority | 1 | 4.11 lbs | $49.36 | $42.58 | $6.78 |
| 218674 | 2020-12-12 | $21.79 | First-Class Mail Stamped Letter | 2 | 0.12 lbs | $3.25 | $3.30 | $-0.05 |
| 218675 | 2020-12-12 | $22.79 | First-Class Package Service | 1 | 0.35 lbs | $3.95 | $3.50 | $0.45 |
| 218678 | 2020-12-12 | $16.16 | First-Class Package Service | 1 | 0.30 lbs | $4.37 | $3.92 | $0.45 |
| 218679 | 2020-12-12 | $60.31 | Priority Mail 3-Day | 15 | 3.75 lbs | $22.26 | $21.41 | $0.85 |
| 218680 | 2020-12-13 | $18.44 | USPSFirstClass | 2 | 1.22 lbs | $11.26 | $9.16 | $2.10 |
| 218682 | 2020-12-12 | $57.99 | Priority Mail 3-Day Padded Flat Rate Envelope | 1 | 1.37 lbs | $9.00 | $8.52 | $0.48 |
| 218684 | 2020-12-12 | $33.96 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.90 | $8.05 | $0.85 |
| 218685 | 2020-12-17 | $17.59 | Priority Mail 2-Day | 1 | 0.37 lbs | $3.50 | $11.69 | $-8.19 |
| 218686 | 2020-12-12 | $10.45 | First-Class Package Service | 1 | 0.22 lbs | $4.96 | $3.43 | $1.53 |
| 218689 | 2020-12-12 | $8.36 | First-Class Package Service | 2 | 0.08 lbs | $3.48 | $3.03 | $0.45 |
| 218692 | 2020-12-13 | $79.85 | Priority Mail 2-Day | 2 | 2.25 lbs | $17.31 | $11.63 | $5.68 |
| 218694 | 2020-12-13 | $25.89 | First-Class Package Service | 1 | 0.42 lbs | $5.02 | $3.77 | $1.25 |
| 218696 | 2020-12-13 | $38.86 | USPSPriority | 1 | 2.60 lbs | $13.80 | $9.94 | $3.86 |
| 218698 | 2020-12-13 | $29.88 | Priority Mail 2-Day Small Flat Rate Box | 2 | 0.36 lbs | $8.90 | $8.05 | $0.85 |
| 218699 | 2020-12-13 | $21.86 | First-Class Package Service | 2 | 0.39 lbs | $4.88 | $4.38 | $0.50 |
| 218700 | 2020-12-13 | $6.14 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.25 | $3.30 | $-0.05 |
| 218701 | 2020-12-13 | $7.58 | First-Class Mail Stamped Letter | 2 | 0.06 lbs | $3.10 | $3.18 | $-0.08 |
| 218703 | 2020-12-13 | $16.14 | USPSFirstClass | 3 | 0.75 lbs | $5.67 | $5.65 | $0.02 |
| 218708 | 2020-12-13 | $47.69 | Priority Mail 2-Day | 2 | 1.50 lbs | $10.01 | $9.16 | $0.85 |
| 218710 | 2020-12-13 | $7.45 | First-Class Mail Stamped Letter | 1 | 0.07 lbs | $3.10 | $3.18 | $-0.08 |
| 218711 | 2020-12-13 | $60.16 | Priority Mail 2-Day | 4 | 1.60 lbs | $11.24 | $8.05 | $3.19 |
| 218712 | 2020-12-13 | $21.50 | First-Class Package Service | 4 | 0.71 lbs | $6.04 | $5.79 | $0.25 |
| 218714 | 2020-12-13 | $9.50 | USPSFirstClass | 1 | 0.15 lbs | $4.31 | $3.30 | $1.01 |
| Total | 21025 order(s) | 59971 | 29292.14 lbs | $193562.51 | $270247.54 | $-76685.03 |