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 |
|---|---|---|---|---|---|---|---|---|
| 231323 | 2023-03-16 | $13.04 | USPS First Class | 1 | 0.06 lbs | $5.15 | $3.97 | $1.18 |
| 231324 | 2023-03-15 | $14.34 | USPS First Class | 1 | 0.55 lbs | $6.35 | $6.07 | $0.28 |
| 231325 | 2023-03-16 | $27.44 | USPS Shipping | 1 | 3.10 lbs | $7.85 | $5.05 | $2.80 |
| 231326 | 2023-03-15 | $8.74 | USPS Shipping | 1 | 0.04 lbs | $5.15 | $3.66 | $1.49 |
| 231327 | 2023-03-16 | $57.89 | Priority Mail Padded Flat Rate Envelope | 1 | 1.56 lbs | $9.90 | $8.30 | $1.60 |
| 231329 | 2023-03-16 | $37.23 | Priority Mail | 5 | 1.32 lbs | $13.07 | $8.30 | $4.77 |
| 231330 | 2023-03-16 | $53.61 | Priority Mail Small Flat Rate Box | 1 | 1.60 lbs | $9.65 | $8.10 | $1.55 |
| 231331 | 2023-03-17 | $27.96 | Priority Mail Padded Flat Rate Envelope | 2 | 1.40 lbs | $9.90 | $8.30 | $1.60 |
| 231333 | 2023-03-17 | $165.16 | Ground | 100 | 20.55 lbs | $51.66 | $28.17 | $23.49 |
| 231334 | 2023-03-16 | $11.09 | USPS First Class | 1 | 0.10 lbs | $4.90 | $3.66 | $1.24 |
| 231335 | 2023-03-16 | $61.39 | USPS First Class | 1 | 0.56 lbs | $6.40 | $4.88 | $1.52 |
| 231336 | 2023-03-17 | $68.89 | Priority Mail Padded Flat Rate Envelope | 1 | 0.50 lbs | $9.90 | $8.30 | $1.60 |
| 231337 | 2023-03-17 | $41.09 | Priority Mail Medium Flat Rate Box | 7 | 1.64 lbs | $16.40 | $13.17 | $3.23 |
| 231338 | 2023-03-17 | $68.39 | USPS Priority Mail | 1 | 1.20 lbs | $13.40 | $9.94 | $3.46 |
| 231339 | 2023-03-17 | $14.97 | First-Class Package Service | 4 | 0.80 lbs | $7.02 | $6.07 | $0.95 |
| 231340 | 2023-03-17 | $36.60 | Priority Mail Flat Rate Envelope | 1 | 1.00 lbs | $9.15 | $7.60 | $1.55 |
| 231344 | 2023-03-17 | $10.95 | First-Class Package Service | 1 | 0.09 lbs | $4.95 | $3.75 | $1.20 |
| 231347 | 2023-03-18 | $51.05 | Priority Mail Flat Rate Envelope | 2 | 1.70 lbs | $9.15 | $8.10 | $1.05 |
| 231349 | 2023-03-18 | $54.80 | Ground | 2 | 0.96 lbs | $41.83 | $30.45 | $11.38 |
| 231350 | 2023-03-18 | $14.14 | First-Class Package Service | 1 | 0.07 lbs | $5.17 | $3.97 | $1.20 |
| 231351 | 2023-03-18 | $20.88 | First-Class Package Service | 7 | 0.31 lbs | $5.44 | $4.24 | $1.20 |
| 231354 | 2023-03-19 | $55.98 | Priority Mail Small Flat Rate Box | 1 | 1.45 lbs | $9.65 | $8.10 | $1.55 |
| 231355 | 2023-03-19 | $18.63 | First-Class Package Service | 1 | 0.19 lbs | $5.64 | $4.13 | $1.51 |
| 231356 | 2023-03-19 | $14.91 | First-Class Package Service | 10 | 0.14 lbs | $5.33 | $4.13 | $1.20 |
| 231360 | 2023-03-19 | $12.44 | USPS First Class | 1 | 0.20 lbs | $5.05 | $3.81 | $1.24 |
| 231361 | 2023-03-19 | $14.34 | USPS First Class | 1 | 0.55 lbs | $6.35 | $6.07 | $0.28 |
| 231362 | 2023-03-19 | $11.74 | USPS First Class | 1 | 0.15 lbs | $5.05 | $3.81 | $1.24 |
| 231363 | 2023-03-19 | $66.44 | USPS Priority Mail | 1 | 1.20 lbs | $11.45 | $8.05 | $3.40 |
| 231364 | 2023-03-18 | $13.64 | USPS First Class | 1 | 0.06 lbs | $5.15 | $3.97 | $1.18 |
| 231365 | 2023-03-18 | $14.14 | USPS First Class | 1 | 0.04 lbs | $5.15 | $3.97 | $1.18 |
| 231366 | 2023-03-20 | $77.90 | USPS Shipping | 1 | 3.05 lbs | $9.15 | $8.30 | $0.85 |
| 231367 | 2023-03-19 | $24.74 | USPS Shipping | 1 | 0.35 lbs | $5.75 | $5.04 | $0.71 |
| 231368 | 2023-03-19 | $10.14 | USPS Shipping | 1 | 0.20 lbs | $5.15 | $4.24 | $0.91 |
| 231371 | 2023-03-20 | $9.38 | First-Class Package Service | 2 | 0.21 lbs | $5.15 | $3.81 | $1.34 |
| 231373 | 2023-03-20 | $17.81 | First-Class Package Service | 2 | 0.07 lbs | $5.33 | $4.44 | $0.89 |
| 231374 | 2023-03-20 | $17.93 | First-Class Package Service | 2 | 0.04 lbs | $4.95 | $3.75 | $1.20 |
| 231375 | 2023-03-20 | $13.62 | First-Class Package Service | 2 | 0.22 lbs | $5.64 | $4.13 | $1.51 |
| 231377 | 2023-03-20 | $15.14 | USPS First Class | 1 | 0.05 lbs | $5.15 | $4.31 | $0.84 |
| 231378 | 2023-03-21 | $48.16 | Priority Mail | 3 | 3.30 lbs | $10.26 | $7.41 | $2.85 |
| 231379 | 2023-03-21 | $9.99 | USPS First Class | 1 | 0.06 lbs | $5.00 | $3.75 | $1.25 |
| 231380 | 2023-03-21 | $37.06 | Priority Mail Flat Rate Envelope | 1 | 1.15 lbs | $9.15 | $8.10 | $1.05 |
| 231383 | 2023-03-21 | $7.94 | USPS Shipping | 1 | 0.06 lbs | $5.15 | $5.17 | $-0.02 |
| 231384 | 2023-03-21 | $15.14 | USPS Shipping | 2 | 0.10 lbs | $5.15 | $4.31 | $0.84 |
| 231385 | 2023-03-22 | $49.12 | Priority Mail | 20 | 5.66 lbs | $12.51 | $9.61 | $2.90 |
| 231386 | 2023-03-22 | $7.25 | First-Class Package Service | 1 | 0.01 lbs | $5.01 | $3.81 | $1.20 |
| 231387 | 2023-03-22 | $74.51 | First-Class Package Service | 31 | 0.85 lbs | $7.42 | $4.20 | $3.22 |
| 231388 | 2023-03-23 | $85.99 | Priority Mail Large Flat Rate Box | 1 | 12.00 lbs | $21.00 | $14.00 | $7.00 |
| 231390 | 2023-03-22 | $15.04 | USPS First Class | 1 | 0.05 lbs | $5.05 | $4.20 | $0.85 |
| 231391 | 2023-03-23 | $21.14 | USPS Shipping | 1 | 0.20 lbs | $5.15 | $4.15 | $1.00 |
| 231392 | 2023-03-23 | $62.41 | Priority Mail | 18 | 1.42 lbs | $15.33 | $12.82 | $2.51 |
| 231393 | 2023-03-23 | $13.59 | USPS First Class | 1 | 0.06 lbs | $5.10 | $3.90 | $1.20 |
| 231396 | 2023-03-23 | $14.60 | First-Class Package Service | 3 | 0.28 lbs | $4.94 | $3.99 | $0.95 |
| 231397 | 2023-03-23 | $17.87 | First-Class Package Service | 3 | 0.07 lbs | $4.86 | $4.09 | $0.77 |
| 231402 | 2023-03-24 | $8.25 | First-Class Package Service | 1 | 0.01 lbs | $5.01 | $3.81 | $1.20 |
| 231419 | 2023-03-24 | $9.57 | First-Class Package Service | 1 | 0.03 lbs | $5.33 | $4.13 | $1.20 |
| 231421 | 2023-03-25 | $8.07 | First-Class Package Service | 1 | 0.03 lbs | $4.86 | $3.66 | $1.20 |
| 231422 | 2023-03-24 | $20.99 | USPS First Class | 1 | 0.06 lbs | $5.00 | $3.75 | $1.25 |
| 231423 | 2023-03-24 | $10.24 | USPS First Class | 1 | 0.05 lbs | $5.25 | $4.13 | $1.12 |
| 231424 | 2023-03-24 | $17.69 | USPS First Class | 1 | 0.30 lbs | $5.70 | $4.24 | $1.46 |
| 231425 | 2023-03-25 | $25.55 | First-Class Package Service | 1 | 0.50 lbs | $7.73 | $6.78 | $0.95 |
| 231426 | 2023-03-25 | $64.26 | Ground | 1 | 2.40 lbs | $36.34 | $25.31 | $11.03 |
| 231429 | 2023-03-26 | $17.38 | Priority Mail Flat Rate Envelope | 2 | 0.06 lbs | $9.15 | $7.60 | $1.55 |
| 231431 | 2023-03-26 | $22.95 | First-Class Package Service | 4 | 0.44 lbs | $6.24 | $4.24 | $2.00 |
| 231435 | 2023-03-27 | $9.24 | USPS First Class | 1 | 0.01 lbs | $5.25 | $4.44 | $0.81 |
| 231436 | 2023-03-26 | $11.84 | USPS First Class | 1 | 0.36 lbs | $5.85 | $4.13 | $1.72 |
| 231437 | 2023-03-25 | $13.66 | USPS Parcel Select Ground | 1 | 0.10 lbs | $7.87 | $7.52 | $0.35 |
| 231438 | 2023-03-27 | $11.34 | USPS First Class | 1 | 0.10 lbs | $5.15 | $3.97 | $1.18 |
| 231440 | 2023-03-27 | $18.94 | USPS First Class | 1 | 0.40 lbs | $5.75 | $4.31 | $1.44 |
| 231441 | 2023-03-27 | $13.95 | USPS Shipping | 1 | 0.06 lbs | $5.15 | $3.97 | $1.18 |
| 231447 | 2023-03-27 | $78.39 | Priority Mail Medium Flat Rate Box | 1 | 3.05 lbs | $16.40 | $8.30 | $8.10 |
| 231451 | 2023-03-27 | $13.49 | USPS First Class | 1 | 0.21 lbs | $5.00 | $3.75 | $1.25 |
| 231452 | 2023-03-27 | $26.08 | USPS Parcel Select Ground | 1 | 0.92 lbs | $8.09 | $8.98 | $-0.89 |
| 231456 | 2023-03-28 | $31.33 | First-Class Package Service | 7 | 0.23 lbs | $5.64 | $4.44 | $1.20 |
| 231458 | 2023-03-29 | $22.43 | Priority Mail | 1 | 1.10 lbs | $13.07 | $11.97 | $1.10 |
| 231460 | 2023-03-29 | $20.57 | First-Class Package Service | 1 | 0.06 lbs | $5.17 | $3.97 | $1.20 |
| 231464 | 2023-03-29 | $8.76 | First-Class Package Service | 4 | 0.04 lbs | $4.95 | $3.75 | $1.20 |
| 231467 | 2023-03-29 | $14.85 | First-Class Package Service | 1 | 0.30 lbs | $5.35 | $4.15 | $1.20 |
| 231468 | 2023-03-30 | $22.30 | First-Class Package Service | 4 | 0.20 lbs | $5.44 | $3.90 | $1.54 |
| 231469 | 2023-03-29 | $15.94 | USPS Shipping | 1 | 0.05 lbs | $5.15 | $3.66 | $1.49 |
| 231476 | 2023-03-31 | $11.34 | USPS First Class | 1 | 0.10 lbs | $5.15 | $3.97 | $1.18 |
| 231478 | 2023-03-31 | $9.25 | USPS Shipping | 1 | 0.05 lbs | $5.15 | $4.15 | $1.00 |
| 231479 | 2023-03-31 | $11.04 | USPS Shipping | 1 | 0.06 lbs | $5.15 | $3.97 | $1.18 |
| 231480 | 2023-03-31 | $45.31 | First-Class Package Service | 1 | 0.29 lbs | $5.51 | $4.31 | $1.20 |
| 231481 | 2023-03-31 | $15.04 | USPS First Class | 1 | 0.05 lbs | $5.05 | $3.81 | $1.24 |
| 231482 | 2023-03-31 | $17.59 | USPS First Class | 1 | 0.30 lbs | $5.60 | $4.15 | $1.45 |
| 231483 | 2023-04-01 | $18.34 | First-Class Package Service | 1 | 0.25 lbs | $5.35 | $4.15 | $1.20 |
| 231484 | 2023-04-01 | $10.19 | First-Class Package Service | 1 | 0.03 lbs | $4.95 | $3.75 | $1.20 |
| 231485 | 2023-04-01 | $90.12 | Priority Mail Flat Rate Envelope | 3 | 1.80 lbs | $9.15 | $8.10 | $1.05 |
| 231486 | 2023-04-02 | $9.41 | First-Class Package Service | 1 | 0.01 lbs | $5.10 | $3.90 | $1.20 |
| 231488 | 2023-04-02 | $25.75 | First-Class Package Service | 1 | 0.60 lbs | $5.76 | $4.81 | $0.95 |
| 231489 | 2023-04-02 | $29.34 | USPS First Class | 1 | 0.40 lbs | $5.85 | $4.44 | $1.41 |
| 231490 | 2023-04-01 | $9.09 | USPS First Class | 1 | 0.02 lbs | $5.10 | $3.90 | $1.20 |
| 231491 | 2023-03-31 | $15.24 | USPS First Class | 1 | 0.05 lbs | $5.25 | $4.44 | $0.81 |
| 231492 | 2023-04-03 | $12.67 | USPS Shipping | 1 | 0.10 lbs | $5.15 | $4.13 | $1.02 |
| 231493 | 2023-04-01 | $7.94 | USPS Shipping | 2 | 0.12 lbs | $5.15 | $4.13 | $1.02 |
| 231494 | 2023-04-03 | $45.76 | Priority Mail | 8 | 1.00 lbs | $9.84 | $8.05 | $1.79 |
| 231495 | 2023-04-03 | $19.40 | First-Class Package Service | 4 | 0.29 lbs | $5.44 | $4.24 | $1.20 |
| 231496 | 2023-04-04 | $36.03 | USPS Shipping | 1 | 0.70 lbs | $6.55 | $8.30 | $-1.75 |
| 231497 | 2023-04-04 | $11.84 | USPS Shipping | 1 | 0.06 lbs | $5.15 | $3.90 | $1.25 |
| 231498 | 2023-04-04 | $14.63 | First-Class Package Service | 1 | 0.20 lbs | $5.64 | $4.44 | $1.20 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |