Okay Quick question I have been searching all over for it,
I created a custom product field, I need this product field to be shown on the Order Info Page. Any idea how I do it?
I got an idea but I am not to sure if it will work, under the model/account/order.php,
If I use the Public Function G, and edit it to search for the where Order Product ID and Product ID's from the Product Database and retrieve all product fields that I have made will it work?
If possible I am doing the code a bit, but if someone can guide me on it, it will help me.
Here is what I coded please can you tell me whether it is fine
Code: Select all
public function getOrderProductsall($order_id) {
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_product op LEFT JOIN " . DB_PREFIX . "product p ON (op.product_id = p.product_id) WHERE order_id = '" . (int)$order_id . "'");
