Every product in my store has purchase price. I want to save the value of this field in the database table 'order_product' when order is confirmed.
So I did this steps:
[*] Altered table 'order_product' to add column
[*] changed /catalog/model/checkout/order.php:modified SQL query in functions addOrder and editOrder
Code: Select all
INSERT INTO [default code] . "', purchase_price = '" . (float)$product['purchase_price'] . "'"Code: Select all
$order_data['products'][] = array(
'product_id' => $product['product_id'],
'name' => $product['name'],
'model' => $product['model'],
'option' => $option_data,
'download' => $product['download'],
'quantity' => $product['quantity'],
'subtract' => $product['subtract'],
'price' => $product['price'],
'total' => $product['total'],
'tax' => $this->tax->getTax($product['price'], $product['tax_class_id']),
'reward' => $product['reward'],
'purchase_price' => $product['purchase_price']
);What am I doing wrong?
