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 |
|---|---|---|---|---|---|---|---|---|
| 210075 | 2020-03-02 | $15.46 | First-Class Mail Stamped Letter | 4 | 0.12 lbs | $3.50 | $3.05 | $0.45 |
| 210076 | 2020-03-02 | $13.48 | First-Class Mail Stamped Letter | 2 | 0.12 lbs | $3.50 | $3.31 | $0.19 |
| 210077 | 2020-03-02 | $23.96 | Priority Mail 2-Day Flat Rate Envelope | 4 | 0.10 lbs | $8.00 | $7.65 | $0.35 |
| 210078 | 2020-03-02 | $14.57 | Priority Mail 3-Day Flat Rate Envelope | 3 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 210080 | 2020-03-02 | $20.73 | First-Class Package Service | 5 | 0.47 lbs | $4.63 | $4.18 | $0.45 |
| 210081 | 2019-11-25 | $116.36 | Flat Shipping Rate | 2 | 3.05 lbs | $11.48 | $14.16 | $-2.68 |
| 210083 | 2020-02-07 | $309.56 | Priority Mail 2-Day Large Flat Rate Box | 18 | 8.42 lbs | $58.23 | $30.03 | $28.20 |
| 210087 | 2020-03-02 | $20.91 | First-Class Package Service | 1 | 0.60 lbs | $4.25 | $4.00 | $0.25 |
| 210091 | 2020-03-03 | $6.32 | First-Class Mail Stamped Letter | 3 | 0.03 lbs | $3.35 | $2.78 | $0.57 |
| 210095 | 2020-03-03 | $41.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.00 lbs | $8.50 | $7.65 | $0.85 |
| 210096 | 2020-03-03 | $41.44 | Priority Mail International Flat Rate Envelope | 1 | 0.05 lbs | $36.45 | $36.65 | $-0.20 |
| 210097 | 2020-03-03 | $29.44 | First-Class Package Service | 13 | 0.82 lbs | $5.57 | $5.12 | $0.45 |
| 210098 | 2020-03-03 | $21.19 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.80 lbs | $8.00 | $7.75 | $0.25 |
| 210100 | 2020-03-03 | $42.12 | Priority Mail 3-Day | 2 | 1.13 lbs | $10.84 | $9.99 | $0.85 |
| 210102 | 2020-03-03 | $15.98 | Priority Mail 3-Day Flat Rate Envelope | 2 | 0.38 lbs | $8.00 | $7.65 | $0.35 |
| 210104 | 2020-03-03 | $12.84 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.93 | $0.42 |
| 210105 | 2020-03-03 | $35.04 | First-Class Package Service | 3 | 0.45 lbs | $4.77 | $3.52 | $1.25 |
| 210107 | 2020-03-04 | $72.58 | Priority Mail 3-Day Padded Flat Rate Envelope | 2 | 1.70 lbs | $8.60 | $7.65 | $0.95 |
| 210109 | 2020-03-04 | $35.19 | Priority Mail 3-Day | 5 | 1.14 lbs | $10.84 | $7.98 | $2.86 |
| 210110 | 2020-03-04 | $37.70 | Priority Mail 3-Day | 2 | 3.15 lbs | $9.30 | $8.44 | $0.86 |
| 210111 | 2020-03-04 | $132.35 | Priority Mail 3-Day | 11 | 3.76 lbs | $10.24 | $9.39 | $0.85 |
| 210113 | 2020-02-03 | $23.99 | Priority Mail 2-Day | 4 | 3.47 lbs | $0.00 | $7.75 | $-7.75 |
| 210114 | 2020-03-04 | $42.99 | Priority Mail 3-Day Flat Rate Envelope | 1 | 1.40 lbs | $8.00 | $7.65 | $0.35 |
| 210117 | 2020-03-04 | $10.34 | First-Class Mail Stamped Letter | 1 | 0.06 lbs | $3.35 | $3.05 | $0.30 |
| 210118 | 2020-03-04 | $60.87 | Priority Mail 2-Day Small Flat Rate Box | 3 | 1.75 lbs | $8.50 | $7.65 | $0.85 |
| 210119 | 2020-03-04 | $13.94 | Priority Mail 3-Day Flat Rate Envelope | 6 | 0.58 lbs | $8.00 | $7.15 | $0.85 |
| 210126 | 2020-03-04 | $404.52 | Priority Mail 3-Day Large Flat Rate Box | 14 | 43.00 lbs | $19.15 | $13.20 | $5.95 |
| 210127 | 2020-03-04 | $36.18 | Priority Mail 2-Day Small Flat Rate Box | 2 | 0.70 lbs | $8.50 | $7.65 | $0.85 |
| 210129 | 2020-03-05 | $10.64 | First-Class Mail Stamped Letter | 1 | 0.19 lbs | $3.65 | $2.78 | $0.87 |
| 210130 | 2020-03-05 | $64.77 | Priority Mail 2-Day | 1 | 3.90 lbs | $16.99 | $16.14 | $0.85 |
| 210131 | 2020-03-05 | $47.89 | Priority Mail 2-Day | 2 | 0.97 lbs | $9.61 | $9.54 | $0.07 |
| 210135 | 2020-03-05 | $27.37 | First-Class Package Service | 18 | 0.69 lbs | $5.52 | $4.08 | $1.44 |
| 210136 | 2020-03-05 | $12.14 | First-Class Mail Stamped Letter | 1 | 0.18 lbs | $3.65 | $3.31 | $0.34 |
| 210137 | 2020-03-06 | $21.19 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.80 lbs | $8.00 | $7.75 | $0.25 |
| 210139 | 2020-03-06 | $112.64 | Priority Mail 3-Day | 7 | 3.21 lbs | $9.92 | $8.21 | $1.71 |
| 210142 | 2020-03-06 | $100.46 | Priority Mail 3-Day | 8 | 5.91 lbs | $16.74 | $15.89 | $0.85 |
| 210143 | 2020-03-06 | $46.42 | Priority Mail 2-Day | 13 | 3.75 lbs | $15.35 | $9.07 | $6.28 |
| 210144 | 2020-03-06 | $27.45 | First-Class Mail Stamped Letter | 1 | 0.15 lbs | $3.50 | $3.39 | $0.11 |
| 210146 | 2020-03-07 | $12.96 | Priority Mail 3-Day Flat Rate Envelope | 4 | 0.22 lbs | $8.00 | $7.75 | $0.25 |
| 210147 | 2020-03-07 | $8.54 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.35 | $2.74 | $0.61 |
| 210150 | 2020-03-07 | $19.97 | Priority Mail 2-Day Flat Rate Envelope | 3 | 0.24 lbs | $8.00 | $7.15 | $0.85 |
| 210152 | 2020-03-07 | $40.86 | Priority Mail 3-Day | 3 | 1.00 lbs | $11.39 | $10.53 | $0.86 |
| 210153 | 2020-03-07 | $13.64 | First-Class Package Service | 1 | 0.65 lbs | $5.65 | $5.40 | $0.25 |
| 210154 | 2020-03-07 | $35.78 | Priority Mail 2-Day Flat Rate Envelope | 2 | 0.71 lbs | $8.00 | $7.65 | $0.35 |
| 210155 | 2020-03-07 | $35.76 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.25 lbs | $8.50 | $7.65 | $0.85 |
| 210156 | 2020-03-08 | $12.28 | First-Class Mail Stamped Letter | 2 | 0.10 lbs | $3.50 | $2.78 | $0.72 |
| 210157 | 2020-03-08 | $44.70 | Priority Mail 3-Day | 2 | 1.50 lbs | $10.84 | $9.99 | $0.85 |
| 210158 | 2020-03-08 | $9.27 | First-Class Package Service | 3 | 0.29 lbs | $3.50 | $3.25 | $0.25 |
| 210159 | 2020-03-08 | $31.76 | Priority Mail 2-Day | 8 | 1.11 lbs | $10.84 | $9.98 | $0.86 |
| 210160 | 2020-03-08 | $69.53 | Priority Mail 2-Day Medium Flat Rate Box | 2 | 2.05 lbs | $14.45 | $12.10 | $2.35 |
| 210167 | 2020-03-08 | $5.83 | First-Class Mail Stamped Letter | 2 | 0.08 lbs | $3.35 | $3.18 | $0.17 |
| 210168 | 2020-03-08 | $23.24 | Priority Mail 2-Day | 2 | 1.43 lbs | $10.39 | $24.18 | $-13.79 |
| 210169 | 2020-03-08 | $11.23 | First-Class Package Service | 3 | 0.23 lbs | $3.76 | $3.31 | $0.45 |
| 210171 | 2020-03-09 | $9.33 | First-Class Mail Stamped Letter | 2 | 0.07 lbs | $3.35 | $2.84 | $0.51 |
| 210172 | 2020-03-09 | $3.84 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $0.00 | $2.84 | $-2.84 |
| 210174 | 2020-03-09 | $56.29 | Priority Mail 2-Day Small Flat Rate Box | 22 | 0.35 lbs | $8.50 | $7.65 | $0.85 |
| 210175 | 2020-03-09 | $93.50 | Priority Mail 2-Day | 2 | 3.60 lbs | $9.92 | $9.39 | $0.53 |
| 210176 | 2020-03-09 | $15.32 | First-Class Package Service | 1 | 0.50 lbs | $4.33 | $4.08 | $0.25 |
| 210177 | 2020-03-09 | $25.29 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.45 lbs | $8.50 | $7.65 | $0.85 |
| 210179 | 2020-03-09 | $89.33 | Priority Mail 2-Day | 6 | 2.65 lbs | $10.39 | $8.92 | $1.47 |
| 210181 | 2020-03-09 | $13.81 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.20 | $2.78 | $0.42 |
| 210182 | 2020-03-09 | $23.57 | Priority Mail 2-Day Flat Rate Envelope | 3 | 0.20 lbs | $8.00 | $7.15 | $0.85 |
| 210183 | 2020-03-09 | $28.30 | Priority Mail 3-Day | 10 | 2.06 lbs | $13.00 | $9.99 | $3.01 |
| 210185 | 2020-03-10 | $91.40 | Priority Mail 3-Day | 11 | 3.33 lbs | $16.91 | $16.06 | $0.85 |
| 210188 | 2020-03-10 | $18.99 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 210190 | 2020-03-10 | $25.03 | First-Class Package Service | 2 | 0.40 lbs | $4.45 | $4.00 | $0.45 |
| 210191 | 2020-03-10 | $28.46 | Priority Mail 2-Day Flat Rate Envelope | 4 | 0.16 lbs | $8.00 | $7.65 | $0.35 |
| 210193 | 2020-03-10 | $38.29 | Priority Mail 3-Day Small Flat Rate Box | 1 | 1.25 lbs | $8.50 | $7.65 | $0.85 |
| 210195 | 2020-03-10 | $8.99 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $76.25 | $2.84 | $73.41 |
| 210197 | 2020-03-10 | $95.86 | Priority Mail 3-Day | 5 | 3.90 lbs | $19.31 | $18.46 | $0.85 |
| 210198 | 2020-03-11 | $6.98 | First-Class Mail Stamped Letter | 2 | 0.02 lbs | $3.20 | $2.93 | $0.27 |
| 210200 | 2020-03-11 | $34.02 | Priority Mail 3-Day | 2 | 1.00 lbs | $12.04 | $11.18 | $0.86 |
| 210201 | 2020-03-11 | $9.08 | First-Class Mail Stamped Letter | 2 | 0.12 lbs | $3.50 | $3.05 | $0.45 |
| 210203 | 2020-03-11 | $19.79 | Priority Mail 2-Day Flat Rate Envelope | 1 | 0.30 lbs | $8.00 | $7.65 | $0.35 |
| 210205 | 2020-03-11 | $55.78 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.45 lbs | $8.00 | $7.65 | $0.35 |
| 210206 | 2020-03-11 | $4.18 | First-Class Mail Stamped Letter | 2 | 0.02 lbs | $3.20 | $2.84 | $0.36 |
| 210207 | 2020-03-11 | $49.87 | Priority Mail 2-Day Flat Rate Envelope | 11 | 1.23 lbs | $8.00 | $7.65 | $0.35 |
| 210208 | 2020-03-11 | $34.38 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.60 lbs | $8.00 | $7.75 | $0.25 |
| 210211 | 2020-03-11 | $50.08 | Priority Mail 3-Day Flat Rate Envelope | 4 | 2.12 lbs | $8.00 | $7.75 | $0.25 |
| 210214 | 2020-03-11 | $16.42 | First-Class Package Service | 1 | 0.55 lbs | $4.63 | $4.18 | $0.45 |
| 210215 | 2020-03-12 | $176.24 | Priority Mail International | 1 | 3.00 lbs | $76.25 | $75.53 | $0.72 |
| 210216 | 2020-03-12 | $36.22 | Ground | 1 | 0.65 lbs | $4.70 | $14.43 | $-9.73 |
| 210217 | 2020-03-12 | $12.99 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.20 lbs | $8.00 | $7.65 | $0.35 |
| 210219 | 2020-03-12 | $10.33 | First-Class Mail Stamped Letter | 2 | 0.10 lbs | $3.35 | $3.05 | $0.30 |
| 210220 | 2020-03-12 | $9.47 | First-Class Mail Stamped Letter | 3 | 0.09 lbs | $3.50 | $2.93 | $0.57 |
| 210223 | 2020-03-13 | $290.36 | Priority Mail 2-Day | 3 | 15.85 lbs | $51.45 | $48.22 | $3.23 |
| 210225 | 2020-03-13 | $7.89 | First-Class Mail Stamped Letter | 1 | 0.10 lbs | $3.50 | $2.93 | $0.57 |
| 210226 | 2020-03-13 | $32.45 | Priority Mail 2-Day Small Flat Rate Box | 1 | 0.15 lbs | $8.50 | $7.65 | $0.85 |
| 210228 | 2020-03-14 | $5.33 | First-Class Mail Stamped Letter | 2 | 0.04 lbs | $3.35 | $3.25 | $0.10 |
| 210229 | 2020-03-14 | $33.40 | Priority Mail 2-Day Flat Rate Envelope | 10 | 0.45 lbs | $8.00 | $7.15 | $0.85 |
| 210230 | 2020-03-14 | $47.62 | Priority Mail 2-Day | 2 | 0.94 lbs | $10.84 | $9.99 | $0.85 |
| 210232 | 2020-03-14 | $4.19 | First-Class Mail Stamped Letter | 1 | 0.01 lbs | $3.20 | $3.18 | $0.02 |
| 210233 | 2020-03-14 | $76.14 | Priority Mail 3-Day Flat Rate Envelope | 6 | 1.20 lbs | $8.00 | $7.65 | $0.35 |
| 210234 | 2020-03-14 | $33.14 | Priority Mail 2-Day Flat Rate Envelope | 6 | 0.78 lbs | $8.00 | $7.65 | $0.35 |
| 210235 | 2020-03-14 | $4.69 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.20 | $2.93 | $0.27 |
| 210236 | 2020-03-14 | $8.54 | First-Class Mail Stamped Letter | 1 | 0.07 lbs | $3.35 | $2.78 | $0.57 |
| 210237 | 2020-03-14 | $51.77 | Priority Mail 2-Day Flat Rate Envelope | 3 | 1.53 lbs | $8.00 | $7.65 | $0.35 |
| 210238 | 2020-03-14 | $10.95 | First-Class Mail Stamped Letter | 5 | 0.25 lbs | $3.50 | $2.78 | $0.72 |
| 210239 | 2020-03-15 | $19.53 | First-Class Package Service | 6 | 0.60 lbs | $5.79 | $4.32 | $1.47 |
| 210240 | 2020-03-15 | $8.95 | First-Class Package Service | 2 | 0.40 lbs | $4.77 | $3.52 | $1.25 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |