I have recent received 2 (out of many) orders that are missing shipping charge. They are from different customers about a week apart. This should not be possible as there should be no situation in which the customer is not forced to choose a shipping option.
At least one of the customers has ordered before with shipping correctly charged.
One order (xx188) is listed as "Trans. Type: cart", the other (xx420) "Trans. Type: expresscheckout"
select * from orders_total where orders_id=xx420;
+-----------------+-----------+------------+-----------+---------+-------------+------------+
| orders_total_id | orders_id | title | text | value | class | sort_order |
+-----------------+-----------+------------+-----------+---------+-------------+------------+
| 296553 | xx420 | Sub-Total: | $53.89CDN | 53.8863 | ot_subtotal | 100 |
| 296554 | xx420 | : | $0.00CDN | 0.0000 | ot_shipping | 200 |
| 296555 | xx420 | HST (13%): | $7.01CDN | 7.0052 | ot_tax | 300 |
| 296556 | xx420 | Total: | $60.89CDN | 60.8915 | ot_total | 999 |
+-----------------+-----------+------------+-----------+---------+-------------+------------+
4 rows in set (0.00 sec)
select * from orders_total where orders_id=xx188;
+-----------------+-----------+--------------+-----------+---------+-------------+------------+
| orders_total_id | orders_id | title | text | value | class | sort_order |
+-----------------+-----------+--------------+-----------+---------+-------------+------------+
| 295557 | xx188 | Sub-Total: | $49.07CDN | 49.0748 | ot_subtotal | 100 |
| 295558 | xx188 | : | $0.00CDN | 0.0000 | ot_shipping | 200 |
| 295559 | xx188 | GST (5%): | $2.45CDN | 2.4537 | ot_tax | 300 |
| 295560 | xx188 | BC PST (7%): | $3.44CDN | 3.4352 | ot_tax | 300 |
| 295561 | xx188 | Total: | $54.96CDN | 54.9638 | ot_total | 999 |
+-----------------+-----------+--------------+-----------+---------+-------------+------------+
select * from orders where orders_id=xx188\G
*************************** 1. row ***************************
orders_id: xx188
<snip>
payment_method: PayPal
payment_module_code: paypalwpp
shipping_method:
shipping_module_code:
coupon_code:
cc_type:
cc_owner:
cc_number:
<snip>
orders_status: 3
orders_date_finished: NULL
currency: CAD
currency_value: 1.000000
order_total: 54.96
order_tax: 5.89
paypal_ipn_id: 0
select * from orders where orders_id=xx420\G
*************************** 1. row ***************************
orders_id: xx420
<snip>
payment_method: PayPal
payment_module_code: paypalwpp
shipping_method:
shipping_module_code:
coupon_code:
cc_type:
cc_owner:
cc_number:
<snip>
orders_status: 3
orders_date_finished: NULL
currency: CAD
currency_value: 1.000000
order_total: 60.89
order_tax: 7.01
paypal_ipn_id: 0
Bookmarks