How to add manufacturer name to the 'Shopping Cart' table
Posted: Mon Jul 06, 2020 4:32 pm
I need to add Manufucaturer name instead the product-model to the Shopping Cart table in 'view Cart' page.
I believe we need to add the manufacturer name to the 'order_product' table as the first step.
I have added this code to catalog/model/checkout/order
But it was not saved to the DB.
I believe we need to add the manufacturer name to the 'order_product' table as the first step.
I have added this code to catalog/model/checkout/order
Code: Select all
$this->db->query("INSERT INTO " . DB_PREFIX . "order_product SET order_id = '" . (int)$order_id . "', product_id = '" . (int)$product['product_id'] . "', name = '" . $this->db->escape($product['name']) . "', model = '" . $this->db->escape($product['model']) . "', manufacturer = '" . $this->db->escape($product['manufacturer']) . "', quantity = '" . (int)$product['quantity'] . "', price = '" . (float)$product['price'] . "', total = '" . (float)$product['total'] . "', tax = '" . (float)$product['tax'] . "', reward = '" . (int)$product['reward'] . "'");