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 |
|---|---|---|---|---|---|---|---|---|
| 208278 | 2019-11-02 | $5.94 | First-Class Package Service | 1 | 0.05 lbs | $3.75 | $2.70 | $1.05 |
| 208280 | 2019-11-02 | $8.13 | First-Class Package Service | 2 | 0.10 lbs | $3.75 | $3.22 | $0.53 |
| 208281 | 2019-11-02 | $56.78 | Priority Mail 3-Day | 5 | 1.55 lbs | $8.73 | $7.88 | $0.85 |
| 208282 | 2019-11-02 | $16.33 | First-Class Package Service | 1 | 0.30 lbs | $4.54 | $4.19 | $0.35 |
| 208283 | 2019-11-02 | $12.74 | First-Class Package Service | 7 | 0.08 lbs | $3.81 | $2.76 | $1.05 |
| 208285 | 2019-11-02 | $37.14 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.35 | $7.50 | $0.85 |
| 208287 | 2019-11-03 | $95.89 | Priority Mail 3-Day Medium Flat Rate Box | 6 | 2.86 lbs | $14.05 | $10.00 | $4.05 |
| 208288 | 2019-11-03 | $36.88 | Priority Mail 3-Day Flat Rate Envelope | 1 | 1.15 lbs | $7.80 | $7.50 | $0.30 |
| 208289 | 2019-11-03 | $19.54 | Priority Mail 3-Day | 1 | 0.95 lbs | $10.55 | $9.70 | $0.85 |
| 208290 | 2019-11-03 | $16.05 | First-Class Package Service | 2 | 0.54 lbs | $6.07 | $5.02 | $1.05 |
| 208292 | 2019-11-03 | $9.53 | First-Class Package Service | 2 | 0.10 lbs | $3.75 | $2.70 | $1.05 |
| 208293 | 2019-11-03 | $97.65 | Priority Mail 3-Day | 3 | 3.15 lbs | $10.88 | $8.76 | $2.12 |
| 208294 | 2019-11-03 | $36.19 | Priority Mail 3-Day Flat Rate Envelope | 1 | 1.27 lbs | $7.80 | $7.50 | $0.30 |
| 208295 | 2019-11-03 | $50.76 | Priority Mail 2-Day Padded Flat Rate Envelope | 4 | 1.48 lbs | $8.40 | $7.55 | $0.85 |
| 208296 | 2019-11-03 | $65.98 | Priority Mail 3-Day Padded Flat Rate Envelope | 2 | 2.20 lbs | $8.40 | $7.55 | $0.85 |
| 208298 | 2019-11-03 | $12.31 | First-Class Package Service | 2 | 0.32 lbs | $4.33 | $3.28 | $1.05 |
| 208299 | 2019-11-03 | $7.12 | First-Class Package Service | 1 | 0.05 lbs | $3.71 | $2.66 | $1.05 |
| 208300 | 2019-11-03 | $17.03 | Priority Mail 2-Day | 2 | 0.65 lbs | $9.35 | $7.65 | $1.70 |
| 208302 | 2019-11-04 | $25.65 | First-Class Package Service - Retail | 1 | 0.40 lbs | $5.66 | $4.33 | $1.33 |
| 208305 | 2019-11-04 | $14.05 | First-Class Package Service | 2 | 0.35 lbs | $8.55 | $4.19 | $4.36 |
| 208306 | 2019-11-04 | $14.46 | First-Class Package Service | 5 | 0.17 lbs | $4.01 | $2.96 | $1.05 |
| 208307 | 2019-11-04 | $30.14 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.60 lbs | $7.80 | $7.55 | $0.25 |
| 208308 | 2019-11-04 | $21.31 | Priority Mail 2-Day | 4 | 1.01 lbs | $10.55 | $9.70 | $0.85 |
| 208309 | 2019-11-04 | $198.63 | Ground | 10 | 6.00 lbs | $21.93 | $17.72 | $4.21 |
| 208310 | 2019-11-04 | $16.72 | First-Class Package Service | 1 | 0.55 lbs | $4.93 | $5.02 | $-0.09 |
| 208314 | 2019-11-04 | $20.61 | First-Class Package Service | 1 | 0.35 lbs | $4.27 | $3.88 | $0.39 |
| 208315 | 2019-11-04 | $14.78 | First-Class Package Service | 11 | 0.12 lbs | $3.89 | $2.84 | $1.05 |
| 208316 | 2019-11-04 | $25.76 | Priority Mail 2-Day Flat Rate Envelope | 4 | 1.82 lbs | $7.80 | $7.50 | $0.30 |
| 208317 | 2019-11-04 | $21.76 | First-Class Package Service | 1 | 0.35 lbs | $4.27 | $3.22 | $1.05 |
| 208319 | 2019-11-05 | $193.68 | Priority Mail 3-Day Flat Rate Envelope | 10 | 4.50 lbs | $7.80 | $8.12 | $-0.32 |
| 208321 | 2019-11-05 | $56.50 | Priority Mail 2-Day | 4 | 1.01 lbs | $8.73 | $7.88 | $0.85 |
| 208323 | 2019-11-05 | $22.09 | First-Class Package Service | 4 | 0.28 lbs | $4.33 | $3.28 | $1.05 |
| 208324 | 2019-11-05 | $26.12 | First-Class Package Service | 6 | 0.28 lbs | $4.68 | $3.09 | $1.59 |
| 208328 | 2019-11-05 | $33.76 | Priority Mail 1-Day Flat Rate Envelope | 1 | 3.55 lbs | $7.80 | $7.65 | $0.15 |
| 208329 | 2019-11-05 | $72.02 | First-Class Package International Service | 1 | 1.50 lbs | $31.53 | $23.28 | $8.25 |
| 208330 | 2019-11-05 | $9.38 | First-Class Package Service | 1 | 0.10 lbs | $3.89 | $2.84 | $1.05 |
| 208331 | 2019-11-05 | $38.99 | First-Class Package Service | 4 | 0.70 lbs | $6.43 | $5.38 | $1.05 |
| 208332 | 2019-11-05 | $22.84 | First-Class Package Service | 3 | 0.30 lbs | $4.41 | $4.06 | $0.35 |
| 208333 | 2019-11-05 | $13.36 | First-Class Package Service | 3 | 0.12 lbs | $3.89 | $2.84 | $1.05 |
| 208336 | 2019-11-05 | $62.65 | Priority Mail 2-Day Padded Flat Rate Envelope | 2 | 2.10 lbs | $8.40 | $7.55 | $0.85 |
| 208338 | 2019-11-06 | $31.24 | Priority Mail 3-Day | 3 | 1.20 lbs | $11.71 | $10.86 | $0.85 |
| 208341 | 2019-11-06 | $48.43 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.25 lbs | $7.80 | $7.55 | $0.25 |
| 208343 | 2019-11-06 | $38.14 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.25 lbs | $8.35 | $7.50 | $0.85 |
| 208344 | 2019-11-06 | $7.50 | First-Class Package Service | 1 | 0.03 lbs | $4.01 | $2.96 | $1.05 |
| 208345 | 2019-11-06 | $16.60 | First-Class Package Service | 1 | 0.40 lbs | $4.81 | $3.96 | $0.85 |
| 208346 | 2019-11-06 | $6.75 | First-Class Package Service | 6 | 0.06 lbs | $3.81 | $2.76 | $1.05 |
| 208351 | 2019-11-07 | $30.21 | First-Class Package Service | 3 | 0.57 lbs | $5.24 | $4.19 | $1.05 |
| 208352 | 2019-11-07 | $24.40 | First-Class Package Service | 1 | 0.40 lbs | $4.41 | $4.06 | $0.35 |
| 208354 | 2019-11-07 | $9.04 | First-Class Package Service | 10 | 0.10 lbs | $4.14 | $3.09 | $1.05 |
| 208357 | 2019-11-07 | $29.09 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.00 lbs | $8.35 | $7.50 | $0.85 |
| 208362 | 2019-11-08 | $44.17 | Priority Mail 3-Day Flat Rate Envelope | 3 | 1.00 lbs | $7.80 | $7.55 | $0.25 |
| 208363 | 2019-11-08 | $127.09 | Priority Mail 2-Day Medium Flat Rate Box | 6 | 4.82 lbs | $14.05 | $12.80 | $1.25 |
| 208366 | 2019-11-09 | $13.44 | First-Class Package Service | 4 | 0.14 lbs | $4.68 | $4.33 | $0.35 |
| 208367 | 2019-11-09 | $20.82 | First-Class Package Service | 1 | 0.40 lbs | $4.33 | $3.96 | $0.37 |
| 208369 | 2019-11-09 | $10.12 | First-Class Package Service | 2 | 0.08 lbs | $4.14 | $3.09 | $1.05 |
| 208373 | 2019-11-09 | $43.94 | Priority Mail 2-Day Flat Rate Envelope | 6 | 1.10 lbs | $7.80 | $7.55 | $0.25 |
| 208374 | 2019-11-10 | $46.58 | Priority Mail 3-Day | 7 | 1.25 lbs | $9.35 | $8.50 | $0.85 |
| 208375 | 2019-11-10 | $16.52 | First-Class Package Service | 2 | 0.30 lbs | $4.54 | $4.19 | $0.35 |
| 208376 | 2019-11-10 | $35.93 | Priority Mail 2-Day Small Flat Rate Box | 2 | 1.22 lbs | $8.35 | $7.50 | $0.85 |
| 208379 | 2019-11-10 | $37.14 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.35 | $7.50 | $0.85 |
| 208380 | 2019-11-10 | $15.75 | Priority Mail 2-Day Flat Rate Envelope | 5 | 0.06 lbs | $7.80 | $7.55 | $0.25 |
| 208384 | 2019-11-10 | $10.12 | First-Class Package Service | 2 | 0.02 lbs | $4.14 | $3.09 | $1.05 |
| 208385 | 2019-11-10 | $11.82 | First-Class Package Service | 2 | 0.23 lbs | $4.54 | $2.96 | $1.58 |
| 208386 | 2019-11-11 | $50.02 | Priority Mail 2-Day | 3 | 1.25 lbs | $11.08 | $10.23 | $0.85 |
| 208389 | 2019-11-11 | $35.18 | Priority Mail 3-Day | 1 | 2.40 lbs | $9.19 | $8.81 | $0.38 |
| 208390 | 2019-11-11 | $24.56 | First-Class Package Service | 1 | 0.90 lbs | $6.17 | $7.50 | $-1.33 |
| 208391 | 2019-11-11 | $55.73 | Priority Mail 2-Day | 3 | 1.47 lbs | $10.55 | $9.70 | $0.85 |
| 208392 | 2019-11-11 | $37.84 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.00 lbs | $8.35 | $7.50 | $0.85 |
| 208394 | 2019-11-11 | $103.92 | Direct Link International | 6 | 2.58 lbs | $29.28 | $27.43 | $1.85 |
| 208395 | 2019-11-11 | $54.55 | Priority Mail 3-Day Flat Rate Envelope | 5 | 1.98 lbs | $7.80 | $7.50 | $0.30 |
| 208402 | 2019-11-11 | $46.32 | Priority Mail 2-Day | 19 | 0.83 lbs | $11.71 | $8.25 | $3.46 |
| 208403 | 2019-11-11 | $99.25 | Ground | 7 | 5.74 lbs | $23.02 | $20.52 | $2.50 |
| 208405 | 2019-11-12 | $7.11 | First-Class Package Service | 3 | 0.01 lbs | $4.14 | $3.09 | $1.05 |
| 208406 | 2019-11-12 | $8.45 | First-Class Package Service | 2 | 0.24 lbs | $4.07 | $3.88 | $0.19 |
| 208407 | 2019-11-12 | $74.36 | Priority Mail 2-Day | 5 | 1.75 lbs | $12.65 | $10.00 | $2.65 |
| 208410 | 2019-11-12 | $7.60 | First-Class Package Service | 1 | 0.05 lbs | $3.81 | $2.76 | $1.05 |
| 208415 | 2019-11-12 | $45.83 | Priority Mail 1-Day | 1 | 1.85 lbs | $8.46 | $7.65 | $0.81 |
| 208416 | 2019-11-12 | $275.76 | Priority Mail 2-Day | 1 | 15.55 lbs | $45.92 | $49.49 | $-3.57 |
| 208419 | 2019-11-12 | $24.45 | Priority Mail 2-Day | 6 | 1.95 lbs | $10.11 | $9.26 | $0.85 |
| 208421 | 2019-11-13 | $8.00 | First-Class Package Service | 1 | 0.03 lbs | $4.01 | $2.96 | $1.05 |
| 208422 | 2019-11-13 | $7.05 | First-Class Package Service | 2 | 0.37 lbs | $4.07 | $3.88 | $0.19 |
| 208425 | 2019-11-13 | $84.33 | Priority Mail 2-Day | 5 | 3.18 lbs | $10.88 | $8.76 | $2.12 |
| 208426 | 2019-11-13 | $26.19 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.85 lbs | $7.80 | $7.55 | $0.25 |
| 208427 | 2019-11-13 | $9.38 | First-Class Package Service | 1 | 0.10 lbs | $3.89 | $2.84 | $1.05 |
| 208428 | 2019-11-13 | $38.50 | Priority Mail 3-Day | 10 | 3.25 lbs | $14.60 | $13.75 | $0.85 |
| 208432 | 2019-11-14 | $10.12 | First-Class Package Service | 2 | 0.10 lbs | $4.14 | $3.63 | $0.51 |
| 208433 | 2019-11-14 | $38.14 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.25 lbs | $8.35 | $7.50 | $0.85 |
| 208436 | 2019-11-15 | $26.39 | First-Class Package Service | 4 | 0.25 lbs | $4.33 | $3.28 | $1.05 |
| 208437 | 2019-11-15 | $24.92 | First-Class Package Service | 1 | 0.48 lbs | $4.93 | $3.88 | $1.05 |
| 208445 | 2019-11-15 | $177.15 | Priority Mail 2-Day Flat Rate Envelope | 4 | 14.77 lbs | $26.22 | $19.42 | $6.80 |
| 208447 | 2019-11-15 | $33.79 | Priority Mail 3-Day | 4 | 1.02 lbs | $8.73 | $7.88 | $0.85 |
| 208448 | 2019-11-15 | $25.67 | First-Class Package Service | 1 | 0.65 lbs | $6.38 | $5.53 | $0.85 |
| 208450 | 2019-11-16 | $39.57 | Priority Mail 3-Day Flat Rate Envelope | 3 | 1.11 lbs | $7.80 | $7.55 | $0.25 |
| 208451 | 2019-11-16 | $14.89 | First-Class Package Service | 1 | 0.30 lbs | $4.68 | $3.63 | $1.05 |
| 208453 | 2019-11-16 | $7.60 | First-Class Package Service | 1 | 0.05 lbs | $3.81 | $2.76 | $1.05 |
| 208454 | 2019-11-16 | $9.50 | First-Class Package Service | 1 | 0.15 lbs | $4.01 | $2.96 | $1.05 |
| 208455 | 2019-11-17 | $34.32 | Priority Mail 3-Day Small Flat Rate Box | 3 | 1.09 lbs | $8.35 | $7.50 | $0.85 |
| 208456 | 2019-11-17 | $28.96 | First-Class Package Service | 2 | 0.55 lbs | $5.38 | $4.33 | $1.05 |
| 208459 | 2019-11-17 | $32.15 | First-Class Package Service | 2 | 0.75 lbs | $5.99 | $4.94 | $1.05 |
| 208460 | 2019-11-17 | $77.76 | Priority Mail 3-Day Flat Rate Envelope | 4 | 2.70 lbs | $7.80 | $7.55 | $0.25 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |