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 |
|---|---|---|---|---|---|---|---|---|
| 208461 | 2019-11-17 | $92.84 | Priority Mail 2-Day Small Flat Rate Box | 1 | 2.85 lbs | $8.35 | $7.50 | $0.85 |
| 208462 | 2019-11-17 | $28.47 | First-Class Package Service | 6 | 0.65 lbs | $6.23 | $5.38 | $0.85 |
| 208463 | 2019-11-17 | $48.74 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.60 lbs | $8.35 | $7.50 | $0.85 |
| 208467 | 2019-11-18 | $11.13 | First-Class Package Service | 3 | 0.08 lbs | $3.71 | $2.66 | $1.05 |
| 208468 | 2019-11-18 | $41.29 | Priority Mail 3-Day Flat Rate Envelope | 1 | 1.10 lbs | $7.80 | $7.50 | $0.30 |
| 208469 | 2019-11-18 | $180.45 | Priority Mail 2-Day | 2 | 4.40 lbs | $24.88 | $10.64 | $14.24 |
| 208470 | 2019-11-18 | $10.87 | First-Class Package Service | 2 | 0.08 lbs | $3.89 | $2.84 | $1.05 |
| 208473 | 2019-11-18 | $63.01 | Priority Mail 2-Day | 4 | 2.07 lbs | $12.65 | $10.00 | $2.65 |
| 208474 | 2019-11-18 | $9.20 | First-Class Package Service | 1 | 0.09 lbs | $4.01 | $2.96 | $1.05 |
| 208475 | 2019-11-18 | $8.39 | First-Class Package Service | 2 | 0.07 lbs | $4.01 | $3.49 | $0.52 |
| 208476 | 2019-11-19 | $30.20 | First-Class Package Service | 3 | 0.54 lbs | $6.23 | $5.38 | $0.85 |
| 208477 | 2019-11-19 | $62.46 | Priority Mail 3-Day Medium Flat Rate Box | 5 | 3.19 lbs | $14.05 | $10.00 | $4.05 |
| 208481 | 2019-11-19 | $21.06 | First-Class Package Service | 1 | 0.45 lbs | $4.27 | $3.88 | $0.39 |
| 208483 | 2019-11-19 | $131.97 | Ground | 1 | 15.30 lbs | $32.33 | $22.57 | $9.76 |
| 208484 | 2019-11-19 | $37.84 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.35 | $7.50 | $0.85 |
| 208485 | 2019-11-20 | $133.42 | Priority Mail 3-Day | 13 | 3.65 lbs | $18.77 | $17.92 | $0.85 |
| 208486 | 2019-11-20 | $28.49 | Priority Mail 3-Day | 1 | 0.95 lbs | $8.73 | $7.88 | $0.85 |
| 208489 | 2019-11-20 | $5.61 | First-Class Package Service | 3 | 0.03 lbs | $4.14 | $3.09 | $1.05 |
| 208492 | 2019-11-21 | $5.89 | First-Class Package Service - Retail | 2 | 0.02 lbs | $4.91 | $3.09 | $1.82 |
| 208494 | 2019-11-21 | $54.36 | Priority Mail 3-Day Flat Rate Envelope | 4 | 1.28 lbs | $7.80 | $7.50 | $0.30 |
| 208495 | 2019-11-21 | $19.70 | First-Class Package Service | 1 | 0.35 lbs | $4.91 | $4.06 | $0.85 |
| 208496 | 2019-11-22 | $6.86 | First-Class Package Service | 3 | 0.12 lbs | $3.89 | $2.84 | $1.05 |
| 208497 | 2019-11-22 | $10.29 | First-Class Package Service | 2 | 0.07 lbs | $3.71 | $2.66 | $1.05 |
| 208499 | 2019-11-22 | $31.28 | First-Class Package International Service | 1 | 0.10 lbs | $21.79 | $13.54 | $8.25 |
| 208501 | 2019-11-22 | $7.38 | First-Class Package Service | 1 | 0.03 lbs | $3.89 | $2.84 | $1.05 |
| 208502 | 2019-11-22 | $12.72 | First-Class Package Service | 3 | 0.10 lbs | $3.75 | $2.70 | $1.05 |
| 208503 | 2019-11-22 | $67.89 | Priority Mail 2-Day | 3 | 1.85 lbs | $12.65 | $10.00 | $2.65 |
| 208506 | 2019-11-23 | $38.14 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.35 | $7.50 | $0.85 |
| 208507 | 2019-11-23 | $4.55 | First-Class Package Service | 1 | 0.20 lbs | $4.54 | $3.49 | $1.05 |
| 208508 | 2019-11-23 | $10.11 | First-Class Package Service | 3 | 0.08 lbs | $4.14 | $3.09 | $1.05 |
| 208509 | 2019-11-23 | $125.09 | Priority Mail 2-Day | 9 | 5.09 lbs | $21.68 | $23.48 | $-1.80 |
| 208514 | 2019-11-23 | $27.57 | First-Class Package Service | 2 | 0.40 lbs | $4.93 | $3.88 | $1.05 |
| 208515 | 2019-11-23 | $21.09 | First-Class Package Service | 4 | 0.25 lbs | $4.33 | $3.28 | $1.05 |
| 208516 | 2019-11-23 | $24.06 | Priority Mail 2-Day | 2 | 1.11 lbs | $11.08 | $13.10 | $-2.02 |
| 208518 | 2019-11-23 | $24.32 | First-Class Package Service | 1 | 0.40 lbs | $4.33 | $3.96 | $0.37 |
| 208521 | 2019-11-24 | $31.07 | Priority Mail 3-Day | 1 | 1.10 lbs | $11.08 | $10.23 | $0.85 |
| 208524 | 2019-11-24 | $34.78 | First-Class Package International Service | 1 | 0.37 lbs | $21.79 | $22.80 | $-1.01 |
| 208525 | 2019-11-24 | $33.13 | First-Class Package Service | 1 | 0.17 lbs | $4.14 | $3.63 | $0.51 |
| 208528 | 2019-11-24 | $14.53 | First-Class Package Service | 3 | 0.22 lbs | $3.71 | $3.18 | $0.53 |
| 208529 | 2019-11-24 | $38.64 | Priority Mail 2-Day | 2 | 1.71 lbs | $8.46 | $7.65 | $0.81 |
| 208532 | 2019-11-25 | $278.98 | Priority Mail 2-Day | 6 | 17.05 lbs | $50.34 | $49.49 | $0.85 |
| 208534 | 2019-11-25 | $17.44 | First-Class Package Service | 4 | 0.23 lbs | $4.68 | $3.09 | $1.59 |
| 208535 | 2019-11-25 | $27.77 | First-Class Package Service | 4 | 0.06 lbs | $3.81 | $3.28 | $0.53 |
| 208536 | 2019-11-25 | $67.03 | Priority Mail 2-Day | 12 | 1.91 lbs | $13.95 | $10.23 | $3.72 |
| 208537 | 2019-11-25 | $19.79 | First-Class Package Service | 2 | 0.37 lbs | $4.91 | $4.06 | $0.85 |
| 208538 | 2019-11-25 | $14.88 | First-Class Package Service | 1 | 0.10 lbs | $3.89 | $3.36 | $0.53 |
| 208541 | 2019-11-25 | $10.59 | First-Class Package Service | 2 | 0.15 lbs | $3.81 | $2.76 | $1.05 |
| 208543 | 2019-11-25 | $37.19 | Priority Mail 3-Day Padded Flat Rate Envelope | 1 | 1.15 lbs | $8.40 | $7.50 | $0.90 |
| 208544 | 2019-11-26 | $204.52 | Priority Mail 2-Day | 1 | 3.30 lbs | $16.44 | $17.92 | $-1.48 |
| 208545 | 2019-11-26 | $44.58 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.80 lbs | $7.80 | $7.55 | $0.25 |
| 208546 | 2019-11-26 | $107.49 | Flat Shipping Rate | 1 | 3.00 lbs | $7.50 | $21.45 | $-13.95 |
| 208548 | 2019-11-26 | $83.39 | Priority Mail 2-Day Padded Flat Rate Envelope | 1 | 0.90 lbs | $8.40 | $7.55 | $0.85 |
| 208549 | 2019-11-26 | $63.05 | Priority Mail 3-Day | 1 | 3.85 lbs | $11.18 | $10.33 | $0.85 |
| 208551 | 2019-11-26 | $25.33 | Priority Mail 2-Day | 4 | 0.58 lbs | $8.67 | $7.82 | $0.85 |
| 208552 | 2019-11-26 | $122.93 | Priority Mail 1-Day | 13 | 5.48 lbs | $9.00 | $8.15 | $0.85 |
| 208554 | 2019-11-26 | $26.19 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.85 lbs | $7.80 | $7.55 | $0.25 |
| 208558 | 2019-11-26 | $41.14 | Priority Mail 3-Day | 12 | 3.14 lbs | $9.66 | $8.81 | $0.85 |
| 208559 | 2019-11-27 | $6.05 | First-Class Package Service | 1 | 0.12 lbs | $3.71 | $3.18 | $0.53 |
| 208560 | 2019-11-27 | $435.15 | Ground | 6 | 19.25 lbs | $3.75 | $23.03 | $-19.28 |
| 208561 | 2019-11-27 | $4.99 | First-Class Package Service | 2 | 0.02 lbs | $4.01 | $2.96 | $1.05 |
| 208562 | 2019-11-27 | $17.73 | First-Class Package Service | 2 | 0.12 lbs | $3.75 | $2.70 | $1.05 |
| 208563 | 2019-11-27 | $65.98 | Priority Mail 3-Day Padded Flat Rate Envelope | 2 | 2.20 lbs | $8.40 | $7.55 | $0.85 |
| 208564 | 2019-11-27 | $53.53 | Priority Mail 2-Day | 2 | 1.00 lbs | $10.55 | $9.70 | $0.85 |
| 208565 | 2019-11-27 | $52.41 | Priority Mail 2-Day | 7 | 1.08 lbs | $11.08 | $10.23 | $0.85 |
| 208567 | 2019-11-28 | $21.64 | Priority Mail 2-Day | 4 | 1.30 lbs | $11.08 | $10.23 | $0.85 |
| 208568 | 2019-11-28 | $78.93 | Priority Mail 2-Day | 13 | 4.50 lbs | $18.78 | $17.93 | $0.85 |
| 208570 | 2019-11-29 | $25.37 | Priority Mail 2-Day Medium Flat Rate Box | 4 | 2.00 lbs | $13.65 | $10.55 | $3.10 |
| 208574 | 2019-11-29 | $17.41 | First-Class Package Service | 2 | 0.40 lbs | $4.54 | $3.49 | $1.05 |
| 208576 | 2019-11-29 | $37.35 | Priority Mail 1-Day | 13 | 2.92 lbs | $8.56 | $7.71 | $0.85 |
| 208577 | 2019-11-29 | $35.67 | Priority Mail 3-Day Flat Rate Envelope | 4 | 0.84 lbs | $7.80 | $7.50 | $0.30 |
| 208578 | 2019-11-29 | $75.68 | Priority Mail 2-Day | 13 | 2.29 lbs | $9.19 | $8.34 | $0.85 |
| 208579 | 2019-11-29 | $46.96 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.65 lbs | $8.35 | $7.50 | $0.85 |
| 208581 | 2019-11-29 | $32.69 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.35 | $7.50 | $0.85 |
| 208583 | 2019-11-29 | $36.59 | Priority Mail 2-Day Flat Rate Envelope | 1 | 1.10 lbs | $7.80 | $7.50 | $0.30 |
| 208585 | 2019-11-29 | $46.44 | Priority Mail 2-Day | 3 | 1.58 lbs | $9.19 | $8.34 | $0.85 |
| 208586 | 2019-11-29 | $42.04 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.40 lbs | $7.80 | $7.55 | $0.25 |
| 208588 | 2019-11-29 | $6.69 | First-Class Package Service | 2 | 0.20 lbs | $3.89 | $3.36 | $0.53 |
| 208589 | 2019-11-29 | $9.34 | First-Class Package Service | 2 | 0.12 lbs | $3.89 | $2.84 | $1.05 |
| 208591 | 2019-11-29 | $60.92 | Priority Mail 2-Day Padded Flat Rate Envelope | 2 | 1.76 lbs | $8.40 | $7.50 | $0.90 |
| 208592 | 2019-11-29 | $23.77 | First-Class Package Service | 23 | 0.45 lbs | $5.38 | $3.63 | $1.75 |
| 208595 | 2019-11-29 | $24.49 | Priority Mail 2-Day | 12 | 1.22 lbs | $11.08 | $10.23 | $0.85 |
| 208596 | 2019-11-29 | $5.78 | First-Class Package Service | 1 | 0.03 lbs | $4.01 | $2.96 | $1.05 |
| 208597 | 2019-11-29 | $46.98 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.55 lbs | $7.80 | $7.50 | $0.30 |
| 208598 | 2019-11-29 | $57.51 | First-Class Package Service | 1 | 0.70 lbs | $5.24 | $5.38 | $-0.14 |
| 208599 | 2019-11-29 | $14.53 | First-Class Package Service | 6 | 0.19 lbs | $4.14 | $3.09 | $1.05 |
| 208601 | 2019-11-29 | $75.97 | Priority Mail 2-Day | 37 | 8.71 lbs | $12.54 | $11.62 | $0.92 |
| 208603 | 2019-11-29 | $164.24 | Priority Mail 3-Day | 4 | 7.59 lbs | $34.36 | $28.00 | $6.36 |
| 208605 | 2019-11-29 | $16.56 | Priority Mail 2-Day | 5 | 0.95 lbs | $11.71 | $10.86 | $0.85 |
| 208607 | 2019-11-29 | $25.51 | First-Class Package Service | 14 | 0.40 lbs | $4.33 | $3.28 | $1.05 |
| 208608 | 2019-11-30 | $11.13 | First-Class Package Service | 4 | 0.57 lbs | $5.24 | $4.19 | $1.05 |
| 208609 | 2019-11-30 | $25.53 | Priority Mail 2-Day | 5 | 3.00 lbs | $10.88 | $8.76 | $2.12 |
| 208611 | 2019-11-30 | $20.80 | First-Class Package Service | 7 | 0.51 lbs | $4.93 | $5.02 | $-0.09 |
| 208612 | 2019-11-30 | $59.71 | Ground Home Delivery | 1 | 16.00 lbs | $21.50 | $19.28 | $2.22 |
| 208614 | 2019-11-30 | $11.25 | First-Class Package Service | 6 | 0.06 lbs | $3.81 | $3.28 | $0.53 |
| 208615 | 2019-11-30 | $46.96 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.70 lbs | $8.35 | $7.50 | $0.85 |
| 208616 | 2019-11-30 | $21.22 | First-Class Package Service | 1 | 0.45 lbs | $4.54 | $4.19 | $0.35 |
| 208617 | 2019-11-30 | $53.31 | Priority Mail 3-Day | 9 | 1.70 lbs | $12.65 | $10.00 | $2.65 |
| 208624 | 2019-11-30 | $33.43 | Priority Mail 2-Day | 15 | 2.97 lbs | $16.44 | $17.92 | $-1.48 |
| 208628 | 2019-12-01 | $33.34 | Direct Link International | 5 | 0.41 lbs | $20.82 | $11.86 | $8.96 |
| 208629 | 2019-12-01 | $32.69 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.35 | $7.50 | $0.85 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |