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.21025 matching order(s)
| Order ID ▲ | Date | Order Total | Shipping Method | # Products | Total Weight | Shipping Charged | Shipping Paid | Profit |
|---|---|---|---|---|---|---|---|---|
| 218171 | 2020-11-30 | $25.19 | First-Class Package Service | 1 | 0.80 lbs | $5.90 | $5.65 | $0.25 |
| 218172 | 2020-11-30 | $25.49 | First-Class Package Service | 1 | 0.80 lbs | $6.20 | $5.95 | $0.25 |
| 218175 | 2020-11-30 | $47.33 | Priority Mail 2-Day Medium Flat Rate Box | 2 | 1.45 lbs | $14.85 | $11.69 | $3.16 |
| 218176 | 2020-11-30 | $38.69 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.20 lbs | $8.90 | $8.05 | $0.85 |
| 218177 | 2020-11-30 | $20.99 | USPSFirstClass | 1 | 0.16 lbs | $5.00 | $3.92 | $1.08 |
| 218179 | 2020-11-30 | $32.39 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.40 | $8.00 | $0.40 |
| 218181 | 2020-11-30 | $51.89 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.90 | $7.90 | $1.00 |
| 218182 | 2020-11-30 | $21.76 | First-Class Package Service | 5 | 0.18 lbs | $3.81 | $3.56 | $0.25 |
| 218185 | 2020-11-30 | $193.20 | Priority Mail 2-Day Flat Rate Envelope | 3 | 14.10 lbs | $8.40 | $8.15 | $0.25 |
| 218187 | 2020-11-30 | $17.16 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.50 | $3.43 | $0.07 |
| 218189 | 2020-11-04 | $6.81 | Priority Mail 2-Day | 1 | 0.04 lbs | $3.82 | $2.84 | $0.98 |
| 218190 | 2020-11-30 | $10.59 | First-Class Package Service | 4 | 0.05 lbs | $3.63 | $3.18 | $0.45 |
| 218191 | 2020-11-30 | $51.89 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.90 | $7.90 | $1.00 |
| 218192 | 2020-12-01 | $8.81 | USPSFirstClass | 1 | 0.05 lbs | $4.42 | $3.43 | $0.99 |
| 218194 | 2020-11-30 | $4.67 | First-Class Mail Stamped Letter | 3 | 0.03 lbs | $3.20 | $3.09 | $0.11 |
| 218197 | 2020-11-30 | $68.18 | Priority Mail 3-Day Padded Flat Rate Envelope | 2 | 2.60 lbs | $9.00 | $8.05 | $0.95 |
| 218199 | 2020-11-30 | $17.88 | First-Class Package Service | 6 | 0.81 lbs | $6.24 | $3.77 | $2.47 |
| 218200 | 2020-12-01 | $38.58 | Priority Mail Express 2-Day | 2 | 0.05 lbs | $30.60 | $8.05 | $22.55 |
| 218203 | 2020-12-01 | $4.18 | First-Class Mail Stamped Letter | 2 | 0.02 lbs | $3.20 | $3.09 | $0.11 |
| 218204 | 2020-12-01 | $51.89 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.90 | $7.90 | $1.00 |
| 218205 | 2020-12-01 | $27.89 | USPSFirstClass | 1 | 0.15 lbs | $4.95 | $3.46 | $1.49 |
| 218206 | 2020-12-01 | $9.24 | USPSFirstClass | 1 | 0.06 lbs | $4.25 | $3.18 | $1.07 |
| 218208 | 2020-12-01 | $51.89 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.55 lbs | $8.90 | $7.90 | $1.00 |
| 218209 | 2020-12-01 | $19.67 | First-Class Package Service | 2 | 0.39 lbs | $4.09 | $4.38 | $-0.29 |
| 218213 | 2020-12-01 | $8.57 | First-Class Package Service | 1 | 0.35 lbs | $4.68 | $5.65 | $-0.97 |
| 218216 | 2020-12-01 | $11.30 | First-Class Package Service | 2 | 0.08 lbs | $3.88 | $3.43 | $0.45 |
| 218217 | 2020-12-01 | $5.99 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.10 | $3.03 | $0.07 |
| 218218 | 2020-12-01 | $15.80 | First-Class Package Service | 1 | 0.30 lbs | $4.01 | $3.56 | $0.45 |
| 218220 | 2020-12-01 | $8.56 | USPSFirstClass | 1 | 0.10 lbs | $4.17 | $3.09 | $1.08 |
| 218221 | 2020-12-01 | $19.23 | First-Class Mail Stamped Letter | 2 | 0.10 lbs | $3.25 | $3.30 | $-0.05 |
| 218223 | 2020-12-01 | $233.96 | Ground Home Delivery | 1 | 21.00 lbs | $40.77 | $35.23 | $5.54 |
| 218225 | 2020-12-01 | $24.18 | First-Class Package Service | 4 | 0.40 lbs | $5.02 | $3.77 | $1.25 |
| 218226 | 2020-12-01 | $66.17 | Priority Mail 3-Day | 26 | 5.12 lbs | $15.43 | $11.04 | $4.39 |
| 218227 | 2020-12-01 | $73.70 | Priority Mail 2-Day | 1 | 3.95 lbs | $19.71 | $18.46 | $1.25 |
| 218228 | 2020-12-01 | $36.35 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.30 lbs | $8.40 | $8.05 | $0.35 |
| 218231 | 2020-12-01 | $60.51 | Priority Mail 3-Day | 8 | 0.78 lbs | $9.09 | $7.75 | $1.34 |
| 218232 | 2020-12-01 | $37.69 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.10 lbs | $8.90 | $7.90 | $1.00 |
| 218233 | 2020-12-02 | $18.06 | USPSFirstClass | 4 | 0.76 lbs | $9.70 | $4.71 | $4.99 |
| 218235 | 2020-12-01 | $11.26 | First-Class Package Service | 1 | 0.30 lbs | $4.37 | $3.92 | $0.45 |
| 218237 | 2020-12-02 | $35.84 | Direct Link International | 4 | 0.23 lbs | $19.38 | $8.27 | $11.11 |
| 218239 | 2020-12-02 | $35.13 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.25 lbs | $8.90 | $8.05 | $0.85 |
| 218240 | 2020-12-02 | $8.36 | First-Class Package Service | 2 | 0.40 lbs | $4.58 | $3.56 | $1.02 |
| 218241 | 2020-12-02 | $6.66 | USPSFirstClass | 1 | 0.01 lbs | $4.17 | $3.30 | $0.87 |
| 218242 | 2020-12-02 | $100.68 | Priority Mail 3-Day Padded Flat Rate Envelope | 4 | 3.40 lbs | $9.00 | $8.05 | $0.95 |
| 218246 | 2020-09-18 | $28.15 | Priority Mail 3-Day | 5 | 0.88 lbs | $8.00 | $10.93 | $-2.93 |
| 218247 | 2020-12-02 | $9.18 | USPSFirstClass | 1 | 0.03 lbs | $4.29 | $3.30 | $0.99 |
| 218249 | 2020-12-02 | $38.69 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.30 lbs | $8.90 | $7.90 | $1.00 |
| 218250 | 2020-12-02 | $223.31 | Ground Home Delivery | 1 | 21.00 lbs | $30.12 | $24.85 | $5.27 |
| 218251 | 2020-12-02 | $56.88 | Priority Mail 3-Day Flat Rate Envelope | 2 | 1.36 lbs | $8.40 | $9.16 | $-0.76 |
| 218252 | 2020-12-02 | $57.80 | Priority Mail 2-Day | 1 | 1.60 lbs | $12.11 | $7.90 | $4.21 |
| 218253 | 2020-12-03 | $22.63 | USPSFirstClass | 2 | 0.10 lbs | $4.65 | $3.92 | $0.73 |
| 218256 | 2020-12-03 | $60.96 | USPSFirstClass | 6 | 2.31 lbs | $26.22 | $12.55 | $13.67 |
| 218258 | 2020-12-02 | $143.50 | Ground | 5 | 6.30 lbs | $29.85 | $21.36 | $8.49 |
| 218260 | 2020-12-03 | $8.47 | USPSFirstClass | 1 | 0.10 lbs | $4.12 | $3.03 | $1.09 |
| 218263 | 2020-12-03 | $87.61 | Direct Link International | 3 | 2.22 lbs | $37.34 | $8.72 | $28.62 |
| 218264 | 2020-12-03 | $35.13 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.10 lbs | $8.90 | $8.05 | $0.85 |
| 218270 | 2020-12-03 | $39.58 | Priority Mail 3-Day | 2 | 0.60 lbs | $8.00 | $7.90 | $0.10 |
| 218271 | 2020-12-03 | $18.36 | First-Class Package Service | 2 | 0.40 lbs | $4.58 | $5.52 | $-0.94 |
| 218273 | 2020-11-27 | $94.06 | Priority Mail 2-Day | 2 | 2.35 lbs | $10.24 | $8.88 | $1.36 |
| 218274 | 2020-12-03 | $8.87 | USPSFirstClass | 1 | 0.45 lbs | $5.18 | $3.92 | $1.26 |
| 218277 | 2020-12-03 | $16.04 | First-Class Mail Stamped Letter | 1 | 0.15 lbs | $3.25 | $3.30 | $-0.05 |
| 218282 | 2020-12-03 | $64.63 | Priority Mail 2-Day | 1 | 3.95 lbs | $10.64 | $9.53 | $1.11 |
| 218283 | 2020-12-03 | $46.61 | First-Class Package Service | 9 | 0.84 lbs | $6.40 | $5.98 | $0.42 |
| 218285 | 2020-12-03 | $35.23 | Priority Mail 3-Day Padded Flat Rate Envelope | 1 | 1.40 lbs | $9.00 | $8.05 | $0.95 |
| 218287 | 2020-12-03 | $43.29 | Next Day Air Saver | 2 | 0.12 lbs | $35.18 | $29.10 | $6.08 |
| 218288 | 2020-12-03 | $5.51 | USPSFirstClass | 1 | 0.03 lbs | $4.02 | $3.09 | $0.93 |
| 218290 | 2020-12-03 | $35.89 | First-Class Package Service | 1 | 0.75 lbs | $5.90 | $5.65 | $0.25 |
| 218291 | 2020-12-03 | $38.69 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.40 lbs | $8.90 | $8.05 | $0.85 |
| 218293 | 2020-12-03 | $274.98 | Priority Mail 3-Day | 1 | 27.75 lbs | $36.99 | $36.14 | $0.85 |
| 218294 | 2020-12-03 | $149.04 | Priority Mail 3-Day Large Flat Rate Box | 7 | 5.49 lbs | $19.55 | $18.70 | $0.85 |
| 218295 | 2020-12-03 | $38.69 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.25 lbs | $8.90 | $8.05 | $0.85 |
| 218296 | 2020-12-04 | $11.08 | USPSFirstClass | 1 | 0.39 lbs | $5.29 | $3.92 | $1.37 |
| 218297 | 2020-12-03 | $27.39 | First-Class Package Service | 1 | 0.50 lbs | $5.90 | $5.65 | $0.25 |
| 218301 | 2020-12-03 | $212.02 | Priority Mail 3-Day | 1 | 14.90 lbs | $22.03 | $22.17 | $-0.14 |
| 218302 | 2020-12-03 | $16.42 | First-Class Mail Stamped Letter | 3 | 0.15 lbs | $3.25 | $3.18 | $0.07 |
| 218303 | 2020-12-03 | $14.94 | First-Class Package Service | 1 | 0.35 lbs | $3.95 | $3.50 | $0.45 |
| 218304 | 2020-12-03 | $90.58 | Priority Mail 3-Day | 5 | 2.42 lbs | $10.79 | $9.93 | $0.86 |
| 218305 | 2020-12-04 | $7.61 | USPSFirstClass | 1 | 0.02 lbs | $4.12 | $3.09 | $1.03 |
| 218306 | 2020-12-04 | $62.24 | USPSFirstClass | 8 | 3.60 lbs | $32.72 | $9.47 | $23.25 |
| 218307 | 2020-12-03 | $38.69 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.25 lbs | $8.90 | $8.05 | $0.85 |
| 218308 | 2020-12-03 | $23.96 | First-Class Package Service | 5 | 0.34 lbs | $4.01 | $3.56 | $0.45 |
| 218309 | 2020-12-03 | $34.36 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.10 lbs | $8.90 | $8.05 | $0.85 |
| 218312 | 2020-12-04 | $23.93 | USPSPriority | 1 | 1.10 lbs | $14.14 | $10.93 | $3.21 |
| 218315 | 2020-12-04 | $7.08 | First-Class Package Service | 1 | 0.19 lbs | $4.09 | $3.18 | $0.91 |
| 218322 | 2020-12-04 | $7.61 | USPSFirstClass | 1 | 0.03 lbs | $4.12 | $3.09 | $1.03 |
| 218323 | 2020-12-04 | $67.98 | Priority Mail 3-Day Flat Rate Envelope | 2 | 2.60 lbs | $8.40 | $16.00 | $-7.60 |
| 218324 | 2020-12-04 | $110.53 | Priority Mail 3-Day Padded Flat Rate Envelope | 3 | 3.04 lbs | $17.40 | $8.15 | $9.25 |
| 218325 | 2020-12-03 | $66.31 | Priority Mail 3-Day Flat Rate Envelope | 9 | 1.85 lbs | $13.08 | $8.15 | $4.93 |
| 218327 | 2020-12-04 | $34.36 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.10 lbs | $8.90 | $8.05 | $0.85 |
| 218345 | 2020-12-04 | $51.89 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.50 lbs | $8.90 | $8.05 | $0.85 |
| 218347 | 2020-12-04 | $61.98 | Priority Mail 2-Day Padded Flat Rate Envelope | 2 | 1.40 lbs | $9.00 | $8.05 | $0.95 |
| 218349 | 2020-12-04 | $4.09 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $3.10 | $3.18 | $-0.08 |
| 218353 | 2020-12-04 | $22.56 | First-Class Package Service | 3 | 0.23 lbs | $4.09 | $4.43 | $-0.34 |
| 218356 | 2020-12-04 | $27.26 | First-Class Package Service | 1 | 0.50 lbs | $5.77 | $5.52 | $0.25 |
| 218361 | 2020-12-04 | $89.97 | Priority Mail 2-Day Padded Flat Rate Envelope | 3 | 2.40 lbs | $9.00 | $8.05 | $0.95 |
| 218363 | 2020-12-04 | $18.94 | First-Class Package Service | 1 | 0.19 lbs | $3.95 | $3.50 | $0.45 |
| 218364 | 2020-12-04 | $26.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.85 lbs | $8.40 | $8.00 | $0.40 |
| 218365 | 2020-12-05 | $19.21 | USPSFirstClass | 1 | 0.04 lbs | $4.72 | $3.18 | $1.54 |
| 218366 | 2020-12-04 | $36.19 | First-Class Package Service | 1 | 0.75 lbs | $6.20 | $5.95 | $0.25 |
| 218367 | 2020-12-04 | $27.97 | First-Class Package Service | 8 | 0.69 lbs | $6.04 | $5.79 | $0.25 |
| Total | 21025 order(s) | 59971 | 29292.14 lbs | $193562.51 | $270247.54 | $-76685.03 |