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.21021 matching order(s)
| Order ID ▲ | Date | Order Total | Shipping Method | # Products | Total Weight | Shipping Charged | Shipping Paid | Profit |
|---|---|---|---|---|---|---|---|---|
| 213491 | 2020-07-09 | $300.45 | Priority Mail 3-Day | 4 | 15.45 lbs | $25.14 | $23.74 | $1.40 |
| 213492 | 2020-07-10 | $6.37 | USPSFirstClass | 1 | 0.20 lbs | $4.04 | $3.31 | $0.73 |
| 213494 | 2020-07-09 | $12.47 | First-Class Mail Stamped Letter | 3 | 0.12 lbs | $3.50 | $2.93 | $0.57 |
| 213496 | 2020-07-10 | $9.54 | USPSFirstClass | 1 | 0.04 lbs | $4.28 | $3.05 | $1.23 |
| 213500 | 2020-07-10 | $15.97 | USPSFirstClass | 1 | 0.40 lbs | $5.30 | $4.18 | $1.12 |
| 213505 | 2020-07-10 | $77.88 | Priority Mail 2-Day | 6 | 2.22 lbs | $14.34 | $10.48 | $3.86 |
| 213506 | 2020-07-10 | $46.27 | Direct Link International | 4 | 0.67 lbs | $21.01 | $11.74 | $9.27 |
| 213507 | 2020-07-10 | $38.16 | Priority Mail 2-Day | 1 | 1.25 lbs | $8.97 | $8.12 | $0.85 |
| 213508 | 2020-07-10 | $64.28 | Priority Mail International Flat Rate Envelope | 2 | 1.75 lbs | $26.40 | $25.55 | $0.85 |
| 213509 | 2020-07-10 | $23.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.40 lbs | $8.00 | $7.65 | $0.35 |
| 213510 | 2020-07-10 | $93.59 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 1.86 lbs | $8.60 | $7.75 | $0.85 |
| 213511 | 2020-07-10 | $14.48 | Priority Mail 3-Day Small Flat Rate Box | 2 | 0.12 lbs | $8.50 | $7.65 | $0.85 |
| 213512 | 2020-07-10 | $25.64 | First-Class Package Service | 1 | 0.85 lbs | $6.15 | $5.70 | $0.45 |
| 213514 | 2020-07-10 | $18.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.35 lbs | $8.50 | $7.65 | $0.85 |
| 213515 | 2020-07-10 | $12.18 | USPSFirstClass | 1 | 0.10 lbs | $4.40 | $3.18 | $1.22 |
| 213516 | 2020-07-10 | $22.55 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 1.72 lbs | $8.60 | $7.75 | $0.85 |
| 213518 | 2020-07-10 | $36.79 | Priority Mail 3-Day Flat Rate Envelope | 1 | 1.10 lbs | $8.00 | $7.65 | $0.35 |
| 213520 | 2020-07-10 | $30.38 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.90 lbs | $8.00 | $7.65 | $0.35 |
| 213521 | 2020-07-10 | $27.45 | First-Class Mail Stamped Letter | 1 | 0.15 lbs | $3.50 | $3.67 | $-0.17 |
| 213523 | 2020-07-10 | $48.58 | Direct Link International | 5 | 0.60 lbs | $20.73 | $11.74 | $8.99 |
| 213525 | 2020-07-10 | $5.89 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.50 | $3.05 | $0.45 |
| 213528 | 2020-07-10 | $26.87 | Priority Mail 3-Day Flat Rate Envelope | 3 | 0.40 lbs | $8.00 | $7.65 | $0.35 |
| 213530 | 2020-07-11 | $17.18 | USPSFirstClass | 1 | 0.37 lbs | $5.28 | $3.31 | $1.97 |
| 213533 | 2020-07-11 | $10.89 | USPSFirstClass | 1 | 0.10 lbs | $4.29 | $2.93 | $1.36 |
| 213535 | 2020-07-10 | $91.25 | Priority Mail 1-Day | 17 | 2.35 lbs | $8.69 | $7.68 | $1.01 |
| 213536 | 2020-07-10 | $45.33 | Priority Mail 2-Day Flat Rate Envelope | 7 | 1.14 lbs | $8.00 | $7.65 | $0.35 |
| 213537 | 2020-07-11 | $34.28 | InternationalPriorityShipping | 1 | 0.07 lbs | $4.39 | $3.05 | $1.34 |
| 213538 | 2020-07-11 | $23.38 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 213542 | 2020-07-11 | $12.47 | First-Class Mail Stamped Letter | 3 | 0.11 lbs | $3.50 | $3.39 | $0.11 |
| 213543 | 2020-07-11 | $15.47 | First-Class Mail Stamped Letter | 3 | 0.15 lbs | $3.50 | $3.05 | $0.45 |
| 213545 | 2020-07-11 | $12.63 | First-Class Mail Stamped Letter | 2 | 0.08 lbs | $3.35 | $3.05 | $0.30 |
| 213546 | 2020-07-11 | $19.15 | First-Class Package Service | 4 | 0.38 lbs | $4.71 | $3.67 | $1.04 |
| 213547 | 2020-07-11 | $39.02 | USPSPriority | 1 | 2.40 lbs | $14.33 | $12.15 | $2.18 |
| 213548 | 2020-07-11 | $15.89 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 213549 | 2020-07-11 | $26.60 | USPSFirstClass | 3 | 1.20 lbs | $13.38 | $8.76 | $4.62 |
| 213551 | 2020-07-11 | $9.49 | First-Class Mail Stamped Letter | 1 | 0.14 lbs | $3.50 | $3.39 | $0.11 |
| 213552 | 2020-07-11 | $9.93 | USPSFirstClass | 4 | 0.20 lbs | $3.97 | $2.78 | $1.19 |
| 213554 | 2020-07-11 | $5.81 | First-Class Mail Stamped Letter | 4 | 0.08 lbs | $3.35 | $2.84 | $0.51 |
| 213555 | 2020-07-12 | $17.47 | USPSFirstClass | 4 | 0.14 lbs | $8.01 | $4.00 | $4.01 |
| 213556 | 2020-07-11 | $44.63 | Priority Mail 3-Day | 5 | 1.80 lbs | $13.00 | $12.15 | $0.85 |
| 213559 | 2020-07-12 | $12.25 | USPSFirstClass | 1 | 0.19 lbs | $4.30 | $2.93 | $1.37 |
| 213560 | 2020-07-11 | $25.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 3.50 lbs | $8.00 | $7.65 | $0.35 |
| 213562 | 2020-07-11 | $30.37 | Priority Mail 2-Day | 2 | 1.90 lbs | $10.39 | $9.54 | $0.85 |
| 213563 | 2020-07-11 | $127.28 | Priority Mail 2-Day | 3 | 7.09 lbs | $27.81 | $24.18 | $3.63 |
| 213566 | 2020-07-11 | $24.47 | Priority Mail 3-Day Flat Rate Envelope | 13 | 0.49 lbs | $8.00 | $7.65 | $0.35 |
| 213569 | 2020-07-12 | $19.45 | USPSFirstClass | 2 | 0.10 lbs | $4.35 | $2.93 | $1.42 |
| 213570 | 2020-07-12 | $7.55 | USPSFirstClass | 1 | 0.05 lbs | $4.19 | $3.52 | $0.67 |
| 213571 | 2020-07-12 | $22.94 | First-Class Mail Stamped Letter | 6 | 0.09 lbs | $3.50 | $2.84 | $0.66 |
| 213572 | 2020-07-12 | $76.33 | Priority Mail 2-Day | 11 | 1.87 lbs | $14.34 | $10.53 | $3.81 |
| 213576 | 2020-07-12 | $5.19 | First-Class Mail Stamped Letter | 1 | 0.02 lbs | $3.20 | $3.18 | $0.02 |
| 213577 | 2020-07-12 | $35.08 | Priority Mail 3-Day | 10 | 3.25 lbs | $11.18 | $10.33 | $0.85 |
| 213578 | 2020-07-12 | $19.79 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 213579 | 2020-07-12 | $82.49 | Priority Mail 2-Day | 15 | 2.38 lbs | $14.34 | $11.13 | $3.21 |
| 213580 | 2020-07-12 | $6.87 | USPSFirstClass | 1 | 0.10 lbs | $4.02 | $2.78 | $1.24 |
| 213582 | 2020-07-12 | $46.94 | Priority Mail 2-Day | 5 | 1.49 lbs | $11.39 | $10.53 | $0.86 |
| 213583 | 2020-07-12 | $28.05 | Priority Mail 2-Day Padded Flat Rate Envelope | 5 | 0.75 lbs | $8.60 | $7.65 | $0.95 |
| 213584 | 2020-07-12 | $24.48 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.00 | $7.75 | $0.25 |
| 213586 | 2020-07-12 | $25.08 | Priority Mail 3-Day Small Flat Rate Box | 2 | 0.25 lbs | $8.50 | $7.65 | $0.85 |
| 213587 | 2020-07-12 | $29.42 | Priority Mail 2-Day | 3 | 0.60 lbs | $8.65 | $8.92 | $-0.27 |
| 213588 | 2020-07-12 | $35.40 | Priority Mail 2-Day Small Flat Rate Box | 10 | 0.59 lbs | $8.50 | $7.65 | $0.85 |
| 213590 | 2020-07-12 | $26.29 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 213591 | 2020-07-12 | $13.19 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.09 lbs | $8.00 | $7.15 | $0.85 |
| 213592 | 2020-07-12 | $7.63 | First-Class Mail Stamped Letter | 2 | 0.07 lbs | $3.35 | $2.78 | $0.57 |
| 213593 | 2020-07-13 | $48.19 | Priority Mail 3-Day | 2 | 1.20 lbs | $9.61 | $8.76 | $0.85 |
| 213594 | 2020-07-13 | $44.48 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.38 lbs | $8.00 | $7.65 | $0.35 |
| 213595 | 2020-07-13 | $53.93 | USPSFirstClass | 5 | 0.25 lbs | $5.45 | $11.19 | $-5.74 |
| 213596 | 2020-07-13 | $16.79 | USPSFirstClass | 1 | 0.05 lbs | $4.55 | $2.93 | $1.62 |
| 213598 | 2020-07-13 | $16.95 | Priority Mail 2-Day Flat Rate Envelope | 5 | 0.19 lbs | $8.00 | $7.65 | $0.35 |
| 213599 | 2020-07-13 | $224.45 | Priority Mail 2-Day | 1 | 11.30 lbs | $49.46 | $46.31 | $3.15 |
| 213607 | 2020-07-13 | $21.31 | First-Class Package Service | 1 | 0.49 lbs | $5.52 | $3.31 | $2.21 |
| 213608 | 2020-07-13 | $21.19 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.80 lbs | $8.00 | $7.75 | $0.25 |
| 213609 | 2020-07-13 | $17.49 | Priority Mail 3-Day Small Flat Rate Box | 1 | 0.40 lbs | $8.50 | $7.65 | $0.85 |
| 213611 | 2020-07-13 | $10.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.03 lbs | $8.00 | $7.15 | $0.85 |
| 213612 | 2020-07-14 | $15.67 | USPSFirstClass | 1 | 0.20 lbs | $4.46 | $3.39 | $1.07 |
| 213614 | 2020-07-13 | $180.14 | Priority Mail International Medium Flat Rate Box | 10 | 4.21 lbs | $49.80 | $52.11 | $-2.31 |
| 213617 | 2020-07-14 | $44.27 | Priority Mail 2-Day Flat Rate Envelope | 3 | 1.00 lbs | $8.00 | $7.65 | $0.35 |
| 213618 | 2020-07-14 | $15.89 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 213619 | 2020-07-14 | $19.43 | USPSFirstClass | 1 | 0.40 lbs | $5.37 | $4.08 | $1.29 |
| 213620 | 2020-07-14 | $6.24 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.93 | $0.42 |
| 213621 | 2020-07-14 | $8.61 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 0.24 lbs | $8.60 | $7.75 | $0.85 |
| 213622 | 2020-07-14 | $57.27 | Priority Mail 3-Day | 2 | 3.60 lbs | $16.99 | $14.56 | $2.43 |
| 213623 | 2020-07-14 | $12.89 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.20 lbs | $8.00 | $8.05 | $-0.05 |
| 213624 | 2020-07-14 | $11.92 | USPSFirstClass | 1 | 0.05 lbs | $4.34 | $2.93 | $1.41 |
| 213626 | 2020-07-14 | $24.79 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.45 lbs | $8.00 | $7.65 | $0.35 |
| 213628 | 2020-07-14 | $25.92 | Priority Mail 2-Day Flat Rate Envelope | 8 | 0.32 lbs | $8.00 | $7.65 | $0.35 |
| 213629 | 2020-07-14 | $23.84 | USPSFirstClass | 2 | 0.15 lbs | $8.50 | $2.78 | $5.72 |
| 213630 | 2020-07-15 | $8.09 | USPSFirstClass | 1 | 0.03 lbs | $4.17 | $2.93 | $1.24 |
| 213631 | 2020-07-14 | $92.43 | Priority Mail 2-Day Medium Flat Rate Box | 2 | 3.20 lbs | $14.45 | $12.10 | $2.35 |
| 213633 | 2020-07-15 | $8.41 | USPSFirstClass | 1 | 0.34 lbs | $4.92 | $4.08 | $0.84 |
| 213634 | 2020-07-15 | $9.83 | USPSFirstClass | 1 | 0.20 lbs | $4.25 | $3.39 | $0.86 |
| 213635 | 2020-07-14 | $39.88 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.25 lbs | $8.00 | $7.65 | $0.35 |
| 213637 | 2020-07-15 | $189.43 | Priority Mail 2-Day | 3 | 10.70 lbs | $45.58 | $44.73 | $0.85 |
| 213638 | 2020-06-18 | $28.79 | Direct Link International | 1 | 0.25 lbs | $10.00 | $11.20 | $-1.20 |
| 213640 | 2020-07-15 | $6.29 | First-Class Mail Stamped Letter | 6 | 0.06 lbs | $3.35 | $3.18 | $0.17 |
| 213641 | 2020-07-15 | $38.33 | USPSFirstClass | 1 | 0.70 lbs | $6.92 | $9.99 | $-3.07 |
| 213642 | 2020-07-15 | $23.38 | Priority Mail 3-Day | 6 | 1.20 lbs | $10.84 | $9.98 | $0.86 |
| 213643 | 2020-07-15 | $17.28 | USPSFirstClass | 1 | 0.37 lbs | $5.33 | $3.39 | $1.94 |
| 213644 | 2020-07-15 | $9.13 | USPSFirstClass | 1 | 0.03 lbs | $4.24 | $2.93 | $1.31 |
| 213645 | 2020-07-15 | $8.24 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.93 | $0.42 |
| 213646 | 2020-07-15 | $14.19 | First-Class Package Service | 4 | 0.44 lbs | $4.43 | $4.18 | $0.25 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |