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 |
|---|---|---|---|---|---|---|---|---|
| 226043 | 2021-07-04 | $12.68 | First-Class Package Service | 1 | 0.05 lbs | $4.69 | $3.49 | $1.20 |
| 226046 | 2021-07-04 | $40.99 | United States | 1 | 0.65 lbs | $4.50 | $4.53 | $-0.03 |
| 226048 | 2021-07-05 | $6.99 | United States | 1 | 0.20 lbs | $3.50 | $3.58 | $-0.08 |
| 226049 | 2021-07-05 | $12.48 | USPSFirstClass | 1 | 0.04 lbs | $4.69 | $3.35 | $1.34 |
| 226050 | 2021-07-05 | $12.43 | USPSFirstClass | 1 | 0.04 lbs | $4.64 | $3.22 | $1.42 |
| 226051 | 2021-07-05 | $21.78 | USPSFirstClass | 1 | 0.05 lbs | $4.99 | $3.06 | $1.93 |
| 226052 | 2021-07-05 | $22.34 | First-Class Package Service | 2 | 0.64 lbs | $6.76 | $5.81 | $0.95 |
| 226055 | 2021-07-05 | $9.39 | USPSFirstClass | 1 | 0.20 lbs | $4.40 | $3.51 | $0.89 |
| 226056 | 2021-07-05 | $9.38 | USPSFirstClass | 1 | 0.04 lbs | $4.49 | $3.22 | $1.27 |
| 226058 | 2021-07-05 | $40.84 | Priority Mail 3-Day Flat Rate Envelope | 1 | 1.30 lbs | $7.95 | $7.90 | $0.05 |
| 226060 | 2021-07-05 | $58.34 | Ground | 4 | 3.01 lbs | $26.91 | $18.92 | $7.99 |
| 226063 | 2021-07-06 | $41.54 | United States | 1 | 1.40 lbs | $8.75 | $7.90 | $0.85 |
| 226064 | 2021-07-06 | $29.48 | FedExHomeDelivery | 1 | 0.05 lbs | $12.69 | $15.51 | $-2.82 |
| 226065 | 2021-07-06 | $9.54 | USPSFirstClass | 1 | 0.06 lbs | $4.55 | $3.35 | $1.20 |
| 226066 | 2021-07-06 | $17.94 | USPSFirstClass | 1 | 0.05 lbs | $4.95 | $3.35 | $1.60 |
| 226067 | 2021-07-06 | $13.48 | USPSFirstClass | 1 | 0.05 lbs | $4.69 | $3.22 | $1.47 |
| 226068 | 2021-07-06 | $23.08 | USPSFirstClass | 3 | 0.20 lbs | $8.81 | $3.51 | $5.30 |
| 226069 | 2021-07-06 | $26.94 | USPSFirstClass | 1 | 0.63 lbs | $6.95 | $3.49 | $3.46 |
| 226070 | 2021-07-06 | $10.75 | USPSFirstClass | 1 | 0.08 lbs | $4.46 | $3.06 | $1.40 |
| 226071 | 2021-07-06 | $19.84 | Priority Mail 2-Day Flat Rate Envelope | 6 | 0.70 lbs | $8.50 | $7.90 | $0.60 |
| 226072 | 2021-07-06 | $7.89 | USPSFirstClass | 1 | 0.06 lbs | $0.00 | $3.06 | $-3.06 |
| 226074 | 2021-07-06 | $6.49 | United States | 1 | 0.05 lbs | $3.50 | $3.49 | $0.01 |
| 226077 | 2021-07-06 | $24.34 | Priority Mail 2-Day | 1 | 0.35 lbs | $8.25 | $7.90 | $0.35 |
| 226079 | 2021-07-06 | $42.15 | Priority Mail 3-Day | 1 | 0.25 lbs | $8.25 | $7.67 | $0.58 |
| 226082 | 2021-07-07 | $25.43 | Priority Mail 2-Day Flat Rate Envelope | 2 | 1.55 lbs | $7.95 | $8.00 | $-0.05 |
| 226083 | 2021-07-07 | $206.44 | Ground Home Delivery | 1 | 9.20 lbs | $34.93 | $28.82 | $6.11 |
| 226084 | 2021-07-07 | $42.44 | USPSFirstClass | 1 | 0.55 lbs | $7.45 | $5.66 | $1.79 |
| 226085 | 2021-07-07 | $25.68 | First-Class Package Service | 5 | 0.55 lbs | $5.73 | $4.53 | $1.20 |
| 226086 | 2021-07-07 | $22.51 | First-Class Package Service | 2 | 0.68 lbs | $6.93 | $5.98 | $0.95 |
| 226087 | 2021-07-07 | $11.49 | USPSFirstClass | 1 | 0.06 lbs | $4.50 | $3.06 | $1.44 |
| 226090 | 2021-07-07 | $52.43 | United States | 4 | 1.83 lbs | $9.25 | $8.72 | $0.53 |
| 226091 | 2021-07-07 | $7.72 | United States | 3 | 0.04 lbs | $3.75 | $3.12 | $0.63 |
| 226093 | 2021-07-07 | $26.99 | United States | 1 | 0.35 lbs | $4.00 | $3.58 | $0.42 |
| 226094 | 2021-07-07 | $14.94 | First-Class Package Service | 2 | 0.21 lbs | $4.46 | $3.51 | $0.95 |
| 226095 | 2021-07-07 | $17.72 | First-Class Package Service | 8 | 0.16 lbs | $4.80 | $7.70 | $-2.90 |
| 226096 | 2021-07-08 | $17.68 | First-Class Package Service | 1 | 0.30 lbs | $4.66 | $3.46 | $1.20 |
| 226098 | 2021-07-08 | $8.44 | USPSFirstClass | 1 | 0.15 lbs | $4.45 | $3.22 | $1.23 |
| 226099 | 2021-07-08 | $11.21 | USPSFirstClass | 1 | 0.20 lbs | $4.77 | $3.85 | $0.92 |
| 226100 | 2021-07-08 | $104.54 | USPSPriority | 1 | 7.20 lbs | $36.55 | $25.52 | $11.03 |
| 226103 | 2021-07-08 | $27.47 | First-Class Package Service | 4 | 0.25 lbs | $4.71 | $3.51 | $1.20 |
| 226105 | 2021-07-08 | $24.80 | United States | 2 | 0.87 lbs | $5.19 | $5.98 | $-0.79 |
| 226106 | 2021-07-08 | $19.99 | United States | 1 | 0.95 lbs | $8.50 | $7.67 | $0.83 |
| 226107 | 2021-07-09 | $19.72 | USPSFirstClass | 1 | 0.04 lbs | $5.18 | $3.49 | $1.69 |
| 226109 | 2021-07-08 | $42.21 | Priority Mail 2-Day | 4 | 0.95 lbs | $8.25 | $8.24 | $0.01 |
| 226113 | 2021-07-09 | $29.99 | Priority Mail 3-Day Flat Rate Envelope | 1 | 0.90 lbs | $8.50 | $8.00 | $0.50 |
| 226114 | 2021-07-09 | $35.30 | USPSFirstClass | 3 | 1.02 lbs | $11.93 | $8.00 | $3.93 |
| 226115 | 2021-07-09 | $10.91 | USPSFirstClass | 1 | 0.20 lbs | $4.47 | $3.06 | $1.41 |
| 226116 | 2021-07-09 | $18.78 | USPSFirstClass | 1 | 0.81 lbs | $6.99 | $5.27 | $1.72 |
| 226117 | 2021-07-09 | $33.35 | Priority Mail 3-Day Small Flat Rate Box | 1 | 0.85 lbs | $8.45 | $8.00 | $0.45 |
| 226118 | 2021-07-09 | $17.99 | First-Class Mail Stamped Letter | 1 | 0.15 lbs | $4.00 | $3.85 | $0.15 |
| 226119 | 2021-07-09 | $24.03 | Priority Mail 2-Day | 1 | 0.45 lbs | $7.70 | $7.90 | $-0.20 |
| 226121 | 2021-07-09 | $35.02 | First-Class Package Service | 1 | 0.40 lbs | $4.99 | $3.46 | $1.53 |
| 226122 | 2021-07-09 | $296.95 | Priority Mail 2-Day Small Flat Rate Box | 8 | 7.17 lbs | $8.45 | $10.71 | $-2.26 |
| 226124 | 2021-07-10 | $16.27 | USPSFirstClass | 1 | 0.40 lbs | $5.54 | $3.58 | $1.96 |
| 226125 | 2021-07-10 | $26.19 | USPSFirstClass | 1 | 0.45 lbs | $6.20 | $4.68 | $1.52 |
| 226126 | 2021-07-10 | $21.82 | USPSFirstClass | 2 | 0.68 lbs | $6.24 | $5.81 | $0.43 |
| 226127 | 2021-07-09 | $7.79 | First-Class Mail Stamped Letter | 1 | 0.05 lbs | $3.80 | $3.22 | $0.58 |
| 226128 | 2021-07-09 | $23.09 | Priority Mail 2-Day | 1 | 0.29 lbs | $9.10 | $7.90 | $1.20 |
| 226131 | 2021-07-10 | $17.79 | USPSFirstClass | 1 | 0.05 lbs | $4.80 | $3.06 | $1.74 |
| 226132 | 2021-07-10 | $13.16 | USPSFirstClass | 1 | 0.05 lbs | $4.67 | $3.22 | $1.45 |
| 226133 | 2021-07-10 | $9.33 | USPSFirstClass | 1 | 0.03 lbs | $4.44 | $3.12 | $1.32 |
| 226134 | 2021-07-10 | $21.88 | USPSFirstClass | 1 | 0.05 lbs | $5.09 | $3.22 | $1.87 |
| 226139 | 2021-07-10 | $41.62 | Priority Mail 3-Day | 5 | 4.08 lbs | $10.63 | $8.34 | $2.29 |
| 226142 | 2021-07-10 | $282.88 | Ground Home Delivery | 1 | 21.00 lbs | $47.89 | $39.29 | $8.60 |
| 226148 | 2021-07-10 | $11.78 | First-Class Mail Stamped Letter | 2 | 0.10 lbs | $3.80 | $3.22 | $0.58 |
| 226149 | 2021-07-10 | $21.89 | Priority Mail 2-Day | 1 | 0.95 lbs | $9.90 | $11.69 | $-1.79 |
| 226150 | 2021-07-10 | $78.78 | Priority Mail 1-Day | 7 | 2.37 lbs | $9.10 | $8.00 | $1.10 |
| 226151 | 2021-07-10 | $40.79 | Priority Mail 2-Day | 1 | 1.00 lbs | $8.80 | $8.00 | $0.80 |
| 226152 | 2021-07-10 | $185.65 | Priority Mail 2-Day | 9 | 5.45 lbs | $30.03 | $22.18 | $7.85 |
| 226153 | 2021-07-11 | $10.91 | USPSFirstClass | 1 | 0.20 lbs | $4.47 | $3.06 | $1.41 |
| 226154 | 2021-07-11 | $24.09 | USPSFirstClass | 1 | 0.50 lbs | $6.10 | $3.85 | $2.25 |
| 226155 | 2021-07-11 | $8.49 | USPSFirstClass | 1 | 0.05 lbs | $4.50 | $3.35 | $1.15 |
| 226156 | 2021-07-11 | $13.18 | USPSFirstClass | 1 | 0.34 lbs | $5.39 | $3.58 | $1.81 |
| 226157 | 2021-07-11 | $10.80 | USPSFirstClass | 1 | 0.15 lbs | $4.51 | $3.12 | $1.39 |
| 226158 | 2021-07-11 | $12.33 | USPSFirstClass | 1 | 0.04 lbs | $4.54 | $3.06 | $1.48 |
| 226159 | 2021-07-10 | $23.05 | First-Class Package Service | 2 | 0.35 lbs | $4.77 | $4.20 | $0.57 |
| 226163 | 2021-07-11 | $72.48 | Priority Mail 2-Day | 2 | 0.62 lbs | $8.50 | $7.88 | $0.62 |
| 226164 | 2021-07-11 | $9.69 | USPSFirstClass | 1 | 0.07 lbs | $4.70 | $3.49 | $1.21 |
| 226165 | 2021-07-11 | $9.43 | USPSFirstClass | 1 | 0.03 lbs | $4.54 | $3.35 | $1.19 |
| 226166 | 2021-07-11 | $103.32 | United States | 13 | 3.32 lbs | $10.50 | $19.29 | $-8.79 |
| 226167 | 2021-07-11 | $9.21 | First-Class Package Service | 5 | 0.14 lbs | $4.26 | $3.51 | $0.75 |
| 226168 | 2021-07-11 | $13.79 | First-Class Mail Stamped Letter | 1 | 0.08 lbs | $3.80 | $3.35 | $0.45 |
| 226171 | 2021-07-11 | $28.43 | Priority Mail 2-Day | 7 | 0.10 lbs | $8.50 | $7.90 | $0.60 |
| 226172 | 2021-07-11 | $31.78 | Priority Mail 2-Day | 2 | 0.55 lbs | $8.80 | $7.90 | $0.90 |
| 226173 | 2021-07-11 | $14.79 | Priority Mail 2-Day | 1 | 0.10 lbs | $8.50 | $7.88 | $0.62 |
| 226174 | 2021-07-12 | $8.49 | USPSFirstClass | 1 | 0.03 lbs | $4.50 | $3.35 | $1.15 |
| 226175 | 2021-07-11 | $56.44 | Priority Mail 2-Day Small Flat Rate Box | 1 | 1.70 lbs | $8.45 | $7.90 | $0.55 |
| 226176 | 2021-07-11 | $26.74 | United States | 1 | 0.15 lbs | $3.75 | $3.57 | $0.18 |
| 226177 | 2021-07-11 | $6.24 | United States | 1 | 0.01 lbs | $3.75 | $3.12 | $0.63 |
| 226179 | 2021-07-11 | $29.77 | Ground | 1 | 0.05 lbs | $20.28 | $14.61 | $5.67 |
| 226181 | 2021-07-12 | $22.74 | First-Class Package Service | 2 | 0.68 lbs | $6.76 | $4.53 | $2.23 |
| 226182 | 2021-07-12 | $48.89 | Priority Mail 2-Day | 1 | 1.15 lbs | $13.90 | $7.90 | $6.00 |
| 226183 | 2021-07-12 | $48.26 | Ground | 1 | 0.85 lbs | $23.36 | $15.70 | $7.66 |
| 226184 | 2021-07-12 | $13.17 | USPSFirstClass | 1 | 0.06 lbs | $4.58 | $3.06 | $1.52 |
| 226186 | 2021-07-12 | $8.22 | United States | 3 | 0.26 lbs | $3.75 | $3.49 | $0.26 |
| 226187 | 2021-07-12 | $13.91 | USPSFirstClass | 4 | 0.60 lbs | $5.95 | $5.81 | $0.14 |
| 226189 | 2021-07-13 | $11.64 | USPSFirstClass | 1 | 0.10 lbs | $4.65 | $3.35 | $1.30 |
| 226190 | 2021-07-13 | $14.41 | USPSFirstClass | 1 | 0.10 lbs | $4.92 | $3.49 | $1.43 |
| 226193 | 2021-07-12 | $44.00 | Priority Mail 2-Day | 1 | 1.20 lbs | $13.90 | $7.90 | $6.00 |
| 226194 | 2021-07-12 | $41.24 | Priority Mail 3-Day | 1 | 0.85 lbs | $8.25 | $8.00 | $0.25 |
| Total | 21021 order(s) | 59963 | 29290.36 lbs | $193530.22 | $270216.78 | $-76686.56 |