Checkout problem: not processing more than one product

**mc5000** · 03-13-2007, 01:19 AM

Hi,

I have a checkout problem. I am using OSCMAX v.2.0.

The problem only happens when ordering more than one product. On checkout_confirmation.php if I order 2 products they both show. But once the confirm order button is pushed and the page changes to checkout_success.php only the first product is shown under the text "Please notify me of updates to the products I have selected below". The order email sent to the customer looks as below, showing one product but charging for both.

Products
------------------------------------------------------
1 x First Clothing Set (FSH044) = £29.97
------------------------------------------------------
Sub-Total: £44.96
Total: £44.96

Billing Address
------------------------------------------------------
tttttttttttt ttttttttttttttttttttttt
fdfffffffffff
fffffffffffffffff, ffffffffff
ffffffffffffffffffffffff, United Kingdom

Payment Method
------------------------------------------------------
Credit Card

Also in the table orders_products only one product entry is shown for the order. I have traced the problem (I think) to this part of the code in checkout_process.php. (see below) (Also think it could be the function tep_db_perform) It seems that the array is only being looped through for the first product. At this point I am stuck. Any ideas? Thanks in advance.

// BOF: MOD - QT Pro
if (!isset($products_stock_attributes)) $products_stock_attributes=null;

$sql_data_array = array('orders_id' => $insert_id,
'products_id' => tep_get_prid($order->products[$i]['id']),
'products_model' => $order->products[$i]['model'],
'products_name' => $order->products[$i]['name'],
'products_price' => $order->products[$i]['price'],
'final_price' => $order->products[$i]['final_price'],
'products_tax' => $order->products[$i]['tax'],
'products_quantity' => $order->products[$i]['qty'],//);
'products_stock_attributes' => $products_stock_attributes);
// EOF: MOD - QT Pro
tep_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array);
$order_products_id = tep_db_insert_id();