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 |
|---|---|---|---|---|---|---|---|---|
| 231107 | 2023-02-16 | $15.63 | Priority Mail | 1 | 0.04 lbs | $10.06 | $8.10 | $1.96 |
| 231108 | 2023-02-16 | $13.09 | First-Class Package Service | 4 | 0.57 lbs | $6.28 | $5.33 | $0.95 |
| 231109 | 2023-02-16 | $108.45 | Priority Mail Medium Flat Rate Box | 6 | 33.56 lbs | $16.40 | $14.00 | $2.40 |
| 231113 | 2023-02-16 | $15.94 | First-Class Package Service | 1 | 0.07 lbs | $4.95 | $3.75 | $1.20 |
| 231114 | 2023-02-16 | $13.92 | First-Class Package Service | 9 | 0.13 lbs | $5.01 | $4.20 | $0.81 |
| 231115 | 2023-02-16 | $26.61 | First-Class Package Service | 3 | 0.20 lbs | $5.64 | $4.13 | $1.51 |
| 231116 | 2023-02-16 | $30.44 | First-Class Package Service | 5 | 0.41 lbs | $6.24 | $4.24 | $2.00 |
| 231117 | 2023-02-17 | $31.90 | First-Class Package Service | 9 | 0.50 lbs | $6.24 | $5.04 | $1.20 |
| 231118 | 2023-02-17 | $109.69 | Priority Mail Small Flat Rate Box | 4 | 1.00 lbs | $9.65 | $8.30 | $1.35 |
| 231119 | 2023-02-17 | $29.09 | USPS First Class | 1 | 0.40 lbs | $5.60 | $4.81 | $0.79 |
| 231121 | 2023-02-17 | $18.64 | USPS First Class | 1 | 0.60 lbs | $6.65 | $4.13 | $2.52 |
| 231122 | 2023-02-17 | $8.87 | First-Class Package Service | 5 | 0.05 lbs | $5.17 | $3.97 | $1.20 |
| 231126 | 2023-02-17 | $10.14 | USPS Shipping | 1 | 0.20 lbs | $5.15 | $4.09 | $1.06 |
| 231127 | 2023-02-18 | $19.84 | USPS First Class | 1 | 0.45 lbs | $5.85 | $5.33 | $0.52 |
| 231128 | 2023-02-18 | $7.19 | First-Class Package Service | 1 | 0.01 lbs | $4.95 | $4.15 | $0.80 |
| 231130 | 2023-02-18 | $13.36 | First-Class Package Service | 1 | 0.04 lbs | $5.01 | $3.81 | $1.20 |
| 231131 | 2023-02-19 | $30.06 | Priority Mail | 6 | 2.10 lbs | $9.96 | $7.89 | $2.07 |
| 231133 | 2023-02-19 | $20.47 | Priority Mail | 2 | 0.66 lbs | $10.49 | $8.82 | $1.67 |
| 231135 | 2023-02-20 | $47.61 | Priority Mail Medium Flat Rate Box | 1 | 2.85 lbs | $16.40 | $14.00 | $2.40 |
| 231140 | 2023-02-20 | $37.79 | First-Class Package Service | 2 | 0.65 lbs | $7.55 | $6.60 | $0.95 |
| 231145 | 2023-02-21 | $18.82 | Priority Mail Flat Rate Envelope | 1 | 0.30 lbs | $9.15 | $8.10 | $1.05 |
| 231148 | 2023-02-21 | $100.23 | Ground Home Delivery | 1 | 2.15 lbs | $63.12 | $50.15 | $12.97 |
| 231156 | 2023-02-23 | $9.87 | USPS Shipping | 1 | 0.05 lbs | $5.15 | $3.90 | $1.25 |
| 231157 | 2023-02-23 | $9.34 | First-Class Package Service | 1 | 0.04 lbs | $5.10 | $3.90 | $1.20 |
| 231158 | 2023-02-23 | $12.32 | First-Class Package Service | 3 | 0.03 lbs | $5.10 | $3.90 | $1.20 |
| 231161 | 2023-02-23 | $13.36 | First-Class Package Service | 3 | 0.87 lbs | $7.64 | $6.44 | $1.20 |
| 231167 | 2023-02-23 | $12.75 | First-Class Package Service | 1 | 0.16 lbs | $5.51 | $3.97 | $1.54 |
| 231169 | 2023-02-24 | $54.41 | Priority Mail Small Flat Rate Box | 1 | 1.70 lbs | $9.65 | $8.10 | $1.55 |
| 231170 | 2023-02-23 | $10.14 | USPS First Class | 1 | 0.05 lbs | $5.15 | $3.97 | $1.18 |
| 231174 | 2023-02-24 | $38.06 | Priority Mail Small Flat Rate Box | 1 | 1.40 lbs | $9.65 | $8.10 | $1.55 |
| 231176 | 2023-02-24 | $12.89 | USPS First Class | 1 | 0.06 lbs | $5.00 | $3.75 | $1.25 |
| 231177 | 2023-02-25 | $17.06 | USPS Shipping | 1 | 0.05 lbs | $5.15 | $4.13 | $1.02 |
| 231179 | 2023-02-25 | $54.16 | Priority Mail Small Flat Rate Box | 1 | 1.60 lbs | $9.65 | $8.10 | $1.55 |
| 231181 | 2023-02-26 | $86.07 | Priority Mail Padded Flat Rate Envelope | 1 | 2.10 lbs | $9.90 | $8.30 | $1.60 |
| 231191 | 2023-02-27 | $7.41 | First-Class Package Service | 1 | 0.05 lbs | $5.17 | $3.97 | $1.20 |
| 231192 | 2023-02-26 | $21.69 | USPS Priority Mail | 1 | 1.00 lbs | $10.95 | $9.94 | $1.01 |
| 231193 | 2023-02-26 | $15.09 | USPS First Class | 1 | 0.07 lbs | $5.10 | $3.90 | $1.20 |
| 231194 | 2023-02-26 | $7.14 | USPS First Class | 1 | 0.04 lbs | $5.15 | $3.97 | $1.18 |
| 231195 | 2023-02-26 | $7.94 | USPS Shipping | 1 | 0.06 lbs | $5.15 | $4.44 | $0.71 |
| 231198 | 2023-02-27 | $89.38 | USPS Shipping | 1 | 5.80 lbs | $27.59 | $14.86 | $12.73 |
| 231201 | 2023-02-27 | $25.38 | First-Class Package Service | 2 | 0.55 lbs | $6.24 | $6.44 | $-0.20 |
| 231203 | 2023-02-28 | $55.82 | First-Class Package International Service | 1 | 0.95 lbs | $37.69 | $29.64 | $8.05 |
| 231204 | 2023-02-27 | $33.10 | USPS Parcel Select Ground | 1 | 0.69 lbs | $8.61 | $8.61 | $0.00 |
| 231205 | 2023-02-27 | $15.24 | USPS First Class | 1 | 0.05 lbs | $5.25 | $4.13 | $1.12 |
| 231206 | 2023-02-28 | $10.14 | USPS Shipping | 1 | 0.20 lbs | $5.15 | $3.75 | $1.40 |
| 231207 | 2023-02-28 | $138.19 | Priority Mail | 5 | 16.10 lbs | $19.93 | $19.55 | $0.38 |
| 231209 | 2023-02-28 | $29.94 | First-Class Package Service | 1 | 0.03 lbs | $4.95 | $3.75 | $1.20 |
| 231210 | 2023-03-01 | $43.89 | First-Class Package Service | 18 | 0.65 lbs | $6.37 | $5.17 | $1.20 |
| 231211 | 2023-02-28 | $14.09 | USPS First Class | 1 | 0.40 lbs | $5.70 | $4.24 | $1.46 |
| 231212 | 2023-03-01 | $10.04 | USPS First Class | 1 | 0.03 lbs | $5.05 | $3.81 | $1.24 |
| 231214 | 2023-03-01 | $11.15 | First-Class Package Service | 5 | 0.02 lbs | $4.95 | $4.15 | $0.80 |
| 231215 | 2023-03-01 | $12.63 | First-Class Package Service | 2 | 0.31 lbs | $5.40 | $4.20 | $1.20 |
| 231216 | 2023-03-02 | $14.24 | USPS First Class | 1 | 0.20 lbs | $5.25 | $4.44 | $0.81 |
| 231217 | 2023-03-02 | $20.94 | USPS First Class | 1 | 0.30 lbs | $5.85 | $4.44 | $1.41 |
| 231218 | 2023-03-02 | $10.75 | USPS Shipping | 1 | 0.05 lbs | $5.15 | $4.31 | $0.84 |
| 231219 | 2023-03-02 | $156.86 | Priority Mail | 10 | 2.88 lbs | $17.11 | $16.01 | $1.10 |
| 231221 | 2023-03-02 | $88.01 | Priority Mail Flat Rate Envelope | 4 | 1.80 lbs | $9.15 | $8.30 | $0.85 |
| 231223 | 2023-03-02 | $29.80 | First-Class Package Service | 1 | 0.45 lbs | $6.01 | $4.81 | $1.20 |
| 231224 | 2023-03-03 | $50.62 | USPS Shipping | 1 | 1.78 lbs | $24.35 | $4.35 | $20.00 |
| 231225 | 2023-03-03 | $9.44 | USPS Shipping | 1 | 0.07 lbs | $5.15 | $3.97 | $1.18 |
| 231226 | 2023-03-03 | $72.04 | USPS Priority Mail | 1 | 1.20 lbs | $17.05 | $8.30 | $8.75 |
| 231227 | 2023-03-03 | $15.04 | USPS First Class | 1 | 0.05 lbs | $5.05 | $3.81 | $1.24 |
| 231230 | 2023-03-03 | $54.57 | USPS Shipping | 1 | 2.30 lbs | $18.58 | $15.22 | $3.36 |
| 231231 | 2023-03-06 | $12.19 | USPS First Class | 1 | 0.25 lbs | $4.90 | $4.74 | $0.16 |
| 231232 | 2023-03-05 | $34.34 | USPS Parcel Select Ground | 1 | 2.30 lbs | $12.25 | $11.64 | $0.61 |
| 231233 | 2023-03-05 | $7.94 | USPS First Class | 1 | 0.03 lbs | $5.05 | $3.81 | $1.24 |
| 231234 | 2023-03-04 | $18.39 | USPS First Class | 1 | 0.60 lbs | $6.40 | $3.81 | $2.59 |
| 231235 | 2023-03-06 | $20.84 | USPS Shipping | 1 | 0.30 lbs | $5.75 | $4.20 | $1.55 |
| 231237 | 2023-03-06 | $16.84 | USPS First Class | 1 | 0.05 lbs | $5.05 | $3.81 | $1.24 |
| 231239 | 2023-03-06 | $9.84 | First-Class Package Service | 1 | 0.03 lbs | $5.10 | $3.90 | $1.20 |
| 231242 | 2023-03-07 | $55.96 | Priority Mail International Flat Rate Envelope | 1 | 1.10 lbs | $29.67 | $28.57 | $1.10 |
| 231246 | 2023-03-07 | $72.04 | USPS Priority Mail | 1 | 1.20 lbs | $17.05 | $8.30 | $8.75 |
| 231247 | 2023-03-07 | $9.14 | USPS First Class | 1 | 0.06 lbs | $5.15 | $3.97 | $1.18 |
| 231249 | 2023-03-07 | $10.54 | USPS First Class | 1 | 0.03 lbs | $5.25 | $4.13 | $1.12 |
| 231250 | 2023-03-07 | $15.14 | USPS Shipping | 2 | 0.10 lbs | $5.15 | $3.65 | $1.50 |
| 231251 | 2023-03-08 | $13.14 | USPS First Class | 1 | 0.06 lbs | $5.25 | $4.13 | $1.12 |
| 231253 | 2023-03-08 | $21.70 | First-Class Package Service | 10 | 0.35 lbs | $5.40 | $4.20 | $1.20 |
| 231254 | 2023-03-08 | $46.22 | First-Class Package Service | 2 | 0.60 lbs | $6.24 | $6.44 | $-0.20 |
| 231255 | 2023-03-08 | $65.69 | USPS First Class | 1 | 0.50 lbs | $5.70 | $4.24 | $1.46 |
| 231256 | 2023-03-08 | $14.60 | First-Class Package Service | 4 | 0.23 lbs | $5.64 | $4.44 | $1.20 |
| 231258 | 2023-03-09 | $8.75 | First-Class Package Service | 1 | 0.19 lbs | $5.51 | $3.97 | $1.54 |
| 231259 | 2023-03-09 | $15.23 | First-Class Package Service | 4 | 0.48 lbs | $7.02 | $6.07 | $0.95 |
| 231260 | 2023-03-09 | $16.69 | USPS First Class | 1 | 0.14 lbs | $5.00 | $4.15 | $0.85 |
| 231263 | 2023-03-10 | $9.91 | First-Class Package Service | 1 | 0.03 lbs | $5.17 | $3.97 | $1.20 |
| 231265 | 2023-03-10 | $11.07 | First-Class Package Service | 3 | 0.30 lbs | $5.35 | $4.15 | $1.20 |
| 231268 | 2023-03-10 | $14.16 | First-Class Package Service | 1 | 0.07 lbs | $5.17 | $3.97 | $1.20 |
| 231271 | 2023-03-12 | $24.41 | First-Class Package Service | 2 | 0.03 lbs | $5.33 | $4.13 | $1.20 |
| 231275 | 2023-03-13 | $72.04 | USPS Priority Mail | 1 | 1.20 lbs | $17.05 | $8.30 | $8.75 |
| 231276 | 2023-03-12 | $11.64 | USPS First Class | 1 | 0.05 lbs | $5.15 | $3.97 | $1.18 |
| 231277 | 2023-03-11 | $61.39 | USPS First Class | 1 | 0.56 lbs | $6.40 | $4.88 | $1.52 |
| 231278 | 2023-03-11 | $9.14 | USPS First Class | 1 | 0.02 lbs | $5.15 | $3.97 | $1.18 |
| 231279 | 2023-03-13 | $69.40 | USPS Shipping | 1 | 3.15 lbs | $39.75 | $5.75 | $34.00 |
| 231281 | 2023-03-13 | $60.24 | USPS Priority Mail | 1 | 9.25 lbs | $22.85 | $34.81 | $-11.96 |
| 231294 | 2023-03-14 | $17.01 | First-Class Package Service | 2 | 0.10 lbs | $5.33 | $4.13 | $1.20 |
| 231295 | 2023-03-14 | $31.29 | First-Class Package Service | 2 | 0.50 lbs | $6.01 | $4.81 | $1.20 |
| 231296 | 2023-03-14 | $7.04 | USPS Shipping | 1 | 0.06 lbs | $5.15 | $4.13 | $1.02 |
| 231297 | 2023-03-15 | $18.59 | First-Class Package Service | 1 | 0.30 lbs | $5.64 | $4.44 | $1.20 |
| 231314 | 2023-03-15 | $26.34 | USPS First Class | 1 | 0.40 lbs | $5.65 | $4.88 | $0.77 |
| 231315 | 2023-03-15 | $43.18 | USPS First Class | 2 | 0.12 lbs | $9.70 | $3.64 | $6.06 |
| 231322 | 2023-03-15 | $12.72 | First-Class Package Service | 1 | 0.20 lbs | $5.35 | $3.75 | $1.60 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |